admin
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_admin (Primary) | int | No | ||||
| nama | varchar(40) | No | ||||
| varchar(40) | No | |||||
| pass | varchar(40) | No | ||||
| level | varchar(12) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_admin | 25 | A | No |
catatan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_catatan (Primary) | int | No | ||||
| catatan | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_catatan | 4 | A | No |
hutang
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_hutang (Primary) | int | No | ||||
| jumlah | int | No | ||||
| tgl_hutang | date | No | ||||
| alasan | text | No | ||||
| penghutang | varchar(40) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_hutang | 15 | A | No |
karyawan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_karyawan (Primary) | int | No | ||||
| nama | varchar(40) | No | ||||
| posisi | varchar(40) | No | ||||
| alamat | varchar(40) | No | ||||
| umur | int | No | ||||
| kontak | varchar(40) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_karyawan | 2 | A | No |
pemasukan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_pemasukan (Primary) | int | No | ||||
| tgl_pemasukan | date | No | ||||
| jumlah | int | No | ||||
| id_sumber | varchar(250) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_pemasukan | 2 | A | No | |
| id_sumber | BTREE | No | No | id_sumber | 2 | A | No |
pengeluaran
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_pengeluaran (Primary) | int | No | ||||
| tgl_pengeluaran | date | No | ||||
| jumlah | int | No | ||||
| id_sumber | int | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_pengeluaran | 18 | A | No | |
| id_sumber | BTREE | No | No | id_sumber | 5 | A | No |
sumber
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_sumber (Primary) | int | No | ||||
| nama | varchar(250) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_sumber | 2 | A | No |
uang
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_uang (Primary) | int | No | ||||
| tgl_uang | date | No | ||||
| id_pengeluaran | int | Yes | NULL | |||
| id_pendapatan | int | Yes | NULL | |||
| jumlah | int | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_uang | 2 | A | No |