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 |
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 |
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 |
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 |
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 |
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 |
Column | Type | Null | Default | Links to | Comments | Media type |
---|---|---|---|---|---|---|
id_user (Primary) | int(11) | No | ||||
nama | varchar(150) | No |
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 |
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!
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | Id | 232490 | A | No |