THE GEIGER DATABASE
DATA TABLE STRUCTURES
DATABASE JGDBFULL TABLES
TABLE DETAIL: JTFONHAND
The structure of this table was designed to record an inventory of back 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 JTFONHAND contains 23 rows arranged in 3 columns.
Entries record issue number, on hand count, and brief main title description information for Issues #1-23 of the JTF.
The table relies on lookup relationships with columns of Table MMTFPUBLICATIONREC.
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: [THRU ISSUE #] records an issue number of the JTF.
Column: [QUANTITY OH] records the number of back copies on hand for an issue of the JTF through lookup on a row value of Column [QUANTITY OH] of Table MMTFPUBLICATIONREC.
Column: [LEADSTORY] records a descriptive text concerning the main story item(s) in a JTF issue through lookup on a row value of Column [LEAD STORY] of Table MMTFPUBLICATIONREC.
RELATED QUERY PROCEDURES
This table is not referenced directly in any of the query procedures devised by Geiger.