stok_barang

32168 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stok_barang_id_seq'::regclass)
barang_dekat_ed_detail.id_stok barang_dekat_ed_detail_id_stok_stok_barang_id_fk R
barang_dekat_ed_detail.id_stok_baru barang_dekat_ed_detail_id_stok_baru_stok_barang_id_fk R
bukti_barang_masuk_detail.id_stok bukti_barang_masuk_detail_id_stok_stok_barang_id_fk R
checking_detail.id_stok checking_detail_id_stok_stok_barang_id_fk R
invoice_retur_detail.id_stok invoice_retur_detail_id_stok_stok_barang_id_fk R
invoice_retur_detail.id_stok_baru invoice_retur_detail_id_stok_baru_stok_barang_id_fk R
pemindahan_barang_detail.id_stok pemindahan_barang_detail_id_stok_stok_barang_id_fk R
retur_pembelian_hpp.id_stok retur_pembelian_hpp_id_stok_fkey R
sales_order_hpp.id_stok sales_order_hpp_id_stok_stok_barang_id_fk R
stok_hold.id stok_hold_id_stok_barang_id_fk R
stok_opname_stok_barang.id_stok stok_opname_stok_barang_id_stok_fkey R
id_rak_barang int4 10 √ null
rak_barang.id stok_barang_id_rak_barang_rak_barang_id_fk R
id_supplier int4 10 √ null
supplier.id stok_barang_id_supplier_supplier_id_fk R
id_gudang int4 10 null
gudang.id stok_barang_id_gudang_gudang_id_fk R
id_barang int4 10 null
barang.id stok_barang_id_barang_barang_id_fk R
tanggal date 13 null
stok numeric 0 null
stok_awal numeric 0 null
expired_date date 13 null
hpp numeric 18,2 '0'::numeric
batch varchar 100 null
reff varchar 5 null
id_reff int4 10 null
stok_hold numeric 0 '0'::numeric
created_by int4 10 null
pegawai.id stok_barang_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id stok_barang_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
jenis varchar 2147483647 'REGULER'::character varying
harga_beli numeric 0 '0'::numeric
harga_jual numeric 0 '0'::numeric
masuk_dari_mana varchar 2147483647 '-'::character varying

Indexes

Constraint Name Type Sort Column(s)
stok_barang_pkey Primary key Asc id
idx_stok_barang_gudang_barang_batch_ed Performance Asc/Asc/Asc/Asc id_gudang + id_barang + batch + expired_date

Relationships

Close relationships within degrees of separation