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