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