data_allegation

216052 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
crid varchar 30 null
data_allegation_areas.allegation_id data_allegation_area_allegation_id_1ccd7982_fk_data_alleR
data_allegation_line_areas.allegation_id data_allegation_line_allegation_id_6c00ce82_fk_data_alleR
data_attachmentfile.allegation_id data_attachmentfile_allegation_id_1b6443a8_fk_data_alleR
data_attachmentrequest.allegation_id data_attachmentreque_allegation_id_c0b1886b_fk_data_alleR
data_complainant.allegation_id data_complainant_allegation_id_f5452147_fk_data_allegation_cridR
data_investigatorallegation.allegation_id data_investigatorall_allegation_id_655b5938_fk_data_alleR
data_involvement.allegation_id data_involvement_allegation_id_c248e036_fk_data_allegation_cridR
data_officerallegation.allegation_id data_officerallegati_allegation_id_429ce710_fk_data_alleR
data_policewitness.allegation_id data_policewitness_allegation_id_b8dc2d75_fk_data_alleR
data_searchwarrant.potential_crid sw_crid_fkeyR
data_victim.allegation_id data_victim_allegation_id_bef5a29d_fk_data_allegation_cridR
pinboard_pinboard_allegations.allegation_id pinboard_pinboard_al_allegation_id_6444fd6c_fk_data_alleR
summary text 2147483647 null
add2 varchar 255 null
city varchar 255 null
incident_date timestamptz 35,6 √ null
point geometry 2147483647 √ null
source varchar 20 null
beat_id int4 10 √ null
data_area.id data_allegation_beat_id_3812d8f9_fk_data_area_idR
is_officer_complaint bool 1 null
add1 varchar 16 null
location varchar 64 null
old_complaint_address varchar 255 √ null
first_end_date date 13 √ null
first_start_date date 13 √ null
most_common_category_id int4 10 √ null
data_allegationcategory.id data_allegation_most_common_category_88004da7_fk_data_alleR
coaccused_count int4 10 √ null
subjects _varchar 255 null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
is_extracted_summary bool 1 null

Indexes

Constraint Name Type Sort Column(s)
data_allegation_crid_1770709b_pk Primary key Asc crid
data_allegation_5f70871c Performance Asc beat_id
data_allegation_crid_1770709b_like Performance Asc crid
data_allegation_crid_1770709b_uniq Must be unique Asc crid
data_allegation_most_common_category_id_88004da7 Performance Asc most_common_category_id
data_allegation_point_id Performance Asc point

Relationships

Close relationships within degrees of separation