BD.DAV CALENDARIOS

2 Campos

2.1 ID

INT UNSIGNED NOT NULL AUTO_INCREMENT,

2.2 C_NOMBRE

VARCHAR(45) NULL,

2.3 ID_CUENTA

INT UNSIGNED NOT NULL,

Este campo no se usa, Se borrara en futuras versiones

2.4 ID_NODO

INT NULL,

2.5 N_CTAG

INT UNSIGNED NOT NULL DEFAULT 0,

2.6 C_DESCRIPCION

VARCHAR(255) NULL,

2.7 N_ORDEN

INT UNSIGNED NOT NULL DEFAULT 0,

2.8 C_CALENDARCOLOR

VARCHAR(45) NULL,

2.9 C_TIMEZONE

VARCHAR(45) NULL,

2.10 C_COMPONENTES

VARCHAR(45) NULL,

2.11 B_TRANSPARENTE

TINYINT(1) NOT NULL DEFAULT 0,

2.12 N_REFRESH

INT UNSIGNED NULL,

2.13 N_TIMEFRAME

INT UNSIGNED NULL COMMENT 'minutos',

2.14 E_USOASTERISK

INT NULL COMMENT 'TUsoAsterisk',

3 índices

 PRIMARY KEY (`ID`),
 UNIQUE INDEX `UDX_NOMBRE_CUENTA` (`ID_CUENTA` ASC, `C_NOMBRE` ASC)