Folder

Tables (3)

Untitled (OFFICE_FOLDER)

  • Key (FOLDERID) — Primary key — NOT NULL
  • Field (ROOMID) — NOT NULL
  • Field (PARENTID)
  • Field (FOLDERNAME) — NOT NULL
  • Field (TIMESTAMP) — NOT NULL

Untitled (OFFICE_FOLDER_REL)

  • Key (FOLDERID) — Foreign key → Untitled.Key — NOT NULL
  • master_id (DOCUMENTID) — Foreign key → master.master_id — NOT NULL

master (OFFICE_DOC_FILE)

  • master_id (DOCUMENTID) — Primary key — NOT NULL
  • Field (DOCUMENTNAME)
  • Field (DOCUMENTEXTENSION)
  • Field (USERID)
  • Field (BOOKMARK) — NOT NULL
  • Field (TIMESTAMP) — NOT NULL
  • Field (VISIBILITY) — NOT NULL