CAUSAS

Tables

CAUSAS

Description

(There is no description for table CAUSAS)

Fields

PK	FK	Field	Domain	Type	NN	Default	Description
		CODIGO		CHAR(5)
		NOMBRE		CHAR(80)

Triggers

(There are no triggers for table CAUSAS)

Indices

Index	Fields	Active	Unique	Order
PK_CAUSAS	CODIGO			ASC

References

(There are no references for table CAUSAS)

Referenced By

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
IPS_CONSULTAS	FK_IPS_CONSULTAS_6	CODCAUSA	CODIGO	NO ACTION	CASCADE
IPS_HOSPITALIZACIONES	FK_IPS_HOSPITALIZACIONES_6	CODCAUSA	CODIGO	NO ACTION	CASCADE
IPS_URGENCIAS	FK_IPS_URGENCIAS_5	CODCAUSA	CODIGO	NO ACTION	CASCADE

Definition

CREATE TABLE CAUSAS (
    CODIGO  CHAR(5) NOT NULL,
    NOMBRE  CHAR(80) NOT NULL
);


ALTER TABLE CAUSAS ADD CONSTRAINT PK_CAUSAS PRIMARY KEY (CODIGO);