dashboard_weekly

channel

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

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No ID 63367 A No

detail_paket

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

Indexes

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

judul_paket

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

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_paket 26 A No

sales

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

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No ID 50874 A No

user

Column Type Null Default Links to Comments Media type
id (Primary) int(11) No
username varchar(128) No
email 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

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id 2 A No

user_role

Column Type Null Default Links to Comments Media type
id (Primary) int(11) No
role varchar(128) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id 2 A No