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