extranet - Laravel Schema Designer

users

id increments
login string (25)
password string
rememberToken rememberToken
timestamps timestamps
softDeletes softDeletes
company_id ^FK bigInteger

contact

id increments
company_id ^FK bigInteger
firstname string
lastname string
phone string (10)
email string
timestamps timestamps
softDeletes softDeletes

files

id increments
name string
file_path string
status boolean
file_type_id ^FK bigInteger
project_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

files_type

id increments
name string
timestamps timestamps
softDeletes softDeletes

projects

id increments
project_type_id ^FK bigInteger
name string
user_id ^FK bigInteger
htlogin string
htpasswd string
timestamps timestamps
softDeletes softDeletes

models

id increments
name string
file_path string
project_id ^FK bigInteger
is_hidden boolean
is_validate boolean
timestamps timestamps
softDeletes softDeletes

integrations

id increments
link string
is_hidden boolean
is_validate boolean
project_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

conversations

id increments
project_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

conversations_users

user_id ^FK bigInteger
conversation_id ^FK bigInteger

messages

id increments
content longText
user_id ^FK bigInteger
conversation_id ^FK bigInteger
is_read boolean
timestamps timestamps
softDeletes softDeletes

tickets

id increments
object string
project_id ^FK bigInteger
user_id ^FK bigInteger
ticket_type_id ^FK bigInteger
content longText
is_open boolean
is_close boolean
timestamps timestamps
softDeletes softDeletes

tickets_type

id increments
name string
is_urgent boolean
timestamps timestamps
softDeletes softDeletes

comments

id increments
user_id ^FK bigInteger
content text
is_read boolean
timestamps timestamps
softDeletes softDeletes

comments_integrations

comment_id ^FK bigInteger
integration_id ^FK bigInteger

comments_models

comment_id ^FK bigInteger
model_id ^FK bigInteger

projects_type

id increments
name string
timestamps timestamps
softDeletes softDeletes

notifs

id uuid
type string
notifiable morphs
data text
read_at timestamp
timestamps timestamps
softDeletes softDeletes

companies

id increments
name string
adress string
zipcode string (5)
city string
comment text
source enum
timestamps timestamps
softDeletes softDeletes

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