Tables


Analysis of schema "lookout_analytics_edge"

Raw tables and views from the Lookout application database.

Generated on Mon June 23 13:24 AWST 2025

Tables

Table / View Columns Type Comments
edge_communities 11 View
edge_finance_accounts 11 View
edge_communities_memberships 4 View
edge_purchase_orders 10 View
edge_events 13 View
edge_match_requests 20 View
edge_payroll_awards 9 View
edge_bulk_actions 11 View
edge_purchase_order_lines 31 View
edge_availability_schedules 15 View
edge_purchase_order_lines_services 9 View
edge_users 19 View
edge_shifts 18 View
edge_ticket_tags 11 View
edge_availability_schedules_rules 12 View
edge_services 16 View
edge_staffers 12 View

Contains information about staff members within the company, including their roles, bio, access info, etc.
edge_dva_referral_plans 17 View
edge_custom_attributes 17 View
edge_invoices 33 View
edge_verifications 11 View
edge_attendees 13 View
edge_client_transport_rates 24 View
edge_staffer_roles 11 View

A collection of permissions that are granted to each staffer associated with the role. These are also known as Access Roles.
edge_comments 10 View
edge_surveys 16 View
edge_finance_hcp_claims 16 View
edge_invoice_lines 19 View
edge_profiles 11 View
edge_observations 21 View
edge_tickets 22 View
edge_visit_logs 9 View
edge_agreement_templates 12 View
edge_custom_attribute_values 11 View
edge_helpers 27 View
edge_custom_attribute_options 10 View
edge_finance_transactions 20 View
edge_help_plan_entries 11 View
edge_memberships 37 View
edge_billing_runs 12 View
edge_help_plans 10 View