Library

Tables (7)

BOOK (도서)

  • Key (BookId) — VARCHAR(100) — Foreign key → LIBRARY.Key — NOT NULL
  • Field (Title) — VARCHAR(200)
  • Field2 (Author) — VARCHAR(20)
  • Field3 (Publisher) — VARCHAR(100)
  • Field4 (ISBN) — VARCHAR(20)

CUSTOMER (고객)

  • CustomerID (CustomerId) — INT — Primary key — NOT NULL
  • Name — VARCHAR(30)
  • Tel — VARCHAR(30)
  • Address — VARCHAR(200)

Extension (연장)

  • Key (ExtensionId) — INT — Primary key — NOT NULL
  • Field2 (start_date) — DATE
  • Field (end_date) — DATE
  • Field (fee) — INT
  • Field (ExtensionDate) — DATE
  • Key (LoanId) — INT — Foreign key → Loan.Key — NOT NULL

LIBRARY (도서관)

  • Key (BookId) — VARCHAR(100) — Primary key — NOT NULL
  • Field (TotalCount) — INT
  • Field2 (StockCount) — INT

Loan (대출)

  • Key (LoanId) — INT — Primary key — NOT NULL
  • Field (LoanDate) — DATE
  • Field2 (DueDate) — DATE
  • Field (ReturnDate) — SYSDATE
  • CustomerID (CustomerId) — INT — Foreign key → CUSTOMER.CustomerID — NOT NULL
  • Key (ReservationId) — INT — Foreign key → Reservation.Key — NOT NULL

Reservation (예약)

  • Key (ReservationId) — INT — Primary key — NOT NULL
  • Field (ReservationDate) — DATE
  • Field2 (ExpectedSupplyDate) — DATE

Return (반납)

  • Key (return_id) — Primary key — NOT NULL
  • Field (return_date)
  • Key (LoanId) — INT — Foreign key → Loan.Key — NOT NULL