morin - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
username string (255)
password string (32)
employee_id ^FK integer
active tinyInteger

customers

id increments
timestamps timestamps
softDeletes softDeletes
person_id ^FK integer
main_address ^FK integer

cases

id increments
timestamps timestamps
softDeletes softDeletes
number string (255)
customer_id ^FK integer
court_id ^FK integer
is_legal_aid tinyInteger
lawyer_employee_id ^FK integer
case_status_id ^FK integer
closed_date datetime

employees

id increments
timestamps timestamps
softDeletes softDeletes
person_id ^FK integer
phone_number ^FK integer

employee_titles

id increments
timestamps timestamps
softDeletes softDeletes
full_title_name string (512)
title_name string (255)
short_title_name string (255)

addresses

id increments
timestamps timestamps
softDeletes softDeletes
street_number integer
street_name string (512)
postal_code string (12)
city_name string (255)
province string (255)
country string (255)

events

id increments
timestamps timestamps
case_id ^FK integer
customer_id ^FK integer
professional_ressource_id ^FK integer
employee_id ^FK integer
type_id ^FK integer
datetime datetime
duration string

event_types

id increments
timestamps timestamps
softDeletes softDeletes
edit_required_acces_level tinyInteger

acess_level

id increments

professional_ressources

id increments
timestamps timestamps
softDeletes softDeletes
person_id ^FK integer
address ^FK integer
ressource_type_id ^FK integer
professional_type_id ^FK integer

professional_types

id increments
timestamps timestamps
name string

ressource_types

id increments
timestamps timestamps
softDeletes softDeletes

courts

id increments
timestamps timestamps
softDeletes softDeletes
short_name string (255)
name string (512)
full_name string (1024)
address_id ^FK integer
phone ^FK integer
fax ^FK integer

notes

id increments
timestamps timestamps
note_type_id ^FK integer
title string (1024)
note longText
case_id ^FK integer
customer_id ^FK integer
employee_id ^FK integer
professional_ressource_id ^FK integer
author_id string

note_types

id increments
timestamps timestamps
name string (255)

cases_professional_ressources

id increments
timestamps timestamps
case_id ^FK integer
professional_ressource_id ^FK integer

charges

id increments
timestamps timestamps
name string (255)

cases_charges

id increments
timestamps timestamps
case_id ^FK integer
charge_id ^FK integer

phone_numbers

id increments
timestamps timestamps
phone_label string (255)
number string (20)
customer_id ^FK integer
professional_ressource_id ^FK integer
employee_id ^FK integer

persons

id increments
timestamps timestamps
softDeletes softDeletes
first_name string (255)
middle_name string (255)
last_name string (255)

case_status

id increments
timestamps timestamps
name string

documents

id increments
timestamps timestamps
name string
path string
case_id ^FK integer
customer_id ^FK integer
employee_id ^FK integer

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