workerTrackApp_dump.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 16.4
-- Dumped by pg_dump version 16.4

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: department; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.department (
    id integer NOT NULL,
    name character varying(255),
    phone_number character varying(255) NOT NULL,
    CONSTRAINT department_name_check CHECK (((name)::text = ANY ((ARRAY['HR'::character varying, 'IT'::character varying])::text[])))
);


ALTER TABLE public.department OWNER TO postgres;

--
-- Name: department_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.department ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.department_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: employee; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.employee (
    id integer NOT NULL,
    first_name character varying(255) NOT NULL,
    last_name character varying(255) NOT NULL,
    start_date date NOT NULL,
    department_id integer NOT NULL
);


ALTER TABLE public.employee OWNER TO postgres;

--
-- Name: employee_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.employee ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.employee_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: role; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.role (
    id integer NOT NULL,
    name character varying(255),
    CONSTRAINT role_name_check CHECK (((name)::text = ANY ((ARRAY['USER'::character varying, 'ADMIN'::character varying])::text[])))
);


ALTER TABLE public.role OWNER TO postgres;

--
-- Name: role_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.role ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.role_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: user_roles; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.user_roles (
    user_id integer NOT NULL,
    role_id integer NOT NULL,
    users_id integer NOT NULL
);


ALTER TABLE public.user_roles OWNER TO postgres;

--
-- Name: users; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.users (
    id integer NOT NULL,
    first_name character varying(255) NOT NULL,
    last_name character varying(255) NOT NULL,
    password character varying(255) NOT NULL,
    username character varying(255) NOT NULL,
    employee_id integer NOT NULL
);


ALTER TABLE public.users OWNER TO postgres;

--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.users ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.users_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: work_log; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.work_log (
    id integer NOT NULL,
    chech_out_time time(6) without time zone NOT NULL,
    check_in_time time(6) without time zone NOT NULL,
    missing_time integer NOT NULL,
    over_time integer NOT NULL,
    work_date date NOT NULL,
    work_duration integer NOT NULL,
    employee_id integer NOT NULL
);


ALTER TABLE public.work_log OWNER TO postgres;

--
-- Name: work_log_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.work_log ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.work_log_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Data for Name: department; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.department (id, name, phone_number) FROM stdin;
1	IT	0362 523 22 22
2	HR	0362 523 44 44
\.


--
-- Data for Name: employee; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.employee (id, first_name, last_name, start_date, department_id) FROM stdin;
11	Ahmet	Yılmaz	2023-12-01	1
13	Mehmet	Duran	2023-09-07	1
14	Burak	Keskinli	2023-04-05	2
1	Yusuf Safa	Köksal	2023-10-01	1
25	Enes	Günaydın	2024-09-30	2
26	Mahmut	Erman	2024-08-08	1
28	Ahsen	Kılıç	2024-03-07	2
29	Ayşe	Yüksek	2023-06-16	1
30	Melis	İnce	2023-09-30	2
31	Ufuk	Keleş	2024-07-30	1
32	Necmettin	Çalık	2024-08-24	2
\.


--
-- Data for Name: role; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.role (id, name) FROM stdin;
1	ADMIN
2	USER
\.


--
-- Data for Name: user_roles; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.user_roles (user_id, role_id, users_id) FROM stdin;
1	1	1
1	2	1
\.


--
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.users (id, first_name, last_name, password, username, employee_id) FROM stdin;
1	Yusuf Safa	Köksal	$2a$10$lMbQ0v.3FgTABwymYRL41e3fr3av9ecKqd1UguD3LD/e.6C1aFiXW	yusufsafaa	1
3	Ahmet	Yılmaz	$2a$10$eUTbBOp3Eq2tUlJrn2OLoOvs0odcPzwh.nRJBptJ48kABVNA.VN9m	ahmety	11
\.


