LOY_ATTR_ITM
this is the Loyalty Attribute Item table.
Details
-
Schema: FUSION
-
Object owner: LOY
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
LOY_ATTR_ITM_PK |
LOY_ATTR_ITM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LOY_ATTR_ITM_ID | NUMBER | 18 | Yes | Who column | |
| ACTION_NOTE | VARCHAR2 | 1000 | It is a marker. Action Notes captured from Action Definition are stamped here. E.g. Member promoted from Gold to Platinum through xyz promotion. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| CONFLICT_ID | NUMBER | 18 | Yes | Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). | |
| ATTRIB_DEFN_ID | NUMBER | 18 | Attribute definition for promotion attribute, which doesnt have parent Attribute | ||
| ATTRIB_ID | NUMBER | 18 | Header of this Attribute Item. | ||
| COMMENTS | VARCHAR2 | 250 | Comments Column | ||
| PROMO_BUCKET_ID | NUMBER | 18 | Promotion Bucket due to which this Point Item was rewarded. | ||
| PROMO_ID | NUMBER | 18 | Promotion for which this item was created. | ||
| TXN_ID | NUMBER | 18 | Transaction for which this item was given | ||
| VALUE | VARCHAR2 | 250 | Value of this item. | ||
| 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. | |
| OPERATOR_CODE | VARCHAR2 | 30 | This column is used to track the operator that was used during the update attribute (action during transaction). E.g. Set, Multiply, Add, Divide and Substract. | ||
| UPDATE_DATE | TIMESTAMP | The date time on which this object was update. LAST_UPDATE_DATE is not set through code so this column is needed to set the date time through code so that this can be used to sort and identify the sequence in which the records were updated. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| LOY_ATTR_ITM | loy_attrib | ATTRIB_ID |
| LOY_ATTR_ITM | loy_txn | TXN_ID |
| LOY_ATTR_ITM | loy_attrdefn_b | ATTRIB_DEFN_ID |
| LOY_ATTR_ITM | loy_bucket | PROMO_BUCKET_ID |
| LOY_ATTR_ITM | loy_promo | PROMO_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| LOY_ATTR_ITM_F1 | Non Unique | Default | ATTRIB_ID |
| LOY_ATTR_ITM_F2 | Non Unique | Default | TXN_ID |
| LOY_ATTR_ITM_F3 | Non Unique | Default | ATTRIB_DEFN_ID, PROMO_ID, TXN_ID |
| LOY_ATTR_ITM_F4 | Non Unique | Default | PROMO_BUCKET_ID |
| LOY_ATTR_ITM_F5 | Non Unique | Default | PROMO_ID |
| LOY_ATTR_ITM_U1 | Unique | FUSION_TS_TX_DATA | LOY_ATTR_ITM_ID |
| LOY_ATTR_ITM_U2 | Unique | Default | LAST_UPDATE_DATE, LOY_ATTR_ITM_ID |