Library

Tables (4)

book (도서)

  • id (PK) — Integer — Primary key — NOT NULL
  • title (도서명) — String
  • author (저자) — String
  • publisher (출판사) — String

member (회원)

  • id (PK) — Integer — Primary key — NOT NULL
  • name (이름) — String
  • tel_number (전화번호) — Phone Number
  • email (이메일) — Email
  • password (비밀번호) — Password

rent (대여)

  • id (PK) — Integer — Primary key — NOT NULL
  • book_id (FK1) — Integer — Primary key — NOT NULL
  • member_id (FK2) — Integer — Foreign key → member.id — NOT NULL
  • rent_date (대출날짜) — Date
  • return_date (반납날짜) — Date

reservation (예약)

  • id (PK) — INT — Primary key — NOT NULL
  • member_id (Field) — INT
  • loan_id (Field2) — INT
  • Field3 (예약순번) — INT