THE GEIGER DATABASE


DATA TABLE STRUCTURES
DATABASE JGDB10 TABLES

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

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 INCONOGRAPHICS2 contains 206 rows arranged in 17 columns.

Entries record details concerning individual photographs, including Frank Lloyd Wright project title, photographer, and publication or archival source of the images, and uses relationships with other tables to reference additional project and bibliographic information.

Document: Description by Geiger of his intention in creating this table.

The table relies on lookup relationships with columns of Tables NDX LINE ITEMS, MMTFFLLWIndexes, and MMJGBKLB.

Database Search

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

ORIGINAL DATAEASE FORM SCREEN

Inconographs form

Document: DataEase table definition printout (PDF)

COLUMN LABELS

Column: [NDX#] records a unique identification number for a Frank Lloyd Wright project through lookup of Column [LINE ITEM NUMBER] of Table NDX 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 NDX LINE ITEMS.

Column: [FLLW ARCHIVE PHOTO#] was intended to record inventory numbers from the Frank Lloyd Wright Archives. No entries.

Column: [CORRECTED ARCHIVE #] records the last 2 digits of the year for a Frank Lloyd Wright project from the Frank Lloyd Wright Archives inventory through lookup on row value of Column [CORRECTED ARCHIVE #] of Table NDX LINE ITEMS.

Column: [CORRECTED ARCHIVE #2] records the series number within a year assigned to a Frank Lloyd Wright project by the Frank Lloyd Wright Archives inventory through lookup on row value of Column [CORRECTED ARCHIVE #2] of Table NDX LINE ITEMS.

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

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

Column: [JOB TITLE] records the title of a Frank Lloyd Wright project through lookup on row value of Column [JOB TITLE] of Table MMTFFLLWINDEX.

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

Column: [LBR#2] records the name of the author of the publication through lookup on row value of Column [AUTHOR1] of Table MMJGBKLB on row value of Column [LBR#].

Column: [PAGES] records the page number(s) where an image is found in the publication referenced in row value of Column [LBR#].

Column: [PAGES2] records the primary or short title of the publication through lookup on row value of Column [TITLE2] of Table MMJGBKLB, or alternative summary description of an archival source.

Column: [FIGURE] records a figure number for an illustration in a publication

Column: [FIGURE2] records the secondary or subordinate title of a publication through lookup on a row value of Column [TITLE3] of Table MMJGBKLB.

Column: [TITLE44] records a third or subsidiary title of the publication through lookup on row value of Column [TITLE4] of Table MMJGBKLB.

Column: [PUBLISHER1] records the publisher of the publication through lookup on row value of Column [PUBLISHER6] of Table MMJGBKLB.

Column: [COMMNETS] (sic) records brief annotation concerning the referenced photograph.

RELATED QUERY PROCEDURES

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