school

Tables (4)

BOOK

  • book_id — INT — Primary key — NOT NULL
  • book_title — VARCHAR(200) — NOT NULL
  • author — VARCHAR(100) — NOT NULL
  • publisher — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • total_count — INT — NOT NULL
  • available_count — INT — NOT NULL

LOAN

  • loan_id — INT — Primary key — NOT NULL
  • book_id — INT — Foreign key → BOOK.book_id — NOT NULL
  • member_id — INT — Foreign key → MEMBER.member_id — NOT NULL
  • loan_date — DATE — NOT NULL
  • due_date — DATE — NOT NULL
  • loan_status — VARCHAR(20) — NOT NULL

MEMBER

  • member_id — INT — Primary key — NOT NULL
  • member_name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • join_date — DATE — NOT NULL
  • member_status — VARCHAR(20) — NOT NULL

RETURN

  • return_id — INT — Primary key — NOT NULL
  • loan_id — INT — Foreign key → LOAN.loan_id — NOT NULL
  • return_date — DATE — NOT NULL
  • overdue_days — INT — NOT NULL
  • overdue_fee — INT — NOT NULL