crashes_cris

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('crashes_cris_id_seq'::regclass)
change_log_crashes_cris.record_id change_log_crashes_cris_record_id_fkey C
charges_cris.crash_pk charges_cris_crash_pk_fkey C
crashes.id crashes_id_fkey C
crashes_edits.id crashes_edits_id_fkey C
units_cris.crash_pk units_cris_crash_pk_fkey C
units_edits.crash_pk units_edits_crash_pk_fkey C
active_school_zone_fl bool 1 √ null
at_intrsct_fl bool 1 √ null
case_id text 2147483647 √ null
cr3_processed_at timestamptz 35,6 √ null
cr3_stored_fl bool 1 false
crash_speed_limit int4 10 √ null
crash_timestamp timestamptz 35,6 null
created_at timestamptz 35,6 now()
created_by text 2147483647 'system'::text
cris_crash_id int4 10 √ null
charges_cris.cris_crash_id charges_cris_cris_crash_id_fkey C
people_cris.cris_crash_id people_cris_cris_crash_id_fkey C
units_cris.cris_crash_id units_cris_cris_crash_id_fkey C
units_edits.cris_crash_id units_edits_cris_crash_id_fkey C
cris_schema_version text 2147483647 null
fhe_collsn_id int4 10 √ null
collsn.id crashes_cris_fhe_collsn_id_fkey R
intrsct_relat_id int4 10 √ null
intrsct_relat.id crashes_cris_intrsct_relat_id_fkey R
investigat_agency_id int4 10 √ null
agency.id crashes_cris_investigat_agency_id_fkey R
investigator_narrative text 2147483647 √ null
is_deleted bool 1 false
is_temp_record bool 1 false
latitude numeric 0 √ null
light_cond_id int4 10 √ null
light_cond.id crashes_cris_light_cond_id_fkey R
longitude numeric 0 √ null
medical_advisory_fl bool 1 √ null
obj_struck_id int4 10 √ null
obj_struck.id crashes_cris_obj_struck_id_fkey R
onsys_fl bool 1 √ null
private_dr_fl bool 1 √ null
road_constr_zone_fl bool 1 √ null
road_constr_zone_wrkr_fl bool 1 √ null
rpt_block_num text 2147483647 √ null
rpt_city_id int4 10 √ null
city.id crashes_cris_rpt_city_id_fkey R
rpt_cris_cnty_id int4 10 √ null
cnty.id crashes_cris_rpt_cris_cnty_id_fkey R
rpt_hwy_num text 2147483647 √ null
rpt_hwy_sfx text 2147483647 √ null
rpt_rdwy_sys_id int4 10 √ null
rwy_sys.id crashes_cris_rpt_rdwy_sys_id_fkey R
rpt_ref_mark_dir text 2147483647 √ null
rpt_ref_mark_dist_uom text 2147483647 √ null
rpt_ref_mark_nbr text 2147483647 √ null
rpt_ref_mark_offset_amt numeric 0 √ null
rpt_road_part_id int4 10 √ null
road_part.id crashes_cris_rpt_road_part_id_fkey R
rpt_sec_block_num text 2147483647 √ null
rpt_sec_hwy_num text 2147483647 √ null
rpt_sec_hwy_sfx text 2147483647 √ null
rpt_sec_rdwy_sys_id int4 10 √ null
rwy_sys.id crashes_cris_rpt_sec_rdwy_sys_id_fkey R
rpt_sec_road_part_id int4 10 √ null
road_part.id crashes_cris_rpt_sec_road_part_id_fkey R
rpt_sec_street_desc text 2147483647 √ null
rpt_sec_street_name text 2147483647 √ null
rpt_sec_street_pfx text 2147483647 √ null
rpt_sec_street_sfx text 2147483647 √ null
rpt_street_desc text 2147483647 √ null
rpt_street_name text 2147483647 √ null
rpt_street_pfx text 2147483647 √ null
rpt_street_sfx text 2147483647 √ null
rr_relat_fl bool 1 √ null
schl_bus_fl bool 1 √ null
surf_cond_id int4 10 √ null
surf_cond.id crashes_cris_surf_cond_id_fkey R
surf_type_id int4 10 √ null
surf_type.id crashes_cris_surf_type_id_fkey R
thousand_damage_fl bool 1 √ null
toll_road_fl bool 1 √ null
traffic_cntl_id int4 10 √ null
traffic_cntl.id crashes_cris_traffic_cntl_id_fkey R
txdot_rptable_fl bool 1 √ null
updated_at timestamptz 35,6 now()
updated_by text 2147483647 'system'::text
wthr_cond_id int4 10 √ null
wthr_cond.id crashes_cris_wthr_cond_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
crashes_cris_pkey Primary key Asc id
crashes_cris_cris_crash_id_key Must be unique Asc cris_crash_id

Relationships

Close relationships within degrees of separation