universidade - Laravel Schema Designer

articles

id increments
article_type_id ^FK integer
title string
subtitle string
slug string
short text
text text
thumb string
image string
date date
highlight tinyInteger
status tinyInteger
order integer
timestamps timestamps
softDeletes softDeletes

article_types

id increments
slug string
name string
image string
active tinyInteger
order integer

languages

code string (2)
description string
status tinyInteger
order smallInteger

course_types

id increments
slug string
name string
active tinyInteger
order integer

staff_types

id increments
slug string
name string
active tinyInteger
order integer

courses

id increments
course_type_id ^FK integer
code string (20)
acronym string (20)
director integer
assistant_director integer
assistant_director2 integer
address text
phone string
phone2 string
fax string
email string
url string
image string
timestamps timestamps
softDeletes softDeletes

texts

id increments
textable_id integer
textable_type string
language_code string (2)
title string
text string
order smallInteger
timestamps timestamps

course_detail

id ^FK integer
language_code string (2)
slug string
title string
alternative_title string
short text
text text
duration string

units

id increments
code string (20)
acronym string (20)
timestamps timestamps
softDeletes softDeletes

unit_detail

id ^FK integer
language_code string (2)
title string
alternative_title string
short text
text text
modules text

unit_schedules

id increments
slug string
name string
active tinyInteger
order integer

course_years

id increments
slug string
name string
active tinyInteger
order integer

staff

id increments
staff_type_id ^FK integer
name string
phone string
phone_extension string
email string
url string
image string
timestamps timestamps
softDeletes softDeletes

staff_unit

staff_id ^FK integer
unit_id ^FK integer

course_unit

course_id ^FK integer
unit_id ^FK integer
year_id ^FK integer
schedule_id ^FK integer
credits_ects string

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