EGO_RL_BLEND_RULE_ATTR_GROUPS

This table stores attribute groups used by a blending rule. GROUP_ROW_ID is a Surrogate Key for this entity. RULE_ID is a foreign key to EGO_RL_USER_RULES_B

Details

  • Schema: FUSION

  • Object owner: EGO

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

EGO_RL_BLEND_RULE_ATTR_GR_PK

GROUP_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments
GROUP_ROW_ID NUMBER 18 Yes Surrogate Key for this entity.Current table EGO_RL_BLEND_RULE_ATTR_GROUPS.
RULE_ID NUMBER 18 Yes Foreign Key to EGO_RL_USER_RULES_B. Current table EGO_RL_BLEND_RULE_ATTR_GROUPS
ATTR_GROUP_TYPE VARCHAR2 30 The type of attribute group the blending rule is for.
ATTR_GROUP_NAME VARCHAR2 80 Internal name of attribute group that the blending rule is for.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table Foreign Table Foreign Key Column
EGO_RL_BLEND_RULE_ATTR_GROUPS ego_rl_user_rules_b RULE_ID

Indexes

Index Uniqueness Tablespace Columns
EGO_RL_BLEND_RULE_ATTR_GROU_U1 Unique Default GROUP_ROW_ID
EGO_RL_BLEND_RULE_ATTR_GROU_U2 Unique Default RULE_ID, ATTR_GROUP_TYPE, ATTR_GROUP_NAME