chat
Tables (5)
Chat_Room (채팅방)
- Key (id) — Primary key — NOT NULL
- 이름 (name)
- 종류 (type)
- 생성시각 (created_at)
Chat_room_member (Untitled2)
- Key (id) — Primary key — NOT NULL
- Key (member_id) — Foreign key → Member.Key — NOT NULL
- Key (chat_room_id) — Foreign key → Chat_Room.Key — NOT NULL
- Field (joined_at)
Member (회원)
- Key (id) — Primary key — NOT NULL
- 닉네임 (nickname)
- 아이디 (login_id)
- 비밀번호 (password)
chat_message (Untitled3)
- Key (id) — Primary key — NOT NULL
- Key (sender_id) — Foreign key → Member.Key — NOT NULL
- Key (chat_room_id) — Foreign key → Chat_Room.Key — NOT NULL
- 메시지 (mesaage_type)
- 내용 (content)
- 생성일자 (created_at)