-
Notifications
You must be signed in to change notification settings - Fork 3
/
dummy_data.sql
149 lines (139 loc) · 53.5 KB
/
dummy_data.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
INSERT INTO contact("contactType", "fullName", "orgName", "orgPosition", "email", "phoneNumber","addressLine1", "addressLine2","city", "province", "country", "postalCode", "dateCreated", "dateModified") VALUES ('clientlead', 'Rob', 'AOT', 'Manager', '[email protected]', '123456789', '325-1207', 'Douglas Street', 'Victoria', 'BC', 'Canada', 'V8W 2E7', '10-Feb-2020', '10-Feb-2020');
INSERT INTO contact("contactType", "fullName", "orgName", "orgPosition", "email", "phoneNumber","addressLine1", "addressLine2","city", "province", "country", "postalCode", "dateCreated", "dateModified") VALUES ('clientlead','Rob','AOT', 'Manager', '[email protected]', '123456789', '325-1207', 'Douglas Street', 'Victoria', 'BC', 'Canada', 'V8W 2E7', '10-Feb-2020', '10-Feb-2020');
INSERT INTO contact("contactType", "fullName", "orgName", "orgPosition", "email", "phoneNumber","addressLine1", "addressLine2","city", "province", "country", "postalCode", "dateCreated", "dateModified") VALUES ('clientlead','Bobby','AOT', 'Manager', '[email protected]', '123456789', '325-1207', 'Douglas Street', 'Victoria', 'BC', 'Canada', 'V8W 2E7', '10-Feb-2020', '10-Feb-2020');
INSERT INTO contact("contactType", "fullName", "orgName", "orgPosition", "email", "phoneNumber","addressLine1", "addressLine2","city", "province", "country", "postalCode", "dateCreated", "dateModified") VALUES ('clientsponsor','Robby','AOT', 'Manager', '[email protected]', '123456789', '325-1207', 'Douglas Street', 'Victoria', 'BC', 'Canada', 'V8W 2E7', '10-Feb-2020', '10-Feb-2020');
INSERT INTO contact("contactType", "fullName", "orgName", "orgPosition", "email", "phoneNumber","addressLine1", "addressLine2","city", "province", "country", "postalCode", "dateCreated", "dateModified") VALUES ('user','Samantha','AOT', 'Manager', '[email protected]', '123456789', '325-1207', 'Douglas Street', 'Victoria', 'BC', 'Canada', 'V8W 2E7', '10-Feb-2020', '10-Feb-2020');
INSERT INTO contact("contactType", "fullName", "orgName", "orgPosition", "email", "phoneNumber","addressLine1", "addressLine2","city", "province", "country", "postalCode", "dateCreated", "dateModified") VALUES ('user','Li','AOT', 'Manager', '[email protected]', '123456789', '325-1207', 'Douglas Street', 'Victoria', 'BC', 'Canada', 'V8W 2E7', '10-Feb-2020', '10-Feb-2020');
INSERT INTO contact("contactType", "fullName", "orgName", "orgPosition", "email", "phoneNumber","addressLine1", "addressLine2","city", "province", "country", "postalCode", "dateCreated", "dateModified") VALUES ('clientsponsor','John','AOT', 'Manager', '[email protected]', '123456789', '325-1207', 'Douglas Street', 'Victoria', 'BC', 'Canada', 'V8W 2E7', '10-Feb-2020', '10-Feb-2020');
INSERT INTO contact("contactType", "fullName", "orgName", "orgPosition", "email", "phoneNumber","addressLine1", "addressLine2","city", "province", "country", "postalCode", "dateCreated", "dateModified") VALUES ('clientlead','Ron','AOT', 'Manager', '[email protected]', '123456789', '325-1207', 'Douglas Street', 'Victoria', 'BC', 'Canada', 'V8W 2E7', '10-Feb-2020', '10-Feb-2020');
INSERT INTO contact("contactType", "fullName", "orgName", "orgPosition", "email", "phoneNumber","addressLine1", "addressLine2","city", "province", "country", "postalCode", "dateCreated", "dateModified") VALUES ('clientsponsor','Monica','AOT', 'Manager', '[email protected]', '123456789', '325-1207', 'Douglas Street', 'Victoria', 'BC', 'Canada', 'V8W 2E7', '10-Feb-2020', '10-Feb-2020');
INSERT INTO contact("contactType", "fullName", "orgName", "orgPosition", "email", "phoneNumber","addressLine1", "addressLine2","city", "province", "country", "postalCode", "dateCreated", "dateModified") VALUES ('user','Arena','AOT', 'Manager', '[email protected]', '123456789', '325-1207', 'Douglas Street', 'Victoria', 'BC', 'Canada', 'V8W 2E7', '10-Feb-2020', '10-Feb-2020');
INSERT INTO public.user ("referenceId","role", "contactId") VALUES (1, 'Procurement Specialist','fac4934a-f916-4375-865d-02a3aa495854');
INSERT INTO public.user("referenceId","role", "contactId") VALUES (2, 'Legal Services Branch','3cc81e32-a133-4583-b2ea-da673ee593c5');
INSERT INTO public.user("referenceId","role", "contactId") VALUES (3, 'Finance','d47dc003-6ac5-430b-9910-f8fedb03ce22');
INSERT INTO public.user ("referenceId","role", "contactId") VALUES (4, 'Admin','d1a35227-f4b2-4e95-b736-26ff0fc7ccbb');
INSERT INTO public.user ("referenceId","role", "contactId") VALUES (5, 'Client','57a3cdd2-45e4-4a36-be7c-0b2d3b005eb2');
INSERT INTO public.user ("referenceId","role", "contactId") VALUES (6, 'Contractor','c335bdfa-c688-4d7d-952d-c113942d523b');
INSERT INTO public.user ("referenceId","role", "contactId") VALUES (7, 'Procurement Specialist','f951d0c4-a3e4-4608-ab53-05b21c04c999');
INSERT INTO public.user ("referenceId","role", "contactId") VALUES (8, 'Legal Services Branch','5b5c5bb5-34d8-4c42-93cf-118eba3a4a61');
INSERT INTO public.user ("referenceId","role", "contactId") VALUES (9, 'Finance','61a9ed90-389e-4320-b9e4-efc0e0f3d8a4');
INSERT INTO public.user ("referenceId","role", "contactId") VALUES (10, 'Admin','be9c8bd3-719e-430e-9838-dadb27ec8a4b');
INSERT INTO client("clientNo", "responsibilityCenter", "serviceCenter", stob, "projectCode", "orgDivision", "email", "addressLine1", "addressLine2", "city", "province", "country", "postalCode", "dateCreated", "dateModified", "ministryId") VALUES (1,971,451,123,235,'IT','[email protected]','325-1207','Douglas Street','Victoria','BC','Canada','V8W 2E7','10-Feb-2020','10-Feb-2020','e761a147-9ef7-41b0-b215-e77ca835fdc9');
INSERT INTO client("clientNo", "responsibilityCenter", "serviceCenter", stob, "projectCode", "orgDivision", "email", "addressLine1", "addressLine2", "city", "province", "country", "postalCode", "dateCreated", "dateModified", "ministryId") VALUES (2,972,452,124,236,'IT','[email protected]','325-1207','Douglas Street','Victoria','BC','Canada','V8W 2E7','10-Feb-2020','10-Feb-2020','0a4d654b-d8af-4b20-b04d-94e672379771');
INSERT INTO client("clientNo", "responsibilityCenter", "serviceCenter", stob, "projectCode", "orgDivision", "email", "addressLine1", "addressLine2", "city", "province", "country", "postalCode", "dateCreated", "dateModified", "ministryId") VALUES (3,973,453,125,237,'IT','[email protected]','325-1207','Douglas Street','Victoria','BC','Canada','V8W 2E7','10-Feb-2020','10-Feb-2020','fe05c320-9786-44c3-9998-540b7342473f');
INSERT INTO client("clientNo", "responsibilityCenter", "serviceCenter", stob, "projectCode", "orgDivision", "email", "addressLine1", "addressLine2", "city", "province", "country", "postalCode", "dateCreated", "dateModified", "ministryId") VALUES (4,974,454,126,238,'IT','[email protected]','325-1207','Douglas Street','Victoria','BC','Canada','V8W 2E7','10-Feb-2020','10-Feb-2020','3b87ff96-be6b-42dd-8cd9-85c742a7a783');
INSERT INTO client("clientNo", "responsibilityCenter", "serviceCenter", stob, "projectCode", "orgDivision", "email", "addressLine1", "addressLine2", "city", "province", "country", "postalCode", "dateCreated", "dateModified", "ministryId") VALUES (5,975,455,127,239,'IT','[email protected]','325-1207','Douglas Street','Victoria','BC','Canada','V8W 2E7','10-Feb-2020','10-Feb-2020','fc1afab6-d824-46a9-aeed-6dc4024c75e2');
INSERT INTO client("clientNo", "responsibilityCenter", "serviceCenter", stob, "projectCode", "orgDivision", "email", "addressLine1", "addressLine2", "city", "province", "country", "postalCode", "dateCreated", "dateModified", "ministryId") VALUES (6,976,456,128,240,'IT','[email protected]','325-1208','Douglas Street','Victoria','BC','Canada','V8W 2E8','10-Feb-2020','10-Feb-2020','9e5eebab-f74b-4906-9efc-21a131a7728c');
INSERT INTO client("clientNo", "responsibilityCenter", "serviceCenter", stob, "projectCode", "orgDivision", "email", "addressLine1", "addressLine2", "city", "province", "country", "postalCode", "dateCreated", "dateModified", "ministryId") VALUES (7,977,457,129,241,'IT','[email protected]','325-1209','Douglas Street','Victoria','BC','Canada','V8W 2E9','10-Feb-2020','10-Feb-2020','51c6f42d-7cbb-4944-b277-5234c7d3298f');
INSERT INTO client("clientNo", "responsibilityCenter", "serviceCenter", stob, "projectCode", "orgDivision", "email", "addressLine1", "addressLine2", "city", "province", "country", "postalCode", "dateCreated", "dateModified", "ministryId") VALUES (8,978,458,130,242,'IT','[email protected]','325-1210','Douglas Street','Victoria','BC','Canada','V8W 2E10','10-Feb-2020','10-Feb-2020','93173948-1a06-4f92-b822-daec06643cfb');
INSERT INTO client("clientNo", "responsibilityCenter", "serviceCenter", stob, "projectCode", "orgDivision", "email", "addressLine1", "addressLine2", "city", "province", "country", "postalCode", "dateCreated", "dateModified", "ministryId") VALUES (9,979,459,131,243,'IT','[email protected]','325-1211','Douglas Street','Victoria','BC','Canada','V8W 2E11','10-Feb-2020','10-Feb-2020','8cfeb083-dec5-4f33-a67a-16027e5bbc93');
INSERT INTO client("clientNo", "responsibilityCenter", "serviceCenter", stob, "projectCode", "orgDivision", "email", "addressLine1", "addressLine2", "city", "province", "country", "postalCode", "dateCreated", "dateModified", "ministryId") VALUES (10,980,460,132,244,'IT','[email protected]','325-1212','Douglas Street','Victoria','BC','Canada','V8W 2E12','10-Feb-2020','10-Feb-2020','008c3dab-181d-4611-8654-ad98bddb80f1');
INSERT INTO client("clientNo", "responsibilityCenter", "serviceCenter", stob, "projectCode", "orgDivision", "email", "addressLine1", "addressLine2", "city", "province", "country", "postalCode", "dateCreated", "dateModified", "ministryId") VALUES (11,981,461,133,245,'IT','[email protected]','325-1213','Douglas Street','Victoria','BC','Canada','V8W 2E13','10-Feb-2020','10-Feb-2020','c9270cc1-83c8-434e-ae31-15c876518a7f');
INSERT INTO client("clientNo", "responsibilityCenter", "serviceCenter", stob, "projectCode", "orgDivision", "email", "addressLine1", "addressLine2", "city", "province", "country", "postalCode", "dateCreated", "dateModified", "ministryId") VALUES (12,982,462,134,246,'IT','[email protected]','325-1214','Douglas Street','Victoria','BC','Canada','V8W 2E14','10-Feb-2020','10-Feb-2020','2880195b-5e13-456b-be80-ecdcabde13ba');
INSERT INTO client("clientNo", "responsibilityCenter", "serviceCenter", stob, "projectCode", "orgDivision", "email", "addressLine1", "addressLine2", "city", "province", "country", "postalCode", "dateCreated", "dateModified", "ministryId") VALUES (13,983,463,135,247,'IT','[email protected]','325-1215','Douglas Street','Victoria','BC','Canada','V8W 2E15','10-Feb-2020','10-Feb-2020','7c9f69ee-00e0-48d0-abd6-319c87210f7f');
INSERT INTO client("clientNo", "responsibilityCenter", "serviceCenter", stob, "projectCode", "orgDivision", "email", "addressLine1", "addressLine2", "city", "province", "country", "postalCode", "dateCreated", "dateModified", "ministryId") VALUES (14,984,464,136,248,'IT','[email protected]','325-1216','Douglas Street','Victoria','BC','Canada','V8W 2E16','10-Feb-2020','10-Feb-2020','dc68feb3-8e59-4ce5-b581-26a0bb8384da');
INSERT INTO client("clientNo", "responsibilityCenter", "serviceCenter", stob, "projectCode", "orgDivision", "email", "addressLine1", "addressLine2", "city", "province", "country", "postalCode", "dateCreated", "dateModified", "ministryId") VALUES (15,985,465,137,249,'IT','[email protected]','325-1217','Douglas Street','Victoria','BC','Canada','V8W 2E17','10-Feb-2020','10-Feb-2020','091e29a8-de66-4937-a71f-0e5650b14de5');
INSERT INTO client("clientNo", "responsibilityCenter", "serviceCenter", stob, "projectCode", "orgDivision", "email", "addressLine1", "addressLine2", "city", "province", "country", "postalCode", "dateCreated", "dateModified", "ministryId") VALUES (16,986,466,138,250,'IT','[email protected]','325-1218','Douglas Street','Victoria','BC','Canada','V8W 2E18','10-Feb-2020','10-Feb-2020','8b658252-2bc5-428f-9d80-202677cb986c');
INSERT INTO project("projectName", "commodityCode", "dueDate", "completionDate", "contractValue", "mouAmount", "leadUserId", "backupUserId", description, "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "clientId", "projectSectorId") VALUES ('NBRP','commodityCode','10-Feb-2020','10-Feb-2020',100000,34000,'e0963b20-0122-4ee5-9c50-1df0e2d85e11','b5104802-8a41-4783-8923-75986b69f07c','project-desc','10-Feb-2020','10-Feb-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','f3b5aecf-c53c-43df-9f78-0610768a5318','129e7342-f568-457f-8865-75ab07c9853f');
INSERT INTO project("projectName", "commodityCode", "dueDate", "completionDate", "contractValue", "mouAmount", "leadUserId", "backupUserId", description, "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "clientId", "projectSectorId") VALUES ('ABNO','commodityCode','10-Feb-2020','10-Feb-2020',100000,34000,'e0963b20-0122-4ee5-9c50-1df0e2d85e11','b5104802-8a41-4783-8923-75986b69f07c','project-desc','10-Feb-2020','10-Feb-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','32a774a1-cd03-4f9d-9388-4b5b8ec6d58a','84d7854d-3cb2-4b01-b5a3-e7cefaae543f');
INSERT INTO project("projectName", "commodityCode", "dueDate", "completionDate", "contractValue", "mouAmount", "leadUserId", "backupUserId", description, "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "clientId", "projectSectorId") VALUES ('TELUS','commodityCode','10-Feb-2020','10-Feb-2020',100000,34000,'e0963b20-0122-4ee5-9c50-1df0e2d85e11','b5104802-8a41-4783-8923-75986b69f07c','project-desc','10-Feb-2020','10-Feb-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','61824a53-a941-4af5-a122-dbdcfffa056d','292683d5-bb83-4127-b947-18e1590fed82');
INSERT INTO project("projectName", "commodityCode", "dueDate", "completionDate", "contractValue", "mouAmount", "leadUserId", "backupUserId", description, "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "clientId", "projectSectorId") VALUES ('CIBC','commodityCode','10-Feb-2020','10-Feb-2020',100000,34000,'e0963b20-0122-4ee5-9c50-1df0e2d85e11','b5104802-8a41-4783-8923-75986b69f07c','project-desc','10-Feb-2020','10-Feb-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','29a0c404-1976-40d7-8b82-0a398ede5e23','f7a33433-6bf3-4b21-80c2-f2198b577829');
INSERT INTO project("projectName", "commodityCode", "dueDate", "completionDate", "contractValue", "mouAmount", "leadUserId", "backupUserId", description, "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "clientId", "projectSectorId") VALUES ('RBC','commodityCode','10-Feb-2020','10-Feb-2020',100000,34000,'e0963b20-0122-4ee5-9c50-1df0e2d85e11','b5104802-8a41-4783-8923-75986b69f07c','project-desc','10-Feb-2020','10-Feb-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','a1c6cb09-c6f6-4e6f-8ff0-9324e6b85c19','41f4711b-52b6-4791-897a-6aebf4d2e7fc');
INSERT INTO project("projectName", "commodityCode", "dueDate", "completionDate", "contractValue", "mouAmount", "leadUserId", "backupUserId", description, "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "clientId", "projectSectorId") VALUES ('BMO','commodityCode','10-Feb-2020','10-Feb-2020',100000,34000,'e0963b20-0122-4ee5-9c50-1df0e2d85e11','b5104802-8a41-4783-8923-75986b69f07c','project-desc','10-Feb-2020','10-Feb-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','6d395348-2910-413b-8c2e-408a0df6a739','2edd7479-f1e3-4bd2-99c3-a08b2047b7d7');
INSERT INTO project("projectName", "commodityCode", "dueDate", "completionDate", "contractValue", "mouAmount", "leadUserId", "backupUserId", description, "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "clientId", "projectSectorId") VALUES ('CCD','commodityCode','10-Feb-2020','10-Feb-2020',100000,34000,'e0963b20-0122-4ee5-9c50-1df0e2d85e11','b5104802-8a41-4783-8923-75986b69f07c','project-desc','10-Feb-2020','10-Feb-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','2019ad41-7978-4562-b814-c0ddf85c0dd8','3f03049d-f1e2-4a59-b223-49189fbb1315');
INSERT INTO project("projectName", "commodityCode", "dueDate", "completionDate", "contractValue", "mouAmount", "leadUserId", "backupUserId", description, "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "clientId", "projectSectorId") VALUES ('TELUS','commodityCode','10-Feb-2020','10-Feb-2020',100000,34000,'e0963b20-0122-4ee5-9c50-1df0e2d85e11','b5104802-8a41-4783-8923-75986b69f07c','project-desc','10-Feb-2020','10-Feb-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e756babf-4e0e-48c4-8352-2e8b4c48648a','9428e4c6-b28a-43c2-8e60-7a20634fa93b');
INSERT INTO project("projectName", "commodityCode", "dueDate", "completionDate", "contractValue", "mouAmount", "leadUserId", "backupUserId", description, "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "clientId", "projectSectorId") VALUES ('CIBC','commodityCode','10-Feb-2020','10-Feb-2020',100000,34000,'e0963b20-0122-4ee5-9c50-1df0e2d85e11','b5104802-8a41-4783-8923-75986b69f07c','project-desc','10-Feb-2020','10-Feb-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','d21a2a88-e715-4155-b815-203043c0db6e','36e78be0-0c49-4b8d-b80b-45772c2a7ad4');
INSERT INTO project("projectName", "commodityCode", "dueDate", "completionDate", "contractValue", "mouAmount", "leadUserId", "backupUserId", description, "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "clientId", "projectSectorId") VALUES ('RBC','commodityCode','10-Feb-2020','10-Feb-2020',100000,34000,'e0963b20-0122-4ee5-9c50-1df0e2d85e11','b5104802-8a41-4783-8923-75986b69f07c','project-desc','10-Feb-2020','10-Feb-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','9c9d0eb3-832a-4b3c-98ae-c93eebd856a8','0428f4f5-5d0e-459c-8e1d-89d43d419371');
INSERT INTO project("projectName", "commodityCode", "dueDate", "completionDate", "contractValue", "mouAmount", "leadUserId", "backupUserId", description, "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "clientId", "projectSectorId") VALUES ('BMO','commodityCode','10-Feb-2020','10-Feb-2020',100000,34000,'e0963b20-0122-4ee5-9c50-1df0e2d85e11','b5104802-8a41-4783-8923-75986b69f07c','project-desc','10-Feb-2020','10-Feb-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','37039005-4048-4952-9475-dd48603db0cc','41f4711b-52b6-4791-897a-6aebf4d2e7fc');
INSERT INTO project("projectName", "commodityCode", "dueDate", "completionDate", "contractValue", "mouAmount", "leadUserId", "backupUserId", description, "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "clientId", "projectSectorId") VALUES ('CCD','commodityCode','10-Feb-2020','10-Feb-2020',100000,34000,'e0963b20-0122-4ee5-9c50-1df0e2d85e11','b5104802-8a41-4783-8923-75986b69f07c','project-desc','10-Feb-2020','10-Feb-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','20b68b4e-2085-4872-b108-208b7202478d','2edd7479-f1e3-4bd2-99c3-a08b2047b7d7');
INSERT INTO project("projectName", "commodityCode", "dueDate", "completionDate", "contractValue", "mouAmount", "leadUserId", "backupUserId", description, "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "clientId", "projectSectorId") VALUES ('TELUS','commodityCode','10-Feb-2020','10-Feb-2020',100000,34000,'e0963b20-0122-4ee5-9c50-1df0e2d85e11','b5104802-8a41-4783-8923-75986b69f07c','project-desc','10-Feb-2020','10-Feb-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','8a216fbd-776f-45df-8210-600d688b0902','3f03049d-f1e2-4a59-b223-49189fbb1315');
INSERT INTO project("projectName", "commodityCode", "dueDate", "completionDate", "contractValue", "mouAmount", "leadUserId", "backupUserId", description, "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "clientId", "projectSectorId") VALUES ('CIBC','commodityCode','10-Feb-2020','10-Feb-2020',100000,34000,'e0963b20-0122-4ee5-9c50-1df0e2d85e11','b5104802-8a41-4783-8923-75986b69f07c','project-desc','10-Feb-2020','10-Feb-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','b210a8ad-34dd-4b0e-9793-2082a36844af','9428e4c6-b28a-43c2-8e60-7a20634fa93b');
INSERT INTO project("projectName", "commodityCode", "dueDate", "completionDate", "contractValue", "mouAmount", "leadUserId", "backupUserId", description, "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "clientId", "projectSectorId") VALUES ('RBC','commodityCode','10-Feb-2020','10-Feb-2020',100000,34000,'e0963b20-0122-4ee5-9c50-1df0e2d85e11','b5104802-8a41-4783-8923-75986b69f07c','project-desc','10-Feb-2020','10-Feb-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','2ffe2399-5f36-4eec-abde-338ee5b9ea32','36e78be0-0c49-4b8d-b80b-45772c2a7ad4');
INSERT INTO project("projectName", "commodityCode", "dueDate", "completionDate", "contractValue", "mouAmount", "leadUserId", "backupUserId", description, "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "clientId", "projectSectorId") VALUES ('BMO','commodityCode','10-Feb-2020','10-Feb-2020',100000,34000,'e0963b20-0122-4ee5-9c50-1df0e2d85e11','b5104802-8a41-4783-8923-75986b69f07c','project-desc','10-Feb-2020','10-Feb-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','3ddc1d0b-6bb5-49f1-a5e2-5e143c22ee53','3f03049d-f1e2-4a59-b223-49189fbb1315');
INSERT INTO project_contacts("projectId", "contactId") VALUES('ebfb4070-84c9-43e0-bc3c-9943e4fb3bb9','fac4934a-f916-4375-865d-02a3aa495854');
INSERT INTO project_contacts("projectId", "contactId") VALUES('7333437d-d764-4ca3-8ba6-0c61d6c6e6d1','3cc81e32-a133-4583-b2ea-da673ee593c5');
INSERT INTO project_contacts("projectId", "contactId") VALUES('baf413d4-0d79-4ca0-b157-f4c43362d2e0','d47dc003-6ac5-430b-9910-f8fedb03ce22');
INSERT INTO project_contacts("projectId", "contactId") VALUES('b28701cf-4cf0-483f-b15a-34a914021d12','d1a35227-f4b2-4e95-b736-26ff0fc7ccbb');
INSERT INTO project_contacts("projectId", "contactId") VALUES('d7e3dc5a-d4d4-4ba9-8e52-d51061478ccb','57a3cdd2-45e4-4a36-be7c-0b2d3b005eb2');
INSERT INTO project_contacts("projectId", "contactId") VALUES('1deedde1-6689-4c05-a003-b43bf33c8461','c335bdfa-c688-4d7d-952d-c113942d523b');
INSERT INTO project_contacts("projectId", "contactId") VALUES('c5c966db-4fc4-484d-ac49-d29fd74e4946','f951d0c4-a3e4-4608-ab53-05b21c04c999');
INSERT INTO project_contacts("projectId", "contactId") VALUES('d58af96f-0a0b-4fa7-b4ba-f0926014e57a','5b5c5bb5-34d8-4c42-93cf-118eba3a4a61');
INSERT INTO project_contacts("projectId", "contactId") VALUES('b86fbe93-477f-4083-92d5-938f0923b965','61a9ed90-389e-4320-b9e4-efc0e0f3d8a4');
INSERT INTO project_contacts("projectId", "contactId") VALUES('cbd66cfb-6524-427d-bbdb-4f80b6a45122','be9c8bd3-719e-430e-9838-dadb27ec8a4b');
INSERT INTO project_intake("projectName", "commodityCode", "estimatedCompletionDate", "estimatedContractValue", "mouAmount", description, status, "projectId", "createdUserId", "approverUserId", "dateCreated", "dateModified", "clientId", "projectSectorId") VALUES ('NBRP','commodityCode','29-Jun-2020',100000,34000,'proj-desc','In Progress','ebfb4070-84c9-43e0-bc3c-9943e4fb3bb9','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','10-Feb-2020','10-Feb-2020','f3b5aecf-c53c-43df-9f78-0610768a5318','129e7342-f568-457f-8865-75ab07c9853f');
INSERT INTO project_intake("projectName", "commodityCode", "estimatedCompletionDate", "estimatedContractValue", "mouAmount", description, status, "projectId", "createdUserId", "approverUserId", "dateCreated", "dateModified", "clientId", "projectSectorId") VALUES ('ABNO','commodityCode','29-Jun-2020',100000,34000,'proj-desc','In Progress','7333437d-d764-4ca3-8ba6-0c61d6c6e6d1','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','10-Feb-2020','10-Feb-2020','32a774a1-cd03-4f9d-9388-4b5b8ec6d58a','84d7854d-3cb2-4b01-b5a3-e7cefaae543f');
INSERT INTO project_intake("projectName", "commodityCode", "estimatedCompletionDate", "estimatedContractValue", "mouAmount", description, status, "projectId", "createdUserId", "approverUserId", "dateCreated", "dateModified", "clientId", "projectSectorId") VALUES ('TELUS','commodityCode','29-Jun-2020',100000,34000,'proj-desc','In Progress','baf413d4-0d79-4ca0-b157-f4c43362d2e0','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','10-Feb-2020','10-Feb-2020','61824a53-a941-4af5-a122-dbdcfffa056d','292683d5-bb83-4127-b947-18e1590fed82');
INSERT INTO project_intake("projectName", "commodityCode", "estimatedCompletionDate", "estimatedContractValue", "mouAmount", description, status, "projectId", "createdUserId", "approverUserId", "dateCreated", "dateModified", "clientId", "projectSectorId") VALUES ('CIBC','commodityCode','29-Jun-2020',100000,34000,'proj-desc','In Progress','b28701cf-4cf0-483f-b15a-34a914021d12','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','10-Feb-2020','10-Feb-2020','29a0c404-1976-40d7-8b82-0a398ede5e23','f7a33433-6bf3-4b21-80c2-f2198b577829');
INSERT INTO project_intake("projectName", "commodityCode", "estimatedCompletionDate", "estimatedContractValue", "mouAmount", description, status, "projectId", "createdUserId", "approverUserId", "dateCreated", "dateModified", "clientId", "projectSectorId") VALUES ('RBC','commodityCode','29-Jun-2020',100000,34000,'proj-desc','In Progress','d7e3dc5a-d4d4-4ba9-8e52-d51061478ccb','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','10-Feb-2020','10-Feb-2020','a1c6cb09-c6f6-4e6f-8ff0-9324e6b85c19','41f4711b-52b6-4791-897a-6aebf4d2e7fc');
INSERT INTO project_intake("projectName", "commodityCode", "estimatedCompletionDate", "estimatedContractValue", "mouAmount", description, status, "projectId", "createdUserId", "approverUserId", "dateCreated", "dateModified", "clientId", "projectSectorId") VALUES ('BMO','commodityCode','29-Jun-2020',100000,34000,'proj-desc','In Progress','1deedde1-6689-4c05-a003-b43bf33c8461','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','10-Feb-2020','10-Feb-2020','6d395348-2910-413b-8c2e-408a0df6a739','2edd7479-f1e3-4bd2-99c3-a08b2047b7d7');
INSERT INTO project_intake("projectName", "commodityCode", "estimatedCompletionDate", "estimatedContractValue", "mouAmount", description, status, "projectId", "createdUserId", "approverUserId", "dateCreated", "dateModified", "clientId", "projectSectorId") VALUES ('CCD','commodityCode','29-Jun-2020',100000,34000,'proj-desc','In Progress','c5c966db-4fc4-484d-ac49-d29fd74e4946','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','10-Feb-2020','10-Feb-2020','2019ad41-7978-4562-b814-c0ddf85c0dd8','3f03049d-f1e2-4a59-b223-49189fbb1315');
INSERT INTO project_intake("projectName", "commodityCode", "estimatedCompletionDate", "estimatedContractValue", "mouAmount", description, status, "projectId", "createdUserId", "approverUserId", "dateCreated", "dateModified", "clientId", "projectSectorId") VALUES ('TELUS','commodityCode','29-Jun-2020',100000,34000,'proj-desc','In Progress','d58af96f-0a0b-4fa7-b4ba-f0926014e57a','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','10-Feb-2020','10-Feb-2020','e756babf-4e0e-48c4-8352-2e8b4c48648a','9428e4c6-b28a-43c2-8e60-7a20634fa93b');
INSERT INTO project_intake("projectName", "commodityCode", "estimatedCompletionDate", "estimatedContractValue", "mouAmount", description, status, "projectId", "createdUserId", "approverUserId", "dateCreated", "dateModified", "clientId", "projectSectorId") VALUES ('CIBC','commodityCode','29-Jun-2020',100000,34000,'proj-desc','In Progress','b86fbe93-477f-4083-92d5-938f0923b965','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','10-Feb-2020','10-Feb-2020','d21a2a88-e715-4155-b815-203043c0db6e','36e78be0-0c49-4b8d-b80b-45772c2a7ad4');
INSERT INTO project_intake("projectName", "commodityCode", "estimatedCompletionDate", "estimatedContractValue", "mouAmount", description, status, "projectId", "createdUserId", "approverUserId", "dateCreated", "dateModified", "clientId", "projectSectorId") VALUES ('RBC','commodityCode','29-Jun-2020',100000,34000,'proj-desc','In Progress','cbd66cfb-6524-427d-bbdb-4f80b6a45122','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','10-Feb-2020','10-Feb-2020','9c9d0eb3-832a-4b3c-98ae-c93eebd856a8','0428f4f5-5d0e-459c-8e1d-89d43d419371');
INSERT INTO project_intake("projectName", "commodityCode", "estimatedCompletionDate", "estimatedContractValue", "mouAmount", description, status, "projectId", "createdUserId", "approverUserId", "dateCreated", "dateModified", "clientId", "projectSectorId") VALUES ('BMO','commodityCode','29-Jun-2020',100000,34000,'proj-desc','In Progress','c5450dcb-0077-4cd5-8ed5-4a11a87bc803','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','10-Feb-2020','10-Feb-2020','37039005-4048-4952-9475-dd48603db0cc','41f4711b-52b6-4791-897a-6aebf4d2e7fc');
INSERT INTO project_intake("projectName", "commodityCode", "estimatedCompletionDate", "estimatedContractValue", "mouAmount", description, status, "projectId", "createdUserId", "approverUserId", "dateCreated", "dateModified", "clientId", "projectSectorId") VALUES ('CCD','commodityCode','29-Jun-2020',100000,34000,'proj-desc','In Progress','1ffb3026-c22c-4868-a36d-ee409ae0cacf','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','10-Feb-2020','10-Feb-2020','20b68b4e-2085-4872-b108-208b7202478d','2edd7479-f1e3-4bd2-99c3-a08b2047b7d7');
INSERT INTO project_intake("projectName", "commodityCode", "estimatedCompletionDate", "estimatedContractValue", "mouAmount", description, status, "projectId", "createdUserId", "approverUserId", "dateCreated", "dateModified", "clientId", "projectSectorId") VALUES ('TELUS','commodityCode','29-Jun-2020',100000,34000,'proj-desc','In Progress','1a1b8d0b-0b4c-45cf-a35f-862618f7993c','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','10-Feb-2020','10-Feb-2020','8a216fbd-776f-45df-8210-600d688b0902','3f03049d-f1e2-4a59-b223-49189fbb1315');
INSERT INTO project_intake("projectName", "commodityCode", "estimatedCompletionDate", "estimatedContractValue", "mouAmount", description, status, "projectId", "createdUserId", "approverUserId", "dateCreated", "dateModified", "clientId", "projectSectorId") VALUES ('CIBC','commodityCode','29-Jun-2020',100000,34000,'proj-desc','In Progress','d23e6966-ea0a-4302-a512-19bd33e1e635','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','10-Feb-2020','10-Feb-2020','b210a8ad-34dd-4b0e-9793-2082a36844af','9428e4c6-b28a-43c2-8e60-7a20634fa93b');
INSERT INTO project_intake("projectName", "commodityCode", "estimatedCompletionDate", "estimatedContractValue", "mouAmount", description, status, "projectId", "createdUserId", "approverUserId", "dateCreated", "dateModified", "clientId", "projectSectorId") VALUES ('RBC','commodityCode','29-Jun-2020',100000,34000,'proj-desc','In Progress','4e8a0ded-c92f-4dca-8cfe-5b4cc92d08fe','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','10-Feb-2020','10-Feb-2020','2ffe2399-5f36-4eec-abde-338ee5b9ea32','36e78be0-0c49-4b8d-b80b-45772c2a7ad4');
INSERT INTO project_intake("projectName", "commodityCode", "estimatedCompletionDate", "estimatedContractValue", "mouAmount", description, status, "projectId", "createdUserId", "approverUserId", "dateCreated", "dateModified", "clientId", "projectSectorId") VALUES ('BMO','commodityCode','29-Jun-2020',100000,34000,'proj-desc','In Progress','0210a24c-4f61-4446-aeb2-b1dad7b5c668','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','10-Feb-2020','10-Feb-2020','3ddc1d0b-6bb5-49f1-a5e2-5e143c22ee53','3f03049d-f1e2-4a59-b223-49189fbb1315');
INSERT INTO project_intake_contacts("projectIntakeId", "contactId") VALUES('e81e9f0f-6fcf-4478-b526-2bdb8aab4b48','fac4934a-f916-4375-865d-02a3aa495854');
INSERT INTO project_intake_contacts("projectIntakeId", "contactId") VALUES('1eeb7fce-109b-4a2d-a277-3b958ca69654','3cc81e32-a133-4583-b2ea-da673ee593c5');
INSERT INTO project_intake_contacts("projectIntakeId", "contactId") VALUES('996a3b83-4ec6-4f44-bcf1-6076ccfc6d0b','d47dc003-6ac5-430b-9910-f8fedb03ce22');
INSERT INTO project_intake_contacts("projectIntakeId", "contactId") VALUES('3561c176-3cfb-4116-9ac7-b26a63db3ba5','d1a35227-f4b2-4e95-b736-26ff0fc7ccbb');
INSERT INTO project_intake_contacts("projectIntakeId", "contactId") VALUES('e7bb5cea-3933-4343-9e91-0c15ccf7b17c','57a3cdd2-45e4-4a36-be7c-0b2d3b005eb2');
INSERT INTO project_intake_contacts("projectIntakeId", "contactId") VALUES('4325b4da-95f1-4509-a26c-bba19f106e2a','c335bdfa-c688-4d7d-952d-c113942d523b');
INSERT INTO project_intake_contacts("projectIntakeId", "contactId") VALUES('5eebda3f-1822-434a-b9db-39d2238118dd','f951d0c4-a3e4-4608-ab53-05b21c04c999');
INSERT INTO project_intake_contacts("projectIntakeId", "contactId") VALUES('8caf6ee6-59b3-4e94-b4bb-238ebe2654b2','5b5c5bb5-34d8-4c42-93cf-118eba3a4a61');
INSERT INTO project_intake_contacts("projectIntakeId", "contactId") VALUES('ddd59f99-9e76-47de-acf2-c6fc1fcbf395','61a9ed90-389e-4320-b9e4-efc0e0f3d8a4');
INSERT INTO project_intake_contacts("projectIntakeId", "contactId") VALUES('b5187799-c8a1-45bc-ad62-c5a99eefd638','fac4934a-f916-4375-865d-02a3aa495854');
INSERT INTO project_intake_contacts("projectIntakeId", "contactId") VALUES('2ecb6275-0cd5-44cb-a6aa-2f499bcca6e5','3cc81e32-a133-4583-b2ea-da673ee593c5');
INSERT INTO project_intake_contacts("projectIntakeId", "contactId") VALUES('9f70c9f0-0831-49cb-a26c-82f0f1cd4835','d47dc003-6ac5-430b-9910-f8fedb03ce22');
INSERT INTO project_intake_contacts("projectIntakeId", "contactId") VALUES('27b46ac2-d9d3-4cf2-bdaa-d1956932b576','d1a35227-f4b2-4e95-b736-26ff0fc7ccbb');
INSERT INTO project_intake_contacts("projectIntakeId", "contactId") VALUES('2386ad17-9255-4b78-91b3-5597fa471f5b','57a3cdd2-45e4-4a36-be7c-0b2d3b005eb2');
INSERT INTO project_intake_contacts("projectIntakeId", "contactId") VALUES('2c84aa38-f980-4bea-bce9-7ee787985d21','c335bdfa-c688-4d7d-952d-c113942d523b');
INSERT INTO project_intake_contacts("projectIntakeId", "contactId") VALUES('5594e855-ca07-4c9d-8cc2-b1f22910a1a4','f951d0c4-a3e4-4608-ab53-05b21c04c999');
INSERT INTO project_rfx("rfxOverview", "clientResponsibilities", "psdResponsibilities", "dateCreated", "dateModified", "projectId", "rfxTypeId", "rfxPhaseId") VALUES ('rfx_overview','clientResponsibilities', 'psdResponsibilities', '10-Feb-2020','10-Feb-2020', 'ebfb4070-84c9-43e0-bc3c-9943e4fb3bb9', '61ae129c-3725-4256-8eb3-f4de23cb1fd9', 'ca4a60e9-4a48-4492-90c5-aa9bbe6488c8');
INSERT INTO project_rfx("rfxOverview", "clientResponsibilities", "psdResponsibilities", "dateCreated", "dateModified", "projectId", "rfxTypeId", "rfxPhaseId") VALUES ('rfx_overview','clientResponsibilities', 'psdResponsibilities', '10-Feb-2020','10-Feb-2020', '7333437d-d764-4ca3-8ba6-0c61d6c6e6d1', '2f41b74a-e79d-4df6-9d45-36ba7dda0cdc', '7ef63add-be7c-4f3d-a810-a1b430ab3303');
INSERT INTO project_rfx("rfxOverview", "clientResponsibilities", "psdResponsibilities", "dateCreated", "dateModified", "projectId", "rfxTypeId", "rfxPhaseId") VALUES ('rfx_overview','clientResponsibilities', 'psdResponsibilities', '10-Feb-2020','10-Feb-2020', 'baf413d4-0d79-4ca0-b157-f4c43362d2e0', '4972beaf-88e0-4488-8f95-f81e9619d559', '031fce1b-84a4-459d-99a9-28879e0513ed');
INSERT INTO project_rfx("rfxOverview", "clientResponsibilities", "psdResponsibilities", "dateCreated", "dateModified", "projectId", "rfxTypeId", "rfxPhaseId") VALUES ('rfx_overview','clientResponsibilities', 'psdResponsibilities', '10-Feb-2020','10-Feb-2020', 'b28701cf-4cf0-483f-b15a-34a914021d12', '081ecbf6-c2d1-43bb-8da3-552749409b7b', '806db3d6-80cc-488d-bb10-0637b6e38e5a');
INSERT INTO project_rfx("rfxOverview", "clientResponsibilities", "psdResponsibilities", "dateCreated", "dateModified", "projectId", "rfxTypeId", "rfxPhaseId") VALUES ('rfx_overview','clientResponsibilities', 'psdResponsibilities', '10-Feb-2020','10-Feb-2020', 'd7e3dc5a-d4d4-4ba9-8e52-d51061478ccb', 'dc146d54-338c-4a3f-8b4f-d7eca463e90b', 'c6ad13be-cb3c-4e7f-9fda-e869e39f6a0f');
INSERT INTO project_rfx("rfxOverview", "clientResponsibilities", "psdResponsibilities", "dateCreated", "dateModified", "projectId", "rfxTypeId", "rfxPhaseId") VALUES ('rfx_overview','clientResponsibilities', 'psdResponsibilities', '10-Feb-2020','10-Feb-2020', '1deedde1-6689-4c05-a003-b43bf33c8461', '189e130b-0278-489f-bbc4-974e8e86936a', '0b206efd-3fda-4d96-874e-65a42155eccd');
INSERT INTO project_rfx("rfxOverview", "clientResponsibilities", "psdResponsibilities", "dateCreated", "dateModified", "projectId", "rfxTypeId", "rfxPhaseId") VALUES ('rfx_overview','clientResponsibilities', 'psdResponsibilities', '10-Feb-2020','10-Feb-2020', 'c5c966db-4fc4-484d-ac49-d29fd74e4946', '68f4e44a-1903-4e88-9e40-73daff8b5cf9', '46418825-7bd2-4e10-b9f5-b344204bb4c3');
INSERT INTO project_rfx("rfxOverview", "clientResponsibilities", "psdResponsibilities", "dateCreated", "dateModified", "projectId", "rfxTypeId", "rfxPhaseId") VALUES ('rfx_overview','clientResponsibilities', 'psdResponsibilities', '10-Feb-2020','10-Feb-2020', 'd58af96f-0a0b-4fa7-b4ba-f0926014e57a', '125bfcd2-be0a-4fd9-89b8-d1163e6ee4a7', '0986399a-816f-4e39-86a9-0142a0e2eab2');
INSERT INTO project_rfx("rfxOverview", "clientResponsibilities", "psdResponsibilities", "dateCreated", "dateModified", "projectId", "rfxTypeId", "rfxPhaseId") VALUES ('rfx_overview','clientResponsibilities', 'psdResponsibilities', '10-Feb-2020','10-Feb-2020', 'b86fbe93-477f-4083-92d5-938f0923b965', '7706d22f-4595-4682-9c5a-d1e9cb977e6c', 'a0b44075-7b22-4dc8-a29f-deaf8c22c6eb');
INSERT INTO project_rfx("rfxOverview", "clientResponsibilities", "psdResponsibilities", "dateCreated", "dateModified", "projectId", "rfxTypeId", "rfxPhaseId") VALUES ('rfx_overview','clientResponsibilities', 'psdResponsibilities', '10-Feb-2020','10-Feb-2020', 'cbd66cfb-6524-427d-bbdb-4f80b6a45122', '55b2865c-a442-4911-a3d5-e0a94705d2f2', 'ca4a60e9-4a48-4492-90c5-aa9bbe6488c8');
INSERT INTO project_rfx("rfxOverview", "clientResponsibilities", "psdResponsibilities", "dateCreated", "dateModified", "projectId", "rfxTypeId", "rfxPhaseId") VALUES ('rfx_overview','clientResponsibilities', 'psdResponsibilities', '10-Feb-2020','10-Feb-2020', 'c5450dcb-0077-4cd5-8ed5-4a11a87bc803', '65cfb2bd-73ff-476a-b206-2cf4e87cf588', '7ef63add-be7c-4f3d-a810-a1b430ab3303');
INSERT INTO project_rfx("rfxOverview", "clientResponsibilities", "psdResponsibilities", "dateCreated", "dateModified", "projectId", "rfxTypeId", "rfxPhaseId") VALUES ('rfx_overview','clientResponsibilities', 'psdResponsibilities', '10-Feb-2020','10-Feb-2020', '1ffb3026-c22c-4868-a36d-ee409ae0cacf', '98564b2e-5794-406f-9183-cbdbbd29ba30', '031fce1b-84a4-459d-99a9-28879e0513ed');
INSERT INTO project_rfx("rfxOverview", "clientResponsibilities", "psdResponsibilities", "dateCreated", "dateModified", "projectId", "rfxTypeId", "rfxPhaseId") VALUES ('rfx_overview','clientResponsibilities', 'psdResponsibilities', '10-Feb-2020','10-Feb-2020', '1a1b8d0b-0b4c-45cf-a35f-862618f7993c', 'd882d998-63d9-493d-bd87-ede5b4e054e7', '806db3d6-80cc-488d-bb10-0637b6e38e5a');
INSERT INTO project_rfx("rfxOverview", "clientResponsibilities", "psdResponsibilities", "dateCreated", "dateModified", "projectId", "rfxTypeId", "rfxPhaseId") VALUES ('rfx_overview','clientResponsibilities', 'psdResponsibilities', '10-Feb-2020','10-Feb-2020', 'd23e6966-ea0a-4302-a512-19bd33e1e635', '52adff94-16c7-4478-9fd5-901dd992de14', 'c6ad13be-cb3c-4e7f-9fda-e869e39f6a0f');
INSERT INTO project_rfx("rfxOverview", "clientResponsibilities", "psdResponsibilities", "dateCreated", "dateModified", "projectId", "rfxTypeId", "rfxPhaseId") VALUES ('rfx_overview','clientResponsibilities', 'psdResponsibilities', '10-Feb-2020','10-Feb-2020', '4e8a0ded-c92f-4dca-8cfe-5b4cc92d08fe', 'f43b5c63-f867-4127-a32c-d513d81f5f11', '0b206efd-3fda-4d96-874e-65a42155eccd');
INSERT INTO timesheet("startDate", "endDate", "userId", "isBillable", "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "projectRfxId", "projectId", "rfxPhaseId") VALUES('10-Feb-2020','29-Jun-2020','b1a273bd-a5ca-4e6b-9efd-a9499b768072',TRUE,'10-Feb-2020','10-Feb-2020','b1a273bd-a5ca-4e6b-9efd-a9499b768072','b1a273bd-a5ca-4e6b-9efd-a9499b768072','c2d3fc39-9974-4ad3-99d0-5a21a1d5f168','ebfb4070-84c9-43e0-bc3c-9943e4fb3bb9','ca4a60e9-4a48-4492-90c5-aa9bbe6488c8');
INSERT INTO timesheet("startDate", "endDate", "userId", "isBillable", "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "projectRfxId", "projectId", "rfxPhaseId") VALUES('10-Feb-2020','29-Jun-2020','bec1dc87-5d39-42b6-8dd2-3b77b6166697',TRUE,'10-Feb-2020','10-Feb-2020','bec1dc87-5d39-42b6-8dd2-3b77b6166697','bec1dc87-5d39-42b6-8dd2-3b77b6166697','d68992f9-3c02-4fa5-b3dc-bcf5920ef1ee','7333437d-d764-4ca3-8ba6-0c61d6c6e6d1','7ef63add-be7c-4f3d-a810-a1b430ab3303');
INSERT INTO timesheet("startDate", "endDate", "userId", "isBillable", "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "projectRfxId", "projectId", "rfxPhaseId") VALUES('10-Feb-2020','29-Jun-2020','1944b4a1-a538-46e5-b11a-8882dc59ccd9',TRUE,'10-Feb-2020','10-Feb-2020','1944b4a1-a538-46e5-b11a-8882dc59ccd9','1944b4a1-a538-46e5-b11a-8882dc59ccd9','ad298ef3-3b71-45b5-9812-2a51fd257966','baf413d4-0d79-4ca0-b157-f4c43362d2e0','031fce1b-84a4-459d-99a9-28879e0513ed');
INSERT INTO timesheet("startDate", "endDate", "userId", "isBillable", "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "projectRfxId", "projectId", "rfxPhaseId") VALUES('10-Feb-2020','29-Jun-2020','3e04445d-d9f2-439e-a354-bb7c4ae6b1ba',TRUE,'10-Feb-2020','10-Feb-2020','3e04445d-d9f2-439e-a354-bb7c4ae6b1ba','3e04445d-d9f2-439e-a354-bb7c4ae6b1ba','b13e9aaa-cfa1-4fb0-817b-52e3f4a3f8af','b28701cf-4cf0-483f-b15a-34a914021d12','806db3d6-80cc-488d-bb10-0637b6e38e5a');
INSERT INTO timesheet("startDate", "endDate", "userId", "isBillable", "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "projectRfxId", "projectId", "rfxPhaseId") VALUES('10-Feb-2020','29-Jun-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11',FALSE,'10-Feb-2020','10-Feb-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11','e0963b20-0122-4ee5-9c50-1df0e2d85e11','ec124bf9-3963-445e-93c9-cdd30e6a70e3','d7e3dc5a-d4d4-4ba9-8e52-d51061478ccb','c6ad13be-cb3c-4e7f-9fda-e869e39f6a0f');
INSERT INTO timesheet("startDate", "endDate", "userId", "isBillable", "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "projectRfxId", "projectId", "rfxPhaseId") VALUES('10-Feb-2020','29-Jun-2020','ba9fbe4e-95a8-47c1-a6d4-a5d7bb6b8ce9',TRUE,'10-Feb-2020','10-Feb-2020','ba9fbe4e-95a8-47c1-a6d4-a5d7bb6b8ce9','ba9fbe4e-95a8-47c1-a6d4-a5d7bb6b8ce9','33de4646-a50b-4344-884b-aaea763bc8a3','1deedde1-6689-4c05-a003-b43bf33c8461','0b206efd-3fda-4d96-874e-65a42155eccd');
INSERT INTO timesheet("startDate", "endDate", "userId", "isBillable", "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "projectRfxId", "projectId", "rfxPhaseId") VALUES('10-Feb-2020','29-Jun-2020','a211fc81-1931-4047-ac3b-270660c01e27',TRUE,'10-Feb-2020','10-Feb-2020','a211fc81-1931-4047-ac3b-270660c01e27','a211fc81-1931-4047-ac3b-270660c01e27','e916b28e-e313-4593-9656-850a97ae610a','c5c966db-4fc4-484d-ac49-d29fd74e4946','46418825-7bd2-4e10-b9f5-b344204bb4c3');
INSERT INTO timesheet("startDate", "endDate", "userId", "isBillable", "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "projectRfxId", "projectId", "rfxPhaseId") VALUES('10-Feb-2020','29-Jun-2020','929f534d-7037-41b2-96eb-132f0fe4a5a6',TRUE,'10-Feb-2020','10-Feb-2020','929f534d-7037-41b2-96eb-132f0fe4a5a6','929f534d-7037-41b2-96eb-132f0fe4a5a6','c1132067-41f7-445b-8496-bc87cc714105','d58af96f-0a0b-4fa7-b4ba-f0926014e57a','0986399a-816f-4e39-86a9-0142a0e2eab2');
INSERT INTO timesheet("startDate", "endDate", "userId", "isBillable", "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "projectRfxId", "projectId", "rfxPhaseId") VALUES('10-Feb-2020','29-Jun-2020','b5104802-8a41-4783-8923-75986b69f07c',TRUE,'10-Feb-2020','10-Feb-2020','b5104802-8a41-4783-8923-75986b69f07c','b5104802-8a41-4783-8923-75986b69f07c','6b7c0c3e-773c-4653-8845-258f8e238d27','b86fbe93-477f-4083-92d5-938f0923b965','a0b44075-7b22-4dc8-a29f-deaf8c22c6eb');
INSERT INTO timesheet("startDate", "endDate", "userId", "isBillable", "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "projectRfxId", "projectId", "rfxPhaseId") VALUES('10-Feb-2020','29-Jun-2020','37109f6e-6bd9-445a-b4c5-01551aa15436',TRUE,'10-Feb-2020','10-Feb-2020','37109f6e-6bd9-445a-b4c5-01551aa15436','37109f6e-6bd9-445a-b4c5-01551aa15436','a43c1eda-df27-495a-a1c5-91bd20d1964e','cbd66cfb-6524-427d-bbdb-4f80b6a45122','ca4a60e9-4a48-4492-90c5-aa9bbe6488c8');
INSERT INTO timesheet("startDate", "endDate", "userId", "isBillable", "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "projectRfxId", "projectId", "rfxPhaseId") VALUES('10-Feb-2020','29-Jun-2020','e0963b20-0122-4ee5-9c50-1df0e2d85e11',TRUE,'10-Feb-2020','10-Feb-2020','ba9fbe4e-95a8-47c1-a6d4-a5d7bb6b8ce9','ba9fbe4e-95a8-47c1-a6d4-a5d7bb6b8ce9','6b9fe57a-f5db-41de-bdd6-86242d6d136f','c5450dcb-0077-4cd5-8ed5-4a11a87bc803','7ef63add-be7c-4f3d-a810-a1b430ab3303');
INSERT INTO timesheet("startDate", "endDate", "userId", "isBillable", "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "projectRfxId", "projectId", "rfxPhaseId") VALUES('10-Feb-2020','29-Jun-2020','ba9fbe4e-95a8-47c1-a6d4-a5d7bb6b8ce9',TRUE,'10-Feb-2020','10-Feb-2020','a211fc81-1931-4047-ac3b-270660c01e27','a211fc81-1931-4047-ac3b-270660c01e27','81bc6dba-d7ba-4340-b49c-f111ae740b92','1ffb3026-c22c-4868-a36d-ee409ae0cacf','031fce1b-84a4-459d-99a9-28879e0513ed');
INSERT INTO timesheet("startDate", "endDate", "userId", "isBillable", "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "projectRfxId", "projectId", "rfxPhaseId") VALUES('10-Feb-2020','29-Jun-2020','a211fc81-1931-4047-ac3b-270660c01e27',TRUE,'10-Feb-2020','10-Feb-2020','929f534d-7037-41b2-96eb-132f0fe4a5a6','929f534d-7037-41b2-96eb-132f0fe4a5a6','c86e37d7-b4e3-4689-96ac-d2e53a667f56','1a1b8d0b-0b4c-45cf-a35f-862618f7993c','806db3d6-80cc-488d-bb10-0637b6e38e5a');
INSERT INTO timesheet("startDate", "endDate", "userId", "isBillable", "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "projectRfxId", "projectId", "rfxPhaseId") VALUES('10-Feb-2020','29-Jun-2020','929f534d-7037-41b2-96eb-132f0fe4a5a6',TRUE,'10-Feb-2020','10-Feb-2020','b5104802-8a41-4783-8923-75986b69f07c','b5104802-8a41-4783-8923-75986b69f07c','0548785a-d148-40f1-9dde-16a8881a7563','d23e6966-ea0a-4302-a512-19bd33e1e635','c6ad13be-cb3c-4e7f-9fda-e869e39f6a0f');
INSERT INTO timesheet("startDate", "endDate", "userId", "isBillable", "dateCreated", "dateModified", "createdUserId", "modifiedUserId", "projectRfxId", "projectId", "rfxPhaseId") VALUES('10-Feb-2020','29-Jun-2020','b5104802-8a41-4783-8923-75986b69f07c',TRUE,'10-Feb-2020','10-Feb-2020','37109f6e-6bd9-445a-b4c5-01551aa15436','37109f6e-6bd9-445a-b4c5-01551aa15436','9e8cc765-cf76-40d9-bee8-e2f3f030cdb1','4e8a0ded-c92f-4dca-8cfe-5b4cc92d08fe','0b206efd-3fda-4d96-874e-65a42155eccd');
INSERT INTO timesheet_entry("projectRfxId", "projectId", "rfxPhaseId", "userId", "hoursBilled", "entryDate", "startTime", "endTime", "comments", "dateCreated", "dateModified", "timesheetId") VALUES('c2d3fc39-9974-4ad3-99d0-5a21a1d5f168','c2d3fc39-9974-4ad3-99d0-5a21a1d5f168','c2d3fc39-9974-4ad3-99d0-5a21a1d5f168','c2d3fc39-9974-4ad3-99d0-5a21a1d5f168',72,'10-Feb-2020','2020-02-10 09:00:00','2020-02-10 05:00:00','comments','10-Feb-2020','10-Feb-2020','a2a52a17-84e4-47b8-af48-5a1cd8a3f0f5');
INSERT INTO timesheet_entry("projectRfxId", "projectId", "rfxPhaseId", "userId", "hoursBilled", "entryDate", "startTime", "endTime", "comments", "dateCreated", "dateModified", "timesheetId") VALUES('d68992f9-3c02-4fa5-b3dc-bcf5920ef1ee','d68992f9-3c02-4fa5-b3dc-bcf5920ef1ee','d68992f9-3c02-4fa5-b3dc-bcf5920ef1ee','d68992f9-3c02-4fa5-b3dc-bcf5920ef1ee',72,'10-Feb-2020','2020-02-10 09:00:00','2020-02-10 05:00:00','comments','10-Feb-2020','10-Feb-2020','14472e71-8805-4bef-a840-3a342b697086');
INSERT INTO timesheet_entry("projectRfxId", "projectId", "rfxPhaseId", "userId", "hoursBilled", "entryDate", "startTime", "endTime", "comments", "dateCreated", "dateModified", "timesheetId") VALUES('ad298ef3-3b71-45b5-9812-2a51fd257966','ad298ef3-3b71-45b5-9812-2a51fd257966','ad298ef3-3b71-45b5-9812-2a51fd257966','ad298ef3-3b71-45b5-9812-2a51fd257966',72,'10-Feb-2020','2020-02-10 09:00:00','2020-02-10 05:00:00','comments','10-Feb-2020','10-Feb-2020','747ac932-68e2-4bbd-b10f-8667b50aba32');
INSERT INTO timesheet_entry("projectRfxId", "projectId", "rfxPhaseId", "userId", "hoursBilled", "entryDate", "startTime", "endTime", "comments", "dateCreated", "dateModified", "timesheetId") VALUES('b13e9aaa-cfa1-4fb0-817b-52e3f4a3f8af','b13e9aaa-cfa1-4fb0-817b-52e3f4a3f8af','b13e9aaa-cfa1-4fb0-817b-52e3f4a3f8af','b13e9aaa-cfa1-4fb0-817b-52e3f4a3f8af',72,'10-Feb-2020','2020-02-10 09:00:00','2020-02-10 05:00:00','comments','10-Feb-2020','10-Feb-2020','6ef574eb-3e3e-41a1-b0ac-6b1dc14d353a');
INSERT INTO timesheet_entry("projectRfxId", "projectId", "rfxPhaseId", "userId", "hoursBilled", "entryDate", "startTime", "endTime", "comments", "dateCreated", "dateModified", "timesheetId") VALUES('ec124bf9-3963-445e-93c9-cdd30e6a70e3','ec124bf9-3963-445e-93c9-cdd30e6a70e3','ec124bf9-3963-445e-93c9-cdd30e6a70e3','ec124bf9-3963-445e-93c9-cdd30e6a70e3',72,'10-Feb-2020','2020-02-10 09:00:00','2020-02-10 05:00:00','comments','10-Feb-2020','10-Feb-2020','52f97b16-b959-4ad7-85e3-758f9a45d726');
INSERT INTO timesheet_entry("projectRfxId", "projectId", "rfxPhaseId", "userId", "hoursBilled", "entryDate", "startTime", "endTime", "comments", "dateCreated", "dateModified", "timesheetId") VALUES('33de4646-a50b-4344-884b-aaea763bc8a3','33de4646-a50b-4344-884b-aaea763bc8a3','33de4646-a50b-4344-884b-aaea763bc8a3','33de4646-a50b-4344-884b-aaea763bc8a3',72,'10-Feb-2020','2020-02-10 09:00:00','2020-02-10 05:00:00','comments','10-Feb-2020','10-Feb-2020','88cb475a-9b00-48ee-bb93-a8cf01a0745f');
INSERT INTO timesheet_entry("projectRfxId", "projectId", "rfxPhaseId", "userId", "hoursBilled", "entryDate", "startTime", "endTime", "comments", "dateCreated", "dateModified", "timesheetId") VALUES('e916b28e-e313-4593-9656-850a97ae610a','e916b28e-e313-4593-9656-850a97ae610a','e916b28e-e313-4593-9656-850a97ae610a','e916b28e-e313-4593-9656-850a97ae610a',72,'10-Feb-2020','2020-02-10 09:00:00','2020-02-10 05:00:00','comments','10-Feb-2020','10-Feb-2020','98af60cb-d5a6-425d-9cf9-880023013b11');
INSERT INTO timesheet_entry("projectRfxId", "projectId", "rfxPhaseId", "userId", "hoursBilled", "entryDate", "startTime", "endTime", "comments", "dateCreated", "dateModified", "timesheetId") VALUES('c1132067-41f7-445b-8496-bc87cc714105','c1132067-41f7-445b-8496-bc87cc714105','c1132067-41f7-445b-8496-bc87cc714105','c1132067-41f7-445b-8496-bc87cc714105',72,'10-Feb-2020','2020-02-10 09:00:00','2020-02-10 05:00:00','comments','10-Feb-2020','10-Feb-2020','419fc2df-d3e5-46a9-8954-46cc725b8276');
INSERT INTO timesheet_entry("projectRfxId", "projectId", "rfxPhaseId", "userId", "hoursBilled", "entryDate", "startTime", "endTime", "comments", "dateCreated", "dateModified", "timesheetId") VALUES('6b7c0c3e-773c-4653-8845-258f8e238d27','6b7c0c3e-773c-4653-8845-258f8e238d27','6b7c0c3e-773c-4653-8845-258f8e238d27','6b7c0c3e-773c-4653-8845-258f8e238d27',72,'10-Feb-2020','2020-02-10 09:00:00','2020-02-10 05:00:00','comments','10-Feb-2020','10-Feb-2020','1e4529fc-7c94-440e-9de7-bd173c4dd54b');
INSERT INTO timesheet_entry("projectRfxId", "projectId", "rfxPhaseId", "userId", "hoursBilled", "entryDate", "startTime", "endTime", "comments", "dateCreated", "dateModified", "timesheetId") VALUES('a43c1eda-df27-495a-a1c5-91bd20d1964e','a43c1eda-df27-495a-a1c5-91bd20d1964e','a43c1eda-df27-495a-a1c5-91bd20d1964e','a43c1eda-df27-495a-a1c5-91bd20d1964e',72,'10-Feb-2020','2020-02-10 09:00:00','2020-02-10 05:00:00','comments','10-Feb-2020','10-Feb-2020','46d1bcc6-31a1-4103-a836-ef02e4c2ba1c');
INSERT INTO timesheet_entry("projectRfxId", "projectId", "rfxPhaseId", "userId", "hoursBilled", "entryDate", "startTime", "endTime", "comments", "dateCreated", "dateModified", "timesheetId") VALUES('6b9fe57a-f5db-41de-bdd6-86242d6d136f','6b9fe57a-f5db-41de-bdd6-86242d6d136f','6b9fe57a-f5db-41de-bdd6-86242d6d136f','6b9fe57a-f5db-41de-bdd6-86242d6d136f',72,'10-Feb-2020','2020-02-10 09:00:00','2020-02-10 05:00:00','comments','10-Feb-2020','10-Feb-2020','58ceb94f-03bb-428c-853a-01b9a64a674e');
INSERT INTO timesheet_entry("projectRfxId", "projectId", "rfxPhaseId", "userId", "hoursBilled", "entryDate", "startTime", "endTime", "comments", "dateCreated", "dateModified", "timesheetId") VALUES('81bc6dba-d7ba-4340-b49c-f111ae740b92','81bc6dba-d7ba-4340-b49c-f111ae740b92','81bc6dba-d7ba-4340-b49c-f111ae740b92','81bc6dba-d7ba-4340-b49c-f111ae740b92',72,'10-Feb-2020','2020-02-10 09:00:00','2020-02-10 05:00:00','comments','10-Feb-2020','10-Feb-2020','d8456604-262a-4982-9cae-3c3b465eab54');
INSERT INTO timesheet_entry("projectRfxId", "projectId", "rfxPhaseId", "userId", "hoursBilled", "entryDate", "startTime", "endTime", "comments", "dateCreated", "dateModified", "timesheetId") VALUES('c86e37d7-b4e3-4689-96ac-d2e53a667f56','c86e37d7-b4e3-4689-96ac-d2e53a667f56','c86e37d7-b4e3-4689-96ac-d2e53a667f56','c86e37d7-b4e3-4689-96ac-d2e53a667f56',72,'10-Feb-2020','2020-02-10 09:00:00','2020-02-10 05:00:00','comments','10-Feb-2020','10-Feb-2020','e1377125-4c23-4eef-a599-85e7bbbdaac6');
INSERT INTO timesheet_entry("projectRfxId", "projectId", "rfxPhaseId", "userId", "hoursBilled", "entryDate", "startTime", "endTime", "comments", "dateCreated", "dateModified", "timesheetId") VALUES('0548785a-d148-40f1-9dde-16a8881a7563','0548785a-d148-40f1-9dde-16a8881a7563','0548785a-d148-40f1-9dde-16a8881a7563','0548785a-d148-40f1-9dde-16a8881a7563',72,'10-Feb-2020','2020-02-10 09:00:00','2020-02-10 05:00:00','comments','10-Feb-2020','10-Feb-2020','39ae868f-4cff-42f5-a849-21db1c65ae2c');
INSERT INTO timesheet_entry("projectRfxId", "projectId", "rfxPhaseId", "userId", "hoursBilled", "entryDate", "startTime", "endTime", "comments", "dateCreated", "dateModified", "timesheetId") VALUES('9e8cc765-cf76-40d9-bee8-e2f3f030cdb1','9e8cc765-cf76-40d9-bee8-e2f3f030cdb1','9e8cc765-cf76-40d9-bee8-e2f3f030cdb1','9e8cc765-cf76-40d9-bee8-e2f3f030cdb1',72,'10-Feb-2020','2020-02-10 09:00:00','2020-02-10 05:00:00','comments','10-Feb-2020','10-Feb-2020','0c2b78c8-faa5-4cb0-ad26-1c88b9cb4d09');