data_officerallegation


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('data_officerallegation_id_seq'::regclass)
start_date date 13 √ null
end_date date 13 √ null
officer_age int4 10 √ null
recc_finding varchar 2 null
recc_outcome varchar 32 null
final_finding varchar 2 null
final_outcome varchar 32 null
final_outcome_class varchar 20 null
allegation_id int4 10 √ null
data_allegation.id data_officerallega_allegation_id_429ce710_fk_data_allegation_id R
allegation_category_id int4 10 √ null
data_allegationcategory.id d_allegation_category_id_023a83f1_fk_data_allegationcategory_id R
officer_id int4 10 √ null
data_officer.id data_officerallegation_officer_id_a68f4888_fk_data_officer_id R
disciplined bool 1 √ null

Table contained 244455 rows

Indexes

Constraint Name Type Sort Column(s)
data_officerallegation_pkey Primary key Asc id
data_officerallegation_6d48f909 Performance Asc allegation_id
data_officerallegation_e1d6855c Performance Asc officer_id
data_officerallegation_f5234087 Performance Asc allegation_category_id

Relationships

Close relationships within degrees of separation