fmc

data_mia_order_detail

Column	Type	Null	Default	Links to	Comments	Media type
ORDER_CODE	varchar(50)	Yes	NULL
NAME	varchar(32)	Yes	NULL
DESCRIPTION	varchar(250)	Yes	NULL
STATUS_VERIFIKASI	text	Yes	NULL
XS14	text	Yes	NULL
XS15	text	Yes	NULL

No index defined!

data_re_ps_orbit_daily_kpro

Column	Type	Null	Default	Links to	Comments	Media type
STO	varchar(20)	Yes	NULL
UNIT	varchar(16)	Yes	NULL
TANGGAL	varchar(8)	Yes	NULL
PERIODE	varchar(6)	Yes	NULL
REG	double	Yes	NULL
PS	double	Yes	NULL

No index defined!

data_re_sales_daily_kpro

Column	Type	Null	Default	Links to	Comments	Media type
STO	varchar(20)	Yes	NULL
UNIT	varchar(16)	Yes	NULL
TANGGAL	varchar(8)	Yes	NULL
PERIODE	varchar(8)	Yes	NULL
REG	double	Yes	NULL
PS	double	Yes	NULL

No index defined!

data_re_sales_daily_kpro_fbb

Column	Type	Null	Default	Links to	Comments	Media type
STO	varchar(20)	Yes	NULL
UNIT	varchar(16)	Yes	NULL
TANGGAL	varchar(32)	Yes	NULL
PERIODE	varchar(24)	Yes	NULL
REG	double	Yes	NULL
PS	double	Yes	NULL

No index defined!

data_re_sales_orbit_daily_kpro

Column	Type	Null	Default	Links to	Comments	Media type
STO	varchar(20)	Yes	NULL
UNIT	varchar(16)	Yes	NULL
TANGGAL	varchar(8)	Yes	NULL
PERIODE	varchar(6)	Yes	NULL
REG	double	Yes	NULL
PS	double	Yes	NULL

No index defined!

data_sales_daily

Column	Type	Null	Default	Links to	Comments	Media type
STO	varchar(15)	Yes	NULL
NEW_CHANEL	varchar(50)	Yes	NULL
CHANNEL	varchar(32)	Yes	NULL
REG	char(1)	Yes	NULL
WITEL	varchar(50)	Yes	NULL
CITEM_SPEEDY	varchar(30)	Yes	NULL
PERIODE	varchar(200)	Yes	NULL
CSEG	varchar(2)	Yes	NULL
STATUS_INDIHOME	varchar(30)	Yes	NULL
DESC_PACK	varchar(150)	Yes	NULL
CPACK	varchar(10)	Yes	NULL
JML	bigint(20)	Yes	NULL

No index defined!

data_sales_daily_orbit_kpro_bot

Column	Type	Null	Default	Links to	Comments	Media type
STO	varchar(20)	Yes	NULL
UNIT	varchar(16)	Yes	NULL
TANGGAL	varchar(8)	Yes	NULL
PERIODE	varchar(8)	Yes	NULL
REG	double	Yes	NULL
PS	double	Yes	NULL

No index defined!

data_sales__jitu1_50mbps_daily_kpro

Column	Type	Null	Default	Links to	Comments	Media type
STO	varchar(20)	Yes	NULL
UNIT	varchar(16)	Yes	NULL
TANGGAL	varchar(32)	Yes	NULL
PERIODE	varchar(24)	Yes	NULL
REG	double	Yes	NULL
PS	double	Yes	NULL

No index defined!

data_sc_order_detail

Column	Type	Null	Default	Links to	Comments	Media type
ORDER_ID	varchar(50)	Yes	NULL
DEVICE_ID	text	Yes	NULL
ORDER_DATE	datetime	Yes	NULL
TGL_PS	datetime	Yes	NULL
LAST_UPDATED_DATE	datetime	Yes	NULL
STATUS_RESUME	varchar(60)	Yes	NULL
SF_ID	varchar(52)	Yes	NULL

No index defined!

fmc_log_jobs

