THE GEIGER DATABASE
DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES
TABLE DETAIL: MMTFLIBRARYLINEITEMS
The structure of this table was designed to record individual 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 MMTFLIBRARYLINEITEMS contains 6 columns void of row entries.
Records from this table are displayed in a subform of Table MMTFFLLWLIBRARYFUND. This table provides a lookup relationship for a column of Table MMTFFLLWLIBRARYFUND, and relies on lookup relationships with columns of Tables MMTFFLLWLIBRARYFUND, SUB LINE ITEMS, and MMTFCATEGORY.
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] is void of entries in all rows; intended lookup on a row value of Column [RECORD NUMBER] of Table MMTFFLLWLIBRARYFUND.
Column: [LIBREC#] is void of entries in all rows; intended lookup on a row value of Column [FLLWLIB#] of Table MMTFFLLWLIBRARYFUND.
Column: [FLLWLIBR#] is void of entries in all rows; intended unique numerical identifier for all rows in the table.
Column: [CHECK #] is void of entries in all rows; intended lookup on a row value of Column [CHECK #] of Table SUB LINE ITEMS.
Column: [CHECK DATE] is void of entries in all rows; intended lookup on a row value of Column [CHECK DATE] of Table SUB LINE ITEMS, though the table definition is in error.
Column: [AMOUNT] is void of entries in all rows.
Column: [COMMENTS] is void of entries in all rows; intended lookup on a row value of (non-existent) Column [LIBF] of Table MMTFCATEGORY
RELATED QUERY PROCEDURES
This table is not referenced directly in any of the query procedures devised by Geiger.