Schema
Table Description
prepersons
Name | Type | M/O | Description and constraints | Status | |
|---|---|---|---|---|---|
| 1 | id | uuid | M | Identifier of preperson (PK) | |
| 2 | person_id | uuid | O | Reference to person (if preperson becomes identified) | |
| 3 | external_id | varchar(1000) | M | External identifier of preperson in MIS. Also can be used as note? | |
| 4 | status | varchar(50) | M | Status of the preperson. Allowed statuses:
By default is NON_IDENTIFIED | |
| 5 | is_active | bool | M | Technical flag. By default is true | |
| 6 | inserted_at | timestamp | M | Insert date and time | |
| 7 | inserted_by | uuid | M | User id who inserted the entry | |
| 8 | updated_at | timestamp | M | Update date and time | |
| 9 | updated_by | uuid | M | User id who updated the entry |