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