library
Tables (3)
History (history)
- member_id (Key) — Foreign key → Membership.member_id — NOT NULL
- book_id (Key2) — integer — Foreign key → book.book_id — NOT NULL
- rent (Field) — date
- return (Field2) — date
Membership (membership)
- member_id (Key) — Primary key — NOT NULL
- name (Field) — varchar(50)
- phone_number (Field2) — varchar(100)
- address (Field3) — varchar(200)
- age (Field4) — int
- member_pw (Field5) — varchar(100)
book
- book_id (Key) — integer — Primary key — NOT NULL
- title (Field) — varchar(100)
- author (Field2) — varchar(50)
- pub (Field3) — varchar(100)
- pub_date (Field4) — date