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 |