Romber

Database tables

romber_item.zones

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid item zones.

A item zone reflects some component of item layout. Uses include:

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

Definition

Source romber_item_zones_tbl.sql

create table romber_item.zones (
  item_zone_code        romber_base.generic_code        not null,
  item_zone_id          romber_item.zone_id             not null
                          default nextval ( 'romber_base.generic_id_seq' ),
  item_zone_name        romber_base.generic_name        not null );

Constraints

Source romber_item_zones_pk.sql

alter table romber_item.zones
  add constraint romber_item_zones_pk
    primary key ( item_zone_id );

Source romber_item_zones_uk1.sql

alter table romber_item.zones
  add constraint romber_item_zones_uk1
    unique ( item_zone_code );

Load

Source romber_item_zones_load.sql