carrotmarket

Tables (10)

Category

  • category_id — Primary key — NOT NULL
  • category_name

ChatRoom

  • chatRoom_id — Primary key — NOT NULL
  • member_id — 구매자 — Foreign key → member.member_id — NOT NULL

article

  • article_id — Primary key — NOT NULL
  • member_id — VARCHAR — Foreign key → member.member_id — NOT NULL
  • title (Field)
  • content (Field3)
  • place (Field4)
  • createdAt
  • modifiedAt
  • status
  • likeArticle
  • price

bookMark

  • bookMark_id — Primary key — NOT NULL
  • member_id — VARCHAR — Foreign key → member.member_id — NOT NULL
  • article_id — Foreign key → article.article_id — NOT NULL

carrotMap

  • myLoca

chatMessage

  • chatMessage_id — Primary key — NOT NULL
  • member_id — VARCHAR — Foreign key → member.member_id — NOT NULL
  • type

mannerTemp

  • mannerTemp_id (Key) — Primary key — NOT NULL
  • member_id — VARCHAR — Foreign key → member.member_id — NOT NULL
  • tempName

member

  • member_id — VARCHAR — Primary key — NOT NULL
  • pic
  • nickname
  • email
  • id
  • pwd
  • phone
  • username
  • createdAt
  • modifiedAt

picture

    product

    • product_id — Primary key — NOT NULL
    • chatRoom_id — Foreign key → ChatRoom.chatRoom_id — NOT NULL
    • article_id — Foreign key → article.article_id — NOT NULL
    • Field