fmc_bot

data_mia_order_detail

Column Type Null Default Links to Comments Media type
ORDER_CODE varchar(24) No
NAME varchar(32) Yes NULL
DESCRIPTION varchar(64) Yes NULL
STATUS_VERIFIKASI text Yes NULL
XS14 text Yes NULL
XS15 text Yes NULL
ORDER_ID (Primary) double No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No ORDER_ID 605532 A No
ORDER_CODE BTREE No No ORDER_CODE 605532 A No

data_mydita_order_detail

Column Type Null Default Links to Comments Media type
ORDER_CODE varchar(50) No
NAME varchar(100) Yes NULL
DESCRIPTION varchar(250) Yes NULL
STATUS_VERIFIKASI text Yes NULL
XS15 text Yes NULL
XS17 text Yes NULL
ORDER_DESC text Yes NULL
CREATE_DTM datetime Yes NULL
XS14 text Yes NULL
XS1 text Yes NULL
XS2 varchar(64) Yes NULL
LAST_CALL varchar(19) Yes NULL
ORDER_ID (Primary) double No
SF_ID varchar(15) Yes NULL

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No ORDER_ID 686904 A No
ORDER_CODE BTREE No No ORDER_CODE 686904 A No
SF_ID BTREE No No SF_ID 32709 A Yes
CREATE_DTM BTREE No No CREATE_DTM 686904 A Yes

data_sc_order_detail

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

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No ORDER_ID 575012 A No
DEVICE_ID BTREE No No DEVICE_ID (768) 575012 A Yes

data_user

Column Type Null Default Links to Comments Media type
id_user (Primary) int(11) No
nama varchar(150) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id_user 3149 A No
nama BTREE No No nama 3149 A No

log_class_sf

Column Type Null Default Links to Comments Media type
Agency varchar(81) Yes NULL
kode_sf varchar(8) Yes NULL
Area varchar(7) Yes NULL
Region varchar(17) Yes NULL
Branch varchar(16) Yes NULL
WOK varchar(26) Yes NULL
JML_PS varchar(6) Yes NULL
LoS varchar(3) Yes NULL
NEW_CLASS varchar(9) Yes NULL
UPDATE_CLASS varchar(24) Yes NULL

No index defined!

log_usage_bot

Column Type Null Default Links to Comments Media type
Id (Primary) int(11) No
id_user varchar(120) No
nama_user varchar(120) No
tgl_input datetime No
command varchar(250) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Id 232490 A No