Database representation properties
- Database: Select a database from your workspace.
- Database table: Enter the name of the database table to use in this structure.
- Primary key columns: Select the column(s) that form the primary key for this table.
-
Primary key generation: Select how the primary key should
be generated for this table:
- None: Does not generate anything for the primary key. The value is expected to be mapped.
- Native: Automatically select the primary key generation most appropriate for the database.
- Identity: Supports identity columns in DB2, MySQL, MS SQL Server, Sybase and HypersonicSQL. Used for identity columns whose type is long, short or int.
- Increment: Generate a sequential number by incrementing a local value before an item is inserted. This is not suitable for an multi-user (including multi-threaded) environment where more than one process/thread may be inserting into the same table at a time.
- Sequence: Uses a sequence in DB2, PostgreSQL, or Oracle.
- Generation sequence name: Specify the sequence name to be used in the case where Primary key generation is either Sequence or Native (and the native implementation uses Sequence). If not specified, hibernate_sequence is used.
- Character encoding: Specify the character encoding for the data to be processed. For more information, see Character encoding.
- Trim whitespace on input?: Select this check box to automatically remove any leading or trailing whitespace from the input data for all elements. The non-leading or trailing whitespace is not affected.
- Pad to minimum length on output?: Select this check box to pad the output to the minimum size with either spaces (character) or zeros (binary).