book

Tables (3)

Untitled (member)

  • Key (member_id) — char(6) — Primary key — NOT NULL
  • Field (member_passwd) — char(6)
  • Field2 (member_name) — varchar2(30)
  • Field (member_tel) — char(11) — NOT NULL
  • Field2 (member_birth) — date — NOT NULL

Untitled2 (book)

  • Key (book_no) — char(11) — Primary key — NOT NULL
  • Field (book_name) — varchar2(120)
  • Field2 (book_writer) — varchar2(30)
  • Field (book_publisher) — varchar2(100)

Untitled3 (book_loan)

  • Key (book_no) — char(11) — Foreign key → Untitled2.Key — NOT NULL
  • Key (member_id) — char(6) — Foreign key → Untitled.Key — NOT NULL
  • Field (book_loan_date) — date
  • Field2 (book_loan_ex_return_date) — date
  • Field3 (book_loan_return_date) — date