CREATE TABLE public.organizations
(
    id bigint DEFAULT nextval('organizations_id_seq'::regclass) PRIMARY KEY NOT NULL,
    name varchar,
    parent_id bigint,
    created_at timestamp NOT NULL,
    updated_at timestamp NOT NULL,
    CONSTRAINT fk_rails_6551137b98 FOREIGN KEY (parent_id) REFERENCES public.organizations (id)
);
CREATE INDEX index_organizations_on_name ON public.organizations (name);
CREATE INDEX index_organizations_on_parent_id ON public.organizations (parent_id);
INSERT INTO public.organizations (id, name, parent_id, created_at, updated_at) VALUES (2, 'UniJobs', null, '2018-07-11 11:01:14.620812', '2018-07-11 11:01:14.620812');
INSERT INTO public.organizations (id, name, parent_id, created_at, updated_at) VALUES (5, 'Dipartimento di Ingegneria dell''Informazione (DEI)', 3, '2018-07-11 11:02:51.633415', '2018-07-11 11:02:51.633415');
INSERT INTO public.organizations (id, name, parent_id, created_at, updated_at) VALUES (6, 'Dipartimento di Lettere', 3, '2018-07-11 11:03:49.121644', '2018-07-11 11:03:49.121644');
INSERT INTO public.organizations (id, name, parent_id, created_at, updated_at) VALUES (7, 'Dipartimento di Ingegneria dell''Informazione (DEI)', 4, '2018-07-11 11:05:05.515510', '2018-07-11 11:05:05.515510');
INSERT INTO public.organizations (id, name, parent_id, created_at, updated_at) VALUES (8, 'Dipartimento di Lettere', 4, '2018-07-11 11:05:09.874536', '2018-07-11 11:05:09.874536');
INSERT INTO public.organizations (id, name, parent_id, created_at, updated_at) VALUES (10, 'MIUR', null, '2018-07-11 19:02:42.295810', '2018-07-11 19:02:42.295810');
INSERT INTO public.organizations (id, name, parent_id, created_at, updated_at) VALUES (3, 'Università di Padova', 10, '2018-07-11 11:01:41.342253', '2018-07-11 19:03:05.011372');
INSERT INTO public.organizations (id, name, parent_id, created_at, updated_at) VALUES (4, 'Università di Milano', 10, '2018-07-11 11:02:02.645950', '2018-07-11 11:02:02.645950');