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