PicklistReservation

Aggrosoft\WAWIBundle\Entity\PicklistReservation
9
Columns
6
Relations
15
Properties

Relationships

Click entity to navigate
erDiagram
    PicklistReservation {
                string id PK
                datetime created
                decimal quantity
                decimal currentQuantity
                decimal previousQuantity
                string uniqNumber
                        ___ ___more___
            }
                PicklistReservation }o--|| WarehouseStorageLocation : "location"
        WarehouseStorageLocation {
        int id PK
    }
                PicklistReservation }o--|| Product : "product"
        Product {
        int id PK
    }
                PicklistReservation }o--|| ProductSerialNumber : "serialNumber"
        ProductSerialNumber {
        int id PK
    }
                PicklistReservation }o--|| PickListItem : "pickListItem"
        PickListItem {
        int id PK
    }
                PicklistReservation }o--o{ Order : "orders"
        Order {
        int id PK
    }
                PicklistReservation }o--|| User : "user"
        User {
        int id PK
    }
                    

Metadaten

Tabelle picklistreservation
Bundle WAWIBundle
Property Column Type Flags Twig Access
id id string(36)
PK AUTO
{{ entity.id }}
created created datetime
{{ entity.created }}
quantity quantity decimal
{{ entity.quantity }}
currentQuantity currentQuantity decimal
{{ entity.currentQuantity }}
previousQuantity previousQuantity decimal
{{ entity.previousQuantity }}
uniqNumber uniqNumber string(128)
{{ entity.uniqNumber }}
type type string(2)
{{ entity.type }}
last last boolean
{{ entity.last }}
exactTime exactTime float
{{ entity.exactTime }}

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

Property Access Twig Usage Methods Return Type
id DB
read
{{ entity.id }}
getId()
string
created DB
read write
{{ entity.created }}
getCreated()
setCreated()
\DateTime
quantity DB
read write
{{ entity.quantity }}
getQuantity()
setQuantity()
string
currentQuantity DB
read write
{{ entity.currentQuantity }}
getCurrentQuantity()
setCurrentQuantity()
string
previousQuantity DB
read write
{{ entity.previousQuantity }}
getPreviousQuantity()
setPreviousQuantity()
string
uniqNumber DB
read write
{{ entity.uniqNumber }}
getUniqNumber()
setUniqNumber()
string
type DB
read write
{{ entity.type }}
getType()
setType()
string
exactTime DB
read write
{{ entity.exactTime }}
getExactTime()
setExactTime()
float
location DB
read write
{{ entity.location }}
getLocation()
setLocation()
\Aggrosoft\WAWIBundle\Entity\WarehouseStorageLocation
product DB
read write
{{ entity.product }}
getProduct()
setProduct()
\Aggrosoft\WAWIBundle\Entity\Product
serialNumber DB
read write
{{ entity.serialNumber }}
getSerialNumber()
setSerialNumber()
\Aggrosoft\WAWIBundle\Entity\ProductSerialNumber
pickListItem DB
read write
{{ entity.pickListItem }}
getPickListItem()
setPickListItem()
\Aggrosoft\WAWIBundle\Entity\PickListItem
user DB
read write
{{ entity.user }}
getUser()
setUser()
\Aggrosoft\WAWIBundle\Entity\User
last DB
read write
{{ entity.last }}
getLast()
setLast()
boolean
orders DB
read
{{ entity.orders }}
getOrders()
\Doctrine\Common\Collections\Collection
Property Type Target Entity Mapped By Inversed By Cascade Twig Access
location ManyToOne WarehouseStorageLocation - - - {{ entity.location }}
product ManyToOne Product - - - {{ entity.product }}
serialNumber ManyToOne ProductSerialNumber - - - {{ entity.serialNumber }}
pickListItem ManyToOne PickListItem - - - {{ entity.pickListItem }}
orders ManyToMany Order - picklistReservations - {{ entity.orders }}
user ManyToOne User - warehousebookings - {{ entity.user }}
Index Name Columns Type
created_idx
created
INDEX
type_idx
type
INDEX
uniqNumber_idx
uniqNumber
INDEX