LinkPlanet

Tables (6)

chatMessage (채팅 내용)

  • id — Not Null — Primary key — NOT NULL
  • chatRoomId (chat_room_id) — Not Null — Foreign key → chatRoom.id — NOT NULL
  • userId (user_id) — Not Null — Foreign key → user.id — NOT NULL
  • message — Not Null

chatRoom (채팅방)

  • id — Not Null — Primary key — NOT NULL
  • name — Not Null

chatRoomUser (채팅 방 , 유저)

  • chatRoomId (chat_room_id) — Not Null — Foreign key → chatRoom.id — NOT NULL
  • userId (user_Id) — Not Null — Foreign key → user.id — NOT NULL

friend (친구)

  • userId (user_id) — Not Null — Foreign key → user.id — NOT NULL
  • friendId (friend_id) — Not Null — Foreign key → user.id — NOT NULL
  • status — Not Null — NOT NULL

profile_image (프로필이미지)

  • userId (user_id) — Not Null — Foreign key → user.id — NOT NULL
  • head — Null
  • arm — Null
  • body — Null
  • legs — Null

user (사용자)

  • id — Not Null — Primary key — NOT NULL
  • name — Not Null — NOT NULL
  • email — Not Null — NOT NULL
  • password — Not Null — NOT NULL
  • phoneNumber (phone_number) — Not Null — NOT NULL
  • todayMood (today_mood) — Null
  • backgroundImage (background_image) — Null
  • location — Null
  • isUseRealTimeLocation (is_use_real_time_location) — Not Null — NOT NULL