DB Schema.md
9 additions, 6 deletions
| ... | ... | @@ -8,15 +8,16 @@ |
| 8 | - | voucher_format| VARCHAR2(10)| | | 來源為 t_bas_bonus_item_info 不可修改，不另開欄位存放<br>票券類型:<br>text<br>barcode<br>qrcode<br>image<br> | | |
| 8 | + | ~~voucher_format~~ | ~~VARCHAR2(10)~~ | | | 來源為 t_bas_bonus_item_info 不可修改，不另開欄位存放<br>~~票券類型:~~<br>text<br>barcode<br>qrcode<br>image<br> | | |
| 9 | -| status | VARCHAR2(20) | Y | | 狀態:<br>reserved: 尚未開始給券<br>start: 開始給券<br>assigned: 給券完成<br>failed: 給券異常<br>canceled: 取消給券<br>invalid: 整批作廢<br> | | |
| 10 | - | file_identity_type | VARCAHR2(30) | | | 名單類型:<br>national_id: 身份證字號<br>invite_code: 邀請碼<br>| | |
| 9 | + | status | VARCHAR2(20) | Y | | 狀態:<br><br><br><br><br><br><br> | | |
| 10 | +| file_identity_type | VARCAHR2(30) | | | 名單類型:<br><br><br> | | |
| 11 | +| result_file_path | VARCHAR2(1024) | | | 結果檔路徑 | | |
| 11 | -| valid_end_time | TIMESTAMP | | | 票券有效迄日 | | |
| 12 | - | status | VARCHAR2(10) | | | 票券狀態:<br>reserved: 圈存中<br>assigned: 給券完成<br>unreserved: 解除圈存<br>invalid: 作廢<br> | | |
| 12 | + | ~~valid_end_time~~ | ~~TIMESTAMP~~ | | | ~~票券有效迄日~~ | | |
| 13 | +| status | VARCHAR2(10) | | | 票券狀態:<br><br><br><br><br> | | |
| 13 | - | update_time| TIMESTAMP| | | 更新時間| | |
| 14 | + | ~~update_time~~ | ~~TIMESTAMP~~ | | | ~~更新時間~~ | | |
| 14 | 15 | STATUS VARCHAR2(20 CHAR), |
| 15 | 16 | FILE_IDENTITY_TYPE VARCHAR2(30 CHAR) NOT NULL, |
| 16 | 17 | FILE_PATH VARCHAR2(1024 CHAR) NOT NULL, |
| 18 | + RESULT_FILE_PATH VARCHAR2(1024 CHAR) NOT NULL, | |
| 17 | 19 | CREATE_TIME TIMESTAMP(6) DEFAULT SYSTIMESTAMP NOT NULL, |
| 18 | 20 | UPDATE_TIME TIMESTAMP(6), |
| 19 | 21 | CONSTRAINT "CMS_ASSIGNED_COUPON_PK" PRIMARY KEY (ID) |
| 22 | +COMMENT ON COLUMN DBMT.CMS_ASSIGNED_COUPON.RESULT_FILE_PATH IS '結果檔名單路徑'; |