Romber

Database tables

romber_member.telecomm_addresses

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid member telecommunications addresses. This information is highly dynamic and does need a data entry page.

Definition

Source romber_member_telecomm_addresses_tbl.sql

create table romber_member.telecomm_addresses (
  member_basemember_id          romber_member.basemember_id             not null,
  telecomm_address_id           romber_telecomm.address_id              not null,
  telecomm_address_usage_id     romber_telecomm.address_usage_id        not null,
  valid_begin_timestamp         romber_base.generic_timestamp           not null,
  valid_end_timestamp           romber_base.generic_timestamp           not null );

Constraints

Source romber_member_telecomm_addresses_pk.sql

alter table romber_member.telecomm_addresses
  add constraint romber_member_telecomm_addresses_pk
    primary key (
      member_basemember_id,
      telecomm_address_usage_id,
      valid_begin_timestamp,
      telecomm_address_id );

Source romber_member_telecomm_addresses_fk1.sql

alter table romber_member.telecomm_addresses
  add constraint romber_member_telecomm_addresses_fk1
    foreign key ( member_basemember_id )
    references romber_member.basemembers ( member_basemember_id );

Source romber_member_telecomm_addresses_fk2.sql

alter table romber_member.telecomm_addresses
  add constraint romber_member_telecomm_addresses_fk2
    foreign key ( telecomm_address_id )
    references romber_telecomm.addresses ( telecomm_address_id );

Source romber_member_telecomm_addresses_fk3.sql

alter table romber_member.telecomm_addresses
  add constraint romber_member_telecomm_addresses_fk3
    foreign key ( telecomm_address_usage_id )
    references romber_telecomm.address_usages ( telecomm_address_usage_id );

Load

Source romber_member_telecomm_addresses_load.sql

insert into romber_member.telecomm_addresses (
    member_basemember_id,
    telecomm_address_id,
    telecomm_address_usage_id,
    valid_begin_timestamp,
    valid_end_timestamp )
  values (
    0,
    0,
    0,
    date '1900-01-01',
    date '9999-12-31' );