data_investigatorallegation


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('data_investigatorallegation_id_seq'::regclass)
current_star varchar 10 √ null
current_rank varchar 100 √ null
allegation_id int4 10 null
data_allegation.id data_investigatorall_allegation_id_655b5938_fk_data_alle R
current_unit_id int4 10 √ null
data_policeunit.id data_investigatorall_current_unit_id_da1ab9e3_fk_data_poli R
investigator_id int4 10 null
data_investigator.id data_investigatorall_investigator_id_cd1fd6b1_fk_data_inve R
investigator_type varchar 32 √ null

Table contained 132235 rows

Indexes

Constraint Name Type Sort Column(s)
data_investigatorallegation_pkey Primary key Asc id
data_investigatorallegation_allegation_id_655b5938 Performance Asc allegation_id
data_investigatorallegation_current_unit_id_da1ab9e3 Performance Asc current_unit_id
data_investigatorallegation_investigator_id_cd1fd6b1 Performance Asc investigator_id

Relationships

Close relationships within degrees of separation