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