cloudlab - Laravel Schema Designer

teacher

id increments
name string (10)
age smallInteger
teach_course string
belong_unit string (10)
pro_call string (10)
work_num bigInteger
email string (20)
mobile string (15)
timestamps timestamps
softDeletes softDeletes

student

id increments
name string (10)
age smallInteger
choose_course string
grade string (10)
class string (10)
major string (10)
study_num string (15)
email string (20)
mobile string (15)
timestamps timestamps
softDeletes softDeletes

admin

id increments
name string (10)
age smallInteger
belong_unit string (10)
email string (15)
mobile string (15)
timestamps timestamps
softDeletes softDeletes

course

id increments
name string (10)
introduction string (255)
degree_difficulty string (10)
time string (10)
teacher string
notice string (255)
expected_result string (255)
comment string (255)
timestamps timestamps
softDeletes softDeletes

student_course

id increments
student_id smallInteger
course_id smallInteger
score smallInteger
timestamps timestamps
softDeletes softDeletes

course_chapter

course_id ^FK bigInteger
chapter_id smallInteger
experiment_name string (255)
photo_id smallInteger
article_id smallInteger
video_id smallInteger
timestamps timestamps
softDeletes softDeletes

photo

id increments
url string (255)
timestamps timestamps
softDeletes softDeletes

article

id increments
timestamps timestamps
softDeletes softDeletes
url string (255)

video

id increments
url string (255)
timestamps timestamps
softDeletes softDeletes

system_course

system_id smallInteger
course_id smallInteger
system_name string (255)
system_introduction string (255)
system_course_num smallInteger
system_comment string (255)
timestamps timestamps
softDeletes softDeletes

comment

id increments
name string (10)
content string (255)
type string (10)
timestamps timestamps
softDeletes softDeletes

experiment_report

id increments
student_id smallInteger
name string (255)
purpose string (255)
content string (255)
result string (255)
photo_id smallInteger
article_id smallInteger
video_id smallInteger
timestamps timestamps
softDeletes softDeletes

course_pro_course

course_id smallInteger
pro_course_id smallInteger
timestamps timestamps
softDeletes softDeletes

chapter_pro_chapter

chapter_id smallInteger
pro_chapter_id smallInteger
timestamps timestamps
softDeletes softDeletes

system

id increments
timestamps timestamps
softDeletes softDeletes

mirror

id increments
timestamps timestamps
softDeletes softDeletes
name string (20)

experiment

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)

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