etc

Tables (3)

bookTBL

  • bookId — VARCHAR(45) — Primary key — NOT NULL
  • bookTitle — VARCHAR(45)
  • bookAuthor — VARCHAR(45)
  • bookPublish — VARCHAR(45)
  • createDt — date — NOT NULL

customerTBL

  • customerId — VARCHAR(45) — Primary key — NOT NULL
  • customerName — VARCHAR(45) — NOT NULL
  • customerRank — VARCHAR(45) — NOT NULL
  • createDt — date — NOT NULL

rentalTBL

  • rentalId — VARCHAR(45) — Primary key — NOT NULL
  • bookId (bookId2) — VARCHAR(45) — Foreign key → bookTBL.bookId — NOT NULL
  • customerId (customerId2) — VARCHAR(45) — Foreign key → customerTBL.customerId — NOT NULL
  • createDt — date — NOT NULL