03_27_daliyquiz

Tables (7)

Book (Untitled2)

  • book_number (Key) — VARCHAR(20) — Primary key — NOT NULL
  • reservation_status (Field) — BOOLEAN — NOT NULL
  • ISBN (Key2) — VARCHAR(30) — Foreign key → Book Information.ISBN — NOT NULL

Book Classification (Untitled7)

  • classification_symbol (Key) — VARCHAR(30) — Primary key — NOT NULL
  • classification_name (Field) — VARCHAR(40) — NOT NULL

Book Information (Untitled5)

  • ISBN (Key) — VARCHAR(30) — Primary key — NOT NULL
  • classification_symbol (Key2) — VARCHAR(30) — Foreign key → Book Classification.classification_symbol — NOT NULL
  • author (Field) — VARCHAR(50) — NOT NULL
  • publisher (Field2) — VARCHAR(50) — NOT NULL
  • publication_date (Field3) — BIGINT(20) — NOT NULL
  • book_name (Field4) — VARCHAR(50) — NOT NULL

Loan (Untitled3)

  • rental_number (Key3) — BIGINT(20) — Primary key — NOT NULL
  • member_number (Key) — BIGINT(20) — Foreign key → Member.member_number — NOT NULL — 회원번호
  • book_number (Key2) — VARCHAR(20) — Foreign key → Book.book_number — NOT NULL
  • loan_date (Field) — DATETIME — NOT NULL
  • return_date (Field2) — DATETIME — NOT NULL — 반납일자
  • loan_status (Field3) — BOOLEAN
  • extended_period (Field4) — BINGINT(10) — 연장

Member (Untitled)

  • member_number (Key) — BIGINT(20) — Primary key — NOT NULL — 회원번호
  • name (Field) — VARCHAR(50) — NOT NULL
  • resident_number (Field2) — VARCHAR(20) — NOT NULL — 주민번호
  • address (Field3) — VARCHAR(200)
  • phone_number (Field4) — VARCHAR(20)
  • email (Field5) — VARCHAR(100)
  • membership_grade (Field6) — VARCHAR(10) — NOT NULL — 회원등급

Reservation (Untitled4)

  • reservation_date (Key3) — DATETIME — Primary key — NOT NULL
  • member_number (Key) — VARCHAR(20) — Foreign key → Member.member_number — NOT NULL — 회원번호
  • book_number (Key2) — VARCHAR(20) — Foreign key → Book.book_number — NOT NULL

Supplement (Untitled6)

  • supplement_code (Key2) — VARCHAR(20) — Primary key — NOT NULL
  • book_number (Key) — VARCHAR(20) — Foreign key → Book.book_number — NOT NULL
  • supplement_name (Field) — VARCHAR(100) — NOT NULL