Romber

Database tables

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

create table romber_item.type_relationships (
  item_type_a_id                        romber_item.type_id                     not null,
  item_type_relationship_id             romber_item.type_relationship_id        not null
                                          default nextval ( 'romber_base.generic_id_seq' ),
  item_type_relationship_type_id        romber_item.type_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_type_relationships_pk.sql

alter table romber_item.type_relationships
  add constraint romber_item_type_relationships_pk
    primary key ( item_type_relationship_id );

Source romber_item_type_relationships_fk1.sql

alter table romber_item.type_relationships
  add constraint romber_item_type_relationships_fk1
    foreign key ( item_type_a_id )
    references romber_item.types ( item_type_id );

Source romber_item_type_relationships_fk2.sql

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

Source romber_item_type_relationships_fk3.sql

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

Source romber_item_type_relationships_fk4.sql

alter table romber_item.type_relationships
  add constraint romber_item_type_relationships_fk4
    foreign key ( item_type_relationship_type_id )
    references romber_item.type_relationship_types ( item_type_relationship_type_id );

Source romber_item_type_relationships_fk5.sql

alter table romber_item.type_relationships
  add constraint romber_item_type_relationships_fk5
    foreign key ( item_type_relationship_id )
    references romber_meta.objects ( meta_object_id );

Load

Source romber_item_type_relationships_load.sql

insert into romber_item.type_relationships (
    item_type_a_id,
    item_type_relationship_id,
    item_type_relationship_type_id,
    member_basemember_b_id,
    member_relationship_b_id )
  values (
    0,
    0,
    0,
    0,
    0 );