Bivalve molluscs: Dynamic search of genera/subgenera

A. Database structure

1. Table bivlocat (3255 records)

PPPNUMBER-- NUMBER(20) NOT NULL,
GEOLAGE-- VARCHAR2(50),
STRATDES-- VARCHAR2(35),
YNGMA-- NUMBER(20),
OLDMA-- NUMBER(20),
STRATMEMBER-- VARCHAR2(50),
FORMATION-- VARCHAR2(50),
STRATGROUP-- VARCHAR2(50),
LOCALITY-- VARCHAR2(50),
REGION-- VARCHAR2(50),
CNTRY-- VARCHAR2(50) NOT NULL

2. Table bivdistr (3185 records)

PPPNUMBER-- NUMBER(20) NOT NULL,
GENUSNAME-- VARCHAR2(100) NOT NULL,
SBGNNAME-- VARCHAR2(100) NOT NULL

3. Table bivimage (501 records)

ILLUSID-- NUMBER(20) NOT NULL,
ILLUSROLLNO-- VARCHAR2(10),
ILLUSFILE-- VARCHAR2(35) NOT NULL,
BIGILLUS-- VARCHAR2(35),
GENUSNAME-- VARCHAR2(100) NOT NULL,
SBGNNAME-- VARCHAR2(100) NOT NULL,
SUBGENUSNAME-- VARCHAR2(100),
SPECIESNAME-- VARCHAR2(100),
VALVE-- VARCHAR2(35) NOT NULL,
ILLVIEW-- VARCHAR2(35) NOT NULL,
NMITAIDNO-- NUMBER(10) NOT NULL,
NMBLOC-- NUMBER(10) NOT NULL

4. Table bivoccur (721 records)

NMBLOC-- NUMBER(20) NOT NULL,
PPPNUMBER-- NUMBER(20) NOT NULL

5. Table bivsbgen (169 records)

PAGETITLE-- VARCHAR2(100),
GENUSNAME-- VARCHAR2(100) NOT NULL,
SBGNNAME-- VARCHAR2(100) NOT NULL,
WEBPAGE-- VARCHAR2(35) NOT NULL

B. SQL code for dynamic search

Last updated on April 29, 2000-afb.