snapfile - Laravel Schema Designer

users

id increments
name string (255)
email string (255)
password string (60)
address_line_1 string (255)
address_line_2 string (255)
address_city string (255)
address_state string (30)
address_postcode string (15)
latitude decimal (9,6)
longitude decimal (9,6)
allow_sharing boolean
remember_token rememberToken
timestamps timestamps

personal_folder

id increments
name string (255)
user_id ^FK integer
timestamps timestamps

files

id increments
file_type_id ^FK integer
user_id ^FK integer
service_profile_id ^FK integer
name string (255)
size integer
encryption_algorithm string (15)
compression_options text
compression_algorithm string (15)
encryption_options text
storage_provider string (15)
storage_path string (300)
timestamps timestamps

file_types

id increments
name string (255)
description text
timestamps timestamps

profile_types

id increments
name string (255)
allow_multiple boolean
timestamps timestamps

profile_fields

id increments
label string (255)
type enum
options text
show_in_leads boolean
profile_type_id ^FK integer
timestamps timestamps

service_types

id increments
name string (255)
max_quote_respondents integer
accept_quote_as_lead_fee_cents integer
profile_type_id ^FK integer
timestamps timestamps

service_type_profile_fields

id increments
service_type_id ^FK integer
profile_field_id ^FK integer

service_type_file_types

id increments
service_type_id ^FK integer
file_type_id ^FK integer

user_profile

id increments
user_id ^FK integer
profile_type_id ^FK integer
name string (255)
timestamps timestamps

user_profile_data

id increments
user_profile_id ^FK integer
profile_field_id ^FK integer
value text

personal_folder_files

id increments
file_id ^FK integer
personal_folder_id ^FK integer

file_shares

id increments
file_id ^FK integer
shared_with_user_id ^FK integer
shared_with_lead_id ^FK integer
shared_with_active_service_id ^FK integer
file_request_id ^FK integer
timestamps timestamps

file_reminders

id increments
file_id ^FK integer
date_of_reminder date
description string (1000)
service_profile_id ^FK integer

quotes

id increments
user_profile_id ^FK integer
service_type_id ^FK integer
timestamps timestamps
current_active_service_id ^FK integer

leads

id increments
quote_id ^FK integer
service_profile_id ^FK integer
accepted_by_service_profile boolean
has_service_profile_sent_quote boolean
users_response enum
timestamps timestamps

notifications

id increments
user_id ^FK integer
service_profile_id ^FK integer
type enum
message string (2000)
has_been_read boolean
timestamps timestamps

business_profiles

id increments
administrator_user_id ^FK integer
name string (255)
email string (255)
phone_number string (15)
abn string (25)
verified boolean
timestamps timestamps

service_profiles

id increments
business_profile_id ^FK integer
service_type_id ^FK integer
address_line_1 string (255)
address_line_2 string (255)
address_city string (255)
address_state string (255)
address_postcode string (10)
years_offering_service_for integer
phone_number string (20)
email string (255)
timestamps timestamps

clients

id increments
user_id ^FK integer
service_profile_id ^FK integer
timestamps timestamps

client_invitations

id increments
service_profile_id ^FK integer
existing_user_id ^FK integer
created_active_service_id ^FK integer
name string (255)
email string (255)
status enum
date_of_status_update datetime
timestamps timestamps

active_service

id increments
client_id ^FK integer
client_user_profile_id ^FK integer
approved_lead_id ^FK integer
timestamps timestamps

service_profile_area

id increments
service_profile_id ^FK integer
type enum
latitude decimal (9,6)
longitude decimal (9,6)
state string (255)
country string (255)
subscription_id ^FK integer

service_admins

id increments
timestamps timestamps
service_profile_id ^FK integer
user_id ^FK integer

file_requests

id increments
timestamps timestamps
lead_id ^FK integer
active_service_id ^FK integer
description string (500)
completed boolean

billing_details

id increments
timestamps timestamps
user_id ^FK integer
business_profile_id ^FK integer
payment_type string (255)
billing_options text

subscriptions

id increments
billing_details_id ^FK integer
timestamps timestamps
plan string (20)
interval_units smallInteger
interval_type enum
fee_cents integer
next_payment_date date

bills

id increments
status enum
next_retry_date date
retry_amount integer
invoice_number string (255)
transaction_id string (255)
amount_due_cents integer
billing_details_id ^FK integer
subscription_id ^FK integer
timestamps timestamps

site_admins

id increments
username string (30)
password string (100)
timestamps timestamps

password_resets

id increments
email string (255)
token string (255)
timestamps timestamps