erd

Tables (4)

orders

  • id — BIGINT — Primary key — NOT NULL
  • store_id — BIGINT — Foreign key → users.id — NOT NULL
  • product_id — BIGINT — Foreign key → products.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

products

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • category — VARCHAR(50) — NOT NULL
  • supply_price — DECIMAL(10,2) — NOT NULL
  • headquarters_id — BIGINT — Foreign key → users.id — NOT NULL
  • order_unit — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

store_inventories

  • id — BIGINT — Primary key — NOT NULL
  • store_id — BIGINT — Foreign key → users.id — NOT NULL
  • product_id — BIGINT — Foreign key → products.id — NOT NULL
  • quantity — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • last_order_id — VARCHAR(255)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — VARCHAR(30) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)