--
-- Data for Name: work_log; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.work_log (id, chech_out_time, check_in_time, missing_time, over_time, work_date, work_duration, employee_id) FROM stdin;
11	16:35:00	08:00:00	12	0	2024-09-02	468	1
12	18:34:00	08:00:00	0	25	2024-09-03	505	1
13	16:12:00	08:00:00	0	11	2024-09-04	491	1
14	16:54:00	08:00:00	0	1	2024-09-05	481	1
15	18:00:00	08:00:00	0	23	2024-09-06	503	1
16	16:21:00	08:00:00	0	13	2024-09-09	493	1
17	18:02:00	08:00:00	12	0	2024-09-10	468	1
18	17:21:00	08:00:00	0	45	2024-09-11	525	1
19	16:07:00	08:00:00	21	0	2024-09-12	459	1
20	16:57:00	08:00:00	0	7	2024-09-13	487	1
21	18:45:00	08:00:00	0	43	2024-09-16	523	1
22	16:19:00	08:00:00	10	0	2024-09-17	470	1
23	18:19:00	08:00:00	11	0	2024-09-18	469	1
24	16:14:00	08:00:00	0	57	2024-09-19	537	1
25	18:22:00	08:00:00	1	0	2024-09-20	479	1
26	17:02:00	08:00:00	0	20	2024-09-23	500	1
27	18:34:00	08:00:00	0	7	2024-09-24	487	1
28	17:25:00	08:00:00	0	59	2024-09-25	539	1
29	16:51:00	08:00:00	0	19	2024-09-26	499	1
30	17:04:00	08:00:00	7	0	2024-09-27	473	1
31	16:48:00	08:00:00	0	30	2024-09-30	510	1
32	18:59:00	08:00:00	1	0	2024-10-01	479	1
33	16:26:00	08:00:00	0	2	2024-10-02	482	1
34	18:02:00	08:00:00	15	0	2024-10-03	465	1
35	16:11:00	08:00:00	0	56	2024-10-04	536	1
36	16:20:00	08:00:00	0	40	2024-10-07	520	1
37	18:31:00	08:00:00	0	30	2024-10-08	510	1
38	17:46:00	08:00:00	0	29	2024-10-09	509	1
39	18:56:00	08:00:00	0	30	2024-10-10	510	1
40	16:56:00	08:00:00	3	0	2024-10-11	477	1
42	18:33:00	08:30:00	0	3	2024-09-02	483	11
43	18:46:00	08:30:00	0	35	2024-09-03	515	11
44	16:42:00	08:30:00	0	6	2024-09-04	486	11
45	18:36:00	08:30:00	0	41	2024-09-05	521	11
46	16:01:00	08:30:00	0	11	2024-09-06	491	11
47	18:41:00	08:30:00	22	0	2024-09-09	458	11
48	18:40:00	08:30:00	22	0	2024-09-10	458	11
49	16:50:00	08:30:00	0	15	2024-09-11	495	11
50	16:41:00	08:30:00	0	21	2024-09-12	501	11
51	17:23:00	08:30:00	5	0	2024-09-13	475	11
52	18:49:00	08:30:00	6	0	2024-09-16	474	11
53	17:09:00	08:30:00	0	54	2024-09-17	534	11
54	18:13:00	08:30:00	0	13	2024-09-18	493	11
55	17:46:00	08:30:00	24	0	2024-09-19	456	11
56	17:02:00	08:30:00	0	23	2024-09-20	503	11
57	17:27:00	08:30:00	0	12	2024-09-23	492	11
58	17:36:00	08:30:00	9	0	2024-09-24	471	11
59	18:24:00	08:30:00	0	5	2024-09-25	485	11
60	18:11:00	08:30:00	0	15	2024-09-26	495	11
61	18:55:00	08:30:00	0	10	2024-09-27	490	11
62	17:37:00	08:30:00	0	21	2024-09-30	501	11
63	17:55:00	08:30:00	29	0	2024-10-01	451	11
64	17:47:00	08:30:00	0	10	2024-10-02	490	11
65	16:18:00	08:30:00	0	29	2024-10-03	509	11
66	16:53:00	08:30:00	0	24	2024-10-04	504	11
67	18:18:00	08:30:00	0	36	2024-10-07	516	11
68	17:08:00	08:30:00	0	36	2024-10-08	516	11
69	17:19:00	08:30:00	13	0	2024-10-09	467	11
70	18:42:00	08:30:00	0	33	2024-10-10	513	11
111	17:30:00	08:30:00	0	0	2024-09-01	480	13
78	20:37:00	07:36:00	1234	123	2024-10-14	12	11
41	17:46:00	08:00:00	0	33	2024-10-14	513	1
112	17:45:00	08:45:00	0	15	2024-09-04	495	13
113	17:00:00	08:15:00	15	0	2024-09-05	465	13
114	17:30:00	08:30:00	0	0	2024-09-06	480	13
115	17:40:00	08:50:00	0	10	2024-09-07	490	13
116	17:10:00	08:30:00	20	0	2024-09-08	460	13
117	17:30:00	08:30:00	0	0	2024-09-11	480	13
118	17:40:00	08:20:00	0	20	2024-09-12	500	13
119	17:30:00	08:45:00	15	0	2024-09-13	465	13
120	17:30:00	08:30:00	0	0	2024-09-14	480	13
121	17:45:00	08:35:00	0	10	2024-09-15	490	13
122	17:10:00	08:30:00	20	0	2024-09-18	460	13
123	17:30:00	08:30:00	0	0	2024-09-19	480	13
124	17:50:00	08:20:00	0	30	2024-09-20	510	13
125	17:25:00	08:40:00	15	0	2024-09-21	465	13
126	17:30:00	08:30:00	0	0	2024-09-22	480	13
127	17:30:00	08:50:00	20	0	2024-09-25	460	13
128	17:30:00	08:30:00	0	0	2024-09-26	480	13
129	17:40:00	08:45:00	5	0	2024-09-27	475	13
130	17:30:00	08:30:00	0	0	2024-09-28	480	13
131	17:50:00	08:30:00	0	20	2024-09-29	500	13
132	17:30:00	08:30:00	0	0	2024-10-02	480	13
133	17:40:00	08:20:00	0	20	2024-10-03	500	13
134	17:25:00	08:35:00	10	0	2024-10-04	470	13
135	17:30:00	08:30:00	0	0	2024-10-05	480	13
136	17:45:00	08:30:00	0	15	2024-10-06	495	13
137	17:30:00	08:30:00	0	0	2024-10-09	480	13
138	17:50:00	08:25:00	0	25	2024-10-10	505	13
139	17:15:00	08:30:00	15	0	2024-10-11	465	13
140	17:30:00	08:30:00	0	0	2024-10-12	480	13
141	17:40:00	08:35:00	0	5	2024-10-13	485	13
142	17:30:00	08:30:00	0	0	2024-10-14	480	13
143	17:27:00	08:33:00	6	0	2024-09-02	474	14
144	17:50:00	08:20:00	0	30	2024-09-03	510	14
145	17:15:00	08:38:00	23	0	2024-09-04	457	14
146	17:45:00	08:35:00	0	10	2024-09-05	490	14
147	17:28:00	08:45:00	17	0	2024-09-06	463	14
148	17:30:00	08:30:00	0	0	2024-09-09	480	14
149	17:33:00	08:25:00	0	8	2024-09-10	488	14
150	17:42:00	08:50:00	8	0	2024-09-11	472	14
151	17:25:00	08:35:00	10	0	2024-09-12	470	14
152	17:45:00	08:30:00	0	15	2024-09-13	495	14
153	17:35:00	08:22:00	0	13	2024-09-16	493	14
154	17:17:00	08:30:00	13	0	2024-09-17	467	14
155	17:39:00	08:33:00	0	6	2024-09-18	486	14
156	17:28:00	08:30:00	2	0	2024-09-19	478	14
157	17:45:00	08:28:00	0	17	2024-09-20	497	14
158	17:24:00	08:33:00	9	0	2024-09-23	471	14
159	17:30:00	08:40:00	0	10	2024-09-24	490	14
160	17:25:00	08:36:00	11	0	2024-09-25	469	14
161	17:40:00	08:29:00	0	11	2024-09-26	491	14
162	17:22:00	08:31:00	9	0	2024-09-27	471	14
163	17:35:00	08:38:00	3	0	2024-09-30	477	14
164	17:47:00	08:33:00	0	14	2024-10-01	494	14
165	17:42:00	08:37:00	0	5	2024-10-02	485	14
166	17:20:00	08:32:00	12	0	2024-10-03	468	14
167	17:25:00	08:30:00	5	0	2024-10-04	475	14
168	17:35:00	08:40:00	5	0	2024-10-07	475	14
169	17:47:00	08:35:00	0	12	2024-10-08	492	14
170	17:34:00	08:28:00	0	6	2024-10-09	486	14
171	17:32:00	08:33:00	1	0	2024-10-10	479	14
172	17:43:00	08:34:00	0	9	2024-10-11	489	14
173	17:50:00	08:40:00	0	10	2024-10-14	490	14
174	17:28:00	08:35:00	7	0	2024-09-30	473	25
175	17:50:00	08:33:00	0	17	2024-10-01	497	25
176	17:35:00	08:44:00	9	0	2024-10-02	471	25
177	17:28:00	08:25:00	0	3	2024-10-03	483	25
178	17:35:00	08:45:00	10	0	2024-10-04	470	25
179	17:30:00	08:48:00	18	0	2024-10-07	462	25
180	17:50:00	08:22:00	0	28	2024-10-08	508	25
181	17:42:00	08:29:00	0	13	2024-10-09	493	25
182	17:30:00	08:30:00	0	0	2024-10-10	480	25
183	17:43:00	08:35:00	0	8	2024-10-11	488	25
184	17:30:00	08:28:00	0	2	2024-10-14	482	25
185	17:32:00	08:40:00	8	0	2024-09-02	472	26
186	17:48:00	08:15:00	0	33	2024-09-03	513	26
187	17:25:00	08:50:00	25	0	2024-09-04	455	26
188	17:40:00	08:30:00	0	10	2024-09-05	490	26
189	17:45:00	08:38:00	0	7	2024-09-06	487	26
190	17:30:00	08:30:00	0	0	2024-09-09	480	26
191	17:38:00	08:20:00	0	18	2024-09-10	498	26
192	17:42:00	08:35:00	0	7	2024-09-11	487	26
193	17:25:00	08:52:00	27	0	2024-09-12	453	26
194	17:48:00	08:42:00	0	6	2024-09-13	486	26
195	17:30:00	08:30:00	0	0	2024-09-16	480	26
196	17:38:00	08:28:00	0	10	2024-09-17	490	26
197	17:25:00	08:47:00	22	0	2024-09-18	458	26
198	17:42:00	08:25:00	0	17	2024-09-19	497	26
199	17:20:00	08:50:00	30	0	2024-09-20	450	26
200	17:28:00	08:30:00	2	0	2024-09-23	478	26
201	17:45:00	08:42:00	0	3	2024-09-24	483	26
202	17:28:00	08:34:00	6	0	2024-09-25	474	26
203	17:50:00	08:40:00	0	10	2024-09-26	490	26
204	17:33:00	08:20:00	0	13	2024-09-27	493	26
205	17:37:00	08:35:00	0	2	2024-09-30	482	26
206	17:42:00	08:28:00	0	14	2024-10-01	494	26
207	17:48:00	08:18:00	0	30	2024-10-02	510	26
208	17:30:00	08:30:00	0	0	2024-10-03	480	26
209	17:28:00	08:26:00	0	2	2024-10-04	482	26
210	17:33:00	08:35:00	2	0	2024-10-07	478	26
211	17:47:00	08:44:00	0	3	2024-10-08	483	26
212	17:35:00	08:22:00	0	13	2024-10-09	493	26
213	17:20:00	08:50:00	30	0	2024-10-10	450	26
214	17:35:00	08:35:00	0	0	2024-10-11	480	26
215	17:38:00	08:32:00	0	6	2024-10-14	486	26
216	17:40:00	08:20:00	0	20	2024-09-02	500	28
217	17:25:00	08:35:00	10	0	2024-09-03	470	28
218	17:30:00	08:30:00	0	0	2024-09-04	480	28
219	17:50:00	08:28:00	0	22	2024-09-05	502	28
220	17:25:00	08:50:00	25	0	2024-09-06	455	28
221	17:30:00	08:30:00	0	0	2024-09-09	480	28
222	17:35:00	08:20:00	0	15	2024-09-10	495	28
223	17:40:00	08:45:00	5	0	2024-09-11	475	28
224	17:50:00	08:30:00	0	20	2024-09-12	500	28
225	17:20:00	08:40:00	20	0	2024-09-13	460	28
226	17:30:00	08:30:00	0	0	2024-09-16	480	28
227	17:48:00	08:20:00	0	28	2024-09-17	508	28
228	17:38:00	08:42:00	0	16	2024-09-18	496	28
229	17:18:00	08:50:00	32	0	2024-09-19	448	28
230	17:40:00	08:35:00	0	5	2024-09-20	485	28
231	17:30:00	08:30:00	0	0	2024-09-23	480	28
232	17:30:00	08:25:00	0	5	2024-09-24	485	28
233	17:20:00	08:50:00	30	0	2024-09-25	450	28
234	17:50:00	08:30:00	0	20	2024-09-26	500	28
235	17:35:00	08:45:00	10	0	2024-09-27	470	28
236	17:50:00	08:35:00	0	15	2024-09-30	495	28
237	17:35:00	08:20:00	0	15	2024-10-01	495	28
238	17:30:00	08:30:00	0	0	2024-10-02	480	28
239	17:40:00	08:38:00	0	2	2024-10-03	482	28
240	17:35:00	08:45:00	10	0	2024-10-04	470	28
241	17:50:00	08:32:00	0	18	2024-10-07	498	28
242	17:18:00	08:50:00	32	0	2024-10-08	448	28
243	17:50:00	08:25:00	0	25	2024-10-09	505	28
244	17:20:00	08:30:00	10	0	2024-10-10	470	28
245	17:45:00	08:42:00	0	3	2024-10-11	483	28
246	17:40:00	08:30:00	0	10	2024-10-14	490	28
247	17:30:00	08:40:00	10	0	2024-09-02	470	29
248	17:40:00	08:25:00	0	15	2024-09-03	495	29
249	17:50:00	08:35:00	0	15	2024-09-04	495	29
250	17:20:00	08:28:00	28	0	2024-09-05	452	29
251	17:35:00	08:42:00	7	0	2024-09-06	473	29
252	17:18:00	08:50:00	32	0	2024-09-09	448	29
253	17:35:00	08:20:00	0	15	2024-09-10	495	29
254	17:30:00	08:30:00	0	0	2024-09-11	480	29
255	17:25:00	08:35:00	10	0	2024-09-12	470	29
256	17:38:00	08:28:00	0	10	2024-09-13	490	29
257	17:42:00	08:25:00	0	17	2024-09-16	497	29
258	17:20:00	08:45:00	25	0	2024-09-17	455	29
259	17:38:00	08:50:00	12	0	2024-09-18	468	29
260	17:50:00	08:30:00	0	20	2024-09-19	500	29
261	17:20:00	08:35:00	15	0	2024-09-20	465	29
262	17:30:00	08:30:00	0	0	2024-09-23	480	29
263	17:25:00	08:50:00	25	0	2024-09-24	455	29
264	17:28:00	08:38:00	10	0	2024-09-25	470	29
265	17:45:00	08:35:00	0	10	2024-09-26	490	29
266	17:20:00	08:30:00	10	0	2024-09-27	470	29
267	17:25:00	08:45:00	20	0	2024-09-30	460	29
268	17:35:00	08:25:00	0	10	2024-10-01	490	29
269	17:35:00	08:28:00	0	7	2024-10-02	487	29
270	17:30:00	08:30:00	0	0	2024-10-03	480	29
271	17:25:00	08:35:00	10	0	2024-10-04	470	29
272	17:35:00	08:50:00	15	0	2024-10-07	465	29
273	17:48:00	08:28:00	0	20	2024-10-08	500	29
274	17:45:00	08:30:00	0	15	2024-10-09	495	29
275	17:35:00	08:42:00	7	0	2024-10-10	473	29
276	17:30:00	08:25:00	0	5	2024-10-11	485	29
278	17:30:00	08:45:00	15	0	2024-09-02	465	30
279	17:25:00	08:30:00	5	0	2024-09-03	475	30
280	17:30:00	08:35:00	5	0	2024-09-04	475	30
281	17:50:00	08:28:00	0	22	2024-09-05	502	30
282	17:50:00	08:20:00	0	30	2024-09-06	510	30
283	17:35:00	08:35:00	0	0	2024-09-09	480	30
284	17:18:00	08:50:00	32	0	2024-09-10	448	30
285	17:45:00	08:25:00	0	20	2024-09-11	500	30
286	17:28:00	08:30:00	2	0	2024-09-12	478	30
287	17:42:00	08:28:00	0	14	2024-09-13	494	30
288	17:48:00	08:32:00	0	16	2024-09-16	496	30
289	17:45:00	08:35:00	0	10	2024-09-17	490	30
290	17:32:00	08:20:00	0	12	2024-09-18	492	30
291	17:28:00	08:30:00	2	0	2024-09-19	478	30
292	17:50:00	08:35:00	0	15	2024-09-20	495	30
293	17:18:00	08:50:00	32	0	2024-09-23	448	30
294	17:50:00	08:30:00	0	20	2024-09-24	500	30
295	17:25:00	08:45:00	20	0	2024-09-25	460	30
296	17:45:00	08:25:00	0	20	2024-09-26	500	30
297	17:40:00	08:30:00	0	10	2024-09-27	490	30
298	17:32:00	08:40:00	8	0	2024-09-30	472	30
299	17:40:00	08:28:00	0	12	2024-10-01	492	30
300	17:28:00	08:30:00	2	0	2024-10-02	478	30
301	17:38:00	08:32:00	0	6	2024-10-03	486	30
302	17:40:00	08:35:00	0	5	2024-10-04	485	30
303	17:42:00	08:28:00	0	14	2024-10-07	494	30
304	17:35:00	08:45:00	10	0	2024-10-08	470	30
305	17:38:00	08:50:00	12	0	2024-10-09	468	30
306	17:50:00	08:25:00	0	25	2024-10-10	505	30
307	17:28:00	08:42:00	14	0	2024-10-11	466	30
308	17:50:00	08:30:00	0	20	2024-10-14	500	30
309	17:50:00	08:40:00	0	30	2024-09-02	510	31
310	17:30:00	08:30:00	0	0	2024-09-03	480	31
311	17:50:00	08:25:00	0	25	2024-09-04	505	31
312	17:20:00	08:50:00	30	0	2024-09-05	450	31
313	17:38:00	08:42:00	4	0	2024-09-06	476	31
314	17:38:00	08:28:00	0	10	2024-09-09	490	31
315	17:50:00	08:30:00	0	20	2024-09-10	500	31
316	17:20:00	08:45:00	25	0	2024-09-11	455	31
317	17:42:00	08:32:00	0	10	2024-09-12	490	31
318	17:35:00	08:38:00	3	0	2024-09-13	477	31
319	17:20:00	08:35:00	15	0	2024-09-16	465	31
320	17:42:00	08:28:00	0	14	2024-09-17	494	31
321	17:35:00	08:30:00	0	5	2024-09-18	485	31
322	17:18:00	08:50:00	32	0	2024-09-19	448	31
323	17:50:00	08:25:00	0	25	2024-09-20	505	31
324	17:35:00	08:35:00	0	0	2024-09-23	480	31
325	17:30:00	08:30:00	0	0	2024-09-24	480	31
326	17:45:00	08:42:00	0	3	2024-09-25	483	31
327	17:20:00	08:50:00	30	0	2024-09-26	450	31
328	17:30:00	08:30:00	0	0	2024-09-27	480	31
329	17:35:00	08:42:00	7	0	2024-09-30	473	31
330	17:38:00	08:50:00	12	0	2024-10-01	468	31
331	17:38:00	08:25:00	0	13	2024-10-02	493	31
332	17:35:00	08:20:00	0	15	2024-10-03	495	31
333	17:45:00	08:28:00	0	17	2024-10-04	497	31
334	17:40:00	08:35:00	0	5	2024-10-07	485	31
335	17:32:00	08:32:00	0	0	2024-10-08	480	31
336	17:48:00	08:28:00	0	20	2024-10-09	500	31
337	17:30:00	08:50:00	20	0	2024-10-10	460	31
338	17:28:00	08:45:00	17	0	2024-10-11	463	31
339	17:30:00	08:20:00	0	10	2024-10-14	490	31
277	17:35:00	08:20:00	0	20	2024-10-14	500	29
\.


