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