GCD Indexing Tutorial
Indexing Overview - Tables
Draft #4
January 04, 2002

Tables
A database is made up of tables. Each table consists of many records, each with the same number of fields.

One way to think of tables is to look at a standard wall calendar. It has rows for each week, and columns for each day of the week. Each individual day has a box (or cell) you can write appointments in. If you have swimming every Thursday you would put the same data, "swimming", in each Thursday box. You know swimming is on Thursday by the column it appears in. If there are no appointments, no data, in other days, "swimming" still shows up in the same box.

Sunday Monday Tuesday Wednesday Thursday Friday Saturday
5

6

7

8

9
Swimming
 
 
10

11
Give A Moore Haircut
12

 
 
13
Meet With M Waid
14

 
 
15

 
16
Swimming
17

18

 
 
19
Pray For More Aquaman
20

 
 
21

22

 
23
Swimming
 
24

25
Index Another 50 Comics

The same is true of the GCD:

Title Pencils Inks Story
Aquaman vs Spam Martin Egeland Howard Shum Peter David
Aquaman Tries to Floss Steve Epting Norm Rapmund Dan Jurgens
Aquaman Gets Canned

Mike Carlin

The lines that define the boxes on a calendar are replaced by the tab characters of our format. Our boxes are called fields and are as wide as they need to be (up to 255 characters), and we aren't concerned with the boxes lining up visually on the screen when we enter data. It is important, however, that each record in the table has the same number of fields, and that the order of the fields is the same.

Aquaman vs Spam [tab] Martin Egeland [tab] Howard Shum [tab] Peter David
Aquaman Tries to Floss [tab] Steve Epting [tab] Norm Rapmund [tab] Dan Jurgens
Aquaman Gets Canned [tab] [tab] [tab] Mike Carlin

The reason for the blank line in the index file is to separate two tables. The indexer record doesn't go into a table, but the series record (which has fourteen fields) goes into a series table, and the issue data (which has eighteen fields) goes into an issues table.


Next Page - Using Other Applications | Back to Start