--
-- Host: localhost    Database: carapp
-- ------------------------------------------------------


--
-- Table structure for table `bank_accounts`
--

CREATE TABLE `bank_accounts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `account_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `swift_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reseason_for_remittance` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bank_accounts`
--

INSERT INTO `bank_accounts` VALUES (1,'KMC Japan Co., Ltd.','3161104','THE NISHI-NIPPON CITY BANK, LTD.','HAKOZAKI BRANCH','FUKUOKA-SHI,HIGASHI-KU,HAKOZAKI 1-28-12','NISIJPJT','Payment for Car/Parts Purchase with Invoice Number.',NULL,NULL);

--
-- Table structure for table `body_styles`
--

CREATE TABLE `body_styles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` tinyint NOT NULL DEFAULT '1',
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `body_styles`
--

INSERT INTO `body_styles` VALUES (1,'Sedans',1,NULL,NULL,NULL),(2,'Buses',1,NULL,NULL,NULL),(3,'Trucs',1,NULL,NULL,NULL),(4,'Coupes',1,NULL,NULL,NULL),(5,'Wagons',1,NULL,NULL,NULL),(6,'Van & MiniVans',1,NULL,NULL,NULL),(7,'Hatchs',1,NULL,NULL,NULL),(8,'Mini Vehicles',1,NULL,NULL,NULL);

--
-- Table structure for table `brands`
--

CREATE TABLE `brands` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` tinyint NOT NULL DEFAULT '1',
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `brands_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `brands`
--

INSERT INTO `brands` VALUES (1,'TOYOTA',1,NULL,NULL,NULL),(2,'LEXUS',1,NULL,NULL,NULL),(3,'NISSAN',1,NULL,NULL,NULL),(4,'HONDA',1,NULL,NULL,NULL),(5,'MAZDA',1,NULL,NULL,NULL),(6,'EUNOS',1,NULL,NULL,NULL),(7,'MCC SMART',1,NULL,NULL,NULL),(8,'BMW',1,NULL,NULL,NULL);

--
-- Table structure for table `car_conditions`
--

CREATE TABLE `car_conditions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `car_conditions`
--

INSERT INTO `car_conditions` VALUES (1,'Non-smoking Car',NULL,NULL),(2,'One Owner',NULL,NULL),(3,'Maintenance Record Available',NULL,NULL);

--
-- Table structure for table `car_equipment`
--

CREATE TABLE `car_equipment` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `car_id` bigint unsigned NOT NULL,
  `equipment_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `car_equipment_car_id_foreign` (`car_id`),
  KEY `car_equipment_equipment_id_foreign` (`equipment_id`),
  CONSTRAINT `car_equipment_car_id_foreign` FOREIGN KEY (`car_id`) REFERENCES `cars` (`id`) ON DELETE CASCADE,
  CONSTRAINT `car_equipment_equipment_id_foreign` FOREIGN KEY (`equipment_id`) REFERENCES `equipment` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `car_equipment`
--


--
-- Table structure for table `car_interior_exterior`
--

CREATE TABLE `car_interior_exterior` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `car_id` bigint unsigned NOT NULL,
  `interior_exterior_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `car_interior_exterior_car_id_foreign` (`car_id`),
  KEY `car_interior_exterior_interior_exterior_id_foreign` (`interior_exterior_id`),
  CONSTRAINT `car_interior_exterior_car_id_foreign` FOREIGN KEY (`car_id`) REFERENCES `cars` (`id`) ON DELETE CASCADE,
  CONSTRAINT `car_interior_exterior_interior_exterior_id_foreign` FOREIGN KEY (`interior_exterior_id`) REFERENCES `interior_exteriors` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `car_interior_exterior`
--

INSERT INTO `car_interior_exterior` VALUES (5,2,33,NULL,NULL),(6,2,32,NULL,NULL);

--
-- Table structure for table `car_safety_equipment`
--

