AssociateHistory Table (526)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
Historical information about associates that have been deleted. Most references are NOT declared as foreign keys; this is a historical table that should not be updated when further changes occur in the database
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| associatehistory_id | Primary key | PK | |
| associateId | The original primary key of the deleted associate | Int | ● |
| groupId | The group id | Int | ● |
| personId | The person id | Int | ● |
| type | Associate type | Enum AssociateType | ● |
| originalRegistered | Registered when | UtcDateTime | ● |
| locationAddress | Address of location, if this is a resource that is a location | String(239) | ● |
| ejUserId | The ejuser reference, if any | Int | ● |
| name | The associate name/initials | String(255) | ● |
| firstname | First name | String(99) | ● |
| middleName | Middle name or 'van' etc. | String(99) | ● |
| lastname | Last name | String(99) | ● |
| contactId | The original contact_id | Int | ● |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate |
Indexes
| Fields | Types | Description |
|---|---|---|
| associatehistory_id | PK | Clustered, Unique |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
Replication Flags
- None
Security Flags
- No access control via user's Role.