Romber

Database tables

romber_page.web_site_business_regions

• Purpose
• Definition
• Constraints
• Load
• Examples

Purpose

This table provides a list of web site associations with business regions.

A web site is accessed using its associated code.

Definition

Source romber_web_site_business_regions_tbl.sql

create table romber_page.web_site_business_regions (
  business_region_id    romber_member.relationship_id   not null,
  web_site_id           romber_page.web_site_id         not null );

Constraints

Source romber_web_site_business_regions_pk.sql

alter table romber_page.web_site_business_regions
  add constraint romber_web_site_business_regions_pk
    primary key (
      web_site_id,
      business_region_id );

Source romber_web_site_business_regions_fk1.sql

alter table romber_page.web_site_business_regions
  add constraint romber_web_site_business_regions_fk1
    foreign key ( web_site_id )
    references romber_page.web_sites ( web_site_id );

Source romber_web_site_business_regions_fk2.sql

alter table romber_page.web_site_business_regions
  add constraint romber_web_site_business_regions_fk2
    foreign key ( business_region_id )
    references romber_base.business_regions ( business_region_id );

Load

Source romber_web_site_business_regions_load.sql

insert into romber_page.web_site_business_regions (
    web_site_id,
    business_region_id )
  select
    ( select web_site_id from romber_page.web_sites where web_site_code = 'ROMBER' ),
    business_region_id
  from romber_base.business_region_details t1
    where business_code = 'ROMBER';

Examples

insert into romber_page.web_site_business_regions (
    web_site_id,
    business_region_id )
  values (
    ( select web_site_id
	from romber_page.web_sites
	where web_site_code = 'DEFAULT' ),
    ( select business_region_id
	from romber_base.business_region_details
	where business_code = 'ROMBER'
	  and region_code = 'WORLD' ) );