person

-1 rows


Description

A person is an individual that is being tracked explicitly within the system. The criteria for being included as a trackable individual is the possession of a unique identifier that can be used for dealiasing. For example an IDIR or a BC Drivers Licence.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
person_guid uuid 2147483647 uuid_generate_v4()
officer.person_guid FK_officer_person R
person_complaint_xref.person_guid FK_person_complaint_xref__person_guid R

System generated unique key for an person. This key should never be exposed to users via any system utilizing the tables.
first_name varchar 32 null

The first name of a person.
middle_name_1 varchar 32 √ null

The first middle name of a person.
middle_name_2 varchar 32 √ null

Any remaining middle names beyond the first of a person.
last_name varchar 32 null

The last name of a person.
create_user_id varchar 32 null

The id of the user that created the person.
create_utc_timestamp timestamp 29,6 null

The timestamp when the person was created. The timestamp is stored in UTC with no Offset.
update_user_id varchar 32 null

The id of the user that updated the person.
update_utc_timestamp timestamp 29,6 null

The timestamp when the person was updated. The timestamp is stored in UTC with no Offset.

Indexes

Constraint Name Type Sort Column(s)
PK_person Primary key Asc person_guid

Relationships

Close relationships within degrees of separation