Tables

nuBuilder stores all form, object, and report definitions within database tables prefixed with 'zzzzsys-'.

• Tables:
  • zzzzsys_access: End Users permissions are defined in groups called "Access Level"
  • zzzzsys_access_form: Stores information about form access permissions, detailing which forms are accessible by which Access Level.
  • zzzzsys_access_php: Contains data regarding PHP procedure access permissions, specifying which PHP procedure can be executed by which Access Level.
  • zzzzsys_access_report: Contains report access permissions, specifying which access level can view or run specific reports.
  • zzzzsys_browse: Contains columns definitions of a Browse Screen.
  • zzzzsys_cloner: This table stores information on cloning form(s) and their parameters.
  • zzzzsys_code_snippet: Contains reusable code snippets or functions that can be inserted in different parts of nuBuilder.
  • zzzzsys_config: Contains configuration settings for the system, including system preferences, and environment settings.
  • zzzzsys_debug: Used for debugging purposes, this table stores logs, error messages, or debugging information generated during system operation.
  • zzzzsys_email_log: Logs all email transactions sent by the system, including send time, recipient, and email content etc.
  • zzzzsys_email_template: Stores templates for emails that can be sent by the system, including placeholders for dynamic content insertion.
  • zzzzsys_event: Contains JavaScript events of nuBuilder objects.
  • zzzzsys_file: Contains uploaded files.
  • zzzzsys_form: Stores details of forms used in the system, including structure, fields, custom code and display settings.
  • zzzzsys_format: Stores custom formats for Date and Number types.
  • zzzzsys_info: Contains DB/file version information.
  • zzzzsys_note: Used for storing notes or comments made through the "notes" form.
  • zzzzsys_note_category: Categorises the notes stored in zzzzsys_note for better organisation and retrieval.
  • zzzzsys_object: Contains object information within forms.
  • zzzzsys_permission_item: Stores user permission items.
  • zzzzsys_user_permission: Stores which user has access to which permission items.
  • zzzzsys_php: Contains PHP procedures that can be executed as part of the system's functionality.
  • zzzzsys_report: Contains report definitions.
  • zzzzsys_select: Contains SQL queries and table relations.
  • zzzzsys_select_clause: Related to the zzzzsys_select table, this stores the WHERE conditions
  • zzzzsys_session: Stores session data for users
  • zzzzsys_setup: Contains setup configuration for the system (email settings, header, style etc)
  • zzzzsys_tab: Contains the tab definitions of the form.
  • zzzzsys_timezone: Contains a list of timezones
  • zzzzsys_translate: Manages translations for multilingual support.
  • zzzzsys_user: Contains user account information, including encrypted credentials, access level, and settings for individuals using the system.

• Views:
  • zzzzsys_object_list: Contains a list or index of all form names within the database.
  • zzzzsys_run_list: Contains Forms, Reports, Procedures that can be picked in a "Run" object.
  • zzzzsys_report_data: Contains procedures, tables, sql that can be chosen in the report builder.