任務牆 table schema.md
10 additions, 13 deletions
| ... | ... | @@ -137,31 +137,28 @@ |
| 137 | - | 名稱欄位 | 型態 | 欄位說明 | example | | |
| 137 | + | 名稱欄位 | 型態 | 欄位範例和說明 | 欄位說明 | | |
| 138 | -| id | Integer | PK | 1 | | |
| 139 | -| CHAIN_APPLICATION | varchar(32) DEFAULT NULL, | main mission | MISSION_RULE | | |
| 140 | -| CHAIN_ID | varchar(32) | | RULE_01 | | |
| 141 | -| CHAIN_NAME | varchar(100) DEFAULT NULL | | | | |
| 142 | -| CHAIN_DESCRIPTION | varchar(200) DEFAULT NULL, | | | | |
| 143 | -| EL_DATA | text | Rule engine flow | SER(SERIAL_ID, IN) | | |
| 144 | -| ROUTE | text | | | | |
| 145 | - | ENABLE | boolean | | | | |
| 138 | + | id | Integer | | | | |
| 139 | +| CHAIN_ID | varchar(32) | ex. MISSION_01 | VERIFY001 | | |
| 140 | +| MASTER_ID | NUMBER DEFAULT NULL (cms填寫) | [MissionMasterSetting.ID](http://MissionMasterSetting.ID) | NULL | | |
| 141 | +| MISSION_NAME | VARCHAR2(50 CHAR) (cms填寫) | 母任務名稱 | 驗證流程定義 | | |
| 142 | +| MISSION_SUMMARY | varchar(200) DEFAULT NULL (cms填寫) | 母任務簡述 | | | |
| 143 | +| EL_DATA | text | 寫入整個母任務的el表達式: SER(<br>VERIFY001,<br>AND(<br>SER(SERIAL_ID, IN).TAG("1", "2", "3", "4", "5", "6", "7", "8", "9", "10"),<br>SER(PRODUCT_NAME, IN).TAG("星巴克 150 元券", "威秀電影票"),<br>AND(<br>OR(<br>SER(PRODUCT_NAME, LIKE).TAG("現金券"),<br>SER(PRODUCT_NAME, LIKE).TAG("抵用券")<br>),<br>SER(total_cub_points, gt).TAG("500")<br>)<br>)<br>) | SER..... | | |
| 144 | +| ENABLE | NUMBER(1) | 1 | 1 | | |
| 146 | -| FIELD | varchar(32) | | SERIAL_ID | | |
| 147 | -| OPEATOR | varchar(32) | | IN | | |
| 148 | - S003: "品名中包含 "現金券" or "抵用券" 且 總兌換點數大於 500" | |
| 145 | + S003: "品名中包含 "現金券" And "抵用券" 且 總兌換點數大於 500" | |
| 149 | 146 | "logic": "and", |
| 150 | 147 | "rules": [ |
| 151 | - { | |
| 148 | + | |
| 152 | 149 | "sub_id": "S001", |
| 153 | 150 | "field": "serial_id", |
| 154 | 151 | "operator": "in", |