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