Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | null |
|
|
||||||
| urut | int4 | 10 | null |
|
|
||||||
| id_barang | int4 | 10 | null |
|
|
||||||
| qty_sistem | numeric | 0 | null |
|
|
||||||
| qty_fisik | numeric | 0 | null |
|
|
||||||
| keterangan | text | 2147483647 | √ | null |
|
|
|||||
| is_verified | bool | 1 | √ | false |
|
|
|||||
| batch | varchar | 2147483647 | null |
|
|
||||||
| expired_date | date | 13 | null |
|
|
||||||
| selisih | numeric | 0 | null |
|
|
||||||
| total_selisih | numeric | 0 | null |
|
|
||||||
| total_qty_sistem | numeric | 0 | null |
|
|
||||||
| profit_margin | numeric | 0 | null |
|
|
||||||
| harga_jual | numeric | 0 | '0'::numeric |
|
|
||||||
| harga_selisih | numeric | 0 | null |
|
|
||||||
| total_harga_jual | numeric | 0 | null |
|
|
||||||
| id_gudang | int4 | 10 | null |
|
|
||||||
| total_qty_fisik | numeric | 0 | null |
|
|
||||||
| hpp | numeric | 0 | null |
|
|
||||||
| keterangan_gudang | text | 2147483647 | √ | null |
|
|
|||||
| is_verified_gudang | bool | 1 | √ | false |
|
|
|||||
| qty_pcs | numeric | 0 | '0'::numeric |
|
|
||||||
| qty_kolian | numeric | 0 | '0'::numeric |
|
|
||||||
| waktu_verified | timestamptz | 35,6 | √ | null |
|
|
|||||
| waktu_verified_gudang | timestamptz | 35,6 | √ | null |
|
|
|||||
| harga_beli | numeric | 0 | '0'::numeric |
|
|
||||||
| jenis | varchar | 2147483647 | 'REGULER'::character varying |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| stok_opname_detail_id_urut_pk | Primary key | Asc/Asc | id + urut |
Relationships
Close relationships within degrees of separation
