sms - Laravel Schema Designer

users

id increments
timestamps timestamps
login string (191)
password string (191)
email string (191)
phone string (191)

user_roles

id increments
timestamps timestamps
name string

projects

id increments
timestamps timestamps
user_id integer
login string
custom_date datetime
balance float
traffic_mothly integer
traffic_planed integer
traffic_regularity integer
company_id integer
status_id integer
status_updated_at datetime
next_contact_date datetime

companies

id increments
timestamps timestamps
name string (191)
inn integer

persons

id increments
timestamps timestamps
name string
lastname string
middlename string
email string
phone integer
is_main boolean
company_id integer

project_statuses

id increments
timestamps timestamps
name string (191)
string_id string (191)

industries

id increments
timestamps timestamps
name string (191)

comments

id increments
timestamps timestamps
commentable_id integer
commentable_type string (191)
user_id integer

communications

id increments
timestamps timestamps
user_id integer
person_id integer
communication_type_id integer

documents

id increments
timestamps timestamps
name string
project_id integer
document_type_id integer
user_id integer

document_types

id increments
timestamps timestamps

invoices

id increments
timestamps timestamps
amount float
project_id integer

services

id increments
timestamps timestamps
name string (191)
string_id string (191)

logs

id increments
timestamps timestamps
loggable_id integer
loggable_type string (191)
user_id integer

communication_types

id increments
timestamps timestamps
name string (191)
string_id string (191)

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