alarqam - Laravel Schema Designer

unversities

id increments
name string (255)
email string (255)
breif longText
phone_number string (191)
address text
latitudes decimal
longitudes decimal
city_id ^FK integer
credence text
language string (255)
unversity_link string (255)
admin_id ^FK integer
timestamps timestamps

unversity_images

id increments
timestamps timestamps
name string (191)

institutes

id increments
timestamps timestamps
name string (255)
phone_number string (255)
breif longText
email string (191)
address text
latitudes decimal
longitudes decimal
course_type string (255)
institute_link string (255)
city_id ^FK integer
date string (255)
admin_id ^FK integer
feature text

scholarships

id increments
timestamps timestamps
name string
email string (191)
end_date timestamps
degree_type string (255)
rule string (191)
breif longText
is_regular_or_not string (191)
city_id ^FK integer
admin_id ^FK integer
is_allowed text

countries

id increments
timestamps timestamps
name string (191)
slug string

cities

id increments
timestamps timestamps
name string (191)
slug string (191)
country_id ^FK integer

users

id increments
timestamps timestamps
phone_number string (20)
email string (255)
password string (255)
user_name string (255)

news

id increments
timestamps timestamps
title string (255)
details string (255)
date string (255)
admin_id ^FK integer

articles

id increments
timestamps timestamps
title string (255)
date string (255)
details text
writer string (255)
img_url string (255)
slug string (191)
admin_id ^FK integer

usre_news_comments

id increments
timestamps timestamps
comment text
news_id ^FK integer
user_id ^FK integer

institute_major

id increments
institute_id ^FK integer
timestamps timestamps
name string

unversty_major

id increments
timestamps timestamps
unversity_id ^FK integer

residence

id increments
timestamps timestamps
name string (255)
unversity_id ^FK integer
city_id ^FK integer
breif text
residence_type string (255)
cost string (255)
features text
disadvantage text
advantage text
image_id ^FK integer
institute_id ^FK integer

articles_users_comments

id increments
timestamps timestamps
articles_id ^FK integer
user_id ^FK integer
comment text

consultations

id increments
timestamps timestamps
scope_consultation string (255)
details text
the_consultation text
consultation_type string (255)
consultation_answer string
date string (255)
consular_name string (255)

consultations_users_comments

id increments
timestamps timestamps
consultation_id ^FK integer
user_id ^FK integer
comment text

experiences

id increments
timestamps timestamps
title string (255)
details text
disadvantage text
advantage text
scope_experience string (255)
user_id ^FK integer

experiences_user_comments

id increments
timestamps timestamps
comment text
experience_id ^FK integer
user_id ^FK integer

major_scholarship

id increments
timestamps timestamps
scholarship_id ^FK integer

institute_images

id increments
timestamps timestamps
name string

scholarship_image

id increments
timestamps timestamps
name string

admins

id increments
timestamps timestamps
name string (191)
email string (191)
password string

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