MNT_E3

Tables

MNT_E3

Description

(There is no description for table MNT_E3)

Fields

Field	Type	Default
ITEM	INTEGER
FECHA	TIMESTAMP
COMENTARIOS	CHAR(1000)
CODMONTAJE	INTEGER
CODAUDITOR	CHAR(10)
CODCONTACTO	CHAR(10)
CONCLUIDA	CHAR(1)	'N'

Triggers

(There are no triggers for table MNT_E3)

Indices

Index	Fields	Order
FK_MNT_E3_1	CODMONTAJE	ASC
FK_MNT_E3_2	CODAUDITOR	ASC
FK_MNT_E3_3	CODCONTACTO	ASC
PK_MNT_E3_1	ITEM	ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
MONTAJES	FK_MNT_E3_1	CODMONTAJE	CODIGO	NO ACTION	CASCADE
USUARIOS	FK_MNT_E3_2	CODAUDITOR	CODIGO	NO ACTION	CASCADE
CONTACTOS	FK_MNT_E3_3	CODCONTACTO	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table MNT_E3)

Definition

CREATE TABLE MNT_E3 (
    ITEM         INTEGER NOT NULL,
    FECHA        TIMESTAMP NOT NULL,
    COMENTARIOS  CHAR(1000) NOT NULL,
    CODMONTAJE   INTEGER NOT NULL,
    CODAUDITOR   CHAR(10) NOT NULL,
    CODCONTACTO  CHAR(10) NOT NULL,
    CONCLUIDA    CHAR(1) DEFAULT 'N'
);


ALTER TABLE MNT_E3 ADD CONSTRAINT PK_MNT_E3_1 PRIMARY KEY (ITEM);
ALTER TABLE MNT_E3 ADD CONSTRAINT FK_MNT_E3_1 FOREIGN KEY (CODMONTAJE) REFERENCES MONTAJES (CODIGO) ON UPDATE CASCADE;
ALTER TABLE MNT_E3 ADD CONSTRAINT FK_MNT_E3_2 FOREIGN KEY (CODAUDITOR) REFERENCES USUARIOS (CODIGO) ON UPDATE CASCADE;
ALTER TABLE MNT_E3 ADD CONSTRAINT FK_MNT_E3_3 FOREIGN KEY (CODCONTACTO) REFERENCES CONTACTOS (CODIGO) ON UPDATE CASCADE;