people

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
change_log_people.record_id change_log_people_record_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_drvr_drg_cat_1_id_fkey R
drvr_zip text 2147483647 √ null
ems_id int4 10 √ null
ems__incidents.id people_ems_id_fkey N
est_comp_cost_crash_based int4 10 √ CASE WHEN (prsn_injry_sev_id = 1) THEN 3000000 WHEN (prsn_injry_sev_id = 2) THEN 250000 WHEN (prsn_injry_sev_id = 3) THEN 200000 WHEN (prsn_injry_sev_id = 4) THEN 3500000 ELSE 20000 END
is_deleted bool 1 false
is_primary_person bool 1 √ null
prsn_age int4 10 √ null
prsn_alc_rslt_id int4 10 √ null
substnc_tst_result.id people_prsn_alc_rslt_id_fkey R
prsn_alc_spec_type_id int4 10 √ null
specimen_type.id people_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_prsn_drg_rslt_id_fkey R
prsn_drg_spec_type_id int4 10 √ null
specimen_type.id people_prsn_drg_spec_type_id_fkey R
prsn_ethnicity_id int4 10 √ null
drvr_ethncty.id people_prsn_ethnicity_id_fkey R
prsn_exp_homelessness bool 1 false
prsn_first_name text 2147483647 √ null
prsn_gndr_id int4 10 √ null
gndr.id people_prsn_gndr_id_fkey R
prsn_helmet_id int4 10 √ null
helmet.id people_prsn_helmet_id_fkey R
prsn_injry_sev_id int4 10 √ null
injry_sev.id people_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_prsn_occpnt_pos_id_fkey R
prsn_rest_id int4 10 √ null
rest.id people_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_prsn_type_id_fkey R
unit_id int4 10 null
units.id people_unit_id_fkey C
updated_at timestamptz 35,6 now()
updated_by text 2147483647 'system'::text
years_of_life_lost int4 10 √ CASE WHEN (prsn_injry_sev_id = 4) THEN GREATEST((75 - prsn_age), 0) ELSE 0 END
drvr_lic_type_id int4 10 √ null
drvr_lic_type.id people_drvr_lic_type_id_fkey R

Driver’s license type

Indexes

Constraint Name Type Sort Column(s)
people_pkey Primary key Asc id
people_prsn_injry_sev_id_idx Performance Asc prsn_injry_sev_id
people_unit_id_idx Performance Asc unit_id
unique_people Must be unique Asc/Asc unit_id + prsn_nbr

Relationships

Close relationships within degrees of separation