crm_meeting

660 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 64 null
crm_companies.company_id Implied Constraint R
crm_companies.crm_owner_id Implied Constraint R
crm_contacts.contact_id Implied Constraint R
crm_deals.crm_owner_id Implied Constraint R
crm_deals.deal_id Implied Constraint R
crm_email_engagements.email_id Implied Constraint R
crm_note_engagements.associated_external_calendar_id Implied Constraint R
crm_note_engagements.associated_meeting_source_id Implied Constraint R
crm_note_engagements.note_id Implied Constraint R
crm_owners.owner_id Implied Constraint R
crm_rep.rep_id Implied Constraint R
customer_integration.zoom_recall_id Implied Constraint R
device.device_id Implied Constraint R
integration_settings_salesforce.user_id Implied Constraint R
share_activity_data.generated_note_id Implied Constraint R
user_integration.zoom_recall_id Implied Constraint R
customer_id varchar 8 null
customer.id crm_meeting_customer_id_fkey R
deal_id varchar 8 √ null
crm_deals.id crm_meeting_deal_id_fkey R
company_id varchar 8 √ null
crm_companies.id crm_meeting_company_id_fkey R
contact_id varchar 8 √ null
crm_contacts.id crm_meeting_contact_id_fkey R
meeting_id varchar 64 √ null
owner_id varchar 8 √ null
crm_owner_id varchar 64 √ null
attachment_ids text 2147483647 √ null
guest_owner_ids text 2147483647 √ null
created_by varchar 8 √ null
crm_contacts.id crm_meeting_created_by_fkey R
crm_external_calendar_id varchar 256 √ null
guest_emails _varchar 2147483647 √ null
crm_meeting_notes text 2147483647 √ null
crm_meeting_start_time timestamptz 35,6 √ null
crm_meeting_end_time timestamptz 35,6 √ null
crm_meeting_source varchar 64 √ null
crm_meeting_title text 2147483647 √ null
integration_type customer_level_integrated_app 2147483647 null
deal_association_ids _varchar 2147483647 √ null
contact_association_ids _varchar 2147483647 √ null
company_association_ids _varchar 2147483647 √ null
crm_created_at timestamptz 35,6 √ now()
crm_updated_at timestamptz 35,6 √ now()
created_at timestamptz 35,6 √ now()
updated_at timestamptz 35,6 √ now()
stage varchar 64 √ null

Indexes

Constraint Name Type Sort Column(s)
crm_meeting_pkey Primary key Asc id
crm_meeting_customer_id_meeting_id_uniq Must be unique Asc/Asc customer_id + meeting_id

Relationships

Close relationships within degrees of separation