STREET_NAME

Description

This table stores the street name information.

Columns

Column Name Data Type Description
ID bigint The unique identifier of the street name.
PREFIX varchar The prefix of the street name.
STREET_NAME varchar The name of the street.
SUFFIX varchar The suffix of the street name.
STREET_NAMES_STREET_ADDRESS 0 bigint The street names street address value.
STREET_NAMES_HJORDER int The HJORDER value of the street name.

Primary Key

  • ID

Foreign Key Relationships

  • STREET_NAMES_STREET_ADDRESS 0 references STREET_ADDRESS(ID)