chat_proj`
Tables (4)
ChatMessage (채팅 메세지)
- message_id (메세지 ID) — Long — Primary key — NOT NULL
- message_content (메세지 내용) — VARCHAR(50)
- message_type (전송 시각) — DATETIME
- file_path (파일 경로) — STRING
- sent_at (전송 시간) — DATETIME
- chat_room_id (채팅방 ID) — Long — Foreign key → ChatRoom.chat_room_id — NOT NULL
- sender_id (사용자 ID) — Long — Foreign key → User.user_id — NOT NULL
ChatRoom (채팅방)
- chat_room_id (채팅방 ID) — Long — Primary key — NOT NULL
- room_name (Field)
- room_type (Field2)
- datetime (생성일) — DATETIME
ChatRoom_Participant (채팅방 참가자)
- room_id (채팅방 ID2) — Long — Foreign key → ChatRoom.chat_room_id — NOT NULL
- created_at (참여일)
- user_id (사용자 ID) — Long — Foreign key → User.user_id — NOT NULL
User (사용자)
- user_id (사용자 ID) — Long — Primary key — NOT NULL
- email (이메일) — VARCHAR(50)
- Field (이름) — VARCHAR(100)
- password (비밀번호) — VARCHAR(20)
- created_at (가입일) — DATETIME
- updated_at (수정일) — DATETIME
- deleted_at (탈퇴일) — DATETIME