학원프로젝트

테이블 (9)

book

  • book_id — number — 기본 키 — NOT NULL
  • book_name — varchar2
  • writer — varchar2
  • publisher — varchar2
  • book_summary — varchar2
  • book_link — varchar2
  • book_img — varchar2

book_grade

  • book_id — number — 외래 키 → book.book_id — NOT NULL
  • book_good — number
  • book_neut — number
  • book_bad — number

book_tag

  • book_id — number — 외래 키 → book.book_id — NOT NULL
  • book_name — varchar2
  • genre_poet (Field) — number
  • genre_essay — number
  • genre_selfDev — number
  • genre_history — number
  • genre_science — number
  • genre_novel — number
  • genre_comics — number
  • genre_art — number
  • Field2

favorite

  • book_id — number — 외래 키 → book.book_id — NOT NULL
  • member_id — varchar2 — 외래 키 → member.member_id

member

  • member_id — varchar2 — 기본 키
  • member_nick — varchar2 — NOT NULL
  • member_pw — varchar2
  • member_genre — varchar2
  • member_photo — varchar2
  • member_phone — varchar2
  • member_goal — number
  • member_email — varchar2

member_grade

  • book_id — number — 외래 키 → book.book_id — NOT NULL
  • member_id — varchar2 — 외래 키 → member.member_id
  • graded — number

record

  • book_id — number — 외래 키 → book.book_id — NOT NULL
  • member_id — varchar2 — 외래 키 → member.member_id
  • Field (book_name) — varchar2
  • Field (start_time) — date
  • Field (end_time) — date
  • Field (isreading) — number

review

  • book_id — number — 외래 키 → book.book_id — NOT NULL
  • member_id — varchar2 — 외래 키 → member.member_id
  • Field (review_id) — number
  • Field (review_content) — varchar2
  • Field (review_likes) — number
  • Field (logdate) — date

search

  • member_id — varchar2 — 외래 키 → member.member_id
  • Field (search) — varchar2
  • Field (logtime) — date