library

Tables (3)

Book (책)

  • id — Primary key — NOT NULL
  • title (제목)
  • author (저자)
  • published_date (출판일)
  • created_at (생성일자)
  • modified_at (수정일자) — NULL
  • modified_by (수정자) — NULL
  • deleted_by (삭제자) — NULL
  • deleted_at (삭제일자) — NULL

Loan (대출)

  • id — Primary key — NOT NULL
  • loan_date (대출일자)
  • due_date (반납일자)
  • return_date (실제 반납일) — NULL
  • status (대출 상태)
  • user_id (사용자 id) — Foreign key → User.id — NOT NULL
  • book_id (책 id) — Foreign key → Book.id — NOT NULL

User (사용자)

  • id — Primary key — NOT NULL
  • name (사용자 이름)
  • email (이메일)
  • created_at (생성일자)
  • is_admin (운영자여부)