units

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
change_log_units.record_id change_log_units_record_id_fkey C
people.unit_id people_unit_id_fkey C
autonomous_unit_id int4 10 √ null
autonomous_unit.id units_autonomous_unit_id_fkey R
contrib_factr_1_id int4 10 √ null
contrib_factr.id units_contrib_factr_1_id_fkey R
contrib_factr_2_id int4 10 √ null
contrib_factr.id units_contrib_factr_2_id_fkey R
contrib_factr_3_id int4 10 √ null
contrib_factr.id units_contrib_factr_3_id_fkey R
contrib_factr_p1_id int4 10 √ null
contrib_factr.id units_contrib_factr_p1_id_fkey R
contrib_factr_p2_id int4 10 √ null
contrib_factr.id units_contrib_factr_p2_id_fkey R
crash_pk int4 10 null
crashes.id units_crash_pk_fkey C
created_at timestamptz 35,6 now()
created_by text 2147483647 'system'::text
cris_crash_id int4 10 √ null
crashes.cris_crash_id units_cris_crash_id_fkey C
e_scooter_id int4 10 √ null
e_scooter.id units_e_scooter_id_fkey R
first_harm_evt_inv_id int4 10 √ null
harm_evnt.id units_first_harm_evt_inv_id_fkey R
is_deleted bool 1 false
movement_id int4 10 √ null
movt.id units_movement_id_fkey R
pbcat_pedalcyclist_id int4 10 √ null
pbcat_pedalcyclist.id units_pbcat_pedalcyclist_id_fkey R
pbcat_pedestrian_id int4 10 √ null
pbcat_pedestrian.id units_pbcat_pedestrian_id_fkey R
pedalcyclist_action_id int4 10 √ null
pedalcyclist_action.id units_pedalcyclist_action_id_fkey R
pedestrian_action_id int4 10 √ null
pedestrian_action.id units_pedestrian_action_id_fkey R
rpt_autonomous_level_engaged_id int4 10 √ null
autonomous_level_engaged.id units_rpt_autonomous_level_engaged_id_fkey R
unit_desc_id int4 10 √ null
unit_desc.id units_unit_desc_id_fkey R
unit_nbr int4 10 null
updated_at timestamptz 35,6 now()
updated_by text 2147483647 'system'::text
veh_body_styl_id int4 10 √ null
veh_body_styl.id units_veh_body_styl_id_fkey R
veh_damage_description1_id int4 10 √ null
veh_damage_description.id units_veh_damage_description1_id_fkey R
veh_damage_description2_id int4 10 √ null
veh_damage_description.id units_veh_damage_description2_id_fkey R
veh_damage_direction_of_force1_id int4 10 √ null
veh_direction_of_force.id units_veh_damage_direction_of_force1_id_fkey R
veh_damage_direction_of_force2_id int4 10 √ null
veh_direction_of_force.id units_veh_damage_direction_of_force2_id_fkey R
veh_damage_severity1_id int4 10 √ null
veh_damage_severity.id units_veh_damage_severity1_id_fkey R
veh_damage_severity2_id int4 10 √ null
veh_damage_severity.id units_veh_damage_severity2_id_fkey R
veh_make_id int4 10 √ null
veh_make.id units_veh_make_id_fkey R
veh_mod_id int4 10 √ null
veh_mod.id units_veh_mod_id_fkey R
veh_mod_year int4 10 √ null
veh_trvl_dir_id int4 10 √ null
trvl_dir.id units_veh_trvl_dir_id_fkey R
vin text 2147483647 √ null
vz_mode_category_id int4 10 CASE WHEN (unit_desc_id = 3) THEN 5 WHEN (unit_desc_id = 5) THEN 6 WHEN (unit_desc_id = 4) THEN 7 WHEN (unit_desc_id = 2) THEN 8 WHEN (unit_desc_id = 177) THEN CASE WHEN (veh_body_styl_id = 177) THEN 11 ELSE 6 END WHEN (unit_desc_id = 1) THEN CASE WHEN (veh_body_styl_id = ANY (ARRAY[100, 104])) THEN 1 WHEN (veh_body_styl_id = ANY (ARRAY[30, 69, 103, 106])) THEN 2 WHEN (veh_body_styl_id = ANY (ARRAY[71, 90])) THEN 3 ELSE 4 END ELSE 9 END
mode_category.id vz_mode_category_fk R
veh_hnr_fl bool 1 √ null

If the unit was involved in a hit-and-run crash. This field may indicate that the unit was the victim of a hit and run, or this unit left the scene/committed the hit and run

Indexes

Constraint Name Type Sort Column(s)
units_pkey Primary key Asc id
unique_units Must be unique Asc/Asc crash_pk + unit_nbr
units_crash_pk_idx Performance Asc crash_pk

Relationships

Close relationships within degrees of separation