bulan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_bulan (Primary) | int(11) | No | ||||
| nama_bulan | varchar(100) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_bulan | 12 | A | No |
detail_laporan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_detail_laporan (Primary) | int(11) | No | ||||
| keterangan | varchar(255) | No | ||||
| id_jenis_laporan | int(11) | No | jenis_laporan -> id_jenis_laporan |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_detail_laporan | 21 | A | No | |
| id_jenis_laporan | BTREE | No | No | id_jenis_laporan | 7 | A | No |
jenis_laporan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_jenis_laporan (Primary) | int(11) | No | ||||
| jenis_laporan | varchar(255) | No | ||||
| kategori | varchar(100) | No | ||||
| id_unit | int(11) | No | unit -> id_unit |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_jenis_laporan | 9 | A | No | |
| id_unit | BTREE | No | No | id_unit | 9 | A | No |
nilai
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_nilai (Primary) | int(11) | No | ||||
| id_detail_laporan | int(11) | No | detail_laporan -> id_detail_laporan | |||
| bulan | int(11) | No | bulan -> id_bulan | |||
| tahun | int(11) | No | ||||
| nilai | double | No | ||||
| waktu_isi | datetime | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_nilai | 21 | A | No | |
| bulan | BTREE | No | No | bulan | 4 | A | No | |
| id_detail_laporan | BTREE | No | No | id_detail_laporan | 21 | A | No |
unit
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_unit (Primary) | int(11) | No | ||||
| nama_unit | varchar(255) | No | ||||
| kode_unit | varchar(100) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_unit | 12 | A | No |
user
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_user (Primary) | int(11) | No | ||||
| nama_user | varchar(255) | No | ||||
| password | varchar(255) | No | ||||
| username | varchar(100) | No | ||||
| id_unit | int(11) | No | unit -> id_unit |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_user | 16 | A | No | |
| id_unit | BTREE | No | No | id_unit | 16 | A | No |