CREATE TABLE `car_safety_equipment` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `car_id` bigint unsigned NOT NULL,
  `safety_equipment_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `car_safety_equipment_car_id_foreign` (`car_id`),
  KEY `car_safety_equipment_safety_equipment_id_foreign` (`safety_equipment_id`),
  CONSTRAINT `car_safety_equipment_car_id_foreign` FOREIGN KEY (`car_id`) REFERENCES `cars` (`id`) ON DELETE CASCADE,
  CONSTRAINT `car_safety_equipment_safety_equipment_id_foreign` FOREIGN KEY (`safety_equipment_id`) REFERENCES `safety_equipment` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `car_safety_equipment`
--

INSERT INTO `car_safety_equipment` VALUES (16,2,7,NULL,NULL),(17,2,6,NULL,NULL),(18,2,5,NULL,NULL);

--
-- Table structure for table `car_self_driving`
--

CREATE TABLE `car_self_driving` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `car_id` bigint unsigned NOT NULL,
  `self_driving_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `car_self_driving_car_id_foreign` (`car_id`),
  KEY `car_self_driving_self_driving_id_foreign` (`self_driving_id`),
  CONSTRAINT `car_self_driving_car_id_foreign` FOREIGN KEY (`car_id`) REFERENCES `cars` (`id`) ON DELETE CASCADE,
  CONSTRAINT `car_self_driving_self_driving_id_foreign` FOREIGN KEY (`self_driving_id`) REFERENCES `self_drivings` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `car_self_driving`
--


--
-- Table structure for table `car_standard_feature`
--

CREATE TABLE `car_standard_feature` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `car_id` bigint unsigned NOT NULL,
  `standard_feature_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `car_standard_feature_car_id_foreign` (`car_id`),
  KEY `car_standard_feature_standard_feature_id_foreign` (`standard_feature_id`),
  CONSTRAINT `car_standard_feature_car_id_foreign` FOREIGN KEY (`car_id`) REFERENCES `cars` (`id`) ON DELETE CASCADE,
  CONSTRAINT `car_standard_feature_standard_feature_id_foreign` FOREIGN KEY (`standard_feature_id`) REFERENCES `standard_features` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `car_standard_feature`
--

INSERT INTO `car_standard_feature` VALUES (7,2,4,NULL,NULL);

--
-- Table structure for table `cars`
--

CREATE TABLE `cars` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `brand_id` bigint unsigned NOT NULL,
  `model_id` bigint unsigned DEFAULT NULL,
  `body_style_id` bigint unsigned NOT NULL,
  `color_id` bigint unsigned DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` double(15,2) unsigned NOT NULL,
  `stock_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_year` date DEFAULT NULL,
  `car_up_date` date DEFAULT NULL,
  `mileage` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `repaired` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `steering` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transmission` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fuel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drive_system` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doors` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `displacement` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `chassis_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `car_location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `is_gallery` tinyint(1) NOT NULL DEFAULT '0',
  `description` text COLLATE utf8mb4_unicode_ci,
  `images` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `mileage_type` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seating_capacity` int DEFAULT NULL,
  `cubic_meter` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cars_stock_no_unique` (`stock_no`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cars`
--

INSERT INTO `cars` VALUES (1,8,1,8,14,'DSWE',1000.00,'10002333',NULL,'2026-05-21','10','NONE','LEFT','AT','GASOLINE','2WD','5D','10',NULL,NULL,NULL,1,0,NULL,NULL,'2026-05-21 11:23:58','2026-05-21 11:23:58','KM',1,10),(2,8,1,8,8,'DSWE',1000.00,'100023332',NULL,'2026-05-21','10','NONE','LEFT','AT','GASOLINE','2WD','5D','10',NULL,NULL,NULL,1,0,NULL,NULL,'2026-05-21 11:24:17','2026-05-21 11:26:05','KM',1,10);

--
-- Table structure for table `carts`
--

CREATE TABLE `carts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `car_id` bigint unsigned NOT NULL,
  `quantity` int NOT NULL,
  `unit_price` double(15,2) unsigned NOT NULL,
  `total_price` double(15,2) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `carts_user_id_foreign` (`user_id`),
  CONSTRAINT `carts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `carts`
--


--
-- Table structure for table `certification_files`
--

CREATE TABLE `certification_files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `original_file_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `extension` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fileable_type` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fileable_id` bigint NOT NULL,
  `certificate_type` tinyint NOT NULL DEFAULT '1' COMMENT '1 - English, 2 - Japanese',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `certification_files`
--


--
-- Table structure for table `colors`
--

CREATE TABLE `colors` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `colors`
--

INSERT INTO `colors` VALUES (1,'white',NULL,NULL,NULL),(2,'red',NULL,NULL,NULL),(3,'blue',NULL,NULL,NULL),(4,'green',NULL,NULL,NULL),(5,'black',NULL,NULL,NULL),(6,'brown',NULL,NULL,NULL),(7,'purple',NULL,NULL,NULL),(8,'yellow',NULL,NULL,NULL),(9,'orange',NULL,NULL,NULL),(10,'pink',NULL,NULL,NULL),(11,'dark-pink',NULL,NULL,NULL),(12,'gray',NULL,NULL,NULL),(13,'gradient-purple',NULL,NULL,NULL),(14,'gradient-yellow',NULL,NULL,NULL);

