azm - Laravel Schema Designer

users

id increments
type tinyInteger
name string
email string
password string
phone string
education_description_ar string
education_description_en string
teacher_info json
timestamps timestamps

diplomas

id increments
timestamps timestamps
type tinyInteger
category_id ^FK integer
title_ar string
title_en string
description_ar string
description_en string
terms_ar string
terms_en string
certificates_ar string
certificates_en string
duration_houres string
duration_days string
start_at time
education_time_ar string
education_time_en string
place string
price string
discount string

enrollments

id increments
user_id ^FK integer
timestamps timestamps
diploma_id ^FK integer
attend_type tinyInteger
code_attend string
certificates string

categories

id increments
timestamps timestamps
name_ar string
name_en string

site_infos

id increments
timestamps timestamps
name_en string
name_ar string
email string
domain string
phone string
twitter string
instagram string
youtube string
google_map string
user_guide longText

articals

id increments
timestamps timestamps
title_ar string
title_en string
content_ar string
content_en string
image string

exams

id increments
timestamps timestamps
title_ar string
title_en string
type tinyInteger
time time

questions

id increments
timestamps timestamps
question_ar string
question_en string
answer_ar string
answer_en string
exam_id ^FK integer

user_exams

id increments
timestamps timestamps
user_id ^FK integer
exam_id ^FK integer
result integer
num_right_answers string
num_wrong_answers string
degree integer

cobones

id increments
timestamps timestamps
max_use integer
user_id ^FK integer
code string
amount string

contact_as

id increments
timestamps timestamps
name string
message string
email string

comments

id increments
timestamps timestamps
user_id ^FK integer
diploma_id ^FK integer
content string

diploma_rates

id increments
timestamps timestamps
diploma_id ^FK integer
user_id ^FK integer
diploma_rate ^FK integer
teacher_rate ^FK integer
site_rate ^FK integer
note string

rates

id increments
timestamps timestamps
title_ar string
title_en string

certificates

id increments
timestamps timestamps
user_id ^FK integer
diploma_id ^FK integer
file string

lessons

id increments
timestamps timestamps
title_ar string
title_en string
link string
subject_id ^FK integer
file string

subjects

id increments
timestamps timestamps
name_ar string
name_en string

semesters

id increments
timestamps timestamps
name_ar string
name_en string
diploma_id ^FK integer

payments

id increments
timestamps timestamps
enrollment_id ^FK integer
user_id ^FK integer
cobone_id ^FK integer

examable

id increments
timestamps timestamps
examable_type string
examable_id string
exam_id ^FK integer

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