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 (이메일)