msstudio - Laravel Schema Designer

reviews

id increments
text string (500)
author string (20)
approval tinyInteger
timestamps timestamps

reasons

id increments
number smallInteger
title string (25)
timestamps timestamps
text string (300)

quotes

id increments
timestamps timestamps
title string (50)
text string (50)

news

id increments
title string
description string
keywords string
timestamps timestamps
content string

category

id increments
timestamps timestamps
title string
description string
keywords string

managers

id increments
title string (25)
timestamps timestamps
phone string (20)
name string (20)

contacts

id increments
contact string (20)
timestamps timestamps

course

id increments
name string
timestamps timestamps
public tinyInteger
alias string
sorting_order integer
start_date datetime
short_desc text
price integer
price_before_increase string
days_before_increase integer
project_examples string
end_courses string
title string
meta_description text
meta_keywords text

lesson

id increments
course_id integer
name string
public integer
timestamps timestamps
alias string
sorting_order string
starting_date datetime
short_desc text
count_hours integer
title string
meta_description text
meta_keywords text

teacher

id increments
timestamps timestamps
lesson_id integer
name string (255)
public tinyInteger
position string
short_desc text
photo string
permissions string
user_id integer

student

id increments
timestamps timestamps
course_id integer
lesson_id integer
group_id integer
public tinyInteger
name string (25)
surname string (45)
birthdate date
city string (25)
company string (25)
photo string (255)
position string
telephone string
skype string
facebook string
vk string
short_desc text
permissions string
course_date string
user_id integer

hometask

id increments
timestamps timestamps
lesson_id integer
course_id integer
student_id string
theme string
type_id integer
availability string
progress string
order string

messages

id increments
timestamps timestamps
teacher_id integer
lesson_id integer
course_id integer
student_id string
theme string
body string
status string
type string
send_date datetime

roles

id increments
name string
label string
timestamps timestamps

permissions

id increments
name string
label string
timestamps timestamps

role_use

user_id integer
role_id integer

users

id increments
username string
password string (65)
email string (60)
timestamps timestamps
userable_id string

Group

id increments
timestamps timestamps
student_id integer

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