SF_RS_DESC |
Default Table Name | SF_RS_DESC |
Definition |
SF_RS_DESC Columns |
ColumnName | Domain | Datatype | NULL | Definition |
FEATURE_ID![]() |
NUMBER(10, 0) | NO | ||
RS_ID![]() |
VARCHAR2(30) | NO | ||
OBJECT_ID | VARCHAR2(72) | NO | ||
TMPL_TYPE | VARCHAR2(30) | YES | ||
TBL_NAME | VARCHAR2(30) | YES | ||
TBL_COL_NAME | VARCHAR2(254) | YES | ||
DATA_TYPE | VARCHAR2(1) | YES | ||
COL_PRECISION | NUMBER(10, 0) | YES | ||
COL_SCALE | NUMBER(5, 0) | YES | ||
PK_FL | VARCHAR2(1) | YES | ||
PK_EDITABLE_FL | VARCHAR2(1) | YES | ||
FK_FL | VARCHAR2(1) | YES | ||
APP_POPULATE_FL | VARCHAR2(1) | YES | ||
DFLT_LABEL | VARCHAR2(2000) | YES | ||
VISIBLE_CD | VARCHAR2(1) | YES | ||
REQUIRED_CD | VARCHAR2(1) | YES | ||
EDITABLE_FL | VARCHAR2(1) | YES | ||
QUERIABLE_FL | VARCHAR2(1) | YES | ||
CLEAR_ON_COPY_FL | VARCHAR2(1) | YES | ||
CLEAR_ON_CLONE_FL | VARCHAR2(1) | YES | ||
DB_READ_ONLY_FL | VARCHAR2(1) | YES | ||
KEEP_ORIG_VAL_FL | VARCHAR2(1) | YES | ||
DFLT_VALUE | VARCHAR2(2000) | YES | ||
FORMAT | VARCHAR2(30) | YES | ||
CURR_REF_OBJ_ID | VARCHAR2(72) | YES | ||
LKP_RS_ID | VARCHAR2(30) | YES | ||
LKP_CHILD_NO | NUMBER(14, 0) | YES | ||
LKP_OBJ_ID | VARCHAR2(72) | YES | ||
LKP_GROUP_NO | NUMBER(5, 0) | YES | ||
LKP_SQL | LONG | YES | ||
LKP_VAL_CD | VARCHAR2(1) | YES | ||
LKP_VAL_SEVERE_CD | VARCHAR2(1) | YES | ||
LKP_MSG_ID | VARCHAR2(32) | YES | ||
LKP_SCOPE_CD | VARCHAR2(1) | YES | ||
FRMLA_TXT | VARCHAR2(2000) | YES | ||
VAL_JS_CLASS | VARCHAR2(90) | YES | ||
VAL_JS_MTHD | VARCHAR2(90) | YES | ||
VAL_CLASS | VARCHAR2(90) | YES | ||
VAL_MTHD | VARCHAR2(90) | YES | ||
VAL_ORDER_NO | NUMBER(5, 0) | YES | ||
ORG_SEC_TYPE_CD | VARCHAR2(1) | YES | ||
OBJ_VALUES | VARCHAR2(2000) | YES | ||
CURRENCY_FUNC_TYPE | VARCHAR2(32) | YES | ||
EDITABLE_FRMLA_TXT | VARCHAR2(2000) | YES | ||
VISIBLE_FRMLA_TXT | VARCHAR2(2000) | YES | ||
SUPRSN_TYPE | VARCHAR2(1) | YES | ||
RPT_DS_VAR_ID | VARCHAR2(30) | YES | ||
RPT_PARM_FL | VARCHAR2(1) | YES | ||
SPACE_SUPPRESSION | VARCHAR2(10) | YES | ||
FROM_OBJ_ID | VARCHAR2(90) | YES | ||
TO_OBJ_ID | VARCHAR2(90) | YES | ||
PERSIST_DISABLD_FL | VARCHAR2(1) | YES | ||
LOGICAL_PK_FL | VARCHAR2(1) | YES | ||
DYN_TYPE_OBJ_ID | VARCHAR2(72) | YES | ||
REQUIRED_FRMLA_TXT | VARCHAR2(2000) | YES | ||
REMOVED_FL | VARCHAR2(1) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
ROWVERSION | NUMBER(10, 0) | YES |
SF_RS_DESC Primary and Unique Keys |
Key Name | Key Type | Keys |
UI_SF_RS_DESC_FERSOB_IDX | Index | FEATURE_ID, RS_ID, OBJECT_ID |
SF_RS_DESC Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
SF_RS_LIST | Non-Identifying | One To Zero or More | FK_SF_RS_DESC_FERS_IDX | FEATURE_ID, RS_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |