COSTOS

Tables

COSTOS

Description

(There is no description for table COSTOS)

Fields

Field	Type	Default
CODIGO	CHAR(10)
NOMBRE	CHAR(80)
CLASE	CHAR(10)
TIPO	CHAR(10)
CODMEDIDA	CHAR(5)
COSTO	NUMERIC(17,4)	0

Triggers

(There are no triggers for table COSTOS)

Indices

Index	Fields	Active	Unique	Order
FK_COSTOS_1	CODMEDIDA			ASC
PK_COSTOS	CODIGO			ASC

References

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

Referenced By

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
ENSAMBLES_COSTOS	FK_ENSAMBLES_COSTOS_2	CODCOSTO	CODIGO	NO ACTION	CASCADE
REG_COSTOS	FK_REG_COSTOS_3	CODCOSTO	CODIGO	NO ACTION	CASCADE
REG_NOVEDADES	FK_REG_NOVEDADES_2	CODCOSTO	CODIGO	NO ACTION	CASCADE

Definition

CREATE TABLE COSTOS (
    CODIGO     CHAR(10) NOT NULL,
    NOMBRE     CHAR(80) NOT NULL,
    CLASE      CHAR(10) NOT NULL,
    TIPO       CHAR(10) NOT NULL,
    CODMEDIDA  CHAR(5) NOT NULL,
    COSTO      NUMERIC(17,4) DEFAULT 0
);


ALTER TABLE COSTOS ADD CONSTRAINT PK_COSTOS PRIMARY KEY (CODIGO);
ALTER TABLE COSTOS ADD CONSTRAINT FK_COSTOS_1 FOREIGN KEY (CODMEDIDA) REFERENCES MEDIDAS (CODIGO) ON UPDATE CASCADE;