SFM

Tables (3)

ChatRoom (Untitled2)

  • chatRoomId (채팅방 ID) — Primary key — NOT NULL
  • name (이름)

ChatRoomUser (Untitled3)

  • chatUserId (채팅 유저 ID) — Primary key — NOT NULL
  • chatRoomId (채팅방 ID) — Foreign key → ChatRoom.chatRoomId — NOT NULL
  • userId (유저 ID) — Foreign key → User.userId — NOT NULL

User (Untitled)

  • userId (유저 ID) — Primary key — NOT NULL
  • name (유저 이름)
  • password (비밀번호)
  • nickname (닉네임)