과제

테이블 (8)

Books

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

Customers (Customersㄴ)

  • customer_ids — INT
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255)
  • phone_number — VARCHAR(20)

Extensions (Extensions2)

  • extension_id — INT
  • rental_id — INT
  • extension_date — DATE — NOT NULL
  • new_due_date — DATE — NOT NULL
  • extension_fee — DECIMAL(10, 2)

Fees

  • fee_id — INT
  • extension_period — INT
  • fee_amount — DECIMAL(10, 2)

Rentalss

  • rental_id — INT
  • customer_id — INT
  • book_id — INT
  • rental_date — DATE — NOT NULL
  • due_date — DATE — NOT NULL
  • return_date — DATE
  • extension_count — INT

고객 (Customers)

  • 고객ID (customer_id) — INT — 기본 키 — NOT NULL
  • 이름 (name) — VARCHAR(255)

대출연장정보 (Extensions)

  • 사람ID (UserId) — NUMBER — 기본 키 — NOT NULL

대출정보 (Rentals)

  • 대출ID (rental_id) — INT — 기본 키 — NOT NULL
  • 고객ID (customer_id) — INT
  • 책ID (book_id) — INT
  • 대출일자 (rental_date) — DATE
  • 대출만료일자 (due_date) — DATE
  • 책 반납일 (return_date) — DATE
  • 대출 기간 연기 횟수 (extension_count) — INT
  • 고객ID (customer_id2) — INT — 외래 키 → 고객.고객ID — NOT NULL