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