Romber

Database tables

romber_financial.transactions

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of valid financial transactions.

Definition

Source romber_financial_transactions_tbl.sql

create table romber_financial.transactions (
  business_id                           romber_base.business_id                 not null,
  financial_transaction_id              romber_financial.transaction_id         not null
                                          default nextval ( 'romber_base.generic_id_seq' ) );

Constraints

Source romber_financial_transactions_pk.sql

alter table romber_financial.transactions
  add constraint romber_financial_transactions_pk
    primary key ( financial_transaction_id );

Source romber_financial_transactions_fk1.sql

alter table romber_financial.transactions
  add constraint romber_financial_transactions_fk1
    foreign key ( financial_transaction_id )
    references romber_meta.objects ( meta_object_id );

Source romber_financial_transactions_fk2.sql

alter table romber_financial.transactions
  add constraint romber_financial_transactions_fk2
    foreign key ( business_id )
    references romber_base.businesses ( business_id );