| ID |
int(11)
|
|
|
|
| cases_id |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| pj_id |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| CID |
int(11)
|
|
|
|
| CSName |
varchar(250)
|
utf8mb4_unicode_ci
|
|
|
| CSDate |
datetime
|
|
|
|
| CSPlace |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| CSPerson |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| CSMemo |
longtext
|
utf8mb4_unicode_ci
|
|
|
| CSSta |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| CSType |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| ModifyDate |
datetime
|
|
|
|
| TargetDate |
datetime
|
|
|
|
| DoneDate |
datetime
|
|
|
|
| Company |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| PSN |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| Keyword |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| TskLev |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| PID |
int(11)
|
|
|
|
| TreeLv |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| BLA |
char(1)
|
utf8mb4_unicode_ci
|
|
|
| AcctFI |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| AcctPJ |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| AcctAmt |
float
|
|
|
|
| UrgLev |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| ImpLev |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| FID |
int(11)
|
|
|
|
| CTR |
int(11)
|
|
|
|
| Target |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| Img |
char(1)
|
utf8mb4_unicode_ci
|
|
|
| SonOrdCL |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| parent_id |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
