THE GEIGER DATABASE


DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES

TABLE DETAIL: MMTFEVENTMAILERCOST

The structure of this table was designed to record total costs for events held by the Taliesin Fellows and issues of the Journal of the Taliesin Fellows (JTF).

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 MMTFEVENTMAILERCOSTcontains 11 rows arranged in 4 columns.

Entries record summary expenses for Issues #18 and #20 through #26 of the JTF, and three events sponsored by the Taliesin Fellows (Jim DeLong House Tour, 1995; Annual Meeting at San Francisco, 1996; and Lloyd Wright Week End/House Tour/Symposium, 1996).

Records from Table MMTFSUBEVENTMAILCOST are displayed in a subform; see DataEase Form Screen image, below. The table relies on lookup relationships with columns of Tables MMTF/JOURNAL/COST 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

JGDBFULL Table MMTF Event Mailer Cost  image

Document: DataEase table definition printout (PDF)

COLUMN LABELS

Column: [EVENT ID#] records an issue number of the JTF or an abbreviation for a Taliesin Fellows event related to Column [CATEGORY ID] of Table MMTFCATEGORY.

Column: [EMCREC#] records a unique numerical identifier for each row in the table.

Column: [DESCRIPTION] records a description through lookup on a row value of Column [DESCRIPTION] of Table MMTFCATEGORY.

Column: [COST] records a number through lookup on a row value of Column [COST1] of Table MMTFSUBEVENTMAILCOST.

RELATED QUERY PROCEDURES

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