THE GEIGER DATABASE


DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES

TABLE DETAIL: MMTFMEETPEOPLE

The structure of this table was designed to record registration information for participants who attended multiple events of the Taliesin Fellows.

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 MMTFMEETPEOPLE contains 760 rows arranged in 16 columns.

Entries record attendee names, programs titles and events, and registration costs for events held between 1992 and 1999.

Records from TableMEET LINE ITEMS are displayed in a subform; see DataEase Form Screen image, below. The table relies on lookup relationships with columns of Tables SUB LINE ITEMS and MMTFMEETINGLIST.

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 MMTFMEETPEOPLE image

Document: DataEase table definition printout (PDF)

COLUMN LABELS

Column: [RECORD NUMBER] records a value related to Column [RECORD NUMBER] of Table MMTFNL.

Column: [RSL#] records a value through lookup on a row value of Column [RSL#] of Table SUB LINE ITEMS.

Column: [MP#] records a sequential number as a unique row identifier.

Column: [CATEGORY] records an abbreviation to identify an event through lookup on a row value of Column [CATEGORY] of Table SUB LINE ITEMS.

Column: [DESCEVENT1] records a program title or description through lookup on a row value of Column [DESCEVENT1] of Table MMTFMEETINGLIST.

Column: [COST1] records a registration cost for the event through lookup on a row value of Column [COST1] of Table MMTFMEETING LIST.

Column: [DESCEVENTA] records a note or comment about an event through lookup on a row value of Column [DESCEVENTA] of Table MMTFMEETING LIST.

Column: [COSTA] records a registration cost for an event through lookup on a row value of Column [COSTA] of Table MMTFMEETING LIST.

Column: [DESCEVENT2] records a program title or description through lookup on a row value of Column [DESCEVENT2] of Table MMTFMEETINGLIST.

Column: [COST2] records a registration cost for an event through lookup on a row value of Column [COST2] of Table MMTFMEETING LIST.

Column: [DESCEVENT3] records a program title or description through lookup on a row value of Column [DESCEVENT3] of Table MMTFMEETINGLIST.

Column: [COST3] records a registration cost for an event through lookup on a row value of Column [COST3] of Table MMTFMEETING LIST.

Column: [DESCEVENT4] records a program title or description through lookup on a row value of Column [DESCEVENT4] of Table MMTFMEETINGLIST.

Column: [COST4] records a registration cost for an event through lookup on a row value of Column [COST4] of Table MMTFMEETING LIST.

Column: [DESCEVENT5] records a program title or description through lookup on a row value of Column [DESCEVENT5] of Table MMTFMEETINGLIST.

Column: [COST5] records a registration cost for an event through lookup on a row value of Column [COST5] of Table MMTFMEETING LIST.

RELATED QUERY PROCEDURES

The data in this table is referenced in 4 query procedures devised by Geiger: