{"schema":{"bank_transactions":{"type":"collection","engine":"v2","columns":{"customer_id":{"type":"String","nullable":false,"link":"customers.customer_id"},"description":{"type":"Text","nullable":false,"analyzer":"standard"},"vendor_name":{"type":"Text","nullable":true,"analyzer":"standard"},"amount":{"type":"Decimal","nullable":false},"bank":{"type":"String","nullable":false},"transaction_id":{"type":"String","nullable":false},"invoice_id":{"type":"String","nullable":true,"link":"invoices.invoice_id"}}},"cache_entries":{"type":"table","engine":"v1","columns":{"created_at":{"type":"Int","nullable":false},"key":{"type":"String","nullable":false},"ttl":{"type":"Int","nullable":false},"value":{"type":"Text","nullable":false,"analyzer":"standard"}}},"corporate_entities":{"type":"collection","engine":"v2","columns":{"city":{"type":"String","nullable":true},"name":{"type":"Text","nullable":false,"analyzer":"standard"},"industry":{"type":"String","nullable":true},"industry_code":{"type":"String","nullable":true},"business_id":{"type":"String","nullable":false},"registration_date":{"type":"String","nullable":true}}},"customers":{"type":"collection","engine":"v2","columns":{"name":{"type":"String","nullable":false},"size_tier":{"type":"String","nullable":false},"customer_id":{"type":"String","nullable":false},"employee_count":{"type":"Int","nullable":false},"invoice_count":{"type":"Int","nullable":false}}},"employees":{"type":"collection","engine":"v2","columns":{"employee_id":{"type":"String","nullable":false},"name":{"type":"String","nullable":false},"customer_id":{"type":"String","nullable":false,"link":"customers.customer_id"},"role":{"type":"String","nullable":false},"supervisor_id":{"type":"String","nullable":true,"link":"employees.employee_id"},"department":{"type":"String","nullable":false},"active":{"type":"Boolean","nullable":false}}},"help_articles":{"type":"collection","engine":"v2","columns":{"body":{"type":"Text","nullable":false,"analyzer":"english"},"customer_id":{"type":"String","nullable":false},"tags":{"type":"Text","nullable":true,"analyzer":"english"},"article_id":{"type":"String","nullable":false},"category":{"type":"String","nullable":false},"title":{"type":"Text","nullable":false,"analyzer":"english"},"page_context":{"type":"String","nullable":true}}},"help_impressions":{"type":"collection","engine":"v2","columns":{"prev_article_id":{"type":"String","nullable":true,"link":"help_articles.article_id"},"customer_id":{"type":"String","nullable":false},"timestamp":{"type":"Int","nullable":false},"clicked":{"type":"Boolean","nullable":false},"page":{"type":"String","nullable":false},"query":{"type":"Text","nullable":true,"analyzer":"english"},"impression_id":{"type":"String","nullable":false},"article_id":{"type":"String","nullable":false,"link":"help_articles.article_id"}}},"invoices":{"type":"collection","engine":"v2","columns":{"reference":{"type":"Text","nullable":false,"analyzer":"standard"},"customer_id":{"type":"String","nullable":false,"link":"customers.customer_id"},"amount_band":{"type":"String","nullable":false},"description":{"type":"Text","nullable":false,"analyzer":"standard"},"amount":{"type":"Decimal","nullable":false},"gl_code":{"type":"String","nullable":false},"vat_pct":{"type":"String","nullable":false},"approver":{"type":"String","nullable":false,"link":"employees.employee_id"},"payment_method":{"type":"String","nullable":false},"vendor_country":{"type":"String","nullable":false},"due_days":{"type":"Int","nullable":false},"processor":{"type":"String","nullable":false,"link":"employees.employee_id"},"cost_centre":{"type":"String","nullable":false},"routed":{"type":"Boolean","nullable":false},"routed_by":{"type":"String","nullable":false},"category":{"type":"String","nullable":false},"vendor_business_id":{"type":"String","nullable":false,"link":"corporate_entities.business_id"},"vendor":{"type":"String","nullable":false},"invoice_date":{"type":"String","nullable":false},"invoice_id":{"type":"String","nullable":false}}},"overrides":{"type":"collection","engine":"v2","columns":{"confidence_was":{"type":"Decimal","nullable":false},"corrected_by":{"type":"String","nullable":false},"customer_id":{"type":"String","nullable":false,"link":"customers.customer_id"},"field":{"type":"String","nullable":false},"predicted_value":{"type":"String","nullable":false},"corrected_value":{"type":"String","nullable":false},"override_id":{"type":"String","nullable":false},"invoice_id":{"type":"String","nullable":false,"link":"invoices.invoice_id"}}},"precompute_entries":{"type":"table","engine":"v1","columns":{"computed_at":{"type":"Int","nullable":false},"name":{"type":"String","nullable":false},"payload":{"type":"Text","nullable":false,"analyzer":"standard"}}},"prediction_log":{"type":"table","engine":"v1","columns":{"source":{"type":"String","nullable":false},"customer_id":{"type":"String","nullable":false,"link":"customers.customer_id"},"timestamp":{"type":"Int","nullable":false},"field":{"type":"String","nullable":false},"user_value":{"type":"String","nullable":true},"accepted":{"type":"Boolean","nullable":false},"predicted_value":{"type":"String","nullable":true},"confidence":{"type":"Decimal","nullable":false},"log_id":{"type":"String","nullable":false}}},"rule_revisions":{"type":"table","engine":"v1","columns":{"change_reason":{"type":"String","nullable":true},"support_ratio":{"type":"Decimal","nullable":false},"customer_id":{"type":"String","nullable":false,"link":"customers.customer_id"},"gl_code":{"type":"String","nullable":false},"approver":{"type":"String","nullable":false},"support_total":{"type":"Int","nullable":false},"valid_from":{"type":"Int","nullable":false},"rule_name":{"type":"String","nullable":false},"valid_to":{"type":"Int","nullable":true},"vendor":{"type":"String","nullable":false},"revision_id":{"type":"String","nullable":false},"lift":{"type":"Decimal","nullable":false},"support_match":{"type":"Int","nullable":false}}}}}