DIC_BGS_FULL_COLOUR
A dictionary of BGS standard full colour descriptors such as [Red, Pinkish, Light], [Blue, Purplish, Dark] etc. Each description is broken down into 3 fields: Base Colour (eg Red), Colour Qualifier (eg Pinkish), and Shade (eg Light). Each colour must have a Munsell full code associated with it and this is termed the `Median` munsell code since it points to a `median` where a BGS colour can cover many Munsell definitions.
| No. |
Column name |
Data type |
Notes |
| 1 |
BASE_COLOUR_CODE |
Varchar(2) |
Primary key
|
| 2 |
COL_QUALIFIER_CODE |
Varchar(2) |
|
| 3 |
SHADE_CODE |
Char(1) |
|
| 4 |
MEDIAN_MUNSELL_HUE_CODE |
Numeric(22) |
|
| 5 |
MEDIAN_MUNSELL_BASE_COL_CODE |
Varchar(2) |
|
| 6 |
MEDIAN_MUNSELL_VALUE_CODE |
Numeric(22) |
|
| 7 |
MEDIAN_MUNSELL_CHROMA_CODE |
Numeric(22) |
|
| 8 |
STATUS |
Char(1) |
|
| 9 |
DATE_ENTERED |
Date |
|
| 10 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 20 of 121)
| BASE_COLOUR_CODE |
COL_QUALIFIER_CODE |
SHADE_CODE |
MEDIAN_MUNSELL_HUE_CODE |
MEDIAN_MUNSELL_BASE_COL_CODE |
MEDIAN_MUNSELL_VALUE_CODE |
MEDIAN_MUNSELL_CHROMA_CODE |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
| OR |
. |
D |
10 |
YR |
5 |
8 |
C |
18-OCT-01 |
|
| OR |
. |
L |
10 |
YR |
8 |
6 |
C |
18-OCT-01 |
|
| GY |
OL |
M |
5 |
Y |
5 |
2 |
C |
18-OCT-01 |
|
| GY |
OR |
L |
5 |
YR |
7 |
1 |
C |
18-OCT-01 |
|
| GY |
PK |
L |
5 |
YR |
6 |
2 |
C |
18-OCT-01 |
|
| GY |
RE |
D |
10 |
R |
4 |
1 |
C |
18-OCT-01 |
|
| GY |
RE |
L |
2.5 |
YR |
7 |
1 |
C |
18-OCT-01 |
|
| GY |
RE |
M |
10 |
R |
6 |
1 |
C |
18-OCT-01 |
|
| GY |
YE |
L |
5 |
Y |
7 |
2 |
C |
18-OCT-01 |
|
| OL |
. |
D |
5 |
Y |
4 |
3 |
C |
18-OCT-01 |
|
| OL |
. |
L |
10 |
Y |
5 |
4 |
C |
18-OCT-01 |
|
| OL |
. |
M |
5 |
Y |
5 |
4 |
C |
18-OCT-01 |
|
| BK |
. |
. |
0 |
N |
0 |
0 |
C |
18-OCT-01 |
|
| BK |
BL |
. |
10 |
B |
2.5 |
1 |
C |
18-OCT-01 |
|
| BK |
BR |
. |
5 |
YR |
2 |
1 |
C |
18-OCT-01 |
|
| BK |
GR |
. |
10 |
G |
2.5 |
1 |
C |
18-OCT-01 |
|
| BK |
OL |
. |
5 |
Y |
2 |
1 |
C |
18-OCT-01 |
|
| BK |
RE |
. |
10 |
R |
2.5 |
1 |
C |
18-OCT-01 |
|
| BL |
. |
L |
5 |
B |
7 |
6 |
C |
18-OCT-01 |
|
| BL |
. |
M |
5 |
B |
5 |
6 |
C |
18-OCT-01 |
|
