schoopeak - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string
password string
photo string
status boolean
user_type enum

roles

id increments
timestamps timestamps
softDeletes softDeletes
name string
display_name string

user_roles

id increments
timestamps timestamps
softDeletes softDeletes
user_id string
role_id string

permissions

id increments
timestamps timestamps
softDeletes softDeletes
name string
display_name string

roles_permissions

id increments
timestamps timestamps
softDeletes softDeletes
role_id string
permission_id integer

schools

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
ministry_number string
number_of_students string
number_of_teachers string
bio_ar string
bio_en string
website string
category_id string
notes_ar string
notes_en string
name_ar string

school_branch_addresses

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
school_branch_id integer
governate_id integer
city_id integer
details_en string
long string
lat string
details_ar string

countries

id increments
timestamps timestamps
softDeletes softDeletes
name string

governates

id increments
timestamps timestamps
name string
country_id integer

cities

id increments
timestamps timestamps
softDeletes softDeletes
name string
governate_id string

tags

id increments
timestamps timestamps
softDeletes softDeletes
name_ar string
name_en string

school_tags

id increments
timestamps timestamps
softDeletes softDeletes
school_id string
tag_id string

school_images

id increments
timestamps timestamps
softDeletes softDeletes
school_id string
image string
profile_picture boolean

school_teachers

id increments
timestamps timestamps
softDeletes softDeletes
school_id string
teacher_id string

activities

id increments
timestamps timestamps
softDeletes softDeletes
name string
description string
school_id string

activity_images

id increments
timestamps timestamps
softDeletes softDeletes
activity_id integer
image string

posts

id increments
timestamps timestamps
softDeletes softDeletes
description string
owner_id integer
type enum

post_images

id increments
timestamps timestamps
post_id string
image_name string

teachers

id increments
timestamps timestamps
garduation_date string

training_centers

id increments
timestamps timestamps
user_id integer
bio_ar string
bio_en string
website string
notes_ar string
notes_en string
name_ar string

training_center_addresses

id increments
timestamps timestamps
softDeletes softDeletes
country_id string
governate_id string
city_id string
details_en string
details_ar string
long string
lat string

training_center_images

id increments
timestamps timestamps
softDeletes softDeletes
training_center_id string
image string

subjects

id increments
timestamps timestamps
softDeletes softDeletes
name string

post_likes

id increments
timestamps timestamps
softDeletes softDeletes
post_id integer
user_id string

post_comments

id increments
timestamps timestamps
softDeletes softDeletes
post_id integer
user_id integer
comment string

training_center_tags

id increments
timestamps timestamps
softDeletes softDeletes
training_center_id integer
tag_id integer

articles

id increments
timestamps timestamps
softDeletes softDeletes
title string
description text
user_id integer
blog_category_id integer
image string

article_categories

id increments
timestamps timestamps
softDeletes softDeletes
name string

article_comments

id increments
timestamps timestamps
softDeletes softDeletes
article_id integer
comment string
user_id integer

teacher_subjects

id increments
timestamps timestamps
softDeletes softDeletes
teacher_id integer
subject_id integer

post_videos

id increments
timestamps timestamps
softDeletes softDeletes
post_id integer
video_link string

school_branches

id increments
timestamps timestamps
softDeletes softDeletes
school_id integer
name string

parents

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
country_id integer
governate_id integer
city_id integer

comment_reports

id increments
timestamps timestamps
comment_id string
reporter_id string
status enum

user_followers

id increments
timestamps timestamps
user_id string
follower_id string

user_followings

id increments
timestamps timestamps
user_id string
following_id string