Contains information about database join definitions
| Column Name | Column Datatype | Column Null Option | Column Comment |
| join_name | nvarchar(100) | not null | Join name. Primary key. Unique. |
| join_description | nvarchar(255) | with null | Join description. |
| relation_type | smallint | with null | Enumerated constant to represent the relation type. 0="one-to-one" 1="one-to-many" 2="many-to-one" 3="many-to-many" |
| join_type | smallint | with null | Enumerated constant to represent the join type. 0="equal join" 1="left outer join" 2="right outer join" 3="full outer join" 4="cross join" 5="self join" |
| creation_user | nvarchar(64) | with null | User or process that created the record. |
| creation_date | integer | with null | Date the record was created. |
| last_update_user | nvarchar(64) | with null | User or process who last updated the record. |
| last_update_date | integer | with null | Date the record was last updated. |
| version_number | integer | with null | Version number for transaction integrity. |
Product Name: Unicenter Asset Portfolio Management
Table Type: Table