Data Model

Describes DB structure for platform use.

For each Table/View the following parameters are defined:

# Name Type Comment
1 Name string
2 System flag
3 Scheme string Table scheme. By default "dbo"
4 Table name string The table name in a DB
5 Versioning type The following types of a versions are supported:Without a versioningVersioning of basic entityVersioning of the connected entityVersion
6 View flag Defines object type in a DB (Table – the flag is removed, View – the flag is established)
7 Comment string
8 Support optimistic lock flag
9 Available for import/export flag

"Link" attibute

# Name Type Comment
1 Name string The name for the system interface
2 Column name string The column name in a DB
3 Purpose choose from list Available values:NormalPrimary keyField for versioningReference to parentFile downloadToken fileId version entityId base version entityVersion fromVersion toLogical deleted
4 Nullable flag
5 System flag
6 Virtual flag If the flag is set, at inquiries to a DB the column is excluded from inquiry.
7 Calculate flag If the flag is set, at INSERT/UPDATE inquiries to a DB the column is excluded from inquiry.
8 Value by default string
9 Object choose from list Reference to a data model that linked from this columns
10 Parameters Used at automatic column creation in a relational DB

"Column" attribute

Name Type Comment
1 Name string The name for the system interface
2 Column name string The column name in a DB
3 Purpose choose from list Available values: Normal; Primary key; Field for versioning; Reference to parent; File download; Token file; Id version entity; Id base version entity; Version from; Version to; Logical deleted
4 Nullable flag
5 System flag
6 Virtual flag If the flag is set, at inquiries to a DB the column is excluded from inquiry.
7 Calculate flag If the flag is set, at INSERT/UPDATE inquiries to a DB the column is excluded from inquiry.
8 Value by default string
9 Column type choose from list The column type in a DB
10 List choose from list It is used for a task of static replacements like Code-Name

Additional functions

1. Lists

Used for a task of static replacements like Code-Name.

2. Update model

The master of updating model objects on the basis of DB structure. It is used in case of a divergence of structure of DB and model.

The string of connection to a DB on which it is required to update model is specified in the settings "Updating of Data model —String of Connection".

3. Sync DB for select items

The master of update database by data model from platform.

The string of connection to a DB on which it is required to update model is specified in the settings "Updating of Data model —String of Connection".

Warning: This functionality is in test mode.

4. Generate objects

The master allows generating of : View, Form with the indication of a template, Menu.

Screenshots:

Screenshot 1 Screenshot 2 Screenshot 3