Romber

Database tables

romber_member.profile_option_sets

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of valid profile option sets. This information is dynamic and should have a data entry page.

Definition

Source romber_profile_option_sets_tbl.sql

create table romber_member.profile_option_sets (
  member_relationship_type_id   romber_member.relationship_type_id      not null,
  meta_virtual_enterprise_id    romber_meta.virtual_enterprise_id       not null,
  profile_option_set_code       romber_base.generic_code                not null,
  profile_option_set_id         romber_member.profile_option_set_id     not null
                                  default nextval ( 'romber_base.generic_id_seq' ),
  profile_option_set_name       romber_base.generic_name                not null,
  profile_option_set_title      varchar(511)                            not null );

Constraints

Source romber_profile_option_sets_pk.sql

alter table romber_member.profile_option_sets
  add constraint romber_profile_option_sets_pk
    primary key ( profile_option_set_id );

Source romber_profile_option_sets_uk1.sql

alter table romber_member.profile_option_sets
  add constraint romber_profile_option_sets_uk1
    unique (
      meta_virtual_enterprise_id,
      member_relationship_type_id,
      profile_option_set_code );

Source romber_profile_option_sets_fk1.sql

alter table romber_member.profile_option_sets
  add constraint romber_profile_option_sets_fk1
    foreign key ( member_relationship_type_id )
    references romber_member.relationship_types ( member_relationship_type_id );

Source romber_profile_option_sets_fk2.sql

alter table romber_member.profile_option_sets
  add constraint romber_profile_option_sets_fk2
    foreign key ( meta_virtual_enterprise_id )
    references romber_meta.virtual_enterprises ( meta_virtual_enterprise_id );