jenis_barang
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_jenis (Primary) | int | No | ||||
| jenis_brg | varchar(255) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_jenis | 17 | A | No |
pemasukan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int | No | ||||
| unit | varchar(20) | No | ||||
| kode_brg | varchar(8) | No | ||||
| jumlah | int | No | ||||
| tgl_keluar | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2 | A | No |
pembelian
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_pembelian (Primary) | int | No | ||||
| unit | varchar(25) | No | ||||
| kode_brg | varchar(8) | No | ||||
| id_jenis | int | No | ||||
| jumlah | int | No | ||||
| tgl_permintaan | date | No | ||||
| nama_tukang | varchar(50) | No | ||||
| status | int | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_pembelian | 2236 | A | No |
pengeluaran
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int | No | ||||
| unit | varchar(20) | No | ||||
| kode_brg | varchar(8) | No | ||||
| jumlah | int | No | ||||
| tgl_keluar | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 17174 | A | No |
permintaan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_permintaan (Primary) | int | No | ||||
| unit | varchar(20) | No | ||||
| kode_brg | varchar(8) | No | ||||
| id_jenis | int | No | ||||
| jumlah | int | No | ||||
| tgl_permintaan | date | No | ||||
| nama_tukang | varchar(20) | No | ||||
| status | int | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_permintaan | 20000 | A | No |
sementara
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_sementara (Primary) | int | No | ||||
| unit | varchar(50) | No | ||||
| kode_brg | varchar(5) | No | ||||
| id_jenis | int | No | ||||
| jumlah | int | No | ||||
| tgl_permintaan | date | No | ||||
| nama_tukang | varchar(20) | No | ||||
| status | int | No | 0 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_sementara | 0 | A | No |
stokbarang
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| kode_brg (Primary) | varchar(9) | No | ||||
| id_jenis | int | No | ||||
| nama_brg | varchar(252) | No | ||||
| satuan | varchar(50) | Yes | NULL | |||
| stok | int | No | ||||
| keluar | int | Yes | 0 | |||
| sisa | int | No | ||||
| tgl_masuk | date | No | ||||
| suplier | varchar(20) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | kode_brg | 747 | A | No |
user
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_user (Primary) | int | No | ||||
| username | varchar(20) | No | ||||
| password | varchar(255) | No | ||||
| level | enum('unit_pelayanan', 'admin', 'admin_gudang', 'asisten_manajer') | No | ||||
| manajer | varchar(50) | No | ||||
| asmen | varchar(50) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_user | 45 | A | No |