| id |
int(10)
|
|
|
|
| nama |
varchar(160)
|
utf8_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| harga |
varchar(20)
|
utf8_general_ci
|
|
|
| jumlah |
varchar(20)
|
utf8_general_ci
|
|
|
| kode |
varchar(30)
|
utf8_general_ci
|
|
|
| no_faktur |
varchar(80)
|
utf8_general_ci
|
|
|
| tanggal |
date
|
|
|
|
| total |
varchar(20)
|
utf8_general_ci
|
|
|
| user |
varchar(120)
|
utf8_general_ci
|
|
|
| sup |
varchar(80)
|
utf8_general_ci
|
|
|
| no_transaksi |
varchar(30)
|
utf8_general_ci
|
|
|
| nama_bahan |
varchar(160)
|
utf8_general_ci
|
|
|
| supplier_id |
varchar(30)
|
utf8_general_ci
|
|
|
| supplier_nama |
varchar(160)
|
utf8_general_ci
|
|
|
| harga_satuan |
decimal(15,2)
|
|
|
|
| keterangan |
text
|
utf8_general_ci
|
|
|
| petugas |
varchar(120)
|
utf8_general_ci
|
|
|
| nama2 |
varchar(160)
|
utf8_general_ci
|
|
|
| hargas |
varchar(20)
|
utf8_general_ci
|
|
|
| ex |
date
|
|
|
|
| ket |
text
|
utf8_general_ci
|
|
|
| kasir |
varchar(80)
|
utf8_general_ci
|
|
|
