Fish: Dynamic searches of families and species

A. Database structure

1. Table omorphol (2906 records)

TAXON-- VARCHAR2(100) NOT NULL,
CHORDER-- NUMBER(20),
CHNAME-- VARCHAR2(50),
CHSTATE-- VARCHAR2(255)

2. Table oimage (141 records)

ILLUSNO-- VARCHAR2(20) NOT NULL,
TAXON-- VARCHAR2(100) NOT NULL,
ILLUSFILE-- VARCHAR2(35),
BIGILLUS-- VARCHAR2(35)
TBILLUS-- VARCHAR2(35)
ILLUSTYPE-- VARCHAR2(35),
ILLVIEW-- VARCHAR2(35),
SCVALUE-- NUMBER(20),
SCUNITS-- VARCHAR2(10),
NMSPECIM-- VARCHAR2(20),
TYPSTATUS-- VARCHAR2(20),
SAMPLNO-- VARCHAR2(20) NOT NULL

3. Table olocat (71 records)

SAMPLNO-- VARCHAR2(20) NOT NULL,
STRATUNIT-- VARCHAR2(50),
STRATID-- NUMBER(20),
STRATABBR-- VARCHAR2(20),
SEPOCHBOT-- VARCHAR2(20),
EPOCHBOT-- VARCHAR2(50),
ICABOT -- NUMBER(20),
SEPOCHTOP-- VARCHAR2(20),
EPOCHTOP-- VARCHAR2(50),
ICATOP-- NUMBER(20),
ICAUNIT-- VARCHAR2(10),
LOCALITY-- VARCHAR2(50),
CNTRY-- VARCHAR2(50),
REGION-- VARCHAR2(50)

4. Table ogenus (104 records)

GENUSNAME-- VARCHAR2(100) NOT NULL,
GAUTHOR-- VARCHAR2(100),
GYEAR-- NMUBER(10),
GORDER-- NUMBER(20),
GWEBPAGE-- VARCHAR2(35),
FAMILYNM-- VARCHAR2(100),
FWEBPAGE-- VARCHAR2(35)

5. Table ospecies (137 recrods)

TAXON-- VARCHAR2(100) NOT NULL,
PAGETITL-- VARCHAR2(100) NOT NULL,
GENUSNAME-- VARCHAR2(100) NOT NULL,
SPECIESNM-- VARCHAR2(100),
SORDER-- NUMBER(20),
SWEBPAGE-- VARCHAR2(35),
ORGENUS-- NUMBER(20),
ORGENUSNM-- VARCHAR2(100),
SAUTHOR-- VARCHAR2(100) NOT NULL,
SYEAR-- VARCHAR2(10),
HOLOREPO-- VARCHAR2(35),
HOLOCAT-- VARCHAR2(35),
TYPLOC-- VARCHAR2(20),
TYPSTRAT-- VARCHAR2(50)

B. SQL code for dynamic searches

Last updated on April 29, 2000-afb.