Description of the database tables
In this page you will find the tables of Squale database (table name are in bold) share out between some main area. You will find a short description of each table. The aim of this document is to give a basic view of the Squale database.
Component area
- Component This table list all the component in Squale : ApplicationBO, ProjectBO, PackageBO, ClassBO, MethodBO, ... This table contain also some configuration information for the ApplicationBO and the ProjectBO
- projectparameter This table contain all parameter define in the configuration of the projects
- useraccess This table list the access of simple user to an application
Audit area
- auditbo This table list all the audit done or plan in Squale
- components_audits This table link audits to components
- error This table contain the error/warning/info happen during an audit and return to the user in the web interface
- auditgridbo This table link the quality grid from grid to audits and projects
Tasks / profiles area
- tasks_user
- analysis_task
- termination_task
- taskref
- task
- taskparameter
- profiles_grids This table link profiles to grid
User
- atomicrights
- profile_rights
- profilebo
- userbo
- user_rights
Grid
- formula_measures
- formula_conditions
- formula
- criteriumpractice_rule
- factorcriterium_rule
- qualityrule
- gridfactor_rule
Referenciel
- factorref
- squalereference
Result
- pratciceresult_repartition
- quality result
- mark
Measure
- measure
- rule
- module
- metric
- rulecheckingtransgressionitem
- ruleset
Stats
- stats_squale_dict_annexe
- stats_squale_dict
Display
- volumetry measure
- displayconf
- profile_displayconfbo
- auditdisplayconf
