TACTS Table Relations


Last Update of this page: November 2, 1998

Diagram of Table Relations

TACTS Table Relations Diagram

Description of the Table Relations

Description of the Relations for Web

The Web table is not related to any other tables. This table should only have one row in it. Therefore there is no primary key defined for this table.

Description of the Relations for Manufacturer

The primary key for the Manufacturer table is MfgID.

The Manufacturer Table is related to the CardSeries table as the one side in a one to many relationship.
The MfgID (Primary Key) is referenced in the CardSeries table as Manufacturer (Foreign Key).

Description of the Relations for CardSeries

The primary key for the CardSeries table is SeriesID.

This table is the main table in our database.
Most of the other data in the database is related to this table.

The Card Series Table is related to the Manufacturer table as the many side in a one to many relationship.
The Manufacturer (Foreign Key) references MfgID (Primary Key) in the Manufacturer table.

The CardSeries Table is related to the ChaseTypes table as the one side in a one to many relationship.
The SeriesID (Primary Key) is referenced in the ChaseTypes table as SeriesID (Foreign Key).

The CardSeries Table is related to the Cards table as the one side in a one to many relationship.
The SeriesID (Primary Key) is referenced in the Cards table as SeriesID (Foreign Key).

The CardSeries Table is related to the CardsTemp table as the one side in a one to many relationship.
The SeriesID (Primary Key) is referenced in the CardsTemp table as SeriesID (Foreign Key).

The CardSeries Table is related to the CCG table as the one side in a one to many relationship.
The SeriesID (Primary Key) is referenced in the CCG table as SeriesID (Foreign Key).

The CardSeries Table is related to the CCGTemp table as the one side in a one to many relationship.
The SeriesID (Primary Key) is referenced in the CCGTemp table as SeriesID (Foreign Key).

The CardSeries Table is related to the RelatedSeries Table twice.
The RelatedSeries Table is really there to implement a many to many relation between CardSeries and itself.
The CardSeries Table is related to the RelatedSeries table as the one side in a one to many relationship.
The SeriesID (Primary Key) is referenced in the RelatedSeries table as SeriesID (Foreign Key).
The CardSeries Table is related to the RelatedSeries table as the one side in a one to many relationship.
The SeriesID (Primary Key) is referenced in the RelatedSeries table as RelatedSeriesID (Foreign Key).

Description of the Relations for RelatedSeries

The primary key for the RelatedSeries table is a composite primary key.
The primary key is SeriesID and RelatedSeriesID.

The RelatedSeries Table is related to the CardSeries Table.
The RelatedSeries Table is really there to implement a many to many relation between CardSeries and itself.
The RelatedSeries Table is related to the CardSeries table as the many side in a one to many relationship.
The SeriesID (Foreign Key) references SeriesID (Primary Key) in the CardSeries table.
The RelatedSeries Table is related to the CardSeries table as the many side in a one to many relationship.
The RelatedSeriesID (Foreign Key) references SeriesID (Primary Key) in the CardSeries table.

Description of the Relations for ChaseTypes

The primary key for the ChaseTypes table is a composite primary key.
The primary key is SeriesID and Sequence.
ChaseTypes can have an alternate primary key.
The alternate composite primary key is SeriesID and RelatedCards.

The ChaseTypes Table is related to the CardSeries table as the many side in a one to many relationship.
The SeriesID (Foreign Key) references SeriesID (Primary Key) in the CardSeries table.

The ChaseTypes Table is related to the Cards table as the one side in a one to many relationship.
The SeriesID and RelatedCards (Alternate Primary Key) is referenced in the Cards table as SeriesID and SubSeries (Foreign Key).

Description of the Relations for Cards

The primary key for the Cards table is a composite primary key.
The primary key is SeriesID and CardNumber.

The Cards Table is related to the CardSeries table as the many side in a one to many relationship.
The SeriesID (Foreign Key) references SeriesID (Primary Key) in the Card Series table.

The Cards Table is related to the ChaseTypes table as the many side in a one to many relationship.
The SeriesID and SubSeries (Foreign Key) references SeriesID and RelatedCards (Alternate Primary Key) in the ChaseTypes table.

Description of the Relations for CCG

The primary key for the CCG table is a composite primary key.
The primary key is SeriesID, Subject, and Description.

The CCG Table is related to the CardSeries table as the many side in a one to many relationship.
The SeriesID (Foreign Key) references SeriesID (Primary Key) in the CardSeries table.

Description of the Relations for CardsTemp

The primary key for the CardsTemp table is a composite primary key.
The primary key is SeriesID and CardNumber.

The CardsTemp Table is related to the CardSeries table as the many side in a one to many relationship.
The SeriesID (Foreign Key) references SeriesID (Primary Key) in the CardSeries table.

Description of the Relations for CCGTemp

The primary key for the CCGTemp table is a composite primary key.
The primary key is SeriesID, Subject, and Description.

The CCGTemp Table is related to the CardSeries table as the many side in a one to many relationship.
The SeriesID (Foreign Key) references SeriesID (Primary Key) in the CardSeries table.

TACT User Guide TOC  -  Previous Section

mail your questions, comments, or requests to:
robert@corfman.com

Back to the TACT User Guide Table of Contents
Go to my HOMEPAGE