서점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