CREATE TABLE public.dolgozo (
    dkod numeric(4,0),
    dnev character varying(10),
    foglalkozas character varying(9),
    fonoke numeric(4,0),
    belepes date,
    fizetes numeric(7,2),
    jutalek numeric(7,2),
    oazon numeric(2,0)
);

--
-- Data for Name: dolgozo; Type: TABLE DATA; Schema: public;
--

INSERT INTO public.dolgozo VALUES (7369, 'SMITH', 'CLERK', 7902, '1980-12-17', 800.00, NULL, 20);
INSERT INTO public.dolgozo VALUES (7499, 'ALLEN', 'SALESMAN', 7698, '1981-02-20', 1600.00, 300.00, 30);
INSERT INTO public.dolgozo VALUES (7521, 'WARD', 'SALESMAN', 7698, '1981-02-22', 1250.00, 500.00, 30);
INSERT INTO public.dolgozo VALUES (7566, 'JONES', 'MANAGER', 7839, '1981-04-02', 2975.00, NULL, 20);
INSERT INTO public.dolgozo VALUES (7654, 'MARTIN', 'SALESMAN', 7698, '1981-09-28', 1250.00, 1400.00, 30);
INSERT INTO public.dolgozo VALUES (7698, 'BLAKE', 'MANAGER', 7839, '1981-05-01', 4250.00, NULL, 30);
INSERT INTO public.dolgozo VALUES (7782, 'CLARK', 'MANAGER', 7839, '1981-06-09', 2450.00, 200.00, 10);
INSERT INTO public.dolgozo VALUES (7788, 'SCOTT', 'ANALYST', 7566, '1982-12-09', 3000.00, NULL, 20);
INSERT INTO public.dolgozo VALUES (7839, 'KING', 'PRESIDENT', NULL, '1981-11-17', 5000.00, NULL, 10);
INSERT INTO public.dolgozo VALUES (7844, 'TURNER', 'SALESMAN', 7698, '1981-09-08', 1500.00, 10.00, 30);
INSERT INTO public.dolgozo VALUES (7876, 'ADAMS', 'CLERK', 7788, '1983-01-12', 1100.00, NULL, 20);
INSERT INTO public.dolgozo VALUES (7900, 'JAMES', 'CLERK', 7698, '1981-12-03', 950.00, NULL, 30);
INSERT INTO public.dolgozo VALUES (7902, 'FORD', 'ANALYST', 7566, '1981-12-03', 3000.00, 700.00, 20);
INSERT INTO public.dolgozo VALUES (7934, 'MILLER', 'CLERK', 7782, '1982-01-23', 1300.00, 600.00, 10);

 