THE GEIGER DATABASE
DATA TABLE STRUCTURES
DATABASE JGDB10 TABLES
TABLE DETAIL: SUPERVISING APPRENT
The structure of this table was designed to record the name of the supervising apprentice for construction of 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
The SUPERVISING APPRENT table contains 88 rows arranged in 5 columns.
Entries record a name establish a lookup relationship with a specific Wright project. 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
Document: Dataease table definition printout (PDF)
COLUMN LABELS
Column: [RA#] records a unique row identifier number for each row in this table.
Column: [COCOMMENTS] records the project identification number from the Frank Lloyd Wright Archives inventory.
Column: [RECORD NUMBER] records a unique identification number for the individual name related to Column [RECORD NUMBER] of Table MMTFNL
Column: [LAST NAME] records the surname of the specifications writer through lookup on row value of Column [LAST] of Table MMTFNL.
Column: [FIRST NAME] records the given name of the specifications writer through lookup on row value of Column [FIRST] of Table MMTFNL.
RELATED QUERY PROCEDURES
The data in this table is referenced in 1 query procedure devised by Geiger: