 CREATE TABLE "Event" (
     event_name character varying,
     event_time timestamp without time zone,
-    event_text character varying
+    event_text character varying,
+    event_data_id bigint,
+    event_id bigint NOT NULL
 );
 
 

CREATE TABLE "EventData" (
    end_time timestamp without time zone,
    number_events smallint,
    start_time timestamp without time zone
);



ALTER TABLE public."viewReadings" OWNER TO daniel;

--
-- Name: event_id; Type: DEFAULT; Schema: public; Owner: sepgroup
--

ALTER TABLE ONLY "Event" ALTER COLUMN event_id SET DEFAULT nextval('event_id_seq'::regclass);


--
-- Name: event_data_id; Type: DEFAULT; Schema: public; Owner: sepgroup
--

ALTER TABLE ONLY "EventData" ALTER COLUMN event_data_id SET DEFAULT nextval('event_data_id_seq'::regclass);


--
-- Name: interval_id; Type: DEFAULT; Schema: public; Owner: sepgroup
--

