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