csvimport

26 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
csvimport_objectgroup.csvimport_id FK_92DD9FF6E825CECDC
csvimportfield.csvimport_id FK_6D358D44E825CECDR
csvimportjob.csvimport_id FK_75BCEB05E825CECDR
csvimportkeyfield.csvimport_id FK_DAC2B5EE825CECDR
csvimportvariationfield.csvimport_id FK_800B0581E825CECDR
csvrow.csvimport_id FK_B4F596C1E825CECDR
client_id VARCHAR 36 null
client.id FK_20CB51319EB6921R
title VARCHAR 255 null
active BIT 1 null
csvPath VARCHAR 255 null
user VARCHAR 255 null
password VARCHAR 255 null
tableName VARCHAR 64 null
csvDelimiter VARCHAR 5 null
csvEnclosure VARCHAR 5 null
csvEncoding VARCHAR 32 null
variationField VARCHAR 255 null
csvFile VARCHAR 255 null
lastupdated INT 10 null
primaryKeyField VARCHAR 255 null
useUpload BIT 1 null
itemsPerCall INT 10 null
customService VARCHAR 255 null
downloadData BIT 1 null
onlyUpdate BIT 1 null
purgeData BIT 1 null
importRowCondition LONGTEXT 2147483647 null
token VARCHAR 36 null
lastLog LONGTEXT 2147483647 null
primaryKeyField2 VARCHAR 255 null
variationGroupingField VARCHAR 255 null
importMode INT 10 null
replaceForeignItems INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_20CB51319EB6921 Performance Asc client_id

Relationships