stok_opname

1428 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stok_opname_id_seq'::regclass)
stok_opname_persetujuan.id stok_opname_persetujuan_id_stok_opname_id_fk R
stok_opname_stok_barang.id stok_opname_stok_barang_id_fkey R
nomor varchar 2147483647 null
tanggal date 13 null
catatan text 2147483647 null
created_by int4 10 null
pegawai.id stok_opname_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id stok_opname_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
status bpchar 1 null
id_barang int4 10 √ null
barang.id stok_opname_id_barang_barang_id_fk R
id_rak_barang int4 10 √ null
rak_barang.id stok_opname_id_rak_barang_rak_barang_id_fk R
bulan_return date 13 √ null
bulan_expired date 13 √ null
persen_ppn numeric 0 null
id_petugas int4 10 √ null
pegawai.id stok_opname_id_petugas_pegawai_id_fk R
id_rak_barang_level int4 10 √ null
waktu_simpan_permanent timestamp 29,6 √ null
selisih_minus numeric 0 null
selisih_plus numeric 0 null
total numeric 0 null
total_ppn numeric 0 null
grandtotal numeric 0 null
id_gudang int4 10 √ null
gudang.id stok_opname_id_gudang_fkey R

Indexes

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

Relationships

Close relationships within degrees of separation