Romber

Database tables

romber_page.layout_zones

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of page zones used for each page layout.

Definition

Source romber_page_layout_zones_tbl.sql

create table romber_page.layout_zones (
  page_layout_id        romber_page.layout_id           not null,
  page_zone_id          romber_page.zone_id             not null );

Constraints

Source romber_page_layout_zones_pk.sql

alter table romber_page.layout_zones
  add constraint romber_page_layout_zones_pk
    primary key (
      page_layout_id,
      page_zone_id );

Source romber_page_layout_zones_fk1.sql

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

Source romber_page_layout_zones_fk2.sql

alter table romber_page.layout_zones
  add constraint romber_page_layout_zones_fk2
    foreign key ( page_zone_id )
    references romber_page.zones ( page_zone_id );

Load

Source romber_page_layout_zones_load.sql

insert into romber_page.layout_zones ( page_layout_id, page_zone_id )
  values (
    ( select page_layout_id from romber_page.layouts where page_layout_code = 'DEFAULT' ),
    ( select page_zone_id from romber_page.zones
        where page_zone_code = 'BEGIN' ) );

insert into romber_page.layout_zones ( page_layout_id, page_zone_id )
  values (
    ( select page_layout_id from romber_page.layouts where page_layout_code = 'DEFAULT' ),
    ( select page_zone_id from romber_page.zones
        where page_zone_code = 'HEADER' ) );

insert into romber_page.layout_zones ( page_layout_id, page_zone_id )
  values (
    ( select page_layout_id from romber_page.layouts where page_layout_code = 'DEFAULT' ),
    ( select page_zone_id from romber_page.zones
        where page_zone_code = 'MIDDLE' ) );

insert into romber_page.layout_zones ( page_layout_id, page_zone_id )
  values (
    ( select page_layout_id from romber_page.layouts where page_layout_code = 'DEFAULT' ),
    ( select page_zone_id from romber_page.zones
        where page_zone_code = 'BODY' ) );

insert into romber_page.layout_zones ( page_layout_id, page_zone_id )
  values (
    ( select page_layout_id from romber_page.layouts where page_layout_code = 'DEFAULT' ),
    ( select page_zone_id from romber_page.zones
        where page_zone_code = 'END' ) );