book-a-book - Laravel Schema Designer

books

id increments
timestamps timestamps
softDeletes softDeletes
title string
isbn string
stock smallInteger

users

id increments
timestamps timestamps
softDeletes softDeletes
email string
password string
bank_account string
suspended boolean

reservations

id increments
timestamps timestamps
softDeletes softDeletes
book_id ^FK bigInteger
order_id ^FK bigInteger
quantity tinyInteger

orders

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
academic_year_id ^FK bigInteger

statuses

id increments
timestamps timestamps
softDeletes softDeletes
name string

status-changes

id increments
timestamps timestamps
softDeletes softDeletes
status_id ^FK bigInteger
order_id ^FK bigInteger

texts

id increments
timestamps timestamps
softDeletes softDeletes
body text
book_id ^FK bigInteger

media

id increments
timestamps timestamps
softDeletes softDeletes

mails

id increments
timestamps timestamps
softDeletes softDeletes
body text

academic-years

id increments
timestamps timestamps
softDeletes softDeletes
starting_year date
ending_year date

sales

id increments
timestamps timestamps
softDeletes softDeletes
book_id ^FK bigInteger
academic_year_id ^FK bigInteger
public-price float
price float

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