Column | Type | Null | Default | Links to | Comments | Media type |
---|---|---|---|---|---|---|
ID (Primary) | int(11) | No | ||||
STATUS | varchar(10) | Yes | NULL | |||
STATUS_DEMAND | varchar(128) | Yes | NULL | |||
CPACK | varchar(10) | Yes | NULL | |||
CITEM_SPEEDY | varchar(30) | Yes | NULL | |||
TGL | varchar(200) | Yes | NULL | |||
KAWASAN | varchar(30) | Yes | NULL | |||
WITEL | varchar(50) | Yes | NULL | |||
C_WITEL | bigint(20) | Yes | NULL | |||
JENIS | varchar(2) | Yes | NULL | |||
FLAG | varchar(26) | Yes | NULL | |||
CHANEL | varchar(13) | Yes | NULL | |||
NEWSALES | decimal(38,0) | Yes | NULL | |||
MIGRASI | decimal(38,0) | Yes | NULL | |||
UPDOWN | decimal(38,0) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 63367 | A | No |
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 | 92 | A | No | |
id_judul_paket | BTREE | No | No | id_judul_paket | 92 | 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(40) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id_paket | 26 | A | No |
Column | Type | Null | Default | Links to | Comments | Media type |
---|---|---|---|---|---|---|
ID (Primary) | int(11) | No | ||||
KAWASAN | varchar(30) | Yes | NULL | |||
WITEL | varchar(50) | Yes | NULL | |||
C_WITEL | double | Yes | NULL | |||
CPACK | varchar(10) | Yes | NULL | |||
CITEM_SPEEDY | varchar(30) | Yes | NULL | |||
CITEM_UPD | varchar(10) | Yes | NULL | |||
PERIODE | varchar(200) | Yes | NULL | |||
STATUS_DEMAND | varchar(128) | Yes | NULL | |||
STATUS2 | varchar(100) | Yes | NULL | |||
JENIS | varchar(2) | Yes | NULL | |||
CSEG | varchar(2) | Yes | NULL | |||
ID_ALPRO | varchar(14) | Yes | NULL | |||
CHANEL | varchar(32) | Yes | NULL | |||
PSBLN | decimal(38,0) | Yes | NULL | |||
CHURN | decimal(38,0) | Yes | NULL | |||
UPDOWN | decimal(38,0) | Yes | NULL | |||
MIGRASI | decimal(38,0) | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | ID | 50874 | 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 |
Column | Type | Null | Default | Links to | Comments | Media type |
---|---|---|---|---|---|---|
id (Primary) | int(11) | No | ||||
role | varchar(128) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 2 | A | No |