Tables Previous topic Chapter index Next topic

TMP_EXO_TERCEROS

 

Description

(There is no description for table TMP_EXO_TERCEROS)

 

Fields

PK

FK

Field

Domain

Type

NN

Default

Description

 

 

TERCERO

 

CHAR(15)

 

 

 

 

VALOR1

 

NUMERIC(17,4)

0

 

 

 

VALOR2

 

NUMERIC(17,4)

0

 

 

 

ID

 

INTEGER

 

 

 

Triggers

(There are no triggers for table TMP_EXO_TERCEROS)

 

Indices

Index

Fields

Active

Unique

Order

TMP_EXO_TERCEROS_IDX1

TERCERO

ASC

TMP_EXO_TERCEROS_IDX2

ID

ASC

 

References

(There are no references for table TMP_EXO_TERCEROS)

 

Referenced By

(There are no tables referenced by table TMP_EXO_TERCEROS)

 

Definition

CREATE TABLE TMP_EXO_TERCEROS (
    TERCERO  CHAR(15),
    VALOR1   NUMERIC(17,4) DEFAULT 0,
    VALOR2   NUMERIC(17,4) DEFAULT 0,
    ID       INTEGER
);


CREATE INDEX TMP_EXO_TERCEROS_IDX1 ON TMP_EXO_TERCEROS (TERCERO);
CREATE INDEX TMP_EXO_TERCEROS_IDX2 ON TMP_EXO_TERCEROS (ID);

 

     Previous topic Chapter index Next topic