goorm_daily_mission
Tables (3)
books
- book_id — TEXT
- isbn — TEXT
- title — TEXT — NOT NULL
- author — TEXT — NOT NULL
- publisher — TEXT
- is_available — INTEGER — NOT NULL
borrowings
- borrow_id — TEXT
- member_id — TEXT — Foreign key → members.member_id — NOT NULL
- book_id — TEXT — Foreign key → books.book_id — NOT NULL
- borrowed_at — TEXT — NOT NULL
- due_date — TEXT — NOT NULL
- returned_at — TEXT
- status — TEXT — NOT NULL
members
- member_id — TEXT
- name — TEXT — NOT NULL
- phone — TEXT — NOT NULL
- join_date — TEXT — NOT NULL
- status — TEXT — NOT NULL