Table: Legacy_Contact_Portal_Mapping
Contains the legacy mappings for contacts to portals that need to be converted.
Columns
NameTypeConstraintsDescription
primary__contact_KEYintNOT NULLThe primary key.
contact_KEYintNOT NULLThe contact key.
loginnvarchar (50)NOT NULLUnique but mutable login name
netstaff_idintUnique and immutable primary key of the staff portal
mobilecs_enabledbitNOT NULLWhether mobilecs is enabled if this mapping was a netstaff
Primary key
NameColumnsDescription
PK_Legacy_Contact_Portal_Mapping$primary__contact_KEYprimary__contact_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Legacy_Contact_Portal_Mapping$contact_KEYcontact_KEYIndex supports foreign key FK_Legacy_Contact_Portal_Mapping__Contact__contact_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Legacy_Contact_Portal_Mapping__Contact__contact_KEYcontact_KEYContacton delete cascade;
FK_Legacy_Contact_Portal_Mapping__Contact__primary__contact_KEYprimary__contact_KEYContact

Schema diagram