| Tables |
|
REPORTES
| Tables |
|
REPORTES
Description
(There is no description for table REPORTES)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
CODIGO |
|
CHAR(10) |
|
|
|
|
|
NOMBRE |
|
CHAR(80) |
|
|
|
|
|
NOTA |
|
CHAR(200) |
|
|
|
|
|
ARCHIVO |
|
CHAR(30) |
|
|
|
|
|
ADJUNTO |
|
CHAR(30) |
|
|
|
|
|
NIVEL |
|
SMALLINT |
|
1 |
|
|
|
MODULO |
|
CHAR(10) |
|
|
|
|
|
PARAMETROS |
|
VARCHAR(200) |
|
|
|
|
|
PUBLICAR |
|
CHAR(1) |
|
'N' |
|
|
|
CODGRUPO |
|
CHAR(30) |
|
|
|
|
|
VALIDA_TRANSITO |
|
CHAR(1) |
|
'N' |
|
|
|
NATIVO |
|
CHAR(1) |
|
'N' |
|
|
|
TABLERO |
|
CHAR(1) |
|
'N' |
|
|
|
PRIORIDAD |
|
SMALLINT |
|
1 |
|
Triggers
(There are no triggers for table REPORTES)
Indices
Index | Fields | Active | Unique | Order |
|---|---|---|---|---|
CODGRUPO |
|
|
ASC |
|
CODIGO |
|
|
ASC |
References
Table | Foreign Key | Fields | FK Field | Delete Rule | Update Rule |
|---|---|---|---|---|---|
CODGRUPO |
CODIGO |
NO ACTION |
CASCADE |
Referenced By
(There are no tables referenced by table REPORTES)
Definition
CREATE TABLE REPORTES (
CODIGO CHAR(10) NOT NULL,
NOMBRE CHAR(80) NOT NULL,
NOTA CHAR(200),
ARCHIVO CHAR(30),
ADJUNTO CHAR(30),
NIVEL SMALLINT DEFAULT 1,
MODULO CHAR(10) NOT NULL,
PARAMETROS VARCHAR(200),
PUBLICAR CHAR(1) DEFAULT 'N',
CODGRUPO CHAR(30),
VALIDA_TRANSITO CHAR(1) DEFAULT 'N',
NATIVO CHAR(1) DEFAULT 'N',
TABLERO CHAR(1) DEFAULT 'N',
PRIORIDAD SMALLINT DEFAULT 1
);
ALTER TABLE REPORTES ADD CONSTRAINT PK_REPORTES PRIMARY KEY (CODIGO);
ALTER TABLE REPORTES ADD CONSTRAINT FK_REPORTES_1 FOREIGN KEY (CODGRUPO) REFERENCES GRUPOS (CODIGO) ON UPDATE CASCADE;
|
|
