flaneur

Tables (13)

Author (author)

  • ID (author_id) — INT — Primary key — NOT NULL
  • Name (author_name) — VARCHAR(30)
  • Field

Book (book)

  • ID (book_id) — INT — Primary key — NOT NULL
  • Name (book_name) — VARCHAR(255)
  • Author (book_author) — VARCHAR(30)
  • Publisher (book_pub) — VARCHAR(30)
  • Published Year (book_pubyear) — TINYINT(4)
  • ISBN (book_isbn) — VARCHAR(13) — NOT NULL
  • Book Image (book_image) — TEXT
  • Author ID (book_author_id) — INT

Book Comment (book_comment)

  • ID (bc_id) — INT — Primary key — NOT NULL
  • Book ID (book_id) — INT — Foreign key → Book.ID — NOT NULL
  • User ID (user_id) — INT — Foreign key → User.ID — NOT NULL
  • Comment (bc_comment) — VARCHAR(100)
  • Created Time (bc_created_time) — DATETIME
  • Last Modifed Time (bc_modified_time) — DATETIME
  • Upvote (bc_upvote) — INT

Book Tag (book_tag)

  • ID (bt_id) — INT — Primary key — NOT NULL
  • Name (bt_name) — VARCHAR(30)
  • Type (bt_type) — VARCHAR(30)

Book-BookTag (book_booktag)

  • ID (bbt_id) — INT — Primary key — NOT NULL
  • Book ID (book_id) — INT — Foreign key → Book.ID — NOT NULL
  • Tag ID (bt_id) — INT — Foreign key → Book Tag.ID — NOT NULL

BookShelf (bookshelf)

  • ID (shelf_id) — INT — Primary key — NOT NULL
  • Name (shelf_name) — VARCHAR(30)
  • Description (shelf_desc) — VARCHAR(255)
  • Issued Date (shelf_date) — DATETIME
  • Published (shelf_published) — ENUM("True", "False")

BookShelf-Book (bookshelf_book)

  • ID (bsb_id) — INT — Primary key — NOT NULL
  • Shelf ID (shelf_id) — INT — Foreign key → BookShelf.ID — NOT NULL
  • Book ID (book_id) — INT — Foreign key → Book.ID — NOT NULL
  • Order (bsb_order) — INT

Follow (follow)

  • ID (follow_id) — INT — Primary key — NOT NULL
  • User ID (user_id) — INT — Foreign key → User.ID — NOT NULL
  • Follower ID (follower_id) — INT — Foreign key → User.ID — NOT NULL
  • Following Date (follow_date) — DATETIME

Online Cache (online_cache)

  • ID (cache_id) — INT — Primary key — NOT NULL
  • Book ID (book_id) — INT — Foreign key → Book.ID — NOT NULL
  • Ridi Books (cache_ridi) — ENUM("True", "False")
  • Millie (cache_millie) — ENUM("True", "False")
  • Yes 24 (cache_yes24) — ENUM("True", "False")
  • Kyobo (cache_kyobo) — ENUM("True", "False")

Place (place)

  • ID (place_id) — INT — Primary key — NOT NULL
  • Name (place_name) — VARCHAR(30)
  • Type (place_type) — INT — 1 : Book Store 2 : Library
  • Address (place_address) — VARCHAR(100)
  • Latitude (place_latitude) — FLOAT()
  • Longitude (place_longitude) — FLOAT()

Published BookShelf (pub_bookshelf)

  • ID (pbs_id) — INT — Primary key — NOT NULL
  • ID (shelf_id) — INT — Foreign key → BookShelf.ID — NOT NULL
  • Highlight (pbs_highlight) — ENUM("True", "False")
  • Upvote (pbs_upvote) — INT

User (user)

  • ID (user_id) — INT — Primary key — NOT NULL
  • Nickname (user_nickname) — VARCHAR(8) — NOT NULL
  • Name (user_name) — VARCHAR(30)
  • Email (user_email) — VARCHAR(30)
  • Type (user_type) — INT — 1 : 일반 유저 2 : 저자(Author) 3 : 출판사(Publisher) 4 : 장소(Place) 5 : 관리자(Admin)
  • Description (user_description) — VARCHAR(255)
  • User Image (user_image) — TEXT
  • Place Info (user_placeinfo) — INT — Foreign key → Place.ID — NOT NULL

User-BookShelf (user_bookshelf)

  • ID (ubs_id) — INT — Primary key — NOT NULL
  • Owner's ID (user_id) — INT — Foreign key → User.ID — NOT NULL
  • Shelf ID (shelf_id) — INT — Foreign key → BookShelf.ID — NOT NULL
  • Order (ubs_order) — INT