| id |
int(11)
|
|
|
|
| payload_type |
enum('supplier_invoice', 'card_expense')
|
utf8_general_ci
|
|
|
| idempotency_key |
varchar(64)
|
utf8_general_ci
|
|
|
| n8n_workflow_id |
varchar(64)
|
utf8_general_ci
|
|
|
| n8n_execution_id |
varchar(64)
|
utf8_general_ci
|
|
|
| source_email |
varchar(190)
|
utf8_general_ci
|
|
|
| raw_payload |
longtext
|
utf8_general_ci
|
|
|
| extracted_fields |
longtext
|
utf8_general_ci
|
|
|
| sharepoint_drive_id |
varchar(255)
|
utf8_general_ci
|
|
|
| sharepoint_item_id |
varchar(255)
|
utf8_general_ci
|
|
|
| sharepoint_web_url |
text
|
utf8_general_ci
|
|
|
| attachment_filename |
varchar(255)
|
utf8_general_ci
|
|
|
| attachment_size |
bigint(20)
|
|
|
|
| attachment_mime |
varchar(100)
|
utf8_general_ci
|
|
|
| pdf_file_id |
int(11)
|
|
|
|
| status |
enum('pending', 'edited', 'approved', 'rejected', 'error', 'deleted')
|
utf8_general_ci
|
|
|
| ai_confidence |
decimal(4,3)
|
|
|
|
| error_text |
text
|
utf8_general_ci
|
|
|
| received_at |
datetime
|
|
|
|
| approved_by_staff_id |
int(11)
|
|
|
|
| approved_at |
datetime
|
|
|
|
| native_record_id |
int(11)
|
|
|
|
| native_record_type |
enum('bill', 'expense')
|
utf8_general_ci
|
|
|
| edit_history |
longtext
|
utf8_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|