video_rental

Tables (3)

Movie (movie)

  • movieNumber — NOT NULL — Primary key — NOT NULL
  • movieName — NOT NULL
  • nation — NOT NULL
  • pubYear — NOT NULL
  • rental (orderNumber) — NOT NULL
  • Field (rentalCharge) — NOT NULL
  • Field (rental) — NOT NULL
  • orderNumber (orderNumber2) — NOT NULL — Foreign key → Order.orderNumber — NOT NULL

Order (order)

  • orderNumber — NOT NULL — Primary key — NOT NULL
  • movieNumber (userNumber) — NOT NULL
  • Field2 (movieNumber) — NOT NULL
  • Field3 (orderDate) — NOT NULL
  • Field4 (returnDate) — NOT NULL
  • userNumber (userNumber2) — NOT NULL — Foreign key → User.userNumber — NOT NULL

User (user)

  • userNumber — NOT NULL — Primary key — NOT NULL
  • userName — NOT NULL
  • phoneNumber — NOT NULL
  • grade — NOT NULL
  • totalPaying — NOT NULL