데이터베이스 과제

테이블 (5)

Books

  • book_id — INT — 기본 키
  • title — VARCHAR(255) — NOT NULL
  • author — VARCHAR(255)
  • available_quantity — INT — NOT NULL
  • available_date — DATE

Customers

  • customer_id — INT — 기본 키
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255)
  • phone_number — VARCHAR(20)

Extensions

  • extension_id — INT — 기본 키
  • rental_id — INT — 외래 키 → Rentals.rental_id
  • extension_date — DATE — NOT NULL
  • new_due_date — DATE — NOT NULL
  • extension_fee — DECIMAL(10, 2)

Fees

  • fee_id — INT — 기본 키
  • extension_id — INT — 외래 키 → Extensions.extension_id
  • extension_period — INT
  • fee_amount — DECIMAL(10, 2)

Rentals

  • rental_id — INT — 기본 키
  • customer_id — INT — 외래 키 → Customers.customer_id
  • book_id — INT — 외래 키 → Books.book_id
  • rental_date — DATE — NOT NULL
  • due_date — DATE — NOT NULL
  • return_date — DATE
  • extension_count — INT