sales_order_detail

380243 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
sales_order_hpp.id sales_order_hpp_sales_order_detail C
sales_order.id sales_order_detail_id_sales_order_id_fk R
id_barang int4 10 null
sales_order_hpp.id_barang sales_order_hpp_sales_order_detail C
barang.id sales_order_detail_id_barang_barang_id_fk R
id_satuan int4 10 null
satuan.id sales_order_detail_id_satuan_satuan_id_fk R
urut int4 10 null
qty numeric 0 null
harga numeric 0 null
diskon_persen_1 numeric 0 null
diskon_rp_1 numeric 0 null
total numeric 0 null
keterangan varchar 2147483647 √ null
status bool 1 √ null
id_program int4 10 √ null
program_penjualan_detail.id sales_order_detail_id_program_urut_program_program_penjualan_de R
id_satuan_bonus int4 10 √ null
satuan.id sales_order_detail_id_satuan_bonus_satuan_id_fk R
urut_program int4 10 √ null
program_penjualan_detail.urut sales_order_detail_id_program_urut_program_program_penjualan_de R
qty_bonus numeric 0 '0'::numeric
index_promotion int4 10 √ null
index_reward int4 10 √ null
qty_diskon numeric 0 '0'::numeric
harga_asli numeric 0 0

Indexes

Constraint Name Type Sort Column(s)
sales_order_detail_id_urut_pk Primary key Asc/Asc id + urut
sales_order_detail_id_id_barang_unique Must be unique Asc/Asc id + id_barang

Relationships

Close relationships within degrees of separation