Table sola.system.br_definition
Contains the code definition for business rules used by SOLA. These rules can be assigned an active date range allowing new rules to superseed old rules at specific dates.
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
br_id varchar 100
br.id br_definition_br_id_fk116 C
Identifier for the business rule
active_from date 13 The date this version of the rule is active from.
active_until date 13 'infinity'::date The date until this version of the rule is active.
body varchar 4000 The definition of the rule. Either SQL commands or Drools XML.

Analyzed at Tue May 31 09:59 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
br_id + active_from Primary key Asc/Asc br_definition_pkey
br_id Performance Asc br_definition_br_id_fk116_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