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