RISC - Laravel Schema Designer

events

id increments
event_type_id integer
title string (255)
subtitle string (255)
details text
date_start date
date_end date
place_id integer
contact text
url string (255)
comments text
image string (255)
valid boolean
user_id integer
timestamps timestamps
softDeletes softDeletes

places

id increments
department string (255)
institution string (255)
address1 string (255)
address2 string (255)
postal_code string (50)
city string (120)
area_id integer
country_id integer
subway string (120)
phone string (50)
comments text
user_id integer
timestamps timestamps

countries

id increments
code smallInteger
alpha2 string (2)
alpha3 string (3)
name_fr string (45)
name_en string (45)

areas

id increments
name_fr string (120)
name_en string (120)

slots

id increments
event_id integer
date datetime
location string (255)
authors string (255)
title string (255)
abstract text
comments text
timestamps timestamps
user_id integer

files

id increments
event_id integer
name string (120)
path string (255)
timestamps timestamps

event_types

id increments
name_fr string (120)
name_en string (120)

colloques

id increments
titre string (255)
url string (255)
lieu string (255)
area_id ^FK integer
country_id ^FK integer
commentaire text
date_start date
date_end date
timestamps timestamps
softDeletes softDeletes

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