DIC_GRAIN_SHAPE_5930
A dictionary of grain shape using the BS5930 shape scheme.
| No. |
Column name |
Data type |
Notes |
| 1 |
CODE |
Varchar(5) |
Primary key
|
| 2 |
DESCRIPTION |
Varchar(30) |
|
| 3 |
STATUS |
Char(1) |
|
| 4 |
TRANSLATION |
Varchar(30) |
|
| 5 |
ORDER_CTRL |
Numeric(22) |
|
| 6 |
DATE_ENTERED |
Date |
|
| 7 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 11 of 11)
| CODE |
DESCRIPTION |
STATUS |
TRANSLATION |
ORDER_CTRL |
DATE_ENTERED |
DATE_UPDATED |
| AN |
ANGULAR |
C |
BS5930 Angular |
5 |
04-JUN-03 |
|
| ANS |
SUBANGULAR |
C |
BS5930 Subangular |
10 |
04-JUN-03 |
|
| RNS |
SUBROUNDED |
C |
BS5930 Subrounded |
15 |
04-JUN-03 |
|
| RN |
ROUNDED |
C |
BS5930 Rounded |
20 |
04-JUN-03 |
|
| FL |
FLAT OR TABULATE |
C |
BS5930 Flat or Tabulate |
25 |
04-JUN-03 |
|
| EL |
ELONGATE |
C |
BS5930 Elongate |
30 |
04-JUN-03 |
|
| RT |
ROUGH SURFACE TEXTURE |
C |
BS5930 Rough Surface Texture |
35 |
04-JUN-03 |
|
| ST |
SMOOTH SURFACE TEXTURE |
C |
BS5930 Smooth Surface Texture |
40 |
04-JUN-03 |
|
| * |
NOT APPLICABLE |
C |
Not Applicable |
900 |
04-JUN-03 |
|
| ! |
NOT AVAILABLE |
C |
Not Available |
905 |
04-JUN-03 |
|
| ? |
NOT ENTERED |
C |
Not Entered |
910 |
04-JUN-03 |
|
