mapping_customer

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mapping_customer_id_seq'::regclass)
id_customer int4 10 null
customer.id mapping_customer_id_customer_customer_id_fk R
id_pegawai int4 10 null
pegawai.id mapping_customer_id_pegawai_pegawai_id_fk R
created_by int4 10 null
pegawai.id mapping_customer_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id mapping_customer_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_customer_pkey Primary key Asc id
mapping_customer_id_customer_id_pegawai_unique Must be unique Asc/Asc id_customer + id_pegawai

Relationships

Close relationships within degrees of separation