Romber

Database tables

romber_item.instance_relationship_types

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid item instance relationship types. This information is static and doesn't need a data entry page.

Definition

Source romber_item_instance_relationship_types_tbl.sql

create table romber_item.instance_relationship_types (
  associated_meta_class_id              romber_meta.class_id                    not null,
  desc_a                                romber_base.generic_name                not null,
  desc_b                                romber_base.generic_name                not null,
  item_instance_relationship_type_code  romber_base.generic_code                not null,
  item_instance_relationship_type_id    romber_item.instance_relationship_type_id       not null
                                          default nextval ( 'romber_base.generic_id_seq' ),
  item_instance_relationship_type_name  romber_base.generic_name                not null,
  unique_or_not                         boolean                                 not null );

Constraints

Source romber_item_instance_relationship_types_pk.sql

alter table romber_item.instance_relationship_types
  add constraint romber_item_instance_relationship_types_pk
    primary key ( item_instance_relationship_type_id );

Source romber_item_instance_relationship_types_uk1.sql

alter table romber_item.instance_relationship_types
  add constraint romber_item_instance_relationship_types_uk1
    unique ( item_instance_relationship_type_code );

Source romber_item_instance_relationship_types_fk1.sql

alter table romber_item.instance_relationship_types
  add constraint romber_item_instance_relationship_types_fk1
    foreign key ( associated_meta_class_id )
    references romber_meta.classes ( meta_class_id );

Load

Source romber_item_instance_relationship_types_load.sql

insert into romber_item.instance_relationship_types (
    associated_meta_class_id,
    desc_a,
    desc_b,
    item_instance_relationship_type_code,
    item_instance_relationship_type_id,
    item_instance_relationship_type_name,
    unique_or_not )
  values (
    0,
    '',
    '',
    '',
    0,
    '',
    false );