RIPS

Tables

RIPS

Description

(There is no description for table RIPS)

Fields

Field	Type	Default
ARCHIVO	CHAR(2)
REMISION	CHAR(6)
CODCONTRATO	CHAR(15)
DESDE	DATE
HASTA	DATE
FECHA	DATE
REGISTROS	INTEGER	0
GLOSAS	CHAR(1)	'N'

Triggers

(There are no triggers for table RIPS)

Indices

Index	Fields	Active	Unique	Order
FK_RIPS_1	CODCONTRATO			ASC
PK_RIPS	ARCHIVO, REMISION, CODCONTRATO			ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
CONTRATOS	FK_RIPS_1	CODCONTRATO	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table RIPS)

Definition

CREATE TABLE RIPS (
    ARCHIVO      CHAR(2) NOT NULL,
    REMISION     CHAR(6) NOT NULL,
    CODCONTRATO  CHAR(15) NOT NULL,
    DESDE        DATE,
    HASTA        DATE,
    FECHA        DATE,
    REGISTROS    INTEGER DEFAULT 0,
    GLOSAS       CHAR(1) DEFAULT 'N'
);


ALTER TABLE RIPS ADD CONSTRAINT PK_RIPS PRIMARY KEY (ARCHIVO, REMISION, CODCONTRATO);
ALTER TABLE RIPS ADD CONSTRAINT FK_RIPS_1 FOREIGN KEY (CODCONTRATO) REFERENCES CONTRATOS (CODIGO) ON UPDATE CASCADE;