Modelo de dados inicial

email_accounts

Armazena as contas de e-mail monitoradas.

id
name
email
imap_host
imap_port
imap_encryption
smtp_host
smtp_port
smtp_encryption
username
password_encrypted
active
created_at
updated_at

email_folders

Armazena as pastas que podem ser monitoradas.

id
email_account_id
folder_name
folder_path
monitoring_enabled
created_at
updated_at

email_messages

Armazena os e-mails coletados.

id
email_account_id
message_uid
message_id_header
folder
from_name
from_email
to_email
subject
body_text
body_html
received_at
has_attachments
raw_metadata_json
processing_status
created_at
updated_at

Índice recomendado

unique(email_account_id, folder, message_uid)

email_classifications

Armazena o resultado da classificação feita pela IA.

id
email_message_id
priority
category
requires_action
requires_reply
suggested_owner
suggested_deadline
summary
risk
confidence
ai_model
created_at
updated_at

email_suggested_actions

Armazena ações sugeridas pela IA.

id
email_message_id
action_type
description
suggested_owner
deadline
status
approved_by
approved_at
created_at
updated_at

email_suggested_replies

Armazena respostas sugeridas, editadas e aprovadas.

id
email_message_id
reply_text
status
edited_text
approved_by
approved_at
sent_at
created_at
updated_at

assistant_rules

Armazena regras ajustáveis de prioridade, categoria e delegação.

id
rule_type
name
conditions_json
actions_json
active
created_at
updated_at

assistant_audit_logs

Armazena rastreabilidade das ações.

id
entity_type
entity_id
action
old_value
new_value
user_id
created_at