任務牆 table schema.md
6 additions, 7 deletions
| ... | ... | @@ -141,12 +141,12 @@ |
| 141 | -| id | Integer | | | | |
| 142 | -| CHAIN_TYPE | varchar(32) | 規則類型 | | | |
| 143 | -| CHAIN_ID | varchar(32) | 規則 ID | VERIFY001 | | |
| 144 | -| EL_DATA | text | 規則表達式 | SER..... | | |
| 145 | -| ENABLE | NUMBER(1) | 1 | 0: disable, 1: enable | | |
| 146 | - | CREATE_TIME | timestamp | 審核通過建立的時間 | | | |
| 141 | + | id | NUMBER | PK | | | |
| 142 | +| CHAIN_TYPE | VARCHAR2(50 CHAR) | 規則類型 | default: MISSION | | |
| 143 | +| CHAIN_ID | VARCHAR2(50 CHAR) | 規則編號 | VERIFY001 | | |
| 144 | +| EL_DATA | VARCHAR2 (32767 CHAR) | 規則表達式 | SER..... | | |
| 145 | +| ENABLE | NUMBER(1) | 是否可使用 | 0: disable, 1: enable | | |
| 146 | +| CREATE_TIME | TIMESTAMP(6) | 建立的時間 | | | |
| 147 | 147 | "logic": "and", |
| 148 | 148 | "rules": [ |
| 149 | - | |
| 150 | 149 | "sub_id": "S001", |
| 151 | 150 | "field": "serial_id", |
| 152 | 151 | "operator": "in", |