CREATE TABLE clickstream (
    clickstream_id bigint DEFAULT nextval('clickstream_seq'::regclass) NOT NULL,
    cookie_id character varying(255),
    user_id character varying(255),
    start_date timestamp without time zone,
    end_date timestamp without time zone,
    referer character varying(255),
    remote_address character varying(255),
    remote_hostname character varying(255),
    user_agent character varying(255),
    bot boolean,
    host_id character varying(50),
    last_page_id character varying(50),
    first_page_id character varying(50),
    operating_system character varying(50),
    browser_name character varying(50),
    browser_version character varying(50),
    mobile_device boolean,
    number_of_requests integer
);


ALTER TABLE public.clickstream OWNER TO root;

--
-- Name: clickstream_pkey; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace:
--

ALTER TABLE ONLY clickstream
    ADD CONSTRAINT clickstream_pkey PRIMARY KEY (clickstream_id);

CREATE INDEX clickstream_cookieid_idx ON clickstream USING btree (cookie_id);

CREATE TABLE clickstream_request (
    clickstream_request_id bigint DEFAULT nextval('clickstream_request_seq'::regclass) NOT NULL,
    clickstream_id bigint,
    server_name character varying(255),
    protocol character varying(255),
    server_port integer,
    request_uri character varying(255),
    request_order integer,
    query_string text,
    language_id bigint,
    timestampper timestamp without time zone,
    host_id character varying(255),
    associated_identifier character varying(50)
);


ALTER TABLE public.clickstream_request OWNER TO root;

--
-- Name: clickstream_request_pkey; Type: CONSTRAINT; Schema: public; Owner: root; Tablespace:
--

ALTER TABLE ONLY clickstream_request
    ADD CONSTRAINT clickstream_request_pkey PRIMARY KEY (clickstream_request_id);


--
-- Name: clickstream_timestamp_idx; Type: INDEX; Schema: public; Owner: root; Tablespace:
--

CREATE INDEX clickstream_timestamp_idx ON clickstream_request USING btree (timestampper);


--
-- Name: clickstrem_request_host_idx; Type: INDEX; Schema: public; Owner: root; Tablespace:
--

CREATE INDEX clickstrem_request_host_idx ON clickstream_request USING btree (host_id);