REG_GLOSAS

Tables

REG_GLOSAS

Description

(There is no description for table REG_GLOSAS)

Fields

Field	Type	Default
ITEM	INTEGER
FECHA	TIMESTAMP	CURRENT_TIMESTAMP
NOTA	VARCHAR(1000)
CODPPTO	CHAR(20)
CODCDP	CHAR(20)
CODRP	CHAR(20)
CODUSUARIO	CHAR(10)

Triggers

(There are no triggers for table REG_GLOSAS)

Indices

Index	Fields	Order
FK_REG_GLOSAS_1	CODPPTO	ASC
FK_REG_GLOSAS_2	CODCDP	ASC
FK_REG_GLOSAS_3	CODRP	ASC
FK_REG_GLOSAS_4	CODUSUARIO	ASC
PK_REG_GLOSAS	ITEM	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
PPTO	FK_REG_GLOSAS_1	CODPPTO	CODIGO	NO ACTION	CASCADE
CDP	FK_REG_GLOSAS_2	CODCDP	CODIGO	NO ACTION	CASCADE
RP	FK_REG_GLOSAS_3	CODRP	CODIGO	NO ACTION	CASCADE
USUARIOS	FK_REG_GLOSAS_4	CODUSUARIO	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table REG_GLOSAS)

Definition

CREATE TABLE REG_GLOSAS (
    ITEM        INTEGER NOT NULL,
    FECHA       TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    NOTA        VARCHAR(1000) NOT NULL,
    CODPPTO     CHAR(20),
    CODCDP      CHAR(20),
    CODRP       CHAR(20),
    CODUSUARIO  CHAR(10)
);


ALTER TABLE REG_GLOSAS ADD CONSTRAINT PK_REG_GLOSAS PRIMARY KEY (ITEM);
ALTER TABLE REG_GLOSAS ADD CONSTRAINT FK_REG_GLOSAS_1 FOREIGN KEY (CODPPTO) REFERENCES PPTO (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_GLOSAS ADD CONSTRAINT FK_REG_GLOSAS_2 FOREIGN KEY (CODCDP) REFERENCES CDP (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_GLOSAS ADD CONSTRAINT FK_REG_GLOSAS_3 FOREIGN KEY (CODRP) REFERENCES RP (CODIGO) ON UPDATE CASCADE;
ALTER TABLE REG_GLOSAS ADD CONSTRAINT FK_REG_GLOSAS_4 FOREIGN KEY (CODUSUARIO) REFERENCES USUARIOS (CODIGO) ON UPDATE CASCADE;