FinalProject

Tables (7)

ADDRESS (Untitled5)

  • zipCode (Key) — char(5) — Primary key — NOT NULL
  • address (Field) — char(50)
  • address2 (Field2) — char(30)

AUTHOR (Untitled6)

  • authorID (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(30)
  • description (Field2) — char(50)

BOOK (Untitled3)

  • bookNO (Key) — char(10) — Primary key — NOT NULL
  • title (Field) — char(50)
  • pubYMD (Field2) — date
  • publisher (Field3) — char(20)
  • ISBN (Field4) — char(13)
  • price (Field5) — int(6)

BOOK_AUTHOR (Untitled7)

  • bookNO (Key) — char(10) — Foreign key → BOOK.bookNO — NOT NULL
  • authorID (Key2) — char(10) — Foreign key → AUTHOR.authorID — NOT NULL

BOOK_RENT (Untitled2)

  • rentNO (Key) — char(10) — Primary key — NOT NULL
  • rentDate (Field) — date
  • returnDate (Field2) — date
  • userID (Key2) — char(10) — Foreign key → LIBUSER.userID — NOT NULL
  • bookNO (Key3) — char(10) — Foreign key → BOOK.bookNO — NOT NULL

BOOK_REQUEST (Untitled4)

  • requestNO (Key) — char(10) — Primary key — NOT NULL
  • userID (Key2) — char(10) — Foreign key → LIBUSER.userID — NOT NULL
  • bookNO (Key3) — char(10) — Foreign key → BOOK.bookNO — NOT NULL
  • requestDate — date

LIBUSER (Untitled)

  • userID (Key) — char(10) — Primary key — NOT NULL
  • uesrName (Field) — char(20)
  • gender (Field2) — char(1)
  • enrollYMD (Field3) — date
  • userType (Field4) — char(1)
  • zipCode (Key2) — char(5) — Foreign key → ADDRESS.zipCode — NOT NULL