Library Exercise

Tables (4)

Book (도서)

  • id (아이디) — Long — Primary key — NOT NULL
  • title (제목) — String
  • author (작가) — String
  • publisher (츨판사) — String
  • publicationYear (간행년도) — Long
  • classification (구분) — String
  • status (상태) — String

Loan/Return (대출/반납)

  • number (번호) — Long — Primary key — NOT NULL
  • member_id (회원 아이디) — Long — Foreign key → Member.id — NOT NULL
  • book_id (도서 아이디) — Long — Foreign key → Book.id — NOT NULL
  • loanDate (대출날짜) — String
  • dueDate (반납기한) — String
  • renewalCount (반납연장횟수) — Long
  • isReturned (반납여부) — Boolean

Member (회원)

  • id (아이디) — Long — Primary key — NOT NULL
  • name (이름) — String
  • feature (특징) — Stirng
  • email (이메일) — String
  • phoneNumber (핸드폰번호) — String
  • idNumber (회원번호) — Long

PurchaseApplication (구입신청)

  • id (아이디) — Long — Primary key — NOT NULL
  • member_id (회원 아이디) — Long — Foreign key → Member.id — NOT NULL
  • title (제목) — String
  • author (작가) — String
  • publisher (출판사) — String
  • publicationYear (간행년도) — Long
  • purchaseRequestCount (구입신청요청횟수) — Long