| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| id_barang (Primary) | int(11) | No | ||||
| kode_barang | varchar(10) | Yes | NULL | |||
| nama_barang | varchar(50) | Yes | NULL | |||
| ukuran | varchar(10) | No | ||||
| harga | int(11) | Yes | NULL | |||
| stok | int(5) | Yes | NULL | |||
| foto_barang | varchar(100) | Yes | NULL | |||
| id_jenis | int(11) | Yes | NULL | |||
| id_merk | int(11) | Yes | NULL | |||
| kode_supplier | varchar(10) | Yes | NULL |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_barang | 30 | A | No |
| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| id_barang_keluar (Primary) | int(11) | No | ||||
| kode_barang | varchar(20) | Yes | NULL | |||
| nama_barang | varchar(100) | No | ||||
| ukuran | varchar(10) | No | ||||
| keperluan_acara | varchar(100) | No | ||||
| tgl_keluar | date | Yes | NULL | |||
| jumlah | int(11) | Yes | NULL |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_barang_keluar | 68 | A | No |
| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| id_barang_masuk (Primary) | int(11) | No | ||||
| kode_barang | varchar(100) | Yes | NULL | |||
| kode_supplier | varchar(100) | Yes | NULL | |||
| ukuran | varchar(10) | No | ||||
| jumlah | int(3) | Yes | NULL | |||
| harga | int(10) | Yes | NULL | |||
| nama_barang | varchar(100) | No | ||||
| nama_supplier | varchar(100) | No | ||||
| tanggal_masuk | date | No |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_barang_masuk | 10 | A | No |
| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| kode_transaksi | varchar(10) | Yes | NULL | |||
| kode_barang | varchar(10) | Yes | NULL | |||
| qty | int(5) | Yes | NULL |
No index defined!
| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| id_jenis (Primary) | int(11) | No | ||||
| jenis_barang | varchar(50) | Yes | NULL |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_jenis | 0 | A | No |
| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| id_merk (Primary) | int(11) | No | ||||
| merk_barang | varchar(50) | Yes | NULL |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_merk | 2 | A | No |
| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| id_supplier (Primary) | int(11) | No | ||||
| kode_supplier | varchar(10) | Yes | NULL | |||
| nama_supplier | varchar(50) | Yes | NULL | |||
| username | varchar(50) | No | ||||
| password | varchar(50) | No |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_supplier | 3 | A | No |
| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| id_transaksi (Primary) | int(11) | No | ||||
| kode_transaksi | varchar(10) | Yes | NULL | |||
| tgl_transaksi | date | Yes | NULL | |||
| total_harga | int(11) | Yes | NULL |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_transaksi | 0 | A | No |
| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| id_user (Primary) | int(11) | No | ||||
| nama_user | varchar(100) | Yes | NULL | |||
| username | varchar(50) | Yes | NULL | |||
| password | varchar(50) | Yes | NULL | |||
| level | varchar(20) | Yes | NULL |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_user | 4 | A | No |