Historical relationships between users
| Column Name | Type | Length | Nullable | Unicode | Description |
|---|---|---|---|---|---|
| creationDate | bigint | N/A | false | The timestamp when a relation was created. | |
| graphID | bigint | N/A | false | The ID of a relationship's graph. | |
| relatedUserID | bigint | N/A | false | User ID of the object of the relationship. | |
| relationshipID | bigint | N/A | false | The relationship ID. Primary key. | |
| relnshipTypeID | int | 1 | false | The UserRelationship.RelationshipType of how the subject is related to the object. | |
| retirementDate | bigint | N/A | true | The timestamp when a relation was retired - null if active. | |
| state | varchar | 20 | false | The UserRelationship.RelationshipState of the relationship. | |
| userID | bigint | N/A | false | User ID of the subject of the relationship. | |
| workflowID | bigint | N/A | true | The ID of the approval workflow associated with this relationship. |