Vocabularies — details

DIC_GRAIN_SHAPE

A dictionary of grain shapes.

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 13 of 13)

CODE DESCRIPTION STATUS TRANSLATION ORDER_CTRL DATE_ENTERED DATE_UPDATED
ANV  VERY ANGULAR  Very Angular  10  28-JUL-03   
AN  ANGULAR  Angular  20  28-JUL-03   
ANS  SUBANGULAR  Subangular  30  28-JUL-03   
RNS  SUBROUNDED  Subrounded  40  28-JUL-03   
RN  ROUNDED  Rounded  50  28-JUL-03   
RNW  WELL-ROUNDED  Well-Rounded  60  28-JUL-03   
FL  FLAT OR TABULATE  Flat or Tabulate  70  28-JUL-03   
EL  ELONGATE  Elongate  80  28-JUL-03   
RT  ROUGH SURFACE TEXTURE  Rough Surface Texture  90  28-JUL-03   
ST  SMOOTH SURFACE TEXTURE  Smooth Surface Texture  100  28-JUL-03   
NOT APPLICABLE  Not Applicable  900  28-JUL-03   
NOT AVAILABLE  Not Available  905  28-JUL-03   
NOT ENTERED  Not Entered  910  28-JUL-03