Romber

Database tables

romber_telecomm.internet_domain_names

• Purpose
• Definition
• Constraints

Purpose

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

Definition

Source romber_internet_domain_names_tbl.sql

create table romber_telecomm.internet_domain_names (
  internet_domain_name          romber_base.generic_name                        not null,
  internet_domain_name_id       romber_telecomm.internet_domain_name_id         not null,
  internet_domain_name_reverse  romber_base.generic_name                        not null,
  internet_domain_zone_id       romber_telecomm.internet_domain_zone_id         not null );

Constraints

Source romber_internet_domain_names_pk.sql

alter table romber_telecomm.internet_domain_names
  add constraint romber_internet_domain_names_pk
    primary key ( internet_domain_name_id );

Source romber_internet_domain_names_uk1.sql

alter table romber_telecomm.internet_domain_names
  add constraint romber_internet_domain_names_uk1
    unique ( internet_domain_name );

Source romber_internet_domain_names_uk2.sql

alter table romber_telecomm.internet_domain_names
  add constraint romber_internet_domain_names_uk2
    unique ( internet_domain_name_reverse );

Source romber_internet_domain_names_fk1.sql

alter table romber_telecomm.internet_domain_names
  add constraint romber_internet_domain_names_fk1
    foreign key ( internet_domain_zone_id )
    references romber_telecomm.internet_domain_zones ( internet_domain_zone_id );