Romber

Database tables

romber_item.component_types

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid item component types.

Definition

Source romber_item_component_types_tbl.sql

create table romber_item.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,
  item_component_type_code      romber_base.generic_code        not null,
  item_component_type_id        romber_item.component_type_id   not null
                                  default nextval ( 'romber_base.generic_id_seq' ),
  item_component_type_label     romber_base.generic_name        not null,
  item_component_type_name      romber_base.generic_name        not null,
  item_component_seq_num        int                             not null,
  item_zone_id                  romber_item.zone_id             not null,
  print_or_not                  boolean                         not null,
  upload_or_not                 boolean                         not null );

Constraints

Source romber_item_component_types_pk.sql

alter table romber_item.component_types
  add constraint romber_item_component_types_pk
    primary key ( item_component_type_id );

Source romber_item_component_types_uk1.sql

alter table romber_item.component_types
  add constraint romber_item_component_types_uk1
    unique ( item_component_type_code );

Source romber_item_component_types_uk2.sql

alter table romber_item.component_types
  add constraint romber_item_component_types_uk2
    unique (
      item_zone_id,
      item_component_seq_num );

Source romber_item_component_types_fk1.sql

alter table romber_item.component_types
  add constraint romber_item_component_types_fk1
    foreign key ( item_zone_id )
    references romber_item.zones ( item_zone_id );

Source romber_item_component_types_fk2.sql

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

Source romber_item_component_types_fk3.sql

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

Source romber_item_component_types_fk4.sql

alter table romber_item.component_types
  add constraint romber_item_component_types_fk4
    foreign key ( meta_property_type_id )
    references romber_meta.property_types ( meta_property_type_id );

Load

Source romber_item_component_types_load.sql