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