Columns
| Table | Type | Column | Type | Size | Nulls | Auto | Default | Comments |
|---|---|---|---|---|---|---|---|---|
| trr_actionresponse | Table | action | varchar | 64 | √ | null | ||
| trr_actionresponse | Table | action_category | varchar | 1 | √ | null | ||
| trr_actionresponse | Table | action_sub_category | varchar | 3 | √ | null | ||
| data_policeunit | Table | active | bool | 1 | √ | null | ||
| data_officer | Table | active | varchar | 10 | null | |||
| data_allegation | Table | add1 | varchar | 16 | null | |||
| data_allegation | Table | add2 | varchar | 255 | null | |||
| data_attachmentfile | Table | additional_info | jsonb | 2147483647 | null | |||
| data_complainant | Table | age | int4 | 10 | √ | null | ||
| trr_trrstatus | Table | age | int2 | 5 | √ | null | ||
| data_victim | Table | age | int4 | 10 | √ | null | ||
| data_involvement | Table | age | int4 | 10 | √ | null | ||
| data_salary | Table | age_at_hire | int2 | 5 | √ | null | ||
| data_area | Table | alderman | varchar | 255 | √ | null | ||
| data_officerallegation | Table | allegation_category_id | int4 | 10 | √ | null | ||
| data_involvement | Table | allegation_id | int4 | 10 | null | |||
| data_victim | Table | allegation_id | int4 | 10 | null | |||
| data_investigatorallegation | Table | allegation_id | int4 | 10 | null | |||
| data_allegation_line_areas | Table | allegation_id | int4 | 10 | null | |||
| data_policewitness | Table | allegation_id | int4 | 10 | √ | null | ||
| data_allegation_areas | Table | allegation_id | int4 | 10 | null | |||
| data_attachmentrequest | Table | allegation_id | int4 | 10 | null | |||
| data_officerallegation | Table | allegation_id | int4 | 10 | √ | null | ||
| data_attachmentfile | Table | allegation_id | int4 | 10 | null | |||
| data_complainant | Table | allegation_id | int4 | 10 | √ | null | ||
| data_allegationcategory | Table | allegation_name | varchar | 255 | null | |||
| data_investigator | Table | appointed_date | date | 13 | √ | null | ||
| data_officer | Table | appointed_date | date | 13 | √ | null | ||
| data_allegation_areas | Table | area_id | int4 | 10 | null | |||
| data_racepopulation | Table | area_id | int4 | 10 | null | |||
| data_area | Table | area_type | varchar | 30 | null | |||
| spatial_ref_sys | Table | auth_name | varchar | 256 | √ | null | ||
| spatial_ref_sys | Table | auth_srid | int4 | 10 | √ | null | ||
| data_award | Table | award_type | varchar | 255 | null | |||
| trr_trr | Table | beat | int2 | 5 | √ | null | ||
| data_allegation | Table | beat_id | int4 | 10 | √ | null | ||
| data_victim | Table | birth_year | int4 | 10 | √ | null | ||
| data_complainant | Table | birth_year | int4 | 10 | √ | null | ||
| data_officer | Table | birth_year | int4 | 10 | √ | null | ||
| trr_trr | Table | block | varchar | 8 | √ | null | ||
| raster_columns | View | blocksize_x | int4 | 10 | √ | null | ||
| raster_columns | View | blocksize_y | int4 | 10 | √ | null | ||
| data_allegationcategory | Table | category | varchar | 255 | null | |||
| data_allegationcategory | Table | category_code | varchar | 255 | null | |||
| data_award | Table | ceremony_date | date | 13 | √ | null | ||
| data_allegationcategory | Table | citizen_dept | varchar | 50 | null | |||
| data_allegation | Table | city | varchar | 255 | null | |||
| data_officer | Table | civilian_allegation_percentile | numeric | 6 | √ | null | ||
| data_area | Table | commander_id | int4 | 10 | √ | null | ||
| data_officer | Table | complaint_percentile | numeric | 6 | √ | null |
Processing...