e-library - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string
password string

materials

id increments
timestamps timestamps
softDeletes softDeletes
title string
description text
category_id bigInteger
path string
cover_path string
abstract text
keywords string
downloads bigInteger
reads bigInteger
date date
isbn string

authors

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string
institution string
department string
country string

authors_materials

id increments
timestamps timestamps
softDeletes softDeletes
material_id bigInteger
author_id bigInteger

transactions

id increments
timestamps timestamps
softDeletes softDeletes
user_id bigInteger
material_id bigInteger
due_date date

categories

id increments
timestamps timestamps
softDeletes softDeletes
name string
description text

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