asd
Tables (4)
CreditCards
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Members.Key — NOT NULL
- MemberID — VARCHAR(10)
- CardNumber — VARCHAR(16)
- ExpirationDate — VARCHAR(7)
Flights
- Key — Primary key — NOT NULL
- FlightNumber — VARCHAR(10)
- DepartureDate — DATE
- DepartureTime — TIME
Members
- Key — Primary key — NOT NULL
- MemberID — VARCHAR(10)
- Password — VARCHAR(20)
- Name — VARCHAR(50)
Seats
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → Flights.Key — NOT NULL
- SeatNumber — VARCHAR(10)
- Class — VARCHAR(20)
- FlightNumber — VARCHAR(10)
- Key (Key3) — Foreign key — NOT NULL