도서관리 (중급)
테이블 (3)
Book (Untitled2)
- id (Key) — Long — 기본 키 — NOT NULL
- id (Field) — String
- title (Field2) — String
- author (Field3) — String
- isbn (Field4) — String
- availableCopies (Field5) — Integer
- totalCopies (Field6) — Integer
- createdAt (Field7) — LocalDateTime
- updatedAt (Field8) — LocalDateTime
Rental (Untitled3)
- id (Key) — Long — 기본 키 — NOT NULL
- userid (Field) — Integer
- bookid (Field2) — Integer
- rentalDate (Field3) — LocalDateTime
- returnDate (Field4) — LocalDateTime
- status (Field5) — Enum
- createdAt (Field6) — LocalDateTime
- updatedAt (Field7) — LocalDateTime
- id (Key2) — Long — 외래 키 → User.id — NOT NULL
- id (Key3) — Long — 외래 키 → Book.id — NOT NULL
User (Untitled)
- id (Key) — Long — 기본 키 — NOT NULL
- username (Field2) — String
- password (Field3) — String
- email (Field4) — String
- role (Field5) — Enum
- createdAt (Field6) — LocalDateTime
- updateAt (Field7) — LocalDateTime