Romber

Database tables

romber_member.memb_reln_profile_options

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of valid member relationship profile options. This information is dynamic and is populated by the various member managament tasks.

Definition

Source romber_memb_reln_profile_options_tbl.sql

create table romber_member.memb_reln_profile_options (
  member_relationship_id        romber_member.relationship_id           not null,
  meta_object_id                romber_meta.object_id                   not null,
  meta_transaction_id           romber_meta.transaction_id              not null,
  option_value_number           int                                     not null,
  option_value_text             varchar(511)                            not null,
  profile_option_id             romber_member.profile_option_id         not null );

Constraints

Source romber_memb_reln_profile_options_pk.sql

alter table romber_member.memb_reln_profile_options
  add constraint romber_memb_reln_profile_options_pk
    primary key (
      meta_object_id,
      meta_transaction_id );

Source romber_memb_reln_profile_options_uk1.sql

alter table romber_member.memb_reln_profile_options
  add constraint romber_memb_reln_profile_options_uk1
    unique (
      member_relationship_id,
      profile_option_id,
      meta_transaction_id );

Source romber_memb_reln_profile_options_fk1.sql

alter table romber_member.memb_reln_profile_options
  add constraint romber_memb_reln_profile_options_fk1
    foreign key (
      meta_object_id,
      meta_transaction_id )
    references romber_meta.object__versions (
      meta_object_id,
      meta_transaction_id );

Source romber_memb_reln_profile_options_fk2.sql

alter table romber_member.memb_reln_profile_options
  add constraint romber_memb_reln_profile_options_fk2
    foreign key ( member_relationship_id )
    references romber_member.relationships ( member_relationship_id );

Source romber_memb_reln_profile_options_fk3.sql

alter table romber_member.memb_reln_profile_options
  add constraint romber_memb_reln_profile_options_fk3
    foreign key ( profile_option_id )
    references romber_member.profile_options ( profile_option_id );

Source romber_memb_reln_profile_options_ck1.sql

alter table romber_member.memb_reln_profile_options
  add constraint romber_memb_reln_profile_options_ck1
    check ( member_relationship_id > 0 );