DailyQuiz0327

Tables (7)

bonusBook (Untitled6)

  • code (Key) — NOT NULL — Primary key — NOT NULL
  • book_id (Key2) — NOT NULL — Foreign key → book.id — NOT NULL — book number
  • bonusBookName (Field) — NOT NULL

book (Untitled3)

  • id (Key) — NOT NULL — Primary key — NOT NULL — book number
  • bookInfo_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
  • bookName (Field4) — NOT NULL

booking (Untitled7)

  • bookingDate (Field) — NOT NULL
  • member_id (Key) — NOT NULL — Foreign key → member.id — NOT NULL
  • book_id (Key2) — NOT NULL — Foreign key → book.id — NOT NULL — book number

category (Untitled5)

  • type (Key) — NOT NULL — Primary key — NOT NULL
  • typeName (Field2) — NOT NULL

member (Untitled)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • name (Field) — NOT NULL
  • ssn (Field2) — NOT NULL — 주민번호 생년월일 8자리 ex)20110101
  • grade (Field3) — NOT NULL
  • address (Field4) — NOT NULL
  • phoneNum (Field5) — NOT NULL
  • email (Field6) — NOT NULL

rent (Untitled2)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • book_id (Key3) — NOT NULL — Foreign key → book.id — NOT NULL — book number
  • member_id (Key2) — NOT NULL — Foreign key → member.id — NOT NULL
  • rentDate (Field2) — NOT NULL
  • returnDate (Field3) — NOT NULL
  • rentBonusBook (Field4) — NOT NULL
  • extend (Field5) — NOT NULL