THE GEIGER DATABASE


DATA TABLE STRUCTURES
DATABASE JGDB10 TABLES

TABLE DETAIL: LANDCAPE DESIGN

The structure of this table was designed to record the name of the landscape designer for a Frank Lloyd Wright building.

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 LANDSCAPE DESIGN contains 6 rows arranged in 5 columns.

Entries record a name and establish a lookup relationship with a specific Wright project, showing work by Walter Burley Griffin for 5 Frank Lloyd Wright commissions and 1 project whose landscape design is attributed to Wright himself. Records are undated.

Records from this table are displayed in a subform of Table MMTFDRAWINGs FILE. The table relies on lookup relationships with columns of Table MMTFNL.

Database Search

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

ORIGINAL DATAEASE FORM SCREEN

Landscape Design form

Document: DataEase table definition printout (PDF)

COLUMN LABELS

Column: [REC#] records a unique identification number related to a row value of Column [RECORD NUMBER] of Table MMTFNL.

Column: [COCOMMENTS] records the project identification number from the Frank Lloyd Wright Archives inventory.

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

Column: [LAST NAME] records the surname name of the individual named as landscape designer through lookup on row value of Column [LAST] of Table MMTFNL.

Column: [FIRST NAME] records the given name of the individual named as landscape designer through lookup on row value of Column [FIRST] of Table MMTFNL.

RELATED QUERY PROCEDURES

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