Metadata Structure Tables¶
MFSQL Connector maintains a large portion of the vault’s metadata definitions. It also includes additional columns not defined in M‑Files. The tables are created during installation and populated by the metadata synchronization procedures.
The tables cover object types, classes, properties, value lists, workflows, login accounts, and users.
The following additional columns are created on these tables to complement the M‑Files data definitions:
Column |
Description |
|---|---|
ID |
SQL identity column that represents the SQL ID of the object |
MFID |
M‑Files ID of the object |
Alias |
The M-Files Alias |
Modified on |
Date the item was last modified in SQL |
Created on |
Date the item was created in SQL |
Deleted |
Set to 1 by the Connector if it was deleted in M‑Files |
These tables include several extensions of the standard M‑Files metadata that are useful in specific applications.
The columns and their usage for the metadata structure tables are outlined in the following sections: