Name | Type | M/O | Description and constraints | Status | |
|---|---|---|---|---|---|
| id | uuid | M | |||
| person_data | jsonb | M | |||
| confidantpreperson_personmpi_id | uuid | O | if merge person with preperson | ||
| person_mpi_id | uuid | O | if update person and it's id is passed | ||
| merged_pair_id | uuid | O | if merge preperson with person is success | ||
| type | varchar | M | PREPERSON_MERGE, PERSON | ||
| status | varchar | M | Dictionary: NEW, APPROVED, SIGNED, CANCELLED, EXPIRED, REJECTED | ||
| authentication_method_currenctcurrent | jsonb | M | |||
| channel | varchar | M | |||
| tax_id | varchar | O | |||
| last_name | varchar | M | |||
| first_name | varchar | M | |||
| birth_date | varchar | M | |||
| person_documents | jsonb | M | |||
| documents | jsonb | O | urls for documents | ||
| printout form | text | O | |||
| inserted_at | timestamp | M | |||
| inserted_by | UUID | M | |||
| updated_at | timestamp | M | |||
| updated_by | uuid | M |
...
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 |