3jo

Tables (4)

products

  • product_id — INT — Primary key
  • name — VARCHAR(255) — NOT NULL
  • price — DECIMAL(10,2) — NOT NULL
  • expiration_date — DATE — NOT NULL
  • quantity — INT — NOT NULL

sales

  • sale_id — INT — Primary key
  • quantity_sold — INT — NOT NULL
  • total_price — DECIMAL(10,2) — NOT NULL
  • sale_date — TIMESTAMP
  • product_id — INT — Foreign key → products.product_id

stock_logs

  • log_id — INT — Primary key
  • change_type — ENUM('입고', '판매') — NOT NULL
  • quantity_change — INT — NOT NULL
  • change_time — TIMESTAMP
  • product_id — INT — Foreign key → products.product_id

suppliers

  • supplier_id — INT — Primary key
  • name — VARCHAR(255) — NOT NULL
  • contact — VARCHAR(50)
  • address — TEXT
  • product_id — INT — Foreign key → products.product_id