Romber

Database tables

romber_telecomm.internet_domain_zones

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of Internet domain zones. This information is dynamic and does need a data entry page.

Definition

Source romber_internet_domain_zones_tbl.sql

create table romber_telecomm.internet_domain_zones (
  internet_domain_name_id       romber_telecomm.internet_domain_name_id         not null,
  internet_domain_zone_id       romber_telecomm.internet_domain_zone_id         not null );

Constraints

Source romber_internet_domain_zones_pk.sql

alter table romber_telecomm.internet_domain_zones
  add constraint romber_internet_domain_zones_pk
    primary key ( internet_domain_zone_id );

Source romber_internet_domain_zones_uk1.sql

alter table romber_telecomm.internet_domain_zones
  add constraint romber_internet_domain_zones_uk1
    unique ( internet_domain_name_id );

Source romber_internet_domain_zones_fk1.sql

alter table romber_telecomm.internet_domain_zones
  add constraint romber_internet_domain_zones_fk1
    foreign key ( internet_domain_zone_id )
    references romber_item.instances ( item_instance_id );

Source romber_internet_domain_zones_fk2.sql

alter table romber_telecomm.internet_domain_zones
  add constraint romber_internet_domain_zones_fk2
    foreign key ( internet_domain_name_id )
    references romber_telecomm.internet_domain_names ( internet_domain_name_id )
    deferrable initially immediate;