runup_db

Tables (11)

Reviews

  • review_id — Primary key — NOT NULL
  • userid — Foreign key → users.userid — NOT NULL
  • product_id — Foreign key → products.product_id — NOT NULL
  • context
  • rate
  • user_img
  • date

brand (brands)

  • id — Primary key — NOT NULL
  • name_kr
  • name_en
  • desc
  • link

main_banner (main_post)

  • post_start — date
  • post_end — date
  • name
  • post_img
  • Field (link)

main_categories (Untitled2)

  • main_ctg_id — Primary key — NOT NULL
  • main_category
  • Name

product_like

  • userid — Foreign key → users.userid — NOT NULL
  • product_id — Foreign key → products.product_id — NOT NULL

products (products_table)

  • product_id — Primary key — NOT NULL
  • id (brand) — Foreign key → brand.id — NOT NULL
  • ctg_id — Foreign key → sub_categories.ctg_id — NOT NULL
  • img_url
  • gender
  • url
  • name
  • price_origin
  • discount_rate
  • retail_price
  • view_count
  • color

rec_result (recommend_result)

  • userid — Foreign key → users.userid — NOT NULL
  • result (result_value)
  • img
  • date

rv_rate (review_rate)

  • review_id — Foreign key → Reviews.review_id — NOT NULL
  • userid — Foreign key → users.userid — NOT NULL
  • up_down

similarity (similarities)

  • product_id (target_pd) — Foreign key → products.product_id — NOT NULL
  • product_id (sim_pd) — Foreign key → products.product_id — NOT NULL
  • sim_val

sub_categories (Untitled)

  • ctg_id — Primary key — NOT NULL
  • main_ctg_id — Foreign key → main_categories.main_ctg_id — NOT NULL
  • sub_category
  • Name

users (user_table)

  • userid — Primary key — NOT NULL
  • password
  • gender
  • birth
  • phone
  • email — NOT NULL