ERD_BOOK

Tables (3)

book (Untitled2)

  • book_no (책번호) — number — Primary key — NOT NULL — seq로 입력
  • book_category (책장르) — varchar2(30) — NOT NULL
  • book_name (책이름) — varchar2(100) — NOT NULL
  • book_writer (작가) — varchar2(40) — NOT NULL
  • book_count (책수량) — number — NOT NULL

member (Untitled)

  • member_no (회원번호) — number — Primary key — NOT NULL — seq로 입력
  • member_id (회원아이디) — varchar2(20) — NOT NULL
  • member_pw (회원비밀번호) — varchar2(30) — NOT NULL
  • member_name (회원이름) — varchar2(20) — NOT NULL
  • member_grade (직원/회원) — char(6) — NOT NULL — 직원/회원만 입력

rental (Untitled3)

  • rental_no (대여번호) — number — Primary key — NOT NULL — seq로 입력
  • rental_date (대여날짜) — date — NOT NULL
  • return_date (반납날짜) — date — NOT NULL — rental_date + 3일
  • member_no (회원번호) — number — Foreign key → member.member_no — NOT NULL
  • rental_yn (반납여부) — char(1) — NOT NULL — Y/N만 입력
  • book_no (책번호) — number — Foreign key → book.book_no — NOT NULL