Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | VARCHAR | 36 | null |
|
|
|||||||||
client_id | VARCHAR | 36 | √ | null |
|
|
||||||||
title | VARCHAR | 255 | null |
|
|
|||||||||
token | VARCHAR | 36 | √ | null |
|
|
||||||||
rootEntity | VARCHAR | 64 | null |
|
|
|||||||||
csvDelimiter | VARCHAR | 5 | null |
|
|
|||||||||
csvEnclosure | VARCHAR | 5 | √ | null |
|
|
||||||||
csvEncoding | VARCHAR | 32 | null |
|
|
|||||||||
itemsPerCall | INT | 10 | √ | null |
|
|
||||||||
lastLog | LONGTEXT | 2147483647 | √ | null |
|
|
||||||||
lastupdated | INT | 10 | null |
|
|
|||||||||
fileName | VARCHAR | 255 | √ | null |
|
|
||||||||
filter_id | VARCHAR | 36 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |
IDX_DDCE6D9A19EB6921 | Performance | Asc | client_id |
UNIQ_DDCE6D9AD395B25E | Must be unique | Asc | filter_id |