Zooxanthellate corals:
Dynamic searches of genera and species within the family Faviidae

A. Database structure

1. Table species (33 records)

SPECIESID-- NUMBER(10) NOT NULL,
SPORDER-- NUMBER(10) NOT NULL,
GENUSNAME-- VARCHAR2(100) NOT NULL,
SPECIESNAME-- VARCHAR2(100) NOT NULL,
SPWEBPAGE-- VARCHAR2(35) NOT NULL,
ORIGGENUS-- NUMBER(5) NOT NULL,
ORIGGENUSNM-- VARCHAR2(100) NOT NULL,
SPECIESAUTHORNM-- VARCHAR2(100) NOT NULL,
SPECIESYEARAU-- VARCHAR2(5) NOT NULL,
SPECIESRESNO-- VARCHAR2(25),
HOLOREPOSABBR-- VARCHAR2(10) NOT NULL,
HOLOMUSCATNO-- VARCHAR2(25),
TYPLOCNO-- VARCHAR2(25),
STRATUNITNAME-- VARCHAR2(50),
TNILLUS-- VARCHAR2(100),
PAGETITLE-- VARCHAR2(100)

2. Table distrib (391 records)

DISTRIBID-- NUMBER(10) NOT NULL,
GENUSNAME-- VARCHAR2(100) NOT NULL,
SPECIESNAME-- VARCHAR2(100) NOT NULL,
STRATUNITNAME-- VARCHAR2(50) NOT NULL

3. Table genmorph (84 records)

GENMORPHID-- NUMBER(10) NOT NULL,
GENUSNAME-- VARCHAR2(100) NOT NULL,
GENCHARGRP-- VARCHAR2(35) NOT NULL,
GENMORCHARABBR-- VARCHAR2(10) NOT NULL,
GENMORCHARNAME-- VARCHAR2(35) NOT NULL,
GENMORWEBPAGE-- VARCHAR2(15),
GENCHARSTATE-- VARCHAR2(35) NOT NULL

4. Table genus (7 records)

GENUSID-- NUMBER(10) NOT NULL,
GENWEBPAGE-- VARCHAR2(35) NOT NULL,
FAMILY-- VARCHAR2(100) NOT NULL,
GENORDER-- NUMBER(10) NOT NULL,
GENUSNAME-- VARCHAR2(100) NOT NULL,
GENAUTHORNM-- VARCHAR2(100) NOT NULL,
GENYEARAUTH-- VARCHAR2(5) NOT NULL,
TYSPGENUS-- VARCHAR2(100) NOT NULL,
TYSPSPECIES-- VARCHAR2(100) NOT NULL,
TYSPAUTHORNM-- VARCHAR2(100) NOT NULL,
TYSPYEAR-- VARCHAR2(5) NOT NULL

5. Table image (129 records)

IMAGEID-- NUMBER(10) NOT NULL,
ILLUSORDER-- NUMBER(10) NOT NULL,
ILLUSFILE-- VARCHAR2(35) NOT NULL,
GENUSNAME-- VARCHAR2(100) NOT NULL,
SPECIESNAME-- VARCHAR2(100) NOT NULL,
ILLUSTYPE-- VARCHAR2(35) NOT NULL,
ILLUSVIEW-- VARCHAR2(35),
SCALEVALUE-- NUMBER(10),
SCALEUNITS-- VARCHAR2(10),
CITEDAUTHORNM-- VARCHAR2(100),
CITEDYEARAU-- VARCHAR2(5),
CITEDPLATENO-- VARCHAR2(35),
REPOSABBR-- VARCHAR2(10),
MUSCATNO-- VARCHAR2(25),
TYPSTATUS-- VARCHAR2(50),
COLLEVSAMNO-- VARCHAR2(25),
STRATUNITNAME-- VARCHAR2(50)

6. Table location (159 records)

LOCATIONID-- NUMBER(10) NOT NULL,
STRATUNITNO-- NUMBER(10) NOT NULL,
STRATUNITNAME-- VARCHAR2(50) NOT NULL,
STRATUNITABBR-- VARCHAR2(10) NOT NULL,
FORMATIONNAME-- VARCHAR2(50) NOT NULL,
SUBEPOCHNAMEBOTTOM-- VARCHAR2(35) NOT NULL,
EPOCHNAMEBOTTOM-- VARCHAR2(35) NOT NULL,
ICABOTTOM-- NUMBER(10) NOT NULL,
SUBEPOCHNAMETOP-- VARCHAR2(35) NOT NULL,
EPOCHNAMETOP-- VARCHAR2(35) NOT NULL,
ICATOP-- NUMBER(10) NOT NULL,
ICAUNITS-- VARCHAR2(10) NOT NULL,
LOCALITYNAME-- VARCHAR2(50) NOT NULL,
COUNTRYNAME-- VARCHAR2(50) NOT NULL,
REGION-- VARCHAR2(35) NOT NULL

7. Table morphol (743 records)

MORPHOLID-- NUMBER(10) NOT NULL,
GENUSNAME-- VARCHAR2(100) NOT NULL,
SPECIESNAME-- VARCHAR2(100) NOT NULL,
INIORDER-- NUMBER(10) NOT NULL,
CHARGRP-- VARCHAR2(35) NOT NULL,
MORPHCHARABBR-- VARCHAR2(10) NOT NULL,
DIAGNOSTIC-- NUMBER(5) NOT NULL,
MORPHCHARNAME-- VARCHAR2(35) NOT NULL,
MORWEBPAGE-- VARCHAR2(35) NOT NULL,
CHARSTATENAME-- VARCHAR2(35) NOT NULL,
CHARSTATECODE-- VARCHAR2(10) NOT NULL

8. Table stratord (66 records)

STRATORDID-- NUMBER(10) NOT NULL,
SUBEPOCHNAMEBOTTOM-- VARCHAR2(35) NOT NULL,
EPOCHNAMEBOTTOM-- VARCHAR2(35) NOT NULL,
SUBEPOCHNAMETOP-- VARCHAR2(35) NOT NULL,
EPOCHNAMETOP-- VARCHAR2(35) NOT NULL,
STRORDER-- NUMBER(10) NOT NULL

9. Table sygenus (2 records)

SYGENUSID-- NUMBER(10) NOT NULL,
GENUSNAME-- VARCHAR2(100) NOT NULL,
SYGENUSNAME-- VARCHAR2(100) NOT NULL,
SYGENUSAUTHORNM-- VARCHAR2(100) NOT NULL,
SYGENUSYEARAU-- VARCHAR2(5)

10. Table syspecies (5 records)

SYSPECIESID-- NUMBER(10) NOT NULL,
GENUSNAME-- VARCHAR2(100) NOT NULL,
SPECIESNAME-- VARCHAR2(100) NOT NULL,
SYGENNAME-- VARCHAR2(100) NOT NULL,
SYSPECIESNAME-- VARCHAR2(100) NOT NULL,
SYSPECIESAUTHORNM-- VARCHAR2(100) NOT NULL,
SYSPECIESYEARAU-- VARCHAR2(5) NOT NULL

B. SQL code for dynamic searches of the Family Faviidae

Last updated on April 29, 2000-afb.