| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| id_sppd (Primary) | int(10) | No | ||||
| userid | int(10) | No | ||||
| username | varchar(50) | No | ||||
| agenda | varchar(100) | No | ||||
| dari | varchar(50) | No | ||||
| tujuan | varchar(50) | No | ||||
| tanggal | date | No | ||||
| tanggal_selesai | date | No | ||||
| jumlah_sppd | varchar(20) | No | ||||
| status | varchar(50) | Yes | NULL |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_sppd | 1 | A | No | |
| id_user | BTREE | No | No | userid | 1 | A | No | |
| nama | BTREE | No | No | username | 1 | A | No |
| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| user_id (Primary) | int(11) | No | ||||
| user_name | varchar(20) | Yes | NULL | |||
| user_email | varchar(60) | Yes | NULL | |||
| user_password | varchar(40) | Yes | NULL | |||
| user_level | varchar(3) | Yes | NULL |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | user_id | 6 | A | No |