Inventory Management (DBML)

Table suppliers {
  id int [pk, increment]
  name varchar
  contact_email varchar
}

Table products {
  id int [pk, increment]
  name varchar
  supplier_id int
  price decimal
  stock int
}

Table inventory_log {
  id int [pk, increment]
  product_id int
  quantity int
  change_date datetime
}

Ref: products.supplier_id > suppliers.id
Ref: inventory_log.product_id > products.id