blog - 2026-05-07 08:20:33
Tables (3)
Member (Untitled)
- member_id (Key) — BIGINT — Primary key — NOT NULL
- name (이름) — VARCHAR
- email (이메일) — VARCHAR
- phone (전화번호) — VARCHAR
Order (Untitled3)
- order_id (주문 고유 ID) — BIGINT — Primary key — NOT NULL
- member_id (Key3) — BIGINT — Foreign key → Member.member_id — NOT NULL
- product_id (Key) — BIGINT — Foreign key → Product.product_id — NOT NULL
- order_date (주문 날짜) — DATETIME
Product (Untitled2)
- product_id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR
- price (Field2) — INT
- stock (Field3) — INT