Column	Type	Null	Default	Links to	Comments	Media type
ID_JOB	int(11)	Yes	NULL
CHANNEL_ID	varchar(255)	Yes	NULL
JOBNAME	varchar(255)	Yes	NULL
STATUS	varchar(15)	Yes	NULL
LINES_READ	bigint(20)	Yes	NULL
LINES_WRITTEN	bigint(20)	Yes	NULL
LINES_UPDATED	bigint(20)	Yes	NULL
LINES_INPUT	bigint(20)	Yes	NULL
LINES_OUTPUT	bigint(20)	Yes	NULL
LINES_REJECTED	bigint(20)	Yes	NULL
ERRORS	bigint(20)	Yes	NULL
STARTDATE	datetime	Yes	NULL
ENDDATE	datetime	Yes	NULL
LOGDATE	datetime	Yes	NULL
DEPDATE	datetime	Yes	NULL
REPLAYDATE	datetime	Yes	NULL
LOG_FIELD	mediumtext	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
IDX_fmc_log_jobs_1	BTREE	No	No	ID_JOB	1153	A	Yes
IDX_fmc_log_jobs_2	BTREE	No	No	ERRORS	8	A	Yes
				STATUS	12	A	Yes
				JOBNAME	20	A	Yes

param_area_fmc

Column	Type	Null	Default	Links to	Comments	Media type
STO	varchar(3)	Yes	NULL
STO_conf_BU	varchar(9)	Yes	NULL
Duplicate_Flag	varchar(4)	Yes	NULL
NAMA_STO	varchar(29)	Yes	NULL
WITEL	varchar(16)	Yes	NULL
DATEL	varchar(20)	Yes	NULL
KAB_TELKOM	varchar(26)	Yes	NULL
KAB_TSEL	varchar(26)	Yes	NULL
CLUSTER	varchar(23)	Yes	NULL
BRANCH	varchar(16)	Yes	NULL
BRANCH_61_FMC	varchar(16)	Yes	NULL
REGIONAL	varchar(17)	Yes	NULL
AREA	varchar(6)	Yes	NULL
REGION_SAP	varchar(17)	Yes	NULL
CHECKS	varchar(20)	Yes	NULL
VERSION	varchar(1)	Yes	NULL

No index defined!

target_fmc_orbit_2024

Column	Type	Null	Default	Links to	Comments	Media type
AREA	varchar(6)	Yes	NULL
REGION	varchar(17)	Yes	NULL
BRANCH	varchar(16)	Yes	NULL
JAN	bigint(20)	Yes	NULL
FEB	bigint(20)	Yes	NULL
MAR	bigint(20)	Yes	NULL
APR	bigint(20)	Yes	NULL
MAY	bigint(20)	Yes	NULL
JUN	bigint(20)	Yes	NULL
JUL	bigint(20)	Yes	NULL
AUG	bigint(20)	Yes	NULL
SEP	bigint(20)	Yes	NULL
OCT	bigint(20)	Yes	NULL
NOV	bigint(20)	Yes	NULL
DES	bigint(20)	Yes	NULL
H1	bigint(20)	Yes	NULL
H2	bigint(20)	Yes	NULL
Total	bigint(20)	Yes	NULL

No index defined!

target_fmc_sales_2023

Column	Type	Null	Default	Links to	Comments	Media type
AREA	varchar(36)	Yes	NULL
REGION	varchar(37)	Yes	NULL
BRANCH	varchar(36)	Yes	NULL
JAN	bigint(20)	Yes	NULL
FEB	bigint(20)	Yes	NULL
MAR	bigint(20)	Yes	NULL
APR	bigint(20)	Yes	NULL
MAY	bigint(20)	Yes	NULL
JUN	bigint(20)	Yes	NULL
JUL	bigint(20)	Yes	NULL
AUG	bigint(20)	Yes	NULL
SEP	bigint(20)	Yes	NULL
OCT	bigint(20)	Yes	NULL
NOV	bigint(20)	Yes	NULL
DES	bigint(20)	Yes	NULL
H1	bigint(20)	Yes	NULL
H2	bigint(20)	Yes	NULL
Total	bigint(20)	Yes	NULL

No index defined!

target_fmc_sales_orbit_fbb

Column	Type	Null	Default	Links to	Comments	Media type
AREA	varchar(26)	Yes	NULL
REGION	varchar(27)	Yes	NULL
BRANCH	varchar(26)	Yes	NULL
JAN	bigint(20)	Yes	NULL
FEB	bigint(20)	Yes	NULL
MAR	bigint(20)	Yes	NULL
APR	bigint(20)	Yes	NULL
MAY	bigint(20)	Yes	NULL
JUN	bigint(20)	Yes	NULL
JUL	bigint(20)	Yes	NULL
AUG	bigint(20)	Yes	NULL
SEP	bigint(20)	Yes	NULL
OCT	bigint(20)	Yes	NULL
NOV	bigint(20)	Yes	NULL
DEC	bigint(20)	Yes	NULL

No index defined!

Open new phpMyAdmin window