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)