INSUMOS

Tables

INSUMOS

Description

(There is no description for table INSUMOS)

Fields

PK	FK	Field	Domain	Type	NN	Default	Description
		CODIGO		CHAR(15)
		NOMBRE		CHAR(120)
		FORMA		CHAR(20)
		CONCENTRACION		CHAR(20)
		CODMEDIDA		CHAR(5)

Triggers

(There are no triggers for table INSUMOS)

Indices

Index	Fields	Active	Unique	Order
FK_INSUMOS_1	CODMEDIDA			ASC
PK_INSUMOS	CODIGO			ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
MEDIDAS	FK_INSUMOS_1	CODMEDIDA	CODIGO	NO ACTION	CASCADE

Referenced By

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
FACTURACION_INSUMOS	FK_FACTURACION_INSUMOS_1	CODINSUMO	CODIGO	NO ACTION	CASCADE
INSUMOS_PROCEDIMIENTOS	FK_INSUMOS_PROCEDIMIENTOS_2	CODINSUMO	CODIGO	NO ACTION	CASCADE
TARIFAS_INSUMOS	FK_TARIFAS_INSUMOS_2	CODINSUMO	CODIGO	NO ACTION	CASCADE

Definition

CREATE TABLE INSUMOS (
    CODIGO         CHAR(15) NOT NULL,
    NOMBRE         CHAR(120) NOT NULL,
    FORMA          CHAR(20),
    CONCENTRACION  CHAR(20),
    CODMEDIDA      CHAR(5)
);


ALTER TABLE INSUMOS ADD CONSTRAINT PK_INSUMOS PRIMARY KEY (CODIGO);
ALTER TABLE INSUMOS ADD CONSTRAINT FK_INSUMOS_1 FOREIGN KEY (CODMEDIDA) REFERENCES MEDIDAS (CODIGO) ON UPDATE CASCADE;