Diferencia entre revisiones de «BD.DAV CALENDARIO ENTRADAS»
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 UNSIGNED NOT NULL AUTO_INCREMENT, | ||
| + | ===ID_CALENDARIO=== | ||
| + | INT UNSIGNED NOT NULL, | ||
| + | ===C_URI=== | ||
| + | VARCHAR(45) NULL, | ||
| + | ===N_LASTMODIFIED=== | ||
| + | INT UNSIGNED NULL, | ||
| + | ===C_ETAG=== | ||
| + | VARCHAR(45) NULL, | ||
| + | ===N_TAM=== | ||
| + | INT UNSIGNED NOT NULL, | ||
| + | ===C_COMPONENTTYPE=== | ||
| + | VARCHAR(45) NULL, | ||
| + | ===N_FIRSTOCCURENCE=== | ||
| + | INT UNSIGNED NULL, | ||
| + | ===N_LASTOCCURENCE=== | ||
| + | INT UNSIGNED NULL, | ||
| + | ===M_CALENDARDATA=== | ||
| + | MEDIUMBLOB NULL, | ||
==índices== | ==índices== | ||
| + | |||
| + | PRIMARY KEY (`ID`), | ||
| + | UNIQUE INDEX `UDX_CALENDARIO_URI` (`ID_CALENDARIO` ASC, `C_URI` ASC) | ||
==índices réplica== | ==índices réplica== | ||
Revisión del 12:26 3 mar 2016
Sumario
1 Descripción
2 Campos
2.1 ID
INT UNSIGNED NOT NULL AUTO_INCREMENT,
2.2 ID_CALENDARIO
INT UNSIGNED NOT NULL,
2.3 C_URI
VARCHAR(45) NULL,
2.4 N_LASTMODIFIED
INT UNSIGNED NULL,
2.5 C_ETAG
VARCHAR(45) NULL,
2.6 N_TAM
INT UNSIGNED NOT NULL,
2.7 C_COMPONENTTYPE
VARCHAR(45) NULL,
2.8 N_FIRSTOCCURENCE
INT UNSIGNED NULL,
2.9 N_LASTOCCURENCE
INT UNSIGNED NULL,
2.10 M_CALENDARDATA
MEDIUMBLOB NULL,
3 índices
PRIMARY KEY (`ID`), UNIQUE INDEX `UDX_CALENDARIO_URI` (`ID_CALENDARIO` ASC, `C_URI` ASC)
