book_admin

Tables (3)

book (Untitled)

  • book_no (number) — Primary key — NOT NULL
  • book_name (varchar2(30))
  • book_writer (varxhar2(30))
  • book_company (Field3)
  • Field4

book_loan (Untitled3)

  • m_id (char(6)) — Foreign key → member.m_id — NOT NULL
  • book_no (number) — Foreign key → book.book_no — NOT NULL
  • book_loan_date (date) — sysdate+3
  • book_return_date (Field3)

member (Untitled2)

  • m_id (char(6)) — Primary key — NOT NULL
  • m_passwd (char(128))
  • m_name (varchar2(30))
  • m_tel_no (char(11))
  • m_birth_date (date)