Romber

Database tables

romber_page.layouts

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid page layouts.

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

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

Definition

Source romber_page_layouts_tbl.sql

create table romber_page.layouts (
  page_layout_code      romber_base.generic_code        not null,
  page_layout_id        romber_page.layout_id           not null
                          default nextval ( 'romber_base.generic_id_seq' ),
  page_layout_name      romber_base.generic_name        not null );

Constraints

Source romber_page_layouts_pk.sql

alter table romber_page.layouts
  add constraint romber_page_layouts_pk
    primary key ( page_layout_id );

Source romber_page_layouts_uk1.sql

alter table romber_page.layouts
  add constraint romber_page_layouts_uk1
    unique ( page_layout_code );

Load

Source romber_page_layouts_load.sql

insert into romber_page.layouts ( page_layout_code, page_layout_name )
  values ( 'DEFAULT', 'Default page layout' );