Romber

Database tables

romber_financial.summaries

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of valid financial summaries.

Definition

Source romber_financial_summaries_tbl.sql

create table romber_financial.summaries (
  business_id                           romber_base.business_id                         not null,
  financial_period_id                   romber_financial.period_id                      not null,
  financial_summary_value               romber_base.generic_currency_amount             not null,
  financial_transaction_element_type_id romber_financial.transaction_element_type_id    not null,
  financial_transaction_status_id       romber_financial.transaction_status_id          not null,
  ledger_account_id                     romber_financial.ledger_account_id              not null,
  subledger_account_id                  romber_financial.subledger_account_id           not null );

Constraints

Source romber_financial_summaries_pk.sql

alter table romber_financial.summaries
  add constraint romber_financial_summaries_pk
    primary key (
      business_id,
      ledger_account_id,
      subledger_account_id,
      financial_period_id,
      financial_transaction_status_id,
      financial_transaction_element_type_id );

Source romber_financial_summaries_fk1.sql

alter table romber_financial.summaries
  add constraint romber_financial_summaries_fk1
    foreign key ( business_id )
    references romber_base.businesses ( business_id );

Source romber_financial_summaries_fk2.sql

alter table romber_financial.summaries
  add constraint romber_financial_summaries_fk2
    foreign key ( ledger_account_id )
    references romber_financial.ledger_accounts ( ledger_account_id );

Source romber_financial_summaries_fk3.sql

alter table romber_financial.summaries
  add constraint romber_financial_summaries_fk3
    foreign key ( subledger_account_id )
    references romber_financial.subledger_accounts ( subledger_account_id );

Source romber_financial_summaries_fk4.sql

alter table romber_financial.summaries
  add constraint romber_financial_summaries_fk4
    foreign key ( financial_period_id )
    references romber_financial.periods ( financial_period_id );

Source romber_financial_summaries_fk5.sql

alter table romber_financial.summaries
  add constraint romber_financial_summaries_fk5
    foreign key ( financial_transaction_status_id )
    references romber_financial.transaction_statuses ( financial_transaction_status_id );

Source romber_financial_summaries_fk6.sql

alter table romber_financial.summaries
  add constraint romber_financial_summaries_fk6
    foreign key ( financial_transaction_element_type_id )
    references romber_financial.transaction_element_types (
      financial_transaction_element_type_id );