book_system
Tables (3)
book
- book_no (Key) — char(11) — Primary key — NOT NULL
- book_name (Field) — varchar2(100)
- book_writer (Field2) — varchar2(30)
- book_seller (Field3) — varchar2(100)
book_member (Untitled2)
- book_member_id (Key) — char(6) — Primary key — NOT NULL
- book_member_passwd (Key2) — varchar2(6) — NOT NULL
- book_member_name (Key3) — varchar2(30)
- book_member_tel (Field) — char(11) — NOT NULL
- book_member_birthday (Field2) — date — NOT NULL
book_rent (Untitled)
- book_member_id (Key2) — char(6) — Foreign key → book_member.book_member_id — NOT NULL
- book_no (Key) — char(11) — Foreign key → book.book_no — NOT NULL
- book_rent_date (Field2) — date — NOT NULL
- book_will_give_date (Field3) — date — NOT NULL
- book_rentend_date (Field4) — date