Romber

Database tables

romber_item.type_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_type_relationship__versions_tbl.sql

create table romber_item.type_relationship__versions (
  item_type_relationship_id     romber_item.type_relationship_id        not null,
  meta_transaction_id           romber_meta.transaction_id              not null );

Constraints

Source romber_item_type_relationship__versions_pk.sql

alter table romber_item.type_relationship__versions
  add constraint romber_item_type_relationship__versions_pk
    primary key (
      item_type_relationship_id,
      meta_transaction_id );

Source romber_item_type_relationship__versions_fk1.sql

alter table romber_item.type_relationship__versions
  add constraint romber_item_type_relationship__versions_fk1
    foreign key ( item_type_relationship_id )
    references romber_item.type_relationships ( item_type_relationship_id );

Source romber_item_type_relationship__versions_fk2.sql

alter table romber_item.type_relationship__versions
  add constraint romber_item_type_relationship__versions_fk2
    foreign key (
      item_type_relationship_id,
      meta_transaction_id )
    references romber_meta.object__versions (
      meta_object_id,
      meta_transaction_id );