Real Time Trip

Tables (6)

chat_message (메시지(채팅))

  • chat_room_id (채팅방 id) — String — Primary key — NOT NULL
  • user_id (유저 ID2) — Long — Foreign key → user.user_id — NOT NULL
  • email (이메일2) — String — Foreign key → user.email — NOT NULL
  • chat_room_id (채팅방 ID) — String — Foreign key → chat_room.chat_room_id — NOT NULL
  • country_code (국가 코드) — String — Foreign key → chat_room.country_code — NOT NULL
  • user_id (유저 ID) — Long
  • nickname (닉네임) — String
  • event_time (시간) — LocalDateTime
  • message (메시지(채팅)) — String
  • type (타입) — String
  • chat_id (채팅 id) — Long — NOT NULL

chat_room (나라 별 대표 채팅방)

  • chat_room_id (채팅방 ID) — String — Primary key — NOT NULL
  • country_code (국가 코드) — String — Foreign key → country.country_code — NOT NULL
  • user_count (유저 수) — Long
  • last_chat_id (마지막 채팅id) — Long

chat_room_user (채팅방 유저)

  • chat_room_user_id (채팅방 유저 아이디) — Long — Primary key — NOT NULL
  • user_id (유저 ID) — Long — Foreign key → user.user_id — NOT NULL
  • chat_room_id (채팅방 ID) — String — Foreign key → chat_room.chat_room_id — NOT NULL
  • country_code (국가 코드) — String — Foreign key → chat_room.country_code — NOT NULL
  • email (이메일2) — String — Foreign key → user.email — NOT NULL

country (국가)

  • country_code (국가 코드) — String — Primary key — NOT NULL
  • country_name (국가명(채팅방 이름)) — String
  • continent (대륙) — String

user (회원)

  • user_id (유저 ID) — Long — Primary key — NOT NULL
  • email (이메일2) — String — Foreign key → verification_code.email — NOT NULL
  • email (이메일) — String
  • password (비밀번호) — String
  • nickname (닉네임) — String
  • profile (프로필 사진) — String

verification_code (인증번호)

  • email (이메일) — String — Primary key — NOT NULL
  • verification_code (인증번호) — String