main-project-team-4

Tables (12)

CategoryL (category_large)

  • ID (id) — Primary key — NOT NULL
  • NAME (name)

CategoryM (category_mid)

  • ID (id) — Primary key — NOT NULL
  • NAME (name)
  • PARENT (parent) — Foreign key → CategoryL.ID — NOT NULL

Chat (chat)

  • ID (id) — Primary key — NOT NULL
  • CONTENT (content)
  • ROOM_ID (room_id) — Foreign key → ChatRoom.ID — NOT NULL

ChatRoom (chat_room)

  • ID (id) — Primary key — NOT NULL
  • SELLER_ID (seller_id) — Foreign key → Member.ID — NOT NULL
  • CONSUMER_ID (consumer_id) — Foreign key → Member.ID — NOT NULL
  • ITEM_ID (item_id) — Foreign key → Item.ID — NOT NULL

Follow (follow)

  • ID (id) — Primary key — NOT NULL
  • MEMBER_ID (member_id) — Foreign key → Member.ID — NOT NULL
  • SHOP_ID (shop_id) — Foreign key → Shop.ID — NOT NULL

Item (item)

  • ID (id) — Primary key — NOT NULL
  • NAME (name)
  • PRICE (price)
  • COMMENT (comment)
  • IMAGE_URL (image_url)
  • CREATED_AT (createdAt)
  • STATE (state)
  • LOCATION_ID (location_id) — Foreign key → Location.ID — NOT NULL
  • SHOP_ID (shop_id) — Foreign key → Shop.ID — NOT NULL
  • CATEGORY_MID_ID (category_mid_id) — Foreign key → CategoryM.ID — NOT NULL

Location (location)

  • ID (id) — Primary key — NOT NULL
  • STATE (state)
  • CITY (city)
  • ADDRESS_ONE (address_one)
  • MEMBER_ID (member_id) — Foreign key → Member.ID — NOT NULL

Member (member)

  • ID (id) — Primary key — NOT NULL
  • USERNAME (username)
  • PASSWORD (password)
  • NICKNAME (nickname)
  • PHONE_NUM (phone_num)
  • IMAGE (image)

Review (review)

  • ID (id) — Primary key — NOT NULL
  • COMMENT (comment)
  • RATING (rating)
  • SHOP_ID (shop_id) — Foreign key → Shop.ID — NOT NULL
  • MEMBER_ID (member_id) — Foreign key → Member.ID — NOT NULL
  • ITEM_ID (item_id) — Foreign key → Item.ID — NOT NULL

Shop (shop)

  • ID (id) — Primary key — NOT NULL
  • INTRO (intro)
  • SELLER_ID (seller_id) — Foreign key → Member.ID — NOT NULL
  • ITEM_LIST (item_list)
  • REVIEW_LIST (review_list)
  • RATING_TOTAL (star_avg)

Trade (trade)

  • ID (id) — Primary key — NOT NULL
  • MEMBER_ID (member_id) — Foreign key → Member.ID — NOT NULL
  • SELLER_ID (seller_id) — Foreign key → Member.ID — NOT NULL
  • ITEM_ID (item_id) — Foreign key → Item.ID — NOT NULL

Wish (wish)

  • ID (id) — Primary key — NOT NULL
  • ITEM_ID (item_id) — Foreign key → Member.ID — NOT NULL
  • MEMBER_ID (member_id) — Foreign key → Item.ID — NOT NULL