SOPT - 38 - 합동세미나
테이블 (11)
card_benefits
- id — BIGINT
- product_id — BIGINT — 외래 키 → products.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
categories
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- icon_url — VARCHAR(255) — NOT NULL
expected_points
- id — BIGINT
- order_id — BIGINT — 외래 키 → orders.id — NOT NULL
- total_point — INT — NOT NULL
- purchase_total_point — INT — NOT NULL
- basic_point — INT — NOT NULL
- npay_money_point — INT — NOT NULL
- review_point — INT — NOT NULL
- membership_point — INT — NOT NULL
orders
- id — BIGINT
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- available_amount — INT — NOT NULL
- available_point — INT — NOT NULL
- available_money — INT — NOT NULL
- hidden_point — INT — NOT NULL
- all_use_amount — INT — NOT NULL
product_categories
- id — BIGINT
- product_id — BIGINT — 외래 키 → products.id — NOT NULL
- category_id — BIGINT — 외래 키 → categories.id — NOT NULL
products
- id — BIGINT
- brand_name — VARCHAR(100) — NOT NULL
- thumbnail_image_url — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- review_score — DOUBLE — NOT NULL
- recent_review_score — DOUBLE — NOT NULL
- review_count — INT — NOT NULL
- discount_rate — INT — NOT NULL
- original_price — INT — NOT NULL
- sale_price — INT — NOT NULL
- member_price — INT — NOT NULL
- coupon_available — BOOLEAN — NOT NULL
- coupon_dday — INT
- unit_price — INT — NOT NULL
- unit_quantity — INT — NOT NULL
- unit — VARCHAR(20) — NOT NULL
- free_delivery — BOOLEAN — NOT NULL
- arrival_date — DATE — NOT NULL
- deadline_at — DATETIME — NOT NULL
- max_point — INT — NOT NULL
promotion_items
- id — BIGINT
- promotion_id — BIGINT — 외래 키 → promotions.id — NOT NULL
- product_id — BIGINT — 외래 키 → products.id — NOT NULL
promotions
- id — BIGINT
- tag — VARCHAR(100) — NOT NULL
- ends_at — DATETIME — NOT NULL
recommendation_items
- id — BIGINT
- recommendation_section_id — BIGINT — 외래 키 → recommendation_sections.id — NOT NULL
- product_id — BIGINT — 외래 키 → products.id — NOT NULL
recommendation_sections
- id — BIGINT
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
users
- id — BIGINT
- nickname — VARCHAR(50) — NOT NULL