saas_schema - Laravel Schema Designer

users

id increments
name string (255)
middle_name string (255)
last_name string (255)
email string (255)
email_verified_at timestamp
password string
phone string
type enum
lang string
status enum
remember_token string
country_id bigInteger
current_team_id bigInteger
profile_photo_path string (2048)
timestamps timestamps

plans

id increments
user_id ^FK bigInteger
title string (255)
description longText
available_features longText
not_available_features longText
trial_period double
monthly_price double
annual_price double
lifetime_price double
monthly_discount double
is_paid boolean
status boolean
timestamps timestamps

countries

id increments
name string (50)
time_zone string
timestamps timestamps

payment_plans

id increments
plan_id ^FK bigInteger
payment_gateway_id bigInteger
monthly_price_id string
annual_price_id string
lifetime_price_id string
timestamps timestamps

payment_gateways

id increments
timestamps timestamps
name string
icon string
enable_gateway boolean
mode enum
currency string (20)
currency_locale string (20)
tax_rate double
base_url string
api_key_live string
api_secret_live string
api_key_sandbox string
api_secret_sandbox string

payments

id increments
subscription_id ^FK bigInteger
payment_id string
status string
refunded_at timestamp
timestamps timestamps

subscriptions

id increments
user_id ^FK bigInteger
plan_id ^FK bigInteger
payment_gateway_id ^FK bigInteger
ends_at timestamp
type string
status string (20)
paymet_subscription_id string
payment_price_id string
timestamps timestamps
cancelled_at timestamp

features

id increments
title string
timestamps timestamps

plan_feature

id increments
plan_id ^FK bigInteger
feature_id ^FK bigInteger
timestamps timestamps

tickets

id increments
ticket_category_id bigInteger
ticket_priority_id bigInteger
ticket_status string
conversation_id string
user_email string
user_name string
user_phone string
subject string
description text
timestamps timestamps

ticket_categories

id increments
name string
color string
timestamps timestamps

ticket_replies

id increments
ticket_id bigInteger
user_email string
reply longText
timestamps timestamps

posts

id increments
title string
slug string
content longText
post_type enum
meta_page_title string
meta_description string
featured_image string
status enum
allow_comments boolean
timestamps timestamps

post_categories

id increments
name string
slug string
parent_id ^FK bigInteger
description text
timestamps timestamps

post_post_category

id increments
post_id bigInteger
post_category_id bigInteger
timestamps timestamps

tags

id increments
name string
slug string
description text
timestamps timestamps

comments

id increments
user_id ^FK bigInteger
post_id bigInteger
parent_id ^FK bigInteger
content longText
timestamps timestamps

reviews

id increments
user_id ^FK bigInteger
rating double
review text
is_featured boolean
timestamps timestamps

coupons

id increments
is_active boolean
code string
notes text
starts_at timestamp
ends_at timestamp
discount double
discount_renewals boolean
apply_to_payment enum
one_redemption_per_user boolean
total_redemptions_limit integer
who_can_use enum
apply_to_plan enum
specific_plans string
timestamps timestamps

coupon_usages

id increments
user_id bigInteger
coupon_id ^FK bigInteger
subscription_id bigInteger
payment_id bigInteger
timestamps timestamps

affiliation_settings

id increments
is_active boolean
is_renewal boolean
commission double
cookie_expiration double
minimum_withdrawal double
timestamps timestamps

affiliates

id increments
user_id ^FK bigInteger
code string
is_active boolean
payment_email string
timestamps timestamps

affiliate_commissions

id increments
affiliate_id ^FK bigInteger
subscription_id bigInteger
amount double
available_at timestamp
paid_at timestamp
timestamps timestamps

affiliate_visits

id increments
affiliate_id bigInteger
session_id string
visitor_ip string
visited_at timestamp
converted boolean
timestamps timestamps

attachments

id increments
model string
model_id bigInteger
file_path string
timestamps timestamps

ticket_priorities

id increments
name string
color string
timestamps timestamps

ticket_saved_replies

id increments
title string
content text
timestamps timestamps

languages

id increments
name string
symbol string
is_default boolean
timestamps timestamps

settings

id increments
site_name string
site_url string
site_email string
default_currency string
default_storage string
default_language string
allow_comments boolean
is_privacy_active boolean
show_privacy_on_login boolean
privacy_policy longText
terms_conditions longText
timestamps timestamps

email_templates

id increments
title string
body_html string
recipient_type enum
is_active boolean
timestamps timestamps

email_settings

id increments
email_protocol string
sender_name string
test_email_to string
smtp_host string
smtp_user string
smtp_password string
smtp_port integer
timestamps timestamps

post_tag

id increments
post_id ^FK bigInteger
tag_id ^FK bigInteger
timestamps timestamps

post_views

id increments
post_id ^FK bigInteger
session_id string
visitor_ip string
visited_at timestamp

ticket_settings

id increments
auto_reply boolean
auto_reply_subject string
auto_reply_message longText
status_after_reply string
signature text
timestamps timestamps