...
...
...
Schema
...
Table Description
prepersons
...
Name
...
Type
...
M/O
...
Description and constraints
...
Status
...
id
...
uuid
...
M
...
Identifier of preperson (PK)
...
person_id
...
uuid
...
O
...
Reference to person (if preperson becomes identified)
...
external_id
...
varchar(1000)
...
M
...
Prepersons stores in the same table as persons - MPI.persons. Thus all constraints should be removed from this table except status field. For prepersons needs will be added external_id field of varchar(1000) - external identifier of preperson in MIS (also can be used as note?
...
status
...
)
...
M
...
Status of the preperson. Allowed statuses:
NON_IDENTIFIED (needed if person_id not null?)
IDENTIFIED (needed if person_id not null? Rename to ACTIVE?)
INACTIVE
By default is NON_IDENTIFIED
...
is_active
...
bool
...
M
...
Technical flag. By default is true
...
inserted_at
...
timestamp
...
M
...
Insert date and time
...
inserted_by
...
uuid
...
M
...
User id who inserted the entry
...
updated_at
...
timestamp
...
M
...
Update date and time
...
updated_by
...
uuid
...
M
...