barang
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| kode_barang | varchar(20) | Yes | NULL | |||
| nama_barang | varchar(80) | Yes | NULL | |||
| no_pinjaman | int(100) | No | ||||
| no_jaminan | int(100) | No | ||||
| kantor_cabang | varchar(100) | No | ||||
| stok | int(11) | Yes | NULL | |||
| satuan | varchar(20) | Yes | NULL | |||
| keterangan | char(50) | No | ||||
| tgl_masuk | datetime | Yes | NULL | |||
| tgl_keluar | timestamp | Yes | CURRENT_TIMESTAMP | |||
| gambar | text | No | ||||
| jumlah_keluar | int(11) | No | ||||
| status | int(1) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 6 | A | No |
barangkeluar
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| tgl_keluar | date | Yes | NULL | |||
| jam_keluar | varchar(10) | Yes | NULL | |||
| jumlah_keluar | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
customer
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| kode | varchar(20) | Yes | NULL | |||
| nama | varchar(80) | Yes | NULL | |||
| varchar(100) | Yes | NULL | ||||
| telepon | varchar(15) | Yes | NULL | |||
| alamat | varchar(255) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2 | A | No |
data_toko
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| nama_toko | varchar(80) | Yes | NULL | |||
| nama_pemilik | varchar(80) | Yes | NULL | |||
| no_telepon | varchar(15) | Yes | NULL | |||
| alamat | varchar(255) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
detail_keluar
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| no_keluar | varchar(25) | Yes | NULL | |||
| nama_barang | varchar(80) | Yes | NULL | |||
| jumlah | int(11) | Yes | NULL | |||
| satuan | varchar(20) | Yes | NULL | |||
| gambar | text | No | ||||
| keterangan | char(50) | No |
detail_terima
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| no_terima | varchar(25) | Yes | NULL | |||
| nama_barang | varchar(80) | Yes | NULL | |||
| jumlah | int(11) | Yes | NULL | |||
| satuan | varchar(20) | Yes | NULL | |||
| keterangan | char(50) | No |
inventaris
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| kode_barang | varchar(20) | Yes | NULL | |||
| nama_barang | varchar(80) | Yes | NULL | |||
| stok | int(11) | Yes | NULL | |||
| satuan | varchar(20) | Yes | NULL | |||
| keterangan | char(50) | No | ||||
| tgl_masuk | datetime | Yes | NULL | |||
| gambar | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2 | A | No |
penerimaan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| no_terima | varchar(25) | Yes | NULL | |||
| tgl_terima | varchar(25) | Yes | NULL | |||
| jam_terima | varchar(10) | Yes | NULL | |||
| nama_customer | varchar(80) | Yes | NULL | |||
| nama_petugas | varchar(80) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 3 | A | No | |
| no_terima | BTREE | No | No | no_terima | 3 | A | Yes |
pengeluaran
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| no_keluar | varchar(25) | Yes | NULL | |||
| tgl_keluar | varchar(25) | Yes | NULL | |||
| jam_keluar | varchar(10) | Yes | NULL | |||
| nama_customer | varchar(80) | Yes | NULL | |||
| nama_petugas | varchar(80) | Yes | NULL | |||
| gambar | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
| no_keluar | BTREE | No | No | no_keluar | 0 | A | Yes |
pengguna
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| kode | varchar(20) | Yes | NULL | |||
| nama | varchar(100) | Yes | NULL | |||
| username | varchar(20) | Yes | NULL | |||
| password | varchar(255) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
petugas
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| kode | varchar(20) | Yes | NULL | |||
| nama | varchar(100) | Yes | NULL | |||
| username | varchar(20) | Yes | NULL | |||
| password | varchar(255) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 3 | A | No |
supplier
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| kode | varchar(20) | Yes | NULL | |||
| nama | varchar(80) | Yes | NULL | |||
| varchar(100) | Yes | NULL | ||||
| telepon | varchar(15) | Yes | NULL | |||
| alamat | varchar(255) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |