Name | Type | M/O | Description and constraints | Status |
---|---|---|---|---|
id | uuid | M |
|
| |||
mpi_id | jsonb | M |
|
|
data_employee_id | uuid | O |
|
| ||
data_legal_entity_id | uuid | O |
|
| |||
declaration_number | varchar | M |
|
|
declaration_id | uuid | M |
|
|
status | varchar | M | Dictionary: NEW, APPROVED, SIGNED, CANCELLED, EXPIRED, REJECTED |
|
overlimit | boolean | O |
|
|
authentication_method_ |
current | jsonb | M |
|
|
channel | varchar | M |
|
|
documents | jsonb | O | urls for document |
|
printout content | text | M |
|
|
inserted_at | timestamp | M |
|
|
inserted_by | uuid | M |
|
|
updated_at | timestamp | M |
|
|
updated_by | uuid | M |
|
|
data | jsonb | O |
|
|
printout_content | text | O |
|
|
data_start_date_year | integer | O |
|
|
data_person_tax_id | varchar | O |
|
|
data_person_first_name | varchar | O |
|
|
data_person_last_name | varchar | O |
|
|
data_person_birth_date | date | O |
|
|
data_person_documents | jsonb | O |
|
|
authorize_with | uuid | O |
|
|
data_to_be_signed | jsonb | O |
|
|
parent_declaration_id | uuid | O |
|
|
status_reason | varchar | O | Dictionary DECLARATION_REQUEST_STATUS_REASON |
|
current_declaration_count | integer | O |
|
|
system_declaration_limit | integer | O |
|
|
is_shareable | boolean | O |
|
|
data_division_id | varchar | O |
|
|