koview

Tables (17)

category (Untitled9)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — String

comments (Untitled4)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (content) — String
  • FK (member_id) — Long — Foreign key → members.Key — NOT NULL
  • FK (review_id) — Long — Foreign key → reviews.Key — NOT NULL

member_liked_shops (즐겨찾는 쇼핑몰)

  • Key (id) — Long — Primary key — NOT NULL
  • FK (shop_id) — Long — Foreign key → shops.Key — NOT NULL
  • FK (member_id) — Long — Foreign key → members.Key — NOT NULL

members

  • Key (id) — Long — Primary key — NOT NULL
  • Field (nickname) — String
  • Field (age) — int
  • Field (email) — String
  • Field (login_pw) — String
  • image (url) — String
  • Field (point) — int
  • Field (role) — Enum

product_images (Untitled8)

  • Key (id) — Long — Primary key — NOT NULL
  • FK (product_id) — Long — Foreign key → products.Key — NOT NULL
  • image (url) — String

products (Untitled)

  • Key (id) — Long — Primary key — NOT NULL
  • FK (category_id) — Long — Foreign key → category.Key — NOT NULL
  • Field (product_name) — String
  • Field (restricted_date) — Date
  • Field (status)

purchase_links (Untitled6)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (purchase_link) — String
  • Field (verifiedType) — enum
  • FK (product_id) — Long — Foreign key → products.Key
  • Field (shop_name) — String

queries (질의)

  • Key (id) — Long — Primary key — NOT NULL
  • FK (member_id) — Long — Foreign key → members.Key — NOT NULL
  • Field (content) — String
  • Field (total_query_count) — Long
  • Field (total_view_count) — Long

query_answers (답변)

  • Key (id) — Long — Primary key — NOT NULL
  • FK (query_id) — Long — Foreign key → queries.Key — NOT NULL
  • FK (review_id) — Long — Foreign key → reviews.Key — NOT NULL
  • Field (content) — String

query_images (Untitled11)

  • Key (id) — Long — Primary key — NOT NULL
  • FK (query_id) — Long — Foreign key → queries.Key — NOT NULL
  • image (url) — String

query_purchase_links (질의 구매링크)

  • Key (id) — Long — Primary key — NOT NULL
  • FK (purchase_link_id) — Long — Foreign key → purchase_links.Key — NOT NULL
  • Key (query_id) — Long — Foreign key → queries.Key — NOT NULL

review_images (Untitled3)

  • Key (id) — Long — Primary key — NOT NULL
  • image (url) — String
  • FK (review_id) — Long — Foreign key → reviews.Key — NOT NULL

review_likes (Untitled5)

  • Key (id) — Long — Primary key — NOT NULL
  • FK (membber_id) — Long — Foreign key → members.Key — NOT NULL
  • FK (review_id) — Long — Foreign key → reviews.Key — NOT NULL

review_purchase_links (Untitled7)

  • Key (id) — Long — Primary key — NOT NULL
  • FK (purchase_link_id) — Long — Foreign key → purchase_links.Key — NOT NULL
  • FK (review_id) — Long — Foreign key → reviews.Key — NOT NULL
  • Field (count) — int

reviews (Untitled2)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (content) — String
  • FK (member_id) — Long — Foreign key → members.Key — NOT NULL
  • Field (total_like_count) — Long

shops

  • Key (id) — Long — Primary key — NOT NULL
  • Field (shop_name) — String

with_queries (나도 궁금)

  • Key (id) — Long — Primary key — NOT NULL
  • FK (member_id) — Long — Foreign key → members.Key — NOT NULL
  • FK (query_id) — Long — Foreign key → queries.Key — NOT NULL