소공
테이블 (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)