csvimport

48 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
executedByUser_id INT 10 √ null
users.id FK_20CB513AC0848D2R
primaryKeyField3 VARCHAR 255 √ null
importType INT 10 null

Indexes

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

Relationships

Close relationships within degrees of separation