GENERAL GUIDE

TECHNICAL INFORMATION

 

THE GEIGER DATABASE



database versions

DATABASE TABLES COMPARISON

The following table shows the table and record count in each of the six complete versions of the Geiger database. The links provide detail of the tables as they exist in Database JGDB10 and JGDBFULL, though their structure is consistent within all database versions.

     

 

 

 

 

DATABASE VERSION
TABLE NAME
(
alphabetical listing)
JGDBFULL JBDB08 JGDB09 JGDB
PERSONAL
JGDB10 JGDB
                 
  AUTHORLINEITEMS 1,522 1,603 1,643 1,644 1,666 1,666  
BUILDING CONTRACTOR 1 1 1 1 1 1  
  CATEGORY OF WORK 86 86 86 86 86 86  
COSTINTHEMAIL 21 n/a n/a n/a n/a n/a  
CURRENTCODE 13 n/a n/a n/a n/a n/a  
DICTIONARY 0 0 0 0 0 0  
DRAWING AUTHOR FILE 1,442 1,530 1,570 1,571 1,594 1,594  
DRAWING LINE ITEMS 4,006 4,432 4,923 4,936 6,204 6,210  
ELECTRICAL 3 0 1 1 3 3  
ICONOGRAPHICS 0 0 0 0 0 0  
Inconographics2 (sic) 104 204 206 206 206 206  
JTFCOSTBREAKDOWN 6 n/a n/a n/a n/a n/a  
JTFONHAND 23 n/a n/a n/a n/a n/a  
  JTFPROFITLOSS 13 n/a n/a n/a n/a n/a  
LANDSCAPE DESIGN 2 2 8 8 8 8  
MECHANICAL 3 2 5 5 5 5  
MEET LINE ITEMS 1,421 n/a n/a n/a n/a n/a  
MEET LOCATION 35 n/a n/a n/a n/a n/a  
MMJGBKLB 1,229 1,328 1,358 1,449 1,466 1,467  
MMJGINV 275 263 263 263 263 263  
MMTF/JOURNAL/COST 25 n/a n/a n/a n/a n/a  
MMTFCATEGORY 41 41 41 41 41 41  
MMTFDRAWINGS FILE 1,132 1,147 1,151 1,151 1,157 1,157  
MMTFEVENTMAILERCOST 11 n/a n/a n/a n/a n/a  
MMTFFLLWIndexes 17 79 79 79 80 80  
MMTFFLLWLIBRARYFUND 1 n/a n/a n/a n/a n/a  
MMTFID 36 38 38 39 39 39  
MMTFIDCODES 3 3 4 4 4 4  
MMTFJDISTRIBUTIONREC 1,472 n/a n/a n/a n/a n/a  
MMTFLIBRARYLINEITEMS 0 n/a n/a n/a n/a n/a  
MMTFMAILCOST 121 n/a n/a n/a n/a n/a  
MMTFMEETING LIST 24 n/a n/a n/a n/a n/a  
MMTFMEETPEOPLE 760 n/a n/a n/a n/a n/a  
MMTFNL 4,525 4,648 4,680 4,683 4,687 4,688  
MMTFNLSF 1,346 n/a n/a n/a n/a n/a  
MMTFPUBLICATIONREC 25 n/a n/a n/a n/a n/a  
MMTFSUBEVENTMAILCOST 65 n/a n/a n/a n/a n/a  
MMTFTALINFO 944 n/a n/a n/a n/a n/a  
MMTFTALINFOFORMS 12 n/a n/a n/a n/a n/a  
MMTFWWPETERS 15 n/a n/a n/a n/a n/a  
NDX LINE ITEMS 112 186 189 189 189 189  
PETER LINE ITEMS 16 n/a n/a n/a n/a n/a  
PRELIM DWG COORD 43 57 59 60 60 60  
PROJECT ARCHITECT 13 14 16 16 16 16  
PUBLISHED LINE ITEMS 5,631 6,266 7,299 7,332 9,943 9,968  
PUBLISHED/DRAWINGS 3,887 4,364 4,860 4,859 6,266 6,272  
QUOTATIONS FILE 52 80 83 83 83 83  
QUOTE LINE ITEMS 76 118 123 124 124 124  
SPECIFICATIONS 3 8 12 12 12 12  
STATUS 3 3 3 3 3 3  
STRUCTUAL (sic) 8 30 32 32 32 32
SUB LINE ITEMS 4,924 n/a n/a n/a n/a n/a  
SUPERVISING APPRENT 59 77 87 87 88 88  
TALINFO LINE ITEMS 2,574 n/a n/a n/a n/a n/a  
TFBIO 1 n/a n/a n/a n/a n/a  
TFEDITORIALCOSTS 9 n/a n/a n/a n/a n/a  
TFGRAPHICCOSTS 7 n/a n/a n/a n/a n/a  
TFJTFCOST 9 n/a n/a n/a n/a n/a  
TFPRINTINGCOSTS 25 n/a n/a n/a n/a n/a  
TFSUBEDITORIALCOSTS 12 n/a n/a n/a n/a n/a  
TFSUBGRAPHICSCOST 25 n/a n/a n/a n/a n/a  
WORK DWGS COORD 76 105 109 109 109 109  
               
TOTAL RECORDS 38,345 26,715 28,929 29,073 34,435 34,474  


TOP OF PAGE

Copyright 2010 John W. Geiger