Generated using SQL Data Dictionary demo version.
Column | Data Type | Identity | Nullable | Default | |
---|---|---|---|---|---|
PersonID | int | ||||
FullName | nvarchar(50) | ||||
PreferredName | nvarchar(50) | ||||
SearchName | nvarchar(101) | ||||
IsPermittedToLogon | bit | ||||
LogonName | nvarchar(50) | X | |||
IsExternalLogonProvider | bit | ||||
HashedPassword | varbinary(max) | X | |||
IsSystemUser | bit | ||||
IsEmployee | bit | ||||
IsSalesperson | bit | ||||
UserPreferences | nvarchar(max) | X | |||
PhoneNumber | nvarchar(20) | X | |||
FaxNumber | nvarchar(20) | X | |||
EmailAddress | nvarchar(256) | X | |||
Photo | varbinary(max) | X | |||
CustomFields | nvarchar(max) | X | |||
OtherLanguages | nvarchar(max) | X | |||
LastEditedBy | int | ||||
ValidFrom | datetime2 | ||||
ValidTo | datetime2 |