Table Schema.md
24 additions, 72 deletions
| ... | ... | @@ -1,24 +1,24 @@ |
| 1 | - ## 子任務原始條件檔 CMS_MISSION_RULE_ORIGIN | |
| 1 | + ## 任務原始條件檔 CMS_MISSION_RULE_ORIGIN | |
| 2 | -| id | INT | 主鍵 | 1 | | |
| 3 | -| mission_sub_id | INT | 任務設定子表 ID [MissionSubSetting.id](http://MissionSubSetting.id)<br> | | | |
| 4 | - | type | VARCHAR2(10 BYTE) | 條件類型 | voucher 指定票券<br>referral 會員推薦<br>member_login 會員登入 | | |
| 2 | + | id | NUMBER | 主鍵 | 1 | | |
| 3 | +| mission_sub_id | NUMBER | 任務設定子表 ID [MissionSubSetting.id](http://MissionSubSetting.id)<br> | | | |
| 4 | +| activity_type | VARCHAR2(50 CHAR) | 條件類型 | 兌換票券：exchange_voucher<br>核銷票券：redeem_voucher<br>兌換點數：total_redeemed_point<br>登入：login<br>會員推薦：member_referral<br>第三方：third_party<br> | | |
| 5 | - | order | INT | 排序 | | | |
| 5 | + | order | NUMBER | 排序 | | | |
| 6 | -| id | INT | 主鍵 | 1 | | |
| 7 | -| mission_master_id | INT | 任務牆主檔 ID [MissionMasterSetting.id](http://MissionMasterSetting.id)<br> | | | |
| 8 | -| type | VARCHAR2(10 BYTE) | 名單類型 | beta：封測<br>white：白名單<br>black：黑名單 | | |
| 9 | -| file_name | VARCHAR2(400 CHAR) | 檔案名稱 | | | |
| 10 | - | file_path | VARCHAR2(4000 BYTE) | 樣板描述 | | | |
| 6 | + | id | NUMBER | 主鍵 | 1 | | |
| 7 | +| mission_master_id | NUMBER | 任務牆主檔 ID [MissionMasterSetting.id](http://MissionMasterSetting.id)<br> | | | |
| 8 | +| type | VARCHAR2(10 CHAR) | 名單類型 | beta：封測<br>white：白名單<br>black：黑名單 | | |
| 9 | +| filename | VARCHAR2(400 CHAR) | 檔名 | | | |
| 10 | +| filepath | VARCHAR2(4000 CHAR) | 路徑 | | | |
| 11 | -| id | INT | 主鍵 | 1 | | |
| 12 | -| category | VARCHAR2(20 BYTE) | 模版類型：<br>voucher 指定票券<br>referral 會員推薦<br>member_login 會員登入 | voucher | | |
| 13 | -| name | VARCHAR2(100 CHAR) | 樣板名稱 | 指定品牌與點數過濾模板 | | |
| 14 | - | description | TEXT | 樣板描述 | 限制指定品牌名稱及點數需大於門檻 | | |
| 11 | + | id | NUMBER | 主鍵 | 1 | | |
| 12 | +| category | VARCHAR2(30 CHAR) | 類型：<br>voucher 指定票券<br>referral 會員推薦<br>member_login 會員登入 | voucher | | |
| 13 | +| name | VARCHAR2(100 CHAR) | 名稱 | 指定品牌與點數過濾模板 | | |
| 14 | +| description | VARCHAR2(400 CHAR) | 描述 | 限制指定品牌名稱及點數需大於門檻 | | |
| 15 | -| create_id | INT | 建立 ID | | | |
| 16 | - | update_id | INT | 更新 ID | | | |
| 15 | + | create_id | NUMBER | 建立 ID | | | |
| 16 | +| update_id | NUMBER | 更新 ID | | | |
| 17 | - * 不包含：**not_like ** | |
| 17 | + * 不包含：**not_like (商品名、品牌名) or not_in (Serial_id、品牌ID)** | |
| 18 | -{ | |
| 19 | - "logic": "or", | |
| 20 | - "rules": | |
| 21 | 18 | [ |
| 22 | 19 | { |
| 23 | - "logic": "and", | |
| 24 | - "rules": | |
| 25 | - [ | |
| 26 | - { | |
| 27 | 20 | "field": "product_name", |
| 28 | 21 | "operator": "like", |
| 29 | - "values": ["現金券"] | |
| 22 | + "values": ["現金券", "抵用券"] | |
| 30 | 23 | }, |
| 31 | 24 | { |
| 32 | 25 | "field": "point_limit", |
| 33 | 26 | "values": [500] |
| 34 | 27 | } |
| 35 | 28 | ] |
| 36 | - }, | |
| 37 | - { | |
| 38 | - "logic": "and", | |
| 39 | - "rules": | |
| 40 | - [ | |
| 41 | - { | |
| 42 | - "field": "product_name", | |
| 43 | - "operator": "like", | |
| 44 | - "values": ["抵用券"] | |
| 45 | - }, | |
| 46 | - { | |
| 47 | - "field": "point_limit", | |
| 48 | - "operator": "gt", | |
| 49 | - "values": [500] | |
| 50 | - } | |
| 51 | - ] | |
| 52 | - } | |
| 53 | - ] | |
| 54 | -} | |
| 55 | -{ | |
| 56 | - "logic": "or", | |
| 57 | - "rules": | |
| 58 | 29 | [ |
| 59 | 30 | { |
| 60 | - "logic": "and", | |
| 61 | - "rules": | |
| 62 | - [ | |
| 63 | - { | |
| 64 | 31 | "field": "brand_id", |
| 65 | 32 | "operator": "in", |
| 66 | 33 | "values": ["7", "10"] |
| 67 | 34 | { |
| 68 | 35 | "field": "product_name", |
| 69 | 36 | "operator": "like", |
| 70 | - "values": ["拿鐵"] | |
| 37 | + "values": ["拿鐵","美式"] | |
| 71 | 38 | } |
| 72 | 39 | ] |
| 73 | - }, | |
| 74 | - { | |
| 75 | - "logic": "and", | |
| 76 | - "rules": | |
| 77 | - [ | |
| 78 | - { | |
| 79 | - "field": "brand_id", | |
| 80 | - "operator": "in", | |
| 81 | - "values": ["7", "10"] | |
| 82 | - }, | |
| 83 | - { | |
| 84 | - "field": "product_name", | |
| 85 | - "operator": "like", | |
| 86 | - "values": ["美式"] | |
| 87 | - } | |
| 88 | - ] | |
| 89 | - } | |
| 90 | - ] | |
| 91 | - } | |
| 40 | + [ | |
| 92 | 41 | "field": "member_identity", |
| 93 | - "operator": "eq", | |
| 42 | + "operator": "in", | |
| 94 | 43 | "values": ["CUBE_HOLDER"] |
| 44 | +] | |
| 45 | +[ | |
| 95 | 46 | "field": "continuous_login_days", |
| 96 | 47 | "operator": "equal", |
| 97 | 48 | "values": [7], |
| 49 | +] |