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
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
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