library
Tables (3)
Book (도서)
- id (책 고유 id) — BIGINT — Primary key — NOT NULL
- title (제목) — VARCHAR
- author (작가) — VARCHAR
- is_available (대여 가능 여부) — BOOLEAN
- created_at (등록일) — DATETIME
- Field — DATETIME
Rental (대여)
- id (대여 기록 ID) — BIGINT — Primary key — NOT NULL
- id (회원고유id) — BIGINT — Foreign key → User.id
- id (책 고유 id) — BIGINT — Foreign key → Book.id — NOT NULL
- rent_date (대여 일자) — DATETIME
- return_date (반납 일자) — DATETIME
User (유저)
- id (회원고유id) — BIGINT — Primary key
- name (이름) — VARCHAR
- email (이메일) — VARCHAR
- phone (전화번호) — VARCHAR
- created_at (가입일) — DATETIME
- updated_at (수정일) — DATETIME