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 |
|