Entity Definition

Logical Name : ColorPalette
Physical Name : CO_PLTE_CLR

A grouping of similar colors used to classify merchandise for analysis. e.g. Earth Tones, Space Colors, Spring Greens

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ColorPaletteID (PK) A unique retailer assigned identifier for the ColorPalette. ID_PLTE_CLR Identity integer
ColorPaletteName A short descriptive name for the ColorPalette e.g. Earth Tones, Space Colors, Spring Greens NM_PLTE_CLR Name varchar(40)
ColorPaletteDescription A short narrative description for the ColorPalette. DE_PLTE_CLR DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
ColorPalette is used by StyleColorPalette
ColorPalette defines MerchandiseHierarchyGroupColorPalette
ColorPalette categorizes Color

Logical Views containing ColorPalette

Logical View
Logical 01010 - Item Description - Subtype View
Logical 01015 - Item Description - Apparel View