Table sola.system.br
Provides a description of the business rules used by SOLA.
Tags: FLOSS SOLA Extension, Business Rules

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id varchar 100
br_definition.br_id br_definition_br_id_fk116 C
br_validation.br_id br_validation_br_id_fk108 R
The name of the business rule
display_name varchar 250 uuid_generate_v1() The display name for the business rule.
technical_type_code varchar 20
br_technical_type.code br_technical_type_code_fk107 R
Indicates which engine must be used to run the business rule (sql or drools). Note that SOLA does not currently implement any Drools rules.
feedback varchar 2000  √  null The message that should be displayed to the user if the rule is not complied with.
description varchar 1000  √  null A description of the business rule. Intended for system administrators and end users.
technical_description varchar 1000  √  null A technical description of the business rule including any parameters the rule expects. Intended for developers.

Analyzed at Tue May 31 09:59 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc br_pkey
display_name Must be unique Asc br_display_name_unique
technical_type_code Performance Asc br_technical_type_code_fk107_ind

Close relationships  within of separation:

Excluded from diagram's relationships: approle_appgroup.change_action  user_pword_expiry.pword_change_user  appuser.change_action  appuser_appgroup.change_action  appuser.change_user  appuser_appgroup.change_time  appuser.rowidentifier  approle_appgroup.rowidentifier  appuser_appgroup.change_user  extracted_rows.rowidentifier  appuser_appgroup.rowversion  approle_appgroup.change_user  appuser_appgroup.rowidentifier  approle_appgroup.rowversion  appuser.rowversion  approle_appgroup.change_time  appuser.change_time