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 12 of 12)
| COL_QUALIFIER_CODE |
COL_QUALIFIER_DESCRIPTION |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
| . |
NA |
C |
18-OCT-01 |
|
| BK |
BLACKISH |
C |
18-OCT-01 |
|
| BL |
BLUISH |
C |
18-OCT-01 |
|
| BR |
BROWNISH |
C |
18-OCT-01 |
|
| GR |
GREENISH |
C |
18-OCT-01 |
|
| GY |
GREYISH |
C |
18-OCT-01 |
|
| OL |
OLIVE |
C |
18-OCT-01 |
|
| OR |
ORANGEISH |
C |
18-OCT-01 |
|
| PK |
PINKISH |
C |
18-OCT-01 |
|
| PU |
PURPLISH |
C |
18-OCT-01 |
|
| RE |
REDDISH |
C |
18-OCT-01 |
|
| YE |
YELLOWISH |
C |
18-OCT-01 |
|
