Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason | CX Insights Name | CX Insights Type | CX Insights Folder Name |
---|---|---|---|---|---|---|---|---|---|
RankId | uniqueidentifier | False | No | 4.0.106.453 | 4.0 Release | ||||
RankGroupId | uniqueidentifier | False | No | 4.0.106.453 | 4.0 Release | ||||
RankName | nvarchar (40) | False | Depends on customer usage | 4.0.106.453 | 4.0 Release | ||||
RankPct | numeric | False | No | 4.0.106.453 | 4.0 Release | ||||
Version | int | False | No | 4.0.106.453 | 4.0 Release |
Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason | CX Insights Name | CX Insights Type | CX Insights Folder Name |
---|---|---|---|---|---|---|---|---|---|
RankId | raw (16) | False | No | 4.0.106.453 | 4.0 Release | ||||
RankGroupId | raw (16) | False | No | 4.0.106.453 | 4.0 Release | ||||
RankName | nvarchar2 (40) | False | Depends on customer usage | 4.0.106.453 | 4.0 Release | ||||
RankPct | numeric | False | No | 4.0.106.453 | 4.0 Release | ||||
Version | integer | False | No | 4.0.106.453 | 4.0 Release |
Primary Key Name | Type | Column Name (sort order) |
---|---|---|
PK_IR_RankDefn | Clustered | RankId (Ascending) |
Primary Key Name | Column Name (sort order) |
---|---|
PK_IR_RankDefn | RankId (Ascending) |
Foreign Key Name | Column | Reference Table | Reference Column | Indexed |
---|---|---|---|---|
FK_IR_RankDefn_RankGroupId | RankGroupId | IR_RankGroup | RankGroupId | Yes |
Foreign Key Name | Column | Reference Table | Reference Column | Indexed |
---|---|---|---|---|
FK_IR_RankDefn_RankGroupId | RankGroupId | IR_RankGroup | RankGroupId | Yes |