data_allegation


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('data_allegation_id_seq'::regclass)
data_allegation_areas.allegation_id data_allegation_ar_allegation_id_1ccd7982_fk_data_allegation_id R
data_allegation_line_areas.allegation_id data_allegation_li_allegation_id_6c00ce82_fk_data_allegation_id R
data_attachmentfile.allegation_id data_attachmentfil_allegation_id_1b6443a8_fk_data_allegation_id R
data_attachmentrequest.allegation_id data_attachmentreque_allegation_id_c0b1886b_fk_data_alle R
data_complainant.allegation_id data_complainant_allegation_id_f5452147_fk_data_allegation_id R
data_investigatorallegation.allegation_id data_investigatorall_allegation_id_655b5938_fk_data_alle R
data_involvement.allegation_id data_involvement_allegation_id_c248e036_fk_data_allegation_id R
data_officerallegation.allegation_id data_officerallega_allegation_id_429ce710_fk_data_allegation_id R
data_policewitness.allegation_id data_policewitness_allegation_id_b8dc2d75_fk_data_allegation_id R
data_victim.allegation_id data_victim_allegation_id_bef5a29d_fk_data_allegation_id R
crid varchar 30 null
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_id R
is_officer_complaint bool 1 null
add1 varchar 16 null
location varchar 64 null
old_complaint_address varchar 255 √ null

Table contained 181534 rows

Indexes

Constraint Name Type Sort Column(s)
data_allegation_pkey Primary key Asc id
data_allegation_5f70871c Performance Asc beat_id
data_allegation_point_id Performance Asc point

Relationships

Close relationships within degrees of separation