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 |
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. | |
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. |