Hospital - Laravel Schema Designer

patients

id increments
timestamps timestamps
name string (100)
birth_date date
sex enum
phone string (20)
address text

wards

timestamps timestamps
id increments
capacity smallInteger

beds

id increments
timestamps timestamps
avaible boolean
ward_id ^FK integer

transactions

id increments
timestamps timestamps
amount decimal
method enum
record_id ^FK integer

records

id increments
timestamps timestamps
description text
type enum
results text
date_from timestamp
date_to timestamp
doctor_id ^FK integer
patient_id ^FK integer

doctors

id increments
timestamps timestamps
name string (100)
birth_date date
sex enum
specialization string (60)
time_in time
time_out time

nurses

id increments
timestamps timestamps
name string (100)
shift enum

users

id increments
timestamps timestamps
user string (50)
password string (60)
remember_token rememberToken
doctor_id ^FK integer
role enum

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