Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | VARCHAR | 36 | null |
|
|
|||||
| stringfield1 | VARCHAR | 255 | √ | null |
|
|
||||
| stringfield2 | VARCHAR | 255 | √ | null |
|
|
||||
| stringfield3 | VARCHAR | 255 | √ | null |
|
|
||||
| stringfield4 | VARCHAR | 255 | √ | null |
|
|
||||
| stringfield5 | VARCHAR | 255 | √ | null |
|
|
||||
| integerfield1 | INT | 10 | null |
|
|
|||||
| integerfield2 | INT | 10 | null |
|
|
|||||
| integerfield3 | INT | 10 | null |
|
|
|||||
| integerfield4 | INT | 10 | null |
|
|
|||||
| integerfield5 | INT | 10 | null |
|
|
|||||
| entitle | VARCHAR | 255 | √ | null |
|
|
||||
| enlongdesc | LONGTEXT | 2147483647 | √ | null |
|
|
||||
| stringfield6 | VARCHAR | 255 | √ | null |
|
|
||||
| stringfield7 | VARCHAR | 255 | √ | null |
|
|
||||
| stringfield8 | VARCHAR | 255 | √ | null |
|
|
||||
| stringfield9 | VARCHAR | 255 | √ | null |
|
|
||||
| stringfield10 | VARCHAR | 255 | √ | null |
|
|
||||
| integerfield6 | INT | 10 | null |
|
|
|||||
| integerfield7 | INT | 10 | null |
|
|
|||||
| integerfield8 | INT | 10 | null |
|
|
|||||
| integerfield9 | INT | 10 | null |
|
|
|||||
| integerfield10 | INT | 10 | null |
|
|
|||||
| stringfield11 | VARCHAR | 255 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| integerfield1_idx | Performance | Asc | integerfield1 |
| integerfield2_idx | Performance | Asc | integerfield2 |
| integerfield3_idx | Performance | Asc | integerfield3 |
| stringfield1_idx | Performance | Asc | stringfield1 |
| stringfield7_idx | Performance | Asc | stringfield7 |