Chat
Tables (4)
ChatMessage (메세지)
- message_id (메시지ID) — PK — Primary key — NOT NULL
- room_id (채팅방 ID) — FK — Foreign key → ChatRoom.room_id — NOT NULL
- user_id (회원ID) — FK — Foreign key → User.user_id — NOT NULL
- message (메시지) — Not Null
- send_date (보내는 시간) — Not Null
ChatRoom (채팅방)
- room_id (채팅방 ID) — PK — Primary key — NOT NULL
- user_id (회원ID) — FK — Foreign key → User.user_id — NOT NULL
- chat_name (채팅방 이름) — Not Null
- created_date (생성일) — Not Null
ChatUser (채팅방 참여 유저)
- id (채탕방 참여 유저id) — PK — Primary key — NOT NULL
- user_id (회원ID) — FK — Foreign key → User.user_id — NOT NULL
- room_id (채팅방 ID) — FK — Foreign key → ChatRoom.room_id — NOT NULL
User (회원)
- user_id (회원ID) — PK — Primary key — NOT NULL
- user_name (이름) — Not Null
- email (이메일) — Not Null
- password (비밀번호) — Not Null
- authority (권한) — Not Null