Romber

Database tables

romber_page.web_sites

• Purpose
• Definition
• Constraints
• Load
• Examples

Purpose

This table provides a list of web sites. Each web site is associated with specific business regions using the romber_page.web_site_business_regions table.

A web site is accessed using its associated code.

Definition

Source romber_web_sites_tbl.sql

create table romber_page.web_sites (
  page_layout_id                romber_page.layout_id           not null,
  web_site_code                 romber_base.generic_code        not null,
  web_site_id                   romber_page.web_site_id         not null
                                  default nextval ( 'romber_base.generic_id_seq' ),
  web_site_name                 romber_base.generic_name        not null );

Constraints

Source romber_web_sites_pk.sql

alter table romber_page.web_sites
  add constraint romber_web_sites_pk
    primary key ( web_site_id );

Source romber_web_sites_uk1.sql

alter table romber_page.web_sites
  add constraint romber_web_sites_uk1
    unique ( web_site_code );

Source romber_web_sites_fk1.sql

alter table romber_page.layout_zones
  add constraint romber_web_sites_fk1
    foreign key ( page_layout_id )
    references romber_page.layouts ( page_layout_id );

Load

Source romber_web_sites_load.sql

insert into romber_page.web_sites (
    page_layout_id,
    web_site_code,
    web_site_name )
  values (
    ( select page_layout_id from romber_page.layouts where page_layout_code = 'DEFAULT' ),
    'ROMBER',
    'Romber default web site' );

Examples

insert into romber_page.web_sites (
    web_site_code,
    web_site_name,
    web_site_page_begin,
    web_site_page_end,
    web_site_page_middle )
  values (
    'ROMBERWORLD',
    'Insight Vacations - Australia',
    'page_begin.html',
    'page_end.html',
    'page_middle.html' );