bookingDB - Laravel Schema Designer

books

id increments
isbn string
name string
pub_house_id ^FK integer
auther_id ^FK integer
category_id ^FK integer
timestamps timestamps
softDeletes softDeletes

branches

id increments
name string
address text
timestamps timestamps
softDeletes softDeletes

rooms

id increments
timestamps timestamps
softDeletes softDeletes
branch_id ^FK integer
room_number integer

cupboards

id increments
room_id ^FK integer
name string
timestamps timestamps
softDeletes softDeletes

shelves

id increments
cupboard_id ^FK integer
name string
timestamps timestamps
softDeletes softDeletes

authors

id increments
timestamps timestamps
softDeletes softDeletes

pub_houses

id increments
name string (255)
timestamps timestamps

book_copies

id increments
timestamps timestamps
softDeletes softDeletes
book_id bigIncrements
isbn string
author_id ^FK integer
pub_house_id ^FK integer
category_id ^FK integer

categories

id increments
name string
timestamps timestamps
softDeletes softDeletes

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