barang
| Column | Type | Null | Default | Links to | Comments |
|---|
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 |
|---|
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 |
|---|
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 |
|---|
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 |
|---|
detail_terima
| Column | Type | Null | Default | Links to | Comments |
|---|
inventaris
| Column | Type | Null | Default | Links to | Comments |
|---|
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 |
|---|
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 |
|---|
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 |
|---|
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 |
|---|
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 |
|---|
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |