Edu
Tables (9)
AiNote (ai_notes)
- note_id (Key) — bigint — Primary key — NOT NULL
- user_id (Key2) — bigint — Foreign key → User.user_id — NOT NULL
- original_file_ref (Field2) — varchar(255)
- summary_content (Field3) — TEXT
- created_at (Field4) — timestamp
ChatMessage (chatMessages)
- message_id (Key) — bigint — Primary key — NOT NULL
- room_id (Key2) — bigint — Foreign key → StudyRoom.room_id — NOT NULL
- user_id (Key3) — bigint — Foreign key → User.user_id — NOT NULL
- content (Field3) — TEXT
- timestamp (Field4) — timestamp
Department (departments)
- department_id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(25)
RoomParticipant (roomParticipants)
- participants_id (Key) — bigint — Primary key — NOT NULL
- user_id (Key2) — bigint — Foreign key → User.user_id — NOT NULL
- room_id (Key3) — bigint — Foreign key → StudyRoom.room_id — NOT NULL
- joined_at (Field3)
RoomTagMap (room_tag_map)
- room_tag_id (Key) — bigint — Primary key — NOT NULL
- room_id (Key2) — bigint — Foreign key → StudyRoom.room_id — NOT NULL
- tag_id (Key3) — Foreign key → Tag.id — NOT NULL
StudyRecord (studyRecords)
- record_id (Key) — bigint — Primary key — NOT NULL
- user_id (Key2) — bigint — Foreign key → User.user_id — NOT NULL
- room_id (Key3) — bigint — Foreign key → StudyRoom.room_id — NOT NULL
- start_time (Field2) — timestamp
- end_time (Field3) — timestamp
- duration (Field4) — int
StudyRoom (studyRooms)
- room_id (Key) — bigint — Primary key — NOT NULL
- owner_id (Key2) — bigint — Foreign key → User.user_id — NOT NULL
- title (Field2) — varchar(25)
- description (Field3) — varchar(255)
- max_capacity (Field4) — int
- is_public (Field5) — boolean
- password (Field6) — varchar(25)
- created_at (Field7)
Tag (tags)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(255)
- category (Field2) — ENUM
- department_id (Key2) — bigint — Foreign key → Department.department_id — NOT NULL
User (users)
- user_id (Key) — bigint — Primary key — NOT NULL
- kakao_id (Field) — bigint
- nickName (Field2) — varchar(25) — NOT NULL
- profil_url (Field3) — varchar(255)
- created_at (Field4) — timestamp
- updated_at (Field5) — timestamp