📋 Tabelas (109)
- access_tokens
- account_saml_settings
- account_users
- accounts
- action_mailbox_inbound_emails
- active_storage_attachments
- active_storage_blobs
- active_storage_variant_records
- agent_bot_inboxes
- agent_bots
- agent_capacity_policies
- applied_slas
- ar_internal_metadata
- article_embeddings
- articles
- assignment_policies
- attachments
- audits
- automation_externals
- automation_rules
- calls
- campaign_executions
- campaigns
- canned_responses
- captain_assistant_responses
- captain_assistants
- captain_custom_tools
- captain_documents
- captain_inboxes
- captain_scenarios
- categories
- channel_api
- channel_email
- channel_facebook_pages
- channel_instagram
- channel_internal
- channel_line
- channel_sms
- channel_telegram
- channel_tiktok
- channel_twilio_sms
- channel_twitter_profiles
- channel_voice
- channel_web_widgets
- channel_whatsapp
- companies
- contact_inboxes
- contacts
- conversation_participants
- conversations
- copilot_messages
- copilot_threads
- csat_survey_responses
- custom_attribute_definitions
- custom_attribute_kanbans
- custom_filters
- custom_roles
- customers
- dashboard_apps
- data_imports
- email_templates
- folders
- funnel_item_checklists
- funnel_item_notes
- funnel_item_participants
- funnel_item_proposals
- funnel_item_tasks
- funnel_items
- funnel_members
- funnel_step_checklists
- funnel_step_messages
- funnel_step_tasks
- funnel_steps
- funnels
- inbox_assignment_policies
- inbox_capacity_limits
- inbox_members
- inboxes
- installation_configs
- integracao_asaas
- integrations_hooks
- labels
- leaves
- macros
- mentions
- messages
- notes
- notification_settings
- notification_subscriptions
- notifications
- platform_app_permissibles
- platform_apps
- portals
- portals_members
- related_categories
- reporting_events
- reporting_events_rollups
- scheduled_messages
- schema_migrations
- sla_events
- sla_policies
- standalone_apps
- taggings
- tags
- team_members
- teams
- users
- webhooks
- working_hours
contacts
Colunas:
19
Registros:
25.243
| Coluna | Tipo de Dado | Nulável | Valor Padrão |
|---|---|---|---|
| id | integer | ✗ Não | nextval('contacts_id_seq'::regclass) |
| name | character varying | ✓ Sim | ''::character varying |
| character varying | ✓ Sim | - | |
| phone_number | character varying | ✓ Sim | - |
| account_id | integer | ✗ Não | - |
| created_at | timestamp without time zone | ✗ Não | - |
| updated_at | timestamp without time zone | ✗ Não | - |
| additional_attributes | jsonb | ✓ Sim | '{}'::jsonb |
| identifier | character varying | ✓ Sim | - |
| custom_attributes | jsonb | ✓ Sim | '{}'::jsonb |
| last_activity_at | timestamp without time zone | ✓ Sim | - |
| contact_type | integer | ✓ Sim | - |
| middle_name | character varying | ✓ Sim | ''::character varying |
| last_name | character varying | ✓ Sim | ''::character varying |
| location | character varying | ✓ Sim | ''::character varying |
| country_code | character varying | ✓ Sim | ''::character varying |
| blocked | boolean | ✗ Não | false |
| enable_bot | boolean | ✓ Sim | true |
| company_id | bigint | ✓ Sim | - |