Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id_barang | int4 | 10 | null |
|
|
||||||
| id_gudang | int4 | 10 | null |
|
|
||||||
| tanggal | date | 13 | null |
|
|
||||||
| in | numeric | 0 | null |
|
|
||||||
| out | numeric | 0 | null |
|
|
||||||
| batch | varchar | 2147483647 | null |
|
|
||||||
| expired_date | date | 13 | null |
|
|
||||||
| jenis | varchar | 2147483647 | 'REGULER'::character varying |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| stok_harian_pk | Primary key | Asc/Asc/Asc/Asc/Asc/Asc | id_barang + tanggal + batch + expired_date + id_gudang + jenis |
| unique_index_stok_harian | Must be unique | Asc/Asc/Asc/Asc/Asc/Asc | tanggal + id_barang + id_gudang + batch + expired_date + jenis |
Relationships
Close relationships within degrees of separation
