Database Statistics

06/12/2025 03:36:24
Total Tables

57

Database

oneplace_uat

Records per Table
# Table Name Record Count Status
1 prt_time_sheet_days 829 Active
2 inv_customer_invoice_items 652 Active
3 prt_timesheet_day_projects 463 Active
4 inv_customer_invoices 403 Active
5 inv_purchase_invoices 335 Active
6 prt_nota_spese_row 184 Active
7 dir_addresses 183 Active
8 dir_customers 111 Active
9 prt_absence_timesheet_days 109 Active
10 prt_projects 101 Active
11 dir_suppliers 99 Low
12 inv_products 80 Low
13 ztb_tenant_properties 72 Low
14 prt_percorsi_autorizzati 71 Low
15 prt_richieste 46 Low
16 dir_audit_types 33 Low
17 ztb_countries 32 Low
18 inv_payment_details 28 Low
19 prt_time_sheet 27 Low
20 ztb_user_roles 26 Low
21 prt_nota_spese 24 Low
22 ztb_application_properties 23 Low
23 dir_document_types 19 Low
24 inv_payments 18 Low
25 ztb_user_preferences 17 Low
26 ztb_users 17 Low
27 inv_items_macro_category 8 Low
28 prt_collaboratori 8 Low
29 prt_tipi_dispositivi 8 Low
30 prt_users_progetti 7 Low
31 dir_supplier_documents 6 Low
32 ztb_roles 6 Low
33 ztb_sync_services 6 Low
34 ztb_facilities 4 Low
35 con_purchase_contracts 3 Low
36 dir_supplier_audits 3 Low
37 dir_contacts 2 Low
38 prt_assegnamenti 2 Low
39 prt_dispositivi 2 Low
40 ztb_mail_servers 2 Low
41 ztb_tenants 2 Low
42 con_sales_contracts 1 Low
43 inv_payment_methods 1 Low
44 ztb_s3_buckets 1 Low
45 ztb_tenant_dashboard 1 Low
46 ztb_user_dashboard 1 Low
47 alembic_version 0 Empty
48 con_purchase_contract_extensions 0 Empty
49 con_purchase_contract_replacements 0 Empty
50 con_sales_contract_extensions 0 Empty
51 con_sales_contract_replacements 0 Empty
52 dir_customer_audits 0 Empty
53 dir_customer_documents 0 Empty
54 dir_customer_guarantees 0 Empty
55 dir_customer_invitations 0 Empty
56 dir_supplier_guarantees 0 Empty
57 dir_supplier_invitations 0 Empty
Total Tables 4,076 records
Information
  • Tables are sorted by record count (descending)
  • Empty tables show 0 records with a "Empty" badge
  • Tables with errors are marked with a "Error" badge
  • Data is retrieved in real-time from the database