library

Tables (3)

Book (도서)

  • id (책 고유 id) — BIGINT — Primary key — NOT NULL
  • title (제목) — VARCHAR
  • author (작가) — VARCHAR
  • is_available (대여 가능 여부) — BOOLEAN
  • created_at (등록일) — DATETIME
  • Field — DATETIME

Rental (대여)

  • id (대여 기록 ID) — BIGINT — Primary key — NOT NULL
  • id (회원고유id) — BIGINT — Foreign key → User.id
  • id (책 고유 id) — BIGINT — Foreign key → Book.id — NOT NULL
  • rent_date (대여 일자) — DATETIME
  • return_date (반납 일자) — DATETIME

User (유저)

  • id (회원고유id) — BIGINT — Primary key
  • name (이름) — VARCHAR
  • email (이메일) — VARCHAR
  • phone (전화번호) — VARCHAR
  • created_at (가입일) — DATETIME
  • updated_at (수정일) — DATETIME