TMP_DESPACHOS

Tables

TMP_DESPACHOS

Description

(There is no description for table TMP_DESPACHOS)

Fields

PK	FK	Field	Domain	Type	NN	Default	Description
		ID		INTEGER
		ORDEN		INTEGER
		CODREFERENCIA		CHAR(20)
		DESPACHADO		NUMERIC(17,4)

Triggers

(There are no triggers for table TMP_DESPACHOS)

Indices

Index	Fields	Order
PK_TMP_DESPACHOS	ID, ORDEN, CODREFERENCIA	ASC
TMP_DESPACHOS_IDX1	ID	ASC
TMP_DESPACHOS_IDX2	ORDEN	ASC
TMP_DESPACHOS_IDX3	CODREFERENCIA	ASC

References

(There are no references for table TMP_DESPACHOS)

Referenced By

(There are no tables referenced by table TMP_DESPACHOS)

Definition

CREATE TABLE TMP_DESPACHOS (
    ID             INTEGER NOT NULL,
    ORDEN          INTEGER NOT NULL,
    CODREFERENCIA  CHAR(20) NOT NULL,
    DESPACHADO     NUMERIC(17,4)
);


ALTER TABLE TMP_DESPACHOS ADD CONSTRAINT PK_TMP_DESPACHOS PRIMARY KEY (ID, ORDEN, CODREFERENCIA);
CREATE INDEX TMP_DESPACHOS_IDX1 ON TMP_DESPACHOS (ID);
CREATE INDEX TMP_DESPACHOS_IDX2 ON TMP_DESPACHOS (ORDEN);
CREATE INDEX TMP_DESPACHOS_IDX3 ON TMP_DESPACHOS (CODREFERENCIA);