Application.People_Archive
Documentation | WideWorldImporters |
Schema | Application |
Name | People_Archive |
Modules | Application, History tables |
People known to the application (staff, customer contacts, supplier contacts)
Contains user names, contact information, for all who use the application, and for the people that the Wide World Importers deals with at customer organizations. This includes staff, customers, suppliers, and any other contacts. For people who have been granted permission to use the system or website, the information includes login details.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | PersonID | int | Numeric ID used for reference to a person within the database | |||||
Numeric ID used for reference to a person within the database |
||||||||
2 | FullName | nvarchar(50) | Full name for this person | |||||
Full name for this person |
||||||||
3 | PreferredName | nvarchar(50) | Name that this person prefers to be called | |||||
Name that this person prefers to be called |
||||||||
4 | SearchName | nvarchar(101) | Name to build full text search on (computed column) | |||||
Name to build full text search on (computed column) |
||||||||
5 | IsPermittedToLogon | bit | Is this person permitted to log on? | |||||
Is this person permitted to log on? |
||||||||
6 | LogonName | nvarchar(50) | Person's system logon name | |||||
Person's system logon name |
||||||||
7 | IsExternalLogonProvider | bit | Is logon token provided by an external system? | |||||
Is logon token provided by an external system? |
||||||||
8 | HashedPassword | varbinary(MAX) | Hash of password for users without external logon tokens | |||||
Hash of password for users without external logon tokens |
||||||||
9 | IsSystemUser | bit | Is the currently permitted to make online access? | |||||
Is the currently permitted to make online access? |
||||||||
10 | IsEmployee | bit | Is this person an employee? | |||||
Is this person an employee? |
||||||||
11 | IsSalesperson | bit | Is this person a staff salesperson? | |||||
Is this person a staff salesperson? |
||||||||
12 | UserPreferences | nvarchar(MAX) | User preferences related to the website (holds JSON data) | |||||
User preferences related to the website (holds JSON data) |
||||||||
13 | PhoneNumber | nvarchar(20) | Phone number | |||||
Phone number |
||||||||
14 | FaxNumber | nvarchar(20) | Fax number | |||||
Fax number |
||||||||
15 | EmailAddress | nvarchar(256) | Email address for this person | |||||
Email address for this person |
||||||||
16 | Photo | varbinary(MAX) | Photo of this person | |||||
Photo of this person |
||||||||
17 | CustomFields | nvarchar(MAX) | Custom fields for employees and salespeople | |||||
Custom fields for employees and salespeople |
||||||||
18 | OtherLanguages | nvarchar(MAX) | Other languages spoken (computed column from custom fields) | |||||
Other languages spoken (computed column from custom fields) |
||||||||
19 | LastEditedBy | int | ||||||
20 | ValidFrom | datetime2(7) | Valid from this date and time | |||||
Valid from this date and time |
||||||||
21 | ValidTo | datetime2(7) | Valid until this date and time | |||||
Valid until this date and time |
Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51