Table Schema.md
84 additions, 36 deletions
| ... | ... | @@ -1,10 +1,22 @@ |
| 1 | - ## 子任務樣板 CMS_SUBMISSION_PATTERNS | |
| 1 | + ## 任務牆名單檔 CMS_MISSION_MEMBER_LIST | |
| 2 | +| task_master_id | INT | 任務牆主檔 ID [TaskMasterSetting.id](http://TaskMasterSetting.id)<br> | | | |
| 3 | +| type | VARCHAR2(10) | 名單類型 | BETA：封測<br>WHITE：白名單<br>BLACK：黑名單 | | |
| 4 | +| file_name | VARCHAR2(400) | 檔案名稱 | | | |
| 5 | +| file_path | VARCHAR2(4000) | 樣板描述 | | | |
| 6 | +| create_time | TIMESTAMP | 建立時間 | | | |
| 7 | +| update_time | TIMESTAMP | 更新時間 | | | |
| 8 | + | |
| 9 | +## 任務樣板 CMS_MISSION_PATTERNS | |
| 10 | + | |
| 11 | +| 欄位名稱 (Field) | 資料型別 (Type) | 說明 (Description) | 範例 (Example) | | |
| 12 | +| ---| ---| ---| --- | | |
| 13 | +| id | INT | 主鍵 | 1 | | |
| 14 | +{ | |
| 15 | + "logic": "or", | |
| 16 | + "rules": | |
| 2 | 17 | { |
| 3 | - "field": "PRODUCT_NAME", | |
| 4 | - "operator": "ilike", | |
| 5 | - "values": ["現金券", "抵用券"] | |
| 18 | + "logic": "and", | |
| 19 | + "rules": | |
| 20 | + [ | |
| 21 | + { | |
| 22 | + "field": "product_name", | |
| 23 | + "operator": "like", | |
| 24 | + "values": ["現金券"] | |
| 6 | 25 | }, |
| 7 | 26 | { |
| 8 | - "field": "PROUDCT_NAME", | |
| 27 | + "field": "point_limit", | |
| 9 | 28 | "operator": "gt", |
| 10 | 29 | "values": [500] |
| 11 | 30 | } |
| 31 | + }, | |
| 32 | + { | |
| 33 | + "logic": "and", | |
| 34 | + "rules": | |
| 35 | + [ | |
| 36 | + { | |
| 37 | + "field": "product_name", | |
| 38 | + "operator": "like", | |
| 39 | + "values": ["抵用券"] | |
| 40 | + }, | |
| 41 | + { | |
| 42 | + "field": "point_limit", | |
| 43 | + "operator": "gt", | |
| 44 | + "values": [500] | |
| 45 | + } | |
| 46 | + ] | |
| 47 | + } | |
| 48 | + ] | |
| 49 | +} | |
| 50 | +{ | |
| 51 | + "logic": "or", | |
| 52 | + "rules": | |
| 12 | 53 | { |
| 13 | - "field": "BRAND_ID", | |
| 54 | + "logic": "and", | |
| 55 | + "rules": | |
| 56 | + [ | |
| 57 | + { | |
| 58 | + "field": "brand_id", | |
| 14 | 59 | "operator": "in", |
| 15 | - "values": [7", "10"], | |
| 60 | + "values": ["7", "10"] | |
| 16 | 61 | }, |
| 17 | 62 | { |
| 18 | - "field": "PROUDCT_NAME", | |
| 19 | - "operator": "ilike", | |
| 20 | - "values": ["拿鐵", "美式"] | |
| 63 | + "field": "product_name", | |
| 64 | + "operator": "like", | |
| 65 | + "values": ["拿鐵"] | |
| 21 | 66 | } |
| 67 | + }, | |
| 68 | + { | |
| 69 | + "logic": "and", | |
| 70 | + "rules": | |
| 71 | + [ | |
| 72 | + { | |
| 73 | + "field": "brand_id", | |
| 74 | + "operator": "in", | |
| 75 | + "values": ["7", "10"] | |
| 76 | + }, | |
| 77 | + { | |
| 78 | + "field": "product_name", | |
| 79 | + "operator": "like", | |
| 80 | + "values": ["美式"] | |
| 81 | + } | |
| 82 | + ] | |
| 83 | + } | |
| 84 | + ] | |
| 85 | +} | |
| 22 | -[ | |
| 23 | 86 | { |
| 24 | - "field": "MEMBER_IDENTITY", | |
| 87 | + "field": "member_identity", | |
| 25 | 88 | "operator": "eq", |
| 26 | 89 | "values": ["CUBE_HOLDER"] |
| 27 | 90 | } |
| 28 | -] | |
| 29 | -[ | |
| 30 | 91 | { |
| 31 | - "field": "CONTINUOUS_LOGIN_DAYS", | |
| 92 | + "field": "continuous_login_days", | |
| 32 | 93 | "operator": "equal", |
| 33 | 94 | "values": [7], |
| 34 | 95 | } |
| 35 | -] | |
| 36 | -* SERIAL_ID | |
| 37 | -* BRAND_ID | |
| 38 | -* BRNAD_NAME | |
| 39 | -* PRODUCT_NAME | |
| 40 | - * POINT_LIMIT | |
| 96 | + * serial_id | |
| 97 | +* brand_id | |
| 98 | +* brand_name | |
| 99 | +* product_name | |
| 100 | +* point_limit | |
| 41 | - * MEMBER_IDENTITY | |
| 101 | + * member_identity | |
| 42 | -* CONTINUOUS_LOGIN_DAYS | |
| 43 | - * ACCUMULATED_LOGIN_DAYS | |
| 102 | + * continuous_login_days | |
| 103 | +* accumulated_login_days | |
| 44 | 104 | ] |
| 45 | - | |
| 46 | -## 任務牆名單檔 CMS_MISSION_MEMBER_LIST | |
| 47 | - | |
| 48 | -| 欄位名稱 (Field) | 資料型別 (Type) | 說明 (Description) | 範例 (Example) | | |
| 49 | -| ---| ---| ---| --- | | |
| 50 | -| id | INT | 主鍵 | 1 | | |
| 51 | -| task_master_id | INT | 任務牆主檔 ID [TaskMasterSetting.id](http://TaskMasterSetting.id)<br> | | | |
| 52 | -| type | VARCHAR2(10) | 名單類型 | BETA：封測<br>WHITE：白名單<br>BLACK：黑名單 | | |
| 53 | -| file_name | VARCHAR2(400) | 檔案名稱 | | | |
| 54 | -| file_path | VARCHAR2(4000) | 樣板描述 | | | |
| 55 | -| create_time | TIMESTAMP | 建立時間 | | | |
| 56 | -| update_time | TIMESTAMP | 更新時間 | | |