· 8 years ago · Jul 22, 2018, 06:14 PM
1-- Database generated with pgModeler (PostgreSQL Database Modeler).
2-- pgModeler version: 0.9.1
3-- PostgreSQL version: 9.6
4-- Project Site: pgmodeler.io
5-- Model Author: ---
6
7
8-- Database creation must be done outside a multicommand file.
9-- These commands were put in this file only as a convenience.
10-- -- object: new_database | type: DATABASE --
11-- -- DROP DATABASE IF EXISTS new_database;
12-- CREATE DATABASE new_database;
13-- -- ddl-end --
14--
15
16-- object: public.team | type: TABLE --
17-- DROP TABLE IF EXISTS public.team CASCADE;
18CREATE TABLE public.team(
19 uid bigserial NOT NULL,
20 uid_ideology bigint,
21 uid_currency bigint,
22 CONSTRAINT team_pk PRIMARY KEY (uid)
23
24);
25-- ddl-end --
26ALTER TABLE public.team OWNER TO postgres;
27-- ddl-end --
28
29-- object: public."user" | type: TABLE --
30-- DROP TABLE IF EXISTS public."user" CASCADE;
31CREATE TABLE public."user"(
32 uid bigserial NOT NULL,
33 uid_ideology bigint,
34 uid_team bigint,
35 CONSTRAINT user_pk PRIMARY KEY (uid)
36
37);
38-- ddl-end --
39ALTER TABLE public."user" OWNER TO postgres;
40-- ddl-end --
41
42-- object: team_fk | type: CONSTRAINT --
43-- ALTER TABLE public."user" DROP CONSTRAINT IF EXISTS team_fk CASCADE;
44ALTER TABLE public."user" ADD CONSTRAINT team_fk FOREIGN KEY (uid_team)
45REFERENCES public.team (uid) MATCH FULL
46ON DELETE SET NULL ON UPDATE CASCADE;
47-- ddl-end --
48
49-- object: public.vehicle | type: TABLE --
50-- DROP TABLE IF EXISTS public.vehicle CASCADE;
51CREATE TABLE public.vehicle(
52 uid bigserial NOT NULL,
53 uid_team bigint,
54 CONSTRAINT vehicle_pk PRIMARY KEY (uid)
55
56);
57-- ddl-end --
58ALTER TABLE public.vehicle OWNER TO postgres;
59-- ddl-end --
60
61-- object: team_fk | type: CONSTRAINT --
62-- ALTER TABLE public.vehicle DROP CONSTRAINT IF EXISTS team_fk CASCADE;
63ALTER TABLE public.vehicle ADD CONSTRAINT team_fk FOREIGN KEY (uid_team)
64REFERENCES public.team (uid) MATCH FULL
65ON DELETE SET NULL ON UPDATE CASCADE;
66-- ddl-end --
67
68-- object: public.area | type: TABLE --
69-- DROP TABLE IF EXISTS public.area CASCADE;
70CREATE TABLE public.area(
71 uid bigserial NOT NULL,
72 uid_team bigint,
73 CONSTRAINT area_pk PRIMARY KEY (uid)
74
75);
76-- ddl-end --
77ALTER TABLE public.area OWNER TO postgres;
78-- ddl-end --
79
80-- object: team_fk | type: CONSTRAINT --
81-- ALTER TABLE public.area DROP CONSTRAINT IF EXISTS team_fk CASCADE;
82ALTER TABLE public.area ADD CONSTRAINT team_fk FOREIGN KEY (uid_team)
83REFERENCES public.team (uid) MATCH FULL
84ON DELETE SET NULL ON UPDATE CASCADE;
85-- ddl-end --
86
87-- object: public.area_resources_link | type: TABLE --
88-- DROP TABLE IF EXISTS public.area_resources_link CASCADE;
89CREATE TABLE public.area_resources_link(
90 uid bigserial NOT NULL,
91 uid_resources bigint,
92 uid_area bigint,
93 CONSTRAINT area_resources_link_pk PRIMARY KEY (uid)
94
95);
96-- ddl-end --
97ALTER TABLE public.area_resources_link OWNER TO postgres;
98-- ddl-end --
99
100-- object: public.resources | type: TABLE --
101-- DROP TABLE IF EXISTS public.resources CASCADE;
102CREATE TABLE public.resources(
103 uid bigserial NOT NULL,
104 CONSTRAINT resources_pk PRIMARY KEY (uid)
105
106);
107-- ddl-end --
108ALTER TABLE public.resources OWNER TO postgres;
109-- ddl-end --
110
111-- object: area_fk | type: CONSTRAINT --
112-- ALTER TABLE public.area_resources_link DROP CONSTRAINT IF EXISTS area_fk CASCADE;
113ALTER TABLE public.area_resources_link ADD CONSTRAINT area_fk FOREIGN KEY (uid_area)
114REFERENCES public.area (uid) MATCH FULL
115ON DELETE SET NULL ON UPDATE CASCADE;
116-- ddl-end --
117
118-- object: resources_fk | type: CONSTRAINT --
119-- ALTER TABLE public.area_resources_link DROP CONSTRAINT IF EXISTS resources_fk CASCADE;
120ALTER TABLE public.area_resources_link ADD CONSTRAINT resources_fk FOREIGN KEY (uid_resources)
121REFERENCES public.resources (uid) MATCH FULL
122ON DELETE SET NULL ON UPDATE CASCADE;
123-- ddl-end --
124
125-- object: public.currency | type: TABLE --
126-- DROP TABLE IF EXISTS public.currency CASCADE;
127CREATE TABLE public.currency(
128 uid bigserial NOT NULL,
129 CONSTRAINT currency_pk PRIMARY KEY (uid)
130
131);
132-- ddl-end --
133ALTER TABLE public.currency OWNER TO postgres;
134-- ddl-end --
135
136-- object: currency_fk | type: CONSTRAINT --
137-- ALTER TABLE public.team DROP CONSTRAINT IF EXISTS currency_fk CASCADE;
138ALTER TABLE public.team ADD CONSTRAINT currency_fk FOREIGN KEY (uid_currency)
139REFERENCES public.currency (uid) MATCH FULL
140ON DELETE SET NULL ON UPDATE CASCADE;
141-- ddl-end --
142
143-- object: public.ideology | type: TABLE --
144-- DROP TABLE IF EXISTS public.ideology CASCADE;
145CREATE TABLE public.ideology(
146 uid bigserial NOT NULL,
147 CONSTRAINT ideology_pk PRIMARY KEY (uid)
148
149);
150-- ddl-end --
151ALTER TABLE public.ideology OWNER TO postgres;
152-- ddl-end --
153
154-- object: ideology_fk | type: CONSTRAINT --
155-- ALTER TABLE public."user" DROP CONSTRAINT IF EXISTS ideology_fk CASCADE;
156ALTER TABLE public."user" ADD CONSTRAINT ideology_fk FOREIGN KEY (uid_ideology)
157REFERENCES public.ideology (uid) MATCH FULL
158ON DELETE SET NULL ON UPDATE CASCADE;
159-- ddl-end --
160
161-- object: ideology_fk | type: CONSTRAINT --
162-- ALTER TABLE public.team DROP CONSTRAINT IF EXISTS ideology_fk CASCADE;
163ALTER TABLE public.team ADD CONSTRAINT ideology_fk FOREIGN KEY (uid_ideology)
164REFERENCES public.ideology (uid) MATCH FULL
165ON DELETE SET NULL ON UPDATE CASCADE;
166-- ddl-end --
167
168-- object: public."treat" | type: TABLE --
169-- DROP TABLE IF EXISTS public."treat" CASCADE;
170CREATE TABLE public."treat"(
171 uid bigserial NOT NULL,
172 CONSTRAINT treat_pk PRIMARY KEY (uid)
173
174);
175-- ddl-end --
176ALTER TABLE public."treat" OWNER TO postgres;
177-- ddl-end --
178
179-- object: public.treat_team_link | type: TABLE --
180-- DROP TABLE IF EXISTS public.treat_team_link CASCADE;
181CREATE TABLE public.treat_team_link(
182 uid bigserial NOT NULL,
183 uid_treat bigint,
184 uid_team bigint,
185 CONSTRAINT treat_team_link_pk PRIMARY KEY (uid)
186
187);
188-- ddl-end --
189ALTER TABLE public.treat_team_link OWNER TO postgres;
190-- ddl-end --
191
192-- object: treat_fk | type: CONSTRAINT --
193-- ALTER TABLE public.treat_team_link DROP CONSTRAINT IF EXISTS treat_fk CASCADE;
194ALTER TABLE public.treat_team_link ADD CONSTRAINT treat_fk FOREIGN KEY (uid_treat)
195REFERENCES public."treat" (uid) MATCH FULL
196ON DELETE SET NULL ON UPDATE CASCADE;
197-- ddl-end --
198
199-- object: team_fk | type: CONSTRAINT --
200-- ALTER TABLE public.treat_team_link DROP CONSTRAINT IF EXISTS team_fk CASCADE;
201ALTER TABLE public.treat_team_link ADD CONSTRAINT team_fk FOREIGN KEY (uid_team)
202REFERENCES public.team (uid) MATCH FULL
203ON DELETE SET NULL ON UPDATE CASCADE;
204-- ddl-end --
205
206-- object: public.organisation | type: TABLE --
207-- DROP TABLE IF EXISTS public.organisation CASCADE;
208CREATE TABLE public.organisation(
209 uid bigserial NOT NULL,
210 CONSTRAINT organisation_pk PRIMARY KEY (uid)
211
212);
213-- ddl-end --
214ALTER TABLE public.organisation OWNER TO postgres;
215-- ddl-end --
216
217-- object: public.organisation_team_link | type: TABLE --
218-- DROP TABLE IF EXISTS public.organisation_team_link CASCADE;
219CREATE TABLE public.organisation_team_link(
220 uid bigserial NOT NULL,
221 uid_team bigint,
222 uid_organisation bigint,
223 CONSTRAINT organisation_team_link_pk PRIMARY KEY (uid)
224
225);
226-- ddl-end --
227ALTER TABLE public.organisation_team_link OWNER TO postgres;
228-- ddl-end --
229
230-- object: team_fk | type: CONSTRAINT --
231-- ALTER TABLE public.organisation_team_link DROP CONSTRAINT IF EXISTS team_fk CASCADE;
232ALTER TABLE public.organisation_team_link ADD CONSTRAINT team_fk FOREIGN KEY (uid_team)
233REFERENCES public.team (uid) MATCH FULL
234ON DELETE SET NULL ON UPDATE CASCADE;
235-- ddl-end --
236
237-- object: organisation_fk | type: CONSTRAINT --
238-- ALTER TABLE public.organisation_team_link DROP CONSTRAINT IF EXISTS organisation_fk CASCADE;
239ALTER TABLE public.organisation_team_link ADD CONSTRAINT organisation_fk FOREIGN KEY (uid_organisation)
240REFERENCES public.organisation (uid) MATCH FULL
241ON DELETE SET NULL ON UPDATE CASCADE;
242-- ddl-end --