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