herafy - Laravel Schema Designer

users

id increments
name string
email string
phone string (20)
activated string (10)
city_id ^FK integer
image string (30)
id_image string (30)
about text
balance integer
type enum
password string
timestamps timestamps
softDeletes softDeletes

provider_times

id increments
provider_id ^FK integer
days string
start_time time
end_time time
timestamps timestamps

services

id increments
parent_id integer
name string
description text
image string (30)
commission integer
timestamps timestamps

cities

id increments
parent_id integer
name string
timestamps timestamps

provider_service

id increments
provider_id ^FK integer
service_id ^FK integer
price integer
timestamps timestamps

provider_banks

id increments
provider_id ^FK integer
bank_id ^FK integer
acc_num string
iban string
acc_name string
timestamps timestamps

banks

id increments
name string
logo string (30)
timestamps timestamps

orders

id increments
address_id ^FK integer
client_id ^FK integer
client_name string
client_mobile string
provider_id ^FK integer
provider_name string
provider_mobile string
service_id ^FK integer
service_name string
parent_service_id string
parent_service_name string
date datetime
status tinyInteger
service_cost integer
provider_commission integer
net_profit integer
rate integer
rate_note text
timestamps timestamps

notifications

id increments
laravel_notification string
timestamps timestamps

order_transactions

id increments
order_id ^FK integer
client_id ^FK integer
client_name string
client_mobile string
cost integer
status tinyInteger
payment_method string
timestamps timestamps

settings

id increments
name string (30)
value text
type string
module string
order_by smallInteger
timestamps timestamps

admins

id increments
name string
email string
password string
timestamps timestamps

provider_transactions

id increments
provider_id ^FK integer
provider_name string
provider_mobile string
cost integer
bank_id ^FK integer
bank_name string
status tinyInteger
acc_num string
iban string
acc_name string
timestamps timestamps

addresses

id increments
user_id ^FK integer
label string (40)
lat string
lng string
building_num integer
floor_num integer
apartment_num integer
address text
is_primary tinyInteger
status tinyInteger
timestamps timestamps

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