mapping_kolektor

18 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mapping_kolektor_id_seq'::regclass)
mapping_kolektor_area.id mapping_kolektor_area_id_mapping_kolektor_id_fk R
id_kolektor int4 10 null
pegawai.id mapping_kolektor_id_kolektor_pegawai_id_fk R
id_spv int4 10 null
pegawai.id mapping_kolektor_id_spv_pegawai_id_fk R
created_by int4 10 null
pegawai.id mapping_kolektor_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id mapping_kolektor_updated_by_pegawai_id_fk R
updated_at timestamp 29,6 √ now()
deleted_by int4 10 √ null
deleted_at timestamp 29,6 √ null
deleted_reason text 2147483647 ''::text

Indexes

Constraint Name Type Sort Column(s)
mapping_kolektor_pkey Primary key Asc id
mapping_kolektor_id_kolektor_id_spv_unique Must be unique Asc/Asc id_kolektor + id_spv

Relationships

Close relationships within degrees of separation