책
테이블 (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