chat
Tables (5)
Chat (채팅)
- id (ID) — Primary key — NOT NULL
- is_read (읽기여부)
- chat_room_id (채팅방ID) — Foreign key → ChatRoom.id — NOT NULL
- sender_id (발신자ID) — Foreign key → Member.id — NOT NULL
- content (본문)
- send_time (보낸시간)
ChatRoom (채팅방)
- id (ID) — Primary key — NOT NULL
- is_alert (푸시알림전송여부)
- last_chat (마지막채팅)
- last_chat_time (마지막채팅시간)
- post_card_Id (엽서ID) — Foreign key → Postcard.id — NOT NULL
Member (member)
- id (ID) — Primary key — NOT NULL
MemberChatRoom (매핑테이블)
- id (ID) — Primary key — NOT NULL
- member_id (멤버ID) — Foreign key → Member.id — NOT NULL
- chat_room_id (채팅방ID) — Foreign key → ChatRoom.id — NOT NULL
- unread_count (안읽은채팅개수)
- is_alert (알림수신여부)
Postcard (엽서)
- id (ID) — Primary key — NOT NULL
- receive_member_id (수신멤버ID) — Foreign key → Member.id — NOT NULL