Romber

Database tables

romber_financial.transaction_statuses

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of valid financial transaction statuses.

Definition

Source romber_financial_transaction_statuses_tbl.sql

create table romber_financial.transaction_statuses (
  financial_transaction_status_code     romber_base.generic_code                not null,
  financial_transaction_status_id       romber_financial.transaction_status_id  not null
                                          default nextval ( 'romber_base.generic_id_seq' ),
  modify_or_not                         boolean                                 not null,
  remove_or_not                         boolean                                 not null,
  summary_or_not                        boolean                                 not null );

Constraints

Source romber_financial_transaction_statuses_pk.sql

alter table romber_financial.transaction_statuses
  add constraint romber_financial_transaction_statuses_pk
    primary key ( financial_transaction_status_id );

Source romber_financial_transaction_statuses_uk1.sql

alter table romber_financial.transaction_statuses
  add constraint romber_financial_transaction_statuses_uk1
    unique ( financial_transaction_status_code );