...
Name | Type | M/O | Description and constraints | |||||
|---|---|---|---|---|---|---|---|---|
1 | id | uuid | M | Identifier of preperson (PK). Authogenerated | ||||
2 | first_name | varchar(50) | O | |||||
3 | second_name | varchar(50) | O | |||||
4 | last_name | varchar(50) | O | |||||
5 | birth_date | date | O | |||||
6 | gender | varchar(10) | O | Gender. Enum: MALE, FEMALE | ||||
7 | emergency_contact | jsonb | O | |||||
8 | confidant_person | jsonb | O | 9 | external_id | varchar(255) | M | External identifier of preperson in MIS. |
109 | note | varchar(1000) | O | Notes | ||||
1110 | status | varchar(10) | M | Status of the preperson. Allowed statuses:
By default is active | ||||
1211 | death_date | date | O | Prepersons death date. By default is null | ||||
1312 | is_active | bool | M | Technical flag. By default is true | ||||
1413 | inserted_at | timestamp | M | Insert date and time | ||||
1514 | inserted_by | uuid | M | User id who inserted the entry | ||||
1615 | updated_at | timestamp | M | Update date and time | ||||
1716 | updated_by | uuid | M | User id who updated the entry |