Romber

Database tables

romber_item.layout_zones

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of item zones used for each item layout.

Definition

Source romber_item_layout_zones_tbl.sql

create table romber_item.layout_zones (
  item_layout_id        romber_item.layout_id           not null,
  item_zone_id          romber_item.zone_id             not null );

Constraints

Source romber_item_layout_zones_pk.sql

alter table romber_item.layout_zones
  add constraint romber_item_layout_zones_pk
    primary key (
      item_layout_id,
      item_zone_id );

Source romber_item_layout_zones_fk1.sql

alter table romber_item.layout_zones
  add constraint romber_item_layout_zones_fk1
    foreign key ( item_layout_id )
    references romber_item.layouts ( item_layout_id );

Source romber_item_layout_zones_fk2.sql

alter table romber_item.layout_zones
  add constraint romber_item_layout_zones_fk2
    foreign key ( item_zone_id )
    references romber_item.zones ( item_zone_id );