| Database Name: HavanaCustomerService |
| Column name | Type | Size | Nullable? | Tables contain this column |
| address | char | 20 | YES | EmployeeDetails |
| address | char | 30 | YES | CustomerDetails |
| aggrementNumber | char | 10 | NO | CustomerDetails |
| agreementNumber | char | 20 | NO | Reservations |
| airline | char | 30 | NO | ResFlights |
| arrDate | datetime | 0 | YES | ResDeals, ResETC, ResFlights |
| birthDate | datetime | 0 | NO | EmployeeDetails |
| bonusWeeks | int | 3(10, 0) | NO | Reservations |
| car | int | 3(10, 0) | NO | Reservations |
| carType | char | 30 | YES | ResCar |
| cellPhone | char | 20 | YES | EmployeeDetails, CustomerDetails |
| city | char | 20 | YES | EmployeeDetails, CustomerDetails |
| Class | char | 10 | YES | ResCar |
| clientID | int | 3(10, 0) | NO | Reservations |
| dealDate | datetime | 0 | NO | CustomerDetails |
| deals | int | 3(10, 0) | NO | Reservations |
| depDate | datetime | 0 | YES | ResFlights, ResETC, ResDeals |
| destanation | char | 40 | NO | ResFlights |
| destantion | varchar | 50 | NO | ResDeals |
| destination | char | 20 | NO | ResBonusWeeks |
| destination | char | 30 | NO | ResETC, ResCar |
| dollarRate | float | 5(53, 0) | YES | CustomerDetails |
| eMail | char | 20 | YES | CustomerDetails |
| employeeID | int | 3(10, 0) | NO | Reservations |
| ETC | int | 3(10, 0) | YES | CustomerDetails, Reservations |
| firstName | char | 20 | YES | CustomerDetails, EmployeeDetails |
| flightNum | char | 20 | YES | ResFlights |
| flights | int | 3(10, 0) | NO | Reservations |
| Gift | int | 3(10, 0) | YES | CustomerDetails |
| Gross | int | 3(10, 0) | YES | CustomerDetails |
| homeLocation | int | 3(10, 0) | NO | Reservations |
| hotelName | char | 30 | YES | ResHomeLocation, ResETC, ResBonusWeeks |
| id | int | 3(10, 0) | NO | Statuses, Ranks, EmployeeDetails, CustomerDetails |
| lastName | char | 20 | YES | EmployeeDetails, CustomerDetails |
| Line | char | 20 | YES | CustomerDetails |
| lineName | char | 20 | NO | Line |
| locationNumber | char | 10 | YES | ResBonusWeeks |
| marks | varchar | 250 | YES | Reservations |
| Netto | int | 3(10, 0) | YES | CustomerDetails |
| numOfAduls | int | 3(10, 0) | NO | ResDeals |
| numOfAdults | int | 3(10, 0) | NO | ResBonusWeeks, ResFlights, ResHomeLocation, ResETC |
| numOfDays | int | 3(10, 0) | YES | ResCar |
| numOfkids | int | 3(10, 0) | YES | ResDeals, ResETC |
| numOfKids | int | 3(10, 0) | NO | ResBonusWeeks, ResFlights, ResHomeLocation |
| payed | int | 3(10, 0) | YES | CustomerDetails |
| phoneNumber | char | 20 | NO | CustomerDetails, EmployeeDetails |
| price | float | 5(53, 0) | YES | ResETC, ResCar, ResFlights, ResBonusWeeks, ResHomeLocation, ResDeals |
| rank | int | 3(10, 0) | NO | EmployeeDetails |
| RCI | char | 15 | YES | CustomerDetails |
| REP | char | 20 | YES | CustomerDetails |
| resDate | datetime | 0 | NO | Reservations |
| resNum | int | 3(10, 0) | NO | ResBonusWeeks, ResETC, ResHomeLocation, ResFlights, ResCar, Reservations, ResDeals |
| resStatus | int | 3(10, 0) | NO | ResFlights, ResHomeLocation, ResBonusWeeks, ResDeals, Reservations, ResCar, ResETC |
| season | int | 3(10, 0) | NO | CustomerDetails |
| seasonType | char | 30 | NO | Season |
| serialNum | int | 3(10, 0) | NO | ResStatus, ResETC, ResCar, ResFlights, ResBonusWeeks, ResHomeLocation, ResDeals |
| serialNumber | char | 10 | NO | CustomerDetails |
| serialNumber | int | 3(10, 0) | NO | Season, DealStatus, SuiteSize, Line |
| serialNumber | nvarchar | 9 | NO | EmployeeDetails |
| Ssize | int | 3(10, 0) | NO | SuiteSize |
| startDate | datetime | 0 | NO | ResCar |
| status | int | 3(10, 0) | NO | CustomerDetails |
| statusType | char | 30 | NO | ResStatus, DealStatus |
| suiteSize | int | 3(10, 0) | NO | ResBonusWeeks |
| TakeOver | char | 20 | YES | CustomerDetails |
| totalPrice | float | 5(53, 0) | YES | Reservations |
| trade | char | 30 | YES | CustomerDetails |
| type | char | 20 | NO | Ranks |
| type | char | 10 | NO | Statuses |
| valid | int | 3(10, 0) | NO | EmployeeDetails |
| weekNum | int | 3(10, 0) | NO | ResBonusWeeks, ResHomeLocation |
| zipCode | int | 3(10, 0) | YES | CustomerDetails, EmployeeDetails |