Table Schema.md
27 additions, 4 deletions
| ... | ... | @@ -14,23 +14,47 @@ |
| 14 | +* 2026/01/13 討論確定當 values 裡的條件都會是 or | |
| 15 | +/*品名中包含 "現金券" or "抵用券"且點數大於 500*/ | |
| 14 | 16 | { |
| 15 | - "field": "BRAND_NAME", | |
| 17 | + "field": "PRODUCT_NAME", | |
| 16 | 18 | "operator": "ilike", |
| 17 | - "values": ["Nike"] | |
| 19 | + "values": ["現金券", "抵用券"] | |
| 18 | 20 | }, |
| 19 | 21 | { |
| 20 | - "field": "POINT_LIMIT", | |
| 22 | + "field": "PROUDCT_NAME", | |
| 21 | 23 | "operator": "gt", |
| 22 | 24 | "values": [500] |
| 23 | 25 | } |
| 26 | +* 石二鍋現金券 600 元 ( 580 點) | |
| 27 | +* 7-11 抵用券 550 元 ( 545 點) | |
| 28 | + | |
| 29 | +```json | |
| 30 | +/*品牌為 7-11 or 全家且品名中包含拿鐵 or 美式*/ | |
| 31 | +[ | |
| 32 | + { | |
| 33 | + "field": "BRAND_ID", | |
| 34 | + "operator": "in", | |
| 35 | + "values": [7", "10"], | |
| 36 | + }, | |
| 37 | + { | |
| 38 | + "field": "PROUDCT_NAME", | |
| 39 | + "operator": "ilike", | |
| 40 | + "values": ["拿鐵", "美式"] | |
| 41 | + } | |
| 42 | +] | |
| 43 | +``` | |
| 44 | + | |
| 45 | +* 7-11大杯拿鐵兌換券 (brand_id = 7) | |
| 46 | +* 星巴克中杯美式兌換券 (brand_id = 10) | |
| 47 | + | |
| 24 | -### |