· 8 years ago · Apr 04, 2018, 02:00 PM
1-- MySQL Script generated by MySQL Workbench
2-- Tue Mar 27 13:09:38 2018
3-- Model: New Model Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema showroom
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema showroom
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `showroom` DEFAULT CHARACTER SET utf8 ;
18USE `showroom` ;
19
20-- -----------------------------------------------------
21-- Table `showroom`.`car_manufactures`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `showroom`.`car_manufactures` (
24 `id` INT NOT NULL,
25 `name` VARCHAR(45) NULL,
26 `description` VARCHAR(45) NULL,
27 `is_active` TINYINT NULL,
28 `created_at` DATETIME NULL,
29 `updated_at` DATETIME NULL,
30 PRIMARY KEY (`id`))
31ENGINE = InnoDB;
32
33
34-- -----------------------------------------------------
35-- Table `showroom`.`category`
36-- -----------------------------------------------------
37CREATE TABLE IF NOT EXISTS `showroom`.`category` (
38 `category_id` INT NOT NULL,
39 `name` VARCHAR(255) NOT NULL,
40 PRIMARY KEY (`category_id`));
41
42
43-- -----------------------------------------------------
44-- Table `showroom`.`car_models`
45-- -----------------------------------------------------
46CREATE TABLE IF NOT EXISTS `showroom`.`car_models` (
47 `id` VARCHAR(10) NOT NULL,
48 `name` VARCHAR(45) NULL,
49 `is_active` TINYINT NULL,
50 `created_at` DATETIME NULL,
51 `updated_at` DATETIME NULL,
52 `deleted_at` DATETIME NULL,
53 `car_manufactures_id` INT NOT NULL,
54 PRIMARY KEY (`id`, `car_manufactures_id`),
55 INDEX `fk_car_models_car_manufactures_idx` (`car_manufactures_id` ASC),
56 CONSTRAINT `fk_car_models_car_manufactures`
57 FOREIGN KEY (`car_manufactures_id`)
58 REFERENCES `showroom`.`car_manufactures` (`id`)
59 ON DELETE NO ACTION
60 ON UPDATE NO ACTION);
61
62
63-- -----------------------------------------------------
64-- Table `showroom`.`car_types`
65-- -----------------------------------------------------
66CREATE TABLE IF NOT EXISTS `showroom`.`car_types` (
67 `id` VARCHAR(10) NOT NULL,
68 `name` VARCHAR(45) NULL,
69 `created_at` DATETIME NULL,
70 `updated_at` DATETIME NULL,
71 `deleted_at` DATETIME NULL,
72 PRIMARY KEY (`id`));
73
74
75-- -----------------------------------------------------
76-- Table `showroom`.`features`
77-- -----------------------------------------------------
78CREATE TABLE IF NOT EXISTS `showroom`.`features` (
79 `id` VARCHAR(10) NOT NULL,
80 `created_at` DATETIME NULL,
81 `updated_at` DATETIME NULL,
82 `deleted_at` DATETIME NULL,
83 `name` VARCHAR(45) NULL,
84 `description` VARCHAR(45) NULL,
85 PRIMARY KEY (`id`));
86
87
88-- -----------------------------------------------------
89-- Table `showroom`.`car_for_sal_features`
90-- -----------------------------------------------------
91CREATE TABLE IF NOT EXISTS `showroom`.`car_for_sal_features` (
92 `id` VARCHAR(10) NOT NULL,
93 `created_at` DATETIME NULL,
94 `updated_at` DATETIME NULL,
95 `deleted_at` DATETIME NULL,
96 `car_for_sale_id` VARCHAR(45) NULL,
97 `features_id` VARCHAR(10) NOT NULL,
98 PRIMARY KEY (`id`, `features_id`),
99 INDEX `fk_car_for_sal_features_features1_idx` (`features_id` ASC),
100 CONSTRAINT `fk_car_for_sal_features_features1`
101 FOREIGN KEY (`features_id`)
102 REFERENCES `showroom`.`features` (`id`)
103 ON DELETE NO ACTION
104 ON UPDATE NO ACTION);
105
106
107-- -----------------------------------------------------
108-- Table `showroom`.`users`
109-- -----------------------------------------------------
110CREATE TABLE IF NOT EXISTS `showroom`.`users` (
111 `id` VARCHAR(10) NOT NULL,
112 `created_at` DATETIME NULL,
113 `updated_at` DATETIME NULL,
114 `deleted_at` DATETIME NULL,
115 `username` VARCHAR(45) NULL,
116 `password` VARCHAR(45) NULL,
117 `email` VARCHAR(45) NULL,
118 `mobile_phone` VARCHAR(45) NULL,
119 `first_name` VARCHAR(45) NULL,
120 `middle_name` VARCHAR(45) NULL,
121 `last_name` VARCHAR(45) NULL,
122 `salutation` VARCHAR(45) NULL,
123 `photo` VARCHAR(45) NULL,
124 `gender` VARCHAR(45) NULL,
125 `date_of_birth` VARCHAR(45) NULL,
126 `register_at` VARCHAR(45) NULL,
127 `verified_at` VARCHAR(45) NULL,
128 `last_login_at` VARCHAR(45) NULL,
129 `status` VARCHAR(45) NULL,
130 PRIMARY KEY (`id`));
131
132
133-- -----------------------------------------------------
134-- Table `showroom`.`car_for-sales`
135-- -----------------------------------------------------
136CREATE TABLE IF NOT EXISTS `showroom`.`car_for-sales` (
137 `id` VARCHAR(10) NOT NULL,
138 `created_at` DATETIME NULL,
139 `updated_at` DATETIME NULL,
140 `deleted_at` DATETIME NULL,
141 `seller_user_id` VARCHAR(45) NULL,
142 `asking_price` VARCHAR(45) NULL,
143 `color` VARCHAR(45) NULL,
144 `current_mileafe` VARCHAR(45) NULL,
145 `manufacture_year` VARCHAR(45) NULL,
146 `assembly_year` VARCHAR(45) NULL,
147 `date-acquired` VARCHAR(45) NULL,
148 `is_used` VARCHAR(45) NULL,
149 `car_models_id` VARCHAR(10) NOT NULL,
150 `car_types_id` VARCHAR(10) NOT NULL,
151 `car_for_sal_features_id` VARCHAR(10) NOT NULL,
152 `users_id` VARCHAR(10) NOT NULL,
153 PRIMARY KEY (`id`, `car_models_id`, `car_types_id`, `car_for_sal_features_id`, `users_id`),
154 INDEX `fk_car_for-sales_car_models1_idx` (`car_models_id` ASC),
155 INDEX `fk_car_for-sales_car_types1_idx` (`car_types_id` ASC),
156 INDEX `fk_car_for-sales_car_for_sal_features1_idx` (`car_for_sal_features_id` ASC),
157 INDEX `fk_car_for-sales_users1_idx` (`users_id` ASC),
158 CONSTRAINT `fk_car_for-sales_car_models1`
159 FOREIGN KEY (`car_models_id`)
160 REFERENCES `showroom`.`car_models` (`id`)
161 ON DELETE NO ACTION
162 ON UPDATE NO ACTION,
163 CONSTRAINT `fk_car_for-sales_car_types1`
164 FOREIGN KEY (`car_types_id`)
165 REFERENCES `showroom`.`car_types` (`id`)
166 ON DELETE NO ACTION
167 ON UPDATE NO ACTION,
168 CONSTRAINT `fk_car_for-sales_car_for_sal_features1`
169 FOREIGN KEY (`car_for_sal_features_id`)
170 REFERENCES `showroom`.`car_for_sal_features` (`id`)
171 ON DELETE NO ACTION
172 ON UPDATE NO ACTION,
173 CONSTRAINT `fk_car_for-sales_users1`
174 FOREIGN KEY (`users_id`)
175 REFERENCES `showroom`.`users` (`id`)
176 ON DELETE NO ACTION
177 ON UPDATE NO ACTION);
178
179
180-- -----------------------------------------------------
181-- Table `showroom`.`car_for_sale_images`
182-- -----------------------------------------------------
183CREATE TABLE IF NOT EXISTS `showroom`.`car_for_sale_images` (
184 `id` VARCHAR(10) NOT NULL,
185 `created_at` DATETIME NULL,
186 `updated_at` DATETIME NULL,
187 `deleted_at` DATETIME NULL,
188 `car_for-sales_id` VARCHAR(10) NOT NULL,
189 PRIMARY KEY (`id`, `car_for-sales_id`),
190 INDEX `fk_car_for_sale_images_car_for-sales1_idx` (`car_for-sales_id` ASC),
191 CONSTRAINT `fk_car_for_sale_images_car_for-sales1`
192 FOREIGN KEY (`car_for-sales_id`)
193 REFERENCES `showroom`.`car_for-sales` (`id`)
194 ON DELETE NO ACTION
195 ON UPDATE NO ACTION);
196
197
198-- -----------------------------------------------------
199-- Table `showroom`.`car_for_sale_comments`
200-- -----------------------------------------------------
201CREATE TABLE IF NOT EXISTS `showroom`.`car_for_sale_comments` (
202 `id` VARCHAR(10) NOT NULL,
203 `created_at` DATETIME NULL,
204 `updated_at` DATETIME NULL,
205 `deleted_at` DATETIME NULL,
206 `comment` VARCHAR(45) NULL,
207 `user_id` VARCHAR(45) NULL,
208 `car_for-sales_id` VARCHAR(10) NOT NULL,
209 PRIMARY KEY (`id`, `car_for-sales_id`),
210 INDEX `fk_car_for_sale_comments_car_for-sales1_idx` (`car_for-sales_id` ASC),
211 CONSTRAINT `fk_car_for_sale_comments_car_for-sales1`
212 FOREIGN KEY (`car_for-sales_id`)
213 REFERENCES `showroom`.`car_for-sales` (`id`)
214 ON DELETE NO ACTION
215 ON UPDATE NO ACTION);
216
217
218-- -----------------------------------------------------
219-- Table `showroom`.`orders`
220-- -----------------------------------------------------
221CREATE TABLE IF NOT EXISTS `showroom`.`orders` (
222 `id` VARCHAR(10) NOT NULL,
223 `created_at` DATETIME NULL,
224 `updated_at` DATETIME NULL,
225 `deleted_at` DATETIME NULL,
226 `invoice_number` VARCHAR(45) NULL,
227 `car_for_sales_id` VARCHAR(45) NULL,
228 `agreed_price` VARCHAR(45) NULL,
229 `status` VARCHAR(45) NULL,
230 `expired_at` VARCHAR(45) NULL,
231 `users_id` VARCHAR(10) NOT NULL,
232 PRIMARY KEY (`id`, `users_id`),
233 INDEX `fk_orders_users1_idx` (`users_id` ASC),
234 CONSTRAINT `fk_orders_users1`
235 FOREIGN KEY (`users_id`)
236 REFERENCES `showroom`.`users` (`id`)
237 ON DELETE NO ACTION
238 ON UPDATE NO ACTION);
239
240
241-- -----------------------------------------------------
242-- Table `showroom`.`user_addresses`
243-- -----------------------------------------------------
244CREATE TABLE IF NOT EXISTS `showroom`.`user_addresses` (
245 `id` VARCHAR(10) NOT NULL,
246 `created_at` DATETIME NULL,
247 `updated_at` DATETIME NULL,
248 `deleted_at` DATETIME NULL,
249 `address_name` VARCHAR(45) NULL,
250 `address` VARCHAR(45) NULL,
251 `city` VARCHAR(45) NULL,
252 `state` VARCHAR(45) NULL,
253 `country` VARCHAR(45) NULL,
254 `zipcode` VARCHAR(45) NULL,
255 `users_id` VARCHAR(10) NOT NULL,
256 PRIMARY KEY (`id`, `users_id`),
257 INDEX `fk_user_addresses_users1_idx` (`users_id` ASC),
258 CONSTRAINT `fk_user_addresses_users1`
259 FOREIGN KEY (`users_id`)
260 REFERENCES `showroom`.`users` (`id`)
261 ON DELETE NO ACTION
262 ON UPDATE NO ACTION);
263
264
265-- -----------------------------------------------------
266-- Table `showroom`.`payment_types`
267-- -----------------------------------------------------
268CREATE TABLE IF NOT EXISTS `showroom`.`payment_types` (
269 `id` VARCHAR(10) NOT NULL,
270 `created_at` DATETIME NULL,
271 `updated_at` DATETIME NULL,
272 `deleted_at` DATETIME NULL,
273 `name` VARCHAR(45) NULL,
274 `is_active` VARCHAR(45) NULL,
275 PRIMARY KEY (`id`));
276
277
278-- -----------------------------------------------------
279-- Table `showroom`.`order_payments`
280-- -----------------------------------------------------
281CREATE TABLE IF NOT EXISTS `showroom`.`order_payments` (
282 `id` VARCHAR(10) NOT NULL,
283 `created_at` DATETIME NULL,
284 `updated_at` DATETIME NULL,
285 `deleted_at` DATETIME NULL,
286 `customer_name` VARCHAR(45) NULL,
287 `customer_phone` VARCHAR(45) NULL,
288 `customer_email` VARCHAR(45) NULL,
289 `payment_fee` VARCHAR(45) NULL,
290 `billed_amount` VARCHAR(45) NULL,
291 `payment_reffnum` VARCHAR(45) NULL,
292 `payment_status` VARCHAR(45) NULL,
293 `payment_trx_time` VARCHAR(45) NULL,
294 `orders_id` VARCHAR(10) NOT NULL,
295 `payment_types_id` VARCHAR(10) NOT NULL,
296 PRIMARY KEY (`id`, `orders_id`, `payment_types_id`),
297 INDEX `fk_order_payments_payment_types1_idx` (`payment_types_id` ASC),
298 INDEX `fk_order_payments_orders1_idx` (`orders_id` ASC),
299 CONSTRAINT `fk_order_payments_payment_types1`
300 FOREIGN KEY (`payment_types_id`)
301 REFERENCES `showroom`.`payment_types` (`id`)
302 ON DELETE NO ACTION
303 ON UPDATE NO ACTION,
304 CONSTRAINT `fk_order_payments_orders1`
305 FOREIGN KEY (`orders_id`)
306 REFERENCES `showroom`.`orders` (`id`)
307 ON DELETE NO ACTION
308 ON UPDATE NO ACTION);
309
310
311SET SQL_MODE=@OLD_SQL_MODE;
312SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
313SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;