Questions tagged [address]

For questions about identifying and labelling locations with postal addresses or similar encoding schemes. Both published standard schemes and novel schemes are included.

Filter by
Sorted by
Tagged with
0 votes
1 answer

Can a foreign key be used for two primary keys?

I'm still a beginner in sql and I have to transform this relation between clients and addresses and vendors and adresses. This uses 2 primary keys(1 for the vendors and 1 for the clients). My question ...
Nightstar479's user avatar
4 votes
5 answers

How do others know what is delivery address and invoice address if they are in the same table?

When I searched around, the recommended way is to use the invoice address and delivery address in the same table and use a field "type" to show what it is. For example Addresses(Company, ...
Xtreme's user avatar
  • 141
1 vote
0 answers

How do I parse Address into Street Number, Street Name, Type, Unit Number?

How do I parse Address into Street Number, Name, Type, Unit Number? Is there a function which will conduct this? 2280 MEYERS AVE ALDERGROVE AVE & S ...
user avatar
5 votes
2 answers

Postgres inet array contains a single ip

Requirement: user can add single ips or ip address ranges to a database table(for example permissions table having ipAddresses of inet[] type). I need to query that a single ip is contained in the ...
Radio Active's user avatar
10 votes
2 answers

PostgreSQL, what is the hostname address of my default database?

I just created a PostgreSQL database on my laptop (following these instructions), which is running Linux CentOS 7. Now I would like to understand what is the hostname address of my default database. ...'s user avatar
7 votes
1 answer

How do I parse addresses in PostgreSQL?

Let's say for instance that I want to parse these addresses for the Chicken Ranch Chicken Ranch 10511 Homestead Rd Pahrump, NV 89061 Chicken Ranch 1600 Pennsylvania Avenue NW Washington, D.C. 20500 ...
Evan Carroll's user avatar
  • 62.2k
2 votes
1 answer

Field/datatype for searchable address components?

I'm using Django with Postgres, and I'm looking for a field/datatype to store address components that come from Google Places API in this format: "address_components": [ {"long_name": "27", "...
davidtgq's user avatar
  • 699
0 votes
1 answer

Combine addresses missing Unit/Suite #

I have a list of addresses which need to be updated in SQL Server. How can I go about adding the Suite # to the addresses which are missing it? Address 1 Burton Hills Blvd, Suite 250 1 Burton Hills ...
Geoff Dawdy's user avatar
  • 1,103
26 votes
7 answers

What problems are solved by splitting street addresses into individual columns?

We have a team who designs the tables and relations for software developers. In our organization, they are pretty strict about enforcing 3NF normalization - which to be honest, I agree with given the ...
Greg Burghardt's user avatar
0 votes
1 answer

Struggling to design addresses table for fast querying

I have two tables: addresses and locations. Locations zipcode city county state Addresses line1 line2 city county state zipcode Posts Id Address_id Body All my users are required to provide at ...
Cristian's user avatar
  • 203
1 vote
1 answer

Should I assimilate all address lines to a single line?

I'm new here, so I'll keep my question straight and short. I am building a webapp that lets users select some product, submit their details and place an order. Currently, my ORDER table contains only ...
user21904's user avatar
  • 113
3 votes
2 answers

Relational database for address model

I want to design an "Address" model for all types of entities like users, businesses, etc. I have two types of main models: one is User and the other is Business. Each one has different ...
Gowri's user avatar
  • 209
5 votes
2 answers

Separate Address Table, Latitude, Longitude

We are designing a DB for a limited functionality social networking application. Users (Registered Users), Retail Outlets, etc are several entities we need to store. We need to store Address of each ...
Rakesh B's user avatar