people_edits

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
change_log_people_edits.record_id change_log_people_edits_record_id_fkey C
people_cris.id people_edits_id_fkey C
created_at timestamptz 35,6 now()
created_by text 2147483647 'system'::text
drvr_city_name text 2147483647 √ null
drvr_drg_cat_1_id int4 10 √ null
substnc_cat.id people_edits_drvr_drg_cat_1_id_fkey R
drvr_zip text 2147483647 √ null
ems_id int4 10 √ null
ems__incidents.id people_edits_ems_id_fkey N
is_deleted bool 1 √ null
is_primary_person bool 1 √ null
prsn_age int4 10 √ null
prsn_alc_rslt_id int4 10 √ null
substnc_tst_result.id people_edits_prsn_alc_rslt_id_fkey R
prsn_alc_spec_type_id int4 10 √ null
specimen_type.id people_edits_prsn_alc_spec_type_id_fkey R
prsn_bac_test_rslt text 2147483647 √ null
prsn_death_timestamp timestamptz 35,6 √ null
prsn_drg_rslt_id int4 10 √ null
substnc_tst_result.id people_edits_prsn_drg_rslt_id_fkey R
prsn_drg_spec_type_id int4 10 √ null
specimen_type.id people_edits_prsn_drg_spec_type_id_fkey R
prsn_ethnicity_id int4 10 √ null
drvr_ethncty.id people_edits_prsn_ethnicity_id_fkey R
prsn_exp_homelessness bool 1 √ null
prsn_first_name text 2147483647 √ null
prsn_gndr_id int4 10 √ null
gndr.id people_edits_prsn_gndr_id_fkey R
prsn_helmet_id int4 10 √ null
helmet.id people_edits_prsn_helmet_id_fkey R
prsn_injry_sev_id int4 10 √ null
injry_sev.id people_edits_prsn_injry_sev_id_fkey R
prsn_last_name text 2147483647 √ null
prsn_mid_name text 2147483647 √ null
prsn_name_sfx text 2147483647 √ null
prsn_nbr int4 10 √ null
prsn_occpnt_pos_id int4 10 √ null
occpnt_pos.id people_edits_prsn_occpnt_pos_id_fkey R
prsn_rest_id int4 10 √ null
rest.id people_edits_prsn_rest_id_fkey R
prsn_taken_by text 2147483647 √ null
prsn_taken_to text 2147483647 √ null
prsn_type_id int4 10 √ null
prsn_type.id people_edits_prsn_type_id_fkey R
unit_id int4 10 √ null
units_cris.id people_edits_unit_id_fkey C
updated_at timestamptz 35,6 now()
updated_by text 2147483647 'system'::text
drvr_lic_type_id int4 10 √ null
drvr_lic_type.id people_edits_drvr_lic_type_id_fkey R

Driver’s license type

Indexes

Constraint Name Type Sort Column(s)
people_edits_pkey Primary key Asc id
unique_people_edits Must be unique Asc/Asc unit_id + prsn_nbr

Relationships

Close relationships within degrees of separation