bookers - Laravel Schema Designer

users

id increments
timestamps timestamps
name string
email string
password string

authors

id increments
timestamps timestamps
name string
description string
avatar string

books

id increments
timestamps timestamps
name string
annotation string
isbn string
publisher_id bigInteger
publish_year string
citation text
pages string
chapters string
category_id bigInteger
picture string

categories

id increments
timestamps timestamps
name string
description string
parent_id bigInteger
picture string

genres

id increments
timestamps timestamps
name string
description string

tags

id increments
timestamps timestamps
name string

props_types

id increments
timestamps timestamps
name string

props_type_values

id increments
timestamps timestamps
type_id ^FK bigInteger
name string
book_id ^FK bigInteger

reader_cards

id increments
timestamps timestamps
book_id bigInteger
user_id bigInteger
state_id bigInteger

publishers

id increments
timestamps timestamps
name string
description string
avatar string

book_tag

book_id ^FK bigInteger
tag_id ^FK bigInteger

book_genre

book_id ^FK bigInteger
genre_id ^FK bigInteger

author_book

author_id ^FK bigInteger
book_id ^FK bigInteger

card_book_states

id increments
timestamps timestamps
name string

reviews

id increments
timestamps timestamps

comments

id increments
timestamps timestamps

langs

id increments
timestamps timestamps

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01