committee - Laravel Schema Designer

users

id bigIncrements
name string
email string
password string
user_type tinyInteger
logo string
suspended boolean
active boolean
is_super_admin boolean
rememberToken rememberToken
userable morphs
timestamps timestamps
softDeletes softDeletes

companies

id bigIncrements
email string
country_id ^FK integer
city_id integer
telephone string
about text
type tinyInteger
website string
license_of_hajj string
commercial_register string
iata_number string
logo string
counterpart_id ^FK bigInteger
license string
active boolean
timestamps timestamps
softDeletes softDeletes

countries

id increments
timestamps timestamps

companies_trans

company_id ^FK bigInteger
lang_id tinyInteger
name string

countries_trans

country_id ^FK integer
lang_id tinyInteger
name string (255)

currencies

id increments
timestamps timestamps

currencies_trans

currency_id ^FK integer
lang_id tinyInteger
name string (255)

counterparts

id bigIncrements
email string
country_id ^FK integer
name string
address string
telephone string
fax string
mobile string
logo string
active boolean
timestamps timestamps
softDeletes softDeletes

companies_licenses_counterparts

company_id ^FK bigInteger
counterpart_name string
license_number string

documents

id increments
title string
path string
documentable nullableMorphs
timestamps timestamps

requests_companies

id bigIncrements
country_id integer
city_id integer
telephone string
about text
type tinyInteger
website string
license_of_hajj string
commercial_register string
iata_number string
logo string
licenses_counterparts json
trans json
documents json
status_request tinyInteger
email string
password string
counterpart_id bigInteger
license string
timestamps timestamps

companies_services

company_id ^FK bigInteger
service_id ^FK bigInteger

services

id bigIncrements
active tinyInteger
category_service_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

services_trans

service_id ^FK bigInteger
lang_id tinyInteger
name string

categories_services

id increments
active tinyInteger
timestamps timestamps
softDeletes softDeletes

categories_services_trans

category_service_id ^FK bigInteger
lang_id tinyInteger
name string

comments

id bigIncrements
text text
commentable nullableMorphs
dispute_id ^FK bigInteger
type tinyInteger
parent_id ^FK bigInteger
user_id ^FK bigInteger
send_to ^FK bigInteger
timestamps timestamps

disputes

id increments
timestamps timestamps

disputes_sessions

id increments
dispute_id ^FK bigInteger
date datetime
timestamps timestamps

disputes_representatives

id increments
dispute_session_id ^FK bigInteger
name string
character string
type tinyInteger
morphable nullableMorphs
user_id bigInteger
timestamps timestamps

disputes_decisions

id increments
dispute_id ^FK bigInteger
text longText
status_counterpart tinyInteger
timestamps timestamps

disputes_reports

id increments
dispute_id bigInteger
status_committee tinyInteger
status_counterpart tinyInteger
created_by ^FK bigInteger
timestamps timestamps

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