submission_location

-1 rows


Description

The details of a client’s location.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
submission_location_id serial 10 √ nextval('nrfc.submission_location_seq'::regclass)
submission_location_contact_xref.submission_location_id submission_location_id_fk R

Incremental id generated for a location of a client.
submission_id int4 10 null
submission.submission_id submission_id_fk R

Incremental id generated for a submission of a client.
street_address varchar 40 null

The address of a client, including the street number and street name.
country_code varchar 2 null
country_code.country_code submission_location_country_code_fk R
province_code.country_code submission_location_province_code_fk R

A code representing the code of a country.
province_code varchar 2 null
province_code.province_code submission_location_province_code_fk R

A code representing the code of a province, state, department or territory.
city_name varchar 30 null

The name of the city of the location.
postal_code varchar 10 null
location_name varchar 40 null

The location name of an address. Examples of location names include, but are not limited to, Mailing Address, Billing Address among others.
business_phone_number varchar 14 √ null

The phone number of a client’s specific location.
secondary_phone_number varchar 14 √ null

A secondary phone number of a client’s specific location.
fax_number varchar 14 √ null

The fax number of a client’s specific location.
notes varchar 4000 √ null

Any additional information about the client’s location or specific instructions for contacting them.
complementary_address_1 varchar 40 √ null

A complementary address line of a client
complementary_address_2 varchar 40 √ null

A second complementary address line of a client
email_address varchar 100 √ null

The email address of the client’s location.

Indexes

Constraint Name Type Sort Column(s)
submission_location_id_pk Primary key Asc submission_location_id

Relationships

Close relationships within degrees of separation