-- Database generated with pgModeler (PostgreSQL Database Modeler).
-- pgModeler  version: 0.9.1
-- PostgreSQL version: 9.6
-- Project Site: pgmodeler.io
-- Model Author: ---


-- Database creation must be done outside a multicommand file.
-- These commands were put in this file only as a convenience.
-- -- object: new_database | type: DATABASE --
-- -- DROP DATABASE IF EXISTS new_database;
-- CREATE DATABASE new_database;
-- -- ddl-end --
--

-- object: public.team | type: TABLE --
-- DROP TABLE IF EXISTS public.team CASCADE;
CREATE TABLE public.team(
    uid bigserial NOT NULL,
    uid_ideology bigint,
    uid_currency bigint,
    CONSTRAINT team_pk PRIMARY KEY (uid)

);
-- ddl-end --
ALTER TABLE public.team OWNER TO postgres;
-- ddl-end --

-- object: public."user" | type: TABLE --
-- DROP TABLE IF EXISTS public."user" CASCADE;
CREATE TABLE public."user"(
    uid bigserial NOT NULL,
    uid_ideology bigint,
    uid_team bigint,
    CONSTRAINT user_pk PRIMARY KEY (uid)

);
-- ddl-end --
ALTER TABLE public."user" OWNER TO postgres;
-- ddl-end --

-- object: team_fk | type: CONSTRAINT --
-- ALTER TABLE public."user" DROP CONSTRAINT IF EXISTS team_fk CASCADE;
ALTER TABLE public."user" ADD CONSTRAINT team_fk FOREIGN KEY (uid_team)
REFERENCES public.team (uid) MATCH FULL
ON DELETE SET NULL ON UPDATE CASCADE;
-- ddl-end --

-- object: public.vehicle | type: TABLE --
-- DROP TABLE IF EXISTS public.vehicle CASCADE;
CREATE TABLE public.vehicle(
    uid bigserial NOT NULL,
    uid_team bigint,
    CONSTRAINT vehicle_pk PRIMARY KEY (uid)

);
-- ddl-end --
ALTER TABLE public.vehicle OWNER TO postgres;
-- ddl-end --

-- object: team_fk | type: CONSTRAINT --
-- ALTER TABLE public.vehicle DROP CONSTRAINT IF EXISTS team_fk CASCADE;
ALTER TABLE public.vehicle ADD CONSTRAINT team_fk FOREIGN KEY (uid_team)
REFERENCES public.team (uid) MATCH FULL
ON DELETE SET NULL ON UPDATE CASCADE;
-- ddl-end --

-- object: public.area | type: TABLE --
-- DROP TABLE IF EXISTS public.area CASCADE;
CREATE TABLE public.area(
    uid bigserial NOT NULL,
    uid_team bigint,
    CONSTRAINT area_pk PRIMARY KEY (uid)

);
-- ddl-end --
ALTER TABLE public.area OWNER TO postgres;
-- ddl-end --

-- object: team_fk | type: CONSTRAINT --
-- ALTER TABLE public.area DROP CONSTRAINT IF EXISTS team_fk CASCADE;
ALTER TABLE public.area ADD CONSTRAINT team_fk FOREIGN KEY (uid_team)
REFERENCES public.team (uid) MATCH FULL
ON DELETE SET NULL ON UPDATE CASCADE;
-- ddl-end --

-- object: public.area_resources_link | type: TABLE --
-- DROP TABLE IF EXISTS public.area_resources_link CASCADE;
CREATE TABLE public.area_resources_link(
    uid bigserial NOT NULL,
    uid_resources bigint,
    uid_area bigint,
    CONSTRAINT area_resources_link_pk PRIMARY KEY (uid)

);
-- ddl-end --
ALTER TABLE public.area_resources_link OWNER TO postgres;
-- ddl-end --

-- object: public.resources | type: TABLE --
-- DROP TABLE IF EXISTS public.resources CASCADE;
CREATE TABLE public.resources(
    uid bigserial NOT NULL,
    CONSTRAINT resources_pk PRIMARY KEY (uid)

);
-- ddl-end --
ALTER TABLE public.resources OWNER TO postgres;
-- ddl-end --

-- object: area_fk | type: CONSTRAINT --
-- ALTER TABLE public.area_resources_link DROP CONSTRAINT IF EXISTS area_fk CASCADE;
ALTER TABLE public.area_resources_link ADD CONSTRAINT area_fk FOREIGN KEY (uid_area)
REFERENCES public.area (uid) MATCH FULL
ON DELETE SET NULL ON UPDATE CASCADE;
-- ddl-end --

-- object: resources_fk | type: CONSTRAINT --
-- ALTER TABLE public.area_resources_link DROP CONSTRAINT IF EXISTS resources_fk CASCADE;
ALTER TABLE public.area_resources_link ADD CONSTRAINT resources_fk FOREIGN KEY (uid_resources)
REFERENCES public.resources (uid) MATCH FULL
ON DELETE SET NULL ON UPDATE CASCADE;
-- ddl-end --

-- object: public.currency | type: TABLE --
-- DROP TABLE IF EXISTS public.currency CASCADE;
CREATE TABLE public.currency(
    uid bigserial NOT NULL,
    CONSTRAINT currency_pk PRIMARY KEY (uid)

);
-- ddl-end --
ALTER TABLE public.currency OWNER TO postgres;
-- ddl-end --

