public.document_type_templates¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| context_mapping | jsonb | true | ||||
| id | bigint | false | ||||
| nationality | varchar(255) | false | ||||
| template_file | varchar(100) | false | ||||
| type | varchar(30) | false |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| document_type_templates_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| unique_document_type_template_per_nationality | UNIQUE | UNIQUE (type, nationality) |
Indexes¶
| Name | Definition |
|---|---|
| document_ty_type_a21f9e_idx | CREATE INDEX document_ty_type_a21f9e_idx ON public.document_type_templates USING btree (type, nationality) |
| document_type_templates_pkey | CREATE UNIQUE INDEX document_type_templates_pkey ON public.document_type_templates USING btree (id) |
| unique_document_type_template_per_nationality | CREATE UNIQUE INDEX unique_document_type_template_per_nationality ON public.document_type_templates USING btree (type, nationality) |
Generated by tbls