Application.SystemParameters - WideWorldImporters

WideWorldImporters

- WideWorldImporters

Documentation	WideWorldImporters
Schema	Application
Name	SystemParameters
Module	Application

Any configurable parameters for the whole system.

Contains system-wide configurable parameters.

Columns

		Name	Data type	Attributes	References	Description
	1	SystemParameterID	int	Default: NEXT VALUE FOR [Sequences].[SystemParameterID]		Numeric ID used for row holding system parameters
Numeric ID used for row holding system parameters Default: NEXT VALUE FOR [Sequences].[SystemParameterID]
	2	DeliveryAddressLine1	nvarchar(60)			First address line for the company
First address line for the company
	3	DeliveryAddressLine2	nvarchar(60)			Second address line for the company
Second address line for the company
	4	DeliveryCityID	int		Application.Cities	ID of the city for this address
ID of the city for this address References: Application.Cities
	5	DeliveryPostalCode	nvarchar(10)			Postal code for the company
Postal code for the company
	6	DeliveryLocation	geography			Geographic location for the company office
Geographic location for the company office
	7	PostalAddressLine1	nvarchar(60)			First postal address line for the company
First postal address line for the company
	8	PostalAddressLine2	nvarchar(60)			Second postaladdress line for the company
Second postaladdress line for the company
	9	PostalCityID	int		Application.Cities	ID of the city for this postaladdress
ID of the city for this postaladdress References: Application.Cities
	10	PostalPostalCode	nvarchar(10)			Postal code for the company when sending via mail
Postal code for the company when sending via mail
	11	ApplicationSettings	nvarchar(MAX)			JSON-structured application settings
JSON-structured application settings
	12	LastEditedBy	int		Application.People
References: Application.People
	13	LastEditedWhen	datetime2(7)	Default: sysdatetime()		When this row was last edited
When this row was last edited Default: sysdatetime()

Relations

Foreign table	Primary table	Join	Title / Name / Description
Application.SystemParameters	Application.Cities	Application.SystemParameters.DeliveryCityID = Application.Cities.CityID	FK_Application_SystemParameters_DeliveryCityID_Application_Cities Foreign key constraint referencing Cities.CityID
Application.SystemParameters.DeliveryCityID = Application.Cities.CityID Name: FK_Application_SystemParameters_DeliveryCityID_Application_Cities Foreign key constraint referencing Cities.CityID
Application.SystemParameters	Application.Cities	Application.SystemParameters.PostalCityID = Application.Cities.CityID	FK_Application_SystemParameters_PostalCityID_Application_Cities Foreign key constraint referencing Cities.CityID
Application.SystemParameters.PostalCityID = Application.Cities.CityID Name: FK_Application_SystemParameters_PostalCityID_Application_Cities Foreign key constraint referencing Cities.CityID
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

Unique keys

	Key name	Columns	Description
	PK_Application_SystemParameters	SystemParameterID	Primary key (clustered) constraint.
Primary key (clustered) constraint.

Uses

Name
Application.SystemParameters
Application.Cities
Application.Cities
Application.People

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