FanTango Project Page

17-654: Analysis of Software Artifacts



Home  
Project Overview  
[ Database ]  
Baseline | Baseline 02-13-04  
FT Baseline  
RT FT Baseline  
HP RT FT Baseline  



Database Tables

FT_THEATER [ Top ]

Stores theater information.
Field Type Nullity Key Description
ID int NOT NULL Primary Unique ID for each Theater.
Name varchar ( 50 ) NOT NULL   Theater name.
Zip int     Theater zip code for locational searching.


FT_ROOM [ Top ]

Stores theater room information.
Field Type Nullity Key Description
ID int NOT NULL Primary Unique ID for each room in database.
TheaterID int NOT NULL FT_THEATER ( ID ) Theater the room is in.
Name varchar ( 50 ) NOT NULL   Room name or number.
Seats int NOT NULL   Total seating.


FT_MOVIE [ Top ]

Stores specific movie information.
Field Type Nullity Key Description
ID int NOT NULL Primary Unique ID for each movie.
Title varchar ( 50 ) NOT NULL   Movie title.
Length real     Running time (hours).


FT_SHOWING [ Top ]

Stores detailed information about available showings.
Field Type Nullity Key Description
ID int NOT NULL Primary Unique ID for each showing.
RoomID int NOT NULL FT_ROOM ( ID ) Room the showing is offered in.
MovieID int NOT NULL FT_MOVIE ( ID ) Movie being shown.
Date DATE NOT NULL   Date of showing.
Time TIME NOT NULL   Time of showing.
Sold int NOT NULL   Seats sold for this showing. Useful so that the server does not need to search every order in the database to determine remaining seating.


FT_CUSTOMER [ Top ]

Stores registered customer information.
Field Type Nullity Key Description
Username varchar ( 20 ) NOT NULL Primary Unique username.
Password varchar ( 20 ) NOT NULL   User-chosen, alphanumeric password.
Email varchar ( 50 ) NOT NULL   User's e-mail.
FName varchar ( 50 ) NOT NULL   Customer first name.
LName varchar ( 50 ) NOT NULL   Customer last name.
Registered DATETIME NOT NULL   Date and time of registration.
LoggedIn BOOL NOT NULL   If customer is currently logged in.


FT_TRANSACTION [ Top ]

Stores customer transaction information to maintain state in event of server failure. Stores multiple transactions from a single customer, not including cancelled transactions. Identifies particular transactions by customer Username, Date, and Time for uniqueness.
Field Type Nullity Key Description
Customer varchar ( 20 ) NOT NULL Candidate, FT_CUSTOMER ( ID ) Customer username.
Date DATE NOT NULL Candidate Date of transaction.
Time TIME NOT NULL Candidate Time of transaction.
Showing int   FT_SHOWING ( ID ) ID of showing if customer was interested in one at the time.
Tickets int     Number of tickets if customer was interested in purchasing.
Status ENUM (
None,
Browsing,
Purchasing,
Cancelling )		 NOT NULL   Stores state of transaction, whether customer had not commit to anything (default), has an interest in a showing, is attempting to purchase, or is attempting to cancel (in that order).


FT_ORDER [ Top ]

Stores customer transaction information upon completion of transaction.
Field Type Nullity Key Description
ID int NOT NULL Primary Unique order number;
Customer varchar ( 20 ) NOT NULL FT_CUSTOMER ( ID ) Customer username.
Date DATE NOT NULL   Date of transaction.
Time TIME NOT NULL   Time of transaction.
Showing int   FT_SHOWING ( ID ) ID of showing that customer has bought tickets for.
Tickets int     Number of tickets purchased.


FT_CREDITCARD [ Top ]

Stores customer credit card information if customer requests their information stored. Kept separate from customer information in the event that this is implemented and handled separately (or at all).
Field Type Nullity Key Description
Customer varchar ( 20 ) NOT NULL Candidate, FT_CUSTOMER ( ID ) Customer username.
Type ENUM (
Visa,
Mastercard,
Amex,
Discover )		 NOT NULL   Type of credit card.
Number varchar ( 20 ) NOT NULL   Credit card number.
ExpMonth int NOT NULL   Expiration month.
ExpDay int     Expiration day, if any.
ExpYear int NOT NULL   Expiration year.