Romber

Database tables

romber_page.layout_classes

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides an orderd list of meta classes associated with a page layout.

Definition

Source romber_page_layout_classes_tbl.sql

create table romber_page.layout_classes (
  page_layout_id        romber_page.layout_id           not null,
  page_class_seq_num    int                             not null,
  meta_class_id         romber_meta.class_id    not null );

Constraints

Source romber_page_layout_classes_pk.sql

alter table romber_page.layout_classes
  add constraint romber_page_layout_classes_pk
    primary key (
      page_layout_id,
      page_class_seq_num );

Source romber_page_layout_classes_uk1.sql

alter table romber_page.layout_classes
  add constraint romber_page_layout_classes_uk1
    unique (
      page_layout_id,
      meta_class_id );

Source romber_page_layout_classes_fk1.sql

alter table romber_page.layout_classes
  add constraint romber_page_layout_classes_fk1
    foreign key ( page_layout_id )
    references romber_page.layouts ( page_layout_id );

Source romber_page_layout_classes_fk2.sql

alter table romber_page.layout_classes
  add constraint romber_page_layout_classes_fk2
    foreign key ( meta_class_id )
    references romber_meta.classes ( meta_class_id );

Load

Source romber_page_layout_classes_load.sql

insert into romber_page.layout_classes ( page_layout_id, page_class_seq_num, meta_class_id )
  values (
    ( select page_layout_id from romber_page.layouts where page_layout_code = 'DEFAULT' ),
    1,
    ( select meta_class_id from romber_meta.classes
        where meta_class_code_singular = 'WEB_SITE' ) );

insert into romber_page.layout_classes ( page_layout_id, page_class_seq_num, meta_class_id )
  values (
    ( select page_layout_id from romber_page.layouts where page_layout_code = 'DEFAULT' ),
    2,
    ( select meta_class_id from romber_meta.classes
        where meta_class_code_singular = 'BUSINESS_REGION' ) );

insert into romber_page.layout_classes ( page_layout_id, page_class_seq_num, meta_class_id )
  values (
    ( select page_layout_id from romber_page.layouts where page_layout_code = 'DEFAULT' ),
    3,
    ( select meta_class_id from romber_meta.classes
        where meta_class_code_singular = 'BUSINESS' ) );