--
-- Table structure for table `condition_info`
--

CREATE TABLE `condition_info` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `car_id` bigint unsigned NOT NULL,
  `car_condition_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `condition_info_car_id_foreign` (`car_id`),
  KEY `condition_info_car_condition_id_foreign` (`car_condition_id`),
  CONSTRAINT `condition_info_car_condition_id_foreign` FOREIGN KEY (`car_condition_id`) REFERENCES `car_conditions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `condition_info_car_id_foreign` FOREIGN KEY (`car_id`) REFERENCES `cars` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `condition_info`
--

INSERT INTO `condition_info` VALUES (9,2,3,NULL,NULL),(10,2,2,NULL,NULL),(11,2,1,NULL,NULL);

--
-- Table structure for table `contact_us`
--

CREATE TABLE `contact_us` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_country_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_country_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `is_received_news` tinyint(1) NOT NULL DEFAULT '0',
  `is_agreed` tinyint(1) NOT NULL DEFAULT '0',
  `carId` bigint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_us`
--


--
-- Table structure for table `customer_feedback`
--

CREATE TABLE `customer_feedback` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `car_id` bigint unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `rating` double(8,2) NOT NULL DEFAULT '0.00',
  `type` tinyint NOT NULL DEFAULT '1' COMMENT '1 - web, 2 - admin',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `customer_feedback_car_id_foreign` (`car_id`),
  CONSTRAINT `customer_feedback_car_id_foreign` FOREIGN KEY (`car_id`) REFERENCES `cars` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_feedback`
--


--
-- Table structure for table `delivery_addresses`
--

CREATE TABLE `delivery_addresses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `addressType` tinyint NOT NULL COMMENT '1-Home, 2-Office',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alternative_mobile_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` int DEFAULT NULL,
  `city` int DEFAULT NULL,
  `area` int DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `delivery_addresses_user_id_foreign` (`user_id`),
  CONSTRAINT `delivery_addresses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `delivery_addresses`
--


--
-- Table structure for table `equipment`
--

CREATE TABLE `equipment` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `equipment`
--

INSERT INTO `equipment` VALUES (1,'Driver Seat Airbag /Passenger Seat Airbag',NULL,NULL),(2,'Manual Sliding Door on Both Sides',NULL,NULL),(3,'Sun / Moon Roof',NULL,NULL),(4,'ABC',NULL,NULL),(5,'Air Conditioner',NULL,NULL),(6,'Double Air-conditioner',NULL,NULL),(7,'Lift Up',NULL,NULL),(8,'Downhill Assist Control',NULL,NULL),(9,'Power Steering',NULL,NULL),(10,'Power Window',NULL,NULL),(11,'Anti-theft Device',NULL,NULL),(12,'Idling Stop',NULL,NULL),(13,'Drive Recorder',NULL,NULL),(14,'USB Input Terminal',NULL,NULL),(15,'Bluetooth Connection',NULL,NULL),(16,'100V Power Supply',NULL,NULL),(17,'Clean Diesel',NULL,NULL),(18,'Center Differential Lock',NULL,NULL),(19,'Electric Retractable Mirror',NULL,NULL);

--
-- Table structure for table `f_a_q_s`
--

CREATE TABLE `f_a_q_s` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `question` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `f_a_q_s`
--


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `feedback_files`
--

CREATE TABLE `feedback_files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `file_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_feedback_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feedback_files`
--


--
-- Table structure for table `files`
--

CREATE TABLE `files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `file_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `extension` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fileable_type` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fileable_id` bigint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `files`
--


--
-- Table structure for table `gallery_images`
--

