Parent topic: Meta-schema Manager Reference
Meta-schema Manager / Meta-schema Manager Reference

Meta-schema properties

Properties can be set for each element in a meta-schema.

Table 1. Common properties
Property Description
Name The name property identifies the name of the item.
Table 2. Table properties
Property Description
Active The active property indicates that the table participates in the application code generation.
Table 3. Column properties
Property Description
Order Position of the column in the table.
Data Type Specifies the data type of the column. See Data types.
Length Defines the maximum length of the character string. The upper limit is 65534.
Precision For DECIMAL data types; defines the number of significant digits (limit is 32, default is 16).
Scale For DECIMAL data types; defines the number of digits to the right of the decimal point.
Qualifier 1, Qualifier 2 Specify the qualifiers for INTERVAL and DATETIME data typed columns, for example YEAR and MONTH.
Not null Specifies that the column does not accept NULL values.
Default value Assigns a default value to a column.
Label Specifies the default label for a form item using the column.
Widget Widgets are designed for data handling, action triggering, or decoration. Specify the default widget for a form item using the column.
Table 4. Index properties
Property Description
Columns The table columns that define the index.
Table 5. Foreign key properties
Property Description
Table Table that contains the foreign key.
Columns The table column that references the primary key column in the referenced table.
Referenced table The table that contains the primary key being referenced.
Referenced columns The name of the primary key column in the referenced table.
Cascade delete A foreign key with a cascade delete specifies that if a row in the parent table is deleted, then the corresponding rows in the child tables are automatically deleted.
Parent topic: Meta-schema Manager Reference