THE GEIGER DATABASE


DATA TABLE STRUCTURES

DATABASE JGDB10 Tables

Database JGDB10 contains 31 tables with a total of 34,435 records, and forms the basis of the redacted version served through this website. The descriptions presented here reflect the database as structured by John Geiger at the time of his death in 2011. Table names are shown as originally created by Geiger. For security reasons, the final version of the database served through the website does not use the same table names or column labels.

TABLE INVENTORY

Table: AuthorLineItems

The structure of this table was designed to record relationships between the name of an individual held responsible for the creation of a specific drawings for a Frank Lloyd Wright design and other tables containing project title or designator, drawing descriptions, publication citations, and biographical information.

Table: Building Contractor

The structure of this table was designed to record the building contractor for a Frank Lloyd Wright building.

Table: Category of Work

The structure of this table was designed to record a list of building types or architectural components found in the work of Frank Lloyd Wright.

Table: Drawing Author File

The structure of this table was designed to record relationships between Frank Lloyd Wright Commission Titles or designators and other tables containing project details, drawing descriptions, publication citations, and biographical information.

Table: Drawings Line Items

The structure of this table was designed to record extensive detail about individual drawings for Frank Lloyd Wright commissions.

Table: Electrical

The structure of this table was designed to record the name of the electrical engineer for a Frank Lloyd Wright project.

Table: ICONOGRAPHICS (empty)

The structure of Table ICONOGRAPHICS is undetermined. The purpose of the table is likely reflected instead in Table INCONOGRAPHICS2 (sic), below.

Table: Inconographics2 (sic)

The structure of this table was designed to record information about published photographs of Frank Lloyd Wright buildings deemed by John Geiger to be relevant to his studies.

Table: Landscape Design

The structure of this table was designed to record the name of the landscape designer for a Frank Lloyd Wright building.

Table: Mechanical

The structure of this table was designed to record the name of the mechanical engineer for a Frank Lloyd Wright building.

Table: MMJGBKLB

The structure of this table was designed to record bibliographic and other information about publications and archival materials collected by John Geiger in his library holdings.

Table: MMJGINV

The structure of this table was designed to record descriptions of personal possessions belonging to John Geiger, particularly home furnishings and his art collection.

Table: MMTFCATEGORY

The structure of this table was designed to record an abbreviation code and related descriptor for Taliesin Fellows membership, event registrations and donations, as well as subscriptions to the Journal of the Taliesin Fellows.

Table: MMTFDRAWINGS FILE

The structure of this table was designed to record identifying information and analytical detail for the production process of Frank Lloyd Wright commissions.

Table: MMTFFLLWIndexes

The structure of this table was designed to record an index of title information about Frank Lloyd Wright commissions in relationship to a selection of photographs.

Table: MMTFID

The structure of this table was designed to record a list of abbreviations to categorize the relationships of individuals to the Frank Lloyd Wright community.

Table: MMTFIDCODES

The structure of this table was designed to record an abbreviation system used to clarify spousal relationships between individuals within the Taliesin Fellowship.

Table: MMTFNL

The structure of this table was designed to record personal information about individuals and institutions related in various ways to the Frank Lloyd Wright community.

Table: NDX Line Items

The structure of this table was designed to record description detail for photographs of Frank Lloyd Wright buildings deemed by John Geiger to be relevant to his studies.

Table: Prelim Dwg Coord

The structure of this table was designed to record the name of the coordinator for the production of preliminary drawings for a Frank Lloyd Wright building.

Table: Project Architect

The structure of this table was designed to record the name of the individual who served as project architect for a Frank Lloyd Wright design.

Table: Published Line Items

The structure of this table was designed to record citation information for publications in which appear drawings for Frank Lloyd Wright commissions.

Table: Published/Drawings

The structure of this table was designed to record title and citation information about published drawings for Frank Lloyd Wright commissions.

Table: Quotations File

The structure of this table was designed to record an index with subject headings for quotations by or about Frank Lloyd Wright that John Geiger deemed relevant to his studies.

Table: Quote Line Items

The structure of this table was designed to record quotations by or about Frank Lloyd Wright that John Geiger deemed relevant to his studies.

Table: Specifications

The structure of this table was designed to record the name of the individual responsible for writing the specificiations for a Frank Lloyd Wright building.

Table: Status

The structure of this table was designed to record the existential status of Frank Lloyd Wright commissions.

Table: Structual (sic)

The structure of this table was designed to record the name of the structural engineer for a Frank Lloyd Wright building.

Table: Supervising Apprent

The structure of this table was designed to record the name of the supervising apprentice for construction of a Frank Lloyd Wright building.

Table: Work Dwgs Coord

The structure of this table was designed to record the name of the person who coordinated working drawings production for a Frank Lloyd Wright building.