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')