PLANTILLAS

Tables

PLANTILLAS

Description

(There is no description for table PLANTILLAS)

Fields

PK	FK	Field	Domain	Type	NN	Default	Description
		CODIGO		CHAR(5)
		NOMBRE		CHAR(120)
		PLANTILLA		BLOB SUB_TYPE 1 SEGMENT SIZE 80
		CODPERSONAL		CHAR(15)

Triggers

(There are no triggers for table PLANTILLAS)

Indices

Index	Fields	Active	Unique	Order
FK_PLANTILLAS_1	CODPERSONAL			ASC
PK_PLANTILLAS	CODIGO			ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
PERSONAL	FK_PLANTILLAS_1	CODPERSONAL	CODIGO	NO ACTION	CASCADE

Referenced By

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
IPS_CONSULTAS	FK_IPS_CONSULTAS_3	CODPLANTILLA	CODIGO	NO ACTION	CASCADE
IPS_HOSPITALIZACIONES	FK_IPS_HOSPITALIZACIONES_3	CODPLANTILLA	CODIGO	NO ACTION	CASCADE
IPS_NEONATOS	FK_IPS_NEONATOS_3	CODPLANTILLA	CODIGO	NO ACTION	CASCADE
IPS_URGENCIAS	FK_IPS_URGENCIAS_3	CODPLANTILLA	CODIGO	NO ACTION	CASCADE
TRANSCRIPCIONES	FK_TRANSCRIPCIONES_2	CODPLANTILLA	CODIGO	NO ACTION	CASCADE

Definition

CREATE TABLE PLANTILLAS (
    CODIGO       CHAR(5) NOT NULL,
    NOMBRE       CHAR(120) NOT NULL,
    PLANTILLA    BLOB SUB_TYPE 1 SEGMENT SIZE 80,
    CODPERSONAL  CHAR(15)
);


ALTER TABLE PLANTILLAS ADD CONSTRAINT PK_PLANTILLAS PRIMARY KEY (CODIGO);
ALTER TABLE PLANTILLAS ADD CONSTRAINT FK_PLANTILLAS_1 FOREIGN KEY (CODPERSONAL) REFERENCES PERSONAL (CODIGO) ON UPDATE CASCADE;