책

테이블 (3)

book

  • book_no (Key) — char(10) — 기본 키 — NOT NULL
  • book_name (Field) — varchar2(40)
  • book_writer (Field2) — varchar2(40)
  • book_publisher (Field3) — varchar2(40)

loan (Untitled2)

  • member_id (Key) — char(10) — 외래 키 → member.member_id — NOT NULL
  • book_no (Key2) — char(10) — 외래 키 → book.book_no — NOT NULL
  • loan_date (Field) — date
  • loan_return_expect (Field2) — date
  • loan_return (Field3) — date

member (Untitled)

  • member_id (Key) — char(10) — 기본 키 — NOT NULL
  • member_pswd (Field) — char(11)
  • member_name (Field2) — varchar2(30)
  • member_tel (Field3) — char(11) — NOT NULL
  • member_birth (Field4) — date — NOT NULL