CSVImport

Aggrosoft\WAWIBundle\Entity\CSVImport

Columns

Relations

Properties

Relationships

Click entity to navigate

← CSVImportField ← CSVImportVariationField → Client → User ↔ ObjectGroup

erDiagram
    CSVImport {
                string id PK
                string title
                boolean active
                string token
                boolean useUpload
                boolean downloadData
                        ___ ___more___
            }
                CSVImport ||--o{ CSVImportField : "fields"
        CSVImportField {
        int id PK
    }
                CSVImport ||--o{ CSVImportVariationField : "variationFields"
        CSVImportVariationField {
        int id PK
    }
                CSVImport }o--|| Client : "client"
        Client {
        int id PK
    }
                CSVImport }o--|| User : "executedByUser"
        User {
        int id PK
    }
                CSVImport }o--o{ ObjectGroup : "groups"
        ObjectGroup {
        int id PK
    }

Metadaten

Tabelle csvimport

Bundle WAWIBundle

Interfaces

IClientable IUpload IClientClonable IGroupable IUpdateTimeTrackable

Property	Column	Type	Flags	Twig Access
`id`	`id`	`string(36)`	PK AUTO	{{ entity.id }}
`title`	`title`	`string(255)`		{{ entity.title }}
`active`	`active`	`boolean`		{{ entity.active }}
`token`	`token`	`string(36)`		{{ entity.token }}
`useUpload`	`useUpload`	`boolean`		{{ entity.useUpload }}
`downloadData`	`downloadData`	`boolean`		{{ entity.downloadData }}
`onlyUpdate`	`onlyUpdate`	`boolean`		{{ entity.onlyUpdate }}
`importType`	`importType`	`integer`		{{ entity.importType }}
`replaceForeignItems`	`replaceForeignItems`	`integer`		{{ entity.replaceForeignItems }}
`missingColumnPolicy`	`missingColumnPolicy`	`integer`		{{ entity.missingColumnPolicy }}
`purgeData`	`purgeData`	`boolean`		{{ entity.purgeData }}
`csvPath`	`csvPath`	`string(255)`		{{ entity.csvPath }}
`user`	`user`	`string(255)`		{{ entity.user }}
`password`	`password`	`string(255)`		{{ entity.password }}
`tableName`	`tableName`	`string(64)`		{{ entity.tableName }}
`csvDelimiter`	`csvDelimiter`	`string(5)`		{{ entity.csvDelimiter }}
`csvEnclosure`	`csvEnclosure`	`string(5)`		{{ entity.csvEnclosure }}
`csvEncoding`	`csvEncoding`	`string(32)`		{{ entity.csvEncoding }}
`variationField`	`variationField`	`string(255)`		{{ entity.variationField }}
`variationGroupingField`	`variationGroupingField`	`string(255)`		{{ entity.variationGroupingField }}
`primaryKeyField`	`primaryKeyField`	`string(255)`		{{ entity.primaryKeyField }}
`alternativePrimaryKeyField`	`alternativePrimaryKeyField`	`string(255)`		{{ entity.alternativePrimaryKeyField }}
`primaryKeyField2`	`primaryKeyField2`	`string(255)`		{{ entity.primaryKeyField2 }}
`primaryKeyField3`	`primaryKeyField3`	`string(255)`		{{ entity.primaryKeyField3 }}
`csvFileName`	`csvFile`	`string(255)`		{{ entity.csvFileName }}
`itemsPerCall`	`itemsPerCall`	`integer`		{{ entity.itemsPerCall }}
`customService`	`customService`	`string(255)`		{{ entity.customService }}
`importRowCondition`	`importRowCondition`	`text`		{{ entity.importRowCondition }}
`customHeader`	`customHeader`	`text`		{{ entity.customHeader }}
`lastLog`	`lastLog`	`text`		{{ entity.lastLog }}
`note`	`note`	`text`		{{ entity.note }}
`afterImportRowAction`	`afterImportRowAction`	`text`		{{ entity.afterImportRowAction }}
`importMode`	`importMode`	`integer`		{{ entity.importMode }}
`archiveLogs`	`archiveLogs`	`boolean`		{{ entity.archiveLogs }}
`updated`	`updated`	`datetime`		{{ entity.updated }}
`lastUpdated`	`lastupdated`	`integer(11)`		{{ entity.lastUpdated }}

Tipp: Diese Properties sind über Getter/Setter-Methoden in Twig verfügbar. Verwende {{ entity.propertyName }} zum Lesen.

Property	Access	Twig Usage	Methods	Return Type
`client` DB	read write	{{ entity.client }}	`getClient()` `setClient()`	`\Aggrosoft\WAWIBundle\Entity\Client`
`id` DB	read	{{ entity.id }}	`getId()`	`string`
`title` DB	read write	{{ entity.title }}	`getTitle()` `setTitle()`	`string`
`active` DB	read write	{{ entity.active }}	`getActive()` `setActive()`	`boolean`
`user` DB	read write	{{ entity.user }}	`getUser()` `setUser()`	`string`
`password` DB	read write	{{ entity.password }}	`getPassword()` `setPassword()`	`string`
`table` Computed	read write	{{ entity.table }}	`getTable()` `setTable()`	`string`
`fields` DB	read	{{ entity.fields }}	`getFields()`	`\Doctrine\Common\Collections\Collection`
`csvPath` DB	read write	{{ entity.csvPath }}	`getCsvPath()` `setCsvPath()`	`string`
`csvDelimiter` DB	read write	{{ entity.csvDelimiter }}	`getCsvDelimiter()` `setCsvDelimiter()`	`string`
`csvEnclosure` DB	read write	{{ entity.csvEnclosure }}	`getCsvEnclosure()` `setCsvEnclosure()`	`string`
`csvEncoding` DB	read write	{{ entity.csvEncoding }}	`getCsvEncoding()` `setCsvEncoding()`	`string`
`tableName` DB	read write	{{ entity.tableName }}	`getTableName()` `setTableName()`	`string`
`variationField` DB	read write	{{ entity.variationField }}	`getVariationField()` `setVariationField()`	`string`
`variationFields` DB	read	{{ entity.variationFields }}	`getVariationFields()`	`\Doctrine\Common\Collections\Collection`
`subPath` Computed	read	{{ entity.subPath }}	`getSubPath()`	-
`uploadFields` Computed	read	{{ entity.uploadFields }}	`getUploadFields()`	-
`csvFileName` DB	read write	{{ entity.csvFileName }}	`getCsvFileName()` `setCsvFileName()`	`string`
`lastUpdated` DB	read write	{{ entity.lastUpdated }}	`getLastUpdated()` `setLastUpdated()`	`integer`
`csvFile` Computed	read write	{{ entity.csvFile }}	`getCsvFile()` `setCsvFile()`	-
`primaryKeyField` DB	read write	{{ entity.primaryKeyField }}	`getPrimaryKeyField()` `setPrimaryKeyField()`	`string`
`hasHeader` Computed	read write	{{ entity.hasHeader }}	`getHasHeader()` `setHasHeader()`	`boolean`
`useUpload` DB	read write	{{ entity.useUpload }}	`getUseUpload()` `setUseUpload()`	`boolean`
`itemsPerCall` DB	read write	{{ entity.itemsPerCall }}	`getItemsPerCall()` `setItemsPerCall()`	`integer`
`customService` DB	read write	{{ entity.customService }}	`getCustomService()` `setCustomService()`	`string`
`downloadData` DB	read write	{{ entity.downloadData }}	`getDownloadData()` `setDownloadData()`	`boolean`
`onlyUpdate` DB	read write	{{ entity.onlyUpdate }}	`getOnlyUpdate()` `setOnlyUpdate()`	`boolean`
`purgeData` DB	read write	{{ entity.purgeData }}	`getPurgeData()` `setPurgeData()`	`boolean`
`importRowCondition` DB	read write	{{ entity.importRowCondition }}	`getImportRowCondition()` `setImportRowCondition()`	`string`
`token` DB	read write	{{ entity.token }}	`getToken()` `setToken()`	`string`
`lastLog` DB	read write	{{ entity.lastLog }}	`getLastLog()` `setLastLog()`	`string`
`removeRouter` Computed	read	{{ entity.removeRouter }}	`getRemoveRouter()`	-
`primaryKeyField2` DB	read write	{{ entity.primaryKeyField2 }}	`getPrimaryKeyField2()` `setPrimaryKeyField2()`	`string`
`variationGroupingField` DB	read write	{{ entity.variationGroupingField }}	`getVariationGroupingField()` `setVariationGroupingField()`	`string`
`importMode` DB	read write	{{ entity.importMode }}	`getImportMode()` `setImportMode()`	`integer`
`groups` DB	read	{{ entity.groups }}	`getGroups()`	`\Doctrine\Common\Collections\Collection`
`replaceForeignItems` DB	read write	{{ entity.replaceForeignItems }}	`getReplaceForeignItems()` `setReplaceForeignItems()`	`int`
`executedByUser` DB	read write	{{ entity.executedByUser }}	`getExecutedByUser()` `setExecutedByUser()`	`\Aggrosoft\WAWIBundle\Entity\User`
`primaryKeyField3` DB	read write	{{ entity.primaryKeyField3 }}	`getPrimaryKeyField3()` `setPrimaryKeyField3()`	`string`
`customData` Computed	write		`setCustomData()`	-
`importType` DB	read write	{{ entity.importType }}	`getImportType()` `setImportType()`	`integer`
`note` DB	read write	{{ entity.note }}	`getNote()` `setNote()`	`string`
`afterImportRowAction` DB	read write	{{ entity.afterImportRowAction }}	`getAfterImportRowAction()` `setAfterImportRowAction()`	`string`
`alternativePrimaryKeyField` DB	read write	{{ entity.alternativePrimaryKeyField }}	`getAlternativePrimaryKeyField()` `setAlternativePrimaryKeyField()`	`string`
`customHeader` DB	read write	{{ entity.customHeader }}	`getCustomHeader()` `setCustomHeader()`	`string`
`updated` DB	read write	{{ entity.updated }}	`getUpdated()` `setUpdated()`	`\DateTime`
`missingColumnPolicy` DB	read write	{{ entity.missingColumnPolicy }}	`getMissingColumnPolicy()` `setMissingColumnPolicy()`	`integer`
`archiveLogs` DB	read write	{{ entity.archiveLogs }}	`getArchiveLogs()` `setArchiveLogs()`	`boolean`

Property	Type	Target Entity	Mapped By	Inversed By	Cascade	Twig Access
`fields`	OneToMany	CSVImportField	`csvimport`	-	`persist` `remove` `refresh`	{{ entity.fields }}
`variationFields`	OneToMany	CSVImportVariationField	`csvimport`	-	`persist` `remove` `refresh`	{{ entity.variationFields }}
`client`	ManyToOne	Client	-	-	-	{{ entity.client }}
`executedByUser`	ManyToOne	User	-	-	-	{{ entity.executedByUser }}
`groups`	ManyToMany	ObjectGroup	-	`csvimports`	-	{{ entity.groups }}

Keine Indexes definiert