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