cattalk
Tables (4)
ChatRoom (채팅방)
- RoomID (채팅방ID) — Primary key — NOT NULL
- Name (이름)
Chatting (채팅)
- ChatID (채팅ID) — Primary key — NOT NULL
- Contants (내용)
- ToTime (보낸시간)
- ToUser (송신자)
- FromUser (수신자)
- ChatRoomID (채팅방ID)
Friendship (친구)
- FriendsID (관계ID) — Primary key — NOT NULL
- UserID (사용자ID) — Foreign key → User.UserID — NOT NULL
- FromUser (받은사용자)
- Status (상태)
User (사용자)
- UserID (사용자ID) — Primary key — NOT NULL
- Name (이름)
- Email (이메일)