Backend Testdata

testdata.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.6.2
-- Dumped by pg_dump version 9.6.2

-- Started on 2017-05-03 13:50:35 CEST

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 204 (class 1259 OID 17738)
-- Name: images; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE images (
    image_id uuid NOT NULL,
    url character varying NOT NULL,
    uploaded_at timestamp without time zone NOT NULL,
    owned_by uuid NOT NULL,
    classification_start timestamp without time zone,
    classification_duration bigint
);


ALTER TABLE images OWNER TO postgres;

--
-- TOC entry 206 (class 1259 OID 17748)
-- Name: predictions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE predictions (
    prediction_id integer NOT NULL,
    image_id uuid NOT NULL,
    category character varying NOT NULL,
    probability double precision NOT NULL,
    leftx integer NOT NULL,
    topy integer NOT NULL,
    rightx integer NOT NULL,
    bottomy integer NOT NULL
);


ALTER TABLE predictions OWNER TO postgres;

--
-- TOC entry 205 (class 1259 OID 17746)
-- Name: predictions_prediction_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE predictions_prediction_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE predictions_prediction_id_seq OWNER TO postgres;

--
-- TOC entry 2202 (class 0 OID 0)
-- Dependencies: 205
-- Name: predictions_prediction_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE predictions_prediction_id_seq OWNED BY predictions.prediction_id;


--
-- TOC entry 2072 (class 2604 OID 17751)
-- Name: predictions prediction_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY predictions ALTER COLUMN prediction_id SET DEFAULT nextval('predictions_prediction_id_seq'::regclass);


