실습1(이커머스)

테이블 (5)

courses

  • course_id — SERIAL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • price — DECIMAL(10,2)
  • created_at — TIMESTAMP

option_items

  • product_id — INT — 기본 키 — NOT NULL
  • user_id — SERIAL — 외래 키 → users.user_id — NOT NULL
  • option_id — SERIAL
  • order_id — INT — NOT NULL
  • option_quantity — INT — NOT NULL
  • option_unit_price — DECIMAL(10, 2) — NOT NULL

orders

  • user_id — SERIAL — 기본 키 — NOT NULL
  • order_id — SERIAL
  • order_date — TIMESTAMP
  • option_id — INT

products

  • product_id — INT — 기본 키 — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • stock — INT — NOT NULL
  • seller_id — INT — NOT NULL
  • created_at — TIMESTAMP

users

  • user_id — SERIAL — 기본 키 — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • is_seller — BOOLEAN
  • created_at — TIMESTAMP