Meta-schema properties

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

Table 1. Table properties
Property	Description
Name	The name of the table.
Description	A description of the table. This value is used as a tooltip when moving the mouse cursor over the table name in the database diagram. The values set in the schema document will be overwritten by the values found in the database when updating the database schema from database. Important: The description property is extracted only from Oracle® databases for now.
View	This checkbox indicates that the object was created from a view, not a table. This property is a read-only property set when extracting the database schema. Views cannot be edited. They can only be deleted.
Active	The active property indicates that the table participates in the application code generation.
Category	The `category` property allows you to group tables using categories that you define yourself. There is no master list of categories; you simply type in the category name that you wish to assign a table. Categories can be used to filter items in the database meta-schema diagram. See Filter View dialog. This property is optional.

Table 2. Column properties
Property	Description
Name	The name of the column.
Description	A description of the column. This value is used as a tooltip when moving the mouse cursor over the column name in the database diagram. The values set in the schema document will be overwritten by the values found in the database when updating the database schema from database. Important: The description property is extracted only from Oracle databases for now.
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 3. Index properties
Property	Description
Name	The name of the index.
Columns	The table columns that define the index.
Type	The type of index: Primary Key Secondary Key Index Unique Index

Table 4. Foreign key properties
Property	Description
Name	The name of the foreign key.
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.