book
Tables (8)
books (도서)
- book_no (책번호) — PK — Primary key — NOT NULL
- author (저자) — NOT NULL
- publisher (출판사) — NOT NULL
- book_hiredate (출판일) — NOT NULL
- book_price (가격) — NOT NULL
- books_count (수량) — NOT NULL
- book_name (책이름) — UNIQUE — NOT NULL
- genre_name (장르) — FK — Foreign key → genre.genre_name — NOT NULL
delivery (배송상태)
- sales_no (판매번호) — PK — Foreign key → salesdata.sales_no — NOT NULL
- member_no (회원번호) — PK — Foreign key → member.member_no — NOT NULL
- book_no (책번호) — PK — Foreign key → books.book_no — NOT NULL
- status (배송상태) — NOT NULL — NOT NULL
genre (책장르)
- genre_name (장르) — PK — Primary key — NOT NULL
member (회원)
- member_no (회원번호) — PK — Primary key — NOT NULL
- name (이름) — NOT NULL
- home_hp (집전화)
- phone_hp (핸드폰) — NOT NULL
- address_number (우편번호) — NOT NULL
- address (주소) — NOT NULL
- member_hiredate (회원가입날짜) — NOT NULL
- member_id (Key) — UNIQUE — NOT NULL
- resident_number (주민등록번호) — UNIQUE
- member_pass (비밀번호) — NOT NULL
pointcalculation (포인트적립내역)
- sales_no (판매번호) — PK — Foreign key → salesdata.sales_no — NOT NULL
- point_earned (포인트적립)
- member_no (회원번호) — PK — Foreign key → member.member_no — NOT NULL
- book_no (책번호) — PK — Foreign key → books.book_no — NOT NULL
pointmember (사용가능포인트)
- member_no (회원번호) — PK FK — Foreign key → member.member_no — NOT NULL
- point_earned (적립포인트)
review (회원리뷰)
- review_no (리뷰번호) — PK — Primary key — NOT NULL
- review_data (리뷰내용)
- member_no (회원번호) — FK — Foreign key → member.member_no — NOT NULL
- book_no (책번호) — FK — Foreign key → books.book_no — NOT NULL
salesdata (판매량)
- sales_no (판매번호) — PK — Primary key — NOT NULL
- saleshire (판매일) — NOT NULL
- book_no (책번호) — FK — Foreign key → books.book_no — NOT NULL