Vocabularies — details

DIC_PAL_TAXON

A dictionary of fossil groups. NB 1: This has different design to the first Palaeosaurus version. NB 2: This will need to be replaced eventually with a hierarchical lexicon of fossil taxonomy (of which this table could form the heart).

No. Column name Data type Notes
1 CODE Varchar(20) Primary key
2 DESCRIPTION Varchar(200)  
3 STATUS Char(1)  
4 TRANSLATION Varchar(50)  
5 ORDER_CTRL Numeric(22)  
6 DATE_ENTERED Date  
7 DATE_UPDATED Date  


Sample data (rows 1 to 10 of 74)

CODE DESCRIPTION STATUS TRANSLATION ORDER_CTRL DATE_ENTERED DATE_UPDATED
!  NOT AVAILABLE  C  Not Available  905  28-JUL-03   
?  NOT ENTERED  C  Not Entered  910  28-JUL-03   
BRYOPHYTA  PLANTS: BRYOPHYTA  C  Plants: Bryophyta  265  28-JUL-03   
PTERIDOPHYTA  PLANTS: PTERIDOPHYTA  C  Plants: Pteridophyta  270  28-JUL-03   
LYCOPHYTA  PLANTS: LYCOPHYTA  C  Plants: Lycophyta  275  28-JUL-03   
SPHENOPHYTA  PLANTS: SPHENOPHYTA  C  Plants: Sphenophyta  280  28-JUL-03   
GYMNOSPERM  PLANTS: GYMNOSPERMOPHYTA  C  Plants: Gymnospermophyta  285  28-JUL-03   
ANGIOSPERM  PLANTS: ANGIOSPERMAE  C  Plants: Angiospermae  290  28-JUL-03   
ICHNOTAXA  ICHNOTAXA  C  Ichnotaxa  295  28-JUL-03   
NON BIOL  NON BIOLOGICAL  C  Non biological  300  28-JUL-03