WCCNM Mapping Tool - Laravel Schema Designer

users

id increments
timestamps timestamps
email string
first_name string
last_name string
rememberToken rememberToken
password string
active boolean

notifications

id increments
timestamps timestamps
notification_text longText
user_id ^FK integer
notification_read boolean
inquiry_id ^FK integer

counties

id increments
timestamps timestamps
county_name string

county_user

id increments
timestamps timestamps
county_id ^FK integer
user_id ^FK integer
county_user_role ^FK integer

companies

id increments
timestamps timestamps
softDeletes softDeletes
county ^FK integer
company_name string (256)
company_address_2 string (256)
company_city string (128)
company_state string (2)
company_county_id ^FK integer
company_number_employees enum
business_type_id ^FK integer

inquiries

id increments
timestamps timestamps
softDeletes softDeletes
company_id ^FK integer

company_insurance

id increments
timestamps timestamps
company_id ^FK integer
company_insurance_type string
company_insurance_policy_number string (50)

company_user

id increments
timestamps timestamps
company_id ^FK integer
user_id ^FK integer
company_user_role ^FK integer

company_profiles

id increments
timestamps timestamps
company_id ^FK integer
company_address string (256)
company_address_2 string (256)
company_city_id ^FK integer
company_state char (2)
company_number_employees enum
company_fein string (50)
company_crs string (50)
company_ean string (50)

services

id increments
timestamps timestamps
service_name string (128)
service_description longText

inquiry_milestone

id increments
timestamps timestamps
inquiry_id ^FK integer
milestone_id ^FK integer
contact_type_id ^FK integer

milestones

id increments
timestamps timestamps

contacts

id increments
timestamps timestamps
contact_first_name string (50)
contact_last_name string (50)
contact_title string (50)
contact_email char (80)
contactable_type string (25)
contactable_id integer

notification_recipients

id increments
timestamps timestamps
inquiry_id ^FK integer
user_id ^FK integer
inquiry_owner boolean
notification_frequency_id ^FK integer

internal_company_profiles

id increments
timestamps timestamps
company_id ^FK integer

service_providers

id increments
timestamps timestamps
service_id ^FK integer
service_provider_name string (80)

company_service

id increments
timestamps timestamps
service_start_date date
service_end_date date
service_provider ^FK integer
inquiry_id ^FK integer
service_id ^FK integer
service_value integer

internal_company_profile_revenues

id increments
timestamps timestamps
internal_company_profile_id ^FK integer
revenue_amount integer
revenue_year integer

cities

id increments
timestamps timestamps
city_name string (256)
county_id ^FK integer

city_county

id increments
timestamps timestamps
city_id ^FK integer
county_id ^FK integer

contact_types

id increments
timestamps timestamps
contact_type string (25)

roles

id increments
timestamps timestamps
role_type string (20)

questions

id increments
timestamps timestamps
question_text mediumText

inquiry_answers

id increments
timestamps timestamps
inquiry_id ^FK integer
question_id ^FK integer

phone_types

id increments
timestamps timestamps
type string

business_types

id increments
timestamps timestamps
business_type string (60)

phone_numbers

id increments
timestamps timestamps
phone_number string (12)
phone_type_id ^FK integer
contact_id ^FK integer

notification_frequencies

id increments
timestamps timestamps
notification string
notification_frequency string (16)