Databases > WideWorldImporters > Tables > Application.SystemParameters

WideWorldImporters

Application.SystemParameters

//
Any configurable parameters for the whole system

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    SystemParameterID
    [int] NOT NULL DEFAULT (NEXT VALUE FOR [Sequences].[SystemParameterID])
  • //
    ${escapify(column.description)}
    DeliveryAddressLine1
    [nvarchar](60) NOT NULL
  • //
    ${escapify(column.description)}
    DeliveryAddressLine2
    [nvarchar](60) NULL
  • //
    ${escapify(column.description)}
    DeliveryCityID
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    DeliveryPostalCode
    [nvarchar](10) NOT NULL
  • //
    ${escapify(column.description)}
    DeliveryLocation
    [geography] NOT NULL
  • //
    ${escapify(column.description)}
    PostalAddressLine1
    [nvarchar](60) NOT NULL
  • //
    ${escapify(column.description)}
    PostalAddressLine2
    [nvarchar](60) NULL
  • //
    ${escapify(column.description)}
    PostalCityID
    [int] NOT NULL
  • //
    ${escapify(column.description)}
    PostalPostalCode
    [nvarchar](10) NOT NULL
  • //
    ${escapify(column.description)}
    ApplicationSettings
    [nvarchar](MAX) NOT NULL
  • LastEditedBy
    [int] NOT NULL
  • LastEditedWhen
    [datetime2](8) NOT NULL DEFAULT (sysdatetime())

Indexes

  • PK_Application_SystemParameters
    UNIQUE CLUSTERED
    SystemParameterID
  • //
    Auto-created to support a foreign key
    FK_Application_SystemParameters_DeliveryCityID
    NONCLUSTERED
    DeliveryCityID
  • //
    Auto-created to support a foreign key
    FK_Application_SystemParameters_PostalCityID
    NONCLUSTERED
    PostalCityID

Foreign Keys

  • FK_Application_SystemParameters_Application_People
    Application.People
    LastEditedBy ⥱ PersonID
  • FK_Application_SystemParameters_DeliveryCityID_Application_Cities
    Application.Cities
    DeliveryCityID ⥱ CityID
  • FK_Application_SystemParameters_PostalCityID_Application_Cities
    Application.Cities
    PostalCityID ⥱ CityID

Sample Data

SystemParameterID
DeliveryAddressLine1
DeliveryAddressLine2
DeliveryCityID
DeliveryPostalCode
DeliveryLocation
PostalAddressLine1
PostalAddressLine2
PostalCityID
PostalPostalCode
ApplicationSettings
LastEditedBy
LastEditedWhen
1
Suite 14
1968 Martin Luther King Junior Drive
30378
94129
[geography]
PO Box 201158
Golden Gate Park
30378
94129
{ "Site": { "SEO": { "Title": "WWI | Site", "Description": "Wide World Importers - Site", "StockItemTitleTemplate": "WWI | Site | StockItem {0}", "StockItemDescrTemplate": "StockItem {0} ({1}})" }, "Menu": { "Home": { "Url": "/", "Alt": "Home" }, "StockItems": { "Url": "/stockitem", "Alt": "Stock item search" }, "Brands": { "Url": "/brand", "Alt": "Supplier listing" }, "Contact": { "Url": "/contact-us", "Alt": "Contact", "email": "jane@wideworldimporters.com" } }, "CSSTheme": "bootstrap-stockitems", "Home": { "Message": "New StockItems from Wide World Importers", "PromoCategories": ["Gadgets", "Toys"], "PromoCount": 5, "NewStockItemsCount": 5, "HotStockItemsCount": 5 }, "SearchResults": { "SeoTitleTemplate": "WWI | Site | {0} | {1}", "SeoDescrTemplate": "Wide World Importers | Stock Items {0} ({1}})", "FacetCount": 3 } }, "Customer": { "SEO": { "Title": "WWI | Customer Portal", "Description": "Wide World Importers - Customer Site", "StockItemTitleTemplate": "WWI | CustomerPortal | StockItem {0}" }, "CSSTheme": "bootstrap-admin", "Dashboard": { "PromoCategories": "", "PromoCount": 5, "NewStockItemsCount": 5 } }, "Supplier": { "SEO": { "Title": "WWI | Supplier Portal" }, "CSSTheme": "bootstrap-admin", "Dashboard": { "StockItemsPerPage": 10, "QuotesPerPage": 25 }, "Reports": { "TopSales": true, "ThisMonthSale": true } }, "Warehouse": { "SEO": { "Title": "WWI | Warehouse Administration", "Description": "WorldWideImporters - Site", "StockItemTitleTemplate": "WWI | Site | StockItem {0}" }, "CSSTheme": "bootstrap-admin" }, "Logging": { "configuration": { "status": "error", "name": "RoutingTest", "packages": "org.apache.logging.log4j.test", "properties": { "property": { "name": "filename", "value": "target/rolling1/rollingtest-$${sd:type}.log" } }, "ThresholdFilter": { "level": "debug" }, "appenders": { "Console": { "name": "STDOUT", "PatternLayout": { "pattern": "%m%n" } }, "List": { "name": "List", "ThresholdFilter": { "level": "debug" } }, "Routing": { "name": "Routing", "Routes": { "pattern": "$${sd:type}", "Route": [{ "RollingFile": { "name": "Rolling-${sd:type}", "fileName": "${filename}", "filePattern": "target/rolling1/test1-${sd:type}.%i.log.gz", "PatternLayout": { "pattern": "%d %p %c{1.} [%t] %m%n" }, "SizeBasedTriggeringPolicy": { "size": "500" } } }, { "AppenderRef": "STDOUT", "key": "Audit" }, { "AppenderRef": "List", "key": "Service" }] } } }, "loggers": { "logger": { "name": "EventLogger", "level": "info", "additivity": "false", "AppenderRef": { "ref": "Routing" } }, "root": { "level": "error", "AppenderRef": { "ref": "STDOUT" } } } } } }
1