Application.People - WideWorldImporters

WideWorldImporters

- WideWorldImporters

Documentation	WideWorldImporters
Schema	Application
Name	People
Module	Application

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

		Name	Data type	Attributes	References	Description
	1	PersonID	int	Default: NEXT VALUE FOR [Sequences].[PersonID]		Numeric ID used for reference to a person within the database
Numeric ID used for reference to a person within the database Default: NEXT VALUE FOR [Sequences].[PersonID]
	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)	Computed: concat([PreferredName],N' ',[FullName])		Name to build full text search on (computed column)
Name to build full text search on (computed column) Computed: concat([PreferredName],N' ',[FullName])
	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)	Computed: json_query([CustomFields],N'$.OtherLanguages')		Other languages spoken (computed column from custom fields)
Other languages spoken (computed column from custom fields) Computed: json_query([CustomFields],N'$.OtherLanguages')
	19	LastEditedBy	int		Application.People
References: Application.People
	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

Relations

Foreign table	Primary table	Join	Title / Name / Description
Application.People	Application.People	Application.People.LastEditedBy = Application.People.PersonID	FK_Application_People_Application_People Foreign key constraint referencing People.PersonID
Application.People.LastEditedBy = Application.People.PersonID Name: FK_Application_People_Application_People Foreign key constraint referencing People.PersonID
Application.People	Application.People	Application.People.LastEditedBy = Application.People.PersonID	FK_Application_People_Application_People Foreign key constraint referencing People.PersonID
Application.People.LastEditedBy = Application.People.PersonID Name: FK_Application_People_Application_People Foreign key constraint referencing People.PersonID
Sales.BuyingGroups	Application.People	Sales.BuyingGroups.LastEditedBy = Application.People.PersonID	FK_Sales_BuyingGroups_Application_People Foreign key constraint referencing People.PersonID
Sales.BuyingGroups.LastEditedBy = Application.People.PersonID Name: FK_Sales_BuyingGroups_Application_People Foreign key constraint referencing People.PersonID
Application.Cities	Application.People	Application.Cities.LastEditedBy = Application.People.PersonID	FK_Application_Cities_Application_People Foreign key constraint referencing People.PersonID
Application.Cities.LastEditedBy = Application.People.PersonID Name: FK_Application_Cities_Application_People Foreign key constraint referencing People.PersonID
Warehouse.Colors	Application.People	Warehouse.Colors.LastEditedBy = Application.People.PersonID	FK_Warehouse_Colors_Application_People Foreign key constraint referencing People.PersonID
Warehouse.Colors.LastEditedBy = Application.People.PersonID Name: FK_Warehouse_Colors_Application_People Foreign key constraint referencing People.PersonID
Application.Countries	Application.People	Application.Countries.LastEditedBy = Application.People.PersonID	FK_Application_Countries_Application_People Foreign key constraint referencing People.PersonID
Application.Countries.LastEditedBy = Application.People.PersonID Name: FK_Application_Countries_Application_People Foreign key constraint referencing People.PersonID
Sales.CustomerCategories	Application.People	Sales.CustomerCategories.LastEditedBy = Application.People.PersonID	FK_Sales_CustomerCategories_Application_People Foreign key constraint referencing People.PersonID
Sales.CustomerCategories.LastEditedBy = Application.People.PersonID Name: FK_Sales_CustomerCategories_Application_People Foreign key constraint referencing People.PersonID
Sales.Customers	Application.People	Sales.Customers.AlternateContactPersonID = Application.People.PersonID	FK_Sales_Customers_AlternateContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Sales.Customers.AlternateContactPersonID = Application.People.PersonID Name: FK_Sales_Customers_AlternateContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Sales.Customers	Application.People	Sales.Customers.LastEditedBy = Application.People.PersonID	FK_Sales_Customers_Application_People Foreign key constraint referencing People.PersonID
Sales.Customers.LastEditedBy = Application.People.PersonID Name: FK_Sales_Customers_Application_People Foreign key constraint referencing People.PersonID
Sales.Customers	Application.People	Sales.Customers.PrimaryContactPersonID = Application.People.PersonID	FK_Sales_Customers_PrimaryContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Sales.Customers.PrimaryContactPersonID = Application.People.PersonID Name: FK_Sales_Customers_PrimaryContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Sales.CustomerTransactions	Application.People	Sales.CustomerTransactions.LastEditedBy = Application.People.PersonID	FK_Sales_CustomerTransactions_Application_People Foreign key constraint referencing People.PersonID
Sales.CustomerTransactions.LastEditedBy = Application.People.PersonID Name: FK_Sales_CustomerTransactions_Application_People Foreign key constraint referencing People.PersonID
Application.DeliveryMethods	Application.People	Application.DeliveryMethods.LastEditedBy = Application.People.PersonID	FK_Application_DeliveryMethods_Application_People Foreign key constraint referencing People.PersonID
Application.DeliveryMethods.LastEditedBy = Application.People.PersonID Name: FK_Application_DeliveryMethods_Application_People Foreign key constraint referencing People.PersonID
Sales.InvoiceLines	Application.People	Sales.InvoiceLines.LastEditedBy = Application.People.PersonID	FK_Sales_InvoiceLines_Application_People Foreign key constraint referencing People.PersonID
Sales.InvoiceLines.LastEditedBy = Application.People.PersonID Name: FK_Sales_InvoiceLines_Application_People Foreign key constraint referencing People.PersonID
Sales.Invoices	Application.People	Sales.Invoices.AccountsPersonID = Application.People.PersonID	FK_Sales_Invoices_AccountsPersonID_Application_People Foreign key constraint referencing People.PersonID
Sales.Invoices.AccountsPersonID = Application.People.PersonID Name: FK_Sales_Invoices_AccountsPersonID_Application_People Foreign key constraint referencing People.PersonID
Sales.Invoices	Application.People	Sales.Invoices.LastEditedBy = Application.People.PersonID	FK_Sales_Invoices_Application_People Foreign key constraint referencing People.PersonID
Sales.Invoices.LastEditedBy = Application.People.PersonID Name: FK_Sales_Invoices_Application_People Foreign key constraint referencing People.PersonID
Sales.Invoices	Application.People	Sales.Invoices.ContactPersonID = Application.People.PersonID	FK_Sales_Invoices_ContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Sales.Invoices.ContactPersonID = Application.People.PersonID Name: FK_Sales_Invoices_ContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Sales.Invoices	Application.People	Sales.Invoices.PackedByPersonID = Application.People.PersonID	FK_Sales_Invoices_PackedByPersonID_Application_People Foreign key constraint referencing People.PersonID
Sales.Invoices.PackedByPersonID = Application.People.PersonID Name: FK_Sales_Invoices_PackedByPersonID_Application_People Foreign key constraint referencing People.PersonID
Sales.Invoices	Application.People	Sales.Invoices.SalespersonPersonID = Application.People.PersonID	FK_Sales_Invoices_SalespersonPersonID_Application_People Foreign key constraint referencing People.PersonID
Sales.Invoices.SalespersonPersonID = Application.People.PersonID Name: FK_Sales_Invoices_SalespersonPersonID_Application_People Foreign key constraint referencing People.PersonID
Sales.OrderLines	Application.People	Sales.OrderLines.LastEditedBy = Application.People.PersonID	FK_Sales_OrderLines_Application_People Foreign key constraint referencing People.PersonID
Sales.OrderLines.LastEditedBy = Application.People.PersonID Name: FK_Sales_OrderLines_Application_People Foreign key constraint referencing People.PersonID
Sales.Orders	Application.People	Sales.Orders.LastEditedBy = Application.People.PersonID	FK_Sales_Orders_Application_People Foreign key constraint referencing People.PersonID
Sales.Orders.LastEditedBy = Application.People.PersonID Name: FK_Sales_Orders_Application_People Foreign key constraint referencing People.PersonID
Sales.Orders	Application.People	Sales.Orders.ContactPersonID = Application.People.PersonID	FK_Sales_Orders_ContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Sales.Orders.ContactPersonID = Application.People.PersonID Name: FK_Sales_Orders_ContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Sales.Orders	Application.People	Sales.Orders.PickedByPersonID = Application.People.PersonID	FK_Sales_Orders_PickedByPersonID_Application_People Foreign key constraint referencing People.PersonID
Sales.Orders.PickedByPersonID = Application.People.PersonID Name: FK_Sales_Orders_PickedByPersonID_Application_People Foreign key constraint referencing People.PersonID
Sales.Orders	Application.People	Sales.Orders.SalespersonPersonID = Application.People.PersonID	FK_Sales_Orders_SalespersonPersonID_Application_People Foreign key constraint referencing People.PersonID
Sales.Orders.SalespersonPersonID = Application.People.PersonID Name: FK_Sales_Orders_SalespersonPersonID_Application_People Foreign key constraint referencing People.PersonID
Warehouse.PackageTypes	Application.People	Warehouse.PackageTypes.LastEditedBy = Application.People.PersonID	FK_Warehouse_PackageTypes_Application_People Foreign key constraint referencing People.PersonID
Warehouse.PackageTypes.LastEditedBy = Application.People.PersonID Name: FK_Warehouse_PackageTypes_Application_People Foreign key constraint referencing People.PersonID
Application.PaymentMethods	Application.People	Application.PaymentMethods.LastEditedBy = Application.People.PersonID	FK_Application_PaymentMethods_Application_People Foreign key constraint referencing People.PersonID
Application.PaymentMethods.LastEditedBy = Application.People.PersonID Name: FK_Application_PaymentMethods_Application_People Foreign key constraint referencing People.PersonID
Purchasing.PurchaseOrderLines	Application.People	Purchasing.PurchaseOrderLines.LastEditedBy = Application.People.PersonID	FK_Purchasing_PurchaseOrderLines_Application_People Foreign key constraint referencing People.PersonID
Purchasing.PurchaseOrderLines.LastEditedBy = Application.People.PersonID Name: FK_Purchasing_PurchaseOrderLines_Application_People Foreign key constraint referencing People.PersonID
Purchasing.PurchaseOrders	Application.People	Purchasing.PurchaseOrders.LastEditedBy = Application.People.PersonID	FK_Purchasing_PurchaseOrders_Application_People Foreign key constraint referencing People.PersonID
Purchasing.PurchaseOrders.LastEditedBy = Application.People.PersonID Name: FK_Purchasing_PurchaseOrders_Application_People Foreign key constraint referencing People.PersonID
Purchasing.PurchaseOrders	Application.People	Purchasing.PurchaseOrders.ContactPersonID = Application.People.PersonID	FK_Purchasing_PurchaseOrders_ContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Purchasing.PurchaseOrders.ContactPersonID = Application.People.PersonID Name: FK_Purchasing_PurchaseOrders_ContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Sales.SpecialDeals	Application.People	Sales.SpecialDeals.LastEditedBy = Application.People.PersonID	FK_Sales_SpecialDeals_Application_People Foreign key constraint referencing People.PersonID
Sales.SpecialDeals.LastEditedBy = Application.People.PersonID Name: FK_Sales_SpecialDeals_Application_People Foreign key constraint referencing People.PersonID
Application.StateProvinces	Application.People	Application.StateProvinces.LastEditedBy = Application.People.PersonID	FK_Application_StateProvinces_Application_People Foreign key constraint referencing People.PersonID
Application.StateProvinces.LastEditedBy = Application.People.PersonID Name: FK_Application_StateProvinces_Application_People Foreign key constraint referencing People.PersonID
Warehouse.StockGroups	Application.People	Warehouse.StockGroups.LastEditedBy = Application.People.PersonID	FK_Warehouse_StockGroups_Application_People Foreign key constraint referencing People.PersonID
Warehouse.StockGroups.LastEditedBy = Application.People.PersonID Name: FK_Warehouse_StockGroups_Application_People Foreign key constraint referencing People.PersonID
Warehouse.StockItemHoldings	Application.People	Warehouse.StockItemHoldings.LastEditedBy = Application.People.PersonID	FK_Warehouse_StockItemHoldings_Application_People Foreign key constraint referencing People.PersonID
Warehouse.StockItemHoldings.LastEditedBy = Application.People.PersonID Name: FK_Warehouse_StockItemHoldings_Application_People Foreign key constraint referencing People.PersonID
Warehouse.StockItems	Application.People	Warehouse.StockItems.LastEditedBy = Application.People.PersonID	FK_Warehouse_StockItems_Application_People Foreign key constraint referencing People.PersonID
Warehouse.StockItems.LastEditedBy = Application.People.PersonID Name: FK_Warehouse_StockItems_Application_People Foreign key constraint referencing People.PersonID
Warehouse.StockItemStockGroups	Application.People	Warehouse.StockItemStockGroups.LastEditedBy = Application.People.PersonID	FK_Warehouse_StockItemStockGroups_Application_People Foreign key constraint referencing People.PersonID
Warehouse.StockItemStockGroups.LastEditedBy = Application.People.PersonID Name: FK_Warehouse_StockItemStockGroups_Application_People Foreign key constraint referencing People.PersonID
Warehouse.StockItemTransactions	Application.People	Warehouse.StockItemTransactions.LastEditedBy = Application.People.PersonID	FK_Warehouse_StockItemTransactions_Application_People Foreign key constraint referencing People.PersonID
Warehouse.StockItemTransactions.LastEditedBy = Application.People.PersonID Name: FK_Warehouse_StockItemTransactions_Application_People Foreign key constraint referencing People.PersonID
Purchasing.SupplierCategories	Application.People	Purchasing.SupplierCategories.LastEditedBy = Application.People.PersonID	FK_Purchasing_SupplierCategories_Application_People Foreign key constraint referencing People.PersonID
Purchasing.SupplierCategories.LastEditedBy = Application.People.PersonID Name: FK_Purchasing_SupplierCategories_Application_People Foreign key constraint referencing People.PersonID
Purchasing.Suppliers	Application.People	Purchasing.Suppliers.AlternateContactPersonID = Application.People.PersonID	FK_Purchasing_Suppliers_AlternateContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Purchasing.Suppliers.AlternateContactPersonID = Application.People.PersonID Name: FK_Purchasing_Suppliers_AlternateContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Purchasing.Suppliers	Application.People	Purchasing.Suppliers.LastEditedBy = Application.People.PersonID	FK_Purchasing_Suppliers_Application_People Foreign key constraint referencing People.PersonID
Purchasing.Suppliers.LastEditedBy = Application.People.PersonID Name: FK_Purchasing_Suppliers_Application_People Foreign key constraint referencing People.PersonID
Purchasing.Suppliers	Application.People	Purchasing.Suppliers.PrimaryContactPersonID = Application.People.PersonID	FK_Purchasing_Suppliers_PrimaryContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Purchasing.Suppliers.PrimaryContactPersonID = Application.People.PersonID Name: FK_Purchasing_Suppliers_PrimaryContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Purchasing.SupplierTransactions	Application.People	Purchasing.SupplierTransactions.LastEditedBy = Application.People.PersonID	FK_Purchasing_SupplierTransactions_Application_People Foreign key constraint referencing People.PersonID
Purchasing.SupplierTransactions.LastEditedBy = Application.People.PersonID Name: FK_Purchasing_SupplierTransactions_Application_People Foreign key constraint referencing People.PersonID
Application.SystemParameters	Application.People	Application.SystemParameters.LastEditedBy = Application.People.PersonID	FK_Application_SystemParameters_Application_People Foreign key constraint referencing People.PersonID
Application.SystemParameters.LastEditedBy = Application.People.PersonID Name: FK_Application_SystemParameters_Application_People Foreign key constraint referencing People.PersonID
Application.TransactionTypes	Application.People	Application.TransactionTypes.LastEditedBy = Application.People.PersonID	FK_Application_TransactionTypes_Application_People Foreign key constraint referencing People.PersonID
Application.TransactionTypes.LastEditedBy = Application.People.PersonID Name: FK_Application_TransactionTypes_Application_People Foreign key constraint referencing People.PersonID

Unique keys

	Key name	Columns	Description
	PK_Application_People	PersonID	Primary key (clustered) constraint.
Primary key (clustered) constraint.

Uses

Name
Application.People
Application.People

Used by

Name
Application.People
Application.Cities
Application.Countries
Application.DeliveryMethods
Application.PaymentMethods
Application.People
Application.StateProvinces
Application.SystemParameters
Application.TransactionTypes
Purchasing.PurchaseOrderLines
Purchasing.PurchaseOrders
Purchasing.PurchaseOrders
Purchasing.SupplierCategories
Purchasing.Suppliers
Purchasing.Suppliers
Purchasing.Suppliers
Purchasing.SupplierTransactions
Sales.BuyingGroups
Sales.CustomerCategories
Sales.Customers
Sales.Customers
Sales.Customers
Sales.CustomerTransactions
Sales.InvoiceLines
Sales.Invoices
Sales.Invoices
Sales.Invoices
Sales.Invoices
Sales.Invoices
Sales.OrderLines
Sales.Orders
Sales.Orders
Sales.Orders
Sales.Orders
Sales.SpecialDeals
Warehouse.Colors
Warehouse.PackageTypes
Warehouse.StockGroups
Warehouse.StockItemHoldings
Warehouse.StockItems
Warehouse.StockItemStockGroups
Warehouse.StockItemTransactions

Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51