Home > Technical > Table Definitions > VALIDDESC2

VALIDDESC2

Records various descriptions such as item brand, item size, and so on for an item. These can be used to validate brand/size entries when an item is added/edited. It supercedes VALIDDESC

Column Type Description
STRLANGUAGECODE VARCHAR(10) The language code for which this description is valid. This allows us to set up valid descriptions for English and German, for example. The primary language descriptions are always stored wit ha '*'

STRTYPE

VARCHAR(1)

Indicates the type of data to be validated.

B  

Brandname

C

Seasons

S  

Size

M

Media types, for example NEWSPAPER, RADIO, and so on.

F

Fit

STRDESCRIPTION

VARCHAR(30)

A unique description. This is unique within strLanguageCode and strType.

STRIMAGENAME

VARCHAR(100)

The name of an image associated with this description.

INTORDER

INT

The sequence in which the size should be displayed. If you looking at sizes of mens clothing which is XS,S,M,L,XL, alphabetical sorting would not be sufficient.
 

Primary Key: STRLANGUAGECODE + STRTYPE + STRDESCRIPTION

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)