warehouse

24 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
client_pickingwarehouse.warehouse_id FK_B4068BC85080ECDEC
inventory_warehouse.warehouse_id FK_6B0F62945080ECDEC
offeritem.warehouse_id FK_7E455D7C5080ECDER
order_pickingwarehouse.warehouse_id FK_F2D91A2F5080ECDEC
orders.warehouse_id FK_E52FFDEE5080ECDER
retailstore_warehouse.warehouse_id FK_FABA25AE5080ECDEC
saleschannel_warehouse.warehouse_id FK_867F4E765080ECDEC
vendororder.warehouse_id FK_82C1E65C5080ECDER
vendororderdelivery.relocatedWarehouse_id FK_44EAB757DD5477C4R
vendororderdelivery.warehouse_id FK_44EAB7575080ECDER
vendororderitemdelivery.warehouse_id FK_61BB18065080ECDER
warehouse_client.warehouse_id FK_2210DB245080ECDEC
warehouse_excludedclient.warehouse_id FK_F6F1902A5080ECDEC
warehouse_excludeduser.warehouse_id FK_2CCAAE635080ECDEC
warehouse_objectgroup.warehouse_id FK_5FC9E9B85080ECDEC
warehouse_user.warehouse_id FK_52F9D69D5080ECDEC
warehousestoragelocation.warehouse_id FK_CBC9E6B75080ECDER
country_id VARCHAR 36 null
country.id FK_ECB38BFCF92F3E70R
dimensions_id VARCHAR 36 null
warehousedimensions.id FK_ECB38BFC4F311658R
name VARCHAR 255 null
ident VARCHAR 255 null
description LONGTEXT 2147483647 null
contactCompany VARCHAR 255 null
contactSalutation VARCHAR 20 null
contactFirstName VARCHAR 255 null
contactLastName VARCHAR 255 null
contactPhone VARCHAR 50 null
contactFax VARCHAR 50 null
contactMail VARCHAR 255 null
contactDepartment VARCHAR 255 null
street VARCHAR 255 null
zip VARCHAR 255 null
city VARCHAR 255 null
state VARCHAR 255 null
type VARCHAR 2 null
sort INT 10 null
active BIT 1 1
vatId VARCHAR 50 null
defaultInClient_id VARCHAR 36 null
client.id FK_ECB38BFC5FD7F972R
stockInAllClientsVisible BIT 1 null
orderReservationOnlyThisClient BIT 1 null
additionalSortingForPickList VARCHAR 255 null
bookingCheckCondition VARCHAR 255 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_ECB38BFC5FD7F972 Performance Asc defaultInClient_id
IDX_ECB38BFCF92F3E70 Performance Asc country_id
UNIQ_ECB38BFC4F311658 Must be unique Asc dimensions_id

Relationships