     created_at timestamp without time zone,
     updated_at timestamp without time zone,
     short_name character varying(255),
-    email text,
-    email_confirmed boolean,
     notes text,
     noc_code character varying(255),
     reference_name character varying(255),

--

CREATE FUNCTION st_intersects(geography, geography) RETURNS boolean
    LANGUAGE sql IMMUTABLE STRICT
    AS $_$SELECT $1 && $2 AND _ST_Distance($1, $2, 0.0, false) < 0.00001$_$;





--
-- Name: journey_patterns_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY journey_patterns
    ADD CONSTRAINT journey_patterns_pkey PRIMARY KEY (id);


--
-- Name: load_run_completions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY load_run_completions
    ADD CONSTRAINT load_run_completions_pkey PRIMARY KEY (id);


--
-- Name: localities_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

