Proposed schema for company location model

gistfile1.txt

CREATE TABLE locations (
    id integer NOT NULL,
    company_id integer,
    name character varying(255),
    legacy_url text,
    address1 character varying(255),
    address2 character varying(255),
    city character varying(255),
    region character varying(255),
    country character varying(255),
    postcode character varying(255),
    telephone character varying(255),
    manager_name character varying(255),
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);

see branch db-hygiene for some code relating to timestamps (should upgrade your schema to timezone columns
automagically)

I don't think timestamptz is desired as it does funny things depending on the local where you are querying/inserting from. See this link on how timezone conversion takes place.

http://www.postgresql.org/docs/9.3/static/functions-datetime.html#FUNCTIONS-DATETIME-ZONECONVERT-TABLE

See this excellent post on the differences.

http://stackoverflow.com/questions/9571392/ignoring-timezones-altogether-in-rails-and-postgresql