THE GEIGER DATABASE


DATA TABLE STRUCTURES
DATABASE JGDB10 TABLES

TABLE DETAIL: 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.

Note: The column labels shown within the table structures are historical references only, and do not reflect the definitions used within the version of the database being served through the website.

TABLE NOTES

The DRAWING AUTHOR FILE table contains 1,594 rows arranged in 9 columns.

Entries record a series of row identifiers from various tables to establish relationships with biographical and project information, as well as cite to individual project drawings. The records are undated.

Records from Table AUTHORLINEITEMS are displayed in a subform; see DataEase Form Screen image, below. This table provides lookup relationships to columns of Table AUTHORLINEITEMS, and relies on lookup relationships with columns of Tables DRAWINGS LINE ITEMS and MMTFDRAWINGS FILE.

DATABASE SEARCH

The content of this table is accessible through the version of the database available on the website.

ORIGINAL DATAEASE FORM SCREEN

Drawing Author File form

Document: DataEase table definition printout (PDF)

COLUMN LABELS

Column: [RD#] records a numerical identifier for each row in the table through lookup on row value of Column [RD#] of Table DRAWINGS LINE ITEMS.

Column: [COCOMMENTS] records the project identification number from the Frank Lloyd Wright Archives inventory through lookup on row value of Column [COCOMMENTS] of Table DRAWINGS LINE ITEMS.

Column: [FLLW DRAW ] records the drawing identification number from the Frank Lloyd Wright Archives inventory through lookup on row value of Column [FLLW ARCHIVES DRAW #] of Table DRAWING LINE ITEMS.

Column: [DRAW SUFFIX] records an alphabetic designator (e.g. "A" or "B") as a suffix for a drawing number through lookup on row value of Column [DRAW SUFFIX] of Table DRAWINGS LINE ITEMS.

Column: [CORR WR#] records a numeric entry through lookup on row value of Column [CORRECTED ARCHIVE J#] of Table DRAWINGS LINE ITEMS.

Column: [CORR WR#2] records a numeric entry through lookup on row value of Column [MONTH] of Table MMTFDRAWINGS FILE.

Column: [CORR DRAW #] records the drawing identification number from the Frank Lloyd Wright Archives inventory through lookup of Column [FLLW ARCHIVE DRAW #2] of Table DRAWINGS LINE ITEMS. Row entry combines with Column [COCOMMENTS] to produce a citation for a specific drawing.

Column: [BLDGCLIENT] records the client name or designator for a Frank Lloyd Wright project through lookup of Column [BLDG CLIENT] of Table DRAWINGS LINE ITEMS.

Column: [RA#] records a unique row identifier number for each row in this table.

RELATED QUERY PROCEDURES

This table is not referenced directly in any of the query procedures devised by Geiger.