BD.MYS QUEUE MEMBER

2 Campos

2.1 ID

INT(11) NOT NULL AUTO_INCREMENT,

2.2 FECHA

VARCHAR(8) NULL,

2.3 HORA

VARCHAR(6) NULL,

2.4 QUEUE

VARCHAR(32) NULL DEFAULT NULL,

2.5 VNAME

VARCHAR(64) NULL DEFAULT NULL,

2.6 VLOCATION

VARCHAR(64) NULL DEFAULT NULL,

2.7 VMEMBERSHIP

VARCHAR(64) NULL DEFAULT NULL,

2.8 VPENALTY

INT(11) NULL DEFAULT NULL,

2.9 VCALLS_TAKEN

INT(11) NULL DEFAULT NULL,

2.10 VLAST_CALL

INT(11) NULL DEFAULT NULL,

2.11 VSTATUS

INT(11) NULL DEFAULT NULL,

2.12 VPAUSED

INT(11) NULL DEFAULT NULL,

2.13 ACTUAL

INT(11) NULL DEFAULT NULL,

3 índices

 PRIMARY KEY (`ID`),
 UNIQUE INDEX `IX_QUEUE_MEMBER_QLM` (`QUEUE` ASC, `VLOCATION` ASC),
 INDEX `IX_QUEUE_MEMBER_QUEUE` (`QUEUE` ASC)