--
-- Name: department_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.department_id_seq', 1, false);


--
-- Name: employee_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.employee_id_seq', 32, true);


--
-- Name: role_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.role_id_seq', 2, true);


--
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.users_id_seq', 3, true);


--
-- Name: work_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.work_log_id_seq', 339, true);


--
-- Name: department department_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.department
    ADD CONSTRAINT department_pkey PRIMARY KEY (id);


--
-- Name: employee employee_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.employee
    ADD CONSTRAINT employee_pkey PRIMARY KEY (id);


--
-- Name: role role_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.role
    ADD CONSTRAINT role_pkey PRIMARY KEY (id);


--
-- Name: users ukd1s31g1a7ilra77m65xmka3ei; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT ukd1s31g1a7ilra77m65xmka3ei UNIQUE (employee_id);


--
-- Name: user_roles user_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_roles
    ADD CONSTRAINT user_roles_pkey PRIMARY KEY (user_id, role_id);


--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- Name: work_log work_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.work_log
    ADD CONSTRAINT work_log_pkey PRIMARY KEY (id);


--
-- Name: work_log fk4vadpdjjk6os2bovifaf0y5ne; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.work_log
    ADD CONSTRAINT fk4vadpdjjk6os2bovifaf0y5ne FOREIGN KEY (employee_id) REFERENCES public.employee(id);


--
-- Name: employee fkbejtwvg9bxus2mffsm3swj3u9; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.employee
    ADD CONSTRAINT fkbejtwvg9bxus2mffsm3swj3u9 FOREIGN KEY (department_id) REFERENCES public.department(id);


--
-- Name: users fkfndbe67uw6silwqnlyudtwqmo; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT fkfndbe67uw6silwqnlyudtwqmo FOREIGN KEY (employee_id) REFERENCES public.employee(id);


--
-- Name: user_roles fkhfh9dx7w3ubf1co1vdev94g3f; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_roles
    ADD CONSTRAINT fkhfh9dx7w3ubf1co1vdev94g3f FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: user_roles fkoovdgg7vvr1hb8vw6ivcrv3tb; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_roles
    ADD CONSTRAINT fkoovdgg7vvr1hb8vw6ivcrv3tb FOREIGN KEY (users_id) REFERENCES public.users(id);


--
-- Name: user_roles fkrhfovtciq1l558cw6udg0h0d3; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_roles
    ADD CONSTRAINT fkrhfovtciq1l558cw6udg0h0d3 FOREIGN KEY (role_id) REFERENCES public.role(id);


--
-- PostgreSQL database dump complete
--