Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
||
| created_at | timestamptz | 35,6 | √ | null |
|
|
||
| created_by | text | 2147483647 | √ | null |
|
|
||
| drvr_city_name | text | 2147483647 | √ | null |
|
|
||
| drvr_drg_cat_1_id | int4 | 10 | √ | null |
|
|
||
| drvr_zip | text | 2147483647 | √ | null |
|
|
||
| ems_id | int4 | 10 | √ | null |
|
|
||
| est_comp_cost_crash_based | int4 | 10 | √ | null |
|
|
||
| is_deleted | bool | 1 | √ | null |
|
|
||
| is_primary_person | bool | 1 | √ | null |
|
|
||
| prsn_age | int4 | 10 | √ | null |
|
|
||
| prsn_alc_rslt_id | int4 | 10 | √ | null |
|
|
||
| prsn_alc_spec_type_id | int4 | 10 | √ | null |
|
|
||
| prsn_bac_test_rslt | text | 2147483647 | √ | null |
|
|
||
| prsn_death_timestamp | timestamptz | 35,6 | √ | null |
|
|
||
| prsn_drg_rslt_id | int4 | 10 | √ | null |
|
|
||
| prsn_drg_spec_type_id | int4 | 10 | √ | null |
|
|
||
| prsn_ethnicity_id | int4 | 10 | √ | null |
|
|
||
| prsn_exp_homelessness | bool | 1 | √ | null |
|
|
||
| prsn_first_name | text | 2147483647 | √ | null |
|
|
||
| prsn_gndr_id | int4 | 10 | √ | null |
|
|
||
| prsn_helmet_id | int4 | 10 | √ | null |
|
|
||
| prsn_injry_sev_id | int4 | 10 | √ | null |
|
|
||
| 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 |
|
|
||
| prsn_rest_id | int4 | 10 | √ | null |
|
|
||
| prsn_taken_by | text | 2147483647 | √ | null |
|
|
||
| prsn_taken_to | text | 2147483647 | √ | null |
|
|
||
| prsn_type_id | int4 | 10 | √ | null |
|
|
||
| unit_id | int4 | 10 | √ | null |
|
|
||
| updated_at | timestamptz | 35,6 | √ | null |
|
|
||
| updated_by | text | 2147483647 | √ | null |
|
|
||
| years_of_life_lost | int4 | 10 | √ | null |
|
|
||
| crash_pk | int4 | 10 | √ | null |
|
|
||
| cris_crash_id | int4 | 10 | √ | null |
|
|
||
| crash_timestamp | timestamptz | 35,6 | √ | null |
|
|
||
| prsn_injry_sev_desc | text | 2147483647 | √ | null |
|
|
||
| unit_nbr | int4 | 10 | √ | null |
|
|
||
| unit_desc_id | int4 | 10 | √ | null |
|
|
||
| mode_desc | text | 2147483647 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
