Romber

Database tables

romber_member.profile_option_set_elements

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of profile options in each profile option set. This information is loaded by a script and doesn't need a data entry page.

Definition

Source romber_profile_option_set_elements_tbl.sql

create table romber_member.profile_option_set_elements (
  profile_option_id             romber_member.profile_option_id         not null,
  profile_option_seq_num        int                                     not null,
  profile_option_set_id         romber_member.profile_option_set_id     not null );

Constraints

Source romber_profile_option_set_elements_pk.sql

alter table romber_member.profile_option_set_elements
  add constraint romber_profile_option_set_elements_pk
    primary key (
     profile_option_set_id,
     profile_option_seq_num );

Source romber_profile_option_set_elements_fk1.sql

alter table romber_member.profile_option_set_elements
  add constraint romber_profile_option_set_elements_fk1
    foreign key ( profile_option_set_id )
    references romber_member.profile_option_sets ( profile_option_set_id );

Source romber_profile_option_set_elements_fk2.sql

alter table romber_member.profile_option_set_elements
  add constraint romber_profile_option_set_elements_fk2
    foreign key ( profile_option_id )
    references romber_member.profile_options ( profile_option_id );