Books - Laravel Schema Designer

books

id increments
author_id ^FK bigInteger
slug string (255)
utf8_title string (255)
ascii_title string (255)
byline string (255)
description string (255)
page_count tinyInteger
relative_path text
remote_path text
softDeletes softDeletes
timestamps timestamps

authors

id increments
utf8_name string (255)
ascii_name string (255)
softDeletes softDeletes
timestamps timestamps

users

id increments
username string (64)
email string (255)
email_pending string (255)
email_hash string (32)
first_name string (64)
last_name string (64)
password string (64)
otp_secret string (128)
salt string (128)
last_ip string (32)
last_login datetime
verified tinyInteger
disabled tinyInteger
softDeletes softDeletes
timestamps timestamps

translations

id increments
user_id ^FK bigInteger
book_id ^FK bigInteger
page_number tinyInteger
text text
softDeletes softDeletes
timestamps timestamps

geo_country

id increments
iso2 string (2)
name string (255)

geo_region

id increments
country_id ^FK bigInteger
name string (255)
code string (5)

geo_city

id increments
country_id ^FK bigInteger
name string (255)

book_subscriptions

id increments
book_id ^FK bigInteger
timestamps timestamps
user_id ^FK bigInteger

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