Table: Legacy_Contact_Portal_Mapping | |||
Contains the legacy mappings for contacts to portals that need to be converted. | |||
Columns | |||
Name | Type | Constraints | Description |
primary__contact_KEY | int | NOT NULL | The primary key. |
contact_KEY | int | NOT NULL | The contact key. |
login | nvarchar (50) | NOT NULL | Unique but mutable login name |
netstaff_id | int | Unique and immutable primary key of the staff portal | |
mobilecs_enabled | bit | NOT NULL | Whether mobilecs is enabled if this mapping was a netstaff |
Primary key | |||
Name | Columns | Description | |
PK_Legacy_Contact_Portal_Mapping$primary__contact_KEY | primary__contact_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Legacy_Contact_Portal_Mapping$contact_KEY | contact_KEY | Index supports foreign key FK_Legacy_Contact_Portal_Mapping__Contact__contact_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Legacy_Contact_Portal_Mapping__Contact__contact_KEY | contact_KEY | Contact | on delete cascade; |
FK_Legacy_Contact_Portal_Mapping__Contact__primary__contact_KEY | primary__contact_KEY | Contact |