Romber

Database tables

romber_page.web_site_urls

• Purpose
• Definition
• Constraints
• Load
• Examples

Purpose

This table provides a list of URLs associated with a web site. This allows mutiple public URLs to be associated with the same web site.

Definition

Source romber_web_site_urls_tbl.sql

create table romber_page.web_site_urls (
  web_site_id           romber_page.web_site_id         not null,
  web_site_url          romber_base.generic_url         not null );

Constraints

Source romber_web_site_urls_pk.sql

alter table romber_page.web_site_urls
  add constraint romber_web_site_urls_pk
    primary key (
      web_site_id,
      web_site_url );

Source romber_web_site_urls_uk1.sql

alter table romber_page.web_site_urls
  add constraint romber_web_site_urls_uk1
    unique ( web_site_url );

Source romber_web_site_urls_fk1.sql

alter table romber_page.web_site_urls
  add constraint romber_web_site_urls_fk1
    foreign key ( web_site_id )
    references romber_page.web_sites ( web_site_id );

Load

Source romber_web_site_urls_load.sql

insert into romber_page.web_site_urls (
    web_site_id,
    web_site_url )
  values (
    ( select web_site_id from romber_page.web_sites where web_site_code = 'ROMBER' ),
    'http://dev.romber.net/' );

insert into romber_page.web_site_urls (
    web_site_id,
    web_site_url )
  values (
    ( select web_site_id from romber_page.web_sites where web_site_code = 'ROMBER' ),
    'http://dtst.romber.net/' );

insert into romber_page.web_site_urls (
    web_site_id,
    web_site_url )
  values (
    ( select web_site_id from romber_page.web_sites where web_site_code = 'ROMBER' ),
    'http://mnt.romber.net/' );

insert into romber_page.web_site_urls (
    web_site_id,
    web_site_url )
  values (
    ( select web_site_id from romber_page.web_sites where web_site_code = 'ROMBER' ),
    'http://mtst.romber.net/' );

insert into romber_page.web_site_urls (
    web_site_id,
    web_site_url )
  values (
    ( select web_site_id from romber_page.web_sites where web_site_code = 'ROMBER' ),
    'http://prep.romber.net/' );

insert into romber_page.web_site_urls (
    web_site_id,
    web_site_url )
  values (
    ( select web_site_id from romber_page.web_sites where web_site_code = 'ROMBER' ),
    'http://prod.romber.net/' );

insert into romber_page.web_site_urls (
    web_site_id,
    web_site_url )
  values (
    ( select web_site_id from romber_page.web_sites where web_site_code = 'ROMBER' ),
    'http://test.romber.net/' );

insert into romber_page.web_site_urls (
    web_site_id,
    web_site_url )
  values (
    ( select web_site_id from romber_page.web_sites where web_site_code = 'ROMBER' ),
    'http://www.romber.net/' );

Examples

insert into romber_page.web_site_urls (
    web_site_id,
    web_site_url )
  values (
    ( select web_site_id from romber_page.web_sites
        where web_site_code = 'ROMBERWORLD' ),
    'http://www.romber.net/world/' );