Use this editor to edit parameters of the database columns, corresponding to entity properties .
The Column Editor dialog is accessible through the three-dotted button on the right side of the Column field in the following dialog boxes:
| • | Association Editor; |
| • | Class Editor; |
| • | Type Editor; |
| • | Inheritance Editor; |
| • | Join Tables Editor; |
| • | Property Editor. |
The following options are available:
Mapping - allows setting the property mapping type for the column. The value of this field for scalar properties is set to Custom mapping and cannot be changed. For component type properties possible values are: Custom mapping, Default mapping and No mapping.
Column Name - specifies the name of the column.
Not null - if selected, specifies that the column should be non-nullable. If the value of the Not Null check box is not specified explicitly, i.e. is not checked or unchecked, its value will be calculated depending on the Nullable property value of the corresponding property.
Unique - if selected, specifies that the column should have a unique constraint.
SQL Type - overrides the default column type.
Fixed Length - determines whether to use fixed length data types for string and binary properties (for example, CHAR, BINARY for SQL Server). If not selected (by default), such types as VARCHAR/VARBINARY are used.
Unicode - can be used, for example, to specify that the string data type in the model is to be matched with the NCHAR or NVARCHAR types in the database. If the value of the Unicode check box is not specified explicitly, its value will be calculated depending on the Default Unicode property value from the model property set.
Length - specifies column length. If the value of the Length field is not specified explicitly, its value will be calculated depending on the Default Length property value from the model property set.
Precision - specifies decimal precision of the column. If the value of the Precision field is not specified explicitly, its value will be calculated depending on the Default Precision property value from the model property set.
Scale - specifies the number of places after the decimal point. If the value of the Scale field is not specified explicitly, its value will be calculated depending on the Default Scale property value from the model property set.
Default Value - specifies the default value.
Check - creates an SQL check constraint on either column or table.
Index Name - specifies the name of a (multi-column) index.
Unique Key - specifies the name of a multi-column unique constraint.
