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