pda 실습
테이블 (7)
member
- member_id — BIGINT — 기본 키 — NOT NULL
- login_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(30) — NOT NULL
- birth_date — DATE — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- deleted_at — DATETIME
order_item
- order_item_id — BIGINT — 기본 키 — NOT NULL
- order_id — BIGINT — 외래 키 → orders.order_id — NOT NULL
- product_id — BIGINT — 외래 키 → product.product_id — NOT NULL
- option_id — BIGINT — 외래 키 → product_option.option_id
- product_name — VARCHAR(100) — NOT NULL
- option_name — VARCHAR(100)
- quantity — INT — NOT NULL
- unit_price — INT — NOT NULL
- subtotal_amount — INT — NOT NULL
orders
- order_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- order_number — VARCHAR(50) — NOT NULL
- order_date — DATETIME — NOT NULL
- total_quantity — INT — NOT NULL
- total_amount — INT — NOT NULL
- order_status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
product
- product_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- price — INT — NOT NULL
- description — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
product_image
- product_image_id — BIGINT — 기본 키 — NOT NULL
- product_id — BIGINT — 외래 키 → product.product_id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- image_order — INT — NOT NULL
- is_thumbnail — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
product_option
- option_id — BIGINT — 기본 키 — NOT NULL
- product_id — BIGINT — 외래 키 → product.product_id — NOT NULL
- option_name — VARCHAR(100) — NOT NULL
- additional_price — INT — NOT NULL
- stock_quantity — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
wishlist
- wishlist_id — BIGINT — 기본 키 — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- product_id — BIGINT — 외래 키 → product.product_id — NOT NULL
- created_at — DATETIME — NOT NULL