maktaba - Laravel Schema Designer

users

id bigIncrements
name string
email string
password string
country string
Type enum
date_birth date
type_study string
brief string
image string
degree string
user_role enum
softDeletes softDeletes

categories

id bigIncrements
title string
created_by ^FK bigInteger
timestamps timestamps

books

id bigIncrements
name string
details longText
summary longText
language string
pages_count integer
views integer
author_id ^FK bigInteger
category_id ^FK bigInteger
file string
timestamps timestamps
softDeletes softDeletes

comments

id increments
comment text
user_id ^FK bigInteger
rate integer
timestamps timestamps
softDeletes softDeletes

books_favorite

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

categories_parents

id increments
name string
category_id ^FK bigInteger
created_by ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

favorite_departments

id increments
name string
user_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

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