BD.ASR SEGMENTOS

2 Campos

2.1 ID

INT(11) NOT NULL AUTO_INCREMENT,

2.2 ID_SEGMENTO

INT(11) NULL DEFAULT NULL,

2.3 C_UCID

VARCHAR(32) CHARACTER SET 'utf8' NULL DEFAULT NULL,

2.4 C_COD_CLIENTE

VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL,

2.5 D_HORA_INICIO

DATETIME NULL DEFAULT NULL,

2.6 D_HORA_FIN

DATETIME NULL DEFAULT NULL,

2.7 N_DURACION

INT(11) NULL DEFAULT NULL,

2.8 C_DIALOG_ID

VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL,

2.9 C_CATEGORIA_1

VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL,

2.10 L_CONFIANZA_1

DOUBLE NULL DEFAULT NULL,

2.11 C_CATEGORIA_2

VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL,

2.12 L_CONFIANZA_2

DOUBLE NULL DEFAULT NULL,

2.13 C_CATEGORIA_3

VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL,

2.14 L_CONFIANZA_3

DOUBLE NULL DEFAULT NULL,

2.15 C_CATEGORIA_4

VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL,

2.16 L_CONFIANZA_4

DOUBLE NULL DEFAULT NULL,

2.17 N_NUM_MEJOR

INT(11) NULL DEFAULT NULL,

2.18 C_TRANSCRIPCION

VARCHAR(1045) CHARACTER SET 'utf8' NULL DEFAULT NULL,

2.19 C_MODIFICACION_CATEGORIA

VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL,

2.20 B_ERROR

TINYINT(1) NULL DEFAULT NULL,

2.21 B_ERROR_REC_VOZ

TINYINT(1) NULL DEFAULT NULL,

2.22 B_ERROR_SILENCIO_VOZ

TINYINT(1) NULL DEFAULT NULL,

2.23 B_ERROR_REC_DTMF

TINYINT(1) NULL DEFAULT NULL,

2.24 B_ERROR_SILENCIO_DTMF

TINYINT(1) NULL DEFAULT NULL,

2.25 C_APLICACION

VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL,

2.26 C_GRAMATICA

VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL,

2.27 C_SERVIDOR

VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL,

2.28 N_VAL_1

INT(11) NULL DEFAULT NULL,

2.29 C_VAL_1

VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL,

2.30 N_VAL_2

INT(11) NULL DEFAULT NULL,

2.31 C_VAL_2

VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL,

2.32 N_VAL_3

INT(11) NULL DEFAULT NULL,

2.33 C_VAL_3

VARCHAR(45) CHARACTER SET 'utf8' NULL DEFAULT NULL,

3 índices

 PRIMARY KEY (`ID`)