CREATE TABLE `gallery_images` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gallery_images`
--


--
-- Table structure for table `interior_exteriors`
--

CREATE TABLE `interior_exteriors` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `interior_exteriors`
--

INSERT INTO `interior_exteriors` VALUES (1,'TV & Navigation /Memory Navi etc.',NULL,NULL),(2,'TV (full segment)',NULL,NULL),(3,'Music Player Connectable /CD or CD Changer /Music Server',NULL,NULL),(4,'DVD Playback',NULL,NULL),(5,'Alloy Wheel',NULL,NULL),(6,'Leather Seat',NULL,NULL),(7,'Half Leather Seat',NULL,NULL),(8,'Keyless',NULL,NULL),(9,'LED Headlamp',NULL,NULL),(10,'HID (xenon light)',NULL,NULL),(11,'Back Camera',NULL,NULL),(12,'ETC',NULL,NULL),(13,'Aero',NULL,NULL),(14,'Smart Key',NULL,NULL),(15,'Lowdown',NULL,NULL),(16,'Run Flat Tire',NULL,NULL),(17,'Power Seats',NULL,NULL),(18,'3-row Seat',NULL,NULL),(19,'Bench Seat',NULL,NULL),(20,'Full Flat Sheet',NULL,NULL),(21,'Tip Up Seat',NULL,NULL),(22,'Ottoman',NULL,NULL),(23,'Electric Retractable Third Seat',NULL,NULL),(24,'Seat Heater',NULL,NULL),(25,'Walk Through',NULL,NULL),(26,'Electric Rear Gate',NULL,NULL),(27,'Front Camera',NULL,NULL),(28,'Seat Air Conditioner',NULL,NULL),(29,'All-around Camera',NULL,NULL),(30,'Side Camera',NULL,NULL),(31,'Roof Rail',NULL,NULL),(32,'Air Suspension',NULL,NULL),(33,'Headlight Washer',NULL,NULL);

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(5,'2021_08_30_070906_create_models_table',1),(6,'2021_08_30_071925_create_brands_table',1),(7,'2021_08_30_072041_create_colors_table',1),(8,'2021_08_30_072106_create_body_styles_table',1),(9,'2021_09_06_031051_create_car_conditions_table',1),(10,'2021_09_06_031121_create_standard_features_table',1),(11,'2021_09_06_031141_create_equipment_table',1),(12,'2021_09_06_031308_create_cars_table',1),(13,'2021_09_06_031757_create_interior_exteriors_table',1),(14,'2021_09_06_031815_create_self_drivings_table',1),(15,'2021_09_06_031833_create_safety_equipment_table',1),(16,'2021_09_27_182618_create_condition_info_table',1),(17,'2021_09_28_164418_create_car_standard_feature_table',1),(18,'2021_09_28_164606_create_car_equipment_table',1),(19,'2021_09_28_164726_create_car_interior_exterior_table',1),(20,'2021_09_28_164831_create_car_self_driving_table',1),(21,'2021_09_28_164939_create_car_safety_equipment_table',1),(22,'2021_09_30_143800_create_files_table',1),(23,'2021_10_03_062356_create_f_a_q_s_table',1),(24,'2021_12_04_165617_create_gallery_images_table',1),(25,'2022_01_13_024834_create_price_calculators_table',1),(26,'2021_11_25_162012_create_carts_table',2),(27,'2021_12_09_161656_create_orders_table',2),(28,'2021_12_13_144919_create_delivery_addresses_table',2),(29,'2021_12_18_054408_create_customer_feedback_table',2),(30,'2021_12_18_061411_create_feedback_files_table',2),(31,'2021_12_28_025646_create_order_items_table',2),(32,'2022_01_09_043039_create_contact_us_table',2),(33,'2022_04_30_033535_create_social_accounts_table',2),(34,'2022_05_28_041828_create_bank_accounts_table',2),(35,'2022_07_02_135918_create_payments_table',2),(36,'2022_08_04_041012_create_certification_files_table',2),(37,'2023_02_07_161457_create_user_contacts_table',2);

--
-- Table structure for table `models`
--

CREATE TABLE `models` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` tinyint NOT NULL DEFAULT '1',
  `brand_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `models`
--

INSERT INTO `models` VALUES (1,'First',1,8,'2026-04-19 20:00:11','2026-04-19 20:00:11');

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint unsigned NOT NULL,
  `car_id` bigint unsigned NOT NULL,
  `quantity` int NOT NULL,
  `unit_price` double(15,2) unsigned NOT NULL,
  `total_price` double(15,2) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_items`
--


