학원프로젝트
테이블 (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