Table: Portal_User | |||
Cached portal web service data. | |||
Columns | |||
Name | Type | Constraints | Description |
create__changeset_KEY | int | NOT NULL | |
update__changeset_KEY | int | NOT NULL | |
portal_user_KEY | int | NOT NULL | unique and immutable primary key of this portal which is also used as this table's primary key |
login | nvarchar (150) | unique but mutable login name | |
last_modification_date | datetime | NOT NULL | time at which the portal server last updated this portal data |
end_date | datetime | time at which the portal server was made inactive | |
first_name | nvarchar (70) | first name of person associated with this portal | |
last_name | nvarchar (256) | last name of person associated with this portal | |
email_address | nvarchar (150) | email address associated with this portal | |
online_bill_pay_enabled | bit | whether or not this portal is authorized for online bill pay | |
mobilecs_enabled | bit | whether or not this portal is authorized for mobile cs | |
portal_user_type_KEY | int | NOT NULL | |
registration_date | datetime | The time at which this Portal's registration was completed | |
registration_sent_date | datetime | The time at which this Portal's registration email was sent | |
expiration_date | datetime | If a value exists then this portal is a temporary type portal and will expire at this time | |
firm_id | int | NOT NULL | The firm id in the license file at the time this record was last modified. |
Primary key | |||
Name | Columns | Description | |
PK_Portal_User$portal_user_KEY | portal_user_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Portal_User$portal_user_type_KEY | portal_user_type_KEY | Index supports foreign key FK_Portal_User__Portal_User_Type__portal_user_type_KEY |