inventory

114 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

Indexes

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

Relationships