inventory

400 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
variant_id INT 10 null
inventory_logs.variant_id inventory_logs_variant_id_fkey R
product_variants.id inventory_variant_id_fkey C
quantity INT 10 0
created_at DATETIME 19 CURRENT_TIMESTAMP
updated_at DATETIME 19 null
deleted_at DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
inventory_variant_id_key Must be unique Asc variant_id

Relationships

Close relationships within degrees of separation