Diferencia entre revisiones de «BD.MYS QUEUE MEMBER»
De VIVAitwiki
Ir a la navegaciónIr a la búsqueda (Página creada con «==Descripción== ==Campos== ==índices== ==índices réplica==») |
|||
| Línea 2: | Línea 2: | ||
==Campos== | ==Campos== | ||
| + | |||
| + | ===ID=== | ||
| + | INT(11) NOT NULL AUTO_INCREMENT, | ||
| + | ===FECHA=== | ||
| + | VARCHAR(8) NULL, | ||
| + | ===HORA=== | ||
| + | VARCHAR(6) NULL, | ||
| + | ===QUEUE=== | ||
| + | VARCHAR(32) NULL DEFAULT NULL, | ||
| + | ===VNAME=== | ||
| + | VARCHAR(64) NULL DEFAULT NULL, | ||
| + | ===VLOCATION=== | ||
| + | VARCHAR(64) NULL DEFAULT NULL, | ||
| + | ===VMEMBERSHIP=== | ||
| + | VARCHAR(64) NULL DEFAULT NULL, | ||
| + | ===VPENALTY=== | ||
| + | INT(11) NULL DEFAULT NULL, | ||
| + | ===VCALLS_TAKEN=== | ||
| + | INT(11) NULL DEFAULT NULL, | ||
| + | ===VLAST_CALL=== | ||
| + | INT(11) NULL DEFAULT NULL, | ||
| + | ===VSTATUS=== | ||
| + | INT(11) NULL DEFAULT NULL, | ||
| + | ===VPAUSED=== | ||
| + | INT(11) NULL DEFAULT NULL, | ||
| + | ===ACTUAL=== | ||
| + | INT(11) NULL DEFAULT NULL, | ||
==índices== | ==índices== | ||
| + | |||
| + | PRIMARY KEY (`ID`), | ||
| + | UNIQUE INDEX `IX_QUEUE_MEMBER_QLM` (`QUEUE` ASC, `VLOCATION` ASC), | ||
| + | INDEX `IX_QUEUE_MEMBER_QUEUE` (`QUEUE` ASC) | ||
==índices réplica== | ==índices réplica== | ||
Revisión actual del 14:42 2 mar 2016
Sumario
1 Descripción
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)
