units_cris

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('units_cris_id_seq'::regclass)
change_log_units_cris.record_id change_log_units_cris_record_id_fkey C
people_cris.unit_id people_cris_unit_id_fkey C
people_edits.unit_id people_edits_unit_id_fkey C
units_edits.id units_edits_id_fkey C
autonomous_unit_id int4 10 √ null
autonomous_unit.id units_cris_autonomous_unit_id_fkey R
contrib_factr_1_id int4 10 √ null
contrib_factr.id units_cris_contrib_factr_1_id_fkey R
contrib_factr_2_id int4 10 √ null
contrib_factr.id units_cris_contrib_factr_2_id_fkey R
contrib_factr_3_id int4 10 √ null
contrib_factr.id units_cris_contrib_factr_3_id_fkey R
contrib_factr_p1_id int4 10 √ null
contrib_factr.id units_cris_contrib_factr_p1_id_fkey R
contrib_factr_p2_id int4 10 √ null
contrib_factr.id units_cris_contrib_factr_p2_id_fkey R
crash_pk int4 10 null
crashes_cris.id units_cris_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_cris_cris_crash_id_fkey C
cris_schema_version text 2147483647 null
e_scooter_id int4 10 √ null
e_scooter.id units_cris_e_scooter_id_fkey R
first_harm_evt_inv_id int4 10 √ null
harm_evnt.id units_cris_first_harm_evt_inv_id_fkey R
is_deleted bool 1 false
pbcat_pedalcyclist_id int4 10 √ null
pbcat_pedalcyclist.id units_cris_pbcat_pedalcyclist_id_fkey R
pbcat_pedestrian_id int4 10 √ null
pbcat_pedestrian.id units_cris_pbcat_pedestrian_id_fkey R
pedalcyclist_action_id int4 10 √ null
pedalcyclist_action.id units_cris_pedalcyclist_action_id_fkey R
pedestrian_action_id int4 10 √ null
pedestrian_action.id units_cris_pedestrian_action_id_fkey R
rpt_autonomous_level_engaged_id int4 10 √ null
autonomous_level_engaged.id units_cris_rpt_autonomous_level_engaged_id_fkey R
unit_desc_id int4 10 √ null
unit_desc.id units_cris_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_cris_veh_body_styl_id_fkey R
veh_damage_description1_id int4 10 √ null
veh_damage_description.id units_cris_veh_damage_description1_id_fkey R
veh_damage_description2_id int4 10 √ null
veh_damage_description.id units_cris_veh_damage_description2_id_fkey R
veh_damage_direction_of_force1_id int4 10 √ null
veh_direction_of_force.id units_cris_veh_damage_direction_of_force1_id_fkey R
veh_damage_direction_of_force2_id int4 10 √ null
veh_direction_of_force.id units_cris_veh_damage_direction_of_force2_id_fkey R
veh_damage_severity1_id int4 10 √ null
veh_damage_severity.id units_cris_veh_damage_severity1_id_fkey R
veh_damage_severity2_id int4 10 √ null
veh_damage_severity.id units_cris_veh_damage_severity2_id_fkey R
veh_make_id int4 10 √ null
veh_make.id units_cris_veh_make_id_fkey R
veh_mod_id int4 10 √ null
veh_mod.id units_cris_veh_mod_id_fkey R
veh_mod_year int4 10 √ null
veh_trvl_dir_id int4 10 √ null
trvl_dir.id units_cris_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_cris_pkey Primary key Asc id
unique_units_cris Must be unique Asc/Asc crash_pk + unit_nbr
units_cris_cris_crash_id_unit_nbr_idx Performance Asc/Asc cris_crash_id + unit_nbr

Check Constraints

Constraint Name Constraint
units_cris_veh_body_styl_id_check ((veh_body_styl_id < 177))
units_cris_unit_desc_id_check (((unit_desc_id < 177) OR ((created_by <> 'cris'::text) AND (created_by <> 'system'::text))))

Relationships

Close relationships within degrees of separation