Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('_column_metadata_id_seq'::regclass) |
|
|
||
| column_name | text | 2147483647 | null |
|
|
The name of the column in the db |
||
| record_type | text | 2147483647 | null |
|
|
The type of record tables associated with this colum: crashes/units/people/charges |
||
| is_imported_from_cris | bool | 1 | false |
|
|
If this column is populated via the CRIS import ETL |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| _column_metadata_pkey | Primary key | Asc | id |
| _column_metadata_column_name_record_type_key | Must be unique | Asc/Asc | column_name + record_type |
Relationships
Close relationships within degrees of separation
