# 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](https://help.qlik.com/talend/en-US/data-mapper-user-guide/8.0/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).