divisi_sales

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('divisi_sales_id_seq'::regclass)
customer.id_divisi_sales customer_id_divisi_sales_divisi_sales_id_fk R
divisi_channel.id_channel divisi_channel_id_channel_divisi_sales_id_fk R
mapping_kolektor_area.id_divisi_sales mapping_kolektor_area_id_divisi_sales_divisi_sales_id_fk R
mapping_salesman_area.id_divisi_sales mapping_salesman_area_id_divisi_sales_divisi_sales_id_fk R
target_penjualan_detail.id_divisi_sales target_penjualan_detail_id_divisi_sales_divisi_sales_id_fk R
nama varchar 2147483647 null
created_by int4 10 null
pegawai.id divisi_sales_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id divisi_sales_updated_by_pegawai_id_fk R
updated_at timestamp 29,6 √ now()
id_divisi _int4 10 √ null
deleted_by int4 10 √ null
deleted_at timestamp 29,6 √ null
deleted_reason text 2147483647 ''::text
id_customer_jenis _int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
divisi_sales_pkey Primary key Asc id
divisi_sales_nama_unique Must be unique Asc nama

Relationships

Close relationships within degrees of separation