alnaamy - Laravel Schema Designer

contacts

id increments
name string
email string
phone string
message text
timestamps timestamps

settings

id increments
facebook_url string
twitter_url string
instagram_url string
address_ar string
address_en string
phone string
working_days string
working_times string
emergency string
home_desc_ar text
home_desc_en text
service_desc_ar text
service_desc_en text
timestamps timestamps

email_subscriptions

id increments
email string
timestamps timestamps

about_us

id increments
about_ar text
about_en text
who_we_are_ar text
who_we_are_en text
ceo_ar text
ceo_en text
hospital_desc_ar text
hospital_desc_en text
mission_ar text
mission_en text
vision_ar text
vision_en text
values_ar text
values_en text
timestamps timestamps

achievements

id increments
achievement_ar text
achievement_en text
dammam_desc_ar text
dammam_desc_en text
khamis_desc_ar string
khamis_desc_en text
timestamps timestamps

partners

id increments
level integer
timestamps timestamps

photos

id increments
path string
photoable_id integer
photoable_type string
timestamps timestamps

specialities

id increments
name_ar string
name_en string
desc_ar text
desc_en text
timestamps timestamps

doctors

id increments
name_ar string
name_en string
desc_ar text
desc_en text
speciality_id ^FK integer
timestamps timestamps

clients

id increments
speciality_id ^FK integer
doctor_id ^FK integer
name string
phone string
day date
time time
timestamps timestamps

sliders

id increments
desc_ar text
desc_en text
timestamps timestamps

offers

id increments
title_ar string
title_en string
desc_ar text
desc_en text
price integer
timestamps timestamps

jobs

id increments
name_ar string
name_en string
timestamps timestamps

careers

id increments
job_id ^FK integer
name string
email string
address string
timestamps timestamps

tags

id increments
name_ar string
name_en string
timestamps timestamps

blogs

id increments
title_ar string
title_en string
desc_ar text
desc_en text
speciality_id ^FK integer
timestamps timestamps

blog_tag

id increments
timestamps timestamps
blog_id ^FK integer
tag_id ^FK integer

payment_methods

id increments
name_ar string
name_en string
timestamps timestamps

payments

id increments
offer_id ^FK integer
payment_method_id ^FK integer
first_name string
last_name string
billing_address string
phone string
country string
transaction_id string
zip_code string
timestamps timestamps

educations

id increments
title_ar string
title_en string
desc_ar string
desc_en string
year integer
doctor_id ^FK integer
timestamps timestamps

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