Romber

Database tables

romber_member.supplier__versions

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of valid supplier versions.

Definition

Source romber_supplier__versions_tbl.sql

create table romber_member.supplier__versions (
  supplier_id           romber_member.relationship_id           not null,
  supplier_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_supplier__versions_pk.sql

alter table romber_member.supplier__versions
  add constraint romber_supplier__versions_pk
    primary key (
      supplier_id,
      meta_transaction_id );

Source romber_supplier__versions_uk1.sql

alter table romber_member.supplier__versions
  add constraint romber_supplier__versions_uk1
    unique (
      meta_namespace_id,
      supplier_code,
      meta_transaction_id );

Source romber_supplier__versions_fk1.sql

alter table romber_member.supplier__versions
  add constraint romber_supplier__versions_fk1
    foreign key ( supplier_id )
    references romber_member.suppliers ( supplier_id );

Source romber_supplier__versions_fk2.sql

alter table romber_member.supplier__versions
  add constraint romber_supplier__versions_fk2
    foreign key (
      supplier_id,
      meta_transaction_id )
    references romber_member.relationship__versions (
      member_relationship_id,
      meta_transaction_id );

Source romber_supplier__versions_fk3.sql

alter table romber_member.supplier__versions
  add constraint romber_supplier__versions_fk3
    foreign key ( meta_namespace_id )
    references romber_meta.namespaces ( meta_namespace_id );

Source romber_supplier__versions_ck1.sql

alter table romber_member.supplier__versions
  add constraint romber_supplier__versions_ck1
    check ( supplier_id > 0 );