local mark
Tables (12)
BoughtProduct (Untitled3)
- bought_id (Key) — varchar(100) — Primary key — NOT NULL
- user_id (id) — varchar(100) — Foreign key → User.user_id — NOT NULL
- product_id (Key2) — varchar(100) — Foreign key → Product.product_id — NOT NULL
- brand_id (Key22) — varchar(100) — Foreign key → Product.brand_id — NOT NULL
Brand (Untitled2)
- brand_id (Key) — varchar(100) — Primary key — NOT NULL
- local (Field) — varchar(100)
- story (Field2) — text
Chat (Untitled11)
- chat_id (Key) — varchar(100) — Primary key — NOT NULL
- contents (Field) — text
- Field2
Interview (Untitled6)
- interview_id (Key) — varchar(100) — Primary key — NOT NULL
- brand_id (Key2) — varchar(100) — Foreign key → Brand.brand_id — NOT NULL
- contents (Field) — text
- interview_img (Field2) — text
- Field3
LocalCommunity (Untitled8)
- community_id (Key) — varchar(100) — Primary key — NOT NULL
- brand_id (Key2) — varchar(100) — Foreign key → Brand.brand_id — NOT NULL
- community_role (Field) — varchar(50)
- title (Field2) — varchar(50)
LocalCommunityComment (Untitled10)
- liked_brand_id (Key) — varchar(100) — Foreign key → Brand.brand_id — NOT NULL
- community_id (Key2) — varchar(100) — Foreign key → LocalCommunity.community_id — NOT NULL
- community_brand_id (Key22) — varchar(100) — Foreign key → LocalCommunity.brand_id — NOT NULL
- contents (Field) — text
LocalCommunityLike (Untitled9)
- community_id (Key2) — varchar(100) — Foreign key → LocalCommunity.community_id — NOT NULL
- community_brand_id (Key22) — varchar(100) — Foreign key → LocalCommunity.brand_id — NOT NULL
- liked_brand_id (Key) — varchar(100) — Foreign key → Brand.brand_id — NOT NULL
LocalLetter (Untitled7)
- letter_id (Key) — varchar(100) — Primary key — NOT NULL
- brand_id (Key2) — varchar(100) — Foreign key → Brand.brand_id — NOT NULL
- contents (Field) — text
- Field2
Product (Untitled)
- product_id (Key) — varchar(100) — Primary key — NOT NULL
- brand_id (Key2) — varchar(100) — Foreign key → Brand.brand_id — NOT NULL
- price (Field) — int
- category (Field2) — varchar(50)
- size (Field3)
- color (Field4)
- product_img (Field5) — text
- spec (Field6) — text
Review (Untitled4)
- review_id (Key) — varchar(100) — Primary key — NOT NULL
- bought_id (Key2) — varchar(100) — Foreign key → BoughtProduct.bought_id — NOT NULL
- user_id (id) — varchar(100) — Foreign key → BoughtProduct.user_id — NOT NULL
- product_id (Key22) — varchar(100) — Foreign key → BoughtProduct.product_id — NOT NULL
- brand_id (Key222) — varchar(100) — Foreign key → BoughtProduct.brand_id — NOT NULL
- contents (Field) — text
- score (Field2) — float
- review_img (Field3) — text
ShoppingBasket (Untitled5)
- user_id (id) — varchar(100) — Foreign key → User.user_id — NOT NULL
- product_id (Key) — varchar(100) — Foreign key → Product.product_id — NOT NULL
- brand_id (Key2) — varchar(100) — Foreign key → Product.brand_id — NOT NULL
User (사용자)
- user_id (id) — varchar(100) — Primary key — NOT NULL
- address — text
- user_img (Field) — text