THE GEIGER DATABASE


DATA TABLE STRUCTURES
DATABASE JGDB10 TABLES

TABLE DETAIL: PUBLISHED LINE ITEMS

The structure of this table was designed to record bibliographic information for publications in which appear 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 LINE ITEMS contains 9,943 rows arranged in 18 columns.

Entries record citations for published drawings of Frank Lloyd Wright designs, including title, author, International Standard Book Number (ISBN) or International Standard Serial Number (ISSN), client name, Wright project title, geographical location, inventory number from the Frank Lloyd Wright Archives, plate or figure locator, and indication of black-and-white or color reproduction.

Records from the table are displayed as a subform of Table PUBLISHED/DRAWINGS. The table relies on lookup relationships with columns of Tables PUBLISHED/DRAWINGS 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

PUBLISHED LINE ITEMS form

Document: DataEase table definition printout (PDF)

COLUMN LABELS

Column: [PUBDRAWFILE#] records a relational row identifier number through lookup on a row value of Column [PUBDRAWFILE#] of Table PUBLISHED/DRAWINGS.

Column: [ISBN2] records an International Standard Book Number through lookup on a row value of Column [ISBN2] of Table MMJGBKLB.

Column: [ISSN] records an International Standard Serial Number through lookup on a row value of Column [ISSN] of Table MMJGBKLB.

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

Column: [ISBN] records an International Standard Book Number through lookup on a row value of Column [ISBN] of Table MMJGBKLB.

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

Column: [LBR#] records an identifier number for a publication or other source related to Column [RECORD #] of Table MMJGBKLB.

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

Column: [PAGES] records a number citing a page in a publication.

Column: [TITLE11] records the primary or main part of a publication title through lookup on a row value of Column [TITLE2] of Table MMJGBKLB.

Column: [FIGURE #] records a number citing a figure label in a publication.

Column: [TITLE33] records additional title components of a publication title through lookup on a row value of Column [TITLE3] of Table MMJGBKLB.

Column: [COLOR] records "YES" or "NO" to indicate whether a drawing is published in color.

Column: [TITLE44] records additional title components of a publication through lookup on a row value of Column [TITLE4] of Table MMJGBKLB.

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 PUBLISHED/DRAWINGS.

Column: [COCOMMENTS2] 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 PUBLISHED/DRAWINGS.

Column: [PUBLISHER1] records a publisher for the cited source through lookup on a row value of Column [PUBLISHER6] of Table MMJGBKLB.

Column: [COMMENTS] records a notation about source, medium, drawing type, etc.

RELATED QUERY PROCEDURES

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