Schema - Addresses

< Schema

addresses

Name Datatype Description Relation
id integer - -
full string - -
town string - -
postcode string - -
map_east string Eastings1 -
map_north string Northings1 -
created_at string - -
updated_at string - -
ward_code string Electoral ward code2 -
ward_name string Electoral ward name -
latitude string Latitude3 -
longitude string Longitude3 -
property_id integer - properties.id

  1. Northings / Eastings / lat lng will be updated as data is ingressed. ↩ ↩2

  2. Ward codes are defined by the ONS ↩

  3. Lat/lng data is stored as is for now, we have not set a format. ↩ ↩2