1

id

uuid

M

Identifier of preperson (PK). Authogenerated

2

person_id

uuid

O

Reference to person (if preperson becomes identified)

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

external_id

varchar(1000255)

M

External identifier of preperson in MIS. Also can be used as note?

9

note

varchar(1000)

O

Notes

10

status

varchar(5010)

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

• active

• inactive

By default is active

11

death_date

date

O

Prepersons death date. By default is null

12

is_active

bool

M

Technical flag. By default is is true

13

inserted_at

timestamp

M

Insert date and time

14

inserted_by

uuid

M

User id who inserted the entry

15

updated_at

timestamp

M

Update date and time

16

updated_by

uuid

M

User id who updated the entry