Tables: Difference between revisions

From nuBuilderForte
Jump to navigation Jump to search
← Older edit
VisualWikitext
mNo edit summary
m Updated Tables/Views
 
(2 intermediate revisions by the same user not shown)
Line 5: Line 5:
** '''zzzzsys_access_form''': Stores information about form access permissions, detailing which forms are accessible by which 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_php''': Contains data regarding PHP procedure access permissions, specifying which PHP procedure can be executed by which Access Level.
** '''zzzzsys_access_report''': Conains report access permissions, defining which Access Level can view or run specific reports.
** '''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_browse''': Contains columns definitions of a Browse Screen.
** '''zzzzsys_cloner''': This table stores information on cloning form(s) and their parameters.
** '''zzzzsys_cloner''': This table stores information on cloning form(s) and their parameters.
** '''zzzzsys_code_snippet''': Holds reusable pieces of code or functions that can be inserted in various parts of nuBuilder.
** '''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_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_debug''': Used for debugging purposes, this table stores logs, error messages, or debugging information generated during system operation.
Line 14: Line 14:
** '''zzzzsys_email_template''': Stores templates for emails that can be sent by the system, including placeholders for dynamic content insertion.
** '''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_event''': Contains JavaScript events of nuBuilder objects.
** '''zzzzsys_file''': Contains upload files.
** '''zzzzsys_file''': Contains uploaded files.
** '''zzzzsys_form''': Stores details of forms used in the system, including structure, fields, custom code and display settings.
** '''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_format''': Stores custom formats for Date and Number types.
** '''zzzzsys_info''': Contains DB/Files version info.
** '''zzzzsys_info''': Contains DB/file version information.
** '''zzzzsys_note''': Used for storing notes or comments made through the "notes" form.
** '''zzzzsys_note''': Used for storing notes or comments made through the "notes" form.
** '''zzzzsys_note_category''': Categorizes the notes stored in zzzzsys_note, allowing for better organization and retrieval.
** '''zzzzsys_note_category''': Categorises the notes stored in zzzzsys_note for better organisation and retrieval.
** '''zzzzsys_object''': Contains object information within forms.
** '''zzzzsys_object''': Contains object information within forms.
** '''zzzzsys_permission_item''': Stores user permission items
** '''zzzzsys_permission_item''': Stores user permission items.
** '''zzzzsys_user_permission''': Stores which user has access to which 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_php''': Contains PHP procedures that can be executed as part of the system's functionality.
** '''zzzzsys_report''': Contains report definitions.
** '''zzzzsys_report''': Contains report definitions.
** '''zzzzsys_report_data''': Contains procedures, tables, sql that can be chosen in the report builder.
** '''zzzzsys_select''': Contains SQL queries and table relations.
** '''zzzzsys_select''': Contains SQL queries and table relations.
** '''zzzzsys_select_clause''': Related to the zzzzsys_select table, this stores the WHERE conditions
** '''zzzzsys_select_clause''': Related to the zzzzsys_select table, this stores the WHERE conditions
Line 34: Line 35:
** '''zzzzsys_user''': Contains user account information, including encrypted credentials, access level, and settings for individuals using the system.
** '''zzzzsys_user''': Contains user account information, including encrypted credentials, access level, and settings for individuals using the system.


* '''Views''':
* '''Views''': (Recently removed)
** '''zzzzsys_object_list''': Provides a list or index of all form names within the database.
** '''zzzzsys_object_list''': Contains a list or index of all form names within the database.
** '''zzzzsys_run_list''': Contains Forms, Report, Procedures that can be picked in a "Run" object.
** '''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.
** '''zzzzsys_report_data''': Contains procedures, tables, sql that can be chosen in the report builder.

Latest revision as of 11:05, 21 May 2024

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_report_data: Contains procedures, tables, sql that can be chosen in the report builder.
    • 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: (Recently removed)
    • 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.
Retrieved from "https://wiki.nubuilder.cloud/index.php?title=Tables&oldid=3708"