warehousebooking

65566 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
location_id VARCHAR 36 null
warehousestoragelocation.id FK_FC6BD52C64D218ER
product_id VARCHAR 36 null
product.id FK_FC6BD52C4584665AR
reference_id VARCHAR 36 null
vendororderdelivery.id FK_FC6BD52C1645DEA9R
created DATETIME 19 null
quantity DECIMAL 10,3 null
remainingQuantity DECIMAL 10,3 null
reservedQuantity DECIMAL 10,3 null
type VARCHAR 2 null
last BIT 1 null
bookingNumber INT 10 null
note VARCHAR 255 null
serialNumber_id VARCHAR 36 null
productserialnumber.id FK_FC6BD52CA907283BR
user_id INT 10 null
users.id FK_FC6BD52CA76ED395R
previousQuantity DECIMAL 10,3 null
uniqNumber VARCHAR 128 null
exactTime DOUBLE 22 null
bookedInClient_id VARCHAR 36 null
client.id FK_FC6BD52C2B7E3CCCR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
bookingnumber_idx Performance Asc bookingNumber
created_idx Performance Asc created
IDX_FC6BD52C1645DEA9 Performance Asc reference_id
IDX_FC6BD52C2B7E3CCC Performance Asc bookedInClient_id
IDX_FC6BD52C4584665A Performance Asc product_id
IDX_FC6BD52C64D218E Performance Asc location_id
IDX_FC6BD52CA76ED395 Performance Asc user_id
IDX_FC6BD52CA907283B Performance Asc serialNumber_id
last_idx Performance Asc last
type_idx Performance Asc type
uniqNumber_idx Performance Asc uniqNumber

Relationships