expense_core - Laravel Schema Designer

companies

id increments
main_address_id ^FK integer
main_infrastructure_id ^FK integer
name string (100)
picture string (255)
vhost_url string (255)
db_write_host string (255)
db_name string (255)
db_login string (255)
db_password string (255)
api_local_url string (255)
api_local_token string (255)
option_international boolean
timestamps timestamps
status tinyInteger
softDeletes softDeletes

persons

id increments
main_address_id ^FK integer
firstname string (100)
lastname string (100)
personal_email string (255)
title string (100)
mobile_phone string
skype string (100)
status tinyInteger
timestamps timestamps
softDeletes softDeletes

contacts

id increments
person_id ^FK integer
company_id ^FK integer
company_address_id ^FK integer
current_infrastructure_id ^FK integer
api_id ^FK integer
picture string (255)
email string (255)
password string (255)
mobile_phone string (100)
skype string (100)
remember_token string (255)
activation_key string (255)
lock_time datetime
last_login_attempts datetime
nb_login_attempts integer
status tinyInteger
timestamps timestamps
softDeletes softDeletes

password_requests

id increments
contact_id ^FK integer
key string (100)
timestamps timestamps

countries

id increments
name string (100)
code string (4)
address_format text
distance_unit enum
longitude float
latitude float
currency_id ^FK integer
timestamps timestamps
softDeletes softDeletes

currency_rates

id increments
base_currency_id ^FK integer
rate_currency_id ^FK integer
rate float
timestamps timestamps
softDeletes softDeletes

currencies

id increments
name string (100)
code string (4)
symbol string (3)
timestamps timestamps
softDeletes softDeletes

addresses

id increments
name string (100)
address string (100)
address2 string (100)
address3 string (100)
city string (100)
zipcode string (100)
country_id ^FK integer
phone string (100)
fax string (100)
website string (255)
picture string (255)
addressable_id integer
addressable_type string (255)
timestamps timestamps
softDeletes softDeletes

applications_companies

id increments
application_id ^FK integer
company_id ^FK integer
timestamps timestamps
softDeletes softDeletes

applications

id increments
name string (100)
prefix_table string (5)
directory_url string (255)
timestamps timestamps
softDeletes softDeletes

audit_trail

id increments
contact_id ^FK integer
trailable_type string (255)
trailable_id integer
trailable_value text
timestamps timestamps

apis

id increments
application_id ^FK integer
name string (255)
description text
fields text
status tinyInteger
timestamps timestamps
softDeletes softDeletes

infrastructures

id increments
code string (255)
name string (255)
cdn_url string (255)
load_balancer_url string (255)
db_core_host string (255)
db_app_host string (255)
country_id ^FK integer
timestamps timestamps
softDeletes softDeletes

actors

id increments
application_id integer
contact_id ^FK integer
role integer
timestamps timestamps
softDeletes softDeletes

role_permissions

id increments
role integer
entity string (255)
permissions bigInteger
timestamps timestamps

companies_options

id increments
company_id ^FK integer
application_id ^FK integer
name string (255)
value text
timestamps timestamps
softDeletes softDeletes

actor_scope

id increments
actor_id ^FK integer
scopable_id integer
scopable_type string (255)
timestamps timestamps
softDeletes softDeletes

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