Romber

Database tables

romber_base.currencies

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid currencies. This information is static and doesn't need a data entry page.

Definition

Source romber_currencies_tbl.sql

create table romber_base.currencies (
  currency_code                 romber_base.generic_code        not null,
  currency_id                   romber_base.currency_id         not null
                                  default nextval ( 'romber_base.generic_id_seq' ),
  currency_name                 romber_base.generic_name        not null,
  currency_numeric              smallint                        not null,
  currency_symbol               romber_base.generic_code        not null,
  valid_begin_timestamp         romber_base.generic_timestamp   not null,
  valid_end_timestamp           romber_base.generic_timestamp   not null );

Constraints

Source romber_currencies_pk.sql

alter table romber_base.currencies
  add constraint romber_currencies_pk
    primary key ( currency_id );

Source romber_currencies_uk1.sql

alter table romber_base.currencies
  add constraint romber_currencies_uk1
    unique ( currency_code );

Source romber_currencies_fk1.sql

alter table romber_base.currencies
  add constraint romber_currencies_fk1
    foreign key ( currency_id )
    references romber_meta.objects ( meta_object_id );

Load

Source romber_currencies_load.sql

insert into romber_base.currencies (
    currency_code,
    currency_id,
    currency_name,
    currency_numeric,
    currency_symbol,
    valid_begin_timestamp,
    valid_end_timestamp )
  values (
    '',
    0,
    'No currency',
    0,
    '',
    timestamp '1858-11-17 00:00:00.00',
    timestamp '9999-12-31 00:00:00.00' );