dovehero - Laravel Schema Designer

users

id increments
is_verified tinyInteger
first_name string (255)
last_name string (255)
language_id integer
email string (255)
password string (255)
phone_code string (255)
phone_number string (100)
is_active tinyInteger
remember_token string (100)
timestamps timestamps
date_format string (255)
softDeletes softDeletes
verified_at timestamps
is_2fa_active tinyInteger
avatar text
time_format string (255)
connected_email string (255)
connected_email_token text
connected_email_alias string (255)
connected_email_signature text
unsubscribe_type tinyInteger
is_unsubscribe tinyInteger
whatsapp_number string (255)
verified_code string (255)
verified_expires_at timestamp
type_2fa tinyInteger
google_secret text

oauth_access_tokens

id increments
user_id bigInteger
client_id bigInteger
name string (255)
scopes text
revoked tinyInteger
expires_at datetime
timestamps timestamps

oauth_clients

id increments
user_id bigInteger
name string (255)
secret string (100)
provider string (255)
redirect text
personal_access_client tinyInteger
password_client tinyInteger
revoked tinyInteger
timestamps timestamps

oauth_refresh_tokens

id increments
access_token_id string (100)
revoked tinyInteger
expires_at datetime

password_resets

email string (255)
token string (255)
created_at timestamps

roles

id increments
name string (191)
guard_name string (191)
timestamps timestamps

permissions

id increments
timestamps timestamps
name string (191)
guard_name string (191)

role_has_permissions

permission_id integer
role_id integer

model_has_permissions

permission_id integer
model_id integer
model_type string (191)

model_has_roles

role_id integer
model_id integer
model_type string (191)

property_groups

id increments
account_id bigInteger
property_object_id bigInteger
name string (255)
default tinyInteger
timestamps timestamps

properties

id increments
account_id integer
object_id bigInteger
property_group_id bigInteger
rule_group smallInteger
label string (255)
description text
property_type integer
sort_type tinyInteger
default tinyInteger
archived tinyInteger
archived_at timestamp
timestamps timestamps

accounts

id increments
name string (255)
timestamps timestamps
uuid string (255)
timezone string (255)
domain string (255)
address string (255)
address_2 string (255)
city string (255)
state string (255)
zip string
country string (255)
industry_id bigInteger
date_format string (255)
softDeletes softDeletes

contacts

id increments
account_id bigInteger
owner_id bigInteger
object_id bigInteger
status tinyInteger
first_name string (255)
last_name string (255)
email string (255)
avatar text
properties jsonb
timestamps timestamps

tags

id increments
account_id bigInteger
name string (255)
timestamps timestamps

icebreakers

id increments
contact_id bigInteger
content text
is_last_used tinyInteger
timestamps timestamps

contact_notes

id increments
contact_id bigInteger
content text
timestamps timestamps

contact_emails

id increments
timestamps timestamps
from_email string (255)
to_email string (255)
subject string (255)
body text

contact_email_queues

id increments
contact_email_id bigInteger
scheduled_at timestamps
status tinyInteger
timestamps timestamps

contact_email_trackings

id increments
timestamps timestamps
contact_email_queue_id bigInteger
sent_at timestamps
opened_at timestamps
replied_at timestamps

contact_calls

id increments
timestamps timestamps
direction tinyInteger
outcome integer
duration bigInteger
description text

contact_meetings

id increments
timestamps timestamps
organized_by string (255)
description text
outcome integer
attendees integer
duration integer

contact_tasks

id increments
timestamps timestamps
title string (255)
due_date datetime
reminder datetime
repeat_period integer
repeat_tyype integer
type tinyInteger
priority tinyInteger
assigned_user_id bigInteger

objects

id increments
name string (255)
key string (255)
timestamps timestamps
property_name string (255)

object_forms

id increments
type smallInteger
schema jsonb
timestamps timestamps
object_id bigInteger

account_user

