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