1223
Tables (5)
Untitled (BOOK)
- Key (bookID) — (char15) — Primary key — NOT NULL
- Field (Title) — (char15)
- Field (Author) — (char15)
- Field (PublishYear) — (date)
- Field (Genre) — (char15)
- Field (AgeGroup) — (int10)
- Field (Description) — (char30)
- Field (User) — (char15)
Untitled (USER)
- Key (UserID) — (char15) — Primary key — NOT NULL
- Field (Name) — (char10)
- Field (Age) — (int)
- Field (Email) — varchar(255)
- Field (Role) — (char15)
- Field (Loan) — (int10)
Untitled (LOAN)
- Key (LoanID) — (char15) — Primary key — NOT NULL
- Key (bookID) — (char15) — Foreign key → Untitled.Key — NOT NULL
- Key (UserID) — (char15) — Foreign key → Untitled.Key — NOT NULL
- Field (LoanDate) — (date)
- Field (DueDate) — (date)
- Field (ReturnDate) — (date)
- Field (Status) — (char10)
- Field (Reservation) — (char10)
Untitled (REVIEW)
- Key (bookID) — (char15) — Foreign key → Untitled.Key — NOT NULL
- Key (UserID) — (char15) — Foreign key → Untitled.Key — NOT NULL
- Field (Rating) — (int)
- Field (Comment) — (char100)
- Field (ReviewDate) — (date)
Untitled (RESERVATION)
- Key (bookID) — (char15) — Foreign key → Untitled.Key — NOT NULL
- Key (UserID) — (char15) — Foreign key → Untitled.Key — NOT NULL
- Field (ReservationDate) — (date)
- Field (Status) — (char10)
- Field (BookReview) — (char300)