· 9 years ago · Jun 21, 2017, 03:02 PM
1CREATE USER IF NOT EXISTS SA SALT '3351e62c43ea5103' HASH '97e2a278d72469faa1d45234d4bddd747c3e03c53f1fbfd88b2f58da16ab75c7' ADMIN;
2CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_4FBC5CE9_4D9E_41DB_B096_21114380D898 START WITH 3 BELONGS_TO_TABLE;
3CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_7D68399A_B846_49FD_B686_10296742F666 START WITH 4 BELONGS_TO_TABLE;
4CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_628F8895_F6D1_4D53_BD36_4C3A8C777CE0 START WITH 7 BELONGS_TO_TABLE;
5CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_29C471E1_09DC_4BDD_BA27_ECBF2D7F9EAE START WITH 70 BELONGS_TO_TABLE;
6CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_78374564_06E2_4DB9_980D_B832D3518B43 START WITH 3 BELONGS_TO_TABLE;
7CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_C0595938_F63E_4F6B_B6F4_B43942A981FE START WITH 3 BELONGS_TO_TABLE;
8CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_7D2197AA_6327_4CE5_915B_3B618EB35B6C START WITH 17 BELONGS_TO_TABLE;
9CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_997FEDF7_384E_4AE8_B1FA_CC69BC9A6B69 START WITH 20 BELONGS_TO_TABLE;
10CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_1860FF04_E4C9_4D1A_A065_90C3C6A3E181 START WITH 9 BELONGS_TO_TABLE;
11CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_6B1DB9FD_7063_4786_8BA1_F8F87761FB7B START WITH 4 BELONGS_TO_TABLE;
12CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_3C6F3CD3_C1EF_4669_9056_95DBAFA87604 START WITH 7 BELONGS_TO_TABLE;
13CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_11992B67_D6F3_45EA_B8FD_84712786FD0D START WITH 11 BELONGS_TO_TABLE;
14CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_81F7C73B_1A05_4B36_B22B_FE7423EA6DFA START WITH 15 BELONGS_TO_TABLE;
15CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_32F6767E_CF87_4A25_A79D_132B01FF1A71 START WITH 3 BELONGS_TO_TABLE;
16CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_A780D494_60A0_4F96_BFD9_B1F4D1F809AC START WITH 4 BELONGS_TO_TABLE;
17CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_93FD0408_F21D_4807_B9B7_68893A4F7802 START WITH 7 BELONGS_TO_TABLE;
18CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_B0E67CE1_867D_4F41_B050_42F0D3C5B259 START WITH 7 BELONGS_TO_TABLE;
19CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_672FB7F9_48F2_4674_B5E2_CD8FA975D5C3 START WITH 3 BELONGS_TO_TABLE;
20CREATE MEMORY TABLE PUBLIC.AREA(
21 AREA_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_7D68399A_B846_49FD_B686_10296742F666) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_7D68399A_B846_49FD_B686_10296742F666,
22 NAME VARCHAR(255),
23 RESTAURANT_ID BIGINT NOT NULL
24);
25ALTER TABLE PUBLIC.AREA ADD CONSTRAINT PUBLIC.CONSTRAINT_1 PRIMARY KEY(AREA_ID);
26-- 3 +/- SELECT COUNT(*) FROM PUBLIC.AREA;
27INSERT INTO PUBLIC.AREA(AREA_ID, NAME, RESTAURANT_ID) VALUES
28(1, 'WHOLE RESTAURANT', 2),
29(2, 'Smoking', 1),
30(3, 'Non-smoking', 1);
31CREATE MEMORY TABLE PUBLIC.BID(
32 BID_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_6B1DB9FD_7063_4786_8BA1_F8F87761FB7B) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_6B1DB9FD_7063_4786_8BA1_F8F87761FB7B,
33 CHOSEN VARCHAR(255),
34 DELIVERY_DEADLINE TIMESTAMP,
35 GUARANTEE VARCHAR(255),
36 PRICE DOUBLE NOT NULL,
37 VERSION INTEGER DEFAULT 0 NOT NULL,
38 BIDDER_ID BIGINT NOT NULL,
39 SUPPLIES_ID BIGINT NOT NULL
40);
41ALTER TABLE PUBLIC.BID ADD CONSTRAINT PUBLIC.CONSTRAINT_10 PRIMARY KEY(BID_ID);
42-- 3 +/- SELECT COUNT(*) FROM PUBLIC.BID;
43INSERT INTO PUBLIC.BID(BID_ID, CHOSEN, DELIVERY_DEADLINE, GUARANTEE, PRICE, VERSION, BIDDER_ID, SUPPLIES_ID) VALUES
44(1, NULL, TIMESTAMP '2017-07-11 00:00:00.0', 'da', 200.0, 0, 16, 1),
45(2, NULL, TIMESTAMP '2017-07-01 00:00:00.0', 'da', 500.0, 0, 17, 1),
46(3, NULL, TIMESTAMP '2017-06-30 00:00:00.0', 'da', 900.0, 0, 18, 1);
47CREATE MEMORY TABLE PUBLIC.BIDDER(
48 PASSWORD_CHANGED BOOLEAN NOT NULL,
49 ID BIGINT NOT NULL
50);
51ALTER TABLE PUBLIC.BIDDER ADD CONSTRAINT PUBLIC.CONSTRAINT_7 PRIMARY KEY(ID);
52-- 3 +/- SELECT COUNT(*) FROM PUBLIC.BIDDER;
53INSERT INTO PUBLIC.BIDDER(PASSWORD_CHANGED, ID) VALUES
54(TRUE, 16),
55(TRUE, 17),
56(TRUE, 18);
57CREATE MEMORY TABLE PUBLIC.DRINK_ITEM(
58 ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_628F8895_F6D1_4D53_BD36_4C3A8C777CE0) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_628F8895_F6D1_4D53_BD36_4C3A8C777CE0,
59 DESCRIPTION VARCHAR(255),
60 NAME VARCHAR(255),
61 PRICE DOUBLE NOT NULL,
62 DRINK_CARD_ID BIGINT NOT NULL,
63 FINALORDER_ID BIGINT
64);
65ALTER TABLE PUBLIC.DRINK_ITEM ADD CONSTRAINT PUBLIC.CONSTRAINT_A PRIMARY KEY(ID);
66-- 6 +/- SELECT COUNT(*) FROM PUBLIC.DRINK_ITEM;
67INSERT INTO PUBLIC.DRINK_ITEM(ID, DESCRIPTION, NAME, PRICE, DRINK_CARD_ID, FINALORDER_ID) VALUES
68(1, 'crno', 'Vino', 235.0, 1, NULL),
69(2, 'belo', 'Vino', 235.0, 1, NULL),
70(3, '-', 'Sprite', 120.0, 1, NULL),
71(4, 'light', 'Cola', 235.0, 2, NULL),
72(5, 'apple', 'Somersby', 210.0, 2, NULL),
73(6, 'pear', 'Somersby', 210.0, 2, NULL);
74CREATE MEMORY TABLE PUBLIC.DRINKCARD(
75 DRINK_CARD_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_672FB7F9_48F2_4674_B5E2_CD8FA975D5C3) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_672FB7F9_48F2_4674_B5E2_CD8FA975D5C3,
76 NAME VARCHAR(255),
77 RESTAURANT_ID BIGINT NOT NULL
78);
79ALTER TABLE PUBLIC.DRINKCARD ADD CONSTRAINT PUBLIC.CONSTRAINT_4 PRIMARY KEY(DRINK_CARD_ID);
80-- 2 +/- SELECT COUNT(*) FROM PUBLIC.DRINKCARD;
81INSERT INTO PUBLIC.DRINKCARD(DRINK_CARD_ID, NAME, RESTAURANT_ID) VALUES
82(1, 'Drink Card', 1),
83(2, 'Drink Card', 2);
84CREATE MEMORY TABLE PUBLIC.DRINKITEM_RATES(
85 DRINKITEM_ID BIGINT NOT NULL,
86 RATES DOUBLE
87);
88-- 3 +/- SELECT COUNT(*) FROM PUBLIC.DRINKITEM_RATES;
89INSERT INTO PUBLIC.DRINKITEM_RATES(DRINKITEM_ID, RATES) VALUES
90(1, 5.0),
91(2, 5.0),
92(3, 5.0);
93CREATE MEMORY TABLE PUBLIC.EMPLOYEE(
94 BIRTH_DATE TIMESTAMP,
95 CONFECTION_NUMBER VARCHAR(255) NOT NULL,
96 PASSWORD_CHANGED BOOLEAN NOT NULL,
97 SHOE_NUMBER VARCHAR(255) NOT NULL,
98 ID BIGINT NOT NULL,
99 RESTAURANT_ID BIGINT
100);
101ALTER TABLE PUBLIC.EMPLOYEE ADD CONSTRAINT PUBLIC.CONSTRAINT_75 PRIMARY KEY(ID);
102-- 7 +/- SELECT COUNT(*) FROM PUBLIC.EMPLOYEE;
103INSERT INTO PUBLIC.EMPLOYEE(BIRTH_DATE, CONFECTION_NUMBER, PASSWORD_CHANGED, SHOE_NUMBER, ID, RESTAURANT_ID) VALUES
104(NULL, 'XS', FALSE, '36', 10, 2),
105(NULL, 'XL', FALSE, '45', 11, 1),
106(NULL, 'XS', TRUE, '36', 12, 1),
107(NULL, 'M', FALSE, '44', 13, 2),
108(NULL, 'L', FALSE, '40', 14, 1),
109(NULL, 'S', TRUE, '36', 15, 1),
110(NULL, 'L', FALSE, '40', 19, 1);
111CREATE MEMORY TABLE PUBLIC.EMPLOYEE_RATES(
112 EMPLOYEE_ID BIGINT NOT NULL,
113 RATES DOUBLE
114);
115-- 4 +/- SELECT COUNT(*) FROM PUBLIC.EMPLOYEE_RATES;
116INSERT INTO PUBLIC.EMPLOYEE_RATES(EMPLOYEE_ID, RATES) VALUES
117(19, 3.0),
118(19, 5.0),
119(15, 1.0),
120(15, 3.0);
121CREATE MEMORY TABLE PUBLIC.EMPLOYEE_SHIFT(
122 EMPLOYEE_SHIFT_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_A780D494_60A0_4F96_BFD9_B1F4D1F809AC) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_A780D494_60A0_4F96_BFD9_B1F4D1F809AC,
123 END_DATE TIMESTAMP,
124 START_DATE TIMESTAMP,
125 AREA_ID BIGINT,
126 EMPLOYEE_ID BIGINT,
127 SHIFT_ID BIGINT
128);
129ALTER TABLE PUBLIC.EMPLOYEE_SHIFT ADD CONSTRAINT PUBLIC.CONSTRAINT_109 PRIMARY KEY(EMPLOYEE_SHIFT_ID);
130-- 3 +/- SELECT COUNT(*) FROM PUBLIC.EMPLOYEE_SHIFT;
131INSERT INTO PUBLIC.EMPLOYEE_SHIFT(EMPLOYEE_SHIFT_ID, END_DATE, START_DATE, AREA_ID, EMPLOYEE_ID, SHIFT_ID) VALUES
132(1, TIMESTAMP '2017-05-25 00:00:00.0', TIMESTAMP '2017-05-18 00:00:00.0', NULL, 11, 1),
133(2, TIMESTAMP '2017-06-29 00:00:00.0', TIMESTAMP '2017-05-20 00:00:00.0', 1, 15, 2),
134(3, TIMESTAMP '2017-05-29 00:00:00.0', TIMESTAMP '2017-05-20 00:00:00.0', NULL, 12, 2);
135CREATE MEMORY TABLE PUBLIC.FRIENDSHIP(
136 ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_93FD0408_F21D_4807_B9B7_68893A4F7802) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_93FD0408_F21D_4807_B9B7_68893A4F7802,
137 CONFIRMED BOOLEAN,
138 FRIEND1 BIGINT NOT NULL,
139 FRIEND2 BIGINT NOT NULL,
140 SENDER BIGINT
141);
142ALTER TABLE PUBLIC.FRIENDSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_B PRIMARY KEY(ID);
143-- 6 +/- SELECT COUNT(*) FROM PUBLIC.FRIENDSHIP;
144INSERT INTO PUBLIC.FRIENDSHIP(ID, CONFIRMED, FRIEND1, FRIEND2, SENDER) VALUES
145(1, TRUE, 5, 6, 5),
146(2, TRUE, 5, 7, 5),
147(3, TRUE, 5, 4, 5),
148(4, TRUE, 6, 7, 6),
149(5, TRUE, 6, 4, 6),
150(6, TRUE, 7, 4, 7);
151CREATE MEMORY TABLE PUBLIC.GUEST(
152 ID BIGINT NOT NULL
153);
154ALTER TABLE PUBLIC.GUEST ADD CONSTRAINT PUBLIC.CONSTRAINT_41 PRIMARY KEY(ID);
155-- 0 +/- SELECT COUNT(*) FROM PUBLIC.GUEST;
156CREATE MEMORY TABLE PUBLIC.INVITATION(
157 ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_7D2197AA_6327_4CE5_915B_3B618EB35B6C) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_7D2197AA_6327_4CE5_915B_3B618EB35B6C,
158 CONFIRMED BOOLEAN,
159 FRIENDEMAIL VARCHAR(255) NOT NULL,
160 FRIENDID BIGINT NOT NULL,
161 RESERVATIONID BIGINT NOT NULL,
162 USERID BIGINT NOT NULL
163);
164ALTER TABLE PUBLIC.INVITATION ADD CONSTRAINT PUBLIC.CONSTRAINT_6 PRIMARY KEY(ID);
165-- 16 +/- SELECT COUNT(*) FROM PUBLIC.INVITATION;
166INSERT INTO PUBLIC.INVITATION(ID, CONFIRMED, FRIENDEMAIL, FRIENDID, RESERVATIONID, USERID) VALUES
167(1, TRUE, 'patrik@gmail.com', 6, 1, 5),
168(2, FALSE, 'jugoslav@gmail.com', 7, 1, 5),
169(3, TRUE, 'jugoslav@gmail.com', 7, 2, 5),
170(4, FALSE, 'djokica@gmail.com', 5, 3, 6),
171(5, FALSE, 'djokica@gmail.com', 5, 4, 6),
172(6, TRUE, 'patrik@gmail.com', 6, 6, 5),
173(7, FALSE, 'patrik@gmail.com', 6, 6, 5),
174(8, FALSE, 'djokica@gmail.com', 5, 11, 4),
175(9, FALSE, 'patrik@gmail.com', 6, 11, 4),
176(10, FALSE, 'jugoslav@gmail.com', 7, 12, 6),
177(11, FALSE, 'djokica@gmail.com', 5, 12, 6),
178(12, TRUE, 'vosmi@gmail.com', 4, 12, 6),
179(13, TRUE, 'djokica@gmail.com', 5, 13, 6),
180(14, TRUE, 'jugoslav@gmail.com', 7, 13, 6),
181(15, TRUE, 'vosmi@gmail.com', 4, 13, 6),
182(16, TRUE, 'djokica@gmail.com', 5, 14, 6);
183CREATE MEMORY TABLE PUBLIC.MENU(
184 MENU_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_78374564_06E2_4DB9_980D_B832D3518B43) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_78374564_06E2_4DB9_980D_B832D3518B43,
185 NAME VARCHAR(255),
186 RESTAURANT_ID BIGINT NOT NULL
187);
188ALTER TABLE PUBLIC.MENU ADD CONSTRAINT PUBLIC.CONSTRAINT_2 PRIMARY KEY(MENU_ID);
189-- 2 +/- SELECT COUNT(*) FROM PUBLIC.MENU;
190INSERT INTO PUBLIC.MENU(MENU_ID, NAME, RESTAURANT_ID) VALUES
191(1, 'Menu', 1),
192(2, 'Menu', 2);
193CREATE MEMORY TABLE PUBLIC.MENU_ITEM(
194 ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_B0E67CE1_867D_4F41_B050_42F0D3C5B259) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_B0E67CE1_867D_4F41_B050_42F0D3C5B259,
195 DESCRIPTION VARCHAR(255),
196 NAME VARCHAR(255),
197 PRICE DOUBLE NOT NULL,
198 FINALORDER_ID BIGINT,
199 MENU_ID BIGINT NOT NULL
200);
201ALTER TABLE PUBLIC.MENU_ITEM ADD CONSTRAINT PUBLIC.CONSTRAINT_4C PRIMARY KEY(ID);
202-- 6 +/- SELECT COUNT(*) FROM PUBLIC.MENU_ITEM;
203INSERT INTO PUBLIC.MENU_ITEM(ID, DESCRIPTION, NAME, PRICE, FINALORDER_ID, MENU_ID) VALUES
204(1, 'ljuta', 'pljeska', 235.0, NULL, 1),
205(2, '-', 'Karadjordjeva', 400.0, NULL, 1),
206(3, 'bolonjeze', 'Spagete', 560.0, NULL, 1),
207(4, 'slane', 'palacinke', 235.0, NULL, 2),
208(5, 'slatke', 'palacinke', 400.0, NULL, 2),
209(6, '', 'Spagete', 560.0, NULL, 2);
210CREATE MEMORY TABLE PUBLIC.MENUITEM_RATES(
211 MENUITEM_ID BIGINT NOT NULL,
212 RATES DOUBLE
213);
214-- 3 +/- SELECT COUNT(*) FROM PUBLIC.MENUITEM_RATES;
215INSERT INTO PUBLIC.MENUITEM_RATES(MENUITEM_ID, RATES) VALUES
216(1, 5.0),
217(2, 5.0),
218(3, 5.0);
219CREATE MEMORY TABLE PUBLIC.ORDER_ITEM(
220 ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_29C471E1_09DC_4BDD_BA27_ECBF2D7F9EAE) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_29C471E1_09DC_4BDD_BA27_ECBF2D7F9EAE,
221 DESCRIPTION VARCHAR(255),
222 NAME VARCHAR(255) NOT NULL,
223 ORDERSTATUS VARCHAR(255),
224 ORDERTYPE VARCHAR(255) NOT NULL,
225 PRICE DOUBLE NOT NULL,
226 VERSION INTEGER DEFAULT 0 NOT NULL,
227 BILL_ID BIGINT NOT NULL,
228 RESTAURANT_ID BIGINT NOT NULL,
229 USER_ID BIGINT NOT NULL
230);
231ALTER TABLE PUBLIC.ORDER_ITEM ADD CONSTRAINT PUBLIC.CONSTRAINT_4B PRIMARY KEY(ID);
232-- 69 +/- SELECT COUNT(*) FROM PUBLIC.ORDER_ITEM;
233INSERT INTO PUBLIC.ORDER_ITEM(ID, DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID) VALUES
234(1, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 1, 1, 15),
235(2, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 1, 1, 15),
236(3, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 1, 1, 15),
237(4, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 1, 1, 15),
238(5, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 1, 1, 15),
239(6, 'crno', 'Vino', 'RESERVED', 'DRINK', 320.0, 0, 2, 1, 15),
240(7, 'crno', 'Vino', 'RESERVED', 'DRINK', 211.0, 0, 2, 1, 15),
241(8, 'crno', 'Vino', 'RESERVED', 'DRINK', 450.0, 0, 2, 1, 15),
242(9, 'crno', 'Vino', 'RESERVED', 'DRINK', 390.0, 0, 2, 1, 15),
243(10, 'crno', 'Vino', 'RESERVED', 'DRINK', 189.0, 0, 2, 1, 15),
244(11, 'crno', 'Vino', 'RESERVED', 'DRINK', 320.0, 0, 3, 1, 15),
245(12, 'crno', 'Vino', 'RESERVED', 'DRINK', 211.0, 0, 3, 1, 15),
246(13, 'crno', 'Vino', 'RESERVED', 'DRINK', 450.0, 0, 3, 1, 15),
247(14, 'crno', 'Vino', 'RESERVED', 'DRINK', 390.0, 0, 3, 1, 15),
248(15, 'crno', 'Vino', 'RESERVED', 'DRINK', 189.0, 0, 3, 1, 15),
249(16, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 4, 1, 4),
250(17, 'belo', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 4, 1, 4),
251(18, '-', 'Sprite', 'RESERVED', 'DRINK', 120.0, 0, 4, 1, 4),
252(19, 'ljuta', 'pljeska', 'RESERVED', 'FOOD', 235.0, 0, 4, 1, 4),
253(20, '-', 'Karadjordjeva', 'RESERVED', 'FOOD', 400.0, 0, 4, 1, 4),
254(21, 'bolonjeze', 'Spagete', 'RESERVED', 'FOOD', 560.0, 0, 4, 1, 4),
255(22, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 5, 1, 6),
256(23, 'belo', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 5, 1, 6),
257(24, '-', 'Sprite', 'RESERVED', 'DRINK', 120.0, 0, 5, 1, 6),
258(25, 'ljuta', 'pljeska', 'RESERVED', 'FOOD', 235.0, 0, 5, 1, 6),
259(26, '-', 'Karadjordjeva', 'RESERVED', 'FOOD', 400.0, 0, 5, 1, 6),
260(27, 'bolonjeze', 'Spagete', 'RESERVED', 'FOOD', 560.0, 0, 5, 1, 6),
261(28, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 6, 1, 6),
262(29, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 6, 1, 6),
263(30, 'belo', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 6, 1, 6),
264(31, 'belo', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 6, 1, 6),
265(32, '-', 'Sprite', 'RESERVED', 'DRINK', 120.0, 0, 6, 1, 6),
266(33, '-', 'Sprite', 'RESERVED', 'DRINK', 120.0, 0, 6, 1, 6),
267(34, 'ljuta', 'pljeska', 'RESERVED', 'FOOD', 235.0, 0, 6, 1, 6),
268(35, '-', 'Karadjordjeva', 'RESERVED', 'FOOD', 400.0, 0, 6, 1, 6),
269(36, '-', 'Karadjordjeva', 'RESERVED', 'FOOD', 400.0, 0, 6, 1, 6),
270(37, 'bolonjeze', 'Spagete', 'RESERVED', 'FOOD', 560.0, 0, 6, 1, 6),
271(38, 'bolonjeze', 'Spagete', 'RESERVED', 'FOOD', 560.0, 0, 6, 1, 6),
272(39, 'bolonjeze', 'Spagete', 'RESERVED', 'FOOD', 560.0, 0, 6, 1, 6),
273(40, 'crno', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 7, 1, 6),
274(41, 'belo', 'Vino', 'RESERVED', 'DRINK', 235.0, 0, 7, 1, 6),
275(42, '-', 'Sprite', 'RESERVED', 'DRINK', 120.0, 0, 7, 1, 6),
276(43, 'ljuta', 'pljeska', 'RESERVED', 'FOOD', 235.0, 0, 7, 1, 6),
277(44, 'ljuta', 'pljeska', 'RESERVED', 'FOOD', 235.0, 0, 7, 1, 6),
278(45, '-', 'Karadjordjeva', 'RESERVED', 'FOOD', 400.0, 0, 7, 1, 6),
279(46, 'bolonjeze', 'Spagete', 'RESERVED', 'FOOD', 560.0, 0, 7, 1, 6),
280(47, 'crno', 'Vino', 'UNFINISHED', 'DRINK', 235.0, 0, 8, 1, 15),
281(48, '-', 'Sprite', 'UNFINISHED', 'DRINK', 120.0, 0, 8, 1, 15),
282(49, 'belo', 'Vino', 'UNFINISHED', 'DRINK', 235.0, 0, 8, 1, 15),
283(50, 'crno', 'Vino', 'UNFINISHED', 'DRINK', 235.0, 0, 8, 1, 15),
284(51, 'bolonjeze', 'Spagete', 'UNFINISHED', 'FOOD', 560.0, 0, 8, 1, 15),
285(52, '-', 'Karadjordjeva', 'UNFINISHED', 'FOOD', 400.0, 0, 8, 1, 15),
286(53, 'ljuta', 'pljeska', 'UNFINISHED', 'FOOD', 235.0, 0, 8, 1, 15),
287(54, 'bolonjeze', 'Spagete', 'UNFINISHED', 'FOOD', 560.0, 0, 9, 1, 15),
288(55, 'ljuta', 'pljeska', 'UNFINISHED', 'FOOD', 235.0, 0, 9, 1, 15),
289(56, '-', 'Karadjordjeva', 'UNFINISHED', 'FOOD', 400.0, 0, 9, 1, 15),
290(57, '-', 'Sprite', 'UNFINISHED', 'DRINK', 120.0, 0, 9, 1, 15),
291(58, 'belo', 'Vino', 'UNFINISHED', 'DRINK', 235.0, 0, 9, 1, 15),
292(59, 'crno', 'Vino', 'UNFINISHED', 'DRINK', 235.0, 0, 9, 1, 15),
293(60, 'bolonjeze', 'Spagete', 'UNFINISHED', 'FOOD', 560.0, 0, 9, 1, 15),
294(61, '-', 'Karadjordjeva', 'UNFINISHED', 'FOOD', 400.0, 0, 9, 1, 15),
295(62, 'ljuta', 'pljeska', 'UNFINISHED', 'FOOD', 235.0, 0, 9, 1, 15);
296INSERT INTO PUBLIC.ORDER_ITEM(ID, DESCRIPTION, NAME, ORDERSTATUS, ORDERTYPE, PRICE, VERSION, BILL_ID, RESTAURANT_ID, USER_ID) VALUES
297(63, '-', 'Sprite', 'UNFINISHED', 'DRINK', 120.0, 0, 9, 1, 15),
298(64, '-', 'Sprite', 'UNFINISHED', 'DRINK', 120.0, 0, 10, 1, 15),
299(65, 'crno', 'Vino', 'UNFINISHED', 'DRINK', 235.0, 0, 10, 1, 15),
300(66, 'belo', 'Vino', 'UNFINISHED', 'DRINK', 235.0, 0, 10, 1, 15),
301(67, 'bolonjeze', 'Spagete', 'UNFINISHED', 'FOOD', 560.0, 0, 10, 1, 15),
302(68, '-', 'Karadjordjeva', 'UNFINISHED', 'FOOD', 400.0, 0, 10, 1, 15),
303(69, 'ljuta', 'pljeska', 'UNFINISHED', 'FOOD', 235.0, 0, 10, 1, 15);
304CREATE MEMORY TABLE PUBLIC.ORDERS(
305 ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_11992B67_D6F3_45EA_B8FD_84712786FD0D) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_11992B67_D6F3_45EA_B8FD_84712786FD0D,
306 DATE_CREATED TIMESTAMP,
307 FINISHED BOOLEAN,
308 PRICE DOUBLE,
309 VERSION INTEGER DEFAULT 0 NOT NULL,
310 RESERVATION_ID BIGINT,
311 RESTAURANT_ID BIGINT NOT NULL,
312 USER_ID BIGINT NOT NULL
313);
314ALTER TABLE PUBLIC.ORDERS ADD CONSTRAINT PUBLIC.CONSTRAINT_8 PRIMARY KEY(ID);
315-- 10 +/- SELECT COUNT(*) FROM PUBLIC.ORDERS;
316INSERT INTO PUBLIC.ORDERS(ID, DATE_CREATED, FINISHED, PRICE, VERSION, RESERVATION_ID, RESTAURANT_ID, USER_ID) VALUES
317(1, TIMESTAMP '2017-01-21 00:06:00.0', FALSE, 1175.0, 0, NULL, 1, 15),
318(2, TIMESTAMP '2017-01-20 00:06:00.0', FALSE, 1560.0, 0, NULL, 1, 15),
319(3, TIMESTAMP '2017-01-10 00:06:00.0', FALSE, 1560.0, 0, NULL, 1, 15),
320(4, TIMESTAMP '2017-06-22 11:00:00.0', FALSE, 1785.0, 0, 11, 1, 4),
321(5, TIMESTAMP '2017-05-22 11:30:00.0', FALSE, 1785.0, 0, 12, 1, 6),
322(6, TIMESTAMP '2017-06-23 11:30:00.0', FALSE, 3895.0, 0, 13, 1, 6),
323(7, TIMESTAMP '2017-04-30 11:30:00.0', FALSE, 2020.0, 0, 14, 1, 6),
324(8, TIMESTAMP '2017-03-21 00:00:00.0', FALSE, 2020.0, 0, NULL, 1, 15),
325(9, TIMESTAMP '2017-04-21 00:00:00.0', FALSE, 3100.0, 0, NULL, 1, 15),
326(10, TIMESTAMP '2017-06-21 00:00:00.0', FALSE, 1785.0, 0, NULL, 1, 15);
327CREATE MEMORY TABLE PUBLIC.RATE(
328 RATE_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_1860FF04_E4C9_4D1A_A065_90C3C6A3E181) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_1860FF04_E4C9_4D1A_A065_90C3C6A3E181,
329 RATE_FOOD DOUBLE,
330 RATE_OVERALL DOUBLE,
331 RATE_WAITER DOUBLE,
332 RESERVATION_ID BIGINT
333);
334ALTER TABLE PUBLIC.RATE ADD CONSTRAINT PUBLIC.CONSTRAINT_26 PRIMARY KEY(RATE_ID);
335-- 8 +/- SELECT COUNT(*) FROM PUBLIC.RATE;
336INSERT INTO PUBLIC.RATE(RATE_ID, RATE_FOOD, RATE_OVERALL, RATE_WAITER, RESERVATION_ID) VALUES
337(1, 3.0, 3.0, 3.0, 1),
338(2, 3.0, 1.0, 5.0, 2),
339(3, 3.0, 5.0, 1.0, 3),
340(4, 3.0, 4.0, 3.0, 4),
341(5, 5.0, 5.0, 5.0, 11),
342(6, 0.0, 0.0, 0.0, 12),
343(7, 0.0, 0.0, 0.0, 13),
344(8, 0.0, 0.0, 0.0, 14);
345CREATE MEMORY TABLE PUBLIC.RATE_INVITEDNOTRATED(
346 RATE_RATE_ID BIGINT NOT NULL,
347 INVITEDNOTRATED BIGINT
348);
349-- 3 +/- SELECT COUNT(*) FROM PUBLIC.RATE_INVITEDNOTRATED;
350INSERT INTO PUBLIC.RATE_INVITEDNOTRATED(RATE_RATE_ID, INVITEDNOTRATED) VALUES
351(6, 6),
352(7, 6),
353(8, 6);
354CREATE MEMORY TABLE PUBLIC.RESERVATION(
355 ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_81F7C73B_1A05_4B36_B22B_FE7423EA6DFA) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_81F7C73B_1A05_4B36_B22B_FE7423EA6DFA,
356 DATE TIMESTAMP NOT NULL,
357 LENGTH INTEGER NOT NULL,
358 RESTAURANTID BIGINT NOT NULL,
359 RESTAURANTNAME VARCHAR(255) NOT NULL,
360 TABLEID VARCHAR(255) NOT NULL,
361 TIME INTEGER NOT NULL,
362 USERID BIGINT NOT NULL
363);
364ALTER TABLE PUBLIC.RESERVATION ADD CONSTRAINT PUBLIC.CONSTRAINT_23 PRIMARY KEY(ID);
365-- 14 +/- SELECT COUNT(*) FROM PUBLIC.RESERVATION;
366INSERT INTO PUBLIC.RESERVATION(ID, DATE, LENGTH, RESTAURANTID, RESTAURANTNAME, TABLEID, TIME, USERID) VALUES
367(1, TIMESTAMP '2017-12-12 00:00:00.0', 2, 1, 'Rest1', '1,2,3', 10, 5),
368(2, TIMESTAMP '2017-10-12 00:00:00.0', 2, 1, 'Rest1', '1,2,3', 10, 5),
369(3, TIMESTAMP '2017-11-12 00:00:00.0', 2, 1, 'Rest1', '1,2,3', 10, 6),
370(4, TIMESTAMP '2017-05-12 00:00:00.0', 2, 1, 'Rest1', '1,2,3', 10, 6),
371(5, TIMESTAMP '2017-06-12 00:00:00.0', 2, 1, 'Rest1', '1,2,3', 10, 5),
372(6, TIMESTAMP '2017-04-12 00:00:00.0', 2, 1, 'Rest1', '1,2,3', 10, 6),
373(7, TIMESTAMP '2017-01-22 00:06:00.0', 3, 1, 'Rest1', '5', 11, 3),
374(8, TIMESTAMP '2017-05-22 00:05:00.0', 3, 1, 'Rest1', '4', 11, 4),
375(9, TIMESTAMP '2017-06-28 00:05:00.0', 3, 1, 'Rest1', '5', 11, 3),
376(10, TIMESTAMP '2017-03-04 00:06:00.0', 3, 1, 'Rest1', '4', 11, 4),
377(11, TIMESTAMP '2017-03-22 02:00:00.0', 3, 1, 'Rest1', '5', 11, 4),
378(12, TIMESTAMP '2017-04-22 02:00:00.0', 3, 1, 'Rest1', '4', 11, 6),
379(13, TIMESTAMP '2017-05-23 02:00:00.0', 5, 1, 'Rest1', '4', 11, 6),
380(14, TIMESTAMP '2017-06-30 02:00:00.0', 3, 1, 'Rest1', '4', 11, 6);
381CREATE MEMORY TABLE PUBLIC.RESTAURANT(
382 ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_32F6767E_CF87_4A25_A79D_132B01FF1A71) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_32F6767E_CF87_4A25_A79D_132B01FF1A71,
383 CITY VARCHAR(255),
384 DESCRIPTION VARCHAR(255),
385 NAME VARCHAR(255),
386 STREET VARCHAR(255),
387 STREET_NUMBER VARCHAR(255)
388);
389ALTER TABLE PUBLIC.RESTAURANT ADD CONSTRAINT PUBLIC.CONSTRAINT_B3 PRIMARY KEY(ID);
390-- 2 +/- SELECT COUNT(*) FROM PUBLIC.RESTAURANT;
391INSERT INTO PUBLIC.RESTAURANT(ID, CITY, DESCRIPTION, NAME, STREET, STREET_NUMBER) VALUES
392(1, 'Novi Sad', '...', 'Rest1', 'Bulevar Oslobodjenja', '111a'),
393(2, 'Beograd', '...', 'Rest2', 'Bulevar Oslobodjenja', '111a');
394CREATE MEMORY TABLE PUBLIC.RESTAURANT_BIDDER(
395 BIDDER_ID BIGINT NOT NULL,
396 RESTAURANT_ID BIGINT NOT NULL
397);
398-- 3 +/- SELECT COUNT(*) FROM PUBLIC.RESTAURANT_BIDDER;
399INSERT INTO PUBLIC.RESTAURANT_BIDDER(BIDDER_ID, RESTAURANT_ID) VALUES
400(16, 1),
401(17, 1),
402(18, 1);
403CREATE MEMORY TABLE PUBLIC.RESTAURANT_MANAGER(
404 ID BIGINT NOT NULL,
405 RESTAURANT_ID BIGINT
406);
407ALTER TABLE PUBLIC.RESTAURANT_MANAGER ADD CONSTRAINT PUBLIC.CONSTRAINT_20 PRIMARY KEY(ID);
408-- 2 +/- SELECT COUNT(*) FROM PUBLIC.RESTAURANT_MANAGER;
409INSERT INTO PUBLIC.RESTAURANT_MANAGER(ID, RESTAURANT_ID) VALUES
410(8, 1),
411(9, 2);
412CREATE MEMORY TABLE PUBLIC.RESTAURANT_RATES(
413 RESTAURANT_ID BIGINT NOT NULL,
414 RATES DOUBLE
415);
416-- 5 +/- SELECT COUNT(*) FROM PUBLIC.RESTAURANT_RATES;
417INSERT INTO PUBLIC.RESTAURANT_RATES(RESTAURANT_ID, RATES) VALUES
418(1, 3.0),
419(1, 2.0),
420(1, 5.0),
421(1, 4.0),
422(1, 5.0);
423CREATE MEMORY TABLE PUBLIC.RESTAURANT_TABLE(
424 RESTAURANT_TABLE_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_3C6F3CD3_C1EF_4669_9056_95DBAFA87604) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_3C6F3CD3_C1EF_4669_9056_95DBAFA87604,
425 NUMBER INTEGER NOT NULL,
426 POSITIONX INTEGER NOT NULL,
427 POSITIONY INTEGER NOT NULL,
428 SEATS INTEGER NOT NULL,
429 AREA BIGINT NOT NULL
430);
431ALTER TABLE PUBLIC.RESTAURANT_TABLE ADD CONSTRAINT PUBLIC.CONSTRAINT_E PRIMARY KEY(RESTAURANT_TABLE_ID);
432-- 6 +/- SELECT COUNT(*) FROM PUBLIC.RESTAURANT_TABLE;
433INSERT INTO PUBLIC.RESTAURANT_TABLE(RESTAURANT_TABLE_ID, NUMBER, POSITIONX, POSITIONY, SEATS, AREA) VALUES
434(1, 815, 193, 286, 1, 2),
435(2, 228, 291, 283, 2, 2),
436(3, 877, 376, 176, 14, 2),
437(4, 42, 291, 175, 4, 2),
438(5, 9, 192, 173, 4, 2),
439(6, 76, 376, 176, 14, 1);
440CREATE MEMORY TABLE PUBLIC.SHIFT(
441 SHIFT_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_4FBC5CE9_4D9E_41DB_B096_21114380D898) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_4FBC5CE9_4D9E_41DB_B096_21114380D898,
442 END_HOUR TIME NOT NULL,
443 START_HOUR TIME NOT NULL,
444 RESTAURANT_ID BIGINT NOT NULL
445);
446ALTER TABLE PUBLIC.SHIFT ADD CONSTRAINT PUBLIC.CONSTRAINT_4B3 PRIMARY KEY(SHIFT_ID);
447-- 2 +/- SELECT COUNT(*) FROM PUBLIC.SHIFT;
448INSERT INTO PUBLIC.SHIFT(SHIFT_ID, END_HOUR, START_HOUR, RESTAURANT_ID) VALUES
449(1, TIME '16:00:00', TIME '08:00:00', 1),
450(2, TIME '23:00:00', TIME '16:00:00', 1);
451CREATE MEMORY TABLE PUBLIC.SUPPLIES(
452 SUPPLIES_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_C0595938_F63E_4F6B_B6F4_B43942A981FE) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_C0595938_F63E_4F6B_B6F4_B43942A981FE,
453 ACCEPTED_OFFER BOOLEAN,
454 END_DATE TIMESTAMP,
455 NEEDED VARCHAR(255),
456 START_DATE TIMESTAMP,
457 VERSION INTEGER DEFAULT 0 NOT NULL,
458 RESTAURANT_ID BIGINT
459);
460ALTER TABLE PUBLIC.SUPPLIES ADD CONSTRAINT PUBLIC.CONSTRAINT_C PRIMARY KEY(SUPPLIES_ID);
461-- 2 +/- SELECT COUNT(*) FROM PUBLIC.SUPPLIES;
462INSERT INTO PUBLIC.SUPPLIES(SUPPLIES_ID, ACCEPTED_OFFER, END_DATE, NEEDED, START_DATE, VERSION, RESTAURANT_ID) VALUES
463(1, FALSE, TIMESTAMP '2017-06-30 00:00:00.0', 'Slanna i jaja', TIMESTAMP '2017-05-11 00:00:00.0', 0, 1),
464(2, FALSE, TIMESTAMP '2017-06-25 00:00:00.0', 'Crno vino 10l\n Belo vino 10l', TIMESTAMP '2017-05-11 00:00:00.0', 0, 1);
465CREATE MEMORY TABLE PUBLIC.USER(
466 ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_997FEDF7_384E_4AE8_B1FA_CC69BC9A6B69) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_997FEDF7_384E_4AE8_B1FA_CC69BC9A6B69,
467 EMAIL VARCHAR(255) NOT NULL,
468 NAME VARCHAR(255),
469 PASSWORD VARCHAR(255) NOT NULL,
470 ROLE VARCHAR(255),
471 SURNAME VARCHAR(255)
472);
473ALTER TABLE PUBLIC.USER ADD CONSTRAINT PUBLIC.CONSTRAINT_27 PRIMARY KEY(ID);
474-- 19 +/- SELECT COUNT(*) FROM PUBLIC.USER;
475INSERT INTO PUBLIC.USER(ID, EMAIL, NAME, PASSWORD, ROLE, SURNAME) VALUES
476(1, 'kantagara@gmail.com', 'Nikola', 'nikola123', 'ADMIN', 'Garabandic'),
477(2, 'sysman', 'sys ', 'asdf', 'SYSTEM_MANAGER', 'manager'),
478(3, 'guest@gmail.com', 'guest', 'asdf', 'GUEST', 'guest'),
479(4, 'vosmi@gmail.com', 'vosmi', 'vosmi', 'GUEST', 'vosmic'),
480(5, 'djokica@gmail.com', 'djokica', 'djokica', 'GUEST', 'djokica'),
481(6, 'patrik@gmail.com', 'patrik', 'patrik', 'GUEST', 'patrik'),
482(7, 'jugoslav@gmail.com', 'jugoslav', 'jugoslav', 'GUEST', 'jugoslav'),
483(8, 'restman', 'rest', 'asdf', 'RESTAURANT_MANAGER', 'man'),
484(9, 'restman2', 'rest', 'asdf', 'RESTAURANT_MANAGER', 'man'),
485(10, 'employee1', 'veljo', 'asdf', 'WAITER', 'man'),
486(11, 'employee2', 'pero', 'asdf', 'CHEF', 'man'),
487(12, 'employee3', 'krco', 'asdf', 'BARTENDER', 'man'),
488(13, 'employee4', 'raspo', 'asdf', 'CHEF', 'man'),
489(14, 'employee5', 'dila', 'asdf', 'BARTENDER', 'man'),
490(15, 'employee6', 'smrad', 'asdf', 'WAITER', 'man'),
491(16, 'bidder1', 'bidder', 'asdf', 'BIDDER', 'man'),
492(17, 'bidder2', 'bidder', 'asdf', 'BIDDER', 'man'),
493(18, 'bidder3', 'bidder', 'asdf', 'BIDDER', 'man'),
494(19, 'employee nov', 'novi', 'asdf', 'WAITER', 'man');
495ALTER TABLE PUBLIC.USER ADD CONSTRAINT PUBLIC.UK_GMRRM359QU7OGUSDU9R2QR637 UNIQUE(EMAIL);
496ALTER TABLE PUBLIC.SUPPLIES ADD CONSTRAINT PUBLIC.FKF6HQNY2QLKX67XW7OMVHQ2BGC FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
497ALTER TABLE PUBLIC.BID ADD CONSTRAINT PUBLIC.FK2TXYJW0R61TFXTYI4I0JNO0TL FOREIGN KEY(BIDDER_ID) REFERENCES PUBLIC.BIDDER(ID) NOCHECK;
498ALTER TABLE PUBLIC.ORDER_ITEM ADD CONSTRAINT PUBLIC.FKIVVJTN2W1F7PI280YI8KGDFSK FOREIGN KEY(USER_ID) REFERENCES PUBLIC.USER(ID) NOCHECK;
499ALTER TABLE PUBLIC.RATE ADD CONSTRAINT PUBLIC.FKT52FAH9K9IE0SV2PO3AAOQERD FOREIGN KEY(RESERVATION_ID) REFERENCES PUBLIC.RESERVATION(ID) NOCHECK;
500ALTER TABLE PUBLIC.DRINKITEM_RATES ADD CONSTRAINT PUBLIC.FK4RSV5D58OM0VXUSM84MW5HM17 FOREIGN KEY(DRINKITEM_ID) REFERENCES PUBLIC.DRINK_ITEM(ID) NOCHECK;
501ALTER TABLE PUBLIC.RATE_INVITEDNOTRATED ADD CONSTRAINT PUBLIC.FKI93CXNL6MRQPIPIHK6O9MR5GF FOREIGN KEY(RATE_RATE_ID) REFERENCES PUBLIC.RATE(RATE_ID) NOCHECK;
502ALTER TABLE PUBLIC.GUEST ADD CONSTRAINT PUBLIC.FKQQU48M8P6FPBUTEGH1NKGY54D FOREIGN KEY(ID) REFERENCES PUBLIC.USER(ID) NOCHECK;
503ALTER TABLE PUBLIC.EMPLOYEE_SHIFT ADD CONSTRAINT PUBLIC.FKDNSY9WDHMIEFEHNT3824DRU49 FOREIGN KEY(SHIFT_ID) REFERENCES PUBLIC.SHIFT(SHIFT_ID) NOCHECK;
504ALTER TABLE PUBLIC.EMPLOYEE ADD CONSTRAINT PUBLIC.FKCAME4TKE2U6K8ONEBU9JSKGYO FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
505ALTER TABLE PUBLIC.EMPLOYEE_SHIFT ADD CONSTRAINT PUBLIC.FKCTLLHOXEY2MBMSR070FUKV9QA FOREIGN KEY(AREA_ID) REFERENCES PUBLIC.AREA(AREA_ID) NOCHECK;
506ALTER TABLE PUBLIC.SHIFT ADD CONSTRAINT PUBLIC.FKCYIHQXNN5IK9LRY5AGM9978HL FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
507ALTER TABLE PUBLIC.EMPLOYEE_RATES ADD CONSTRAINT PUBLIC.FKIWDLE5E28XG94G7KRDJU6SRFB FOREIGN KEY(EMPLOYEE_ID) REFERENCES PUBLIC.EMPLOYEE(ID) NOCHECK;
508ALTER TABLE PUBLIC.EMPLOYEE ADD CONSTRAINT PUBLIC.FK2FAU84LPW6L6O3RPD2UQDTG84 FOREIGN KEY(ID) REFERENCES PUBLIC.USER(ID) NOCHECK;
509ALTER TABLE PUBLIC.ORDERS ADD CONSTRAINT PUBLIC.FKGKA1QCX3EHODL1TJHF0N11U4C FOREIGN KEY(RESERVATION_ID) REFERENCES PUBLIC.RESERVATION(ID) NOCHECK;
510ALTER TABLE PUBLIC.DRINK_ITEM ADD CONSTRAINT PUBLIC.FK627K0XP4WGBG19SLNBV1PM7CW FOREIGN KEY(FINALORDER_ID) REFERENCES PUBLIC.ORDERS(ID) NOCHECK;
511ALTER TABLE PUBLIC.ORDERS ADD CONSTRAINT PUBLIC.FK996XQT09WG74354FA2T7HOM58 FOREIGN KEY(USER_ID) REFERENCES PUBLIC.USER(ID) NOCHECK;
512ALTER TABLE PUBLIC.RESTAURANT_MANAGER ADD CONSTRAINT PUBLIC.FK8ISHXYNXNJRURJUO0MVLCRDNN FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
513ALTER TABLE PUBLIC.MENUITEM_RATES ADD CONSTRAINT PUBLIC.FK9H6G1O7DRSAE8XBBNHP8G55N5 FOREIGN KEY(MENUITEM_ID) REFERENCES PUBLIC.MENU_ITEM(ID) NOCHECK;
514ALTER TABLE PUBLIC.AREA ADD CONSTRAINT PUBLIC.FK3HL3MMBOU1TJF1TH07Y02AWTI FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
515ALTER TABLE PUBLIC.BID ADD CONSTRAINT PUBLIC.FKM1K1VHVA4KOVGSJFCDLPCDI5V FOREIGN KEY(SUPPLIES_ID) REFERENCES PUBLIC.SUPPLIES(SUPPLIES_ID) NOCHECK;
516ALTER TABLE PUBLIC.ORDER_ITEM ADD CONSTRAINT PUBLIC.FKT6BDYFC81HSP914AD0TUYH50I FOREIGN KEY(BILL_ID) REFERENCES PUBLIC.ORDERS(ID) NOCHECK;
517ALTER TABLE PUBLIC.ORDER_ITEM ADD CONSTRAINT PUBLIC.FK3PKJ02UEFM7HTSKIYHMBR88QR FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
518ALTER TABLE PUBLIC.RESTAURANT_RATES ADD CONSTRAINT PUBLIC.FKQ46SBB4D8TFX1YFPLHJYL5PF8 FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
519ALTER TABLE PUBLIC.BIDDER ADD CONSTRAINT PUBLIC.FK4UVMD18362EW864MTTUDQWDSM FOREIGN KEY(ID) REFERENCES PUBLIC.USER(ID) NOCHECK;
520ALTER TABLE PUBLIC.EMPLOYEE_SHIFT ADD CONSTRAINT PUBLIC.FKAMCFBP52GYX9JMH75CS3HFQU2 FOREIGN KEY(EMPLOYEE_ID) REFERENCES PUBLIC.EMPLOYEE(ID) NOCHECK;
521ALTER TABLE PUBLIC.ORDERS ADD CONSTRAINT PUBLIC.FKB09Y67YGQJ00O2LJ6HSH4QUWU FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
522ALTER TABLE PUBLIC.RESTAURANT_MANAGER ADD CONSTRAINT PUBLIC.FKP3VAT1G53O5M91RH3NGPT8WJ9 FOREIGN KEY(ID) REFERENCES PUBLIC.USER(ID) NOCHECK;
523ALTER TABLE PUBLIC.DRINK_ITEM ADD CONSTRAINT PUBLIC.FK8VXY0YX6HK5SWYT8WCSHYJ4UH FOREIGN KEY(DRINK_CARD_ID) REFERENCES PUBLIC.DRINKCARD(DRINK_CARD_ID) NOCHECK;
524ALTER TABLE PUBLIC.DRINKCARD ADD CONSTRAINT PUBLIC.FKTVAQI1AJ3VU9W4GT160L8QFM FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
525ALTER TABLE PUBLIC.RESTAURANT_BIDDER ADD CONSTRAINT PUBLIC.FKPLDBDR08KHMISM2YFNWMS3F4B FOREIGN KEY(BIDDER_ID) REFERENCES PUBLIC.BIDDER(ID) NOCHECK;
526ALTER TABLE PUBLIC.MENU_ITEM ADD CONSTRAINT PUBLIC.FKRXGNVKA3DA9DECJAEH848SSO4 FOREIGN KEY(FINALORDER_ID) REFERENCES PUBLIC.ORDERS(ID) NOCHECK;
527ALTER TABLE PUBLIC.MENU_ITEM ADD CONSTRAINT PUBLIC.FK48EHRRGKSEG1IMYKYS66CXWTU FOREIGN KEY(MENU_ID) REFERENCES PUBLIC.MENU(MENU_ID) NOCHECK;
528ALTER TABLE PUBLIC.MENU ADD CONSTRAINT PUBLIC.FK8K3H58SA22WM36705F3R5F0R3 FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
529ALTER TABLE PUBLIC.RESTAURANT_BIDDER ADD CONSTRAINT PUBLIC.FKDIG48L45M0GWYLVBX4FGJ1JY9 FOREIGN KEY(RESTAURANT_ID) REFERENCES PUBLIC.RESTAURANT(ID) NOCHECK;
530ALTER TABLE PUBLIC.RESTAURANT_TABLE ADD CONSTRAINT PUBLIC.FKJB9S1865BVSHJOXMVGWW3YEB7 FOREIGN KEY(AREA) REFERENCES PUBLIC.AREA(AREA_ID) NOCHECK;