pcs_db - Laravel Schema Designer

admins

id increments
timestamps timestamps
softDeletes softDeletes
image string (255)
name string (255)
password string (255)
remember_token string (255)
email string (255)

admins_password_resets

email string (255)
token string (255)
created_at timestamp

courses

id increments
timestamps timestamps
softDeletes softDeletes
course_title string (400)
course_overview text
course_objectives text
course_content text
details text
cover string (255)
tags string (400)
categories string (400)
notify_users tinyInteger
price float

course_instructors

id increments
timestamps timestamps
softDeletes softDeletes
course_id ^FK integer
instructor_id ^FK integer

instructors

id increments
timestamps timestamps
softDeletes softDeletes
full_name string (55)
bio string (255)
photo string (255)
phone_number string (255)
email string (255)
facebook string (400)
twitter string (400)
instagram string (400)
youtube string (400)
telegram string (400)
martial_status string (25)
nationality string (100)
address string (400)
skills_history text
experiences_history string (400)
working_history text
notes string (400)
rate string (55)
academic_history text

course_locations

id increments
timestamps timestamps
softDeletes softDeletes
course_id ^FK integer
location_id ^FK integer

locations

id increments
timestamps timestamps
softDeletes softDeletes
location_title string (400)
location_address string (400)
coordinates json

medias

id increments
timestamps timestamps
softDeletes softDeletes
name string (400)
remote_link string (400)
datetime timestamp
model_id integer
model_name string (255)
sort integer
shown_in_medias tinyInteger
category_id ^FK integer

media_categories

id increments
timestamps timestamps
softDeletes softDeletes
title string (100)
datetime datetime
parent_id ^FK integer

migrations

id increments
migration string (255)
batch integer

news

id increments
timestamps timestamps
softDeletes softDeletes
title string (400)
subject text
datetime datetime
cover string (400)

offers

id increments
timestamps timestamps
softDeletes softDeletes
title string (400)
datetime timestamp
notes string (400)
notify_users tinyInteger

offers_details

id increments
timestamps timestamps
softDeletes softDeletes
course_id ^FK integer
offer_id ^FK integer
price_before_discount float
price_after_discount float
discount_rate float
datetime datetime

notifications

id increments
timestamps timestamps
softDeletes softDeletes
model_name string (100)
model_id integer
datetime datetime
expiredate datetime

password_resets

email string (255)
token string (255)
created_at timestamp

reservations

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
course_id ^FK integer
offers_details_id ^FK integer
price float
datetime datetime
payment_method string (55)
is_paid tinyInteger

users

id increments
timestamps timestamps
softDeletes softDeletes
remember_token string (100)
user_name string (100)
full_name string (100)
phone_number string (55)
email string (255)
password string (255)
photo string (255)
age string (55)
bio string (255)
address string (255)
country string (55)
state string (55)
is_verified tinyInteger
token string (255)

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