WarehouseBooking

Aggrosoft\WAWIBundle\Entity\WarehouseBooking
12
Columns
7
Relations
22
Properties

Relationships

Click entity to navigate
erDiagram
    WarehouseBooking {
                string id PK
                datetime created
                decimal quantity
                decimal remainingQuantity
                decimal previousQuantity
                string uniqNumber
                        ___ ___more___
            }
                WarehouseBooking }o--|| WarehouseStorageLocation : "location"
        WarehouseStorageLocation {
        int id PK
    }
                WarehouseBooking }o--|| Product : "product"
        Product {
        int id PK
    }
                WarehouseBooking }o--|| ProductSerialNumber : "serialNumber"
        ProductSerialNumber {
        int id PK
    }
                WarehouseBooking }o--|| VendorOrderDelivery : "reference"
        VendorOrderDelivery {
        int id PK
    }
                WarehouseBooking }o--|| User : "user"
        User {
        int id PK
    }
                WarehouseBooking }o--|| Client : "bookedInClient"
        Client {
        int id PK
    }
                WarehouseBooking }o--|| WarehouseStorageLocation : "parentLocation"
        WarehouseStorageLocation {
        int id PK
    }
                    

Metadaten

Tabelle warehousebooking
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 }}
remainingQuantity remainingQuantity decimal
{{ entity.remainingQuantity }}
previousQuantity previousQuantity decimal
{{ entity.previousQuantity }}
uniqNumber uniqNumber string(128)
{{ entity.uniqNumber }}
reservedQuantity reservedQuantity decimal
{{ entity.reservedQuantity }}
type type string(2)
{{ entity.type }}
last last boolean
{{ entity.last }}
bookingNumber bookingNumber integer
{{ entity.bookingNumber }}
exactTime exactTime float
{{ entity.exactTime }}
note note string(255)
{{ entity.note }}

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()
float
type DB
read write
{{ entity.type }}
getType()
setType()
integer
location DB
read write
{{ entity.location }}
getLocation()
setLocation()
\Aggrosoft\WAWIBundle\Entity\WarehouseStorageLocation
vendorOrder Computed
read write
{{ entity.vendorOrder }}
getVendorOrder()
setVendorOrder()
\Aggrosoft\WAWIBundle\Entity\VendorOrder
product DB
read write
{{ entity.product }}
getProduct()
setProduct()
\Aggrosoft\WAWIBundle\Entity\Product
remainingQuantity DB
read write
{{ entity.remainingQuantity }}
getRemainingQuantity()
setRemainingQuantity()
float
bookingNumber DB
read write
{{ entity.bookingNumber }}
getBookingNumber()
setBookingNumber()
integer
last DB
read write
{{ entity.last }}
getLast()
setLast()
boolean
note DB
read write
{{ entity.note }}
getNote()
setNote()
string
reservedQuantity DB
read write
{{ entity.reservedQuantity }}
getReservedQuantity()
setReservedQuantity()
float
reference DB
read write
{{ entity.reference }}
getReference()
setReference()
\Aggrosoft\WAWIBundle\Entity\VendorOrderDelivery
serialNumber DB
read write
{{ entity.serialNumber }}
getSerialNumber()
setSerialNumber()
\Aggrosoft\WAWIBundle\Entity\ProductSerialNumber
user DB
read write
{{ entity.user }}
getUser()
setUser()
\Aggrosoft\WAWIBundle\Entity\User
previousQuantity DB
read write
{{ entity.previousQuantity }}
getPreviousQuantity()
setPreviousQuantity()
string
uniqNumber DB
read write
{{ entity.uniqNumber }}
getUniqNumber()
setUniqNumber()
string
exactTime DB
read write
{{ entity.exactTime }}
getExactTime()
setExactTime()
float
quantityDifference Computed
read
{{ entity.quantityDifference }}
getQuantityDifference()
-
bookedInClient DB
read write
{{ entity.bookedInClient }}
getBookedInClient()
setBookedInClient()
\Aggrosoft\WAWIBundle\Entity\Client
parentLocation DB
read write
{{ entity.parentLocation }}
getParentLocation()
setParentLocation()
\Aggrosoft\WAWIBundle\Entity\WarehouseStorageLocation
tempReservedQuantity Computed
read write
{{ entity.tempReservedQuantity }}
getTempReservedQuantity()
setTempReservedQuantity()
-
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 }}
reference ManyToOne VendorOrderDelivery - - - {{ entity.reference }}
user ManyToOne User - warehousebookings - {{ entity.user }}
bookedInClient ManyToOne Client - - - {{ entity.bookedInClient }}
parentLocation ManyToOne WarehouseStorageLocation - - - {{ entity.parentLocation }}
Index Name Columns Type
created_idx
created
INDEX
type_idx
type
INDEX
bookingnumber_idx
bookingNumber
INDEX
uniqNumber_idx
uniqNumber
INDEX
last_idx
last
INDEX