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