Name | Type | M/O | Description and constraints | Status|||||
|---|---|---|---|---|---|---|---|---|
| id | uuid | M | ||||||
| data_person_info | jsonb | M | data_person_confidant_person | |||||
| jsonbmpi_id | uuid | O | data_person_emergency_contact | jsonb | Oif update person and it's id is passed | |||
| status | varchar | M | Dictionary: NEW, APPROVED, SIGNED, CANCELLED, EXPIRED, REJECTED | |||||
| authentication_method_currenctcurrent | jsonb | M | ||||||
| channel | varchar | M | ||||||
| mpitax_id | uuidvarchar | O | start_date | date | ||||
| last_name | varchar | M | ||||||
| first_name | varchar | M | ||||||
| endbirth_datedate | varchar | M | ||||||
| data_legal_entiity | jsonbperson_documents | jsonb | M | |||||
| documents | jsonb | O | urls for documents | |||||
| printout form | text | O | ||||||
| inserted_at | timestamp | M | ||||||
| data_legal_entity_idinserted_by | UUID | M | ||||||
| updated_at | timestamp | M | ||||||
| updated_by | uuid | M | data_person_tax_id | uuid | M | data_person_last_name | ||
| varchar | M | data_person_first_name authorize_with | uuid | O | identifier of person's auth method |
Person authentication method
| Name | Type | M/O | Description |
|---|---|---|---|
| id | UUID | M | |
| person_id | UUID | M | |
third_person_id | UUID | M | |
| alias | varchar | M |
| status | varchar | M |
| person_authentication_ |
| method_ |
| currenct | jsonb | M |
| third_person_authentication_method_currenct | jsonb | M | |
| inserted_at | timestamp | M | |
| inserted_by |
| UUID | M | ||
| updated_at | timestamp | M | |
| updated_by |
| UUID | M |