d

Tables (3)

book

  • Key (book_id) — biginit — Primary key — NOT NULL
  • Field (is_available) — bit
  • 언어 (language) — varchar
  • 출판사 (publisher) — varchar
  • 제목 (title) — varchar
  • 저자 (writer) — varchar

member

  • Key (member_id) — bigint — Primary key — NOT NULL
  • 주소 (address) — varchar
  • 성별 (gender) — varchar
  • 이름 (name) — varchar
  • 전화번호 (phone_number) — varchar
  • 주민번호 (resident_registration_number) — varchar

rental

  • Key (id) — bigint — Primary key — NOT NULL
  • 대출일 (due_Date) — date
  • 반납상태 (is_returned) — bit
  • 책존재여부 (is_available) — bit
  • 반납일 (returned_date) — timestamp
  • Key (book_id) — biginit — Foreign key → book.Key — NOT NULL
  • Key (member_id) — bigint — Foreign key → member.Key — NOT NULL