| Tables |
|
TMP_ROTACION
| Tables |
|
TMP_ROTACION
Description
(There is no description for table TMP_ROTACION)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
REFERENCIA |
|
CHAR(30) |
|
|
|
|
|
PERIODO |
|
INTEGER |
|
|
|
|
|
MES |
|
INTEGER |
|
|
|
|
|
FECHA |
|
DATE |
|
|
|
|
|
ENTRADAS |
|
NUMERIC(17,4) |
|
0 |
|
|
|
SALIDAS |
|
NUMERIC(17,4) |
|
0 |
|
|
|
ID |
|
INTEGER |
|
|
|
Triggers
(There are no triggers for table TMP_ROTACION)
Indices
Index | Fields | Active | Unique | Order |
|---|---|---|---|---|
REFERENCIA |
|
|
ASC |
|
ID |
|
|
ASC |
References
(There are no references for table TMP_ROTACION)
Referenced By
(There are no tables referenced by table TMP_ROTACION)
Definition
CREATE TABLE TMP_ROTACION (
REFERENCIA CHAR(30),
PERIODO INTEGER,
MES INTEGER,
FECHA DATE,
ENTRADAS NUMERIC(17,4) DEFAULT 0,
SALIDAS NUMERIC(17,4) DEFAULT 0,
ID INTEGER
);
CREATE INDEX TMP_ROTACION_IDX1 ON TMP_ROTACION (REFERENCIA);
CREATE INDEX TMP_ROTACION_IDX2 ON TMP_ROTACION (ID);
|
|
