inventory

189 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
inventory_warehouse.inventory_id FK_6B0F62949EEA759C
inventorylocation.inventory_id FK_6BD2CE4A9EEA759R
created DATETIME 19 null
completed BIT 1 null
note LONGTEXT 2147483647 √ null
inventoryNumber INT 10 null
inventoryFile VARCHAR 255 √ null
includeAllProducts BIT 1 null
lastupdated INT 10 null
inventoryType INT 10 null
inventoryCSVProtocolFile VARCHAR 255 √ null
excludeNullStock BIT 1 null
category_id VARCHAR 36 √ null
category.id FK_B12D4A3612469DE2R
inventoredLocation_id VARCHAR 36 √ null
warehousestoragelocation.id FK_B12D4A36BF251FBDR
manufacturer_id VARCHAR 36 √ null
manufacturer.id FK_B12D4A36A23B42DR
protocolRollingInventory BIT 1 null
fetchInventoryAtDate DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_B12D4A3612469DE2 Performance Asc category_id
IDX_B12D4A36A23B42D Performance Asc manufacturer_id
IDX_B12D4A36BF251FBD Performance Asc inventoredLocation_id

Relationships

Close relationships within degrees of separation