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 |