livrary_infomaniak_bdd - Laravel Schema Designer

books

id increments
title string (100)
publication date
ref string (30)
description longText
image string (100)
quantity integer
timestamps timestamps
category_id ^FK integer
author_id ^FK integer

categories

id increments
timestamps timestamps
name string (50)

users

id increments
firstname string (100)
lastname string (100)
email string (150)
password string (150)
sex enum
role enum
verified boolean
attachment string (150)
timestamps timestamps

authors

id increments
firstname string (100)
lastname string (100)
biography text
timestamps timestamps

borrowings

id increments
timestamps timestamps
during tinyInteger
quantity tinyInteger
user_id ^FK integer
book_id ^FK integer

opinions

id increments
timestamps timestamps
grade tinyInteger
description text
title string (50)
user_id ^FK integer
book_id ^FK integer

favorites

id increments
timestamps timestamps
user_id ^FK integer
book_id ^FK integer

loves

id increments
timestamps timestamps
user_id ^FK integer
book_id ^FK integer

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