Vocabularies — details

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 10 of 11)

CODE DESCRIPTION STATUS TRANSLATION ORDER_CTRL DATE_ENTERED DATE_UPDATED
AN  ANGULAR  BS5930 Angular  04-JUN-03   
ANS  SUBANGULAR  BS5930 Subangular  10  04-JUN-03   
RNS  SUBROUNDED  BS5930 Subrounded  15  04-JUN-03   
RN  ROUNDED  BS5930 Rounded  20  04-JUN-03   
FL  FLAT OR TABULATE  BS5930 Flat or Tabulate  25  04-JUN-03   
EL  ELONGATE  BS5930 Elongate  30  04-JUN-03   
RT  ROUGH SURFACE TEXTURE  BS5930 Rough Surface Texture  35  04-JUN-03   
ST  SMOOTH SURFACE TEXTURE  BS5930 Smooth Surface Texture  40  04-JUN-03   
NOT APPLICABLE  Not Applicable  900  04-JUN-03   
NOT AVAILABLE  Not Available  905  04-JUN-03