layanan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_layanan (Primary) | int | No | ||||
| layanan | varchar(50) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_layanan | 2 | A | No |
pengiriman
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_pengiriman (Primary) | int | No | ||||
| id_layanan | varchar(50) | No | ||||
| id_tujuan | varchar(50) | No | ||||
| tanggal_pengiriman | date | No | ||||
| tanggal_kedatangan | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_pengiriman | 0 | A | No |
tujuan
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_tujuan (Primary) | int | No | ||||
| tujuan | varchar(150) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_tujuan | 81 | A | No |
user
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id_pengguna (Primary) | int | No | ||||
| username | varchar(50) | No | ||||
| password | varchar(150) | No | ||||
| nama | varchar(50) | No | ||||
| alamat | varchar(50) | No | ||||
| no_tlp | varchar(50) | No | ||||
| level | varchar(15) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_pengguna | 0 | A | No |