Romber

Database tables

romber_location.thoroughfare_suffices

• Purpose
• Definition
• Constraints
• Load

Purpose

This table provides a list of valid thoroughfare suffices. This information is fairly static and requires its own data entry page.

Definition

Source romber_thoroughfare_suffices_tbl.sql

create table romber_location.thoroughfare_suffices (
  thoroughfare_suffix_code      romber_base.generic_code        not null,
  thoroughfare_suffix_id        romber_location.location_id     not null,
  thoroughfare_suffix_name      romber_base.generic_name        not null );

Constraints

Source romber_thoroughfare_suffices_pk.sql

alter table romber_location.thoroughfare_suffices
  add constraint romber_thoroughfare_suffices_pk
    primary key ( thoroughfare_suffix_id );

Source romber_thoroughfare_suffices_uk1.sql

alter table romber_location.thoroughfare_suffices
  add constraint romber_thoroughfare_suffices_uk1
    unique ( thoroughfare_suffix_code );

Source romber_thoroughfare_suffices_fk1.sql

alter table romber_location.thoroughfare_suffices
  add constraint romber_thoroughfare_suffices_fk1
    foreign key ( thoroughfare_suffix_id )
    references romber_location.locations ( location_id );

Load

Source romber_thoroughfare_suffices_load.sql

insert into romber_location.thoroughfare_suffices (
    thoroughfare_suffix_code,
    thoroughfare_suffix_id,
    thoroughfare_suffix_name )
  values ( '', 0, '' );