estimasi_order

705 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('estimasi_order_id_seq'::regclass)
estimasi_order_detail.id estimasi_order_detail_id_estimasi_order_id_fk R
estimasi_order_persetujuan.id estimasi_order_persetujuan_id_estimasi_order_id_fk R
permintaan_penawaran.id_estimasi_order permintaan_penawaran_id_estimasi_order_estimasi_order_id_fk R
nomor varchar 50 null
tanggal date 13 null
pengali_estimasi numeric 5,2 √ null
id_brand int4 10 √ null
brand.id estimasi_order_id_brand_brand_id_fk R
id_divisi int4 10 √ null
divisi.id estimasi_order_id_divisi_divisi_id_fk R
keterangan text 2147483647 √ null
status bpchar 1 null
created_by int4 10 null
pegawai.id estimasi_order_created_by_pegawai_id_fk R
updated_by int4 10 null
pegawai.id estimasi_order_updated_by_pegawai_id_fk R
updated_at timestamp 29,6 √ now()
id_kategori int4 10 √ null
barang_kategori.id estimasi_order_id_kategori_barang_kategori_id_fk R
created_at timestamp 29,6 √ now()
deleted_by int4 10 √ null
deleted_at timestamp 29,6 √ null
deleted_reason text 2147483647 ''::text
bulan int4 10 null
subtotal numeric 0 null
total_diskon numeric 0 null
dpp numeric 0 null
grandtotal numeric 0 null
is_ppn bool 1 null
persen_ppn numeric 0 null
total_ppn numeric 0 null

Indexes

Constraint Name Type Sort Column(s)
estimasi_order_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation