| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| id (Primary) | int(10) | No | ||||
| detail_paket | varchar(80) | No | ||||
| id_judul_paket | int(10) | No | ||||
| internet | varchar(40) | No | ||||
| phone | varchar(40) | No | ||||
| usee_tv | varchar(40) | No | ||||
| ont | varchar(30) | No | ||||
| stb | varchar(30) | No | ||||
| add_on | varchar(60) | No | ||||
| price_normal | int(10) | No | ||||
| price_gimmick | varchar(70) | No | ||||
| target | varchar(300) | No | ||||
| sales_channel | varchar(60) | No | ||||
| kode_paket | varchar(1500) | No | ||||
| ketentuan_paket | varchar(1500) | No | ||||
| tanggal_expired | date | No |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 98 | A | No | |
| id_judul_paket | BTREE | No | No | id_judul_paket | 98 | A | No |
| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| id_paket (Primary) | int(10) | No | ||||
| nama_paket | varchar(150) | No | ||||
| tanggal_berlaku | date | No | ||||
| tanggal_expired | date | No | ||||
| kawasan | varchar(40) | No | ||||
| channel | varchar(700) | No |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_paket | 27 | A | No |
| 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 | 0 | A | No | |
| id_user | BTREE | No | No | userid | 0 | A | No | |
| nama | BTREE | No | No | username | 0 | 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 | 5 | A | No |
| Column | Type | Null | Default | Links to | Comments | Media type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| username | varchar(128) | No | ||||
| varchar(128) | No | |||||
| image | varchar(128) | No | ||||
| password | varchar(256) | No | ||||
| role_id | int(11) | No | ||||
| is_active | int(1) | No | ||||
| date_created | int(11) | No |
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2 | A | No |