activehealth - Laravel Schema Designer

domains

id increments
parent_id integer
name string
type enum
code string
softDeletes softDeletes
timestamps timestamps

users

id increments
domain_id ^FK integer
username string
password string
firstname string
prefix string
lastname string
gender enum
email string
mobile string
role enum
code string
status enum
softDeletes softDeletes
timestamps timestamps

locations

id increments
name string
street1 string
street2 string
postcode string
city string
state string
country string
softDeletes softDeletes
timestamps timestamps

services

id increments
minutes smallInteger
name string
color string
code string
timestamps timestamps
softDeletes softDeletes

calendars

id increments
resource_type enum
resource_id integer
timestamps timestamps
softDeletes softDeletes

user_locations

user_id ^FK integer
location_id ^FK integer
softDeletes softDeletes
timestamps timestamps

user_services

user_id ^FK integer
service_id ^FK integer
softDeletes softDeletes
timestamps timestamps

clients

id increments
user_id ^FK integer
company_id ^FK integer
street1 string
street2 string
postcode string
city string
state string
country string
note text
code string
softDeletes softDeletes
timestamps timestamps

availabilities

id increments
start datetime
end datetime
repeat boolean
repeat_every tinyInteger
repeat_type enum
repeat_until date
timestamps timestamps
softDeletes softDeletes

location_services

location_id integer
service_id integer
softDeletes softDeletes
timestamps timestamps

availability_services

availability_id ^FK integer
service_id ^FK integer
softDeletes softDeletes
timestamps timestamps

companies

id increments
domain_id ^FK integer
parent_id ^FK integer
name string
street1 string
street2 string
postcode string
city string
state string
country string
email string
telephone string
note text
code string
softDeletes softDeletes
timestamps timestamps

appointments

id increments
availability_id ^FK integer
service_id ^FK integer
client_id ^FK integer
start datetime
end datetime
note text
by_user_id ^FK integer
softDeletes softDeletes
timestamps timestamps

availability_repeat_breaks

id increments
availability_id ^FK integer
date date
timestamps timestamps

files

id increments
appointment_id ^FK integer
medical boolean
timestamps timestamps

file_documents

id increments
file_id ^FK integer
name string
type string
contents binary
by_user_id ^FK integer
hash string
softDeletes softDeletes
timestamps timestamps

file_notes

id increments
file_id ^FK integer
title string
contents text
by_user_id ^FK integer
hash string
softDeletes softDeletes
timestamps timestamps

groups

id increments
name string
resource_type enum
timestamps timestamps

group_items

id increments
group_id ^FK integer
resource_id integer
timestamps timestamps

apps

id increments
name string

app_modules

id increments
app_id ^FK integer
parent_id integer
name string
timestamps timestamps

roles

id increments
name string
timestamps timestamps

role_app_modules

id increments
role_id ^FK integer
app_module_id ^FK integer
timestamps timestamps

availability_calendars

id increments
availability_id ^FK integer
calendar_id ^FK integer
softDeletes softDeletes
timestamps timestamps

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