Library
Tables (4)
book (도서)
- id (PK) — Integer — Primary key — NOT NULL
- title (도서명) — String
- author (저자) — String
- publisher (출판사) — String
member (회원)
- id (PK) — Integer — Primary key — NOT NULL
- name (이름) — String
- tel_number (전화번호) — Phone Number
- email (이메일) — Email
- password (비밀번호) — Password
rent (대여)
- id (PK) — Integer — Primary key — NOT NULL
- book_id (FK1) — Integer — Primary key — NOT NULL
- member_id (FK2) — Integer — Foreign key → member.id — NOT NULL
- rent_date (대출날짜) — Date
- return_date (반납날짜) — Date
reservation (예약)
- id (PK) — INT — Primary key — NOT NULL
- member_id (Field) — INT
- loan_id (Field2) — INT
- Field3 (예약순번) — INT