실습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