Generated using SQL Data Dictionary demo version.


Table Application.SystemParameters (1 row)


Any configurable parameters for the whole system


  Column Data Type Identity Nullable Default
PK SystemParameterID int NEXT VALUE FOR [Sequences].[SystemParameterID]
Numeric ID used for row holding system parameters
DeliveryAddressLine1 nvarchar(60)
First address line for the company
DeliveryAddressLine2 nvarchar(60) X
Second address line for the company
FK DeliveryCityID int
ID of the city for this address
DeliveryPostalCode nvarchar(10)
Postal code for the company
DeliveryLocation geography
Geographic location for the company office
PostalAddressLine1 nvarchar(60)
First postal address line for the company
PostalAddressLine2 nvarchar(60) X
Second postaladdress line for the company
FK PostalCityID int
ID of the city for this postaladdress
PostalPostalCode nvarchar(10)
Postal code for the company when sending via mail
ApplicationSettings nvarchar(max)
JSON-structured application settings
FK LastEditedBy int
LastEditedWhen datetime2 sysdatetime()

Indexes:


References: