Home → Using LincDoc 3.1+ → Configuring Storage Repositories → About SQL (Database) Repositories
This topic provides information specific to the SQL repository provided with all LincDoc application installations. This type of repository is sometimes known as a Database repository.
Although this information is not necessarily needed for defining or using the repository, it may be helpful for some users who want or need a deeper understanding of how the repository (and underlying database) functions.
A set of system tables are used to store folders, files, document (and related metadata), version history, and attachments. These following tables are used:
The actual table name is taken by amending the above names with the prefix and suffix configured in the repository's connection settings, which allows multiple, independent repositories to be placed in the same database schema. The prefix is added to the beginning of the table name (prepended), while the suffix is added to the end of the table name (appended).
Note: You can view the DDL used to create the system tables using the show system table DDL button. This feature is useful in cases where a database administrator wants to personally execute the corresponding commands instead of doing it through the LincDoc connection.
LincDoc document data may be stored in one or more tables. Non-multi-row fields are mapped to a set of one or more tables. Fields in each multi-row table are mapped to a set of one or more tables. Each of these tables has the following four required system columns:
The group_name and row_index fields are in non-multi-row tables. Therefore, if a table is used for multi-row and non-multi-row fields, LincDoc can determine which rows correspond to which fields.