Table properties, such as columns, primary keys, and foreign keys displayed in the
Properties collapsible tab on the on the Edit Physical
Model page are based on the type of source connection selected in the physical
model. The detail for various connection types are given below.
- JDBC connection
-
- Columns
- Displays the name, data type, and size of each column. The section also displays whether a column is nullable and/or a primary key.
- Primary Keys
- Displays the primary key, primary key name, and key sequence.
- Foreign Keys
- Displays the foreign key column name, foreign key name, primary key catalog name, primary key table name, primary key column name, and primary key name.
- Indexes
- Displays the index name, column name, and whether the indexes are unique or non-unique. If an index is non-unique then the NU check box is displayed as checked otherwise it is displayed as unchecked.
- Amazon DynamoDB connection
-
- Columns
- Displays the name and data type of each column. The section also displays whether a column can be updated, searched, and/or is a primary key.
- Primary Keys
- Displays the primary key and primary key name.
- Amazon SimpleDB connection
-
- Columns
- Displays the column name and data type for the table you select.
- Flat File connection
-
- Columns
- Displays the column name and data type for the table you select.
- MS Dynamics 365 Online connection
-
- Columns
- Displays the column name and data type. The section also displays whether a column is nullable and/or a primary key.
- Primary Keys
- Displays the primary key and primary key name.
- Foreign Keys
- Displays the foreign key column name, foreign key name, and the reference table name.
- Permissions
- Indicates which functions can be performed on the selected physical model table. Currently, the functions create, read, write, and delete can be performed on an MS Dynamics 365 Online table.
- Salesforce connection
- Columns
- Displays the name, data type, and size of each column. The section also displays whether a column is nullable and/or a primary key.
- Primary Keys
- Displays the primary key and primary key name.
- Foreign Keys
- Displays the foreign key column name, foreign key name, and the reference table name.