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