Romber

Database tables

romber_member.relationship_types

• Purpose
• Definition
• Constraints
• Load

Purpose

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

Definition

Source romber_member_relationship_types_tbl.sql

create table romber_member.relationship_types (
  associated_meta_class_id      romber_meta.class_id                    not null,
  contacts_or_not               boolean                                 not null,
  description_a                 romber_base.generic_name                not null,
  description_b                 romber_base.generic_name                not null,
  generic_or_not                boolean                                 not null,
  max_usernames                 smallint                                not null,
  member_relationship_type_code romber_base.generic_code                not null,
  member_relationship_type_id   romber_member.relationship_type_id      not null
                                  default nextval ( 'romber_base.generic_id_seq' ),
  member_relationship_type_name romber_base.generic_name                not null,
  min_usernames                 smallint                                not null,
  payments_or_not               boolean                                 not null,
  subledger_or_not              boolean                                 not null,
  unique_or_not                 boolean                                 not null,
  validity_required             smallint                                not null
                                  check ( validity_required in ( 0, 1, 2 )) );

Constraints

Source romber_member_relationship_types_pk.sql

alter table romber_member.relationship_types
  add constraint romber_member_relationship_types_pk
    primary key ( member_relationship_type_id );

Source romber_member_relationship_types_uk1.sql

alter table romber_member.relationship_types
  add constraint romber_member_relationship_types_uk1
    unique ( member_relationship_type_code );

Source romber_member_relationship_types_fk1.sql

alter table romber_member.relationship_types
  add constraint romber_member_relationship_types_fk1
    foreign key ( associated_meta_class_id )
    references romber_meta.classes ( meta_class_id );

Load

Source romber_member_relationship_types_load.sql

insert into romber_member.relationship_types (
    associated_meta_class_id,
    contacts_or_not,
    description_a,
    description_b,
    generic_or_not,
    max_usernames,
    member_relationship_type_code,
    member_relationship_type_id,
    member_relationship_type_name,
    min_usernames,
    payments_or_not,
    subledger_or_not,
    unique_or_not,
    validity_required )
  values (
    0,
    false,
    '',
    '',
    false,
    0,
    '',
    0,
    '',
    0,
    false,
    false,
    false,
    0 );

insert into romber_member.relationship_types (
    associated_meta_class_id,
    contacts_or_not,
    description_a,
    description_b,
    generic_or_not,
    max_usernames,
    member_relationship_type_code,
    member_relationship_type_name,
    min_usernames,
    payments_or_not,
    subledger_or_not,
    unique_or_not,
    validity_required  )
  values (
    0,
    false,
    'is the same as',
    'is the same as',
    false,
    0,
    'UNITY',
    'Unity',
    0,
    false,
    false,
    false,
    0 );