-- object: currency_fk | type: CONSTRAINT --
-- ALTER TABLE public.team DROP CONSTRAINT IF EXISTS currency_fk CASCADE;
ALTER TABLE public.team ADD CONSTRAINT currency_fk FOREIGN KEY (uid_currency)
REFERENCES public.currency (uid) MATCH FULL
ON DELETE SET NULL ON UPDATE CASCADE;
-- ddl-end --

-- object: public.ideology | type: TABLE --
-- DROP TABLE IF EXISTS public.ideology CASCADE;
CREATE TABLE public.ideology(
    uid bigserial NOT NULL,
    CONSTRAINT ideology_pk PRIMARY KEY (uid)

);
-- ddl-end --
ALTER TABLE public.ideology OWNER TO postgres;
-- ddl-end --

-- object: ideology_fk | type: CONSTRAINT --
-- ALTER TABLE public."user" DROP CONSTRAINT IF EXISTS ideology_fk CASCADE;
ALTER TABLE public."user" ADD CONSTRAINT ideology_fk FOREIGN KEY (uid_ideology)
REFERENCES public.ideology (uid) MATCH FULL
ON DELETE SET NULL ON UPDATE CASCADE;
-- ddl-end --

-- object: ideology_fk | type: CONSTRAINT --
-- ALTER TABLE public.team DROP CONSTRAINT IF EXISTS ideology_fk CASCADE;
ALTER TABLE public.team ADD CONSTRAINT ideology_fk FOREIGN KEY (uid_ideology)
REFERENCES public.ideology (uid) MATCH FULL
ON DELETE SET NULL ON UPDATE CASCADE;
-- ddl-end --

-- object: public."treat" | type: TABLE --
-- DROP TABLE IF EXISTS public."treat" CASCADE;
CREATE TABLE public."treat"(
    uid bigserial NOT NULL,
    CONSTRAINT treat_pk PRIMARY KEY (uid)

);
-- ddl-end --
ALTER TABLE public."treat" OWNER TO postgres;
-- ddl-end --

-- object: public.treat_team_link | type: TABLE --
-- DROP TABLE IF EXISTS public.treat_team_link CASCADE;
CREATE TABLE public.treat_team_link(
    uid bigserial NOT NULL,
    uid_treat bigint,
    uid_team bigint,
    CONSTRAINT treat_team_link_pk PRIMARY KEY (uid)

);
-- ddl-end --
ALTER TABLE public.treat_team_link OWNER TO postgres;
-- ddl-end --

-- object: treat_fk | type: CONSTRAINT --
-- ALTER TABLE public.treat_team_link DROP CONSTRAINT IF EXISTS treat_fk CASCADE;
ALTER TABLE public.treat_team_link ADD CONSTRAINT treat_fk FOREIGN KEY (uid_treat)
REFERENCES public."treat" (uid) MATCH FULL
ON DELETE SET NULL ON UPDATE CASCADE;
-- ddl-end --

-- object: team_fk | type: CONSTRAINT --
-- ALTER TABLE public.treat_team_link DROP CONSTRAINT IF EXISTS team_fk CASCADE;
ALTER TABLE public.treat_team_link ADD CONSTRAINT team_fk FOREIGN KEY (uid_team)
REFERENCES public.team (uid) MATCH FULL
ON DELETE SET NULL ON UPDATE CASCADE;
-- ddl-end --

-- object: public.organisation | type: TABLE --
-- DROP TABLE IF EXISTS public.organisation CASCADE;
CREATE TABLE public.organisation(
    uid bigserial NOT NULL,
    CONSTRAINT organisation_pk PRIMARY KEY (uid)

);
-- ddl-end --
ALTER TABLE public.organisation OWNER TO postgres;
-- ddl-end --

-- object: public.organisation_team_link | type: TABLE --
-- DROP TABLE IF EXISTS public.organisation_team_link CASCADE;
CREATE TABLE public.organisation_team_link(
    uid bigserial NOT NULL,
    uid_team bigint,
    uid_organisation bigint,
    CONSTRAINT organisation_team_link_pk PRIMARY KEY (uid)

);
-- ddl-end --
ALTER TABLE public.organisation_team_link OWNER TO postgres;
-- ddl-end --

-- object: team_fk | type: CONSTRAINT --
-- ALTER TABLE public.organisation_team_link DROP CONSTRAINT IF EXISTS team_fk CASCADE;
ALTER TABLE public.organisation_team_link ADD CONSTRAINT team_fk FOREIGN KEY (uid_team)
REFERENCES public.team (uid) MATCH FULL
ON DELETE SET NULL ON UPDATE CASCADE;
-- ddl-end --

-- object: organisation_fk | type: CONSTRAINT --
-- ALTER TABLE public.organisation_team_link DROP CONSTRAINT IF EXISTS organisation_fk CASCADE;
ALTER TABLE public.organisation_team_link ADD CONSTRAINT organisation_fk FOREIGN KEY (uid_organisation)
REFERENCES public.organisation (uid) MATCH FULL
ON DELETE SET NULL ON UPDATE CASCADE;
-- ddl-end --