Romber

Database tables

romber_member.basemember__versions

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides the details about each version of a base member. This information is highly dynamic.

Definition

Source romber_member_basemember__versions_tbl.sql

create table romber_member.basemember__versions (
  basemember_status_id          romber_member.basemember_status_id      not null,
  member_basemember_id          romber_member.basemember_id             not null
                                  default nextval ( 'romber_base.generic_id_seq' ),
  member_key                    romber_base.generic_name                not null,
  member_type_id                romber_member.type_id                   not null,
  meta_transaction_id           romber_meta.transaction_id              not null );

Constraints

Source romber_member_basemember__versions_pk.sql

alter table romber_member.basemember__versions
  add constraint romber_member_basemember__versions_pk
    primary key (
      member_basemember_id,
      meta_transaction_id );

Source romber_member_basemember__versions_fk1.sql

alter table romber_member.basemember__versions
  add constraint romber_member_basemember__versions_fk1
    foreign key ( member_basemember_id )
    references romber_member.basemembers ( member_basemember_id );

Source romber_member_basemember__versions_fk2.sql

alter table romber_member.basemember__versions
  add constraint romber_member_basemember__versions_fk2
    foreign key (
      member_basemember_id,
      meta_transaction_id )
    references romber_meta.object__versions (
      meta_object_id,
      meta_transaction_id );

Source romber_member_basemember__versions_fk3.sql

alter table romber_member.basemember__versions
  add constraint romber_member_basemember__versions_fk3
    foreign key ( member_type_id )
    references romber_member.types ( member_type_id );

Source romber_member_basemember__versions_fk4.sql

alter table romber_member.basemember__versions
  add constraint romber_member_basemember__versions_fk4
    foreign key ( basemember_status_id )
    references romber_member.basemember_statuses ( basemember_status_id );

Load

Source romber_member_basemember__versions_load.sql

insert into romber_member.basemember__versions (
    basemember_status_id,
    member_basemember_id,
    member_key,
    member_type_id,
    meta_transaction_id )
  values (
    ( select basemember_status_id
        from romber_member.basemember_statuses
        where basemember_status_code = 'Inactive' ),
    0,
    '',
    0,
    0 );