Romber

Database tables

romber_telecomm.smtp_addresses

• Purpose
• Definition
• Constraints

Purpose

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

Definition

Source romber_smtp_addresses_tbl.sql

create table romber_telecomm.smtp_addresses (
  internet_domain_zone_id       romber_telecomm.internet_domain_zone_id not null,
  smtp_address_id               romber_telecomm.address_id              not null,
  smtp_address_prefix           romber_base.generic_name                not null );

Constraints

Source romber_smtp_addresses_pk.sql

alter table romber_telecomm.smtp_addresses
  add constraint romber_smtp_addresses_pk
    primary key ( smtp_address_id );

Source romber_smtp_addresses_uk1.sql

alter table romber_telecomm.smtp_addresses
  add constraint romber_smtp_addresses_uk1
    unique (
      internet_domain_zone_id,
      smtp_address_prefix );

Source romber_smtp_addresses_fk1.sql

alter table romber_telecomm.smtp_addresses
  add constraint romber_smtp_addresses_fk1
    foreign key ( smtp_address_id )
    references romber_telecomm.addresses ( telecomm_address_id );

Source romber_smtp_addresses_fk2.sql

alter table romber_telecomm.smtp_addresses
  add constraint romber_smtp_addresses_fk2
    foreign key ( internet_domain_zone_id )
    references romber_telecomm.internet_domain_zones ( internet_domain_zone_id );