Romber

Database tables

romber_page.zones

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid page zones.

A page zone reflects some component of page layout. Uses include:

• An associated zone_include column in one or more tables.
• An attribute of a table such as romber_page.zones.

Definition

Source romber_page_zones_tbl.sql

create table romber_page.zones (
  page_zone_code        romber_base.generic_code        not null,
  page_zone_id          romber_page.zone_id             not null
                          default nextval ( 'romber_base.generic_id_seq' ),
  page_zone_name        romber_base.generic_name        not null );

Constraints

Source romber_page_zones_pk.sql

alter table romber_page.zones
  add constraint romber_page_zones_pk
    primary key ( page_zone_id );

Source romber_page_zones_uk1.sql

alter table romber_page.zones
  add constraint romber_page_zones_uk1
    unique ( page_zone_code );

Load

Source romber_page_zones_load.sql

insert into romber_page.zones ( page_zone_code, page_zone_name )
  values ( 'BEGIN', 'Begining of page' );

insert into romber_page.zones ( page_zone_code, page_zone_name )
  values ( 'BODY', 'Main content' );

insert into romber_page.zones ( page_zone_code, page_zone_name )
  values ( 'END', 'End of page including footer' );

insert into romber_page.zones ( page_zone_code, page_zone_name )
  values ( 'HEADER', 'Header content' );

insert into romber_page.zones ( page_zone_code, page_zone_name )
  values ( 'MIDDLE', 'Middle of page including navigation' );