| Column Summary | ||||||
|---|---|---|---|---|---|---|
| Name | SqlType | Length | Precision | Scale | Nullable | Unique |
| CODE | VARCHAR2(40) | 255 | 19 | 2 | false | false |
| NAME | VARCHAR2(100) | 255 | 19 | 2 | false | false |
| DESCRIPTION | VARCHAR2(255) | 255 | 19 | 2 | true | false |
| IS_QUALITATIVE | NUMBER(1) | 255 | 19 | 2 | false | false |
| IS_TAXINOMIC | NUMBER(1) | 255 | 19 | 2 | false | false |
| IS_CALCULATED | NUMBER(1) | 255 | 19 | 2 | false | false |
| IS_ALPHANUMERIC | NUMBER(1) | 255 | 19 | 2 | false | false |
| CREATION_DATE | DATE | 255 | 19 | 2 | false | false |
| UPDATE_DATE | TIMESTAMP | 255 | 19 | 2 | false | false |
| COMMENTS | VARCHAR2(2000) | 255 | 19 | 2 | true | false |
| PARAMETER_GROUP_FK | NUMBER(10) | 255 | 19 | 2 | false | false |
| STATUS_FK | VARCHAR2(1) | 255 | 19 | 2 | false | false |
| Primary Key | |
|---|---|
| Name | Columns |
| PARAMETERPK | CODE |
| Foreign Keys | ||
|---|---|---|
| Name | Referenced Table | Columns |
| PARAMETER_PARAMETER_GROUP_FKC | PARAMETER_GROUP | PARAMETER_GROUP_FK |
| PARAMETER_STATUS_FKC | STATUS | STATUS_FK |
| Indexes | |
|---|---|
| Name | Columns |
| IX_PARAMETER_UD | UPDATE_DATE |
Column Detail