ra7ty - Laravel Schema Designer

users

id increments
name string
email string
phone1 string
phone2 string
salary integer
is_admin enum
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

branchs

id increments
name string
address string
lat string
long string
work_hours integer
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

services

id increments
name string
avg_price integer
created_by integer
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

clients

id increments
name string
email string
phone1 string
phone2 string
location string
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

roles

id increments
name string
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

permissions

id increments
name string
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

roles_users

id increments
role_id bigInteger
user_id bigInteger
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

items

id increments
name string
min_amount integer
price_avg integer
rate integer
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

reservations

id increments
client_id bigInteger
branch_id bigInteger
status enum
date date
time time
discount string
total_price integer
main_price integer
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

service_reservation

id increments
reservation_id bigInteger
service_id bigInteger
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

item_reservation

id increments
reservation_id bigInteger
item_id bigInteger
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

user_branch

id increments
branch_id bigInteger
user_id bigInteger
updated_by bigInteger
created_by bigInteger
timestamps timestamps
softDeletes softDeletes

finance_category

id increments
name string
icon string
sub_of bigInteger
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

finance_cash

id increments
amount integer
date date
status enum
finance_category_id bigInteger
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

providers

id increments
name string
email string
phone1 string
phone2 string
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

stores

id increments
item_id bigInteger
provider_id bigInteger
count_item integer
total_amount integer
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

roles_permissions

id increments
permisson_id bigInteger
role_id string
created_by integer
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

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