trainingFull/backup.sql at main · work-owlo/trainingFull · GitHub

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
CREATE TABLE IF NOT EXISTS public.auth_token
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    refresh_token text COLLATE pg_catalog."default" NOT NULL,
    access_token text COLLATE pg_catalog."default" NOT NULL,
    updated timestamp without time zone,
    CONSTRAINT auth_token_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.company
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    company_id text COLLATE pg_catalog."default" NOT NULL,
    company_name text COLLATE pg_catalog."default" NOT NULL,
    company_description text COLLATE pg_catalog."default" NOT NULL,
    status text COLLATE pg_catalog."default" NOT NULL,
    created timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
    updated timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT company_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.cookie
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    page_id text COLLATE pg_catalog."default" NOT NULL,
    cookie_name text COLLATE pg_catalog."default" NOT NULL,
    cookie_value text COLLATE pg_catalog."default" NOT NULL,
    parse_id text COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT cookie_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.element
(
    pk_val integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    id text COLLATE pg_catalog."default" NOT NULL,
    parse_id text COLLATE pg_catalog."default" NOT NULL,
    context text COLLATE pg_catalog."default",
    page_id text COLLATE pg_catalog."default" NOT NULL,
    to_page_id text COLLATE pg_catalog."default",
    form_id text COLLATE pg_catalog."default",
    element_value text COLLATE pg_catalog."default",
    element_type text COLLATE pg_catalog."default",
    element_subtype text COLLATE pg_catalog."default",
    width integer NOT NULL,
    height integer NOT NULL,
    x integer NOT NULL,
    y integer NOT NULL,
    id_val text COLLATE pg_catalog."default",
    placeholder text COLLATE pg_catalog."default",
    element_name text COLLATE pg_catalog."default",
    outerhtml text COLLATE pg_catalog."default",
    generated_value text COLLATE pg_catalog."default",
    deleted text COLLATE pg_catalog."default",
    created timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT element_pkey PRIMARY KEY (pk_val)
);

CREATE TABLE IF NOT EXISTS public.element_action
(
    action_id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    element_id text COLLATE pg_catalog."default" NOT NULL,
    action_type text COLLATE pg_catalog."default" NOT NULL,
    to_page_id text COLLATE pg_catalog."default",
    page_id text COLLATE pg_catalog."default" NOT NULL,
    id text COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT element_action_pkey PRIMARY KEY (action_id)
);

CREATE TABLE IF NOT EXISTS public.employee_user
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    user_id text COLLATE pg_catalog."default" NOT NULL,
    first_name text COLLATE pg_catalog."default" NOT NULL,
    last_name text COLLATE pg_catalog."default" NOT NULL,
    email text COLLATE pg_catalog."default" NOT NULL,
    status text COLLATE pg_catalog."default" NOT NULL,
    created timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
    updated timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT employee_user_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.form
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    parse_id text COLLATE pg_catalog."default" NOT NULL,
    page_id text COLLATE pg_catalog."default" NOT NULL,
    form_id text COLLATE pg_catalog."default" NOT NULL,
    action_name text COLLATE pg_catalog."default",
    action_link text COLLATE pg_catalog."default",
    context text COLLATE pg_catalog."default",
    outerhtml text COLLATE pg_catalog."default",
    created timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT form_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.invoice
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    invoice_id text COLLATE pg_catalog."default" NOT NULL,
    invoice_month integer NOT NULL,
    invoice_year integer NOT NULL,
    company_id text COLLATE pg_catalog."default" NOT NULL,
    compensation double precision NOT NULL,
    invoice_amount double precision NOT NULL,
    status text COLLATE pg_catalog."default" NOT NULL,
    created timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
    updated timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT invoice_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.job_roles
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    company_id text COLLATE pg_catalog."default" NOT NULL,
    role_id text COLLATE pg_catalog."default" NOT NULL,
    role_name text COLLATE pg_catalog."default" NOT NULL,
    role_description text COLLATE pg_catalog."default" NOT NULL,
    status text COLLATE pg_catalog."default" NOT NULL,
    created timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
    updated timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
    completion_rate double precision,
    average_score double precision,
    average_time double precision,
    CONSTRAINT job_roles_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.manager_permissions
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    user_id text COLLATE pg_catalog."default" NOT NULL,
    add_managers boolean DEFAULT false,
    edit_managers boolean DEFAULT false,
    delete_managers boolean DEFAULT false,
    read_managers boolean DEFAULT false,
    add_roles boolean DEFAULT false,
    edit_roles boolean DEFAULT false,
    delete_roles boolean DEFAULT false,
    add_shifts boolean DEFAULT false,
    edit_shifts boolean DEFAULT false,
    delete_shifts boolean DEFAULT false,
    edit_company boolean DEFAULT false,
    delete_company boolean DEFAULT false,
    created timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
    updated timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT manager_permissions_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.manager_user
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    user_id text COLLATE pg_catalog."default" NOT NULL,
    company_id text COLLATE pg_catalog."default",
    first_name text COLLATE pg_catalog."default" NOT NULL,
    last_name text COLLATE pg_catalog."default" NOT NULL,
    email text COLLATE pg_catalog."default" NOT NULL,
    status text COLLATE pg_catalog."default" NOT NULL,
    created timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
    updated timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT manager_user_pkey PRIMARY KEY (id)
);


