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)