Tables


SchemaSpy Analysis of finance

Generated on Wed May 26 07:08 UTC 2021

XML Representation
Insertion Order Deletion Order
TABLES 63
VIEWS 30
COLUMNS 926
Constraints 89
Anomalies 28
Routines 46

Database Properties

Database Type: PostgreSQL - 9.5.24

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
tbl_tender_episode_data 0 1 52 6014 Table
tbl_cost_rates 0 3 7 11455 Table
tbl_invoice_exchange_lookup 0 1 3 135645 Table
tbl_slip_exp 2 7 22 2727591 Table
tbl_invoice 2 2 17 131268 Table
tbl_project_monitor_subscriptions 0 2 3 59 Table
tbl_slip_exp_currency_translation 0 2 3 5455024 Table
GI_CAPEX_VAT 0 0 3 208 Table
tbl_exchequer_unpaid_invoices 1 0 15 122 Table
tbl_spinal_points 0 1 5 121 Table
tbl_staff_positions 0 2 7 5710 Table
tbl_cost_centre 28 0 3 10 Table
tbl_project_monitor_reports 0 2 21 369 Table
tbl_positions 14 0 2 46 Table
tbl_payroll 1 1 3 5 Table
tbl_sales_exchange_lookup 0 1 3 31688 Table
tbl_finance_project_dated_summary 0 1 25 29890 Table
tbl_sales 2 2 15 30505 Table
tbl_work_in_progress 2 3 23 3822 Table
tbl_staff_payroll_centre 0 2 6 4280 Table
tbl_markup_values 0 2 5 64 Table
tbl_charge_group_project 0 2 6 1403 Table
tbl_orders_currency_translation 0 2 3 57512 Table
tbl_charge_rates 0 3 5 380 Table
tbl_project_defer_income 0 2 6 1396 Table
tbl_percentage_markup 0 2 4 12274 Table
tbl_lookup_fund 4 0 2 6 Table
ManAccs_Comments 0 2 8 626 Table
tbl_wip_currency_translation 0 3 4 7644 Table
tbl_invoice_currency_translation 0 3 4 262536 Table
tbl_allocations 0 0 3 1546 Table
tbl_financial_details 0 2 15 2579 Table
tbl_lookup_department 7 0 1 7 Table
tbl_staff_location 0 2 6 4827 Table
tbl_subs_currency_translation 0 2 3 23868 Table
tbl_lookup_invoice_type 1 0 1 8 Table
tbl_sales_temp 0 1 16 5307 Table
tbl_finance_project 8 8 33 14970 Table
tbl_markup 3 0 1 8 Table
tbl_staff_lookup 21 2 11 2579 Table
tbl_charge_groups 2 2 7 19 Table
tbl_finance_project_summary 0 2 22 29940 Table
tbl_staff_cost_centre 0 2 6 4417 Table
tbl_trans_type 0 0 3 25 Table
tbl_finance_project_summary_temp 0 1 22 29940 Table
tbl_exchange_reference 8 1 3 2 Table
tbl_invoice_temp 0 1 18 26490 Table
tbl_exchange_rates 0 3 5 4 Table
tbl_location 4 0 2 9 Table
tbl_orders 1 3 13 28756 Table
tbl_lookup_project_type 0 0 1 10 Table
tbl_lookup_area 4 0 4 90 Table
tbl_view_time_sheets_by_day 0 2 14 2525197 Table
tbl_subs 1 6 15 11954 Table
tbl_weighted_markup 0 3 4 2697 Table
tbl_sales_currency_translation 0 3 4 61010 Table
tbl_view_time_sheets_by_week 0 2 14 1250885 Table
tbl_slip_exp_currency_translation_charge_rates 0 2 3 5455024 Table
tbl_subs_hist 0 1 8 25808 Table
tbl_subs_input 0 1 7 1 Table
tbl_currency 38 0 2 2 Table
tbl_view_staff 0 0 10 535209 Table
tbl_project_recost_range 0 0 2 1 Table
view_time_sheets_by_week_part_two 0 2 10 0 View
view_staff_time_summary 0 0 5 0 View
view_staff_time_summary_part_two 0 0 7 0 View
view_project_monitor_report_details 0 2 10 0 View
view_staff 0 0 10 0 View
view_wip_summaries 0 3 13 0 View
view_project_monitor_reports 0 2 18 0 View
view_time_sheets_by_day_part_one 0 2 8 0 View
view_costs 0 1 9 0 View
view_projects 0 1 6 0 View
view_orders 0 1 9 0 View
view_project_details_percentage_markup 0 4 23 0 View
view_staff_time_summary_part_three 0 0 6 0 View
view_project_financials_percentage_markup 0 1 18 0 View
view_time_sheets_by_week_part_one 0 2 10 0 View
view_wip 0 1 9 0 View
projects 0 0 2 0 View
view_staff_time_summary_part_one 0 0 8 0 View
view_staff_by_day 0 1 12 0 View
view_staff_by_week 0 1 12 0 View
view_time_sheets_by_day_part_two 0 2 8 0 View
view_project_details_admin 0 5 32 0 View
view_staff_positions 0 2 5 0 View
view_unpaid_invoices 0 1 18 0 View
view_sales 0 1 8 0 View
view_time_sheets_by_week 0 2 14 0 View
view_project_details_level_markup 0 5 23 0 View
view_project_financials_level_markup 0 1 18 0 View
view_time_sheets_by_day 0 2 14 0 View
view_projects_summaries 0 3 17 0 View