SOPT
Tables (9)
category
- id — INT
- name — VARCHAR(50) — NOT NULL
- icon_url — VARCHAR(500) — NOT NULL
expected_point
- id — INT
- order_id — INT — Foreign key → order.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
order
- id — INT
- 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
- id — INT
- brand_name — VARCHAR(100) — NOT NULL
- thumbnail_image_url — VARCHAR(500) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- review_score — DOUBLE — NOT NULL
- recent_review_score — DOUBLE — NOT NULL
- review_count — INT — NOT NULL
- original_price — INT — NOT NULL
- sale_price — INT — NOT NULL
- member_price — INT — NOT NULL
- discount_rate — INT — NOT NULL
- coupon_available — BOOLEAN — NOT NULL
- coupon_dday — INT — NOT NULL
- unit_price — INT — NOT NULL
- unit_quantity — INT — NOT NULL
- unit — VARCHAR(10) — NOT NULL
- free_delivery — BOOLEAN — NOT NULL
- arrival_date — DATE — NOT NULL
- deadline_at — DATETIME — NOT NULL
- max_point — INT — NOT NULL
promotion
- id — INT
- tag — VARCHAR(50) — NOT NULL
- ends_at — DATETIME — NOT NULL
promotion_item
- id — INT
- promotion_id — INT — Foreign key → promotion.id — NOT NULL
- product_id — INT — Foreign key → product.id — NOT NULL
- display_order — INT — NOT NULL
recommendation_item
- id — INT
- recommendation_section_id — INT — Foreign key → recommendation_section.id — NOT NULL
- product_id — INT — Foreign key → product.id — NOT NULL
- display_order — INT — NOT NULL
recommendation_section
- id — INT
- user_id — INT — Foreign key → user.id — NOT NULL
user
- id — INT
- nickname — VARCHAR(100) — NOT NULL