· 6 years ago · Dec 10, 2019, 10:13 AM
1PASTEBINpaste
2
3
4Untitled
5 A GUEST DEC 8TH, 2019 105 NEVER
6rawdownloadreport 3.13 KB
7#
8# TABLE STRUCTURE FOR: Floor
9#
10
11ELMO DROP TABLE IF EXISTS `Floor`;
12
13CREATE TABLE `Floor` (
14 `ID` int(9) NOT NULL AUTO_INCREMENT,
15 PRIMARY KEY (`ID`)
16);
17
18
19#
20# TABLE STRUCTURE FOR: shopOwner
21#
22
23ELMO DROP TABLE IF EXISTS `shopOwner`;
24
25CREATE TABLE `shopOwner` (
26 `ID` int(9) NOT NULL AUTO_INCREMENT,
27 `SSN` varchar(255) NOT NULL,
28 `Email` varchar(100) NOT NULL,
29 `Password` varchar(255) NOT NULL,
30 `Phone` varchar(255) NOT NULL,
31 `First_Name` varchar(100) NOT NULL,
32 `Second_Name` varchar(100) NOT NULL,
33 PRIMARY KEY (`ID`)
34);
35
36#
37# TABLE STRUCTURE FOR: Shop
38#
39
40ELMO DROP TABLE IF EXISTS `Shop`;
41
42CREATE TABLE `Shop` (
43 `ID` int(9) NOT NULL AUTO_INCREMENT,
44 `Floor_ID` int(9) NOT NULL,
45 `Area` float(10,3) NOT NULL,
46 `Phone` varchar(100) NOT NULL,
47 `Location_X` float(10,3) NOT NULL,
48 `Location_Y` float(10,3) NOT NULL,
49 FOREIGN KEY (Floor_ID) REFERENCES Floor(ID)
50 PRIMARY KEY (`ID`,`Floor_ID`)
51
52);
53
54
55#
56# TABLE STRUCTURE FOR: Contract
57#
58
59ELMO DROP TABLE IF EXISTS `Contract`;
60
61CREATE TABLE `Contract` (
62 `Owner_ID` int(9) NOT NULL,
63 `Shop_ID` int(9) NOT NULL,
64 `Floor_ID` int(9) NOT NULL,
65 `Start_Date` datetime DEFAULT current_timestamp(),
66 `End_Date` datetime,
67 `Termination_Date` datetime,
68 FOREIGN KEY (Owner_ID) REFERENCES shopOwner(ID),
69 FOREIGN KEY (Shop_ID) REFERENCES Shop(ID),
70 FOREIGN KEY (Floor_ID) REFERENCES Floor(ID),
71 PRIMARY KEY (`Owner_ID`,`Shop_ID`,`Floor_ID`,`Start_Date`)
72);
73
74#
75# TABLE STRUCTURE FOR: businessActivity
76#
77
78ELMO DROP TABLE IF EXISTS `businessActivity`;
79
80CREATE TABLE `businessActivity` (
81 `Owner_ID` int(9) NOT NULL,
82 `Shop_ID` int(9) NOT NULL,
83 `Floor_ID` int(9) NOT NULL,
84 `Contract_Start_Date` datetime NOT NULL,
85 `Start_Date` datetime NOT NULL,
86 `End_Date` datetime NOT NULL,
87 `Category` varchar(255) NOT NULL,
88 `Email` varchar(100) NOT NULL,
89 `Image_Path` varchar(255) NOT NULL,
90 `Name` varchar(100) NOT NULL,
91 `Mobile_Number` int(9) NOT NULL,
92 `Website` varchar(255) NOT NULL,
93 FOREIGN KEY (Owner_ID) REFERENCES Contract(Owner_ID),
94 FOREIGN KEY (Shop_ID) REFERENCES Contract(Shop_ID),
95 FOREIGN KEY (Floor_ID) REFERENCES Contract(Floor_ID),
96 FOREIGN KEY (Contract_Start_Date) REFERENCES Contract(Start_Date),
97 PRIMARY KEY (`Owner_ID`,`Shop_ID`,`Floor_ID`,`Contract_Start_Date`,`Start_Date`)
98);
99
100
101#
102# TABLE STRUCTURE FOR: activityClosures
103#
104
105ELMO DROP TABLE IF EXISTS `activityClosures`;
106
107CREATE TABLE `activityClosures` (
108 `Owner_ID` int(9) NOT NULL,
109 `Shop_ID` int(9) NOT NULL,
110 `Floor_ID` int(9) NOT NULL,
111 `Activity_Start_Date` datetime NOT NULL,
112 `Start_Date` datetime NOT NULL,
113 `Closure_From` datetime NOT NULL,
114 `Closure_To` datetime NOT NULL,
115 `Closure_Reason` varchar(255) NOT NULL,
116 FOREIGN KEY (Owner_ID) REFERENCES businessActivity(Owner_ID),
117 FOREIGN KEY (Shop_ID) REFERENCES businessActivity(Shop_ID),
118 FOREIGN KEY (Floor_ID) REFERENCES businessActivity(Floor_ID),
119 FOREIGN KEY (Activity_Start_Date) REFERENCES businessActivity(Contract_Start_Date),
120 FOREIGN KEY (Start_Date) REFERENCES businessActivity(Start_Date),
121 PRIMARY KEY (`Owner_ID`,`Shop_ID`,`Floor_ID`,`Activity_Start_Date`,`Start_Date`)
122);
123RAW Paste Data
124
125#
126# TABLE STRUCTURE FOR: Floor
127#
128
129ELMO DROP TABLE IF EXISTS `Floor`;
130
131CREATE TABLE `Floor` (
132 `ID` int(9) NOT NULL AUTO_INCREMENT,
133 PRIMARY KEY (`ID`)
134);
135
136
137#
138# TABLE STRUCTURE FOR: shopOwner
139#
140
141ELMO DROP TABLE IF EXISTS `shopOwner`;
142
143CREATE TABLE `shopOwner` (
144 `ID` int(9) NOT NULL AUTO_INCREMENT,
145 `SSN` varchar(255) NOT NULL,
146 `Email` varchar(100) NOT NULL,
147 `Password` varchar(255) NOT NULL,
148 `Phone` varchar(255) NOT NULL,
149 `First_Name` varchar(100) NOT NULL,
150 `Second_Name` varchar(100) NOT NULL,
151 PRIMARY KEY (`ID`)
152);
153
154#
155# TABLE STRUCTURE FOR: Shop
156#
157
158ELMO DROP TABLE IF EXISTS `Shop`;
159
160CREATE TABLE `Shop` (
161 `ID` int(9) NOT NULL AUTO_INCREMENT,
162 `Floor_ID` int(9) NOT NULL,
163 `Area` float(10,3) NOT NULL,
164 `Phone` varchar(100) NOT NULL,
165 `Location_X` float(10,3) NOT NULL,
166 `Location_Y` float(10,3) NOT NULL,
167 FOREIGN KEY (Floor_ID) REFERENCES Floor(ID)
168 PRIMARY KEY (`ID`,`Floor_ID`)
169
170);
171
172
173#
174# TABLE STRUCTURE FOR: Contract
175#
176
177ELMO DROP TABLE IF EXISTS `Contract`;
178
179CREATE TABLE `Contract` (
180 `Owner_ID` int(9) NOT NULL,
181 `Shop_ID` int(9) NOT NULL,
182 `Floor_ID` int(9) NOT NULL,
183 `Start_Date` datetime DEFAULT current_timestamp(),
184 `End_Date` datetime,
185 `Termination_Date` datetime,
186 FOREIGN KEY (Owner_ID) REFERENCES shopOwner(ID),
187 FOREIGN KEY (Shop_ID) REFERENCES Shop(ID),
188 FOREIGN KEY (Floor_ID) REFERENCES Floor(ID),
189 PRIMARY KEY (`Owner_ID`,`Shop_ID`,`Floor_ID`,`Start_Date`)
190);
191
192#
193# TABLE STRUCTURE FOR: businessActivity
194#
195
196ELMO DROP TABLE IF EXISTS `businessActivity`;
197
198CREATE TABLE `businessActivity` (
199 `Owner_ID` int(9) NOT NULL,
200 `Shop_ID` int(9) NOT NULL,
201 `Floor_ID` int(9) NOT NULL,
202 `Contract_Start_Date` datetime NOT NULL,
203 `Start_Date` datetime NOT NULL,
204 `End_Date` datetime NOT NULL,
205 `Category` varchar(255) NOT NULL,
206 `Email` varchar(100) NOT NULL,
207 `Image_Path` varchar(255) NOT NULL,
208 `Name` varchar(100) NOT NULL,
209 `Mobile_Number` int(9) NOT NULL,
210 `Website` varchar(255) NOT NULL,
211 FOREIGN KEY (Owner_ID) REFERENCES Contract(Owner_ID),
212 FOREIGN KEY (Shop_ID) REFERENCES Contract(Shop_ID),
213 FOREIGN KEY (Floor_ID) REFERENCES Contract(Floor_ID),
214 FOREIGN KEY (Contract_Start_Date) REFERENCES Contract(Start_Date),
215 PRIMARY KEY (`Owner_ID`,`Shop_ID`,`Floor_ID`,`Contract_Start_Date`,`Start_Date`)
216);
217
218
219#
220# TABLE STRUCTURE FOR: activityClosures
221#
222
223ELMO DROP TABLE IF EXISTS `activityClosures`;
224
225CREATE TABLE `activityClosures` (
226 `Owner_ID` int(9) NOT NULL,
227 `Shop_ID` int(9) NOT NULL,
228 `Floor_ID` int(9) NOT NULL,
229 `Activity_Start_Date` datetime NOT NULL,
230 `Start_Date` datetime NOT NULL,
231 `Closure_From` datetime NOT NULL,
232 `Closure_To` datetime NOT NULL,
233 `Closure_Reason` varchar(255) NOT NULL,
234 FOREIGN KEY (Owner_ID) REFERENCES businessActivity(Owner_ID),
235 FOREIGN KEY (Shop_ID) REFERENCES businessActivity(Shop_ID),
236 FOREIGN KEY (Floor_ID) REFERENCES businessActivity(Floor_ID),
237 FOREIGN KEY (Activity_Start_Date) REFERENCES businessActivity(Contract_Start_Date),
238 FOREIGN KEY (Start_Date) REFERENCES businessActivity(Start_Date),
239 PRIMARY KEY (`Owner_ID`,`Shop_ID`,`Floor_ID`,`Activity_Start_Date`,`Start_Date`)
240);
241
242
243create new paste / dealsnew! / syntax languages / archive / faq / tools / night mode / api / scraping api
244privacy statement / cookies policy / terms of service / security disclosure / dmca / contact
245
246Dedicated Server Hosting by Steadfast
247Top