THE GEIGER DATABASE


DATA TABLE STRUCTURES
DATABASE JGDB10 TABLES

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

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 QUOTE LINE ITEMS contains 124 rows arranged in 10 columns.

Entries record bibliographic citation information for quotations, study notes, or comments by Geiger.

Records from the table are displayed as a subform of Table QUOTATIONS FILE. and also has lookup relationships with columns of Table MMJGKBLB. Some of the text columns shown in the DataEase Table Definition Printout, below, are not present in the existing table structure.

ORIGINAL DATAEASE FORM SCREEN

QUOTATIONS LINE ITEMS form

Document: DataEase table definition printout (PDF)

COLUMN LABELS

Column: [QUOTE FILE] records a number as a row identifier through lookup on a row value of Column [QUOTE FILE #] of Table QUOTATIONS FILE.

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

Column: [SUBJECT] records a freeform subject heading devised by Geiger. Row entries may be related to Column [SUBJECT] of Table QUOTATIONS FILE, but can also be unique descriptions of a quoted source.

Column: [LBR#] records a unique identifier number related to Column [RECORD#] of Table MMJGBKLB.

Column: [LBR#2] records an author name in "last name, first name" format through lookup on a row value of Column [AUTHOR1] of Table MMJGBKLB on value of Column [LBR#].

Column: [LBR#3] records title information for a publication through lookup on a row value of Column [TITLE2] of Table MMJGBKLB on value of Column [LBR#].

Column: [LBR#4] records additional title information for a publication through lookup on a row value of Column [TITLE3] of Table MMJGBKLB on value of Column [LBR#].

Column: [LBR5] records additional title information for a publication through lookup on a row value of Column [TITLE4] of Table MMJGBKLB on value of Column [LBR#].

Column: [PAGES] records page numbers for the citation of a quoted source.

Column: [LONG:COMMENTS] records a quotation, study note, and or citation information.

Note: Columns 11 through 28 as shown in the Table Definition do not exist in the table, but were originally intended to compensate for text field length limitations of 80 characters. This method was used initially by Geiger to allow for longer quotations until he learned how the functionality for a single long text entry was available in DataEase.

RELATED QUERY PROCEDURES

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