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.
Note:

For Genero Studio for Report Writer, setting the widget property has no influence.

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.