Insightly
Explore the interactive ERD
Table & Field Reference
contact_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
link_object_id | Unknown | FK |
relationship_id | Unknown | FK |
detail | Unknown | |
is_forward | Unknown | |
link_object_name | Unknown | |
role | Unknown |
contact_date
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | PKFK |
create_task_yearly | Unknown | |
occasion_date | Unknown | |
occasion_name | Unknown | |
repeat_yearly | Unknown |
contact_tag
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
contact_id | Unknown | PKFK |
contact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_user_id | Unknown | FK |
organisation_id | Unknown | FK |
owner_user_id | Unknown | FK |
address_mail_city | Unknown | |
address_mail_country | Unknown | |
address_mail_postcode | Unknown | |
address_mail_state | Unknown | |
address_mail_street | Unknown | |
address_other_city | Unknown | |
address_other_country | Unknown | |
address_other_postcode | Unknown | |
address_other_state | Unknown | |
address_other_street | Unknown | |
assistant_name | Unknown | |
background | Unknown | |
date_created_utc | Unknown | |
date_of_birth | Unknown | |
date_updated_utc | Unknown | |
email_address | Unknown | |
email_opted_out | Unknown | |
first_name | Unknown | |
image_url | Unknown | |
last_activity_date_utc | Unknown | |
last_name | Unknown | |
next_activity_date_utc | Unknown | |
phone | Unknown | |
phone_assistant | Unknown | |
phone_fax | Unknown | |
phone_home | Unknown | |
phone_mobile | Unknown | |
phone_other | Unknown | |
salutation | Unknown | |
social_facebook | Unknown | |
social_linkedin | Unknown | |
social_twitter | Unknown | |
title | Unknown | |
custom_** |
lead_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
default_status | Unknown | |
field_order | Unknown | |
status | Unknown | |
status_type | Unknown |
note_file_attachment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
note_id | Unknown | FK |
owner_user_id | Unknown | FK |
content_type | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
file_category_id | Unknown | |
file_name | Unknown | |
file_size | Unknown | |
url | Unknown |
custom_field_option
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
custom_field_custom_object_name | Unknown | PKFK |
custom_field_name | Unknown | PKFK |
option_default | Unknown | |
option_value | Unknown |
custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
custom_object_name | Unknown | PKFK |
default_value | Unknown | |
editable | Unknown | |
field_for | Unknown | |
field_help_text | Unknown | |
field_label | Unknown | |
field_order | Unknown | |
field_type | Unknown | |
join_object | Unknown | |
visible | Unknown |
email_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
email_id | Unknown | FK |
link_object_id | Unknown | FK |
relationship_id | Unknown | FK |
detail | Unknown | |
is_forward | Unknown | |
link_object_name | Unknown | |
role | Unknown |
email_tag
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
email_id | Unknown | PKFK |
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_user_id | Unknown | FK |
owner_user_id | Unknown | FK |
date_created_utc | Unknown | |
email_date_utc | Unknown | |
email_from | Unknown | |
format | Unknown | |
queued_send_date_utc | Unknown | |
size | Unknown | |
subject | Unknown |
event_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_id | Unknown | FK |
link_object_id | Unknown | FK |
relationship_id | Unknown | FK |
detail | Unknown | |
is_forward | Unknown | |
link_object_name | Unknown | |
role | Unknown |
event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
owner_user_id | Unknown | FK |
all_day | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
details | Unknown | |
end_date_utc | Unknown | |
location | Unknown | |
reminder_date_utc | Unknown | |
reminder_sent | Unknown | |
start_date_utc | Unknown | |
title | Unknown | |
custom_** |
contact_file_attachment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
owner_user_id | Unknown | FK |
content_type | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
file_category_id | Unknown | |
file_name | Unknown | |
file_size | Unknown | |
url | Unknown |
quote_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
opportunity_item_id | Unknown | FK |
price_book_entry_id | Unknown | FK |
quote_id | Unknown | FK |
currency_code | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
description | Unknown | |
discount | Unknown | |
list_price | Unknown | |
quantity | Unknown | |
sort_order | Unknown | |
subtotal | Unknown | |
total_price | Unknown | |
unit_price | Unknown | |
custom_** |
email_file_attachment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
email_id | Unknown | FK |
owner_user_id | Unknown | FK |
content_type | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
file_category_id | Unknown | |
file_name | Unknown | |
file_size | Unknown | |
url | Unknown |
forum_post
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_contact_id | Unknown | FK |
edited_contact_id | Unknown | FK |
forum_id | Unknown | FK |
ticket_id | Unknown | FK |
closed | Unknown | |
comment_count | Unknown | |
date_created | Unknown | |
date_edited | Unknown | |
date_update | Unknown | |
downvote_count | Unknown | |
featured | Unknown | |
follower_count | Unknown | |
message | Unknown | |
pending | Unknown | |
pinned | Unknown | |
post_name | Unknown | |
spam | Unknown | |
status | Unknown | |
upvote_count | Unknown |
project_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
background_color | Unknown | |
name | Unknown |
product
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_user_id | Unknown | FK |
owner_user_id | Unknown | FK |
active | Unknown | |
code | Unknown | |
currency_code | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
default_price | Unknown | |
description | Unknown | |
family | Unknown | |
image_url | Unknown | |
name | Unknown | |
sku | Unknown | |
custom_** |
quote_document
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
owner_user_id | Unknown | FK |
quote_id | Unknown | FK |
currency_code | Unknown | |
date_created_utc | Unknown | |
file_id | Unknown | |
file_name | Unknown | |
quotation_name | Unknown |
task_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
link_object_id | Unknown | FK |
relationship_id | Unknown | FK |
task_id | Unknown | FK |
detail | Unknown | |
is_forward | Unknown | |
link_object_name | Unknown | |
role | Unknown |
task
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assigned_by_user_id | Unknown | FK |
assigned_team_id | Unknown | FK |
created_user_id | Unknown | FK |
email_id | Unknown | FK |
milestone_id | Unknown | FK |
opportunity_id | Unknown | FK |
owner_user_id | Unknown | FK |
parent_task_id | Unknown | FK |
project_id | Unknown | FK |
responsible_user_id | Unknown | FK |
stage_id | Unknown | FK |
task_category_id | Unknown | FK |
assigned_date_utc | Unknown | |
completed | Unknown | |
completed_date_utc | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
details | Unknown | |
due_date | Unknown | |
owner_visible | Unknown | |
percent_complete | Unknown | |
priority | Unknown | |
publicly_visible | Unknown | |
recurrence | Unknown | |
reminder_date_utc | Unknown | |
reminder_sent | Unknown | |
start_date | Unknown | |
status | Unknown | |
title | Unknown | |
custom_** |
pipeline_stage
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
activity_set_id | Unknown | FK |
owner_user_id | Unknown | FK |
pipeline_id | Unknown | FK |
stage_name | Unknown | |
stage_order | Unknown |
project_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
link_object_id | Unknown | FK |
project_id | Unknown | FK |
relationship_id | Unknown | FK |
detail | Unknown | |
is_forward | Unknown | |
link_object_name | Unknown | |
role | Unknown |
project_tag
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
project_id | Unknown | PKFK |
project
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_user_id | Unknown | FK |
opportunity_id | Unknown | FK |
owner_user_id | Unknown | FK |
pipeline_id | Unknown | FK |
project_category_id | Unknown | FK |
responsible_user_id | Unknown | FK |
stage_id | Unknown | FK |
completed_date | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
image_url | Unknown | |
last_activity_date_utc | Unknown | |
next_activity_date_utc | Unknown | |
project_details | Unknown | |
project_name | Unknown | |
started_date | Unknown | |
status | Unknown | |
custom_** |
task_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
background_color | Unknown | |
name | Unknown |
lead_source
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
default_value | Unknown | |
field_order | Unknown | |
name | Unknown |
organisation_email_domain
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organisation_id | Unknown | PKFK |
email_domain | Unknown |
organisation_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
link_object_id | Unknown | FK |
organisation_id | Unknown | FK |
relationship_id | Unknown | FK |
detail | Unknown | |
is_forward | Unknown | |
link_object_name | Unknown | |
role | Unknown |
organisation_date
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organisation_id | Unknown | PKFK |
create_task_yearly | Unknown | |
occasion_date | Unknown | |
occasion_name | Unknown | |
repeat_yearly | Unknown |
organisation_tag
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
organisation_id | Unknown | PKFK |
organisation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_user_id | Unknown | FK |
owner_user_id | Unknown | FK |
visible_team_id | Unknown | FK |
address_billing_city | Unknown | |
address_billing_country | Unknown | |
address_billing_postcode | Unknown | |
address_billing_state | Unknown | |
address_billing_street | Unknown | |
address_ship_city | Unknown | |
address_ship_country | Unknown | |
address_ship_postcode | Unknown | |
address_ship_state | Unknown | |
address_ship_street | Unknown | |
background | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
image_url | Unknown | |
last_activity_date_utc | Unknown | |
name | Unknown | |
next_activity_date_utc | Unknown | |
phone | Unknown | |
phone_fax | Unknown | |
social_facebook | Unknown | |
social_linkedin | Unknown | |
social_twitter | Unknown | |
website | Unknown | |
custom_** |
prospect_tag
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
prospect_id | Unknown | PKFK |
prospect
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
created_user_id | Unknown | FK |
lead_id | Unknown | FK |
organisation_id | Unknown | FK |
owner_user_id | Unknown | FK |
address_city | Unknown | |
address_country | Unknown | |
address_postcode | Unknown | |
address_state | Unknown | |
address_street | Unknown | |
date_created | Unknown | |
date_update | Unknown | |
description | Unknown | |
do_not_call | Unknown | |
do_not_email | Unknown | |
do_not_sync | Unknown | |
email_address | Unknown | |
employee_count | Unknown | |
fax | Unknown | |
first_name | Unknown | |
grade | Unknown | |
grade_profile_id | Unknown | |
industry | Unknown | |
last_activity_date | Unknown | |
last_name | Unknown | |
lead_conversion_date | Unknown | |
mobile | Unknown | |
opted_out | Unknown | |
organisation_name | Unknown | |
phone | Unknown | |
salutation | Unknown | |
score | Unknown | |
title | Unknown | |
custom_** |
custom_object
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
created_user_id | Unknown | FK |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
description | Unknown | |
enable_navbar | Unknown | |
enable_workflow | Unknown | |
plural_label | Unknown | |
record_name_display_format | Unknown | |
record_name_label | Unknown | |
record_name_type | Unknown | |
singular_label | Unknown |
relationship
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
for_contacts | Unknown | |
for_organisations | Unknown | |
forward | Unknown | |
forward_title | Unknown | |
reverse | Unknown | |
reverse_title | Unknown |
opportunity_state_history
| Column | Type | Keys |
|---|---|---|
date_changed | Unknown | PK |
opportunity_id | Unknown | PKFK |
for_opportunity_state | Unknown | |
state_reason | Unknown | |
state_reason_id | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
account_owner | Unknown | |
active | Unknown | |
administrator | Unknown | |
contact_display | Unknown | |
contact_order | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
email_address | Unknown | |
email_drop_box_address | Unknown | |
email_drop_box_identifier | Unknown | |
first_name | Unknown | |
instance_id | Unknown | |
last_name | Unknown | |
profile_id | Unknown | |
role_id | Unknown | |
task_week_start | Unknown | |
timezone_id | Unknown | |
user_currency | Unknown |
quote
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
created_user_id | Unknown | FK |
opportunity_id | Unknown | FK |
organisation_id | Unknown | FK |
owner_user_id | Unknown | FK |
price_book_id | Unknown | FK |
address_billing_city | Unknown | |
address_billing_country | Unknown | |
address_billing_name | Unknown | |
address_billing_postcode | Unknown | |
address_billing_state | Unknown | |
address_billing_street | Unknown | |
address_shipping_city | Unknown | |
address_shipping_country | Unknown | |
address_shipping_name | Unknown | |
address_shipping_postcode | Unknown | |
address_shipping_state | Unknown | |
address_shipping_street | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
discount | Unknown | |
grand_total | Unknown | |
is_syncing | Unknown | |
line_item_count | Unknown | |
quotation_currency_code | Unknown | |
quotation_description | Unknown | |
quotation_email | Unknown | |
quotation_expiration_date | Unknown | |
quotation_fax | Unknown | |
quotation_name | Unknown | |
quotation_number | Unknown | |
quotation_phone | Unknown | |
quote_status | Unknown | |
shipping_handling | Unknown | |
subtotal | Unknown | |
tax | Unknown | |
total_price | Unknown | |
custom_** |
opportunity_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
background_color | Unknown | |
name | Unknown |
milestone
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
owner_user_id | Unknown | FK |
project_id | Unknown | FK |
completed | Unknown | |
completed_date_utc | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
due_date | Unknown | |
responsible_user | Unknown | |
title | Unknown |
note_comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
owner_user_id | Unknown | PKFK |
comment_id | Unknown | FK |
note_id | Unknown | FK |
organisation_file_attachment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organisation_id | Unknown | FK |
owner_user_id | Unknown | FK |
content_type | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
file_category_id | Unknown | |
file_name | Unknown | |
file_size | Unknown | |
url | Unknown |
price_book
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_user_id | Unknown | FK |
owner_user_id | Unknown | FK |
active | Unknown | |
currency_code | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
description | Unknown | |
is_standard | Unknown | |
name | Unknown |
note_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
link_object_id | Unknown | FK |
note_id | Unknown | FK |
relationship_id | Unknown | FK |
detail | Unknown | |
is_forward | Unknown | |
link_object_name | Unknown | |
role | Unknown |
note
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
owner_user_id | Unknown | FK |
body | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
title | Unknown |
activity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
activity_set_id | Unknown | PKFK |
assigned_team_id | Unknown | FK |
owner_user_id | Unknown | FK |
responsible_user_id | Unknown | FK |
all_day | Unknown | |
category_id | Unknown | |
details | Unknown | |
due_days_after_start | Unknown | |
due_days_before_end | Unknown | |
duration | Unknown | |
event_days_after_start | Unknown | |
event_days_before_end | Unknown | |
event_time | Unknown | |
name | Unknown | |
owner_visible | Unknown | |
publicly_visible | Unknown | |
reminder | Unknown | |
reminder_days_before_due | Unknown | |
reminder_time | Unknown | |
skip_fri | Unknown | |
skip_mon | Unknown | |
skip_sat | Unknown | |
skip_sun | Unknown | |
skip_thu | Unknown | |
skip_tue | Unknown | |
skip_wed | Unknown | |
type | Unknown |
activity_set
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
owner_user_id | Unknown | FK |
for_contact | Unknown | |
for_lead | Unknown | |
for_opportunity | Unknown | |
for_organisation | Unknown | |
for_project | Unknown | |
name | Unknown |
pipeline
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
owner_user_id | Unknown | FK |
for_opportunities | Unknown | |
for_projects | Unknown | |
pipeline_name | Unknown |
opportunity_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
opportunity_id | Unknown | FK |
price_book_entry_id | Unknown | FK |
currency_code | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
description | Unknown | |
discount | Unknown | |
list_price | Unknown | |
quantity | Unknown | |
service_date | Unknown | |
subtotal | Unknown | |
total_price | Unknown | |
unit_price | Unknown | |
custom_** |
forum_comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_contact_id | Unknown | FK |
edited_contact_id | Unknown | FK |
forum_id | Unknown | FK |
post_id | Unknown | FK |
answer | Unknown | |
body | Unknown | |
date_created | Unknown | |
date_edited | Unknown | |
date_update | Unknown | |
downvote_count | Unknown | |
official | Unknown | |
pending | Unknown | |
spam | Unknown | |
upvote_count | Unknown |
price_book_entry
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_user_id | Unknown | FK |
price_book_id | Unknown | FK |
product_id | Unknown | FK |
active | Unknown | |
currency_code | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
price | Unknown | |
use_standard_price | Unknown | |
custom_** |
lead_file_attachment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
lead_id | Unknown | FK |
owner_user_id | Unknown | FK |
content_type | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
file_category_id | Unknown | |
file_name | Unknown | |
file_size | Unknown | |
url | Unknown |
forum_category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_date | Unknown | |
name | Unknown | |
updated_date | Unknown |
ticket_tag
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
ticket_id | Unknown | PKFK |
ticket
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
created_user_id | Unknown | FK |
organisation_id | Unknown | FK |
owner_user_id | Unknown | FK |
date_closed | Unknown | |
date_created | Unknown | |
date_solved | Unknown | |
date_updated | Unknown | |
priority | Unknown | |
source | Unknown | |
subject | Unknown | |
ticket_comment_body | Unknown | |
ticket_number | Unknown | |
ticket_status | Unknown | |
ticket_type | Unknown | |
to_email_address | Unknown | |
custom_** |
team_member
| Column | Type | Keys |
|---|---|---|
permission_id | Unknown | PK |
member_user_id | Unknown | PKFK |
team_id | Unknown | PKFK |
team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
name | Unknown |
opportunity_file_attachment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
opportunity_id | Unknown | FK |
owner_user_id | Unknown | FK |
content_type | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
file_category_id | Unknown | |
file_name | Unknown | |
file_size | Unknown | |
url | Unknown |
custom_object_record
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
owner_user_id | Unknown | FK |
visible_team_id | Unknown | FK |
date_created_utc | Unknown | |
record_name | Unknown | |
visible_to | Unknown | |
custom_** |
opportunity_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
link_object_id | Unknown | FK |
opportunity_id | Unknown | FK |
relationship_id | Unknown | FK |
detail | Unknown | |
is_forward | Unknown | |
link_object_name | Unknown | |
role | Unknown |
opportunity_tag
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
opportunity_id | Unknown | PKFK |
opportunity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_user_id | Unknown | FK |
opportunity_category_id | Unknown | FK |
organisation_id | Unknown | FK |
owner_user_id | Unknown | FK |
pipeline_id | Unknown | FK |
price_book_id | Unknown | FK |
responsible_user_id | Unknown | FK |
stage_id | Unknown | FK |
actual_close_date | Unknown | |
bid_amount | Unknown | |
bid_currency | Unknown | |
bid_duration | Unknown | |
bid_type | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
details | Unknown | |
forecast_close_date | Unknown | |
image_url | Unknown | |
last_activity_date_utc | Unknown | |
name | Unknown | |
next_activity_date_utc | Unknown | |
probability | Unknown | |
state | Unknown | |
value | Unknown | |
custom_** |
forum
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_user_id | Unknown | FK |
forum_category_id | Unknown | FK |
date_created | Unknown | |
date_updated | Unknown | |
description | Unknown | |
forum_name | Unknown | |
forum_order | Unknown | |
forum_type | Unknown | |
visibility | Unknown |
lead_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
lead_id | Unknown | FK |
link_object_id | Unknown | FK |
relationship_id | Unknown | FK |
detail | Unknown | |
is_forward | Unknown | |
link_object_name | Unknown | |
role | Unknown |
lead_tag
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
lead_id | Unknown | PKFK |
lead
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
converted_contact_id | Unknown | FK |
converted_opportunity_id | Unknown | FK |
converted_organisation_id | Unknown | FK |
created_user_id | Unknown | FK |
lead_source_id | Unknown | FK |
lead_status_id | Unknown | FK |
owner_user_id | Unknown | FK |
responsible_user_id | Unknown | FK |
address_city | Unknown | |
address_country | Unknown | |
address_postcode | Unknown | |
address_state | Unknown | |
address_street | Unknown | |
converted | Unknown | |
converted_date_utc | Unknown | |
date_created_utc | Unknown | |
date_updated_utc | Unknown | |
email | Unknown | |
email_opted_out | Unknown | |
fax | Unknown | |
first_name | Unknown | |
image_url | Unknown | |
industry | Unknown | |
last_activity_date_utc | Unknown | |
last_name | Unknown | |
lead_description | Unknown | |
lead_rating | Unknown | |
mobile | Unknown | |
next_activity_date_utc | Unknown | |
phone | Unknown | |
salutation | Unknown | |
title | Unknown | |
website | Unknown | |
custom_** |