PickListItem

Aggrosoft\WAWIBundle\Entity\PickListItem

Columns

Relations

Properties

Relationships

Click entity to navigate

→ PickList → Product → ProductSerialNumber → WarehouseStorageLocation → User

erDiagram
    PickListItem {
                string id PK
                integer sort
                decimal quantity
                decimal pickedQuantity
                boolean picked
                boolean virtualPicking
                        ___ ___more___
            }
                PickListItem }o--|| PickList : "pickList"
        PickList {
        int id PK
    }
                PickListItem }o--|| Product : "product"
        Product {
        int id PK
    }
                PickListItem }o--|| ProductSerialNumber : "serialNumber"
        ProductSerialNumber {
        int id PK
    }
                PickListItem }o--|| WarehouseStorageLocation : "location"
        WarehouseStorageLocation {
        int id PK
    }
                PickListItem }o--|| User : "fetchedByUser"
        User {
        int id PK
    }

Metadaten

Tabelle picklistitem

Bundle WAWIBundle

Property	Column	Type	Flags	Twig Access
`id`	`id`	`string(36)`	PK AUTO	{{ entity.id }}
`sort`	`sort`	`integer(11)`		{{ entity.sort }}
`quantity`	`quantity`	`decimal`		{{ entity.quantity }}
`pickedQuantity`	`pickedQuantity`	`decimal`		{{ entity.pickedQuantity }}
`picked`	`picked`	`boolean`		{{ entity.picked }}
`virtualPicking`	`virtualPicking`	`boolean`		{{ entity.virtualPicking }}
`fetchDate`	`fetchDate`	`datetime`		{{ entity.fetchDate }}

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

Property	Access	Twig Usage	Methods	Return Type
`pricingItem` Computed	read	{{ entity.pricingItem }}	`getPricingItem()`	-
`id` DB	read	{{ entity.id }}	`getId()`	`string`
`sort` DB	read write	{{ entity.sort }}	`getSort()` `setSort()`	`integer`
`quantity` DB	read write	{{ entity.quantity }}	`getQuantity()` `setQuantity()`	`float`
`pickList` DB	read write	{{ entity.pickList }}	`getPickList()` `setPickList()`	`\Aggrosoft\WAWIBundle\Entity\PickList`
`product` DB	read write	{{ entity.product }}	`getProduct()` `setProduct()`	`\Aggrosoft\WAWIBundle\Entity\Product`
`location` DB	read write	{{ entity.location }}	`getLocation()` `setLocation()`	`\Aggrosoft\WAWIBundle\Entity\WarehouseStorageLocation`
`picked` DB	read write	{{ entity.picked }}	`getPicked()` `setPicked()`	`boolean`
`serialNumber` DB	read write	{{ entity.serialNumber }}	`getSerialNumber()` `setSerialNumber()`	`\Aggrosoft\WAWIBundle\Entity\ProductSerialNumber`
`pickedQuantity` DB	read write	{{ entity.pickedQuantity }}	`getPickedQuantity()` `setPickedQuantity()`	`string`
`virtualPicking` DB	read write	{{ entity.virtualPicking }}	`getVirtualPicking()` `setVirtualPicking()`	`boolean`
`fetchDate` DB	read write	{{ entity.fetchDate }}	`getFetchDate()` `setFetchDate()`	`\DateTime`
`fetchedByUser` DB	read write	{{ entity.fetchedByUser }}	`getFetchedByUser()` `setFetchedByUser()`	`\Aggrosoft\WAWIBundle\Entity\User`

Property	Type	Target Entity	Mapped By	Inversed By	Cascade	Twig Access
`pickList`	ManyToOne	PickList	-	`items`	-	{{ entity.pickList }}
`product`	ManyToOne	Product	-	-	-	{{ entity.product }}
`serialNumber`	ManyToOne	ProductSerialNumber	-	-	-	{{ entity.serialNumber }}
`location`	ManyToOne	WarehouseStorageLocation	-	-	-	{{ entity.location }}
`fetchedByUser`	ManyToOne	User	-	-	-	{{ entity.fetchedByUser }}

Keine Indexes definiert