| Tables |
|
RATIOS
| Tables |
|
RATIOS
Description
(There is no description for table RATIOS)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
CODIGO |
|
CHAR(10) |
|
|
|
|
|
NOMBRE |
|
CHAR(80) |
|
|
|
|
|
NOTA |
|
VARCHAR(300) |
|
|
|
|
|
MINIMO |
|
NUMERIC(17,4) |
|
|
|
|
|
MAXIMO |
|
NUMERIC(17,4) |
|
|
|
|
|
FORMULA |
|
VARCHAR(300) |
|
|
|
|
|
ORDEN |
|
SMALLINT |
|
0 |
|
Triggers
(There are no triggers for table RATIOS)
Indices
Index | Fields | Active | Unique | Order |
|---|---|---|---|---|
CODIGO |
|
|
ASC |
References
(There are no references for table RATIOS)
Referenced By
(There are no tables referenced by table RATIOS)
Definition
CREATE TABLE RATIOS (
CODIGO CHAR(10) NOT NULL,
NOMBRE CHAR(80),
NOTA VARCHAR(300),
MINIMO NUMERIC(17,4),
MAXIMO NUMERIC(17,4),
FORMULA VARCHAR(300),
ORDEN SMALLINT DEFAULT 0
);
ALTER TABLE RATIOS ADD CONSTRAINT PK_RATIOS PRIMARY KEY (CODIGO);
|
|
