THE GEIGER DATABASE
DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES
TABLE DETAIL: MMTFFLLWLIBRARYFUND
The structure of this table was designed to record total donations to the William Wesley Peters Memorial Scholarship Fund at the Frank Lloyd Wright School of Architecture at Taliesin West in Scottsdale, Arizona.
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 MMTFFLLWLIBRARYFUND contains 1 row arranged in 4 columns.
Entries were intended to record a list of donors and contribution information. Data entry was not developed beyond the single record, showing 1 donation by a Taliesin Fellow on August 25, 1995.
Records from Table MMTFFLibraryLineItems are displayed in a subform; see DataEase Form Screen image, below. The table relies on lookup relationships with columns of Tables MMTFNL and MMTFFLibraryLineItems.
Database Search
The content of this table is not 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] records a unique identification number through lookup on Column [RECORD NUMBER] of Table MMTFNL.
Column: [FLLWLIB#] records a unique numerical identifier for each row in the table.
Column: [YEAR TO DATE DONATIO] records a total number of donations by an individual for the year to date on lookup of Column [AMOUNT] of Table MMTFLIBRARYLINEITEMS; field calculation as written would not have functioned.
Column: [ENTRY DATE] records a date in month/day/year format.
RELATED QUERY PROCEDURES
This table is not referenced directly in any of the query procedures devised by Geiger.