THE GEIGER DATABASE


DATA TABLE STRUCTURES
DATABASE JGDB10 TABLES

TABLE DETAIL: PUBLISHED/DRAWINGS

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

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

Table PUBLISHED/DRAWINGS table contains 6,266 rows arranged in 13 columns.

Entries record name or designator, client, drawing titles, location, and other descriptive detail for Wright projects in order to group and cite publication information for related drawings. Records are undated.

Records from Table PUBLISHED LINE ITEMS are displayed in a subform; see DataEase Form Screen image, below. The table 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

PUBLISHED DRAWINGS form

Document: DataEase table definition printout (PDF)

COLUMN LABELS

Column: [DRAW LINE ITEM #] records a unique numerical identifier related to a specific drawing through lookup on Column [RD#] of Table DRAWINGS LINE ITEMS.

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

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

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

Column: [CORRECTED ARCHIVE J] records the last 2 digits of the year assigned to Frank Lloyd Wright project through lookup on a row value of Column [CORRECTED ARCHIVE J] of Table DRAWINGS LINE ITEMS.

Column: [MONTH2] records records a month in MM format through lookup on a row value of Column [MONTH] of Table MMTFDRAWINGS FILE.

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

Column: [PUBDRAWFILE#] records a unique (but not always sequential) number as a row identifier.

Column: [CLIENT NAME] records the client name or designator for a Frank Lloyd Wright project through lookup from Column [BLDG CLIENT] of Table MMTFDRAWINGS FILE.

Column: [DRAWING TITLE] records the title for a Frank Lloyd Wright project through lookup on a row value of Column [JOB TITLE] of Table DRAWINGS LINE ITEMS.

Column: [DRAWING TITLE2] records the title block label, if present, on a drawing (e.g. "Floor Plan, "Section," [DRAWING TITLE] of Table DRAWINGS LINE ITEMS.

Column: [LOCATION2] records a geographical location for a Frank Lloyd Wright project through lookup on Column [LOCATION] of Table DRAWINGS LINE ITEMS.

Column: [DRAWING DESCRIPTION] records a description of the principal content of a drawing (e.g. "Main floor plan and fireplace details") through lookup on a row value of Column [DESCRIPTION] of Table DRAWINGS LINE ITEMS.

RELATED QUERY PROCEDURES

The data in this table is referenced in 7 query procedures devised by Geiger: