data_investigatorallegation

181161 rows


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
current_unit_id int4 10 √ null
data_policeunit.id data_investigatorall_current_unit_id_da1ab9e3_fk_data_poliR
investigator_id int4 10 null
data_investigator.id data_investigatorall_investigator_id_cd1fd6b1_fk_data_inveR
investigator_type varchar 32 √ null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
allegation_id varchar 30 null
data_allegation.crid data_investigatorall_allegation_id_655b5938_fk_data_alleR

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_allegation_id_655b5938_like 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