Jarviser_erd

Tables (9)

audio_message

  • audio_message_id — BIGINT — Primary key — NOT NULL
  • speech_length — INT
  • meeting_id — BIGINT
  • priority — BIGINT
  • start_time — DATETIME(6)
  • user_id — BIGINT
  • content — VARCHAR(255)
  • file_path — VARCHAR(255)

chat_message

  • chat_message_id — BIGINT — Primary key — NOT NULL
  • meeting_id — BIGINT
  • timestamp — DATETIME(6)
  • content — VARCHAR(255)
  • sender — VARCHAR(255)

keywordstatistics

  • keyword_statistics_id — BIGINT — Primary key — NOT NULL
  • percent — DOUBLE — NOT NULL
  • meeting_id — BIGINT
  • keyword — VARCHAR(255)

meeting

  • meeting_id — BIGINT — Primary key — NOT NULL
  • end_time — DATETIME(6)
  • host_id — BIGINT
  • start_time — DATETIME(6)
  • encryptedKey — VARCHAR(255)
  • meeting_name — VARCHAR(255)
  • meeting_url — VARCHAR(255)

participant

  • participant_id — BIGINT — Primary key — NOT NULL
  • end_time — DATETIME(6)
  • meeting_id — BIGINT
  • start_time — DATETIME(6)
  • user_id — BIGINT — Foreign key → user.user_id
  • role — ENUM('HOST', 'PARTICIPANT')
  • INDEX — `FKj2ywtc5meno2ouhf5pcq9rsbh`

report

  • report_id — BIGINT — Primary key — NOT NULL
  • meeting_id — BIGINT
  • summary — VARCHAR(255)

reservated_meeting

  • reservated_meeting_id — BIGINT — Primary key — NOT NULL
  • host_id — BIGINT
  • start_time — DATETIME(6)
  • description — VARCHAR(255)
  • meeting_name — VARCHAR(255)

reservation

  • reservation_id — BIGINT — Primary key — NOT NULL
  • reservated_meeting_id — BIGINT — Foreign key → reservated_meeting.reservated_meeting_id
  • user_id — BIGINT — Foreign key → user.user_id
  • INDEX — `FKnrjkqhtxr8fi26g4gel366w3e`
  • INDEX — `FKm4oimk0l1757o9pwavorj6ljg`

user

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255)
  • name — VARCHAR(255)
  • password — VARCHAR(255)
  • role — ENUM('ADMIN', 'USER')