dailyquiz

테이블 (7)

대여 (rental)

  • Rental_id (rental_id) — INT — 기본 키 — NOT NULL
  • Book_id (bookid) — INT — 외래 키 → 도서.Book_id — NOT NULL — FK
  • Memeber_id (member_id) — INT — 외래 키 → 회원.Memeber_id — NOT NULL — FK
  • Rental_at (rental_at) — DATETIME
  • Return_at (return_at) — DATETIME
  • Loan (loan) — BOOLEAN
  • Extenstione (extension) — DATETIME

도서 (book)

  • Book_id (bookid) — INT — 기본 키 — NOT NULL
  • Reservatioin (reservation) — BOOLEAN

도서분류 (bookClassification)

  • Symbol (symbol) — VARCHAR(1000) — 기본 키 — NOT NULL
  • name — VARCHAR(1000)

도서정보 (bookInfromation)

  • ISBN — INT — 기본 키 — NOT NULL
  • Symbol (symbol) — VARCHAR(1000) — 외래 키 → 도서분류.Symbol — NOT NULL — FK
  • Author (author) — VARCHAR(100)
  • Publisher (publisher) — VARCHAR(500)
  • Dated (ate) — DATETIME
  • Name (name) — VARCHAR(500)

부록 (supplement)

  • code — INT — 기본 키 — NOT NULL
  • ISBN — INT — 외래 키 → 도서정보.ISBN — NOT NULL — FK
  • Book_id (bookid) — INT — 외래 키 → 도서.Book_id — NOT NULL — FK
  • Name (name) — VARCHAR(100)

예약 (reservation)

  • Reservation_at (reservation_at) — DATETIME — 기본 키 — NOT NULL
  • Book_id (bookid) — INT — 외래 키 → 도서.Book_id — NOT NULL
  • Memeber_id (member_id) — INT — 외래 키 → 회원.Memeber_id — NOT NULL

회원 (member)

  • Memeber_id (member_id) — INT — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(100)
  • Number (number) — VARCHAR(200)
  • Rank (rank) — INT
  • Address (address) — VARCHAR(1000)
  • Phone (phone) — VARCHAR(1000)
  • Email (email) — VARCHAR(1000)