Romber

Database tables

romber_telecomm.internet_address_ranges

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of Internet address ranges associated with each country. This table is maintained using an import script.

Definition

Source romber_internet_address_ranges_tbl.sql

create table romber_telecomm.internet_address_ranges (
  country_id            romber_location.location_id     not null,
  internet_address_from romber_telecomm.internet_address        not null,
  internet_address_to   romber_telecomm.internet_address        not null );

Constraints

Source romber_internet_address_ranges_pk.sql

alter table romber_telecomm.internet_address_ranges
  add constraint romber_internet_address_ranges_pk
    primary key ( internet_address_from );

Source romber_internet_address_ranges_fk1.sql

alter table romber_telecomm.internet_address_ranges
  add constraint romber_internet_address_ranges_fk1
    foreign key ( country_id )
    references romber_location.countries ( country_id );