Romber

Database tables

romber_page.component_types

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid page component types.

Definition

Source romber_page_component_types_tbl.sql

create table romber_page.component_types (
  associated_meta_class_id      romber_meta.class_id            not null,
  editor_or_not                 boolean                         not null,
  highest_meta_class_id         romber_meta.class_id            not null,
  highlight_or_not              boolean                         not null,
  max_characters                int                             not null,
  max_columns                   smallint                        not null,
  max_rows                      smallint                        not null,
  meta_property_type_id         romber_meta.property_type_id    not null,
  num_columns                   smallint                        not null,
  num_rows                      smallint                        not null,
  page_component_type_code      romber_base.generic_code        not null,
  page_component_type_id        romber_page.component_type_id   not null
                                  default nextval ( 'romber_base.generic_id_seq' ),
  page_component_type_label     romber_base.generic_name        not null,
  page_component_type_name      romber_base.generic_name        not null,
  page_component_seq_num        int                             not null,
  page_zone_id                  romber_page.zone_id             not null,
  print_or_not                  boolean                         not null,
  upload_or_not                 boolean                         not null );

Constraints

Source romber_page_component_types_pk.sql

alter table romber_page.component_types
  add constraint romber_page_component_types_pk
    primary key ( page_component_type_id );

Source romber_page_component_types_uk1.sql

alter table romber_page.component_types
  add constraint romber_page_component_types_uk1
    unique ( page_component_type_code );

Source romber_page_component_types_uk2.sql

alter table romber_page.component_types
  add constraint romber_page_component_types_uk2
    unique (
      page_zone_id,
      page_component_seq_num );

Source romber_page_component_types_fk1.sql

alter table romber_page.component_types
  add constraint romber_page_component_types_fk1
    foreign key ( page_zone_id )
    references romber_page.zones ( page_zone_id );

Source romber_page_component_types_fk2.sql

alter table romber_page.component_types
  add constraint romber_page_component_types_fk2
    foreign key ( associated_meta_class_id )
    references romber_meta.classes ( meta_class_id );

Source romber_page_component_types_fk3.sql

alter table romber_page.component_types
  add constraint romber_page_component_types_fk3
    foreign key ( highest_meta_class_id )
    references romber_meta.classes ( meta_class_id );

Source romber_page_component_types_fk4.sql

alter table romber_page.component_types
  add constraint romber_page_component_types_fk4
    foreign key ( meta_property_type_id )
    references romber_meta.property_types ( meta_property_type_id );

Load

Source romber_page_component_types_load.sql

insert into romber_page.component_types (
    associated_meta_class_id,
    editor_or_not,
    highest_meta_class_id,
    highlight_or_not,
    max_characters,
    max_columns,
    max_rows,
    meta_property_type_id,
    num_columns,
    num_rows,
    page_component_type_code,
    page_component_type_label,
    page_component_type_name,
    page_component_seq_num,
    page_zone_id,
    print_or_not,
    upload_or_not )
  values (
    0,
    TRUE,
    ( select meta_class_id from romber_meta.classes
        where meta_class_code_singular = 'WEB_SITE' ),
    false,
    0,
    0,
    0,
    ( select meta_property_type_id from romber_meta.property_types
        where meta_property_type_code = 'TEXT' ),
    60,
    3,
    'BEGIN',
    '',
    'Begining of page',
    1,
    ( select page_zone_id from romber_page.zones where page_zone_code = 'BEGIN' ),
    false,
    false );

insert into romber_page.component_types (
    associated_meta_class_id,
    editor_or_not,
    highest_meta_class_id,
    highlight_or_not,
    max_characters,
    max_columns,
    max_rows,
    meta_property_type_id,
    num_columns,
    num_rows,
    page_component_type_code,
    page_component_type_label,
    page_component_type_name,
    page_component_seq_num,
    page_zone_id,
    print_or_not,
    upload_or_not )
  values (
    0,
    TRUE,
    ( select meta_class_id from romber_meta.classes
        where meta_class_code_singular = 'WEB_SITE' ),
    false,
    0,
    0,
    0,
    ( select meta_property_type_id from romber_meta.property_types
        where meta_property_type_code = 'TEXT' ),
    60,
    3,
    'MIDDLE',
    '',
    'Middle of page including navigation',
    1,
    ( select page_zone_id from romber_page.zones where page_zone_code = 'MIDDLE' ),
    false,
    false );

insert into romber_page.component_types (
    associated_meta_class_id,
    editor_or_not,
    highest_meta_class_id,
    highlight_or_not,
    max_characters,
    max_columns,
    max_rows,
    meta_property_type_id,
    num_columns,
    num_rows,
    page_component_type_code,
    page_component_type_label,
    page_component_type_name,
    page_component_seq_num,
    page_zone_id,
    print_or_not,
    upload_or_not )
  values (
    0,
    TRUE,
    ( select meta_class_id from romber_meta.classes
        where meta_class_code_singular = 'WEB_SITE' ),
    false,
    0,
    0,
    0,
    ( select meta_property_type_id from romber_meta.property_types
        where meta_property_type_code = 'TEXT' ),
    60,
    3,
    'END',
    '',
    'End of page including footer',
    1,
    ( select page_zone_id from romber_page.zones where page_zone_code = 'END' ),
    false,
    false );