dbo.dictionary - Products

Box Inc - Enterprise Data Catalog

Documentation	Products
Schema	dbo
Name	dictionary
Module	Products

Generic dicitonary (list of values for dropdowns) table.

Holds following dictionaries:

CONUNTRY - list of countries
COLOR - product colors
CUR - currencies

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		dictionary_val_id	int		Identity		Row ID
Row ID Identity
	2		val	nvarchar(50)				Value unique code (unique per dictionary)
Value unique code (unique per dictionary)
	3		dictionary	nvarchar(50)				Dictionary code (e.g. COUNTRY)
Dictionary code (e.g. COUNTRY)
	4		label	nvarchar(50)				Value label
Value label

Relations

Foreign table		Primary table	Join	Title / Name / Description
dbo.prices		dbo.dictionary	dbo.prices.currency = dbo.dictionary.val	User-defined relation Where dictionary = 'CUR'
dbo.prices.currency = dbo.dictionary.val Name: User-defined relation Where dictionary = 'CUR'
dbo.products		dbo.dictionary	dbo.products.color = dbo.dictionary.val	Color User-defined relation Where dictionary = 'COLOR'
dbo.products.color = dbo.dictionary.val Title: Color Name: User-defined relation Where dictionary = 'COLOR'

Unique keys

	Key name	Columns	Description
	PK_dictionary	dictionary_val_id

	IX_dictionary	val

Used by

Name
dbo.dictionary
dbo.prices
dbo.products (Color)

Exported: 2019-02-04 23:17, Last imported: 2018-04-10 17:07