INFORMES

Tables

INFORMES

Description

(There is no description for table INFORMES)

Fields

Field	Type	Default
CODIGO	CHAR(10)
NOMBRE	CHAR(80)
NOTA	CHAR(200)
SQL_CONSULTA	BLOB SUB_TYPE 1 SEGMENT SIZE 80
NIVEL	SMALLINT	1
MODULO	CHAR(10)
FORMATO	BLOB SUB_TYPE 0 SEGMENT SIZE 80
PUBLICAR	CHAR(1)	'N'
CODGRUPO	CHAR(30)
NATIVO	CHAR(1)	'N'
TABLERO	CHAR(1)	'N'
PRIORIDAD	SMALLINT	1

Triggers

(There are no triggers for table INFORMES)

Indices

Index	Fields	Active	Unique	Order
FK_INFORMES_1	CODGRUPO			ASC
PK_INFORMES	CODIGO			ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
GRUPOS	FK_INFORMES_1	CODGRUPO	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table INFORMES)

Definition

CREATE TABLE INFORMES (
    CODIGO        CHAR(10) NOT NULL,
    NOMBRE        CHAR(80) NOT NULL,
    NOTA          CHAR(200),
    SQL_CONSULTA  BLOB SUB_TYPE 1 SEGMENT SIZE 80,
    NIVEL         SMALLINT DEFAULT 1,
    MODULO        CHAR(10),
    FORMATO       BLOB SUB_TYPE 0 SEGMENT SIZE 80,
    PUBLICAR      CHAR(1) DEFAULT 'N',
    CODGRUPO      CHAR(30),
    NATIVO        CHAR(1) DEFAULT 'N',
    TABLERO       CHAR(1) DEFAULT 'N',
    PRIORIDAD     SMALLINT DEFAULT 1
);


ALTER TABLE INFORMES ADD CONSTRAINT PK_INFORMES PRIMARY KEY (CODIGO);
ALTER TABLE INFORMES ADD CONSTRAINT FK_INFORMES_1 FOREIGN KEY (CODGRUPO) REFERENCES GRUPOS (CODIGO) ON UPDATE CASCADE;