person


Columns

Column Type Size Nulls Auto Default Children Parents Comments
person_id int8 19 √ null
enrollment.person_id fk_enrollment_person R
enrollment_appointment.person_id Implied Constraint R
free_enrollment.person_id fk_free_enrollment_person R
reservation.person_id fk_reservation_person R
version int4 10 0
created_by text 2147483647 √ null
modified_by text 2147483647 √ null
deleted_by text 2147483647 √ null
created_at timestamptz 35,6 now()
modified_at timestamptz 35,6 now()
deleted_at timestamptz 35,6 √ null
last_name text 2147483647 null
first_name text 2147483647 null
oid varchar 255 √ null
other_identifier varchar 1024 √ null
latest_identified_at timestamptz 35,6 null
uuid uuid 2147483647 null
latest_sync_at timestamptz 35,6 now()
tmp_first_name text 2147483647 √ null
tmp_last_name text 2147483647 √ null
tmp_nickname text 2147483647 √ null
partial_exam_selection text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
person_pkey Primary key Asc person_id
person_oid_uniq_idx Must be unique Asc oid
person_other_id_uniq_idx Must be unique Asc other_identifier
person_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation