QSC_PROD_GRP_ATTR_B
This table is used to store further narrow by options available to a product group. Narrow by filters can be used to further filter the search results based on certain attributes. The attributes on which narrow by filters can be defined could be item attributes, pricing attributes, shipping attributes and/or tag attributes.
Details
-
Schema: FUSION
-
Object owner: QSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_SEED
Primary Key
Name | Columns |
---|---|
QSC_PROD_GRP_ATTR_B_PK |
PROD_GRP_ATTR_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
PROD_GRP_ATTR_ID | NUMBER | 18 | Yes | Product Group Further Narrow By Attribute Identifier | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | Active | |
REF_NUMBER | VARCHAR2 | 50 | Yes | Identifier used for integration with external systems. | Active | |
OBJECT_ID | NUMBER | 18 | Yes | Persistent Id used to reference the original version. | Active | |
REVISION_NUM | NUMBER | 18 | Yes | Revision Number | Active | |
CHANGE_NUM | NUMBER | 18 | Column for internal use. Used internally for publishing product groups. | Active | ||
PROD_GROUP_ID | NUMBER | 18 | Yes | Product Group Identifier. Foreign Key to QSC_PROD_GROUPS_B. | Active | |
ATTRIBUTE_OPTION_ID | NUMBER | 18 | Yes | Refers to the product group attribute option unique identifier. | Active | |
DISPLAY_ORDER_NUM | NUMBER | 18 | Manually set display order in which narrow by attributes are displayed at runtime. | Active | ||
NARROW_BY_FLAG | VARCHAR2 | 1 | Flag to indicate whether the attribute will be displayed in the narrow by section at runtime. | Active | ||
DISPLAY_PROD_LAYOUT_FLAG | VARCHAR2 | 1 | Flag to indicate whether this attribute should be displayed in the product list or detail layout for a particular product group. | Active | ||
ADVANCE_SEARCH_FLAG | VARCHAR2 | 1 | Flag to indicate whether the attribute will be available for advance search. | Active | ||
SHOW_ALL_FLAG | VARCHAR2 | 1 | Flag to indicate whether the attribute will be displayed in the 'Show All' part of the narrow by region at runtime. | Active | ||
SORT_BY_FLAG | VARCHAR2 | 1 | Flag to indicate whether attribute will be available for sorting. | Active | ||
DOMAIN_AUTO_GEN_FLAG | VARCHAR2 | 1 | Flag to indicate whether the domain is automatically generated for this attribute type. | Active | ||
UI_MODE_TYPE_CODE | VARCHAR2 | 30 | Indicates the mode in which UI should be rendered during runtime. | Active | ||
ATTR_TYPE_CODE | VARCHAR2 | 30 | Refers to the type of attribute. | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
USER_LAST_UPDATE_DATE | TIMESTAMP | Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). | Active |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
QSC_PROD_GRP_ATTR_B | qsc_prod_groups_b | PROD_GROUP_ID |
QSC_PROD_GRP_ATTR_B | qsc_attribute_options | ATTRIBUTE_OPTION_ID |
qsc_prod_grp_attr_tl | qsc_prod_grp_attr_b | PROD_GRP_ATTR_ID |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
QSC_PROD_GRP_ATTR_B_F1 | Non Unique | FUSION_TS_SEED | ATTRIBUTE_OPTION_ID | Active |
QSC_PROD_GRP_ATTR_B_N1 | Non Unique | FUSION_TS_SEED | LAST_UPDATE_DATE, PROD_GRP_ATTR_ID | Active |
QSC_PROD_GRP_ATTR_B_PK | Unique | FUSION_TS_SEED | PROD_GRP_ATTR_ID | Active |
QSC_PROD_GRP_ATTR_B_U1 | Unique | FUSION_TS_SEED | PROD_GROUP_ID, ATTRIBUTE_OPTION_ID, REVISION_NUM | Active |
QSC_PROD_GRP_ATTR_B_U2 | Unique | FUSION_TS_SEED | PROD_GROUP_ID, REVISION_NUM, OBJECT_ID | Active |