id increments
user_id bigInteger
account_id bigInteger
role_id bigInteger
timestamps timestamps

languages

id increments
name string (255)
timestamps timestamps

email_connections

id increments
timestamps timestamps
token text

associations

id increments
account_id bigInteger
association_type_id bigInteger
limit integer
timestamps timestamps

industries

id increments
name string (255)
timestamps timestamps

companies

id increments
name string (255)
domain string (255)
avatar text
timestamps timestamps
account_id bigInteger
owner_id bigInteger

leads

id increments
timestamps timestamps

deals

id increments
timestamps timestamps

association_types

id increments
timestamps timestamps
name string (255)
from_object_id bigInteger
to_object_id bigInteger

association_details

id increments
association_type_id bigInteger
association_id bigInteger
from_entity_id bigInteger
to_entity_id bigInteger
timestamps timestamps

labels

id increments
account_id bigInteger
association_type_id bigInteger
name string (255)
limit integer
from_object_name string (255)
to_object_name string (255)
created_by integer
timestamps timestamps

label_details

id increments
account_id bigInteger
label_id bigInteger
association_detail_id bigInteger
from_entity_id bigInteger
to_entity_id bigInteger
from_object_name string (255)
to_object_name string (255)
timestamps timestamps
internal_name string (255)

contact_setups

id increments
account_id bigInteger
is_auto_assign_company_owner tinyInteger
is_auto_fill_contact_details tinyInteger
preferred_state_format string (255)
preferred_country_format string (255)
timestamps timestamps

company_setups

id increments
account_id bigInteger
is_auto_associate_contacts tinyInteger
is_auto_fill_company_properties tinyInteger
timestamps timestamps

lead_setups

id increments
account_id bigInteger
is_sync_lead_owner tinyInteger
timestamps timestamps

deal_setups

id increments
account_id bigInteger
deffault_deal_amount tinyInteger
is_show_deal_insights tinyInteger
is_allow_add_collaborator tinyInteger
apply_default_close_date tinyInteger
end_of_a_certain_period tinyInteger
deal_creation_time integer
deal_creation_period tinyInteger
timestamps timestamps

lifecycle_stages

id increments
name string (255)
timestamps timestamps
position integer

lifecycle_stage_configs

id increments
is_sync_stages tinyInteger
contact_or_company_on_created_stage_id integer
deal_on_created_stage_id integer
deal_on_won_stage_id integer
timestamps timestamps

property_rules

id increments
property_id integer
rule_id integer
value integer
timestamps timestamps

property_values

id increments
property_id integer
account_id integer
property_type integer
position integer
key string (255)
value string (255)
type_element string (255)
in_form tinyInteger
timestamps timestamps

rules

id increments
rule_group integer
name text
type integer
timestamps timestamps

form_customs

id increments
account_id integer
object_id integer
timestamps timestamps

property_objects

id increments
name string (255)
timestamps timestamps

form_properties

id increments
form_custom_id bigInteger
property_id bigInteger
position bigInteger
required tinyInteger
timestamps timestamps

conditional_controlling_properties

id increments
account_id bigInteger
object_id bigInteger
property_id bigInteger
condition_value bigInteger
timestamps timestamps

conditional_dependent_properties

id increments
controlling_property_id bigInteger
property_id bigInteger
position bigInteger
required tinyInteger
timestamps timestamps

contact_accounts

id increments
timestamps timestamps
account_id bigInteger

contact_acccount_property_values

id increments
contact_account_id bigInteger
property_id bigInteger
value text
source smallInteger
timestamps timestamps
deleted_at timestamps

form_associations

id increments
timestamps timestamps
form_custom_id bigInteger
object_id bigInteger

contact_acccount_association_values

id increments
timestamps timestamps
form_association_id bigInteger
value text

taggables

id increments
tag_id bigInteger
taggable_id bigInteger
taggable_type string (255)
timestamps timestamps