units_edits

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
change_log_units_edits.record_id change_log_units_edits_record_id_fkey C
units_cris.id units_edits_id_fkey C
autonomous_unit_id int4 10 √ null
autonomous_unit.id units_edits_autonomous_unit_id_fkey R
contrib_factr_1_id int4 10 √ null
contrib_factr.id units_edits_contrib_factr_1_id_fkey R
contrib_factr_2_id int4 10 √ null
contrib_factr.id units_edits_contrib_factr_2_id_fkey R
contrib_factr_3_id int4 10 √ null
contrib_factr.id units_edits_contrib_factr_3_id_fkey R
contrib_factr_p1_id int4 10 √ null
contrib_factr.id units_edits_contrib_factr_p1_id_fkey R
contrib_factr_p2_id int4 10 √ null
contrib_factr.id units_edits_contrib_factr_p2_id_fkey R
crash_pk int4 10 √ null
crashes_cris.id units_edits_crash_pk_fkey C
created_at timestamptz 35,6 now()
created_by text 2147483647 'system'::text
cris_crash_id int4 10 √ null
crashes_cris.cris_crash_id units_edits_cris_crash_id_fkey C
e_scooter_id int4 10 √ null
e_scooter.id units_edits_e_scooter_id_fkey R
first_harm_evt_inv_id int4 10 √ null
harm_evnt.id units_edits_first_harm_evt_inv_id_fkey R
is_deleted bool 1 √ null
movement_id int4 10 √ null
movt.id units_edits_movement_id_fkey R
pbcat_pedalcyclist_id int4 10 √ null
pbcat_pedalcyclist.id units_edits_pbcat_pedalcyclist_id_fkey R
pbcat_pedestrian_id int4 10 √ null
pbcat_pedestrian.id units_edits_pbcat_pedestrian_id_fkey R
pedalcyclist_action_id int4 10 √ null
pedalcyclist_action.id units_edits_pedalcyclist_action_id_fkey R
pedestrian_action_id int4 10 √ null
pedestrian_action.id units_edits_pedestrian_action_id_fkey R
rpt_autonomous_level_engaged_id int4 10 √ null
autonomous_level_engaged.id units_edits_rpt_autonomous_level_engaged_id_fkey R
unit_desc_id int4 10 √ null
unit_desc.id units_edits_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_edits_veh_body_styl_id_fkey R
veh_damage_description1_id int4 10 √ null
veh_damage_description.id units_edits_veh_damage_description1_id_fkey R
veh_damage_description2_id int4 10 √ null
veh_damage_description.id units_edits_veh_damage_description2_id_fkey R
veh_damage_direction_of_force1_id int4 10 √ null
veh_direction_of_force.id units_edits_veh_damage_direction_of_force1_id_fkey R
veh_damage_direction_of_force2_id int4 10 √ null
veh_direction_of_force.id units_edits_veh_damage_direction_of_force2_id_fkey R
veh_damage_severity1_id int4 10 √ null
veh_damage_severity.id units_edits_veh_damage_severity1_id_fkey R
veh_damage_severity2_id int4 10 √ null
veh_damage_severity.id units_edits_veh_damage_severity2_id_fkey R
veh_make_id int4 10 √ null
veh_make.id units_edits_veh_make_id_fkey R
veh_mod_id int4 10 √ null
veh_mod.id units_edits_veh_mod_id_fkey R
veh_mod_year int4 10 √ null
veh_trvl_dir_id int4 10 √ null
trvl_dir.id units_edits_veh_trvl_dir_id_fkey R
vin text 2147483647 √ null
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_edits_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation