Tables


Analysis of schema "lookout_analytics_edge"

Raw tables and views from the Lookout application database.

Generated on Mon Oct 13 14:17 AWST 2025

Tables

Table / View Columns Type Comments
edge_finance_accounts 11 Table
edge_services_third_party_provider_rates 9 Table
edge_communities_memberships 4 Table
edge_events 13 Table
edge_match_requests 20 Table
edge_bulk_actions 11 Table
edge_purchase_order_lines_services 9 Table
edge_users 19 Table
edge_shifts 18 Table
edge_services_australia_identifiers 9 Table
edge_supplier_generated_invoices 14 Table
edge_ticket_tags 11 Table
edge_availability_schedules_rules 12 Table
edge_dva_referral_plans 17 Table
edge_invoices 33 Table
edge_finance_hcp_rates 6 Table
edge_client_transport_rates 26 Table
edge_invoice_lines_services 9 Table
edge_third_party_provider_rates 17 Table
edge_finance_hcp_claims 16 Table
edge_profiles 11 Table
edge_archive_reasons 13 Table
edge_visit_cancelation_reasons 18 Table
edge_tickets 22 Table
edge_visit_logs 9 Table
edge_agreement_templates 12 Table
edge_membership_plans 24 Table
edge_helpers 27 Table
edge_finance_transactions 20 Table
edge_help_plan_entries 11 Table
edge_billing_runs 12 Table
edge_help_plans 10 Table
edge_communities 11 Table
edge_purchase_orders 10 Table
edge_payroll_awards 9 Table
edge_purchase_order_lines 31 Table
edge_availability_schedules 15 Table
edge_finance_hcp_daily_rates 9 Table
edge_services 16 Table
edge_staffers 12 Table

Contains information about staff members within the company, including their roles, bio, access info, etc.

edge_custom_attributes 17 Table
edge_verifications 11 Table
edge_attendees 13 Table
edge_time_tracking_logs 18 Table
edge_staffer_roles 11 Table

A collection of permissions that are granted to each staffer associated with the role. These are also known as Access Roles.

edge_comments 10 Table
edge_surveys 16 Table
edge_invoice_lines 19 Table
edge_observations 21 Table
edge_custom_attribute_values 11 Table
edge_custom_attribute_options 10 Table
edge_memberships 37 Table
edge_finance_membership_hcp_rates 15 Table