SDC table
Structure Utility.Additional Column
Defines user-defined columns. Master table: SDK.
SDC_KEY | NUMBER(19,0) | not null |
SDK_KEY | NUMBER(19,0) | not null |
SDC_NAME | VARCHAR2(30 CHAR) | not null |
SDC_VARIANT_TYPE | VARCHAR2(10 CHAR) | not null |
SDC_SQL_LENGTH | NUMBER(5,0) | |
SDC_LABEL | VARCHAR2(100 CHAR) | |
SDC_FIELD_TYPE | VARCHAR2(25 CHAR) | |
SDC_ORDER | NUMBER(5,0) | |
SDC_DEFAULT | VARCHAR2(1 CHAR) | |
SDC_DEFAULT_VALUE | VARCHAR2(1000 CHAR) | |
SDC_PROFILE_ENABLED | VARCHAR2(1 CHAR) | |
SDC_ENCRYPTED | VARCHAR2(1 CHAR) | |
SDC_VERSION | NUMBER(10,0) | |
SDC_DATA_LEVEL | NUMBER(1,0) | |
SDC_CREATE | DATE | |
SDC_CREATEBY | NUMBER(19,0) | |
SDC_UPDATE | DATE | |
SDC_UPDATEBY | NUMBER(19,0) | |
SDC_NOTE | CLOB | |
SDC_ROWVER | RAW(8) |
Child tables:
- SDP - User defined column properties
page revision: 4, last edited: 14 Jul 2011 21:11