Romber

Database tables

romber_item.instance_relationship__versions

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of item to member relationship versions. This information is highly dynamic and data is entered via item and/or member management pages.

Definition

Source romber_item_instance_relationship__versions_tbl.sql

create table romber_item.instance_relationship__versions (
  item_instance_relationship_id romber_item.instance_relationship_id    not null,
  meta_transaction_id           romber_meta.transaction_id              not null );

Constraints

Source romber_item_instance_relationship__versions_pk.sql

alter table romber_item.instance_relationship__versions
  add constraint romber_item_instance_relationship__versions_pk
    primary key (
      item_instance_relationship_id,
      meta_transaction_id );

Source romber_item_instance_relationship__versions_fk1.sql

alter table romber_item.instance_relationship__versions
  add constraint romber_item_instance_relationship__versions_fk1
    foreign key ( item_instance_relationship_id )
    references romber_item.instance_relationships ( item_instance_relationship_id );

Source romber_item_instance_relationship__versions_fk2.sql

alter table romber_item.instance_relationship__versions
  add constraint romber_item_instance_relationship__versions_fk2
    foreign key (
      item_instance_relationship_id,
      meta_transaction_id )
    references romber_meta.object__versions (
      meta_object_id,
      meta_transaction_id );