Romber

Database tables

romber_item.layouts

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid item layouts.

An item layout reflects some component of item layout. Uses include:

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

Definition

Source romber_item_layouts_tbl.sql

create table romber_item.layouts (
  item_layout_code      romber_base.generic_code        not null,
  item_layout_id        romber_item.layout_id           not null
                          default nextval ( 'romber_base.generic_id_seq' ),
  item_layout_name      romber_base.generic_name        not null );

Constraints

Source romber_item_layouts_pk.sql

alter table romber_item.layouts
  add constraint romber_item_layouts_pk
    primary key ( item_layout_id );

Source romber_item_layouts_uk1.sql

alter table romber_item.layouts
  add constraint romber_item_layouts_uk1
    unique ( item_layout_code );

Load

Source romber_item_layouts_load.sql