Romber

Database tables

romber_item.instance_relationships

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid member relationships. This information is highly dynamic and does need a data entry page.

Definition

Source romber_item_instance_relationships_tbl.sql

create table romber_item.instance_relationships (
  item_instance_a_id                    romber_item.instance_id                 not null,
  item_instance_relationship_id         romber_item.instance_relationship_id    not null
                                          default nextval ( 'romber_base.generic_id_seq' ),
  item_instance_relationship_type_id    romber_item.instance_relationship_type_id       not null,
  member_basemember_b_id                romber_member.basemember_id             not null,
  member_relationship_b_id              romber_member.relationship_id           not null );

Constraints

Source romber_item_instance_relationships_pk.sql

alter table romber_item.instance_relationships
  add constraint romber_item_instance_relationships_pk
    primary key ( item_instance_relationship_id );

Source romber_item_instance_relationships_fk1.sql

alter table romber_item.instance_relationships
  add constraint romber_item_instance_relationships_fk1
    foreign key ( item_instance_a_id )
    references romber_item.instances ( item_instance_id );

Source romber_item_instance_relationships_fk2.sql

alter table romber_item.instance_relationships
  add constraint romber_item_instance_relationships_fk2
    foreign key ( member_basemember_b_id )
    references romber_member.basemembers ( member_basemember_id );

Source romber_item_instance_relationships_fk3.sql

alter table romber_item.instance_relationships
  add constraint romber_item_instance_relationships_fk3
    foreign key ( member_relationship_b_id )
    references romber_member.relationships ( member_relationship_id );

Source romber_item_instance_relationships_fk4.sql

alter table romber_item.instance_relationships
  add constraint romber_item_instance_relationships_fk4
    foreign key ( item_instance_relationship_type_id )
    references romber_item.instance_relationship_types ( item_instance_relationship_type_id );

Source romber_item_instance_relationships_fk5.sql

alter table romber_item.instance_relationships
  add constraint romber_item_instance_relationships_fk5
    foreign key ( item_instance_relationship_id )
    references romber_meta.objects ( meta_object_id );

Load

Source romber_item_instance_relationships_load.sql

insert into romber_item.instance_relationships (
    item_instance_a_id,
    item_instance_relationship_id,
    item_instance_relationship_type_id,
    member_basemember_b_id,
    member_relationship_b_id )
  values (
    0,
    0,
    0,
    0,
    0 );