--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_number` int unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `order_date` datetime DEFAULT NULL,
  `cancel_datetime` datetime DEFAULT NULL COMMENT 'By Customer',
  `payment_type` tinyint NOT NULL COMMENT '0 - cash, 8 - card',
  `country_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `port` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `marine_insurance` tinyint NOT NULL DEFAULT '0' COMMENT '0 - unchecked, 1 - checked',
  `pre_export_inspection` tinyint NOT NULL DEFAULT '0' COMMENT '0 - unchecked, 1 - checked',
  `marine_insurance_amount` double unsigned NOT NULL DEFAULT '0',
  `pre_export_inspection_amount` double unsigned NOT NULL DEFAULT '0',
  `user_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_country_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_country_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_message` text COLLATE utf8mb4_unicode_ci,
  `item_total_price` double unsigned NOT NULL DEFAULT '0' COMMENT 'Total Item Price without Delivery Charge Item',
  `delivery_charge` double unsigned NOT NULL DEFAULT '0' COMMENT 'Delivery Charge if any',
  `item_consumption_tax` double unsigned NOT NULL DEFAULT '0' COMMENT 'Item Consumption Tax',
  `total_quantity` double unsigned NOT NULL DEFAULT '0' COMMENT 'Total Quantity of all items',
  `total_price` double unsigned NOT NULL DEFAULT '0' COMMENT 'Total Price of all items, Tax and Delivery Charge',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '1 - Processing, 2 - Approved, 3 - On shipping, 4 - Shipped, 5- Completed, 6- Cancelled',
  `transaction_status` tinyint NOT NULL DEFAULT '1' COMMENT '1 - Incomplete Transaction, 2 - Complete Transaction',
  `transaction_id` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `isPaid` tinyint NOT NULL DEFAULT '0' COMMENT '0 - unpaid, 1 - paid',
  `discount` double unsigned NOT NULL DEFAULT '0',
  `paid_amount` double unsigned NOT NULL DEFAULT '0',
  `ship_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voyage_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ship_date` date DEFAULT NULL,
  `est_arrival_date` date DEFAULT NULL,
  `invoice_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice_date` date DEFAULT NULL,
  `inspec_request_date` date DEFAULT NULL,
  `tracking_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_date` date DEFAULT NULL,
  `cons_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cons_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cons_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cons_country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cons_city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cons_shipper` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cons_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `documents` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `certificate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` bigint unsigned NOT NULL COMMENT 'Created by User Id',
  `updated_by` bigint unsigned DEFAULT NULL COMMENT 'Updated by User Id',
  `deleted_by` bigint unsigned DEFAULT NULL COMMENT 'Cancelled by User Id',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--


--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `payment_amount` double unsigned NOT NULL DEFAULT '0',
  `due_amount` double unsigned NOT NULL DEFAULT '0',
  `isPaid` tinyint NOT NULL DEFAULT '0' COMMENT '0 - paid, 1 - refund',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payments`
--


--
-- Table structure for table `price_calculators`
--

CREATE TABLE `price_calculators` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `country` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `port` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `delivery_charge` double(8,2) NOT NULL,
  `marine_insurance` double(8,2) NOT NULL,
  `pre_export_inspection` double(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `price_calculators`
--


--
-- Table structure for table `safety_equipment`
--

CREATE TABLE `safety_equipment` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `safety_equipment`
--

INSERT INTO `safety_equipment` VALUES (1,'ESC (Electronic Stability Control)',NULL,NULL),(2,'Collision Safety Body',NULL,NULL),(3,'Collision Damage Reduction System',NULL,NULL),(4,'Clearance Sonar',NULL,NULL),(5,'Automatic High Beam',NULL,NULL),(6,'Auto Light',NULL,NULL),(7,'Active Headrest',NULL,NULL);

--
-- Table structure for table `self_drivings`
--

CREATE TABLE `self_drivings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `self_drivings`
--

INSERT INTO `self_drivings` VALUES (1,'Auto Cruise Control',NULL,NULL),(2,'Lane Keep Assist',NULL,NULL),(3,'Automatic Parking System',NULL,NULL),(4,'Park Assist',NULL,NULL);

--
-- Table structure for table `social_accounts`
--

CREATE TABLE `social_accounts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `provider_user_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `provider` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `social_accounts`
--


--
-- Table structure for table `standard_features`
--

CREATE TABLE `standard_features` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `standard_features`
--

INSERT INTO `standard_features` VALUES (1,'Seating Capacity 2',NULL,NULL),(2,'Supercharger',NULL,NULL),(3,'Cold Weather Specification Car',NULL,NULL),(4,'Welfare Vehicles',NULL,NULL);

--
-- Table structure for table `user_contacts`
--

CREATE TABLE `user_contacts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `choice` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_contacts_user_id_foreign` (`user_id`),
  CONSTRAINT `user_contacts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_contacts`
--