--
-- TOC entry 2195 (class 0 OID 17738)
-- Dependencies: 204
-- Data for Name: images; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY images (image_id, url, uploaded_at, owned_by, classification_start, classification_duration) FROM stdin;
927e048f-2a01-47fe-89c1-be1550786623	https://octotaggerpictures.blob.core.windows.net/pictures/set3pyifnlzypnl1ogwrju7irgphwjmxr1o4qvbi.jpg	2017-05-02 21:39:21	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
099f9fa4-2670-4706-8cad-40db3db4bb13	https://octotaggerpictures.blob.core.windows.net/pictures/c0p3st7ngnskqjyx5js9d5ogdccwxfjgb19ylc83.jpg	2017-05-02 21:44:25	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
a509a077-a193-4022-83d5-8ee129355932	https://octotaggerpictures.blob.core.windows.net/pictures/mi44cck65tjl18cgayoql40yukaw72le5mt93hjj.jpg	2017-05-02 21:47:33	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
82096e39-2a1a-4a9a-ab1e-ca7002f9f464	https://octotaggerpictures.blob.core.windows.net/pictures/lhp5j0u2tso7vs29iawnhdslqxomt37hh4q80urp.jpg	2017-05-02 22:07:07	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
bbb383c7-449e-406e-83c3-ec9f81581513	https://octotaggerpictures.blob.core.windows.net/pictures/wav2412x2a704ll2yvg12ns22cocj2fa1cz1glz4.jpg	2017-05-02 22:49:31	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
c7863808-e5c2-416a-b34a-584a7fe510dd	https://octotaggerpictures.blob.core.windows.net/pictures/cnf7cll441adqrcx4hxwzu4uhuigmn5zja27i4ko.jpg	2017-05-02 22:56:19	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
c46dbfcc-2e37-440a-871e-6eea5e3463cd	https://octotaggerpictures.blob.core.windows.net/pictures/u5u0yv2jk2orz5qqumeu159zxxh3dxooq4prwhl4.jpg	2017-05-02 22:56:23	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
69db2bf6-e4f3-4051-92d6-b5d8fd5ff5f2	https://octotaggerpictures.blob.core.windows.net/pictures/zdt3bsvm2rafiqqg4wpayhz9vnsnmt42pm78x4bb.jpg	2017-05-02 22:56:29	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
20d4a36e-38e6-4321-88f0-2562448770bb	https://octotaggerpictures.blob.core.windows.net/pictures/ja2jz347zhetbo00re7r8bfkldfqtfc7xzno3dgk.jpg	2017-05-02 23:02:36	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
740039a7-6363-4316-92b5-caca8fb580df	https://octotaggerpictures.blob.core.windows.net/pictures/0us96j6ww3z890xcszncw9dungmpxamkzhgxih9r.jpg	2017-05-02 23:03:14	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
5ad8a596-9373-40e2-8723-ff4dadaffcb6	https://octotaggerpictures.blob.core.windows.net/pictures/j4ns4it4k7zz7soulp0dbh2yfx2lo84aiuq2pbfi.jpg	2017-05-02 23:03:16	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
120276b2-7a5b-4c28-b410-abb9901713a9	https://octotaggerpictures.blob.core.windows.net/pictures/tcdiempxligztcx56p1e8k1fd4ir3t3lxbppltl1.jpg	2017-05-02 23:03:27	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
a43eb77b-4621-440c-9306-79293854983c	https://octotaggerpictures.blob.core.windows.net/pictures/m2fbvj83siyiq5x3c6et68lgrgdzet23cb06ovah.jpg	2017-05-02 23:04:14	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
ae5964a0-0c5c-4405-a3df-4b23c7c3309d	https://octotaggerpictures.blob.core.windows.net/pictures/yqvtsjvou2k4q1b45owadrq8zh3v6yv5kacs0txw.jpg	2017-05-03 11:11:47	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
590ee0fa-744c-42e6-8e89-bea6880d1240	https://octotaggerpictures.blob.core.windows.net/pictures/vto5yxr7d8jmi42hxtggxj4yaaipir7i4pmhx8py.jpg	2017-05-03 11:17:55	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
34c954d9-c1a3-44a7-8cfd-299541f93ad1	https://octotaggerpictures.blob.core.windows.net/pictures/egukn0aw0hu08mray445vgbpvk3yts6e7dygr3cq.jpg	2017-05-03 12:23:42	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
7ac34f8c-a5a3-4a8d-8422-a710a33a8586	https://octotaggerpictures.blob.core.windows.net/pictures/lc7xwblowokxx98m25zovdxc3xe3l7az405h34r0.jpg	2017-05-03 12:35:23	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
1a05675f-769b-4722-8bd6-237b29717fd3	https://octotaggerpictures.blob.core.windows.net/pictures/qb2jxxms0yw7hqjoeckhb1alznlhxtgyk8bxbya2.jpg	2017-05-03 12:41:41	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
1bc5f446-0feb-4c1e-ad7f-b16ed25578c5	https://octotaggerpictures.blob.core.windows.net/pictures/rbdxwvzpt9lwrm3zjpckel53nvczoh5vk11te211.jpg	2017-05-03 12:58:17	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
a2991ddf-51a9-45a0-b239-19a617530225	https://octotaggerpictures.blob.core.windows.net/pictures/kc0n4nspyzfwf6zjon7ljeg53ir2qrhz1v8qjneg.jpg	2017-05-03 13:00:10	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
34a19688-7f19-4c86-ab06-170c31e485d9	https://octotaggerpictures.blob.core.windows.net/pictures/4pjgxrssbjxp2sid327qdzif3m9ay6a0pglogq8c.jpg	2017-05-03 13:42:38	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
dadf1f7c-d975-4a62-ae1a-43f0b6fda32a	https://octotaggerpictures.blob.core.windows.net/pictures/5uko2yppmdjfzw2g6rboo5t921wjknx75uqydxc3.jpg	2017-05-03 13:43:45	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
b711ca32-7d81-41b1-bdda-cc3bcaa9cabd	https://octotaggerpictures.blob.core.windows.net/pictures/z0sg30cql1dxc3z394z44ljnnvqy58s9sknr6oj9.jpg	2017-05-03 13:43:46	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
5797b394-04e7-4ba1-a10f-58f8baaada16	https://octotaggerpictures.blob.core.windows.net/pictures/tetztq1muwuu83c987s0itv03qhwryu6x3wh2g93.jpg	2017-05-03 13:45:11	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
69292fee-292f-4a7c-9529-2775f73d8970	https://octotaggerpictures.blob.core.windows.net/pictures/qjwb2q4plta0s8qkcxzzxfthhq6vppde6wapsojw.jpg	2017-05-03 13:45:20	bebbca44-3264-4991-b824-5408b394a42b	\N	\N
\.


