THE GEIGER DATABASE
DATA TABLE STRUCTURES
DATABASE JGDB10 TABLES
TABLE DETAIL: ELECTRICAL
The structure of this table was designed to record the name of the electrical engineer for a Frank Lloyd Wright project.
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 ELECTRICAL contains 3 rows arranged in 5 columns.
Entries record a name and establish a lookup relationship with a specific Wright project. Records are incomplete and undated.
Records from the table are displayed as 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: [RECORD NUMBER] relates to a unique identification number found in Column [RECORD NUMBER] of Table MMTFNL for the individual named as electrical designer.
Column: [COCOMMENTS] records the project identification number from the Frank Lloyd Wright Archives inventory.
Column: [RE#] records a unique row identifier number for each row in this table.
Column: [LAST NAME] records the surname name of an individual named as electrical designer through lookup on row value of Column [LAST] of Table MMTFNL.
Column: [FIRST NAME] records the given name of the individual named as electrical designer through lookup MMTFNL.
RELATED QUERY PROCEDURES
This table is not referenced directly in any of the query procedures devised by Geiger.