ex_04
Tables (7)
ACTOR (Untitled7)
- ACTORId (Key) — char(10) — Primary key — NOT NULL
- MovieName (Key2) — char(20) — Foreign key → MOVIE.MovieName — NOT NULL
- ActorName (Field) — char(10)
- AssociatedMovie (Field2) — char(30)
- ActorBiographic (Field3) — char(60)
CUSTOMER (Untitled)
- CustomerID (Key) — char(10) — Primary key — NOT NULL
- Name (Field) — char(15)
- Phone (Field2) — char(11)
- Address (Field3) — char(30)
- FirstRental (Field5) — date
- RentHistory (Field4) — int
- LateFee (Field6)
DIRECTOR (Untitled8)
- DirectorID (Key) — char(10) — Primary key — NOT NULL
- MovieName (Key2) — char(20) — Foreign key → MOVIE.MovieName — NOT NULL
- DirectorName (Field) — char(20)
- DirectorsFilm (Field2) — char(30)
- DirectorBiographic (Field3) — char(60)
DVD (Untitled2)
- DVDCode (Key) — char(10) — Primary key — NOT NULL
- DateOfPurchase (Field2) — date
- reservation (Field3) — char(2)
- VideoQuantity (Field4) — int
- MovieName (Key2) — char(20) — Foreign key → MOVIE.MovieName — NOT NULL
MOVIE (Untitled6)
- MovieName (Key) — char(20) — Primary key — NOT NULL
- YearMade (Field) — date
RENT (Untitled4)
- RentCode (Key) — char(10) — Primary key — NOT NULL
- RentDay (Field) — date
- ReturnDay (Field2) — date
- NumberOfRentals (Field3) — int
- TimesOfRentals (Field4) — int
- RentPrice (Field5) — int
- CustomerID (Key2) — char(10) — Foreign key → CUSTOMER.CustomerID — NOT NULL
- DVDCode (Key3) — char(10) — Foreign key → DVD.DVDCode — NOT NULL
RESERVATION (Untitled5)
- ReservationOder (Key) — int — Primary key — NOT NULL
- CustomerID (Key2) — char(10) — Foreign key → CUSTOMER.CustomerID — NOT NULL
- OderOfReservation (Field) — int