Bayena - Laravel Schema Designer

countries

id increments
timestamps timestamps
softDeletes softDeletes
name string
code string

cities

id increments
timestamps timestamps
softDeletes softDeletes
name string
country_id integer

lawyers

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string
phone string
country_id integer
city_id integer
advice_price double
password string
birth_date date
gender enum
brief text
level_id integer
status enum
available enum
user_id string
waiting_from integer
waiting_to integer
bank_id integer
account_name string
balance double
account_number string
iban string
rating integer

specialties

id increments
timestamps timestamps
softDeletes softDeletes
name string

languages

id increments
timestamps timestamps
softDeletes softDeletes
name string

memberships

id increments
timestamps timestamps
softDeletes softDeletes
organization string
start_at date
still boolean
expire_at date
lawyer_id integer
name string
country_id integer

licenses

id increments
timestamps timestamps
softDeletes softDeletes
start_at date
expire_at date
license_number string
type enum
country_id integer
lawyer_id integer

levels

id increments
timestamps timestamps
softDeletes softDeletes
name string

qualifications

id increments
timestamps timestamps
softDeletes softDeletes
start_at date
expire_at date
university string
faculty string
specialty string
degree_id integer
description string
lawyer_id integer

experiences

id increments
timestamps timestamps
start_at date
expire_at date
still boolean
company_name string
job_title string
company_location string
description string
lawyer_id integer

rating

id increments
timestamps timestamps
user_id integer
rating_to integer
order_id integer
rate integer
softDeletes softDeletes
status enum

banks

id increments
timestamps timestamps
softDeletes softDeletes
name string
country_id integer

rating_stars

id increments
timestamps timestamps
softDeletes softDeletes
rating_id integer
rate integer
question_id integer

rating_reviews

id increments
timestamps timestamps
softDeletes softDeletes
rating_id integer
comment text

rating_questions

id increments
timestamps timestamps
softDeletes softDeletes
question text
to enum

lawyers_specialties

id increments
timestamps timestamps
softDeletes softDeletes
lawyer_id integer
specialty_id integer

lawyers_languages

id increments
timestamps timestamps
softDeletes softDeletes
lawyer_id integer
language_id integer

categories

id increments
timestamps timestamps
softDeletes softDeletes
name string

user

id increments
timestamps timestamps
softDeletes softDeletes

orders

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
lawyer_id integer
category_id integer
specialty_id integer
language_id integer
type enum
title string
details text
status enum
offer_id integer
discount_id integer
price double

invitations

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
lawyer_id integer
price double
days_offer integer
period integer
status enum
cancel enum
review string

offers

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
lawyer_id integer
invitation_id integer
price double
period integer
status enum
details longText
cancel_reason text
read boolean

settings

id increments
timestamps timestamps
softDeletes softDeletes
key string
value text

notifications

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
type enum
message text

messages

id increments
timestamps timestamps
softDeletes softDeletes
from_user integer
to_user integer
type enum
message longText
order_id integer
is_reply boolean

discounts

id increments
timestamps timestamps
softDeletes softDeletes
code string
name string
type enum
amount integer
lawyer_id integer
uses integer
max_uses integer
start_ar date
expire_at date
user_id integer
email string

cancel_reasons

id increments
timestamps timestamps
softDeletes softDeletes
question text

payouts

id increments
timestamps timestamps
softDeletes softDeletes
lawyer_id integer
amount double
status enum
process_date date

contacts

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string

regions

id increments
timestamps timestamps
name string (200)
city_id integer

degrees

id increments
timestamps timestamps
softDeletes softDeletes
name string

courses

id increments
timestamps timestamps
softDeletes softDeletes
start_at datetime
expire_at datetime
institute string
name string
hours_number integer
description string
lawyer_id integer

history

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
status string

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