fleaMarket
Tables (7)
Category (Untitled7)
- Key (category_id) — Primary key — NOT NULL
- 카테고리명 (category_name) — NOT NULL
Chat (Untitled4)
- Key (chat_id) — Primary key — NOT NULL
- 메시지 (message) — message — NOT NULL
Comment (Untitled8)
- Key (comment_id) — Primary key — NOT NULL
- 작성자 (writer) — User — NOT NULL
- 내용 (text) — String — NOT NULL
- 작성일 (date) — Date — NOT NULL
- key (user_id) — String — Foreign key → User.key — NOT NULL
- Key (post_id) — Foreign key → Post.Key — NOT NULL
Message (Untitled5)
- Key (Message_id) — Primary key — NOT NULL
- 내용 (text) — NOT NULL
- 보낸시간 (date) — Date — NOT NULL
- key (user_id) — String — Foreign key → User.key — NOT NULL
- Key (chat_id) — Foreign key → Chat.Key — NOT NULL
Post (Untitled2)
- Key (post_id) — Primary key — NOT NULL
- 제목 (title) — String — NOT NULL
- 물건 (item) — item — NOT NULL
- 가격 (price) — int — NOT NULL
- 등록일 (post_date) — Date — NOT NULL
- 거래방식 (tradeType) — TradeType — NOT NULL
- 본문 (text) — String
- key (user_id) — String — Foreign key → User.key — NOT NULL
- Key (category_id) — Foreign key → Category.Key — NOT NULL
Sub_comment (Untitled3)
- Key (sub_comment_id) — Primary key — NOT NULL
- 작성자 (writer) — User — NOT NULL
- 내용 (text) — String — NOT NULL
- 작성일 (date) — NOT NULL
- Key (comment_id2) — Foreign key → Comment.Key — NOT NULL
- key (user_id) — String — Foreign key → User.key — NOT NULL
User (Untitled)
- key (user_id) — String — Primary key — NOT NULL
- 아이디 (id) — String — NOT NULL
- 비밀번호 (password) — String — NOT NULL
- 닉네임 (nickname) — String — NOT NULL