LOY_PROMO_ATT
This Table contains information about Loyalty Promotion Attachment under Fusion Loyalty in Cloud.
Details
-
Schema: FUSION
-
Object owner: LOY
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
LOY_PROMO_ATT_PK |
LOY_PROMO_ATT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LOY_PROMO_ATT_ID | NUMBER | 18 | Yes | Who column. | |
| 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). | |
| COMMENTS | VARCHAR2 | 250 | Comments | ||
| FILE_AUTO_UPD_FLAG | VARCHAR2 | 1 | Yes | File Routing Processing Column | |
| FILE_DATE | DATE | File Routing Processing Column | |||
| FILE_DEFER_FLAG | VARCHAR2 | 1 | Yes | File Routing Processing Column | |
| FILE_DOCK_REQ_FLAG | VARCHAR2 | 1 | Yes | File Routing Processing Column | |
| FILE_DOCK_STAT_FLAG | VARCHAR2 | 1 | Yes | File Routing Processing Column | |
| FILE_EXT | VARCHAR2 | 10 | File Routing Processing Column | ||
| FILE_NAME | VARCHAR2 | 200 | Yes | File Routing Processing Column | |
| FILE_REV_NUM | VARCHAR2 | 15 | File Routing Processing Column | ||
| FILE_SIZE | NUMBER | 22 | File Routing Processing Column | ||
| FILE_SRC_PATH | VARCHAR2 | 250 | File Routing Processing Column | ||
| FILE_SRC_TYPE | VARCHAR2 | 30 | File Routing Processing Column | ||
| LOGO_STAT_CODE | VARCHAR2 | 30 | Logo Status Code | ||
| LOGO_TYPE_CODE | VARCHAR2 | 30 | Logo Type Code | ||
| PAR_ROW_ID | NUMBER | 18 | Yes | System Column | |
| SM_PUBLISH_FLAG | VARCHAR2 | 1 | Yes | Publish Flag. If checked, this attachment will be sent to the publish API to publish on social media. A loyalty promotion may have many attachments such as thumbnail image, large image, etc. Only specific attachment(s) may be published and sent as outbound post/web service to a social network such as Facebook or Twitter. | |
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| LOY_PROMO_ATT | loy_promo | PAR_ROW_ID |
| loy_promo | loy_promo_att | PR_PROMO_LOGO_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| LOY_PROMO_ATT_U1 | Unique | FUSION_TS_TX_DATA | LOY_PROMO_ATT_ID |
| LOY_PROMO_ATT_U2 | Unique | Default | PAR_ROW_ID, FILE_NAME, FILE_EXT, CONFLICT_ID |