Table: Portal_User
Cached portal web service data.
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
portal_user_KEYintNOT NULLunique and immutable primary key of this portal which is also used as this table's primary key
loginnvarchar (150)unique but mutable login name
last_modification_datedatetimeNOT NULLtime at which the portal server last updated this portal data
end_datedatetimetime at which the portal server was made inactive
first_namenvarchar (70)first name of person associated with this portal
last_namenvarchar (256)last name of person associated with this portal
email_addressnvarchar (150)email address associated with this portal
online_bill_pay_enabledbitwhether or not this portal is authorized for online bill pay
mobilecs_enabledbitwhether or not this portal is authorized for mobile cs
portal_user_type_KEYintNOT NULL
registration_datedatetimeThe time at which this Portal's registration was completed
registration_sent_datedatetimeThe time at which this Portal's registration email was sent
expiration_datedatetimeIf a value exists then this portal is a temporary type portal and will expire at this time
firm_idintNOT NULLThe firm id in the license file at the time this record was last modified.
Primary key
NameColumnsDescription
PK_Portal_User$portal_user_KEYportal_user_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Portal_User$portal_user_type_KEYportal_user_type_KEYIndex supports foreign key FK_Portal_User__Portal_User_Type__portal_user_type_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Contact__Portal_User__portal_user_KEYportal_user_KEYContact
FK_File_Transfer__Portal_User__contact__portal_user_KEYcontact__portal_user_KEYFile_Transfer
FK_File_Transfer__Portal_User__staff__portal_user_KEYstaff__portal_user_KEYFile_Transfer
FK_File_Transfer_Event__Portal_User__portal_user_KEYportal_user_KEYFile_Transfer_Event

Schema diagram