library - Laravel Schema Designer

books

id increments
name string
publisher_id ^FK integer
timestamps timestamps

employments

id increments
book_id ^FK integer
start_employment datetime
end_employment datetime
timestamps timestamps

publishers

id increments
year datetime
address string
founding_date datetime
timestamps timestamps

book_author_xref

book_id ^FK integer
author_id ^FK integer
timestamps timestamps

book_genre_xref

book_id ^FK integer
genre_id ^FK integer
timestamps timestamps

book_preview_xref

book_id ^FK integer
preview ^FK integer
timestamps timestamps

authors

id increments
author string
birthday datetime
timestamps timestamps

genres

id increments
genre string
timestamps timestamps

previews

id increments
file string
hash string
timestamps timestamps

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