Book

Tables (5)

Book (book)

  • 책번호 (book_id) — NOT NULL — Primary key — NOT NULL
  • 책이름 (book_name) — NOT NULL
  • 저자 (book_writer) — NOT NULL
  • 출판사 (book_publisher) — NOT NULL

Member (mem)

  • 회원번호 (mem_id) — NOT NULL — Primary key — NOT NULL
  • 회원명 (mem_name) — NOT NULL — NOT NULL
  • 생년월일 (mem_brithday) — NULL — NOT NULL
  • 전화번호 (mem_phone) — NULL
  • 등급 (mem_grade) — NOT NULL

Untitled (Rental)

  • 책대여번호 (book_rent_no) — NOT NULL — Primary key — NOT NULL
  • 대여일자 (rent_dt) — NOT NULL
  • 예정반납일자 (ex_rent_dt) — NOT NULL
  • 실제반납일자 (actually_rent_dt) — NOT NULL
  • 회원번호 (mem_id) — NOT NULL — Foreign key → Member.회원번호 — NOT NULL
  • 책번호 (book_id) — NOT NULL — Foreign key → Book.책번호 — NOT NULL

Untitled (Review)

  • 작성일자 (writet_dt) — NOT NULL — Primary key — NOT NULL
  • 책대여번호 (book_rent_no) — NOT NULL — Foreign key → Untitled.책대여번호 — NOT NULL
  • 책후기내용 (book_rivew) — NOT NULL

Untitled