public.id_check_documents¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| application_id | bigint | false | public.id_check_applications | |||
| country | varchar(3) | false | ||||
| date_of_birth | date | true | ||||
| first_name | varchar(255) | false | ||||
| first_name_en | varchar(255) | false | ||||
| id | bigint | false | ||||
| id_doc_type | varchar(50) | false | ||||
| issued_date | date | true | ||||
| last_name | varchar(255) | false | ||||
| last_name_en | varchar(255) | false | ||||
| middle_name | varchar(255) | false | ||||
| middle_name_en | varchar(255) | false | ||||
| mrz_line_1 | varchar(255) | false | ||||
| mrz_line_2 | varchar(255) | false | ||||
| number | varchar(255) | false | ||||
| valid_until | date | true |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| id_check_documents_application_id_bd45422c_fk_id_check_ | FOREIGN KEY | FOREIGN KEY (application_id) REFERENCES id_check_applications(id) DEFERRABLE INITIALLY DEFERRED |
| id_check_documents_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| id_check_documents_application_id_bd45422c | CREATE INDEX id_check_documents_application_id_bd45422c ON public.id_check_documents USING btree (application_id) |
| id_check_documents_pkey | CREATE UNIQUE INDEX id_check_documents_pkey ON public.id_check_documents USING btree (id) |
Generated by tbls