database_schema.dbml

Table filetrove {
  version TEXT
  initdate TEXT
  lastupdate TEXT
}

Table sessionsmd {
  uuid TEXT
  starttime TEXT
  endtime TEXT
  project TEXT
  archivistname TEXT
  mountpoint TEXT
  exifflag TEXT
  dublincoreflag TEXT
  yaraflag TEXT
  yarasource TEXT
  filetroveversion TEXT
  filetrovedbversion TEXT
  nsrlversion TEXT
  siegfriedversion TEXT
  goversion TEXT
}

TABLE dublincore{
  uuid TEXT
  sessionuuid TEXT
  title TEXT
  creator TEXT
  contributor TEXT
  publisher TEXT
  subject TEXT
  description TEXT
  date TEXT
  language TEXT
  type TEXT
  format TEXT
  identifier TEXT
  source TEXT
  relation TEXT
  rights TEXT
  coverage TEXT
}

TABLE files {fileuuid TEXT
  sessionuuid TEXT
  filename TEXT
  filepath TEXT
  filenameextension TEXT
  filesize INTEGER
  filemd5 TEXT
  filesha1 TEXT
  filesha256 TEXT
  filesha512 TEXT
  fileblake2b TEXT
  filesffmt TEXT
  filesfmime TEXT
  filesfformatname TEXT
  filesfformatversion TEXT
  filesfidentnote TEXT
  filesfidentproof TEXT
  filectime TEXT
  filemtime TEXT
  fileatime TEXT
  filensrl TEXT
  fileentropy INTEGER
  hierarchy INTEGER
}

TABLE directories{
  diruuid TEXT
  sessionuuid TEXT
  dirname TEXT
  dirpath TEXT
  dirctime TEXT
  dirmtime TEXT
  diratime TEXT
  hierarchy INTEGER
}

TABLE exif{
  exifuuid TEXT
  sessionuuid TEXT
  fileuuid TEXT
  exifversion TEXT
  datetime TEXT
  datetimeorig TEXT
  artist TEXT
  copyright TEXT
  xptitle TEXT
  xpcomment TEXT
  xpauthor TEXT
  xpkeywords TEXT
  xpsubject TEXT
}

TABLE yara{
  yaraentryuuid TEXT
  sessionuuid TEXT
  fileuuid TEXT
  rulename TEXT
}

Ref: files.sessionuuid > sessionsmd.uuid
Ref: exif.sessionuuid > sessionsmd.uuid
Ref: exif.fileuuid > files.fileuuid
Ref: directories.sessionuuid > sessionsmd.uuid
Ref: dublincore.sessionuuid > sessionsmd.uuid
Ref: yara.sessionuuid > sessionsmd.uuid
Ref: yara.fileuuid > files.fileuuid