· 8 years ago · Feb 12, 2018, 01:10 PM
1
2 drop table if exists public.cash_operation_type cascade
3
4 drop table if exists public.client cascade
5
6 drop table if exists public.client_type cascade
7
8 drop table if exists public.discount cascade
9
10 drop table if exists public.session cascade
11
12 drop table if exists public.rent_item cascade
13
14 drop table if exists public.visit cascade
15
16 drop table if exists public.ticket cascade
17
18 drop table if exists public.trainer cascade
19
20 drop table if exists trainer_training_type cascade
21
22 drop table if exists public.training_type cascade
23
24 drop table if exists public.user cascade
25
26 drop table if exists public.user_type cascade
27
28 drop table if exists public.ticket_visit cascade
29
30 drop table if exists public.cash_operation cascade
31
32 drop table if exists public.ticket_type cascade
33
34 create table public.cash_operation_type (
35 cash_operation_type serial,
36 title varchar(255),
37 deleted boolean,
38 primary key (cash_operation_type)
39 )
40
41 create table public.client (
42 client_id serial,
43 fio varchar(255),
44 barcode varchar(255),
45 birthdate timestamp,
46 credit float8,
47 email varchar(255),
48 phone varchar(255),
49 gender varchar(255),
50 deleted boolean,
51 info varchar(255),
52 client_type_id int4,
53 last_ticket int4,
54 primary key (client_id)
55 )
56
57 create table public.client_type (
58 client_type_id serial,
59 title varchar(255),
60 primary key (client_type_id)
61 )
62
63 create table public.discount (
64 discount_id serial,
65 title varchar(255),
66 percent float8,
67 deleted boolean,
68 primary key (discount_id)
69 )
70
71 create table public.session (
72 session_id serial,
73 date_start timestamp,
74 start_cash_sum float8,
75 start_terminal_sum float8,
76 date_finish timestamp,
77 finish_cash_sum float8,
78 finish_terminal_sum float8,
79 user_id int4,
80 primary key (session_id)
81 )
82
83 create table public.rent_item (
84 rent_item_id serial,
85 title varchar(255),
86 count int4,
87 deleted boolean,
88 primary key (rent_item_id)
89 )
90
91 create table public.visit (
92 visit_id serial,
93 sum float8,
94 date timestamp,
95 client_id int4,
96 session_id int4,
97 trainer_id int4,
98 training_type_id int4,
99 primary key (visit_id)
100 )
101
102 create table public.ticket (
103 ticket_id serial,
104 expiration timestamp,
105 frozen boolean,
106 total_sum float8,
107 visit_quantity int4,
108 sell_data timestamp,
109 deleted boolean,
110 session_id int4,
111 client_id int4,
112 discount_id int4,
113 ticket_type_id int4,
114 primary key (ticket_id)
115 )
116
117 create table public.trainer (
118 trainer_id serial,
119 fio varchar(255),
120 birthdate timestamp,
121 phone varchar(255),
122 salary_debt float8,
123 info varchar(255),
124 deleted boolean,
125 primary key (trainer_id)
126 )
127
128 create table trainer_training_type (
129 Trainer_id int4 not null,
130 TrainingType_id int4 not null
131 )
132
133 create table public.training_type (
134 training_type_id serial,
135 title varchar(255),
136 deleted boolean,
137 day_price float8,
138 evening_price float8,
139 morning_price float8,
140 salary_visit float8,
141 salary_ticket float8,
142 primary key (training_type_id)
143 )
144
145 create table public.user (
146 user_id serial,
147 birthdate timestamp,
148 deleted boolean,
149 fio varchar(255),
150 phone varchar(255),
151 user_type_id int4,
152 primary key (user_id)
153 )
154
155 create table public.user_type (
156 user_type_id serial,
157 title varchar(255),
158 primary key (user_type_id)
159 )
160
161 create table public.ticket_visit (
162 ticket_visit_id serial,
163 date timestamp,
164 ticket_id int4,
165 session_id int4,
166 trainer_id int4,
167 training_type_id int4,
168 primary key (ticket_visit_id)
169 )
170
171 create table public.cash_operation (
172 cash_operation_id serial,
173 comment varchar(255),
174 summ float8,
175 date timestamp,
176 payee_id int4,
177 session_id int4,
178 cash_operation_type int4,
179 primary key (cash_operation_id)
180 )
181
182 create table public.ticket_type (
183 ticket_type_id serial,
184 title varchar(255),
185 nominal float8,
186 lesson_count int4,
187 deleted boolean,
188 primary key (ticket_type_id)
189 )
190
191 alter table public.client
192 add constraint FK328F029A6B64758E
193 foreign key (client_type_id)
194 references public.client_type
195
196 alter table public.client
197 add constraint FK328F029A62AA4F48
198 foreign key (last_ticket)
199 references public.ticket
200
201 alter table public.session
202 add constraint FKBF1D3A5748E9CB4C
203 foreign key (user_id)
204 references public.user
205
206 alter table public.visit
207 add constraint FKEBCD4837BBF14D3
208 foreign key (client_id)
209 references public.client
210
211 alter table public.visit
212 add constraint FKEBCD4837F6FCD438
213 foreign key (session_id)
214 references public.session
215
216 alter table public.visit
217 add constraint FKEBCD4837271799C1
218 foreign key (trainer_id)
219 references public.trainer
220
221 alter table public.visit
222 add constraint FKEBCD4837A1445F37
223 foreign key (training_type_id)
224 references public.training_type
225
226 alter table public.ticket
227 add constraint FKFFA692A0F6FCD438
228 foreign key (session_id)
229 references public.session
230
231 alter table public.ticket
232 add constraint FKFFA692A0BBF14D3
233 foreign key (client_id)
234 references public.client
235
236 alter table public.ticket
237 add constraint FKFFA692A0571B9B93
238 foreign key (discount_id)
239 references public.discount
240
241 alter table public.ticket
242 add constraint FKFFA692A025FE17B
243 foreign key (ticket_type_id)
244 references public.ticket_type
245
246 alter table trainer_training_type
247 add constraint FKED5B2A46894C1C92
248 foreign key (TrainingType_id)
249 references public.training_type
250
251 alter table trainer_training_type
252 add constraint FKED5B2A46271799C1
253 foreign key (Trainer_id)
254 references public.trainer
255
256 alter table public.user
257 add constraint FK7185C15CF47F4C06
258 foreign key (user_type_id)
259 references public.user_type
260
261 alter table public.ticket_visit
262 add constraint FK456ABA37904C45A7
263 foreign key (ticket_id)
264 references public.ticket
265
266 alter table public.ticket_visit
267 add constraint FK456ABA37F6FCD438
268 foreign key (session_id)
269 references public.session
270
271 alter table public.ticket_visit
272 add constraint FK456ABA37271799C1
273 foreign key (trainer_id)
274 references public.trainer
275
276 alter table public.ticket_visit
277 add constraint FK456ABA37A1445F37
278 foreign key (training_type_id)
279 references public.training_type
280
281 alter table public.cash_operation
282 add constraint FK8056EAE5BCD92FBA
283 foreign key (payee_id)
284 references public.trainer
285
286 alter table public.cash_operation
287 add constraint FK8056EAE5F6FCD438
288 foreign key (session_id)
289 references public.session
290
291 alter table public.cash_operation
292 add constraint FK8056EAE575BCB484
293 foreign key (cash_operation_type)
294 references public.cash_operation_type