Romber

Database tables

romber_telecomm.telephone_numbers

• Purpose
• Definition
• Constraints

Purpose

This table provides a list of telephone numbers. This information is dynamic and does need a data entry page.

Definition

Source romber_telephone_numbers_tbl.sql

create table romber_telecomm.telephone_numbers (
  telephone_area_id     romber_telecomm.address_id              not null,
  telephone_number      romber_base.generic_code                not null,
  telephone_number_id   romber_telecomm.address_id              not null );

Constraints

Source romber_telephone_numbers_pk.sql

alter table romber_telecomm.telephone_numbers
  add constraint romber_telephone_numbers_pk
    primary key ( telephone_number_id );

Source romber_telephone_numbers_uk1.sql

alter table romber_telecomm.telephone_numbers
  add constraint romber_telephone_numbers_uk1
    unique (
      telephone_area_id,
      telephone_number );

Source romber_telephone_numbers_fk1.sql

alter table romber_telecomm.telephone_numbers
  add constraint romber_telephone_numbers_fk1
    foreign key ( telephone_number_id )
    references romber_telecomm.addresses ( telecomm_address_id );

Source romber_telephone_numbers_fk2.sql

alter table romber_telecomm.telephone_numbers
  add constraint romber_telephone_numbers_fk2
    foreign key ( telephone_area_id )
    references romber_telecomm.telephone_area_codes ( telephone_area_id );