stok_value

28334 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
batch varchar 2147483647 null
expired_date date 13 null
tahun varchar 2147483647 null
id_barang int4 10 null
barang.id stok_value_id_barang_barang_id_fk R
id_gudang int4 10 null
gudang.id stok_value_id_gudang_gudang_id_fk R
db0 numeric 0 √ '0'::numeric
db1 numeric 0 √ '0'::numeric
db2 numeric 0 √ '0'::numeric
db3 numeric 0 √ '0'::numeric
db4 numeric 0 √ '0'::numeric
db5 numeric 0 √ '0'::numeric
db6 numeric 0 √ '0'::numeric
db7 numeric 0 √ '0'::numeric
db8 numeric 0 √ '0'::numeric
db9 numeric 0 √ '0'::numeric
db10 numeric 0 √ '0'::numeric
db11 numeric 0 √ '0'::numeric
db12 numeric 0 √ '0'::numeric
db13 numeric 0 √ '0'::numeric
cr0 numeric 0 √ '0'::numeric
cr1 numeric 0 √ '0'::numeric
cr2 numeric 0 √ '0'::numeric
cr3 numeric 0 √ '0'::numeric
cr4 numeric 0 √ '0'::numeric
cr5 numeric 0 √ '0'::numeric
cr6 numeric 0 √ '0'::numeric
cr7 numeric 0 √ '0'::numeric
cr8 numeric 0 √ '0'::numeric
cr9 numeric 0 √ '0'::numeric
cr10 numeric 0 √ '0'::numeric
cr11 numeric 0 √ '0'::numeric
cr12 numeric 0 √ '0'::numeric
cr13 numeric 0 √ '0'::numeric
jenis varchar 2147483647 'REGULER'::character varying

Indexes

Constraint Name Type Sort Column(s)
stok_value_pk Primary key Asc/Asc/Asc/Asc/Asc/Asc id_barang + tahun + batch + expired_date + id_gudang + jenis
unique_index_stok_value Must be unique Asc/Asc/Asc/Asc/Asc/Asc tahun + id_barang + id_gudang + batch + expired_date + jenis

Relationships

Close relationships within degrees of separation