ChatProject

Tables (4)

ChatParticipant (Untitled)

  • id (Key) — Primary key — NOT NULL
  • id (userId) — NOTNULL — Foreign key → User.id — NOT NULL
  • id (ChatRoomID) — NOTNULL — Foreign key → ChatRoom.id — NOT NULL
  • joinedAt (Field)

ChatRoom (채팅)

  • id (Key) — NOTNULL — Primary key — NOT NULL
  • type (타입) — NOTNULL
  • roomname (방이름) — NOTNULL
  • createdAt (Field3)

Message (메세지)

  • id (Key) — Primary key — NOT NULL
  • id (userId) — NOTNULL — Foreign key → User.id — NOT NULL
  • id (ChatRoomId) — NOTNULL — Foreign key → ChatRoom.id — NOT NULL
  • content (Field)
  • createdAt (Field2)
  • messageType (Field3)

User (유저)

  • id (Key) — NOTNULL — Primary key — NOT NULL
  • email (이메일) — NOTNULL
  • password (패스워드) — NOTNULL
  • username (이름) — NOTNULL
  • gender (성별) — NOTNULL
  • age (나이) — NOTNULL