소공

테이블 (7)

ChatMessage (Untitled4)

  • id (Key) — 기본 키 — NOT NULL
  • roomId (Key2) — 외래 키 → ChatRoom.id — NOT NULL
  • content (Field3) — TEXT
  • createdAt (Field4) — datetime
  • senderId (Key3) — 외래 키 → Student.id — NOT NULL
  • receiverId (Key4) — 외래 키 → Student.id — NOT NULL

ChatRoom (Untitled6)

  • id (Key) — 기본 키 — NOT NULL
  • name (Field)

DormAdmin (CopyOfStudent)

  • id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • email (Field2)
  • affiliation (Field3)
  • hashedPassword (Field4)
  • gender (Field5)

Join (Untitled)

  • roomId (Key) — 외래 키 → ChatRoom.id — NOT NULL
  • studentId (Key2) — 외래 키 → Student.id — NOT NULL

MatchResult (Untitled5)

  • senderId (Key) — 외래 키 → Student.id — NOT NULL
  • receiverId (Key2) — 외래 키 → Student.id — NOT NULL
  • isMatched (Field) — boolean

Student

  • id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • email (Field2)
  • affiliation (Field3)
  • hashedPassword (Field4)
  • gender (Field5)
  • isMatched (Field6)
  • matchingStatus (Field7)
  • roommateId (Key2) — 외래 키 → Student.id — NOT NULL

StudentProfile (Untitled3)

  • studentId (Key) — 외래 키 → Student.id — NOT NULL
  • smoking (Field)
  • dayNight (Field2)
  • dormName (Field3)