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