pacs - Laravel Schema Designer

users

id increments
tenant_id ^FK integer
name string (100)
email string (255)
password string (15)
remember_token string (100)
permissions text
last_login timestamps
active timestamps
activation_key string (255)

tenants

id increments
email string (255)
domain string (50)
logo string
expiry_counter integer
theme_background string
timestamps timestamps

permissions

id increments
timestamps timestamps
title string (255)
description text
key string (255)

groups

id increments
name string (255)
permissions text
timestamps timestamps

user_group

id increments
user_id ^FK integer
group_id ^FK integer
timestamps timestamps

custom_messages

id increments
tenant_id ^FK integer
type enum
email_message text
landing_page_message text
timestamps timestamps

servers

id increments
timestamps timestamps

pacs_data

id increments
tenant_id ^FK integer
special_char string
study_date string
study_time string
accession_no string
ea_title string
instance_availability string
modalities_study string
study_description string
physician_name string
patient_name string
patient_id string
patient_birthdate string
patient_sex string
study_instance_uid string
study_id string
number_study_series string
number_study_instance string
patient_file string
timestamps timestamps

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