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