OrderTask

Aggrosoft\WAWIBundle\Entity\OrderTask

Columns

Relations

Properties

Relationships

Click entity to navigate

→ User → Customer → User → Order → WorkflowEvent → EntityStatus

erDiagram
    OrderTask {
                string id PK
                integer sort
                string title
                text description
                text note
                datetime created
                        ___ ___more___
            }
                OrderTask }o--|| User : "clerk"
        User {
        int id PK
    }
                OrderTask }o--|| Customer : "externalClerk"
        Customer {
        int id PK
    }
                OrderTask }o--|| User : "createdBy"
        User {
        int id PK
    }
                OrderTask }o--|| Order : "order"
        Order {
        int id PK
    }
                OrderTask }o--|| WorkflowEvent : "workflowAction"
        WorkflowEvent {
        int id PK
    }
                OrderTask }o--|| EntityStatus : "status"
        EntityStatus {
        int id PK
    }

Metadaten

Tabelle ordertask

Bundle WAWIBundle

Interfaces

IUpload IForeignClientable

Property	Column	Type	Flags	Twig Access
`id`	`id`	`string(36)`	PK AUTO	{{ entity.id }}
`sort`	`sort`	`integer(11)`		{{ entity.sort }}
`title`	`title`	`string(255)`		{{ entity.title }}
`description`	`description`	`text`		{{ entity.description }}
`note`	`note`	`text`		{{ entity.note }}
`created`	`created`	`datetime`		{{ entity.created }}
`fulfillmentBeginDate`	`fulfillmentBeginDate`	`datetime`		{{ entity.fulfillmentBeginDate }}
`fulfillmentEndDate`	`fulfillmentEndDate`	`datetime`		{{ entity.fulfillmentEndDate }}
`completedDate`	`completedDate`	`datetime`		{{ entity.completedDate }}
`fileName`	`file`	`string(255)`		{{ entity.fileName }}
`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
`file` Computed	read write	{{ entity.file }}	`getFile()` `setFile()`	-
`uploadFields` Computed	read	{{ entity.uploadFields }}	`getUploadFields()`	-
`subPath` Computed	read	{{ entity.subPath }}	`getSubPath()`	-
`foreignClient` Computed	read	{{ entity.foreignClient }}	`getForeignClient()`	-
`removeRouter` Computed	read	{{ entity.removeRouter }}	`getRemoveRouter()`	-
`id` DB	read	{{ entity.id }}	`getId()`	`string`
`sort` DB	read write	{{ entity.sort }}	`getSort()` `setSort()`	`integer`
`title` DB	read write	{{ entity.title }}	`getTitle()` `setTitle()`	`string`
`description` DB	read write	{{ entity.description }}	`getDescription()` `setDescription()`	`string`
`created` DB	read write	{{ entity.created }}	`getCreated()` `setCreated()`	`\DateTime`
`fileName` DB	read write	{{ entity.fileName }}	`getFileName()` `setFileName()`	`string`
`lastUpdated` DB	read write	{{ entity.lastUpdated }}	`getLastUpdated()` `setLastUpdated()`	`integer`
`order` DB	read write	{{ entity.order }}	`getOrder()` `setOrder()`	`\Aggrosoft\WAWIBundle\Entity\Order`
`workflowAction` DB	read write	{{ entity.workflowAction }}	`getWorkflowAction()` `setWorkflowAction()`	`\Aggrosoft\WAWIBundle\Entity\WorkflowEvent`
`status` DB	read write	{{ entity.status }}	`getStatus()` `setStatus()`	`\Aggrosoft\WAWIBundle\Entity\EntityStatus`
`fulfillmentBeginDate` DB	read write	{{ entity.fulfillmentBeginDate }}	`getFulfillmentBeginDate()` `setFulfillmentBeginDate()`	`\DateTime`
`fulfillmentEndDate` DB	read write	{{ entity.fulfillmentEndDate }}	`getFulfillmentEndDate()` `setFulfillmentEndDate()`	`\DateTime`
`completedDate` DB	read write	{{ entity.completedDate }}	`getCompletedDate()` `setCompletedDate()`	`\DateTime`
`note` DB	read write	{{ entity.note }}	`getNote()` `setNote()`	`string`
`clerk` DB	read write	{{ entity.clerk }}	`getClerk()` `setClerk()`	`\Aggrosoft\WAWIBundle\Entity\User`
`externalClerk` DB	read write	{{ entity.externalClerk }}	`getExternalClerk()` `setExternalClerk()`	`\Aggrosoft\WAWIBundle\Entity\Customer`
`createdBy` DB	read write	{{ entity.createdBy }}	`getCreatedBy()` `setCreatedBy()`	`\Aggrosoft\WAWIBundle\Entity\User`

Property	Type	Target Entity	Mapped By	Inversed By	Cascade	Twig Access
`clerk`	ManyToOne	User	-	-	-	{{ entity.clerk }}
`externalClerk`	ManyToOne	Customer	-	-	-	{{ entity.externalClerk }}
`createdBy`	ManyToOne	User	-	-	-	{{ entity.createdBy }}
`order`	ManyToOne	Order	-	-	-	{{ entity.order }}
`workflowAction`	ManyToOne	WorkflowEvent	-	-	-	{{ entity.workflowAction }}
`status`	ManyToOne	EntityStatus	-	-	-	{{ entity.status }}

Keine Indexes definiert