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