CREATE TABLE IF NOT EXISTS public.page
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    parse_id text COLLATE pg_catalog."default" NOT NULL,
    page_url text COLLATE pg_catalog."default" NOT NULL,
    page_name text COLLATE pg_catalog."default",
    page_id text COLLATE pg_catalog."default" NOT NULL,
    page_hash text COLLATE pg_catalog."default",
    source_element_id text COLLATE pg_catalog."default",
    CONSTRAINT page_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.module
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    module_id text COLLATE pg_catalog."default" NOT NULL,
    company_id text COLLATE pg_catalog."default" NOT NULL,
    module_title text COLLATE pg_catalog."default" NOT NULL,
    module_description text COLLATE pg_catalog."default" NOT NULL,
    tool_id text COLLATE pg_catalog."default" NOT NULL,
    access text COLLATE pg_catalog."default" NOT NULL,
    module_text text COLLATE pg_catalog."default",
    num_chats text COLLATE pg_catalog."default",
    customer text COLLATE pg_catalog."default",
    situation text COLLATE pg_catalog."default",
    problem text COLLATE pg_catalog."default",
    respond text COLLATE pg_catalog."default",
    created timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT module_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.parse
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    company_id text COLLATE pg_catalog."default" NOT NULL,
    input_type text COLLATE pg_catalog."default" NOT NULL,
    parse_id text COLLATE pg_catalog."default" NOT NULL,
    website_url text COLLATE pg_catalog."default" NOT NULL,
    website_name text COLLATE pg_catalog."default" NOT NULL,
    website_description text COLLATE pg_catalog."default" NOT NULL,
    status text COLLATE pg_catalog."default" NOT NULL,
    parse_root_id text COLLATE pg_catalog."default",
    created timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT parse_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.query
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    query_id text COLLATE pg_catalog."default" NOT NULL,
    module_id text COLLATE pg_catalog."default",
    path_id text COLLATE pg_catalog."default",
    page_id integer,
    query text COLLATE pg_catalog."default",
    query_type text COLLATE pg_catalog."default" NOT NULL,
    prev_query_id text COLLATE pg_catalog."default",
    CONSTRAINT query_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.query_element
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    query_id text COLLATE pg_catalog."default" NOT NULL,
    query_element_id text COLLATE pg_catalog."default" NOT NULL,
    element_id text COLLATE pg_catalog."default" NOT NULL,
    element_type text COLLATE pg_catalog."default" NOT NULL,
    form_id text COLLATE pg_catalog."default",
    CONSTRAINT query_element_pkey PRIMARY KEY (id)
);


CREATE TABLE IF NOT EXISTS public.role_module
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    module_id text COLLATE pg_catalog."default" NOT NULL,
    role_id text COLLATE pg_catalog."default" NOT NULL,
    status text COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT role_module_pkey PRIMARY KEY (id)
);


CREATE TABLE IF NOT EXISTS public.role_tools
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    role_id text COLLATE pg_catalog."default" NOT NULL,
    tool_id text COLLATE pg_catalog."default" NOT NULL,
    status text COLLATE pg_catalog."default" NOT NULL,
    rt_id text COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT role_tools_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.screenshot
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    parse_id text COLLATE pg_catalog."default" NOT NULL,
    img_counter integer NOT NULL,
    node_id text COLLATE pg_catalog."default" NOT NULL,
    screenshot_name text COLLATE pg_catalog."default" NOT NULL,
    y integer NOT NULL,
    CONSTRAINT screenshot_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.section
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    section_id text COLLATE pg_catalog."default" NOT NULL,
    module_id text COLLATE pg_catalog."default" NOT NULL,
    section_title text COLLATE pg_catalog."default" NOT NULL,
    section_description text COLLATE pg_catalog."default" NOT NULL,
    minutes_to_complete double precision NOT NULL,
    training_order integer NOT NULL,
    created timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
    updated timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT section_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.select_option
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    parse_id text COLLATE pg_catalog."default" NOT NULL,
    element_id text COLLATE pg_catalog."default" NOT NULL,
    option_id text COLLATE pg_catalog."default" NOT NULL,
    option_value text COLLATE pg_catalog."default" NOT NULL,
    selected boolean NOT NULL,
    CONSTRAINT select_option_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.team
(
    employee_id text COLLATE pg_catalog."default",
    company_id text COLLATE pg_catalog."default",
    role_id text COLLATE pg_catalog."default" NOT NULL,
    employment_type text COLLATE pg_catalog."default" NOT NULL,
    status text COLLATE pg_catalog."default" NOT NULL,
    created timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
    id_input text COLLATE pg_catalog."default",
    first_name text COLLATE pg_catalog."default",
    last_name text COLLATE pg_catalog."default",
    email text COLLATE pg_catalog."default" NOT NULL,
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    team_id text COLLATE pg_catalog."default",
    CONSTRAINT team_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.tools
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    tool_id text COLLATE pg_catalog."default" NOT NULL,
    tool_name text COLLATE pg_catalog."default" NOT NULL,
    tool_icon text COLLATE pg_catalog."default" NOT NULL,
    status text COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT tools_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.training
(
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
    training_id text COLLATE pg_catalog."default" NOT NULL,
    team_id text COLLATE pg_catalog."default" NOT NULL,
    module_id text COLLATE pg_catalog."default" NOT NULL,
    query_id text COLLATE pg_catalog."default",
    response text COLLATE pg_catalog."default",
    responsetoresponse text COLLATE pg_catalog."default",
    training_status text COLLATE pg_catalog."default" NOT NULL,
    training_type text COLLATE pg_catalog."default",
    CONSTRAINT training_pkey PRIMARY KEY (id)
);