Romber

Database tables

romber_member.customer__versions

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of valid customer versions.

Definition

Source romber_customer__versions_tbl.sql

create table romber_member.customer__versions (
  customer_id           romber_member.relationship_id           not null,
  customer_code         romber_base.generic_code                not null,
  meta_namespace_id     romber_meta.namespace_id                not null,
  meta_transaction_id   romber_meta.transaction_id              not null );

Constraints

Source romber_customer__versions_pk.sql

alter table romber_member.customer__versions
  add constraint romber_customer__versions_pk
    primary key (
      customer_id,
      meta_transaction_id );

Source romber_customer__versions_uk1.sql

alter table romber_member.customer__versions
  add constraint romber_customer__versions_uk1
    unique (
      meta_namespace_id,
      customer_code,
      meta_transaction_id );

Source romber_customer__versions_fk1.sql

alter table romber_member.customer__versions
  add constraint romber_customer__versions_fk1
    foreign key ( customer_id )
    references romber_member.customers ( customer_id );

Source romber_customer__versions_fk2.sql

alter table romber_member.customer__versions
  add constraint romber_customer__versions_fk2
    foreign key (
      customer_id,
      meta_transaction_id )
    references romber_member.relationship__versions (
      member_relationship_id,
      meta_transaction_id );

Source romber_customer__versions_fk3.sql

alter table romber_member.customer__versions
  add constraint romber_customer__versions_fk3
    foreign key ( meta_namespace_id )
    references romber_meta.namespaces ( meta_namespace_id );

Source romber_customer__versions_ck1.sql

alter table romber_member.customer__versions
  add constraint romber_customer__versions_ck1
    check ( customer_id > 0 );