쇼핑

테이블 (4)

order_items

  • order_item_id — INT — 기본 키
  • order_id — INT — NOT NULL
  • product_id — INT — NOT NULL
  • quantity — INT — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL

orders

  • order_date — DATETIME — 기본 키
  • user_id (user_id2) — INT — 외래 키 → users.user_id
  • total_amount — DECIMAL(10, 2) — NOT NULL
  • status — VARCHAR(20)
  • order_id — INT

products

  • product_id — INT — 기본 키
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • price — DECIMAL(10, 2) — NOT NULL
  • stock — INT — NOT NULL
  • created_at — DATETIME

users

  • user_id — INT — 기본 키
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — DATETIME