--
-- TOC entry 2197 (class 0 OID 17748)
-- Dependencies: 206
-- Data for Name: predictions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY predictions (prediction_id, image_id, category, probability, leftx, topy, rightx, bottomy) FROM stdin;
-1	a509a077-a193-4022-83d5-8ee129355932	person	0.898395000000000055	52	77	747	1068
1	82096e39-2a1a-4a9a-ab1e-ca7002f9f464	dog	0.823984999999999967	132	232	321	521
2	82096e39-2a1a-4a9a-ab1e-ca7002f9f464	truck	0.635908999999999947	467	84	680	167
3	82096e39-2a1a-4a9a-ab1e-ca7002f9f464	bicycle	0.853098000000000023	95	124	588	447
4	bbb383c7-449e-406e-83c3-ec9f81581513	giraffe	0.901657000000000042	165	-6	437	448
5	bbb383c7-449e-406e-83c3-ec9f81581513	zebra	0.802510999999999974	241	207	422	441
6	bbb383c7-449e-406e-83c3-ec9f81581513	giraffe	0.901657000000000042	165	-6	437	448
7	bbb383c7-449e-406e-83c3-ec9f81581513	zebra	0.802510999999999974	241	207	422	441
8	c7863808-e5c2-416a-b34a-584a7fe510dd	horse	0.843090000000000006	-5	194	170	336
9	c7863808-e5c2-416a-b34a-584a7fe510dd	horse	0.475281999999999982	256	207	420	367
10	c7863808-e5c2-416a-b34a-584a7fe510dd	horse	0.619163000000000019	433	211	601	349
11	c7863808-e5c2-416a-b34a-584a7fe510dd	horse	0.908745000000000025	12	193	300	416
12	1a05675f-769b-4722-8bd6-237b29717fd3	bird	0.932182999999999984	143	81	623	448
13	a2991ddf-51a9-45a0-b239-19a617530225	bird	0.932182999999999984	143	81	623	448
14	34a19688-7f19-4c86-ab06-170c31e485d9	bird	0.932182999999999984	143	81	623	448
15	dadf1f7c-d975-4a62-ae1a-43f0b6fda32a	bird	0.932182999999999984	143	81	623	448
16	b711ca32-7d81-41b1-bdda-cc3bcaa9cabd	bird	0.932182999999999984	143	81	623	448
17	5797b394-04e7-4ba1-a10f-58f8baaada16	person	0.302819000000000005	133	236	218	437
18	69292fee-292f-4a7c-9529-2775f73d8970	dog	0.823984999999999967	132	232	321	521
19	69292fee-292f-4a7c-9529-2775f73d8970	truck	0.635908999999999947	467	84	680	167
20	69292fee-292f-4a7c-9529-2775f73d8970	bicycle	0.853098000000000023	95	124	588	447
\.


--
-- TOC entry 2203 (class 0 OID 0)
-- Dependencies: 205
-- Name: predictions_prediction_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('predictions_prediction_id_seq', 20, true);


--
-- TOC entry 2074 (class 2606 OID 17745)
-- Name: images images_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY images
    ADD CONSTRAINT images_pkey PRIMARY KEY (image_id);


--
-- TOC entry 2076 (class 2606 OID 17756)
-- Name: predictions predictions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY predictions
    ADD CONSTRAINT predictions_pkey PRIMARY KEY (prediction_id);


--
-- TOC entry 2077 (class 2606 OID 17757)
-- Name: predictions predictions_image_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY predictions
    ADD CONSTRAINT predictions_image_id_fkey FOREIGN KEY (image_id) REFERENCES images(image_id);


-- Completed on 2017-05-03 13:50:35 CEST

--
-- PostgreSQL database dump complete
--