area

42 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('area_id_seq'::regclass)
area_delivery.id_area area_delivery_id_area_area_id_fk R
area_rencana_kunjungan_salesman.id_area area_rencana_kunjungan_salesman_id_area_area_id_fk R
bukti_barang_masuk.id_area bukti_barang_masuk_id_area_area_id_fk R
customer.id_area customer_id_area_area_id_fk R
customer.id_area_delivery customer_id_area_delivery_area_id_fk R
customer.id_area_penagihan customer_id_area_penagihan_area_id_fk R
ekspedisi_harga.id_area ekspedisi_harga_id_area_area_id_fk R
invoice.id_area invoice_id_area_area_id_fk R
mapping_kolektor_area.id_area mapping_kolektor_area_id_area_area_id_fk R
mapping_salesman_area.id_area mapping_salesman_area_id_area_area_id_fk R
packing.id_area packing_id_area_area_id_fk R
packing.id_area_delivery packing_id_area_delivery_area_id_fk R
penerimaan_barang.id_area penerimaan_barang_id_area_area_id_fk R
proposal_ar.id_area proposal_ar_id_area_area_id_fk R
sales_order.id_area sales_order_id_area_area_id_fk R
stok_opname_invoice_area.id_area stok_opname_invoice_area_id_area_area_id_fk R
surat_jalan.id_area surat_jalan_id_area_area_id_fk R
surat_jalan.id_area_delivery surat_jalan_id_area_delivery_area_id_fk R
surat_pesanan.id_area surat_pesanan_id_area_area_id_fk R
target_penjualan_detail.id_area target_penjualan_detail_id_area_area_id_fk R
nama varchar 2147483647 null
kabupaten varchar 2147483647 null
kecamatan varchar 2147483647 null
kelurahan text 2147483647 null
created_by int4 10 null
pegawai.id area_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id area_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)
area_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation