Vocabularies — details

DIC_COLOUR_QUALIFIER

A dictionary of qualifiers as applied to Base colours eg Reddish. The codes used here must be the same as their equivalents in Base Colour dictionary ie Red and Reddish; Blue and Bluish are same in code form in both tables.

No. Column name Data type Notes
1 COL_QUALIFIER_CODE Varchar(2) Primary key
2 COL_QUALIFIER_DESCRIPTION Varchar(25)  
3 STATUS Char(1)  
4 DATE_ENTERED Date  
5 DATE_UPDATED Date  


Sample data (rows 1 to 10 of 12)

COL_QUALIFIER_CODE COL_QUALIFIER_DESCRIPTION STATUS DATE_ENTERED DATE_UPDATED
NA  18-OCT-01   
BK  BLACKISH  18-OCT-01   
BL  BLUISH  18-OCT-01   
BR  BROWNISH  18-OCT-01   
GR  GREENISH  18-OCT-01   
GY  GREYISH  18-OCT-01   
OL  OLIVE  18-OCT-01   
OR  ORANGEISH  18-OCT-01   
PK  PINKISH  18-OCT-01   
PU  PURPLISH  18-OCT-01