-
Notifications
You must be signed in to change notification settings - Fork 0
/
db.sql
1518 lines (1159 loc) · 256 KB
/
db.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
--
-- PostgreSQL database dump
--
-- Dumped from database version 11.2 (Debian 11.2-1.pgdg90+1)
-- Dumped by pg_dump version 11.5
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
--
-- Name: file_id_pseudo_encrypt(bigint); Type: FUNCTION; Schema: public; Owner: duouser
--
CREATE FUNCTION public.file_id_pseudo_encrypt(value bigint) RETURNS bigint
LANGUAGE plpgsql IMMUTABLE STRICT
AS $$
DECLARE
l1 bigint;
l2 bigint;
r1 bigint;
r2 bigint;
i int:=0;
BEGIN
l1:= (VALUE >> 32) & 4294967295::bigint;
r1:= VALUE & 4294967295;
WHILE i < 3 LOOP
l2 := r1;
r2 := l1 # ((((1366.0 * r1 + 150889) % 714025) / 714025.0) * 32767*32767)::int;
l1 := l2;
r1 := r2;
i := i + 1;
END LOOP;
RETURN ((l1::bigint << 32) + r1);
END;
$$;
ALTER FUNCTION public.file_id_pseudo_encrypt(value bigint) OWNER TO duouser;
--
-- Name: trigger_set_timestamp(); Type: FUNCTION; Schema: public; Owner: duouser
--
CREATE FUNCTION public.trigger_set_timestamp() RETURNS trigger
LANGUAGE plpgsql
AS $$
BEGIN
NEW.updated_at = NOW();
RETURN NEW;
END;
$$;
ALTER FUNCTION public.trigger_set_timestamp() OWNER TO duouser;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: call; Type: TABLE; Schema: public; Owner: duouser
--
CREATE TABLE public.call (
call_id integer NOT NULL,
call_short_code character varying(20) NOT NULL,
start_call date NOT NULL,
end_call date NOT NULL,
start_review date NOT NULL,
end_review date NOT NULL,
start_notify date NOT NULL,
end_notify date NOT NULL,
cycle_comment character varying(100) NOT NULL,
survey_comment character varying(100) NOT NULL
);
ALTER TABLE public.call OWNER TO duouser;
--
-- Name: call_call_id_seq; Type: SEQUENCE; Schema: public; Owner: duouser
--
CREATE SEQUENCE public.call_call_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.call_call_id_seq OWNER TO duouser;
--
-- Name: call_call_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: duouser
--
ALTER SEQUENCE public.call_call_id_seq OWNED BY public.call.call_id;
--
-- Name: files_file_id_seq; Type: SEQUENCE; Schema: public; Owner: duouser
--
CREATE SEQUENCE public.files_file_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.files_file_id_seq OWNER TO duouser;
--
-- Name: files; Type: TABLE; Schema: public; Owner: duouser
--
CREATE TABLE public.files (
file_id bigint DEFAULT public.file_id_pseudo_encrypt(nextval('public.files_file_id_seq'::regclass)) NOT NULL,
file_name character varying(512) NOT NULL,
size_in_bytes integer,
mime_type character varying(64),
oid integer,
created_at timestamp with time zone DEFAULT now() NOT NULL
);
ALTER TABLE public.files OWNER TO duouser;
--
-- Name: pagetext; Type: TABLE; Schema: public; Owner: duouser
--
CREATE TABLE public.pagetext (
pagetext_id integer NOT NULL,
content text
);
ALTER TABLE public.pagetext OWNER TO duouser;
--
-- Name: pagetext_pagetext_id_seq; Type: SEQUENCE; Schema: public; Owner: duouser
--
CREATE SEQUENCE public.pagetext_pagetext_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.pagetext_pagetext_id_seq OWNER TO duouser;
--
-- Name: pagetext_pagetext_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: duouser
--
ALTER SEQUENCE public.pagetext_pagetext_id_seq OWNED BY public.pagetext.pagetext_id;
--
-- Name: proposal_answers; Type: TABLE; Schema: public; Owner: duouser
--
CREATE TABLE public.proposal_answers (
answer_id integer NOT NULL,
proposal_id integer NOT NULL,
proposal_question_id character varying(64) NOT NULL,
answer character varying(512),
created_at timestamp with time zone DEFAULT now() NOT NULL
);
ALTER TABLE public.proposal_answers OWNER TO duouser;
--
-- Name: proposal_answers_answer_id_seq; Type: SEQUENCE; Schema: public; Owner: duouser
--
CREATE SEQUENCE public.proposal_answers_answer_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.proposal_answers_answer_id_seq OWNER TO duouser;
--
-- Name: proposal_answers_answer_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: duouser
--
ALTER SEQUENCE public.proposal_answers_answer_id_seq OWNED BY public.proposal_answers.answer_id;
--
-- Name: proposal_answers_files; Type: TABLE; Schema: public; Owner: duouser
--
CREATE TABLE public.proposal_answers_files (
answer_id integer,
file_id bigint
);
ALTER TABLE public.proposal_answers_files OWNER TO duouser;
--
-- Name: proposal_question_datatypes; Type: TABLE; Schema: public; Owner: duouser
--
CREATE TABLE public.proposal_question_datatypes (
proposal_question_datatype_id character varying(64) NOT NULL
);
ALTER TABLE public.proposal_question_datatypes OWNER TO duouser;
--
-- Name: proposal_question_dependencies; Type: TABLE; Schema: public; Owner: duouser
--
CREATE TABLE public.proposal_question_dependencies (
proposal_question_id character varying(64) NOT NULL,
proposal_question_dependency character varying(64) NOT NULL,
condition character varying(64) DEFAULT NULL::character varying
);
ALTER TABLE public.proposal_question_dependencies OWNER TO duouser;
--
-- Name: proposal_questions; Type: TABLE; Schema: public; Owner: duouser
--
CREATE TABLE public.proposal_questions (
proposal_question_id character varying(64) NOT NULL,
data_type character varying(64) NOT NULL,
question character varying(256) NOT NULL,
topic_id integer,
config character varying(512) DEFAULT NULL::character varying,
sort_order integer DEFAULT 0,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL
);
ALTER TABLE public.proposal_questions OWNER TO duouser;
--
-- Name: proposal_topics; Type: TABLE; Schema: public; Owner: duouser
--
CREATE TABLE public.proposal_topics (
topic_id integer NOT NULL,
topic_title character varying(32) NOT NULL,
is_enabled boolean DEFAULT false,
sort_order integer NOT NULL
);
ALTER TABLE public.proposal_topics OWNER TO duouser;
--
-- Name: proposal_topics_sort_order_seq; Type: SEQUENCE; Schema: public; Owner: duouser
--
CREATE SEQUENCE public.proposal_topics_sort_order_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.proposal_topics_sort_order_seq OWNER TO duouser;
--
-- Name: proposal_topics_sort_order_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: duouser
--
ALTER SEQUENCE public.proposal_topics_sort_order_seq OWNED BY public.proposal_topics.sort_order;
--
-- Name: proposal_topics_topic_id_seq; Type: SEQUENCE; Schema: public; Owner: duouser
--
CREATE SEQUENCE public.proposal_topics_topic_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.proposal_topics_topic_id_seq OWNER TO duouser;
--
-- Name: proposal_topics_topic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: duouser
--
ALTER SEQUENCE public.proposal_topics_topic_id_seq OWNED BY public.proposal_topics.topic_id;
--
-- Name: proposal_user; Type: TABLE; Schema: public; Owner: duouser
--
CREATE TABLE public.proposal_user (
proposal_id integer NOT NULL,
user_id integer NOT NULL
);
ALTER TABLE public.proposal_user OWNER TO duouser;
--
-- Name: proposals; Type: TABLE; Schema: public; Owner: duouser
--
CREATE TABLE public.proposals (
proposal_id integer NOT NULL,
title character varying(100),
abstract text,
status integer DEFAULT 0 NOT NULL,
proposer_id integer,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL
);
ALTER TABLE public.proposals OWNER TO duouser;
--
-- Name: proposals_proposal_id_seq; Type: SEQUENCE; Schema: public; Owner: duouser
--
CREATE SEQUENCE public.proposals_proposal_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.proposals_proposal_id_seq OWNER TO duouser;
--
-- Name: proposals_proposal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: duouser
--
ALTER SEQUENCE public.proposals_proposal_id_seq OWNED BY public.proposals.proposal_id;
--
-- Name: reviews; Type: TABLE; Schema: public; Owner: duouser
--
CREATE TABLE public.reviews (
review_id integer NOT NULL,
user_id integer NOT NULL,
proposal_id integer NOT NULL,
comment character varying(500),
grade integer,
status integer,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL
);
ALTER TABLE public.reviews OWNER TO duouser;
--
-- Name: reviews_review_id_seq; Type: SEQUENCE; Schema: public; Owner: duouser
--
CREATE SEQUENCE public.reviews_review_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.reviews_review_id_seq OWNER TO duouser;
--
-- Name: reviews_review_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: duouser
--
ALTER SEQUENCE public.reviews_review_id_seq OWNED BY public.reviews.review_id;
--
-- Name: role_user; Type: TABLE; Schema: public; Owner: duouser
--
CREATE TABLE public.role_user (
role_id integer NOT NULL,
user_id integer NOT NULL
);
ALTER TABLE public.role_user OWNER TO duouser;
--
-- Name: roles; Type: TABLE; Schema: public; Owner: duouser
--
CREATE TABLE public.roles (
role_id integer NOT NULL,
short_code character varying(20) NOT NULL,
title character varying(20) NOT NULL
);
ALTER TABLE public.roles OWNER TO duouser;
--
-- Name: roles_role_id_seq; Type: SEQUENCE; Schema: public; Owner: duouser
--
CREATE SEQUENCE public.roles_role_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.roles_role_id_seq OWNER TO duouser;
--
-- Name: roles_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: duouser
--
ALTER SEQUENCE public.roles_role_id_seq OWNED BY public.roles.role_id;
--
-- Name: users; Type: TABLE; Schema: public; Owner: duouser
--
CREATE TABLE public.users (
user_id integer NOT NULL,
user_title character varying(5) DEFAULT NULL::character varying,
middlename character varying(20) DEFAULT NULL::character varying,
firstname character varying(20) NOT NULL,
lastname character varying(20) NOT NULL,
username character varying(20),
password character varying(100) NOT NULL,
preferredname character varying(20) DEFAULT NULL::character varying,
orcid character varying(100) NOT NULL,
orcidRefreshToken character varying(100) NOT NULL,
gender character varying(12) NOT NULL,
nationality character varying(30) NOT NULL,
birthdate date NOT NULL,
organisation character varying(50) NOT NULL,
department character varying(60) NOT NULL,
organisation_address character varying(100) NOT NULL,
"position" character varying(30) NOT NULL,
email character varying(30),
email_verified boolean DEFAULT false,
telephone character varying(20) NOT NULL,
telephone_alt character varying(20) DEFAULT NULL::character varying,
created_at timestamp with time zone DEFAULT now() NOT NULL,
updated_at timestamp with time zone DEFAULT now() NOT NULL
);
ALTER TABLE public.users OWNER TO duouser;
--
-- Name: users_user_id_seq; Type: SEQUENCE; Schema: public; Owner: duouser
--
CREATE SEQUENCE public.users_user_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.users_user_id_seq OWNER TO duouser;
--
-- Name: users_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: duouser
--
ALTER SEQUENCE public.users_user_id_seq OWNED BY public.users.user_id;
--
-- Name: call call_id; Type: DEFAULT; Schema: public; Owner: duouser
--
ALTER TABLE ONLY public.call ALTER COLUMN call_id SET DEFAULT nextval('public.call_call_id_seq'::regclass);
--
-- Name: pagetext pagetext_id; Type: DEFAULT; Schema: public; Owner: duouser
--
ALTER TABLE ONLY public.pagetext ALTER COLUMN pagetext_id SET DEFAULT nextval('public.pagetext_pagetext_id_seq'::regclass);
--
-- Name: proposal_answers answer_id; Type: DEFAULT; Schema: public; Owner: duouser
--
ALTER TABLE ONLY public.proposal_answers ALTER COLUMN answer_id SET DEFAULT nextval('public.proposal_answers_answer_id_seq'::regclass);
--
-- Name: proposal_topics topic_id; Type: DEFAULT; Schema: public; Owner: duouser
--
ALTER TABLE ONLY public.proposal_topics ALTER COLUMN topic_id SET DEFAULT nextval('public.proposal_topics_topic_id_seq'::regclass);
--
-- Name: proposal_topics sort_order; Type: DEFAULT; Schema: public; Owner: duouser
--
ALTER TABLE ONLY public.proposal_topics ALTER COLUMN sort_order SET DEFAULT nextval('public.proposal_topics_sort_order_seq'::regclass);
--
-- Name: proposals proposal_id; Type: DEFAULT; Schema: public; Owner: duouser
--
ALTER TABLE ONLY public.proposals ALTER COLUMN proposal_id SET DEFAULT nextval('public.proposals_proposal_id_seq'::regclass);
--
-- Name: reviews review_id; Type: DEFAULT; Schema: public; Owner: duouser
--
ALTER TABLE ONLY public.reviews ALTER COLUMN review_id SET DEFAULT nextval('public.reviews_review_id_seq'::regclass);
--
-- Name: roles role_id; Type: DEFAULT; Schema: public; Owner: duouser
--
ALTER TABLE ONLY public.roles ALTER COLUMN role_id SET DEFAULT nextval('public.roles_role_id_seq'::regclass);
--
-- Name: users user_id; Type: DEFAULT; Schema: public; Owner: duouser
--
ALTER TABLE ONLY public.users ALTER COLUMN user_id SET DEFAULT nextval('public.users_user_id_seq'::regclass);
--
-- Name: 18605; Type: BLOB; Schema: -; Owner: duouser
--
SELECT pg_catalog.lo_create('18605');
ALTER LARGE OBJECT 18605 OWNER TO duouser;
--
-- Data for Name: call; Type: TABLE DATA; Schema: public; Owner: duouser
--
COPY public.call (call_id, call_short_code, start_call, end_call, start_review, end_review, start_notify, end_notify, cycle_comment, survey_comment) FROM stdin;
1 call 1 2019-01-01 2023-01-01 2019-01-01 2023-01-01 2019-01-01 2023-01-01 This is cycle comment This is survey comment
\.
--
-- Data for Name: files; Type: TABLE DATA; Schema: public; Owner: duouser
--
COPY public.files (file_id, file_name, size_in_bytes, mime_type, oid, created_at) FROM stdin;
3898573529235304961 Proposal Review.pdf 91658 application/pdf 18605 2019-10-16 12:41:38.939947+00
\.
--
-- Data for Name: pagetext; Type: TABLE DATA; Schema: public; Owner: duouser
--
COPY public.pagetext (pagetext_id, content) FROM stdin;
1 <h1 class="display-4" style="box-sizing: border-box; margin-top: 0px; margin-bottom: 0.5rem; font-family: Titillium, 'Titillium Web', 'Helvetica Neue', sans-serif; font-weight: 300; line-height: 1.2; color: #293035; font-size: 3.5rem; caret-color: #293035; font-style: normal; font-variant-caps: normal; letter-spacing: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration: none;">Welcome</h1>\n<p class="lead" style="box-sizing: border-box; margin-top: 0px; margin-bottom: 1rem; font-size: 1.25rem; font-weight: 300; caret-color: #293035; color: #293035; font-family: Titillium, 'Titillium Web', 'Helvetica Neue', sans-serif; font-style: normal; font-variant-caps: normal; letter-spacing: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration: none;">to the DEMAX user portal for deuteration & crystallization support!</p>\n<hr class="my-4" style="box-sizing: content-box; height: 0px; overflow: visible; margin-top: 1.5rem !important; margin-bottom: 1.5rem !important; border-width: 1px 0px 0px; border-top-style: solid; border-top-color: rgba(0, 0, 0, 0.0980392); caret-color: #293035; color: #293035; font-family: Titillium, 'Titillium Web', 'Helvetica Neue', sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration: none;" />\n<p style="box-sizing: border-box; margin-top: 0px; margin-bottom: 1rem; caret-color: #293035; color: #293035; font-family: Titillium, 'Titillium Web', 'Helvetica Neue', sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration: none;">Users are strongly encouraged to contact DEMAX staff prior to preparing and submitting a deuteration/crystallization proposal.<span class="Apple-converted-space"> </span><br style="box-sizing: border-box;" />General enquiries can be sent to:<span class="Apple-converted-space"> </span><a style="box-sizing: border-box; color: #007bff; text-decoration: none; background-color: transparent; text-decoration-skip: objects;" href="mailto:demax@esss.se">demax@esss.se</a><span class="Apple-converted-space"> </span>or to one of the<a style="box-sizing: border-box; color: #007bff; text-decoration: none; background-color: transparent; text-decoration-skip: objects;" href="https://demax.esss.dk/contact"><span class="Apple-converted-space"> </span>subject matter experts.</a></p>\n<ul style="box-sizing: border-box; margin-top: 0px; margin-bottom: 1rem; caret-color: #293035; color: #293035; font-family: Titillium, 'Titillium Web', 'Helvetica Neue', sans-serif; font-size: 16px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: #ffffff; text-decoration: none;">\n<li style="box-sizing: border-box;">Proposals should be written in English, properly referenced, and prepared in the<span class="Apple-converted-space"> </span><a style="box-sizing: border-box; color: #007bff; text-decoration: none; background-color: transparent; text-decoration-skip: objects;" href="https://demaxapi.esss.dk/api/word/attachment">Word template</a>. Please keep to the 2 page limit, including Summary, Background (Science Case, Practical Consideration, References, Figures/Tables).<span class="Apple-converted-space"> </span></li>\n<li style="box-sizing: border-box;">Access to DEMAX is granted on the basis of both a technical and a peer-review process.</li>\n<li style="box-sizing: border-box;">Proposals awarded during initial operations (2019-2022) will be free of charge. During formal user operations (beyond 2023) we reserve the right to ask for partial financial contributions towards consumables & shipping costs.<span class="Apple-converted-space"> </span></li>\n<li style="box-sizing: border-box;">During initial operations, we will not limit access to DEMAX based on ESS-membership. Beyond this period, we will respect the user access policy that will be applicable ESS-wide.<span class="Apple-converted-space"> </span></li>\n<li style="box-sizing: border-box;">Biological and chemical deuteration proposals are run as a service but users for protein crystallization are welcome to come in person as well.<span class="Apple-converted-space"> </span></li>\n<li class="str" style="box-sizing: border-box;"><em style="box-sizing: border-box;">Users should note that the contributions by DEMAX should be acknowledged in any publications containing materials obtained from us. For particularly challenging projects that require above average involvement from DEMAX, relevant DEMAX staff should be acknowledged through co-authorship of any subsequent publications.</em></li>\n</ul>
2 <h1>Frequently asked questions</h1>\n<h5 style="box-sizing: border-box; margin-top: 0px; margin-bottom: 0.5rem; font-family: inherit; font-weight: 500; line-height: 1.2; color: inherit; font-size: 1.25rem;">I try to generate a PDF but get an error message, what am I doing wrong?<span class="Apple-converted-space"> </span></h5>\n<p style="box-sizing: border-box; margin-top: 0px; margin-bottom: 1rem;">Depending on what types of deuteration you chose and how you answered the form, a different number of attachments are required to upload before you can generate a PDF.<span class="Apple-converted-space"> </span></p>\n<h5 style="box-sizing: border-box; margin-top: 0px; margin-bottom: 0.5rem; font-family: inherit; font-weight: 500; line-height: 1.2; color: inherit; font-size: 1.25rem;">I try to submit the proposal it doesn't seem to work?<span class="Apple-converted-space"> </span></h5>\n<p style="box-sizing: border-box; margin-top: 0px; margin-bottom: 0px;">Make sure that all required attachments have been uploaded and that all required questions in the form have been answered.</p>\n<p style="box-sizing: border-box; margin-top: 0px; margin-bottom: 0px;"> </p>\n<p style="box-sizing: border-box; margin-top: 0px; margin-bottom: 0px;"><span class="Apple-converted-space"> <br /></span></p>
\.
--
-- Data for Name: proposal_answers; Type: TABLE DATA; Schema: public; Owner: duouser
--
COPY public.proposal_answers (answer_id, proposal_id, proposal_question_id, answer, created_at) FROM stdin;
15 1 biosafety_is_recombinant {"value":""} 2019-10-16 11:14:06.341512+00
12 1 slide_select_deuteration {"value":true} 2019-10-16 11:14:06.341407+00
9 1 is_biomass {"value":""} 2019-10-16 11:14:06.339558+00
6 1 recombinant_protein {"value":""} 2019-10-16 11:14:06.337591+00
17 1 biosafety_has_hazard_ligand {"value":""} 2019-10-16 11:14:06.343632+00
41 1 chem_deu_structure_justification {"value":""} 2019-10-16 12:59:40.350906+00
44 1 chem_deu_chem_structure {"value":""} 2019-10-16 12:59:40.364055+00
42 1 chem_deu_prep_source {"value":"no"} 2019-10-16 12:59:40.351668+00
1 1 has_links_with_industry {"value":"no"} 2019-10-16 11:14:01.603382+00
40 1 links_with_industry {"value":""} 2019-10-16 12:43:07.002082+00
2 1 is_student_proposal {"value":"no"} 2019-10-16 11:14:01.60408+00
3 1 is_towards_degree {"value":"no"} 2019-10-16 11:14:01.604748+00
4 1 final_delivery_date {"value":"2019-10-28T12:17:00.000Z"} 2019-10-16 11:14:01.605076+00
5 1 final_delivery_date_motivation {"value":""} 2019-10-16 11:14:01.606028+00
35 1 has_crystallization {"value":true} 2019-10-16 12:41:41.406147+00
30 1 crystallization_molecule_name {"value":""} 2019-10-16 12:41:41.400172+00
22 1 amino_seq {"value":""} 2019-10-16 12:41:41.371186+00
21 1 doi_or_alike {"value":""} 2019-10-16 12:41:41.366688+00
20 1 reference_file {"value":"3898573529235304961"} 2019-10-16 12:41:41.365934+00
25 1 crystallization_cofactors_ligands {"value":""} 2019-10-16 12:41:41.395783+00
18 1 biosafety_is_organism_active {"value":""} 2019-10-16 11:14:06.344698+00
19 1 biosafety_explanation {"value":""} 2019-10-16 11:14:06.344897+00
8 1 yeast_derived_lipid_amnt {"value":""} 2019-10-16 11:14:06.339323+00
7 1 bio_deu_other {"value":""} 2019-10-16 11:14:06.33909+00
10 1 biosafety_containment_level {"value":""} 2019-10-16 11:14:06.33991+00
11 1 biosafety_has_risks {"value":""} 2019-10-16 11:14:06.341158+00
14 1 biosafety_is_toxin {"value":""} 2019-10-16 11:14:06.341984+00
13 1 biosafety_is_virulence {"value":""} 2019-10-16 11:14:06.341627+00
16 1 biosafety_is_prion {"value":""} 2019-10-16 11:14:06.343235+00
29 1 prec_composition {"value":""} 2019-10-16 12:41:41.397807+00
26 1 crystallization_experience {"value":""} 2019-10-16 12:41:41.3979+00
27 1 crystallization_time {"value":""} 2019-10-16 12:41:41.398828+00
31 1 crystal_size {"value":""} 2019-10-16 12:41:41.400714+00
28 1 typical_yield {"value":""} 2019-10-16 12:41:41.399579+00
38 1 storage_conditions {"value":""} 2019-10-16 12:41:41.418994+00
34 1 stability {"value":""} 2019-10-16 12:41:41.40535+00
32 1 protein_buffer {"value":""} 2019-10-16 12:41:41.400892+00
33 1 is_deuterated {"value":""} 2019-10-16 12:41:41.402559+00
36 1 molecular_weight {"value":""} 2019-10-16 12:41:41.407558+00
24 1 oligomerization_state {"value":""} 2019-10-16 12:41:41.371799+00
23 1 pdb_id {"value":""} 2019-10-16 12:41:41.366898+00
37 1 protein_concentration {"value":""} 2019-10-16 12:41:41.417491+00
39 1 chem_deu_enabled {"value":true} 2019-10-16 12:41:43.62617+00
47 1 chem_deu_molecule_name {"value":"Many"} 2019-10-16 12:59:40.38017+00
45 1 chem_deu_amount {"value":""} 2019-10-16 12:59:40.378941+00
46 1 chem_deu_amount_justification {"value":""} 2019-10-16 12:59:40.37953+00
43 1 chem_deu_d_percentage {"value":""} 2019-10-16 12:59:40.356605+00
48 4 has_links_with_industry {"value":"yes"} 2019-10-17 15:02:13.063225+00
49 4 links_with_industry {"value":"I have a friend who works in a company"} 2019-10-17 15:02:13.064523+00
50 4 is_student_proposal {"value":"no"} 2019-10-17 15:02:13.065336+00
51 4 is_towards_degree {"value":"no"} 2019-10-17 15:02:13.06616+00
52 4 final_delivery_date {"value":"2019-10-18T15:05:00.000Z"} 2019-10-17 15:02:13.067412+00
53 4 final_delivery_date_motivation {"value":"Because even tomorrow is not soon enough."} 2019-10-17 15:02:13.068185+00
54 4 biosafety_is_recombinant {"value":"yes"} 2019-10-17 15:04:02.946803+00
55 4 slide_select_deuteration {"value":true} 2019-10-17 15:04:02.948349+00
56 4 is_biomass {"value":""} 2019-10-17 15:04:02.949235+00
57 4 recombinant_protein {"value":true} 2019-10-17 15:04:02.950129+00
58 4 molecule_name_for_deuteration {"value":"Aspartate decarboxylase"} 2019-10-17 15:04:02.950956+00
59 4 bio_deu_fasta {"value":"1234"} 2019-10-17 15:04:02.951803+00
60 4 bio_deu_molecular_weight {"value":"1000000000"} 2019-10-17 15:04:02.952675+00
61 4 bio_deu_oligomerization_state {"value":"tetramer"} 2019-10-17 15:04:02.953467+00
62 4 bio_deu_cofactors_ligands {"value":"no"} 2019-10-17 15:04:02.954241+00
63 4 bio_deu_origin {"value":"E. Coli"} 2019-10-17 15:04:02.955028+00
64 4 biosafety_has_hazard_ligand {"value":"no"} 2019-10-17 15:04:02.955779+00
65 4 biosafety_is_organism_active {"value":""} 2019-10-17 15:04:02.95657+00
66 4 biosafety_explanation {"value":""} 2019-10-17 15:04:02.957321+00
67 4 bio_deu_plasmid_provided {"value":"no"} 2019-10-17 15:04:02.958109+00
68 4 bio_deu_material_amount {"value":"1 metric ton"} 2019-10-17 15:04:02.958882+00
69 4 bio_deu_material_amount_justification {"value":"I like this protein very much"} 2019-10-17 15:04:02.960152+00
70 4 bio_deu_d_lvl_req {"value":"Partial (65-80% with unlabeled carbon source)"} 2019-10-17 15:04:02.96092+00
71 4 bio_deu_d_lvl_req_justification {"value":""} 2019-10-17 15:04:02.961672+00
72 4 bio_deu_purification_need {"value":"yes"} 2019-10-17 15:04:02.962435+00
73 4 bio_deu_has_expressed {"value":"yes"} 2019-10-17 15:04:02.96317+00
74 4 bio_deu_typical_yield {"value":"1mg per L"} 2019-10-17 15:04:02.963992+00
75 4 bio_deu_purification_done {"value":"no"} 2019-10-17 15:04:02.964739+00
76 4 bio_deu_has_deuteration_experience {"value":"no"} 2019-10-17 15:04:02.965492+00
77 4 yeast_derived_lipid_amnt {"value":""} 2019-10-17 15:04:02.966245+00
78 4 bio_deu_other {"value":""} 2019-10-17 15:04:02.967258+00
79 4 biosafety_containment_level {"value":"L1"} 2019-10-17 15:04:02.967964+00
80 4 biosafety_has_risks {"value":"no"} 2019-10-17 15:04:02.968629+00
81 4 biosafety_is_toxin {"value":"no"} 2019-10-17 15:04:02.969276+00
82 4 biosafety_is_virulence {"value":"no"} 2019-10-17 15:04:02.969947+00
83 4 biosafety_is_prion {"value":"no"} 2019-10-17 15:04:02.970596+00
84 4 has_crystallization {"value":true} 2019-10-17 15:05:25.206039+00
85 4 crystallization_molecule_name {"value":"Aspartate decarboxylase"} 2019-10-17 15:05:25.207331+00
86 4 amino_seq {"value":"1234"} 2019-10-17 15:05:25.208154+00
87 4 molecular_weight {"value":"1000000"} 2019-10-17 15:05:25.208916+00
88 4 oligomerization_state {"value":"tetramer"} 2019-10-17 15:05:25.209718+00
89 4 pdb_id {"value":"1AW8"} 2019-10-17 15:05:25.210454+00
90 4 doi_or_alike {"value":"sdkjbdakl;"} 2019-10-17 15:05:25.211272+00
91 4 reference_file {"value":""} 2019-10-17 15:05:25.211952+00
92 4 crystallization_cofactors_ligands {"value":"No"} 2019-10-17 15:05:25.212654+00
93 4 prec_composition {"value":"Ammonium sulphate and water"} 2019-10-17 15:05:25.213339+00
94 4 crystallization_experience {"value":"Vapour diffusion, 2uL drops, 20C"} 2019-10-17 15:05:25.214014+00
95 4 crystallization_time {"value":"1 week"} 2019-10-17 15:05:25.214749+00
96 4 crystal_size {"value":"200x200x200"} 2019-10-17 15:05:25.215431+00
97 4 typical_yield {"value":""} 2019-10-17 15:05:25.216119+00
98 4 storage_conditions {"value":""} 2019-10-17 15:05:25.216751+00
99 4 stability {"value":""} 2019-10-17 15:05:25.217417+00
100 4 protein_buffer {"value":""} 2019-10-17 15:05:25.218105+00
101 4 is_deuterated {"value":""} 2019-10-17 15:05:25.218765+00
102 4 protein_concentration {"value":""} 2019-10-17 15:05:25.219549+00
103 4 chem_deu_enabled {"value":true} 2019-10-17 15:05:59.960073+00
104 4 chem_deu_molecule_name {"value":"sugar"} 2019-10-17 15:05:59.961698+00
105 4 chem_deu_amount {"value":"1 metric ton"} 2019-10-17 15:05:59.96313+00
106 4 chem_deu_amount_justification {"value":"I like sugar"} 2019-10-17 15:05:59.963939+00
107 4 chem_deu_d_percentage {"value":"100% all over"} 2019-10-17 15:05:59.965074+00
108 4 chem_deu_structure_justification {"value":"I like to present a challenge"} 2019-10-17 15:05:59.965833+00
109 4 chem_deu_chem_structure {"value":""} 2019-10-17 15:05:59.96722+00
110 4 chem_deu_prep_source {"value":"no"} 2019-10-17 15:05:59.969522+00
111 4 text_input_1571323436286 {"value":"asdf"} 2019-10-17 15:06:31.970928+00
112 4 text_input_1571323780736 {"value":"dfasd"} 2019-10-17 15:06:31.972298+00
113 4 text_input_1571324064504 {"value":"asdf"} 2019-10-17 15:06:31.973227+00
114 4 file_upload_1571323955969 {"value":""} 2019-10-17 15:06:31.976611+00
124 5 will_provide_organism {"value":false} 2019-10-18 08:03:36.846023+00
125 5 material_amount {"value":""} 2019-10-18 08:03:36.846766+00
126 5 material_condition {"value":""} 2019-10-18 08:03:36.847485+00
127 5 amount_justification {"value":""} 2019-10-18 08:03:36.849374+00
128 5 rq_deuteration_level {"value":""} 2019-10-18 08:03:36.852239+00
129 5 d_level_justification {"value":""} 2019-10-18 08:03:36.855407+00
122 5 slide_select_deuteration {"value":true} 2019-10-18 08:03:36.843518+00
123 5 is_biomass {"value":false} 2019-10-18 08:03:36.844879+00
130 5 recombinant_protein {"value":true} 2019-10-18 08:03:36.856092+00
160 5 molecule_name_for_deuteration {"value":""} 2019-10-18 08:04:56.075919+00
132 5 biosafety_is_organism_active {"value":""} 2019-10-18 08:03:36.857461+00
133 5 biosafety_explanation {"value":""} 2019-10-18 08:03:36.858133+00
134 5 yeast_derived_lipid_amnt {"value":false} 2019-10-18 08:03:36.858804+00
135 5 bio_deu_other {"value":""} 2019-10-18 08:03:36.859455+00
136 5 biosafety_containment_level {"value":"L1"} 2019-10-18 08:03:36.860309+00
137 5 biosafety_has_risks {"value":"no"} 2019-10-18 08:03:36.861004+00
138 5 biosafety_is_toxin {"value":"no"} 2019-10-18 08:03:36.861641+00
139 5 biosafety_is_virulence {"value":"no"} 2019-10-18 08:03:36.862285+00
140 5 biosafety_is_prion {"value":"no"} 2019-10-18 08:03:36.862918+00
141 5 has_crystallization {"value":true} 2019-10-18 08:04:35.105687+00
144 5 molecular_weight {"value":""} 2019-10-18 08:04:35.111621+00
145 5 oligomerization_state {"value":""} 2019-10-18 08:04:35.112339+00
146 5 pdb_id {"value":""} 2019-10-18 08:04:35.113061+00
147 5 doi_or_alike {"value":""} 2019-10-18 08:04:35.113777+00
148 5 reference_file {"value":""} 2019-10-18 08:04:35.114453+00
149 5 crystallization_cofactors_ligands {"value":""} 2019-10-18 08:04:35.115119+00
150 5 prec_composition {"value":""} 2019-10-18 08:04:35.115728+00
151 5 crystallization_experience {"value":""} 2019-10-18 08:04:35.116366+00
152 5 crystallization_time {"value":""} 2019-10-18 08:04:35.119152+00
153 5 crystal_size {"value":""} 2019-10-18 08:04:35.121194+00
154 5 typical_yield {"value":""} 2019-10-18 08:04:35.12192+00
155 5 storage_conditions {"value":""} 2019-10-18 08:04:35.122601+00
156 5 stability {"value":""} 2019-10-18 08:04:35.126558+00
157 5 protein_buffer {"value":""} 2019-10-18 08:04:35.127368+00
158 5 is_deuterated {"value":""} 2019-10-18 08:04:35.128569+00
159 5 protein_concentration {"value":""} 2019-10-18 08:04:35.129284+00
117 5 is_student_proposal {"value":"no"} 2019-10-18 07:58:01.195012+00
118 5 is_towards_degree {"value":"no"} 2019-10-18 07:58:01.196351+00
143 5 amino_seq {"value":""} 2019-10-18 08:04:35.110784+00
120 5 final_delivery_date_motivation {"value":"I NEED this material."} 2019-10-18 07:58:01.198407+00
115 5 has_links_with_industry {"value":"no"} 2019-10-18 07:58:01.192019+00
116 5 links_with_industry {"value":""} 2019-10-18 07:58:01.193989+00
121 5 biosafety_is_recombinant {"value":""} 2019-10-18 08:03:36.842141+00
131 5 biosafety_has_hazard_ligand {"value":"no"} 2019-10-18 08:03:36.85675+00
205 7 links_with_industry {"value":"zdkfjb"} 2019-10-18 08:47:27.808013+00
206 7 is_student_proposal {"value":"no"} 2019-10-18 08:47:27.808669+00
207 7 is_towards_degree {"value":"no"} 2019-10-18 08:47:27.809376+00
208 7 final_delivery_date {"value":"2019-10-22T08:51:00.000Z"} 2019-10-18 08:47:27.809992+00
209 7 final_delivery_date_motivation {"value":"a.sdjf.skjd"} 2019-10-18 08:47:27.811081+00
226 8 final_delivery_date {"value":"2019-10-22T09:23:00.000Z"} 2019-10-18 09:19:36.331985+00
119 5 final_delivery_date {"value":"2020-01-10T09:01:00.000Z"} 2019-10-18 07:58:01.19736+00
161 5 bio_deu_fasta {"value":""} 2019-10-18 08:04:56.077249+00
162 5 bio_deu_molecular_weight {"value":""} 2019-10-18 08:04:56.078377+00
163 5 bio_deu_oligomerization_state {"value":""} 2019-10-18 08:04:56.079091+00
164 5 bio_deu_cofactors_ligands {"value":""} 2019-10-18 08:04:56.079762+00
165 5 bio_deu_origin {"value":""} 2019-10-18 08:04:56.081054+00
166 5 bio_deu_plasmid_provided {"value":"yes"} 2019-10-18 08:04:56.088163+00
167 5 bio_deu_material_amount {"value":""} 2019-10-18 08:04:56.088882+00
168 5 bio_deu_material_amount_justification {"value":""} 2019-10-18 08:04:56.089587+00
169 5 bio_deu_d_lvl_req {"value":"Partial (65-80% with unlabeled carbon source)"} 2019-10-18 08:04:56.090251+00
170 5 bio_deu_d_lvl_req_justification {"value":""} 2019-10-18 08:04:56.091723+00
171 5 bio_deu_purification_need {"value":"no"} 2019-10-18 08:04:56.092487+00
172 5 bio_deu_has_expressed {"value":"yes"} 2019-10-18 08:04:56.09319+00
173 5 bio_deu_typical_yield {"value":"10"} 2019-10-18 08:04:56.093843+00
174 5 bio_deu_purification_done {"value":"yes"} 2019-10-18 08:04:56.094514+00
175 5 bio_deu_has_deuteration_experience {"value":"yes"} 2019-10-18 08:04:56.095166+00
142 5 crystallization_molecule_name {"value":""} 2019-10-18 08:04:35.10884+00
176 5 chem_deu_enabled {"value":true} 2019-10-18 08:06:35.691557+00
177 5 chem_deu_molecule_name {"value":""} 2019-10-18 08:06:35.693301+00
178 5 chem_deu_amount {"value":""} 2019-10-18 08:06:35.694036+00
179 5 chem_deu_amount_justification {"value":""} 2019-10-18 08:06:35.694691+00
180 5 chem_deu_d_percentage {"value":""} 2019-10-18 08:06:35.695377+00
181 5 chem_deu_structure_justification {"value":""} 2019-10-18 08:06:35.69605+00
182 5 chem_deu_chem_structure {"value":""} 2019-10-18 08:06:35.696715+00
183 5 chem_deu_prep_source {"value":""} 2019-10-18 08:06:35.697392+00
184 6 has_links_with_industry {"value":"no"} 2019-10-18 08:13:49.440126+00
185 6 links_with_industry {"value":""} 2019-10-18 08:13:49.441513+00
186 6 is_student_proposal {"value":"no"} 2019-10-18 08:13:49.442415+00
187 6 is_towards_degree {"value":"no"} 2019-10-18 08:13:49.443302+00
188 6 final_delivery_date {"value":"2019-10-18T08:17:00.000Z"} 2019-10-18 08:13:49.444896+00
189 6 final_delivery_date_motivation {"value":"hwywhyryhh"} 2019-10-18 08:13:49.445736+00
190 6 slide_select_deuteration {"value":""} 2019-10-18 08:13:52.114362+00
191 6 has_crystallization {"value":""} 2019-10-18 08:13:52.803908+00
192 6 chem_deu_enabled {"value":true} 2019-10-18 08:14:02.10555+00
193 6 chem_deu_molecule_name {"value":""} 2019-10-18 08:14:02.106496+00
194 6 chem_deu_amount {"value":""} 2019-10-18 08:14:02.110287+00
195 6 chem_deu_amount_justification {"value":""} 2019-10-18 08:14:02.111084+00
196 6 chem_deu_d_percentage {"value":""} 2019-10-18 08:14:02.127891+00
197 6 chem_deu_structure_justification {"value":""} 2019-10-18 08:14:02.137898+00
198 6 chem_deu_chem_structure {"value":""} 2019-10-18 08:14:02.139021+00
199 6 chem_deu_prep_source {"value":""} 2019-10-18 08:14:02.139822+00
200 5 text_input_1571323436286 {"value":"not feeling it"} 2019-10-18 08:17:26.010611+00
201 5 text_input_1571323780736 {"value":"blah"} 2019-10-18 08:17:26.011953+00
202 5 text_input_1571324064504 {"value":"blah"} 2019-10-18 08:17:26.01277+00
203 5 file_upload_1571323955969 {"value":""} 2019-10-18 08:17:26.014366+00
227 8 final_delivery_date_motivation {"value":"I need it badly"} 2019-10-18 09:19:36.332756+00
228 8 slide_select_deuteration {"value":false} 2019-10-18 09:25:20.749204+00
229 8 yeast_derived_d_lvl_req {"value":"Partial (65-80% with unlabeled carbon source)"} 2019-10-18 09:25:20.755142+00
222 8 has_links_with_industry {"value":"no"} 2019-10-18 09:19:36.328407+00
223 8 links_with_industry {"value":""} 2019-10-18 09:19:36.329561+00
224 8 is_student_proposal {"value":"no"} 2019-10-18 09:19:36.330385+00
210 7 slide_select_deuteration {"value":""} 2019-10-18 08:58:35.918755+00
211 7 is_biomass {"value":false} 2019-10-18 08:58:35.921387+00
212 7 recombinant_protein {"value":false} 2019-10-18 08:58:35.922234+00
213 7 yeast_derived_lipid_amnt {"value":false} 2019-10-18 08:58:35.922989+00
214 7 yeast_derived_d_lvl_req {"value":""} 2019-10-18 08:58:35.923823+00
215 7 biosafety_containment_level {"value":"L2"} 2019-10-18 08:58:35.924603+00
216 7 biosafety_has_risks {"value":"no"} 2019-10-18 08:58:35.926895+00
217 7 biosafety_is_organism_active {"value":"as.dkjfh"} 2019-10-18 08:58:35.928415+00
218 7 biosafety_is_toxin {"value":"no"} 2019-10-18 08:58:35.929198+00
219 7 biosafety_is_virulence {"value":"no"} 2019-10-18 08:58:35.93526+00
220 7 biosafety_is_prion {"value":"no"} 2019-10-18 08:58:35.937638+00
221 7 text_input_1571388053776 {"value":"as.djfh"} 2019-10-18 08:58:35.938498+00
204 7 has_links_with_industry {"value":"no"} 2019-10-18 08:47:27.807017+00
230 8 has_crystallization {"value":false} 2019-10-18 09:38:55.006114+00
225 8 is_towards_degree {"value":"no"} 2019-10-18 09:19:36.331286+00
231 8 chem_deu_enabled {"value":true} 2019-10-18 09:39:07.892446+00
232 8 chem_deu_molecule_name {"value":"werf"} 2019-10-18 09:39:07.894052+00
235 8 chem_deu_amount {"value":"asdf"} 2019-10-18 09:39:07.896433+00
237 8 chem_deu_amount_justification {"value":"asdfsadfasdf"} 2019-10-18 09:39:07.897918+00
238 8 chem_deu_d_percentage {"value":"asdfasdfasdf"} 2019-10-18 09:39:07.898602+00
239 8 chem_deu_structure_justification {"value":"asdfasdfd"} 2019-10-18 09:39:07.899288+00
236 8 chem_deu_chem_structure {"value":""} 2019-10-18 09:39:07.897205+00
233 8 chem_deu_prep_source {"value":"no"} 2019-10-18 09:39:07.894837+00
234 8 chem_deu_protocol {"value":""} 2019-10-18 09:39:07.89564+00
\.
--
-- Data for Name: proposal_answers_files; Type: TABLE DATA; Schema: public; Owner: duouser
--
COPY public.proposal_answers_files (answer_id, file_id) FROM stdin;
\.
--
-- Data for Name: proposal_question_datatypes; Type: TABLE DATA; Schema: public; Owner: duouser
--
COPY public.proposal_question_datatypes (proposal_question_datatype_id) FROM stdin;
TEXT_INPUT
SELECTION_FROM_OPTIONS
BOOLEAN
DATE
FILE_UPLOAD
EMBELLISHMENT
\.
--
-- Data for Name: proposal_question_dependencies; Type: TABLE DATA; Schema: public; Owner: duouser
--
COPY public.proposal_question_dependencies (proposal_question_id, proposal_question_dependency, condition) FROM stdin;
organism_name is_biomass {"condition":"eq","params":true}
will_provide_organism is_biomass {"condition":"eq","params":true}
material_amount is_biomass {"condition":"eq","params":true}
amount_justification is_biomass {"condition":"eq","params":true}
rq_deuteration_level is_biomass {"condition":"eq","params":true}
d_level_justification is_biomass {"condition":"eq","params":true}
reference_pdf is_biomass {"condition":"eq","params":true}
molecule_name_for_deuteration recombinant_protein {"condition":"eq","params":true}
bio_deu_fasta recombinant_protein {"condition":"eq","params":true}
bio_deu_molecular_weight recombinant_protein {"condition":"eq","params":true}
bio_deu_oligomerization_state recombinant_protein {"condition":"eq","params":true}
bio_deu_cofactors_ligands recombinant_protein {"condition":"eq","params":true}
bio_deu_origin recombinant_protein {"condition":"eq","params":true}
bio_deu_material_amount recombinant_protein {"condition":"eq","params":true}
bio_deu_material_amount_justification recombinant_protein {"condition":"eq","params":true}
bio_deu_d_lvl_req recombinant_protein {"condition":"eq","params":true}
bio_deu_d_lvl_req_justification recombinant_protein {"condition":"eq","params":true}
yeast_derived_d_lvl_req_justification yeast_derived_lipid_amnt {"condition":"eq","params":true}
bio_deu_has_expressed recombinant_protein {"condition":"eq","params":true}
crystallization_experience has_crystallization {"condition":"eq","params":true}
crystallization_time has_crystallization {"condition":"eq","params":true}
crystal_size has_crystallization {"condition":"eq","params":true}
ttl_biosafety slide_select_deuteration {"condition":"eq","params":true}
biosafety_containment_level slide_select_deuteration {"condition":"eq","params":true}
biosafety_has_risks slide_select_deuteration {"condition":"eq","params":true}
biosafety_is_organism_active slide_select_deuteration {"condition":"eq","params":true}
biosafety_is_toxin slide_select_deuteration {"condition":"eq","params":true}
biosafety_is_virulence slide_select_deuteration {"condition":"eq","params":true}
biosafety_is_prion slide_select_deuteration {"condition":"eq","params":true}
text_input_1571388053776 slide_select_deuteration {"condition":"eq","params":true}
reference_file has_crystallization {"condition":"eq","params":true}
bio_deu_purification_need recombinant_protein {"condition":"eq","params":true}
bio_deu_typical_yield recombinant_protein {"condition":"eq","params":true}
bio_deu_has_deuteration_experience recombinant_protein {"condition":"eq","params":true}
yeast_derived_material_amount yeast_derived_lipid_amnt {"condition":"eq","params":true}
yeast_derived_material_amount_justification yeast_derived_lipid_amnt {"condition":"eq","params":true}
crystallization_molecule_name has_crystallization {"condition":"eq","params":true}
amino_seq has_crystallization {"condition":"eq","params":true}
molecular_weight has_crystallization {"condition":"eq","params":true}
oligomerization_state has_crystallization {"condition":"eq","params":true}
pdb_id has_crystallization {"condition":"eq","params":true}
ttl_details_for_prep has_crystallization {"condition":"eq","params":true}
crystallization_cofactors_ligands has_crystallization {"condition":"eq","params":true}
protein_concentration has_crystallization {"condition":"eq","params":true}
is_deuterated has_crystallization {"condition":"eq","params":true}
stability has_crystallization {"condition":"eq","params":true}
prec_composition has_crystallization {"condition":"eq","params":true}
ttl_select_deuteration_type slide_select_deuteration {"condition":"eq","params":true}
is_biomass slide_select_deuteration {"condition":"eq","params":true}
recombinant_protein slide_select_deuteration {"condition":"eq","params":true}
yeast_derived_lipid_amnt slide_select_deuteration {"condition":"eq","params":true}
\.
--
-- Data for Name: proposal_questions; Type: TABLE DATA; Schema: public; Owner: duouser
--
COPY public.proposal_questions (proposal_question_id, data_type, question, topic_id, config, sort_order, created_at, updated_at) FROM stdin;
ttl_general EMBELLISHMENT 1 {"html":"<h2>Indicators</h2>", "plain": "Indicators"} 1 2019-10-16 11:04:58.041626+00 2019-10-16 12:42:39.877996+00
has_links_with_industry SELECTION_FROM_OPTIONS Links with industry? 1 {"required":true, "options":["yes", "no"], "variant":"radio"} 2 2019-10-16 11:04:58.041626+00 2019-10-16 12:42:39.884753+00
links_with_industry TEXT_INPUT If yes, please describe: 1 {"placeholder":"Please specify links with industry"} 3 2019-10-16 11:04:58.041626+00 2019-10-16 12:42:39.889582+00
is_towards_degree SELECTION_FROM_OPTIONS Does the proposal work towards a students degree? 1 {"required":true, "options":["yes", "no"], "variant":"radio"} 5 2019-10-16 11:04:58.041626+00 2019-10-16 12:42:39.900291+00
ttl_delivery_date EMBELLISHMENT 1 {"html":"<h2>Final delivery date</h2>", "plain": "Final delivery date"} 6 2019-10-16 11:04:58.041626+00 2019-10-16 12:42:39.912067+00
reference_file FILE_UPLOAD Please attach a reference or protocol for crystallization conditions, crystal structure(s). 2 {"max_files":3,"file_type":[]} 16 2019-10-16 11:04:58.041626+00 2019-10-18 09:25:44.63783+00
final_delivery_date DATE Choose a date 1 {"min":"now","required":true} 7 2019-10-16 11:04:58.041626+00 2019-10-18 09:24:58.570505+00
crystallization_time TEXT_INPUT How long do your crystals take to appear? 2 {"min":2,"max":200} 14 2019-10-16 11:04:58.041626+00 2019-10-18 09:15:01.013903+00
bio_deu_origin TEXT_INPUT Biological origin of protein: 3 {"placeholder":"(e.g. human, E. coli, S. cerevisiae)"} 18 2019-10-16 11:04:58.041626+00 2019-10-18 08:51:42.991645+00
molecule_name_for_deuteration TEXT_INPUT Name of protein to be deuterated: 3 {"placeholder":"(e.g. superoxide dismutase)"} 13 2019-10-16 11:04:58.041626+00 2019-10-18 08:50:53.861879+00
material_amount TEXT_INPUT How much material do you need (indicate wet or dry mass) 3 {"min":2,"max":200} 8 2019-10-16 11:04:58.041626+00 2019-10-18 08:49:55.7331+00
d_level_justification TEXT_INPUT Justify level of D incorporation 3 {"min":10,"max":500,"multiline":true} 11 2019-10-16 11:04:58.041626+00 2019-10-18 08:50:28.083785+00
bio_deu_cofactors_ligands TEXT_INPUT Does the protein have any co-factors or ligands required for folding/expression? Specify: 3 {"multiline":true} 17 2019-10-16 11:04:58.041626+00 2019-10-18 08:51:32.27118+00
bio_deu_molecular_weight TEXT_INPUT Molecular weight (kDA) 3 {} 15 2019-10-16 11:04:58.041626+00 2019-10-18 08:51:13.93047+00
crystal_size TEXT_INPUT What is the typical size of your crystal? 2 {"min":2,"max":200,"placeholder":"( µm x µm x µm )"} 15 2019-10-16 11:04:58.041626+00 2019-10-18 09:15:12.701128+00
bio_deu_fasta TEXT_INPUT FASTA sequence or Uniprot number 3 {} 14 2019-10-16 11:04:58.041626+00 2019-10-18 08:51:04.407253+00
has_crystallization BOOLEAN Is crystallization applicable 2 {"variant":"checkbox"} 1 2019-10-16 11:04:58.041626+00 2019-10-18 09:12:23.57651+00
is_biomass BOOLEAN Biomass (E. coli) 3 {"variant":"checkbox"} 3 2019-10-16 11:04:58.041626+00 2019-10-18 09:20:34.963402+00
bio_deu_oligomerization_state TEXT_INPUT Oligomerization state 3 {"placeholder":"(e.g. homodimer, tetramer etc.)"} 16 2019-10-16 11:04:58.041626+00 2019-10-18 08:51:22.841639+00
slide_select_deuteration BOOLEAN Is biological deuteration applicable 3 {"variant":"slider"} 1 2019-10-16 11:04:58.041626+00 2019-10-18 08:45:57.136705+00
final_delivery_date_motivation TEXT_INPUT Please motivate the chosen date 1 {"min":10,"multiline":true,"max":500,"placeholder":"(e.g. based on awarded beamtime, or described intention to apply)","required":true} 8 2019-10-16 11:04:58.041626+00 2019-10-18 09:24:52.077397+00
reference_pdf FILE_UPLOAD Please attach a reference or protocol of culture conditions and media composition 3 {"small_label":"Accepted formats: PDF","file_type":[".pdf"]} 12 2019-10-16 11:04:58.041626+00 2019-10-18 08:50:39.772551+00
will_provide_organism BOOLEAN Will user provide the organism for us to grow under deuterated conditions? 3 {"variant":"radio","options":["yes","no"]} 7 2019-10-16 11:04:58.041626+00 2019-10-18 08:49:10.099758+00
amount_justification TEXT_INPUT Justify the amount requested 3 {"min":10,"max":500,"multiline":true} 9 2019-10-16 11:04:58.041626+00 2019-10-18 08:50:05.89845+00
recombinant_protein BOOLEAN Recombinant protein (E. coli) (user supplies plasmid) 3 {"variant":"slider"} 4 2019-10-16 11:04:58.041626+00 2019-10-18 09:21:04.237596+00
stability TEXT_INPUT Stability and storage conditions (e.g. 2 months at 4 degrees Celsius) 2 {"min":2,"max":200} 11 2019-10-16 11:04:58.041626+00 2019-10-18 09:14:34.776276+00
crystallization_experience TEXT_INPUT What crystallization method, volume, and temperature have you used in the past? 2 {"multiline":true,"min":2,"max":500,"placeholder":"(e.g. vapour diffusion, 10 µL drops, room temperature)"} 13 2019-10-16 11:04:58.041626+00 2019-10-18 09:14:52.376515+00
material_condition TEXT_INPUT Indicate wet or dry mass 8 {"min":2, "max":5} 14 2019-10-16 11:04:58.041626+00 2019-10-18 09:35:47.401278+00
crystallization_molecule_name TEXT_INPUT Name of molecule to be crystallized 2 {"min":2,"max":40,"placeholder":"(e.g. superoxide dismutase)"} 2 2019-10-16 11:04:58.041626+00 2019-10-18 09:13:05.309973+00
storage_conditions TEXT_INPUT Storage conditions: 8 {"min":2, "max":200,"placeholder":"(e.g. stable at 4 °C or frozen at -20 °C)"} 13 2019-10-16 11:04:58.041626+00 2019-10-18 09:35:47.398119+00
protein_concentration TEXT_INPUT What protein concentration do you usually use for crystallization? 2 {"min":2,"max":200} 9 2019-10-16 11:04:58.041626+00 2019-10-18 09:14:15.602469+00
crystallization_cofactors_ligands TEXT_INPUT What is the composition of your protein solution (buffer, pH, co-factors, metals) prior to crystallization? Specify 2 {"min":2,"max":200} 8 2019-10-16 11:04:58.041626+00 2019-10-18 09:14:03.389435+00
oligomerization_state TEXT_INPUT Oligomerization state: 2 {"min":2,"max":200,"placeholder":"(e.g. homodimer, tetramer etc.)"} 5 2019-10-16 11:04:58.041626+00 2019-10-18 09:13:36.251892+00
pdb_id TEXT_INPUT PDB ID of crystal structure 2 {"min":2,"max":200} 6 2019-10-16 11:04:58.041626+00 2019-10-18 09:13:46.373752+00
ttl_details_for_prep EMBELLISHMENT 2 {"html":"<h2>Crystallization Details</h2>","plain":"Crystallization Details"} 7 2019-10-16 11:04:58.041626+00 2019-10-18 09:13:54.983483+00
typical_yield TEXT_INPUT Typical yield: 8 {"min":2, "max":200, "placeholder":"(mg per liter of culture)"} 7 2019-10-16 11:04:58.041626+00 2019-10-18 09:35:47.377707+00
prec_composition TEXT_INPUT Known crystallization precipitant composition: 2 {"min":2,"max":200,"placeholder":"(inc.buffer, salt, additives, pH)"} 12 2019-10-16 11:04:58.041626+00 2019-10-18 09:14:44.49808+00
ttl_crystallization EMBELLISHMENT 8 {"html":"<h2>Crystallization</h2>","plain":"Crystallization"} 10 2019-10-16 11:04:58.041626+00 2019-10-18 09:35:47.388472+00
is_deuterated TEXT_INPUT Is your protein partially or fully deuterated? 2 {"min":2,"max":200} 10 2019-10-16 11:04:58.041626+00 2019-10-18 09:14:25.89322+00
doi_or_alike TEXT_INPUT If the reference is publicly available, please provide the DOI or an accessible link: 8 {"min":2, "max":200} 12 2019-10-16 11:04:58.041626+00 2019-10-18 09:35:47.39518+00
molecular_weight TEXT_INPUT Molecular weight (kDA): 2 {"min":2,"max":200} 4 2019-10-16 11:04:58.041626+00 2019-10-18 09:13:27.054699+00
protein_buffer TEXT_INPUT What buffer is your protein in? 8 {"min":2, "max":200} 9 2019-10-16 11:04:58.041626+00 2019-10-18 09:35:47.384802+00
ttl_select_deuteration_type EMBELLISHMENT 3 {"html":"<h3>Select deuteration type(s)</h3>","plain":"Select deuteration type(s)"} 2 2019-10-16 11:04:58.041626+00 2019-10-18 09:20:09.215065+00
amino_seq TEXT_INPUT FASTA sequence or Uniprot number: 2 {"min":2,"max":200} 3 2019-10-16 11:04:58.041626+00 2019-10-18 09:13:17.069007+00
organism_name TEXT_INPUT What is the organism? 3 {"min":2,"max":200} 6 2019-10-16 11:04:58.041626+00 2019-10-18 08:48:57.453061+00
is_student_proposal SELECTION_FROM_OPTIONS Are any of the co-proposers students? 1 {"required":true, "options":["yes", "no"], "variant":"radio"} 4 2019-10-16 11:04:58.041626+00 2019-10-16 12:42:39.89428+00
biosafety_has_hazard_ligand SELECTION_FROM_OPTIONS Does the sample have a hazardous ligand (e.g. heavy metal, toxic molecule etc.)? If so, what is it? 8 {"variant":"radio","options":["yes","no"]} 2 2019-10-16 11:04:58.041626+00 2019-10-18 09:35:47.343689+00
bio_deu_purification_done SELECTION_FROM_OPTIONS Have you been able to purify the unlabeled protein? 8 {"variant":"radio","options":["yes","no"]} 5 2019-10-16 11:04:58.041626+00 2019-10-18 09:35:47.365846+00
biosafety_is_toxin SELECTION_FROM_OPTIONS Is the sample a toxin? 3 {"variant":"radio","options":["yes","no"],"required":true} 35 2019-10-16 11:04:58.041626+00 2019-10-18 09:23:49.262903+00
biosafety_is_recombinant SELECTION_FROM_OPTIONS Is the protein recombinant? 8 {"variant":"radio", "options":["yes", "no"]} 1 2019-10-16 11:04:58.041626+00 2019-10-18 09:35:47.301631+00
text_input_1571324064504 TEXT_INPUT References 6 {"placeholder":"Please provide supporting references for the Science Case in Nature format.","multiline":true} 5 2019-10-17 14:50:42.732138+00 2019-10-18 09:35:47.360483+00