DailyQuiz0327
Tables (7)
bonusBook (Untitled6)
- code (Key) — NOT NULL — Primary key — NOT NULL
- book_no (Key2) — NOT NULL — Foreign key → book.no — NOT NULL
- bonusBookName (Field) — NOT NULL
book (Untitled3)
- no (Key) — NOT NULL — Primary key — NOT NULL
- ISBN (Key2) — NOT NULL — Foreign key → bookInfo.ISBN — NOT NULL
- isBooking (Field) — NOT NULL
bookInfo (Untitled4)
- ISBN (Key) — NOT NULL — Primary key — NOT NULL
- category_type (Key2) — NOT NULL — Foreign key → category.type — NOT NULL
- writer (Field) — NOT NULL
- publisher (Field2) — NOT NULL
- releaseDate (Field3) — NOT NULL
- name (Field4) — NOT NULL
booking (Untitled7)
- bookingDate (Key3) — NOT NULL — Primary key — NOT NULL
- member_id (Key) — NOT NULL — Foreign key → member.id — NOT NULL
- book_no (Key2) — NOT NULL — Foreign key → book.no — NOT NULL
category (Untitled5)
- type (Key) — NOT NULL — Primary key — NOT NULL
- typeName (Field) — NOT NULL
member (Untitled)
- id (Key) — NOT NULL — Primary key — NOT NULL
- name (Field) — NOT NULL
- ssn (Field2) — NOT NULL
- grade (Field3) — NOT NULL
- address (Field4) — NOT NULL
- phone (Field5) — NOT NULL
- email (Field6) — NOT NULL
rent (Untitled2)
- no (Key) — NOT NULL — Primary key — NOT NULL
- book_no (Key2) — NOT NULL — Foreign key → book.no — NOT NULL
- member_id (Key3) — NOT NULL — Foreign key → member.id — NOT NULL
- rentDate (Field) — NOT NULL
- returnDate (Field2)
- isRentBonusBook (Field3)
- isExtends (Field4)