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 20 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   
ARTEFACT  ARTEFACT  C  Artefact  305  28-JUL-03   
*  NOT APPLICABLE  C  Not Applicable  900  28-JUL-03   
NOT KNOWN  NOT KNOWN  C  Not known  5  28-JUL-03   
SHELL  UNKNOWN SHELLS  C  Unknown shells  10  28-JUL-03   
MONERA  MONERA (BLUE-GREEN ALGAE, BACTERIA)  C  Monera (blue-green algae, bacteria)  15  28-JUL-03   
FUNGI  FUNGI  C  Fungi  20  28-JUL-03   
ALGAE  ALGAE  C  Algae  25  28-JUL-03   
PORIFERA  PORIFERA (SPONGES)  C  Porifera (sponges)  30  28-JUL-03   
COELENTERATA  COELENTERATA (SEA ANEMONES, JELLYFISH, CORALS)  C  Coelenterata (sea anemones, jellyfish, corals)  35  28-JUL-03   
ARCHAEOCYATHID  ARCHAEOCYATHA  C  Archaeocyatha  40  28-JUL-03