서점zip
테이블 (10)
BookReview (도서리뷰)
- bookreiew_id (bookreview_id) — NOT NULL — 기본 키 — NOT NULL
- book_rating — NOT NULL
- bookreview_text — NOT NULL
- created_at (creted_at) — NOT NULL
- updated_at — NOT NULL
- member_id — NOT NULL — 외래 키 → Member.member_id — NOT NULL
- book_id — NOT NULL — 외래 키 → Books.book_id — NOT NULL
- indepbook_id — NOT NULL — 외래 키 → IndepBooks.indepbook_id — NOT NULL
BookReviewLikes (좋아요한 도서리뷰)
- id — NOT NULL — 기본 키 — NOT NULL
- created_at — NOT NULL
- member_id — NOT NULL — 외래 키 → Member.member_id — NOT NULL
- bookreview_id — NOT NULL — 외래 키 → BookReview.bookreiew_id — NOT NULL
Bookiechat (부키대화)
- bookie_id — NOT NULL — 기본 키 — NOT NULL
- user_message (usermessage) — NOT NULL
- bookie_response — NOT NULL
- created_at (created_ate) — NOT NULL
- member_id — NOT NULL — 외래 키 → Member.member_id — NOT NULL
Books (도서)
- book_id — NOT NULL — 기본 키 — NOT NULL
- author — NOT NULL
- book_image_url — NOT NULL
- book_name — NOT NULL
- book_content — NOT NULL
- publisher — NOT NULL
BookstoreIndepBook (보유 독립서적)
- bookstore_id — NOT NULL — 외래 키 → Bookstores.bookstore_id — NOT NULL
- indepbook_id — NOT NULL — 외래 키 → IndepBooks.indepbook_id — NOT NULL
BookstoreReivew (서점리뷰)
- bookstorereview_id — NOT NULL — 기본 키 — NOT NULL
- rating — NOT NULL
- text — NOT NULL
- image_url — NOT NULL
- created_at — NOT NULL
- member_id — NOT NULL — 외래 키 → Member.member_id — NOT NULL
- bookstore_id — NOT NULL — 외래 키 → Bookstores.bookstore_id — NOT NULL
Bookstores (서점)
- bookstore_id — NOT NULL — 기본 키 — NOT NULL
- name — NOT NULL
- address — NOT NULL
- hours — NOT NULL
- description — NOT NULL
- keyword (keword) — NOT NULL
- latitude — NOT NULL
- longitude (longtityde) — NOT NULL
- phone — NOT NULL
- rating — NOT NULL
IndepBooks (독립서적)
- indepbook_id — NOT NULL — 기본 키 — NOT NULL
- author — NOT NULL
- book_image_url — NOT NULL
- book_name — NOT NULL
- book_content — NOT NULL
- publisher — NOT NULL
Member (회원)
- member_id — NOT NULL — 기본 키 — NOT NULL
- email — NOT NULL
- password — NOT NULL
- join_type — NOT NULL
- nickname — NOT NULL
- social_id — NULL
- created_at — NOT NULL
- updated_at — NOT NULL
- temp_password — NOT NULL
PickedBook (회원책장)
- id — NOT NULL — 기본 키 — NOT NULL
- created_at — NOT NULL
- member_id — NOT NULL — 외래 키 → Member.member_id — NOT NULL
- book_id — NOT NULL — 외래 키 → Books.book_id — NOT NULL