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
|
# info about the structrure of the models
## user fields; insert / update sql queries
INSERT INTO user
( id,
prefix,
first_name,
last_name,
email,
father_name,
registration_number,
sector_id,
specialty,
belonging_school,
working_shcool,
position_type_id,
phone,
password,
expiration,
otp,
otp_expiration,
activation,
creation,
active) VALUES (:id,
:prefix,
:first_name,
:last_name,
:email,
:father_name,
:registration_number,
:sector_id,
:specialty,
:belonging_school,
:working_shcool,
:position_type_id,
:phone,
:password,
:expiration,
:otp,
:otp_expiration,
:activation,
:creation,
:active )
UPDATE user
SET prefix = :prefix,
first_name = :first_name,
last_name = :last_name,
email = :email,
father_name = :father_name,
registration_number = :registration_number,
sector_id = :sector_id,
specialty = :specialty,
belonging_school = :belonging_school,
working_shcool = :working_shcool,
position_type_id = :position_type_id,
phone = :phone,
password = :password,
expiration = :expiration,
otp = :otp,
otp_expiration = :otp_expiration,
activation = :activation,
creation = :creation,
active = :active,
## record_types
document forms -> json
request = {
user_id -> user: {
...
}
date: ...
body: ...
media: [ ... array of media-id(s) ]
}
penalty = {
user_id -> user: {
...
},
date:
time:
subject:
of_student:
place:
president:
members: [ list ]
reason:
apology:
decision:
}
## records
id
user_id
type
source_json
## record_media
record_id
media_id
|
