도서관리 (중급)

테이블 (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