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)