search

fuhui14 / SWEN90017-2024-TAP

1 stars 0 forks source link

Create ER diagram #16

Open fuhui14 opened 1 month ago

fuhui14 commented 2 weeks ago
  1. Table File may not necessary to be include in database. Does table File mean the original file which the user uploads? Do we need to save the original file in our database?
  2. Could add a User table. Although we don't have login function, I think we still need to storage user's email to send the transcription and status report after transcribe. And user data may affect the authentication process for accessing history portal.
fuhui14 commented 2 weeks ago
  1. According to class diagram, should we build a new table for history record, which includes non-expired files and expire dates for each non-expired files?
fuhui14 commented 2 weeks ago
  1. I'm not sure if we need to create a table for files in the queue of transcribing. Do you think it can make sense? For the function of queue, we need to know the quantities of files in the transcribing process and estimated waiting time for the first files waiting to transcribe for the user. But I don't know if it is necessary to be storaged in database.
fuhui14 commented 2 weeks ago
  1. Should include a column for language in File table.
  2. Should include a column for expiredDate for Transcription table.