任務牆 table schema.md
12 additions, 12 deletions
| ... | ... | @@ -41,22 +41,22 @@ |
| 41 | -| id | Integer | 名單唯一識別碼 | 80001 | | |
| 42 | -| master_id | Integer | 關聯表 ID ([任務關聯表.id](http://任務關聯表.id)) | 1 | | |
| 43 | -| user_id | String | 用戶唯一識別碼 | USER_667788 | | |
| 44 | -| type | string | 名單類型 | 白名單/ 封測.... | | |
| 45 | -| create_time | Timestamp | 加入名單時間 | 2025-12-22 11:00:00 | | |
| 46 | - | update_time | Timestamp | 更新時間 | 2025-12-22 11:00:00 | | |
| 41 | + | id | NUMBER | 名單唯一識別碼 | 80001 | | |
| 42 | +| master_id | NUMBER | 關聯表 ID ([任務關聯表.id](http://任務關聯表.id)) | 1 | | |
| 43 | +| user_id | VARCHAR2(15 CHAR) NOT NULL | 用戶ID | USER_667788 | | |
| 44 | +| type | VARCHAR2(10 CHAR) | 名單類型 | 白名單 WHITELIST/ 封測 BETATEST | | |
| 45 | +| create_time | TIMESTAMP(6) | 建立時間 | 2025-12-22 11:00:00 | | |
| 46 | +| update_time | TIMESTAMP(6) | 更新時間 | 2025-12-22 11:00:00 | | |
| 47 | -| user_id | String | 用戶唯一識別碼 | USER_667788 | | |
| 48 | -| producer_id | String (unique) | kafka producer push id | | | |
| 49 | -| activity_type | String | 活動類型：兌換點數/ 兌換票券 / 核銷 / 登入 / mgm / 第三方 | | | |
| 50 | - | content | String (JSON) | 詳細紀錄內容(raw data) | {<br> "type": "exchange",<br> "content": {<br> "serialId": "01", "name": "A券","point":"500","deduct_time":"2025/12/30 00:09:00","amount":2<br> }<br>} | | |
| 47 | + | user_id | VARCHAR2(15 CHAR) NOT NULL | 用戶唯一識別碼 | USER_667788 | | |
| 48 | +| producer_id | VARCHAR2 UNIQUE | kafka producer push id | | | |
| 49 | +| activity_type | VARCHAR2(10 CHAR) | 活動類型：兌換點數/ 兌換票券 / 核銷 / 登入 / mgm / 第三方 | REDEEM_POINTS 兌換點數 / REDEEM_VOUCHER 兌換票券 / WRITE_OFF 核銷 / LOGIN 登入/ MGM / THIRD_PARTY 第三方 | | |
| 50 | +| content | VARCHAR2 (32767) | 詳細紀錄內容(raw data) | {<br> "type": "exchange",<br> "content": {<br> "serialId": "01", "name": "A券","point":"500","deduct_time":"2025/12/30 00:09:00","amount":2<br> }<br>} | | |
| 51 | - | user_id | String | 用戶唯一識別碼 | USER_667788 | | |
| 51 | + | user_id | String | 用戶ID | USER_667788 | | |
| 52 | - | record_id (rule engine寫入) | String （nullable) | [FK] [UserEventLog.id](http://UserEventLog.id)<br> | 1 | | |
| 52 | + | event_id (rule engine寫入) | Integer（nullable) | [FK] [UserEventLog.id](http://UserEventLog.id)<br> | 1 | |