proj

테이블 (5)

Chatting room (Untitled3)

  • Key — 기본 키 — NOT NULL
  • chatroom_list (Field)
  • room_id (Field4)
  • messages (Field5)
  • created_at (Field6)
  • updated_at (Field7)
  • user1_id (Key2) — 외래 키 → User.Key — NOT NULL
  • user 2_ id (Key3) — 외래 키 → User.Key — NOT NULL
  • Key (Key22) — 외래 키 → User.Key — NOT NULL

Product (Untitled)

  • Key — 기본 키 — NOT NULL
  • sellerid (Key2) — 외래 키 → User.Key — NOT NULL
  • number (Field)
  • title (Field2)
  • thumb_nail__image (Field3)
  • price (Field4)
  • bookmark_cnt (Field5)
  • chat_cnt (Field6)
  • content (Field7)
  • location (Field8)
  • created_at (Field9)
  • updated_at (Field10)
  • Key (Key22) — 외래 키 → User.Key — NOT NULL

User (Untitled2)

  • Key — 기본 키 — NOT NULL
  • Key (Key2) — 외래 키 → user_post.Key — NOT NULL
  • name (Field)
  • location (Field2)
  • created_at (Field4)
  • updated_at (Field5)
  • userid (Field9)
  • password (Field10)

user_post (Untitled4)

  • Key — 기본 키 — NOT NULL
  • post_id (Field)
  • content (Field2)
  • created_at (Field3)
  • updated_at (Field4)

관심 목록 (Untitled5)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2