CREATE TABLE TransferedFile
(
  id TEXT PRIMARY KEY
, classModelId TEXT NOT NULL REFERENCES ClassModel (id)
, name TEXT NOT NULL
, storedFilePath TEXT NOT NULL
, dateTimeOfTransfer TEXT NOT NULL
, tags TEXT
);

CREATE TABLE TransferStatus
(
    id TEXT PRIMARY KEY
  , transferedFileId TEXT NOT NULL REFERENCES TransferedFile (id)
  , studentId TEXT NOT NULL REFERENCES Student (id)
);