· 9 years ago · Jan 13, 2017, 01:04 AM
1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema artistlancer
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema artistlancer
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `artistlancer` DEFAULT CHARACTER SET utf8 ;
15USE `artistlancer` ;
16
17-- -----------------------------------------------------
18-- Table `artistlancer`.`artist`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `artistlancer`.`artist` (
21 `id` INT(11) NOT NULL DEFAULT 0,
22 `name` VARCHAR(20) NULL,
23 `profile` VARCHAR(45) NULL,
24 `profession` VARCHAR(45) NULL,
25 `location` VARCHAR(45) NULL,
26 `portfolio` VARCHAR(45) NULL,
27 `availability` TINYINT(1) NULL,
28 `category` INT NULL,
29 PRIMARY KEY (`id`),
30 UNIQUE INDEX `id_UNIQUE` (`id` ASC))
31ENGINE = InnoDB;
32
33
34-- -----------------------------------------------------
35-- Table `artistlancer`.`model`
36-- -----------------------------------------------------
37CREATE TABLE IF NOT EXISTS `artistlancer`.`model` (
38 `id` INT(11) NOT NULL,
39 `artist_id` INT(11) NULL,
40 `age` INT(3) NULL,
41 `height` FLOAT(11) NULL,
42 `bust` FLOAT(11) NULL,
43 `waist` FLOAT(11) NULL,
44 `hip` FLOAT(11) NULL,
45 `ethnicity` VARCHAR(45) NULL,
46 `cup` VARCHAR(2) NULL,
47 `dress` INT(5) NULL,
48 `shoe` FLOAT(3) NULL,
49 `haircolor` VARCHAR(15) NULL,
50 `hairlength` FLOAT(11) NULL,
51 `eyecolor` VARCHAR(15) NULL,
52 `shootnudes` TINYINT(1) NULL,
53 `tattoos` FLOAT(11) NULL,
54 `piercings` FLOAT(11) NULL,
55 PRIMARY KEY (`id`))
56ENGINE = InnoDB;
57
58
59-- -----------------------------------------------------
60-- Table `artistlancer`.`client`
61-- -----------------------------------------------------
62CREATE TABLE IF NOT EXISTS `artistlancer`.`client` (
63 `id` INT(11) NOT NULL,
64 `profile` VARCHAR(45) NULL,
65 `name` VARCHAR(45) NULL,
66 `profession` VARCHAR(45) NULL,
67 `location` VARCHAR(45) NULL,
68 `description` VARCHAR(45) NULL,
69 PRIMARY KEY (`id`))
70ENGINE = InnoDB;
71
72
73-- -----------------------------------------------------
74-- Table `artistlancer`.`personal_renter`
75-- -----------------------------------------------------
76CREATE TABLE IF NOT EXISTS `artistlancer`.`personal_renter` (
77 `id` INT(11) NOT NULL,
78 `profile` VARCHAR(45) NULL,
79 `name` VARCHAR(45) NULL,
80 `profession` VARCHAR(45) NULL,
81 `location` VARCHAR(45) NULL,
82 PRIMARY KEY (`id`))
83ENGINE = InnoDB;
84
85
86-- -----------------------------------------------------
87-- Table `artistlancer`.`chat_content`
88-- -----------------------------------------------------
89CREATE TABLE IF NOT EXISTS `artistlancer`.`chat_content` (
90 `id` INT(11) NOT NULL,
91 `chatroom_id` VARCHAR(45) NULL,
92 `text` VARCHAR(200) NULL,
93 `picture` VARCHAR(200) NULL,
94 `date` DATETIME NULL,
95 `read` TINYINT(1) NULL,
96 PRIMARY KEY (`id`))
97ENGINE = InnoDB;
98
99
100-- -----------------------------------------------------
101-- Table `artistlancer`.`chat_idx`
102-- -----------------------------------------------------
103CREATE TABLE IF NOT EXISTS `artistlancer`.`chat_idx` (
104 `id` INT(11) NOT NULL,
105 `employer` INT(11) NULL,
106 `employee` INT(11) NULL,
107 `chatroom_id` VARCHAR(100) NULL,
108 PRIMARY KEY (`id`))
109ENGINE = InnoDB;
110
111
112-- -----------------------------------------------------
113-- Table `artistlancer`.`category`
114-- -----------------------------------------------------
115CREATE TABLE IF NOT EXISTS `artistlancer`.`category` (
116 `id` INT(11) NOT NULL,
117 `genre` VARCHAR(45) NULL,
118 PRIMARY KEY (`id`))
119ENGINE = InnoDB;
120
121
122-- -----------------------------------------------------
123-- Table `artistlancer`.`pictures`
124-- -----------------------------------------------------
125CREATE TABLE IF NOT EXISTS `artistlancer`.`pictures` (
126 `id` INT(11) NOT NULL,
127 `url` VARCHAR(45) NULL,
128 `user_id` INT(11) NULL,
129 PRIMARY KEY (`id`))
130ENGINE = InnoDB;
131
132
133-- -----------------------------------------------------
134-- Table `artistlancer`.`user`
135-- -----------------------------------------------------
136CREATE TABLE IF NOT EXISTS `artistlancer`.`user` (
137 `id` INT NOT NULL,
138 `name` VARCHAR(45) NULL,
139 `email` VARCHAR(45) NULL,
140 `password` VARCHAR(45) NULL,
141 `birthday` DATETIME NULL,
142 `gender` TINYINT(1) NULL,
143 `tier` INT(11) NULL,
144 `membership` INT(11) NULL,
145 PRIMARY KEY (`id`))
146ENGINE = InnoDB;
147
148
149-- -----------------------------------------------------
150-- Table `artistlancer`.`videos`
151-- -----------------------------------------------------
152CREATE TABLE IF NOT EXISTS `artistlancer`.`videos` (
153 `id` INT(11) NOT NULL,
154 `url` VARCHAR(45) NULL,
155 `user_id` INT(11) NULL,
156 PRIMARY KEY (`id`))
157ENGINE = InnoDB;
158
159
160-- -----------------------------------------------------
161-- Table `artistlancer`.`admin`
162-- -----------------------------------------------------
163CREATE TABLE IF NOT EXISTS `artistlancer`.`admin` (
164 `id` INT(11) NOT NULL,
165 `username` VARCHAR(45) NULL,
166 `password` VARCHAR(45) NULL,
167 PRIMARY KEY (`id`))
168ENGINE = InnoDB;
169
170
171-- -----------------------------------------------------
172-- Table `artistlancer`.`job`
173-- -----------------------------------------------------
174CREATE TABLE IF NOT EXISTS `artistlancer`.`job` (
175 `id` INT(11) NOT NULL,
176 `title` VARCHAR(45) NULL,
177 `description` VARCHAR(45) NULL,
178 `preferences` VARCHAR(45) NULL,
179 `right` VARCHAR(45) NULL,
180 `territory` VARCHAR(45) NULL,
181 `deadline` INT(11) NULL,
182 `budget` FLOAT(20) NULL,
183 `client_id` VARCHAR(45) NULL,
184 `jobbidroom_id` VARCHAR(45) NULL,
185 `employeeroom_id` VARCHAR(45) NULL,
186 PRIMARY KEY (`id`))
187ENGINE = InnoDB;
188
189
190-- -----------------------------------------------------
191-- Table `artistlancer`.`jobbid_room`
192-- -----------------------------------------------------
193CREATE TABLE IF NOT EXISTS `artistlancer`.`jobbid_room` (
194 `id` INT(11) NOT NULL,
195 `user_id` INT(11) NULL,
196 `jobbidroom_id` VARCHAR(45) NULL,
197 `budget` FLOAT(20) NULL,
198 `chatroom_id` VARCHAR(45) NULL,
199 PRIMARY KEY (`id`))
200ENGINE = InnoDB;
201
202
203-- -----------------------------------------------------
204-- Table `artistlancer`.`tfp`
205-- -----------------------------------------------------
206CREATE TABLE IF NOT EXISTS `artistlancer`.`tfp` (
207 `id` INT(11) NOT NULL,
208 `title` VARCHAR(45) NULL,
209 `description` VARCHAR(45) NULL,
210 `preferences` VARCHAR(45) NULL,
211 `right` VARCHAR(45) NULL,
212 `territory` VARCHAR(45) NULL,
213 `deadline` INT(11) NULL,
214 `incentives` VARCHAR(45) NULL,
215 `artist_id` INT(11) NULL,
216 `bidroom_id` VARCHAR(45) NULL,
217 `employeeroom_id` VARCHAR(45) NULL,
218 `budget` FLOAT(20) NULL,
219 PRIMARY KEY (`id`))
220ENGINE = InnoDB;
221
222
223-- -----------------------------------------------------
224-- Table `artistlancer`.`employee_room`
225-- -----------------------------------------------------
226CREATE TABLE IF NOT EXISTS `artistlancer`.`employee_room` (
227 `id` INT(11) NOT NULL,
228 `user_id` INT(11) NULL,
229 `employeeroom_id` VARCHAR(45) NULL,
230 PRIMARY KEY (`id`))
231ENGINE = InnoDB;
232
233
234-- -----------------------------------------------------
235-- Table `artistlancer`.`prop`
236-- -----------------------------------------------------
237CREATE TABLE IF NOT EXISTS `artistlancer`.`prop` (
238 `id` INT(11) NOT NULL,
239 `title` VARCHAR(45) NULL,
240 `preferences` VARCHAR(45) NULL,
241 `right` VARCHAR(45) NULL,
242 `territory` VARCHAR(45) NULL,
243 `deadline` INT(11) NULL,
244 `price_day` FLOAT(20) NULL,
245 `artist_id` INT(11) NULL,
246 `bidroom_id` VARCHAR(45) NULL,
247 `employeeroom_id` VARCHAR(45) NULL,
248 `can_ship` TINYINT(1) NULL,
249 `days` INT(11) NULL,
250 `type` TINYINT(1) NULL,
251 PRIMARY KEY (`id`))
252ENGINE = InnoDB;
253
254
255-- -----------------------------------------------------
256-- Table `artistlancer`.`location`
257-- -----------------------------------------------------
258CREATE TABLE IF NOT EXISTS `artistlancer`.`location` (
259 `id` INT(11) NOT NULL,
260 `title` VARCHAR(45) NULL,
261 `description` VARCHAR(45) NULL,
262 `preferences` VARCHAR(45) NULL,
263 `right` VARCHAR(45) NULL,
264 `territory` VARCHAR(45) NULL,
265 `deadline` INT(11) NULL,
266 `price_day` FLOAT(20) NULL,
267 `client_id` VARCHAR(45) NULL,
268 `bidroom_id` VARCHAR(45) NULL,
269 `employeeroom_id` VARCHAR(45) NULL,
270 `type` VARCHAR(45) NULL,
271 `days` VARCHAR(45) NULL,
272 PRIMARY KEY (`id`))
273ENGINE = InnoDB;
274
275
276-- -----------------------------------------------------
277-- Table `artistlancer`.`equipment`
278-- -----------------------------------------------------
279CREATE TABLE IF NOT EXISTS `artistlancer`.`equipment` (
280 `id` INT(11) NOT NULL,
281 `title` VARCHAR(45) NULL,
282 `description` VARCHAR(45) NULL,
283 `condition` VARCHAR(45) NULL,
284 `right` VARCHAR(45) NULL,
285 `territory` VARCHAR(45) NULL,
286 `deadline` INT(11) NULL,
287 `price_day` FLOAT(20) NULL,
288 `client_id` VARCHAR(45) NULL,
289 `bidroom_id` VARCHAR(45) NULL,
290 `employeeroom_id` VARCHAR(45) NULL,
291 `days` INT(11) NULL,
292 PRIMARY KEY (`id`))
293ENGINE = InnoDB;
294
295
296-- -----------------------------------------------------
297-- Table `artistlancer`.`tfpbid_room`
298-- -----------------------------------------------------
299CREATE TABLE IF NOT EXISTS `artistlancer`.`tfpbid_room` (
300 `id` INT(11) NOT NULL,
301 `user_id` INT(11) NULL,
302 `tfpbidroom_id` VARCHAR(45) NULL,
303 `budget` FLOAT(20) NULL,
304 PRIMARY KEY (`id`))
305ENGINE = InnoDB;
306
307
308-- -----------------------------------------------------
309-- Table `artistlancer`.`locationbid_room`
310-- -----------------------------------------------------
311CREATE TABLE IF NOT EXISTS `artistlancer`.`locationbid_room` (
312 `id` INT(11) NOT NULL,
313 `user_id` INT(11) NULL,
314 `locationbidroom_id` VARCHAR(45) NULL,
315 `price_day` FLOAT(20) NULL,
316 `days` INT(11) NULL,
317 `chatroom_id` VARCHAR(45) NULL,
318 PRIMARY KEY (`id`))
319ENGINE = InnoDB;
320
321
322-- -----------------------------------------------------
323-- Table `artistlancer`.`equipmentbid_room`
324-- -----------------------------------------------------
325CREATE TABLE IF NOT EXISTS `artistlancer`.`equipmentbid_room` (
326 `id` INT(11) NOT NULL,
327 `user_id` INT(11) NULL,
328 `equipmentbidroom_id` VARCHAR(45) NULL,
329 `price_day` FLOAT(20) NULL,
330 `days` INT(11) NULL,
331 `chatroom_id` VARCHAR(45) NULL,
332 PRIMARY KEY (`id`))
333ENGINE = InnoDB;
334
335
336-- -----------------------------------------------------
337-- Table `artistlancer`.`propbid_room`
338-- -----------------------------------------------------
339CREATE TABLE IF NOT EXISTS `artistlancer`.`propbid_room` (
340 `id` INT(11) NOT NULL,
341 `user_id` INT(11) NULL,
342 `propbidroom_id` VARCHAR(45) NULL,
343 `price_day` FLOAT(20) NULL,
344 `days` INT(11) NULL,
345 `chatroom_id` VARCHAR(45) NULL,
346 PRIMARY KEY (`id`))
347ENGINE = InnoDB;
348
349
350-- -----------------------------------------------------
351-- Table `artistlancer`.`feedbacks`
352-- -----------------------------------------------------
353CREATE TABLE IF NOT EXISTS `artistlancer`.`feedbacks` (
354 `id` INT(11) NOT NULL,
355 `text` VARCHAR(200) NULL,
356 `picture` VARCHAR(200) NULL,
357 `date` DATETIME NULL,
358 `poster` INT(11) NULL,
359 PRIMARY KEY (`id`))
360ENGINE = InnoDB;
361
362
363SET SQL_MODE=@OLD_SQL_MODE;
364SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
365SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;