-
Notifications
You must be signed in to change notification settings - Fork 0
/
export.surql
401 lines (309 loc) · 30.4 KB
/
export.surql
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
-- ------------------------------
-- OPTION
-- ------------------------------
OPTION IMPORT;
-- ------------------------------
-- SCOPES
-- ------------------------------
DEFINE SCOPE admin SESSION 1d SIGNIN (SELECT ->login->admin.id AS id FROM user WHERE email = $email AND crypto::argon2::compare(password, $password) SPLIT ON id);
DEFINE SCOPE student SESSION 1d SIGNIN (SELECT ->login->student.id AS id FROM user WHERE email = $email AND crypto::argon2::compare(password, $password) SPLIT ON id);
DEFINE SCOPE teacher SESSION 1d SIGNIN (SELECT ->login->teacher.id AS id FROM user WHERE email = $email AND crypto::argon2::compare(password, $password) SPLIT ON id);
-- ------------------------------
-- TABLE: admin
-- ------------------------------
DEFINE TABLE admin SCHEMAFULL;
DEFINE FIELD blood_group ON admin TYPE string ASSERT $value INSIDE ['A+', 'B+', 'AB+', 'O+', 'A-', 'B-', 'AB-', 'O-'];
DEFINE FIELD department ON admin TYPE record(department) ASSERT $value != NONE;
DEFINE FIELD designation ON admin TYPE string ASSERT $value != NONE AND $value = /^[A-Za-z. ]+$/ AND string::len($value) >= 3;
DEFINE FIELD email ON admin TYPE object;
DEFINE FIELD email.academic ON admin TYPE string ASSERT $value != NONE AND is::email($value) AND parse::email::host($value) = 'sust.edu' AND parse::email::user($value) >= 3;
DEFINE FIELD email.personal ON admin TYPE string ASSERT $value != NONE AND is::email($value);
DEFINE FIELD gender ON admin TYPE string ASSERT $value INSIDE ['male', 'female'];
DEFINE FIELD id ON admin TYPE string;
DEFINE FIELD name ON admin TYPE string ASSERT $value != NONE AND $value = /^[A-Za-z. ]+$/ AND string::len($value) >= 3;
DEFINE FIELD personal ON admin TYPE object;
DEFINE FIELD personal.birthday ON admin TYPE datetime ASSERT $value != NONE AND time::year($value) < time::year() - 15;
DEFINE FIELD personal.father ON admin TYPE string ASSERT $value != NONE AND $value = /^[A-Za-z. ]+$/ AND string::len($value) >= 3;
DEFINE FIELD personal.hometown ON admin TYPE string ASSERT $value != NONE AND $value = /^[A-Za-z, ]+$/ AND string::len($value) >= 3;
DEFINE FIELD personal.mother ON admin TYPE string ASSERT $value != NONE AND $value = /^[A-Za-z. ]+$/ AND string::len($value) >= 3;
DEFINE FIELD personal.phone ON admin TYPE string;
DEFINE INDEX academic_email ON admin FIELDS email.academic UNIQUE;
DEFINE INDEX personal_email ON admin FIELDS email.personal UNIQUE;
DEFINE INDEX phone ON admin FIELDS personal.phone UNIQUE;
-- ------------------------------
-- TABLE: course
-- ------------------------------
DEFINE TABLE course SCHEMAFULL;
DEFINE FIELD course_code ON course TYPE string VALUE meta::id(id);
DEFINE FIELD credit ON course TYPE float ASSERT $value != NONE AND $value > 0 AND $value <= 4;
DEFINE FIELD department ON course TYPE record(department) ASSERT $value != NONE;
DEFINE FIELD name ON course TYPE string ASSERT $value != NONE AND $value = /^[A-Za-z ]+$/ AND string::len($value) > 5;
DEFINE FIELD syllabus ON course TYPE array;
DEFINE FIELD syllabus[*] ON course TYPE object;
DEFINE FIELD syllabus[*].title ON course TYPE string ASSERT $value != NONE AND $value = /^[A-Za-z ,&0-9]+$/ AND string::len($value) > 5;
DEFINE FIELD syllabus[*].topics ON course TYPE array;
DEFINE FIELD syllabus[*].topics[*] ON course TYPE string ASSERT $value != NONE AND string::len($value) > 5;
DEFINE FIELD type ON course TYPE string ASSERT $value INSIDE ['Lab', 'Theory', 'Thesis'];
DEFINE INDEX name ON course FIELDS name UNIQUE;
-- ------------------------------
-- TABLE: dailyroutine
-- ------------------------------
DEFINE TABLE dailyroutine SCHEMAFULL;
DEFINE FIELD building ON dailyroutine TYPE string ASSERT $value != NONE;
DEFINE FIELD date ON dailyroutine TYPE datetime ASSERT $value != NONE;
DEFINE FIELD duration ON dailyroutine TYPE string ASSERT $value INSIDE ['1hr', '2hr', 3hr];
DEFINE FIELD room ON dailyroutine TYPE string ASSERT $value != NONE;
DEFINE FIELD time ON dailyroutine TYPE number ASSERT $value != NONE AND $value >= 8 AND $value <= 18;
-- ------------------------------
-- TABLE: department
-- ------------------------------
DEFINE TABLE department SCHEMAFULL;
DEFINE FIELD building ON department TYPE string ASSERT $value != NONE AND string::len($value) > 0;
DEFINE FIELD code ON department TYPE number ASSERT $value != NONE AND $value >= 100 AND $value <= 999 AND math::round($value) = $value;
DEFINE FIELD floor ON department TYPE number ASSERT $value != NONE AND $value > 0 AND $value <= 10 AND math::round($value) = $value;
DEFINE FIELD letter_code ON department TYPE string ASSERT $value != NONE AND string::len($value) = 3 AND $value = /[A-Z]{3}/;
DEFINE FIELD minor_course_code ON department TYPE string ASSERT $value != NONE AND $value = /[A-Z]{1}/ AND string::len($value) == 1;
DEFINE FIELD name ON department TYPE string ASSERT $value != NONE AND $value = /^[A-Za-z ]+$/ AND string::len($value) > 5;
DEFINE INDEX code ON department FIELDS code UNIQUE;
DEFINE INDEX letter_code ON department FIELDS letter_code UNIQUE;
DEFINE INDEX minor_course_code ON department FIELDS minor_course_code UNIQUE;
DEFINE INDEX name ON department FIELDS name UNIQUE;
-- ------------------------------
-- TABLE: follows
-- ------------------------------
DEFINE TABLE follows SCHEMALESS PERMISSIONS NONE;
-- ------------------------------
-- TABLE: has
-- ------------------------------
DEFINE TABLE has SCHEMALESS PERMISSIONS NONE;
-- ------------------------------
-- TABLE: having
-- ------------------------------
DEFINE TABLE having SCHEMALESS PERMISSIONS NONE;
-- ------------------------------
-- TABLE: login
-- ------------------------------
DEFINE TABLE login SCHEMALESS PERMISSIONS NONE;
-- ------------------------------
-- TABLE: offers
-- ------------------------------
DEFINE TABLE offers SCHEMALESS PERMISSIONS NONE;
-- ------------------------------
-- TABLE: post
-- ------------------------------
DEFINE TABLE post SCHEMAFULL;
DEFINE FIELD description ON post TYPE string ASSERT $value != NONE;
DEFINE FIELD info ON post TYPE object;
DEFINE FIELD info.date ON post TYPE datetime ASSERT $value != NONE;
DEFINE FIELD info.posted_by ON post TYPE record(teacher) ASSERT $value != NONE;
DEFINE FIELD info.title ON post TYPE string ASSERT $value != NONE;
DEFINE FIELD pdf ON post TYPE string;
-- ------------------------------
-- TABLE: resource
-- ------------------------------
DEFINE TABLE resource SCHEMAFULL;
DEFINE FIELD date ON resource TYPE datetime ASSERT $value != NONE;
DEFINE FIELD link ON resource TYPE string ASSERT $value != NONE;
DEFINE FIELD posted_by ON resource TYPE record(student, admin, teacher) ASSERT $value != NONE;
DEFINE FIELD title ON resource TYPE string ASSERT $value != NONE;
-- ------------------------------
-- TABLE: routine
-- ------------------------------
DEFINE TABLE routine SCHEMAFULL;
DEFINE FIELD building ON routine TYPE string ASSERT $value != NONE;
DEFINE FIELD duration ON routine TYPE string ASSERT $value INSIDE ['1hr', '2hr', 3hr];
DEFINE FIELD room ON routine TYPE string ASSERT $value != NONE;
DEFINE FIELD time ON routine TYPE number ASSERT $value != NONE AND $value >= 8 AND $value <= 17;
-- ------------------------------
-- TABLE: student
-- ------------------------------
DEFINE TABLE student SCHEMAFULL;
DEFINE FIELD blood_group ON student TYPE string ASSERT $value INSIDE ['A+', 'B+', 'AB+', 'O+', 'A-', 'B-', 'AB-', 'O-'];
DEFINE FIELD current_semester ON student TYPE number ASSERT $value != NONE AND $value >= 1 AND $value <= 8 AND math::round($value) = $value;
DEFINE FIELD department ON student TYPE record(department) ASSERT $value != NONE;
DEFINE FIELD email ON student TYPE object;
DEFINE FIELD email.academic ON student TYPE string ASSERT $value != NONE AND is::email($value) AND parse::email::host($value) = 'student.sust.edu' AND parse::email::user($value) >= 5 AND is::numeric(string::slice(parse::email::user($value), string::len(parse::email::user($value)) - 2, 2)) AND is::alpha(string::slice(parse::email::user($value), 0, string::len(parse::email::user($value)) - 2));
DEFINE FIELD email.personal ON student TYPE string ASSERT $value != NONE AND is::email($value);
DEFINE FIELD gender ON student TYPE string ASSERT $value INSIDE ['male', 'female'];
DEFINE FIELD id ON student TYPE string;
DEFINE FIELD name ON student TYPE string ASSERT $value != NONE AND $value = /^[A-Za-z. ]+$/ AND string::len($value) >= 3;
DEFINE FIELD personal ON student TYPE object;
DEFINE FIELD personal.birthday ON student TYPE datetime ASSERT $value != NONE AND time::year($value) < time::year() - 15;
DEFINE FIELD personal.father ON student TYPE string ASSERT $value != NONE AND $value = /^[A-Za-z. ]+$/ AND string::len($value) >= 3;
DEFINE FIELD personal.hometown ON student TYPE string ASSERT $value != NONE AND $value = /^[A-Za-z, ]+$/ AND string::len($value) >= 3;
DEFINE FIELD personal.mother ON student TYPE string ASSERT $value != NONE AND $value = /^[A-Za-z. ]+$/ AND string::len($value) >= 3;
DEFINE FIELD personal.phone ON student TYPE string;
DEFINE FIELD privilege ON student TYPE string ASSERT $value = NONE OR ($value = /^[A-Za-z. ]+$/ AND string::len($value) > 1);
DEFINE FIELD result ON student TYPE object;
DEFINE FIELD result.cgpa ON student TYPE float ASSERT $value == NONE OR $value >= 0 AND $value <= 4;
DEFINE FIELD result.grade ON student TYPE string ASSERT $value == NONE OR $value INSIDE ['A+', 'A', 'A-', 'B+', 'B', 'B-', 'C+', 'C', 'C-', 'F'];
DEFINE FIELD result.total_credit ON student TYPE float ASSERT $value == NONE OR $value >= 0 AND $value <= 160;
DEFINE FIELD session ON student TYPE number ASSERT $value != NONE AND $value >= 1980 AND $value <= time::year() AND math::round($value) = $value;
DEFINE INDEX academic_email ON student FIELDS email.academic UNIQUE;
DEFINE INDEX personal_email ON student FIELDS email.personal UNIQUE;
DEFINE INDEX phone ON student FIELDS personal.phone UNIQUE;
-- ------------------------------
-- TABLE: takes
-- ------------------------------
DEFINE TABLE takes SCHEMALESS PERMISSIONS NONE;
-- ------------------------------
-- TABLE: teacher
-- ------------------------------
DEFINE TABLE teacher SCHEMAFULL;
DEFINE FIELD blood_group ON teacher TYPE string ASSERT $value INSIDE ['A+', 'B+', 'AB+', 'O+', 'A-', 'B-', 'AB-', 'O-'];
DEFINE FIELD department ON teacher TYPE record(department) ASSERT $value != NONE;
DEFINE FIELD designation ON teacher TYPE string ASSERT $value INSIDE ['Lecturer', 'Assistant Professor', 'Professor'];
DEFINE FIELD email ON teacher TYPE object;
DEFINE FIELD email.academic ON teacher TYPE string ASSERT $value != NONE AND is::email($value) AND parse::email::host($value) = 'sust.edu' AND parse::email::user($value) >= 3;
DEFINE FIELD email.personal ON teacher TYPE string ASSERT $value != NONE AND is::email($value);
DEFINE FIELD gender ON teacher TYPE string ASSERT $value INSIDE ['male', 'female'];
DEFINE FIELD id ON teacher TYPE string;
DEFINE FIELD name ON teacher TYPE string ASSERT $value != NONE AND $value = /^[A-Za-z .]+$/ AND string::len($value) >= 3;
DEFINE FIELD personal ON teacher TYPE object;
DEFINE FIELD personal.birthday ON teacher TYPE datetime ASSERT $value != NONE AND time::year($value) < time::year() - 15;
DEFINE FIELD personal.father ON teacher TYPE string ASSERT $value != NONE AND $value = /^[A-Za-z .]+$/ AND string::len($value) >= 3;
DEFINE FIELD personal.hometown ON teacher TYPE string ASSERT $value != NONE AND $value = /^[A-Za-z, ]+$/ AND string::len($value) >= 3;
DEFINE FIELD personal.mother ON teacher TYPE string ASSERT $value != NONE AND $value = /^[A-Za-z .]+$/ AND string::len($value) >= 3;
DEFINE FIELD personal.phone ON teacher TYPE string;
DEFINE INDEX academic_email ON teacher FIELDS email.academic UNIQUE;
DEFINE INDEX personal_email ON teacher FIELDS email.personal UNIQUE;
DEFINE INDEX phone ON teacher FIELDS personal.phone UNIQUE;
-- ------------------------------
-- TABLE: teaches
-- ------------------------------
DEFINE TABLE teaches SCHEMALESS PERMISSIONS NONE;
-- ------------------------------
-- TABLE: user
-- ------------------------------
DEFINE TABLE user SCHEMAFULL;
DEFINE FIELD email ON user TYPE string ASSERT $value != NONE AND is::email($value);
DEFINE FIELD password ON user TYPE string ASSERT $value != NONE;
DEFINE INDEX email ON user FIELDS email UNIQUE;
-- ------------------------------
-- TRANSACTION
-- ------------------------------
BEGIN TRANSACTION;
-- ------------------------------
-- TABLE DATA: admin
-- ------------------------------
UPDATE admin:2019331002 CONTENT { blood_group: 'B+', department: department:CSE, designation: 'Assistant Something', email: { academic: 'mufassir@sust.edu', personal: 'mac2221@gmail.com' }, gender: 'male', id: admin:2019331002, name: 'Mr. Xx', personal: { birthday: '2001-07-10T07:18:52Z', father: 'Mr. X', hometown: 'Sylhet', mother: 'Mrs. Y', phone: '01771144309' } };
UPDATE admin:2019331004 CONTENT { blood_group: 'B+', department: department:CSE, designation: 'Assistant Something', email: { academic: 'mrx@sust.edu', personal: 'mac22214u@gmail.com' }, gender: 'male', id: admin:2019331004, name: 'Mr. X', personal: { birthday: '2001-07-10T07:18:52Z', father: 'Mr. X', hometown: 'Sylhet', mother: 'Mrs. Y', phone: '01771144308' } };
-- ------------------------------
-- TABLE DATA: course
-- ------------------------------
UPDATE course:CSE222 CONTENT { course_code: 'CSE222', credit: 3, department: department:CSE, id: course:CSE222, name: 'Computer Science', syllabus: [{ title: 'Topic 1', topics: ['Discussion', 'Something other than that'] }, { title: 'Topic 2', topics: ['Discussion2', 'Something other than that'] }], type: 'Theory' };
UPDATE course:CSE330 CONTENT { course_code: 'CSE330', credit: 2, department: department:CSE, id: course:CSE330, name: 'Web Tech', syllabus: [{ title: 'Topic 1', topics: ['Discussion', 'Something other than that'] }, { title: 'Topic 2', topics: ['Discussion2', 'Something other than that'] }], type: 'Lab' };
-- ------------------------------
-- TABLE DATA: dailyroutine
-- ------------------------------
UPDATE dailyroutine:ndeb82uxfmwgybsuk2md CONTENT { building: 'IICT', date: '2023-08-24T19:32:45.564948Z', duration: '1hr', id: dailyroutine:ndeb82uxfmwgybsuk2md, room: 'G-2', time: 14 };
-- ------------------------------
-- TABLE DATA: department
-- ------------------------------
UPDATE department:CSE CONTENT { building: 'Dr. M. A. Wazed Miah IICT Building', code: 331, floor: 3, id: department:CSE, letter_code: 'CSE', minor_course_code: 'D', name: 'Computer Science and Engineering' };
UPDATE department:ECO CONTENT { building: 'D', code: 330, floor: 3, id: department:ECO, letter_code: 'ECO', minor_course_code: 'B', name: 'Economics' };
UPDATE department:PHY CONTENT { building: 'A', code: 132, floor: 1, id: department:PHY, letter_code: 'PHY', minor_course_code: 'C', name: 'Physics' };
UPDATE department:SWE CONTENT { building: 'Dr. M. A. Wazed Miah IICT Building', code: 123, floor: 1, id: department:SWE, letter_code: 'SWE', minor_course_code: 'A', name: 'Software Engineering' };
-- ------------------------------
-- TABLE DATA: follows
-- ------------------------------
RELATE course:CSE330 -> follows:13wrgnxgn193h41lex3a -> routine:196j2rikt9dgikhpuelv CONTENT { __: true, day: 'Wednesday', id: follows:13wrgnxgn193h41lex3a, in: course:CSE330, out: routine:196j2rikt9dgikhpuelv, year: '2023' };
RELATE course:CSE222 -> follows:4gyn6go2nt1z45jw91bc -> routine:0890gz6xvnjc5oc9cgfc CONTENT { __: true, day: 'Monday', id: follows:4gyn6go2nt1z45jw91bc, in: course:CSE222, out: routine:0890gz6xvnjc5oc9cgfc, year: '2023' };
RELATE course:CSE222 -> follows:5r64y6ulhrhdf8zapyax -> routine:0890gz6xvnjc5oc9cgfc CONTENT { __: true, day: 'Sunday', id: follows:5r64y6ulhrhdf8zapyax, in: course:CSE222, out: routine:0890gz6xvnjc5oc9cgfc, year: '2023' };
-- ------------------------------
-- TABLE DATA: has
-- ------------------------------
RELATE course:CSE222 -> has:gdwh0a4n59m0wa8wukzk -> resource:a2lphbzcgp5ki4xe5jtv CONTENT { __: true, id: has:gdwh0a4n59m0wa8wukzk, in: course:CSE222, out: resource:a2lphbzcgp5ki4xe5jtv, type: 'Video', year: '2023' };
RELATE course:CSE222 -> has:rxpwnox0962wrglsgb3m -> resource:5072z1qsmtzt96uave4x CONTENT { __: true, id: has:rxpwnox0962wrglsgb3m, in: course:CSE222, out: resource:5072z1qsmtzt96uave4x, type: 'Video', year: '2023' };
RELATE course:CSE222 -> has:tzzuw2ajfnjiakvlet0s -> resource:7cjcpi6sqgr8pi1typmx CONTENT { __: true, id: has:tzzuw2ajfnjiakvlet0s, in: course:CSE222, out: resource:7cjcpi6sqgr8pi1typmx, type: 'Pdf', year: '2023' };
RELATE course:CSE222 -> has:ypkepaluk8sy26hugxh2 -> post:vuc687jrwp2014xl18mf CONTENT { __: true, id: has:ypkepaluk8sy26hugxh2, in: course:CSE222, out: post:vuc687jrwp2014xl18mf, year: '2023' };
-- ------------------------------
-- TABLE DATA: having
-- ------------------------------
RELATE course:CSE330 -> having:syn88tvte55ce3zxzvv8 -> dailyroutine:ndeb82uxfmwgybsuk2md CONTENT { __: true, id: having:syn88tvte55ce3zxzvv8, in: course:CSE330, out: dailyroutine:ndeb82uxfmwgybsuk2md };
-- ------------------------------
-- TABLE DATA: login
-- ------------------------------
RELATE user:emfrsjin5aql5nbu2cnz -> login:0rmjsdqk2j0v0qq2thwv -> student:2023119144 CONTENT { __: true, id: login:0rmjsdqk2j0v0qq2thwv, in: user:emfrsjin5aql5nbu2cnz, out: student:2023119144 };
RELATE user:ws6uynksgs1kdr07b3r8 -> login:1sjkmi7o2a9f98a978gi -> teacher:2019331073 CONTENT { __: true, id: login:1sjkmi7o2a9f98a978gi, in: user:ws6uynksgs1kdr07b3r8, out: teacher:2019331073 };
RELATE user:xz5o4prrbak776nivu4a -> login:2or2pea30ymoa6ko5905 -> student:2019331013 CONTENT { __: true, id: login:2or2pea30ymoa6ko5905, in: user:xz5o4prrbak776nivu4a, out: student:2019331013 };
RELATE user:4p3m8nugy0lspbz2mxr8 -> login:74aiw92bacx0k2zvodbu -> student:2022998101 CONTENT { __: true, id: login:74aiw92bacx0k2zvodbu, in: user:4p3m8nugy0lspbz2mxr8, out: student:2022998101 };
RELATE user:aasa01kbaknch7ol17w7 -> login:a6j4uyrajbtxp64xegnp -> student:2019331073 CONTENT { __: true, id: login:a6j4uyrajbtxp64xegnp, in: user:aasa01kbaknch7ol17w7, out: student:2019331073 };
RELATE user:pi75cobhfzu0xp5ex832 -> login:ad56liuqu1nfkj275cz5 -> student:2022887055 CONTENT { __: true, id: login:ad56liuqu1nfkj275cz5, in: user:pi75cobhfzu0xp5ex832, out: student:2022887055 };
RELATE user:yycl51qmt5pz4gn798ct -> login:aqrods5pwrwjmz61kdq5 -> student:2022336011 CONTENT { __: true, id: login:aqrods5pwrwjmz61kdq5, in: user:yycl51qmt5pz4gn798ct, out: student:2022336011 };
RELATE user:emfrsjin5aql5nbu2cnz -> login:fc5fhrxvg2lqqfouq513 -> student:2023119144 CONTENT { __: true, id: login:fc5fhrxvg2lqqfouq513, in: user:emfrsjin5aql5nbu2cnz, out: student:2023119144 };
RELATE user:d9pu7wrq9qgg9ssojw78 -> login:jadeoaijybhx570kkrc3 -> admin:2019331002 CONTENT { __: true, id: login:jadeoaijybhx570kkrc3, in: user:d9pu7wrq9qgg9ssojw78, out: admin:2019331002 };
RELATE user:3sx7fe9v6w58gag2b625 -> login:oh12q5ju4z4l60t2pn0a -> teacher:2016331033 CONTENT { __: true, id: login:oh12q5ju4z4l60t2pn0a, in: user:3sx7fe9v6w58gag2b625, out: teacher:2016331033 };
RELATE user:4p3m8nugy0lspbz2mxr8 -> login:pupihh1qmjmigs8dcjky -> student:2022998101 CONTENT { __: true, id: login:pupihh1qmjmigs8dcjky, in: user:4p3m8nugy0lspbz2mxr8, out: student:2022998101 };
RELATE user:hb4sfhwnejl13tkzhfpw -> login:s1ut92rd7ukzly37hbvr -> admin:2019331004 CONTENT { __: true, id: login:s1ut92rd7ukzly37hbvr, in: user:hb4sfhwnejl13tkzhfpw, out: admin:2019331004 };
RELATE user:nbe5cbdnq5fke193hw67 -> login:t9s83uozefinf9kpxtl4 -> student:2022447122 CONTENT { __: true, id: login:t9s83uozefinf9kpxtl4, in: user:nbe5cbdnq5fke193hw67, out: student:2022447122 };
-- ------------------------------
-- TABLE DATA: offers
-- ------------------------------
RELATE department:ECO -> offers:1jfzfa9qu33174ouv5nt -> course:CSE222 CONTENT { __: true, id: offers:1jfzfa9qu33174ouv5nt, in: department:ECO, out: course:CSE222, semester: 3, year: 2019 };
RELATE department:CSE -> offers:8nxc8n4apw6oblyng901 -> course:CSE330 CONTENT { __: true, id: offers:8nxc8n4apw6oblyng901, in: department:CSE, out: course:CSE330, semester: 12, year: 2019 };
RELATE department:CSE -> offers:stkue740iyvgmrklrtq7 -> course:CSE330 CONTENT { __: true, id: offers:stkue740iyvgmrklrtq7, in: department:CSE, out: course:CSE330, semester: 12, year: 2023 };
RELATE department:CSE -> offers:t5hazd30yi26x82u5n2l -> course:CSE222 CONTENT { __: true, id: offers:t5hazd30yi26x82u5n2l, in: department:CSE, out: course:CSE222, semester: 12, year: 2019 };
-- ------------------------------
-- TABLE DATA: post
-- ------------------------------
UPDATE post:vuc687jrwp2014xl18mf CONTENT { description: 'this is the first post', id: post:vuc687jrwp2014xl18mf, info: { date: '2023-08-25T15:16:34.956770300Z', posted_by: teacher:2019331073, title: 'First Post' }, pdf: '' };
-- ------------------------------
-- TABLE DATA: resource
-- ------------------------------
UPDATE resource:5072z1qsmtzt96uave4x CONTENT { date: '2023-08-25T14:46:55.308837600Z', id: resource:5072z1qsmtzt96uave4x, link: 'https://www.youtube.com/watch?v=C7WFwgDRStM&ab_channel=Fireship', posted_by: student:2019331013, title: 'Introduction to surrealdb' };
UPDATE resource:7cjcpi6sqgr8pi1typmx CONTENT { date: '2023-08-25T14:39:22.443165700Z', id: resource:7cjcpi6sqgr8pi1typmx, link: 'https://drive.google.com/file/d/1BoOMYnJTvUzBFGwZ7jfGzUgqc7NT5PSe/view?usp=drive_link', posted_by: student:2019331073, title: 'Database class note' };
UPDATE resource:a2lphbzcgp5ki4xe5jtv CONTENT { date: '2023-08-25T14:24:04.359252500Z', id: resource:a2lphbzcgp5ki4xe5jtv, link: 'https://www.youtube.com/watch?v=C7WFwgDRStM&ab_channel=Fireship', posted_by: student:2019331073, title: 'Introduction to surrealdb' };
UPDATE resource:q1bc9ex6a58avvsvldno CONTENT { date: '2023-08-25T14:12:16.412947700Z', id: resource:q1bc9ex6a58avvsvldno, link: 'https://www.youtube.com/watch?v=C7WFwgDRStM&ab_channel=Fireship', posted_by: student:2019331073, title: 'Introduction to surrealdb' };
-- ------------------------------
-- TABLE DATA: routine
-- ------------------------------
UPDATE routine:0890gz6xvnjc5oc9cgfc CONTENT { building: 'IICT', duration: '1hr', id: routine:0890gz6xvnjc5oc9cgfc, room: 'G-2', time: 9 };
UPDATE routine:0sv0qyprii255ccv1vfl CONTENT { building: 'IICT', duration: '2hr', id: routine:0sv0qyprii255ccv1vfl, room: '304', time: 10 };
UPDATE routine:196j2rikt9dgikhpuelv CONTENT { building: 'IICT', duration: '1hr', id: routine:196j2rikt9dgikhpuelv, room: 'G-2', time: 14 };
-- ------------------------------
-- TABLE DATA: student
-- ------------------------------
UPDATE student:2019331013 CONTENT { blood_group: 'A+', current_semester: 5, department: department:CSE, email: { academic: 'asanul13@student.sust.edu', personal: 'asanulhaquekiron@gmail.com' }, gender: 'male', id: student:2019331013, name: 'Asanul Haque Kiron', personal: { birthday: '2000-12-03T07:18:52Z', father: 'Md Mojammel Haque', hometown: 'Naogaon', mother: 'Most Ayasha Siddika', phone: '01771144309' }, result: { cgpa: 3.94, grade: 'A', total_credit: 160 }, session: 2019 };
UPDATE student:2019331073 CONTENT { blood_group: 'B+', current_semester: 5, department: department:CSE, email: { academic: 'mufassir73@student.sust.edu', personal: 'mac22214u@gmail.com' }, gender: 'male', id: student:2019331073, name: 'Mufassir Ahmad Chowdhury', personal: { birthday: '2001-07-10T07:18:52Z', father: 'Hafiz Md Mashhud Chowdhury', hometown: 'Sylhet', mother: 'Afsana Begum', phone: '01771144308' }, privilege: 'CR', result: { cgpa: 4, grade: 'A+', total_credit: 160 }, session: 2019 };
UPDATE student:2022336011 CONTENT { blood_group: 'AB-', current_semester: 1, department: department:CSE, email: { academic: 'amelia01@student.sust.edu', personal: 'amelia.harris@example.com' }, gender: 'female', id: student:2022336011, name: 'Amelia Harris', personal: { birthday: '2002-03-20T09:45:00Z', father: 'Christopher Harris', hometown: 'Atlanta', mother: 'Jessica Harris', phone: '1743210987' }, privilege: 'Student', result: { cgpa: 3.6, grade: 'A-', total_credit: 40 }, session: 2022 };
UPDATE student:2022447122 CONTENT { blood_group: 'B+', current_semester: 3, department: department:PHY, email: { academic: 'ethan02@student.sust.edu', personal: 'ethan.rahman@example.com' }, gender: 'male', id: student:2022447122, name: 'Ethan Rahman', personal: { birthday: '2001-05-15T11:30:00Z', father: 'Ahmed Rahman', hometown: 'Dhaka', mother: 'Nadia Rahman', phone: '1732109876' }, result: { cgpa: 3.5, grade: 'B+', total_credit: 75 }, session: 2022 };
UPDATE student:2022887055 CONTENT { blood_group: 'A-', current_semester: 2, department: department:ECO, email: { academic: 'sophia03@student.sust.edu', personal: 'sophia.ahmed@example.com' }, gender: 'female', id: student:2022887055, name: 'Sophia Ahmed', personal: { birthday: '2001-09-10T14:00:00Z', father: 'Kamal Ahmed', hometown: 'Chittagong', mother: 'Sara Ahmed', phone: '1754321098' }, privilege: 'Student', result: { cgpa: 3.8000000000000003, grade: 'A', total_credit: 60 }, session: 2022 };
UPDATE student:2022998101 CONTENT { blood_group: 'B-', current_semester: 4, department: department:SWE, email: { academic: 'arjun04@student.sust.edu', personal: 'arjun.chowdhury@example.com' }, gender: 'male', id: student:2022998101, name: 'Arjun Chowdhury', personal: { birthday: '2001-07-12T09:15:00Z', father: 'Rahim Chowdhury', hometown: 'Rajshahi', mother: 'Nasreen Chowdhury', phone: '1743210989' }, privilege: 'Student', result: { cgpa: 3.2, grade: 'B', total_credit: 100 }, session: 2022 };
UPDATE student:2023119144 CONTENT { blood_group: 'O+', current_semester: 5, department: department:PHY, email: { academic: 'amina05@student.sust.edu', personal: 'amina.islam@example.com' }, gender: 'female', id: student:2023119144, name: 'Amina Islam', personal: { birthday: '2001-10-08T10:00:00Z', father: 'Mohammed Islam', hometown: 'Khulna', mother: 'Fatima Islam', phone: '1732109877' }, result: { cgpa: 3.9000000000000004, grade: 'A', total_credit: 140 }, session: 2022 };
-- ------------------------------
-- TABLE DATA: takes
-- ------------------------------
RELATE student:2019331073 -> takes:2jepxv788in9t7t71q8g -> course:CSE330 CONTENT { __: true, id: takes:2jepxv788in9t7t71q8g, in: student:2019331073, out: course:CSE330, semester: 12, year: 2019 };
RELATE student:2019331013 -> takes:4tnahxcwnlgpj6l634dl -> course:CSE222 CONTENT { __: true, id: takes:4tnahxcwnlgpj6l634dl, in: student:2019331013, out: course:CSE222, semester: 12, year: 2019 };
RELATE student:2019331013 -> takes:cvq6uvnqf51c3vvuws97 -> course:CSE330 CONTENT { __: true, id: takes:cvq6uvnqf51c3vvuws97, in: student:2019331013, out: course:CSE330, semester: 12, year: 2019 };
-- ------------------------------
-- TABLE DATA: teacher
-- ------------------------------
UPDATE teacher:2016331033 CONTENT { blood_group: 'B+', department: department:CSE, designation: 'Lecturer', email: { academic: 'xyz@sust.edu', personal: 'xyzz@gmail.com' }, gender: 'male', id: teacher:2016331033, name: 'Mr. X', personal: { birthday: '2001-07-10T07:18:52Z', father: 'Mr. Y', hometown: 'Khulna', mother: 'Mrs. Z', phone: '1771144309' } };
UPDATE teacher:2019331073 CONTENT { blood_group: 'B+', department: department:CSE, designation: 'Lecturer', email: { academic: 'mufassir73@sust.edu', personal: 'mac22214u@gmail.com' }, gender: 'male', id: teacher:2019331073, name: 'Mufassir Ahmad Chowdhury', personal: { birthday: '2001-07-10T07:18:52Z', father: 'Hafiz Md Mashhud Chowdhury', hometown: 'Sylhet', mother: 'Afsana Begum', phone: '1771144308' } };
-- ------------------------------
-- TABLE DATA: teaches
-- ------------------------------
RELATE teacher:2016331033 -> teaches:j75b63mpllydx2sw17a1 -> offers:stkue740iyvgmrklrtq7 CONTENT { __: true, id: teaches:j75b63mpllydx2sw17a1, in: teacher:2016331033, out: offers:stkue740iyvgmrklrtq7 };
RELATE teacher:2016331033 -> teaches:lssw1xn2l0yjq9ut7xid -> offers:8nxc8n4apw6oblyng901 CONTENT { __: true, id: teaches:lssw1xn2l0yjq9ut7xid, in: teacher:2016331033, out: offers:8nxc8n4apw6oblyng901 };
RELATE teacher:2019331073 -> teaches:o94o6fvp390utzmery77 -> offers:1jfzfa9qu33174ouv5nt CONTENT { __: true, id: teaches:o94o6fvp390utzmery77, in: teacher:2019331073, out: offers:1jfzfa9qu33174ouv5nt };
RELATE teacher:2019331073 -> teaches:x700jf9ofic4o8lkfxnv -> offers:t5hazd30yi26x82u5n2l CONTENT { __: true, id: teaches:x700jf9ofic4o8lkfxnv, in: teacher:2019331073, out: offers:t5hazd30yi26x82u5n2l };
-- ------------------------------
-- TABLE DATA: user
-- ------------------------------
UPDATE user:3sx7fe9v6w58gag2b625 CONTENT { email: 'xyz@sust.edu', id: user:3sx7fe9v6w58gag2b625, password: '$argon2id$v=19$m=19456,t=2,p=1$7JLreAVwXh73ALGEEjjtXw$DwpTTl/o2TwlZoooQ+9AC8MqwFCmpiIeGt7T54HU3Jc' };
UPDATE user:4p3m8nugy0lspbz2mxr8 CONTENT { email: 'arjun04@student.sust.edu', id: user:4p3m8nugy0lspbz2mxr8, password: '$argon2id$v=19$m=19456,t=2,p=1$W1PLzntnQnQvHVBESwaonw$mqCDsNwfPF/A7Z0WjbkOUmObpzj6kb+QWQyAtoPi/cI' };
UPDATE user:aasa01kbaknch7ol17w7 CONTENT { email: 'mufassir73@student.sust.edu', id: user:aasa01kbaknch7ol17w7, password: '$argon2id$v=19$m=19456,t=2,p=1$c1fIG/sv0IV5k1UFScZVZg$92aoHf8Y/2wUWTBccYvJ1OmtbwkIAwCkaCksS3+w/b8' };
UPDATE user:d9pu7wrq9qgg9ssojw78 CONTENT { email: 'mufassir@sust.edu', id: user:d9pu7wrq9qgg9ssojw78, password: '$argon2id$v=19$m=19456,t=2,p=1$z9bb3s0hsj/Y4eFgiOYeDw$FvNIPOqc39RLOnm1tf3/oALeopjHBh5u8+kDi/BEuWI' };
UPDATE user:emfrsjin5aql5nbu2cnz CONTENT { email: 'amina05@student.sust.edu', id: user:emfrsjin5aql5nbu2cnz, password: '$argon2id$v=19$m=19456,t=2,p=1$YCAS684IJvTsmkv1vH2CjQ$orcHFgHMZnXhtA8mSKGAGZGEqN4vIN+ynAvvSYFtKWA' };
UPDATE user:hb4sfhwnejl13tkzhfpw CONTENT { email: 'mrx@sust.edu', id: user:hb4sfhwnejl13tkzhfpw, password: '$argon2id$v=19$m=19456,t=2,p=1$mzO2HyrwcGWzE9TxXkIwHA$UM3Ql1K5ekDY0/yVOC+eLMooNt+U1Oi/ULyI3jTVV8k' };
UPDATE user:nbe5cbdnq5fke193hw67 CONTENT { email: 'ethan02@student.sust.edu', id: user:nbe5cbdnq5fke193hw67, password: '$argon2id$v=19$m=19456,t=2,p=1$HkXP0cU6hzquhFhok8pdjg$4zkdcs9U/P36y14VFuIjBcHHZI/RVm/gvOi+J3GcdFQ' };
UPDATE user:pi75cobhfzu0xp5ex832 CONTENT { email: 'sophia03@student.sust.edu', id: user:pi75cobhfzu0xp5ex832, password: '$argon2id$v=19$m=19456,t=2,p=1$Vm/FqMc7u6x/PuctKb3Qmw$OaOC6GaD4LZu7+5x6163OOJ9jxNEo4y6DSSphcwioew' };
UPDATE user:ws6uynksgs1kdr07b3r8 CONTENT { email: 'mufassir73@sust.edu', id: user:ws6uynksgs1kdr07b3r8, password: '$argon2id$v=19$m=19456,t=2,p=1$mPBgfJGt3zXLfBgw7m4+4A$sG5wE599w7moglTaMHc5ERT8nJNg77mNhB61M91R1Qg' };
UPDATE user:xz5o4prrbak776nivu4a CONTENT { email: 'asanul13@student.sust.edu', id: user:xz5o4prrbak776nivu4a, password: '$argon2id$v=19$m=19456,t=2,p=1$bA8wPGQ2nVcvf29yRNdpVg$YlyMWq/crbG+rvpGk4IomFzYf2vnyDs0EtwFWlDXenQ' };
UPDATE user:yycl51qmt5pz4gn798ct CONTENT { email: 'amelia01@student.sust.edu', id: user:yycl51qmt5pz4gn798ct, password: '$argon2id$v=19$m=19456,t=2,p=1$G7HE7CxuzYIEOM4tfTzozQ$syRVMt8PCP9TSC2Ab678gIz+HGs16Ease/YgZQ4Fo1M' };
-- ------------------------------
-- TRANSACTION
-- ------------------------------
COMMIT TRANSACTION;