hedena_gold/oapi-struncture.sql

/*
 Navicat Premium Dump SQL

 Source Server         : Henza
 Source Server Type    : MySQL
 Source Server Version : 80042 (8.0.42-0ubuntu0.20.04.1)
 Source Host           : localhost:3305
 Source Schema         : oapi

 Target Server Type    : MySQL
 Target Server Version : 80042 (8.0.42-0ubuntu0.20.04.1)
 File Encoding         : 65001

 Date: 05/10/2026 11:28:53
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for accounts_address
-- ----------------------------
DROP TABLE IF EXISTS `accounts_address`;
CREATE TABLE `accounts_address`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `reciver_lname` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `reciver_fname` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `reciver_phone` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `reciver_fixed_phone` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `province` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `city` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `zipcode` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `address` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `latitude` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `longitude` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `is_default` tinyint(1) NULL DEFAULT NULL,
  `user_id_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 167 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for accounts_effectivedate
-- ----------------------------
DROP TABLE IF EXISTS `accounts_effectivedate`;
CREATE TABLE `accounts_effectivedate`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `date` timestamp NOT NULL,
  `user_id_id` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `accounts_effectivedate_user_id_id_7b8962ff`(`user_id_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for accounts_profile
-- ----------------------------
DROP TABLE IF EXISTS `accounts_profile`;
CREATE TABLE `accounts_profile`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `sex` smallint NULL DEFAULT NULL,
  `major_type` smallint NULL DEFAULT NULL,
  `fixed_phone` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `fixed_phone_1` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `fixed_phone_2` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `national_code` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `province` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `city` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `address` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `cart_number` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `introduce_code` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `cargo_code` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `company` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `website` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `telegram` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `instagram` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `printed_name` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `gold_credit` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `rial_credit` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `account_code` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `birth_date` date NULL DEFAULT NULL,
  `marriage_date` date NULL DEFAULT NULL,
  `effective_date` date NULL DEFAULT NULL,
  `sales_ceiling` double NULL DEFAULT NULL,
  `carrying_ceiling` double NULL DEFAULT NULL,
  `last_order_id` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `meta` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `tags` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `verified` tinyint(1) NOT NULL,
  `orders_count` int NULL DEFAULT NULL,
  `total_spent` double NULL DEFAULT NULL,
  `total_score` int NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `marketer_id` int NULL DEFAULT NULL,
  `national_card_pic_id` int NULL DEFAULT NULL,
  `shop_pic_id` int NULL DEFAULT NULL,
  `user_id_id` int NOT NULL,
  `user_pic_id` int NULL DEFAULT NULL,
  `affiliateـbrands` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `commission` double NULL DEFAULT NULL,
  `introduced_id` int NULL DEFAULT NULL,
  `relatedـfactories` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `profit` double NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `accounts_profile_user_id_id_key`(`user_id_id` ASC) USING BTREE,
  INDEX `accounts_profile_introduced_id_77f8ce2a`(`introduced_id` ASC) USING BTREE,
  INDEX `accounts_profile_marketer_id_ba5cf774`(`marketer_id` ASC) USING BTREE,
  INDEX `accounts_profile_national_card_pic_id_864f7a93`(`national_card_pic_id` ASC) USING BTREE,
  INDEX `accounts_profile_shop_pic_id_fd393568`(`shop_pic_id` ASC) USING BTREE,
  INDEX `accounts_profile_user_pic_id_b6422aa4`(`user_pic_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for accounts_rolepermission
-- ----------------------------
DROP TABLE IF EXISTS `accounts_rolepermission`;
CREATE TABLE `accounts_rolepermission`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `role` int NOT NULL,
  `permission` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `accounts_rolepermission_role_permission_4c663109_uniq`(`permission` ASC, `role` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for apk_log
-- ----------------------------
DROP TABLE IF EXISTS `apk_log`;
CREATE TABLE `apk_log`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for auth_permission
-- ----------------------------
DROP TABLE IF EXISTS `auth_permission`;
CREATE TABLE `auth_permission`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `content_type_id` int NOT NULL,
  `codename` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 169 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for branches
-- ----------------------------
DROP TABLE IF EXISTS `branches`;
CREATE TABLE `branches`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `user_id` int NULL DEFAULT NULL,
  `is_active` tinyint(1) NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for cashes
-- ----------------------------
DROP TABLE IF EXISTS `cashes`;
CREATE TABLE `cashes`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` int UNSIGNED NULL DEFAULT NULL,
  `customer_id` int UNSIGNED NOT NULL COMMENT 'شناسه مشتری',
  `input` double NULL DEFAULT NULL,
  `output` double NULL DEFAULT NULL,
  `remain` double NULL DEFAULT NULL,
  `rial_input` bigint UNSIGNED NULL DEFAULT NULL,
  `rial_output` bigint UNSIGNED NULL DEFAULT NULL,
  `rial_remain` bigint UNSIGNED NULL DEFAULT NULL,
  `type` tinyint NULL DEFAULT NULL COMMENT 'نوع سند',
  `sts` tinyint NULL DEFAULT NULL COMMENT 'وضعیت سند ',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'تاریخ ایجاد',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'تاریخ ویرایش',
  `deleted_at` timestamp NULL DEFAULT NULL COMMENT 'تاریخ حذف',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'عنوان سند ',
  `to` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'حواله به ',
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'توضیحات',
  `ayar` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'عیار',
  `lab` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'نام آزمایشگاه ',
  `balance` double NULL DEFAULT NULL,
  `value` double NULL DEFAULT NULL,
  `original_value` double NULL DEFAULT NULL COMMENT 'میزان گرم اعمالی در سند',
  `price` bigint NULL DEFAULT NULL COMMENT 'میزان پول دریافتی یا مبلغ چک در سند های پولی و چکی',
  `confirmed` tinyint(1) NULL DEFAULT NULL COMMENT 'وضعیت سند تایید شده یا نشده',
  `no` bigint NULL DEFAULT NULL,
  `proceed_at` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `account_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'نام صاحب حساب - برای سند چک',
  `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'نام بانک - برای سند چک',
  `recive_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'تاریخ دریافت سند ',
  `order_id` int NULL DEFAULT NULL COMMENT 'شماره سفارش - برای سند های ثبت سفارش',
  `ang` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'انگ - برای سند های آب شده',
  `price_per_gram` double NULL DEFAULT NULL COMMENT 'مظنه ( قیمت یک گرم طلا) - برای سند های پولی',
  `discount` double NULL DEFAULT NULL COMMENT 'جمع کل تخفیف  - برای سند های فروش',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1032 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for category_collect
-- ----------------------------
DROP TABLE IF EXISTS `category_collect`;
CREATE TABLE `category_collect`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `position` int NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `collection_id_id` int NOT NULL,
  `post_id_id` int NULL DEFAULT NULL,
  `product_id_id` int NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `category_collect_collection_id_id_22215592`(`collection_id_id` ASC) USING BTREE,
  INDEX `category_collect_post_id_id_11e334e1`(`post_id_id` ASC) USING BTREE,
  INDEX `category_collect_product_id_id_c5260e5c`(`product_id_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7126 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for category_collection
-- ----------------------------
DROP TABLE IF EXISTS `category_collection`;
CREATE TABLE `category_collection`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `body_html` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `meta` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `rules` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `category_type` int NULL DEFAULT NULL,
  `disjunctive` tinyint(1) NULL DEFAULT NULL,
  `published` tinyint(1) NULL DEFAULT NULL,
  `published_at` timestamp NULL DEFAULT NULL,
  `is_active` tinyint(1) NULL DEFAULT 1,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `image_id_id` int NULL DEFAULT NULL,
  `parent_id_id` int NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `priority` smallint NULL DEFAULT NULL,
  `is_master` smallint NULL DEFAULT NULL,
  `image_id` int NULL DEFAULT NULL,
  `total` int NOT NULL DEFAULT 0,
  `icon_id` int NULL DEFAULT NULL,
  `type` tinyint NULL DEFAULT NULL,
  `body` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `disabled` tinyint(1) UNSIGNED ZEROFILL NOT NULL,
  `header` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `category_collection_image_id_id_f41753e4`(`image_id_id` ASC) USING BTREE,
  INDEX `category_collection_parent_id_id_f9fb60cd`(`parent_id_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for cinies
-- ----------------------------
DROP TABLE IF EXISTS `cinies`;
CREATE TABLE `cinies`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `icon_id` int NULL DEFAULT NULL,
  `is_active` tinyint(1) NULL DEFAULT 1,
  `description` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `collection_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 118 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for ciny_products
-- ----------------------------
DROP TABLE IF EXISTS `ciny_products`;
CREATE TABLE `ciny_products`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `ciny_id` int NULL DEFAULT NULL,
  `product_id` int NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7173 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for cities
-- ----------------------------
DROP TABLE IF EXISTS `cities`;
CREATE TABLE `cities`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `parent` int UNSIGNED NULL DEFAULT NULL,
  `level` int UNSIGNED NULL DEFAULT NULL,
  `has_children` tinyint(1) NOT NULL DEFAULT 0,
  `percent` double(8, 2) UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `percent_aux` double(8, 2) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for cities5
-- ----------------------------
DROP TABLE IF EXISTS `cities5`;
CREATE TABLE `cities5`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `parent` int UNSIGNED NULL DEFAULT NULL,
  `level` int UNSIGNED NULL DEFAULT NULL,
  `has_children` tinyint(1) NOT NULL DEFAULT 0,
  `percent` double(8, 2) UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `percent_aux` double(8, 2) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1591 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for citiesB
-- ----------------------------
DROP TABLE IF EXISTS `citiesB`;
CREATE TABLE `citiesB`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `parent` int UNSIGNED NULL DEFAULT NULL,
  `level` int UNSIGNED NULL DEFAULT NULL,
  `percent` double(8, 2) UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `percent_aux` double(8, 2) NULL DEFAULT NULL,
  `has_children` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for cities_copy11
-- ----------------------------
DROP TABLE IF EXISTS `cities_copy11`;
CREATE TABLE `cities_copy11`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `parent` int UNSIGNED NULL DEFAULT NULL,
  `level` tinyint NULL DEFAULT NULL,
  `has_children` tinyint(1) NOT NULL DEFAULT 0,
  `percent` double(8, 2) UNSIGNED NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `percent_aux` double(8, 2) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1602 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for comments
-- ----------------------------
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `customer_id` bigint NULL DEFAULT NULL,
  `product_id` bigint NULL DEFAULT NULL,
  `comment` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NULL DEFAULT NULL,
  `reply_to` bigint NULL DEFAULT NULL,
  `sts` tinyint NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 79 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_persian_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for config_statics
-- ----------------------------
DROP TABLE IF EXISTS `config_statics`;
CREATE TABLE `config_statics`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `val` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `key` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 145 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for custom_order_logs
-- ----------------------------
DROP TABLE IF EXISTS `custom_order_logs`;
CREATE TABLE `custom_order_logs`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `custom_order_id` int NULL DEFAULT NULL,
  `changes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `description` varchar(955) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `ip_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'تاریخ ایجاد',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'تاریخ به روز رسانی',
  `deleted_at` timestamp NULL DEFAULT NULL COMMENT 'تاریخ حذف',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for custom_orders
-- ----------------------------
DROP TABLE IF EXISTS `custom_orders`;
CREATE TABLE `custom_orders`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_id` int NULL DEFAULT NULL,
  `file_id` int NULL DEFAULT NULL,
  `city_id` int UNSIGNED NULL DEFAULT NULL,
  `workshop_id` int NULL DEFAULT NULL,
  `sts` tinyint NULL DEFAULT NULL COMMENT 'وضعیت سفارش',
  `weight` double NULL DEFAULT NULL,
  `color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `sum` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `color_stone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `color_mina` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'تاریخ ایجاد',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'تاریخ به روز رسانی',
  `deleted_at` timestamp NULL DEFAULT NULL COMMENT 'تاریخ حذف',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for customers
-- ----------------------------
DROP TABLE IF EXISTS `customers`;
CREATE TABLE `customers`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `fname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `lname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `name` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ncode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `send_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `input` double NULL DEFAULT NULL,
  `output` double NULL DEFAULT NULL,
  `remain` double NULL DEFAULT 0,
  `rial_input` bigint UNSIGNED NULL DEFAULT NULL,
  `rial_output` bigint UNSIGNED NULL DEFAULT NULL,
  `rial_remain` bigint NULL DEFAULT 0,
  `reagent_id` int UNSIGNED NULL DEFAULT NULL,
  `type` tinyint NULL DEFAULT NULL,
  `sts` tinyint NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `api_token` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `rnd` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `notify_count` int NOT NULL DEFAULT 0,
  `total_order` int NOT NULL DEFAULT 0,
  `gram_level` double NOT NULL DEFAULT 0,
  `percent` double NULL DEFAULT NULL,
  `open_order` int NOT NULL DEFAULT 0,
  `child` int NOT NULL DEFAULT 0,
  `phone` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `token_mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `grams_sell` double NULL DEFAULT 0,
  `store_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `zone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `pasazh_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `count_login` bigint NULL DEFAULT 0,
  `active` tinyint NULL DEFAULT NULL,
  `birth_date` timestamp NULL DEFAULT NULL,
  `marriage_date` timestamp NULL DEFAULT NULL,
  `city_id` int UNSIGNED NULL DEFAULT NULL,
  `image_id` int NULL DEFAULT NULL,
  `mcode` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `is_archive` tinyint(1) NULL DEFAULT 0,
  `business_license_image_id` int NULL DEFAULT NULL,
  `shop_image_id` int NULL DEFAULT NULL,
  `ncode_image_id` int NULL DEFAULT NULL,
  `sts_verify_step_one` tinyint(1) NULL DEFAULT NULL,
  `sts_verify_step_two` tinyint(1) NULL DEFAULT NULL,
  `new_city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1723 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for customers_copy1
-- ----------------------------
DROP TABLE IF EXISTS `customers_copy1`;
CREATE TABLE `customers_copy1`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `fname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `lname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `name` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ncode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `send_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `input` double NULL DEFAULT NULL,
  `output` double NULL DEFAULT NULL,
  `remain` double NULL DEFAULT 0,
  `rial_input` bigint UNSIGNED NULL DEFAULT NULL,
  `rial_output` bigint UNSIGNED NULL DEFAULT NULL,
  `rial_remain` bigint NULL DEFAULT 0,
  `reagent_id` int UNSIGNED NULL DEFAULT NULL,
  `type` tinyint NULL DEFAULT NULL,
  `sts` tinyint NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `api_token` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `rnd` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `notify_count` int NOT NULL DEFAULT 0,
  `total_order` int NOT NULL DEFAULT 0,
  `gram_level` double NOT NULL DEFAULT 0,
  `percent` double NULL DEFAULT NULL,
  `open_order` int NOT NULL DEFAULT 0,
  `child` int NOT NULL DEFAULT 0,
  `phone` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `token_mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `grams_sell` double NULL DEFAULT 0,
  `store_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `zone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `pasazh_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `count_login` bigint NULL DEFAULT 0,
  `active` tinyint NULL DEFAULT NULL,
  `birth_date` timestamp NULL DEFAULT NULL,
  `marriage_date` timestamp NULL DEFAULT NULL,
  `city_id` int UNSIGNED NULL DEFAULT NULL,
  `image_id` int NULL DEFAULT NULL,
  `mcode` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `is_archive` tinyint(1) NULL DEFAULT 0,
  `business_license_image_id` int NULL DEFAULT NULL,
  `shop_image_id` int NULL DEFAULT NULL,
  `ncode_image_id` int NULL DEFAULT NULL,
  `sts_verify_step_one` tinyint(1) NULL DEFAULT NULL,
  `sts_verify_step_two` tinyint(1) NULL DEFAULT NULL,
  `new_city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1417 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for customers_copy2
-- ----------------------------
DROP TABLE IF EXISTS `customers_copy2`;
CREATE TABLE `customers_copy2`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `fname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `lname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `name` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ncode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `send_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `input` double NULL DEFAULT NULL,
  `output` double NULL DEFAULT NULL,
  `remain` double NULL DEFAULT 0,
  `rial_input` bigint UNSIGNED NULL DEFAULT NULL,
  `rial_output` bigint UNSIGNED NULL DEFAULT NULL,
  `rial_remain` bigint NULL DEFAULT 0,
  `reagent_id` int UNSIGNED NULL DEFAULT NULL,
  `type` tinyint NULL DEFAULT NULL,
  `sts` tinyint NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `api_token` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `rnd` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `notify_count` int NOT NULL DEFAULT 0,
  `total_order` int NOT NULL DEFAULT 0,
  `gram_level` double NOT NULL DEFAULT 0,
  `percent` double NULL DEFAULT NULL,
  `open_order` int NOT NULL DEFAULT 0,
  `child` int NOT NULL DEFAULT 0,
  `phone` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `token_mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `grams_sell` double NULL DEFAULT 0,
  `store_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `zone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `pasazh_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `count_login` bigint NULL DEFAULT 0,
  `active` tinyint NULL DEFAULT NULL,
  `birth_date` timestamp NULL DEFAULT NULL,
  `marriage_date` timestamp NULL DEFAULT NULL,
  `city_id` int UNSIGNED NULL DEFAULT NULL,
  `image_id` int NULL DEFAULT NULL,
  `mcode` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `is_archive` tinyint(1) NULL DEFAULT 0,
  `business_license_image_id` int NULL DEFAULT NULL,
  `shop_image_id` int NULL DEFAULT NULL,
  `ncode_image_id` int NULL DEFAULT NULL,
  `sts_verify_step_one` tinyint(1) NULL DEFAULT NULL,
  `sts_verify_step_two` tinyint(1) NULL DEFAULT NULL,
  `new_city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1417 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for customers_test
-- ----------------------------
DROP TABLE IF EXISTS `customers_test`;
CREATE TABLE `customers_test`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `fname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `lname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `name` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `ncode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `send_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `input` double NULL DEFAULT NULL,
  `output` double NULL DEFAULT NULL,
  `remain` double NULL DEFAULT NULL,
  `rial_input` bigint UNSIGNED NULL DEFAULT NULL,
  `rial_output` bigint UNSIGNED NULL DEFAULT NULL,
  `rial_remain` bigint NULL DEFAULT NULL,
  `reagent_id` int UNSIGNED NULL DEFAULT NULL,
  `type` tinyint NULL DEFAULT NULL,
  `sts` tinyint NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `api_token` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `rnd` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `notify_count` int NOT NULL DEFAULT 0,
  `total_order` int NOT NULL DEFAULT 0,
  `gram_level` double NOT NULL DEFAULT 0,
  `percent` double NOT NULL,
  `open_order` int NOT NULL DEFAULT 0,
  `child` int NOT NULL DEFAULT 0,
  `phone` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `token_mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `grams_sell` double NULL DEFAULT NULL,
  `store_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `zone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `pasazh_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `count_login` bigint NULL DEFAULT NULL,
  `active` tinyint NULL DEFAULT NULL,
  `birth_date` timestamp NULL DEFAULT NULL,
  `marriage_date` timestamp NULL DEFAULT NULL,
  `city_id` int UNSIGNED NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 542 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for discount_codes
-- ----------------------------
DROP TABLE IF EXISTS `discount_codes`;
CREATE TABLE `discount_codes`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `code` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  `deleted_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for discount_discountcode
-- ----------------------------
DROP TABLE IF EXISTS `discount_discountcode`;
CREATE TABLE `discount_discountcode`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `usage_count` int NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL,
  `price_rule_id_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `discount_discountcode_price_rule_id_id_19b29aa6`(`price_rule_id_id` ASC) USING BTREE,
  CONSTRAINT `discount_discountcod_price_rule_id_id_19b29aa6_fk_discount_` FOREIGN KEY (`price_rule_id_id`) REFERENCES `discount_pricerule` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for discount_pricerule
-- ----------------------------
DROP TABLE IF EXISTS `discount_pricerule`;
CREATE TABLE `discount_pricerule`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `starts_at` timestamp NULL DEFAULT NULL,
  `ends_at` timestamp NULL DEFAULT NULL,
  `value_type` char(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `value` double NULL DEFAULT NULL,
  `allocation_method` char(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `customer_selection` char(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `shipentitled_collection_ids` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `entitled_product_ids` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `entitled_variant_ids` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `prerequisite_customer_ids` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `prerequisite_quantity_range` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `prerequisite_saved_search_ids` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `prerequisite_shipping_price_range` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `prerequisite_subtotal_range` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `prerequisite_to_entitlement_quantity_ratio` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `target_selection` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `target_type` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `once_per_customer` tinyint(1) NOT NULL,
  `allocation_limit` int NULL DEFAULT NULL,
  `usage_limit` int NULL DEFAULT NULL,
  `prerequisite_product_ids` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `prerequisite_variant_ids` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `prerequisite_collection_ids` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for failed_jobs
-- ----------------------------
DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE `failed_jobs`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `failed_jobs_uuid_unique`(`uuid` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for fav
-- ----------------------------
DROP TABLE IF EXISTS `fav`;
CREATE TABLE `fav`  (
  `customer_id` int UNSIGNED NOT NULL,
  `product_id` int UNSIGNED NOT NULL,
  PRIMARY KEY (`customer_id`, `product_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for image
-- ----------------------------
DROP TABLE IF EXISTS `image`;
CREATE TABLE `image`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` char(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `position` int NULL DEFAULT NULL,
  `image` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `resize` tinyint(1) NULL DEFAULT NULL,
  `resize_path` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `resize_watermark` tinyint(1) NULL DEFAULT NULL,
  `resize_watermark_path` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `resize_small` tinyint(1) NULL DEFAULT NULL,
  `resize_small_path` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `link` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `width` int NULL DEFAULT NULL,
  `height` int NULL DEFAULT NULL,
  `banner` tinyint(1) NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `original_name` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `ext` char(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `body` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18189 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for inventory_branches
-- ----------------------------
DROP TABLE IF EXISTS `inventory_branches`;
CREATE TABLE `inventory_branches`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `count_item` int NULL DEFAULT 0,
  `sum_weight` double NULL DEFAULT 0,
  `branch_id` int NULL DEFAULT NULL,
  `allocator_user_id` int NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for inventory_transactions
-- ----------------------------
DROP TABLE IF EXISTS `inventory_transactions`;
CREATE TABLE `inventory_transactions`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_id` int NULL DEFAULT NULL,
  `product_variant_id` int NULL DEFAULT NULL,
  `branch_id` int NULL DEFAULT NULL,
  `allocator_user_id` int NULL DEFAULT NULL,
  `order_id` int NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `type` tinyint NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 113 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for jobs
-- ----------------------------
DROP TABLE IF EXISTS `jobs`;
CREATE TABLE `jobs`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint UNSIGNED NOT NULL,
  `reserved_at` int UNSIGNED NULL DEFAULT NULL,
  `available_at` int UNSIGNED NOT NULL,
  `created_at` int UNSIGNED NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `jobs_queue_index`(`queue` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2140 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for kids
-- ----------------------------
DROP TABLE IF EXISTS `kids`;
CREATE TABLE `kids`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `num` int NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 200 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for links
-- ----------------------------
DROP TABLE IF EXISTS `links`;
CREATE TABLE `links`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `counter` int NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for login
-- ----------------------------
DROP TABLE IF EXISTS `login`;
CREATE TABLE `login`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `username` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `lname` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `fname` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `user_type` tinyint NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `last_login` timestamp NULL DEFAULT NULL,
  `is_active` tinyint NULL DEFAULT NULL,
  `api_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `token_sms` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `percent` int NULL DEFAULT 0,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `birth_day` timestamp NULL DEFAULT NULL,
  `branch_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 654 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for logs
-- ----------------------------
DROP TABLE IF EXISTS `logs`;
CREATE TABLE `logs`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `customer_id` bigint NULL DEFAULT NULL,
  `time_present` time NULL DEFAULT NULL,
  `start_at` timestamp NULL DEFAULT NULL,
  `end_at` timestamp NULL DEFAULT NULL,
  `ip` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `title` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `data` json NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title_fa` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `product_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 147682 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for major_favorites
-- ----------------------------
DROP TABLE IF EXISTS `major_favorites`;
CREATE TABLE `major_favorites`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_id` bigint NULL DEFAULT NULL,
  `customer_id` bigint NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3568 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for major_promotion
-- ----------------------------
DROP TABLE IF EXISTS `major_promotion`;
CREATE TABLE `major_promotion`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NULL DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_persian_ci NULL DEFAULT NULL,
  `start_at` timestamp NULL DEFAULT NULL,
  `end_at` timestamp NULL DEFAULT NULL,
  `type` tinyint NULL DEFAULT NULL,
  `discount_percent` double NULL DEFAULT NULL,
  `is_active` tinyint NULL DEFAULT NULL,
  `use_only` tinyint NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `show` tinyint NULL DEFAULT NULL,
  `type_customer` tinyint NULL DEFAULT NULL,
  `discount_price` double NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 923 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_persian_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for major_promotion_ignores
-- ----------------------------
DROP TABLE IF EXISTS `major_promotion_ignores`;
CREATE TABLE `major_promotion_ignores`  (
  `type` tinyint(1) NULL DEFAULT NULL,
  `item_id` int NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` time NULL DEFAULT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 55 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for major_promotion_item
-- ----------------------------
DROP TABLE IF EXISTS `major_promotion_item`;
CREATE TABLE `major_promotion_item`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `promotion_id` int NULL DEFAULT NULL,
  `item_id` int NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4451 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_persian_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for major_promotion_used
-- ----------------------------
DROP TABLE IF EXISTS `major_promotion_used`;
CREATE TABLE `major_promotion_used`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_id` int NULL DEFAULT NULL,
  `promotion_id` int NULL DEFAULT NULL,
  `promotion_item_id` int NULL DEFAULT NULL,
  `order_id` int NULL DEFAULT NULL,
  `order_item_id` int NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 388 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_persian_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for message_notification
-- ----------------------------
DROP TABLE IF EXISTS `message_notification`;
CREATE TABLE `message_notification`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` char(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `notif_type` char(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `body` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `f_id` int NULL DEFAULT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  `receiver_id` int NOT NULL,
  `sender_id` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `message_notification_receiver_id_90f1b2a9`(`receiver_id` ASC) USING BTREE,
  INDEX `message_notification_sender_id_a643dc26`(`sender_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 106 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for messages
-- ----------------------------
DROP TABLE IF EXISTS `messages`;
CREATE TABLE `messages`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_id` int NULL DEFAULT NULL,
  `mobile` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `massage` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
  `token` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `type` int NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24474 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for notify
-- ----------------------------
DROP TABLE IF EXISTS `notify`;
CREATE TABLE `notify`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `customer_id` int UNSIGNED NULL DEFAULT NULL,
  `user_id` int UNSIGNED NULL DEFAULT NULL,
  `note` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `type` tinyint NULL DEFAULT NULL,
  `value` tinyint NULL DEFAULT NULL,
  `read` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `type_send` tinyint NULL DEFAULT NULL,
  `sender_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 864 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for order_activity
-- ----------------------------
DROP TABLE IF EXISTS `order_activity`;
CREATE TABLE `order_activity`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `user_id` int UNSIGNED NULL DEFAULT NULL,
  `customer_id` int UNSIGNED NULL DEFAULT NULL,
  `order_id` int UNSIGNED NULL DEFAULT NULL,
  `meta` decimal(30, 30) NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `proceed` tinyint(1) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5439 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for order_items
-- ----------------------------
DROP TABLE IF EXISTS `order_items`;
CREATE TABLE `order_items`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'شناسه',
  `order_id` int UNSIGNED NOT NULL COMMENT 'شناسه سفارش',
  `product_id` int UNSIGNED NOT NULL COMMENT 'شناسه محصول',
  `product_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'عنوان محصول',
  `variant_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'عنوان تنوع',
  `w` double NULL DEFAULT NULL COMMENT 'وزن نهایی + درصد',
  `wage` double NULL DEFAULT NULL COMMENT 'حق الزحمه - مبالتفاوت',
  `percent` double NULL DEFAULT NULL COMMENT 'درصد با احتساب تخفیف',
  `rial_pay` double NULL DEFAULT NULL COMMENT 'اجرت ریالی',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'تاریخ ایجاد',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'تاریخ به روز رسانی',
  `variant_id` int UNSIGNED NULL DEFAULT NULL COMMENT 'شناسه تنوع',
  `price` double UNSIGNED NULL DEFAULT NULL COMMENT 'قیمت',
  `sts` tinyint NULL DEFAULT NULL COMMENT 'وضعیت',
  `qty` int UNSIGNED NULL DEFAULT NULL COMMENT 'تعداد',
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'توضیحات',
  `rash_weight` double NULL DEFAULT NULL COMMENT 'وزن خام با تغییر',
  `original_rash_weight` double NULL DEFAULT NULL COMMENT 'وزن خام بدون تغییر',
  `deleted_at` timestamp NULL DEFAULT NULL COMMENT 'تاریخ حذف',
  `discount` double NULL DEFAULT NULL COMMENT 'تخفیف روی این آیتم',
  `original_percent` double NULL DEFAULT NULL COMMENT 'درصد بدون احتساب تخفیف',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1497 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'شناسه',
  `customer_id` int UNSIGNED NOT NULL COMMENT 'شناسه مشتری',
  `reagent_id` int UNSIGNED NULL DEFAULT NULL COMMENT 'شناسه کارشناس فروش',
  `type` tinyint UNSIGNED NOT NULL,
  `input` double NULL DEFAULT NULL COMMENT 'جمع کل فاکتور یا ورودی ',
  `output` double NULL DEFAULT NULL,
  `remain` double NULL DEFAULT NULL,
  `w` double NULL DEFAULT NULL,
  `wage` double NULL DEFAULT NULL,
  `percent` double NULL DEFAULT NULL,
  `sts` tinyint NULL DEFAULT NULL COMMENT 'وضعیت سفارش',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'تاریخ ایجاد',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'تاریخ به روز رسانی',
  `deleted_at` timestamp NULL DEFAULT NULL COMMENT 'تاریخ حذف',
  `price` double UNSIGNED NULL DEFAULT NULL COMMENT 'قیمت',
  `confirmed` tinyint(1) NULL DEFAULT NULL COMMENT 'تایید شده توسط مشتری',
  `rial_input` bigint NULL DEFAULT NULL COMMENT 'جمع کل مقدار ریالی فاکتور',
  `discount` double NULL DEFAULT NULL COMMENT 'جمع کل تخفیف روی فاکتور',
  `city_id` int UNSIGNED NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 800 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for orders_fulfillment
-- ----------------------------
DROP TABLE IF EXISTS `orders_fulfillment`;
CREATE TABLE `orders_fulfillment`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `line_itmes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `notify_customer` tinyint(1) NOT NULL,
  `service` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `shipment_status` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `sts` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `tracking_number` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `tracking_url` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `order_id_id` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `orders_fulfillment_order_id_id_178151c0`(`order_id_id` ASC) USING BTREE,
  CONSTRAINT `orders_fulfillment_order_id_id_178151c0_fk_orders_orders_id` FOREIGN KEY (`order_id_id`) REFERENCES `orders_orders` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for orders_histroy
-- ----------------------------
DROP TABLE IF EXISTS `orders_histroy`;
CREATE TABLE `orders_histroy`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `order_id` int NULL DEFAULT NULL,
  `customer_id` int NULL DEFAULT NULL,
  `proceed` smallint NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `key` tinyint NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `orders_orderstshistroy_order_id_0ac368d2`(`order_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2744 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for orders_orderitem
-- ----------------------------
DROP TABLE IF EXISTS `orders_orderitem`;
CREATE TABLE `orders_orderitem`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `price` double NULL DEFAULT NULL,
  `approximate_price` double NULL DEFAULT NULL,
  `qty` int NOT NULL,
  `deposit` double NULL DEFAULT NULL,
  `amount_paid` double NULL DEFAULT NULL,
  `approximate_gram` double NULL DEFAULT NULL,
  `exact_gram` double NULL DEFAULT NULL,
  `debtor_amount` double NULL DEFAULT NULL,
  `is_active` tinyint(1) NULL DEFAULT NULL,
  `supply_at` date NULL DEFAULT NULL,
  `delivery_at` date NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `order_id` int NOT NULL,
  `product_id` int NOT NULL,
  `variant_id` int NOT NULL,
  `grams` double NULL DEFAULT NULL,
  `rial_pay` double NULL DEFAULT NULL,
  `variant_title` char(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `is_preorder` tinyint(1) NULL DEFAULT NULL,
  `promotion_id` int NULL DEFAULT NULL,
  `promotion_item_id` int NULL DEFAULT NULL,
  `total_discount` int NULL DEFAULT 0,
  `total_price` double NULL DEFAULT NULL,
  `gold_price_in_formula` double NULL DEFAULT NULL,
  `branch_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `orders_orderitem_order_id_id_f49815c5`(`order_id` ASC) USING BTREE,
  INDEX `orders_orderitem_product_id_id_05820f89`(`product_id` ASC) USING BTREE,
  INDEX `orders_orderitem_variant_id_id_710a853c`(`variant_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1029 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for orders_orders
-- ----------------------------
DROP TABLE IF EXISTS `orders_orders`;
CREATE TABLE `orders_orders`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `app` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `billing_address` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `browser_ip` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `buyer_accepts_marketing` tinyint(1) NULL DEFAULT NULL,
  `email` char(254) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `phone` char(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `prcessing_method` char(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `processed_at` timestamp NULL DEFAULT NULL,
  `shipping_address` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `shipping_line` int NULL DEFAULT NULL,
  `subtotal_price` double NULL DEFAULT NULL,
  `discount_codes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `total_discount` double NULL DEFAULT NULL,
  `total_price` double NULL DEFAULT NULL,
  `total_tax` double NULL DEFAULT NULL,
  `total_weight` double NULL DEFAULT NULL,
  `tags` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `sts` int NULL DEFAULT NULL,
  `is_active` tinyint(1) NULL DEFAULT NULL,
  `canceled_at` date NULL DEFAULT NULL,
  `canceled_reason` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `closed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `send_time_id` int NULL DEFAULT NULL,
  `user_id_id` int NULL DEFAULT NULL,
  `gold_price` bigint NULL DEFAULT NULL,
  `gold_price_original` bigint NULL DEFAULT NULL,
  `price` double NULL DEFAULT NULL,
  `reagent_id` int NULL DEFAULT NULL,
  `type` tinyint NULL DEFAULT NULL,
  `use_wallet` tinyint(1) NULL DEFAULT 0,
  `payment_after_wallet` int NULL DEFAULT NULL,
  `branch_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `orders_orders_send_time_id_ae5105a6`(`send_time_id` ASC) USING BTREE,
  INDEX `orders_orders_user_id_id_573dbdec`(`user_id_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 651 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for orders_sendtime
-- ----------------------------
DROP TABLE IF EXISTS `orders_sendtime`;
CREATE TABLE `orders_sendtime`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `started_at` timestamp NOT NULL,
  `ended_at` timestamp NOT NULL,
  `perimitted_number` int NOT NULL,
  `sent_number` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for permission
-- ----------------------------
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission`  (
  `rid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ut` int NOT NULL,
  PRIMARY KEY (`rid`, `ut`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for product
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `body_html` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `product_code` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `metafields_global_title_tag` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `metafields_global_description_tag` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `tags` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `meta` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `sts` int NULL DEFAULT NULL,
  `number_of_purchase` int NOT NULL,
  `published_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL,
  `brand_id` int NULL DEFAULT NULL,
  `indicator_id_id` int NULL DEFAULT NULL,
  `supplier_id` int NULL DEFAULT NULL,
  `mobile_pic_id` int NULL DEFAULT NULL,
  `show_type` smallint NULL DEFAULT NULL,
  `delivery_type` tinyint(1) NULL DEFAULT NULL,
  `message_long_delivery` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `file_id` int UNSIGNED NULL DEFAULT NULL,
  `desk_note` longtext CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `disabled` tinyint(1) NOT NULL DEFAULT 0,
  `count_fav` int NULL DEFAULT 0,
  `count_order` int NULL DEFAULT 0,
  `count_view` int NULL DEFAULT 0,
  `min_gram` double NULL DEFAULT NULL,
  `max_gram` double NULL DEFAULT NULL,
  `offer_day` tinyint(1) NULL DEFAULT 0,
  `branch_id` int NULL DEFAULT NULL,
  `inventory_id` int NULL DEFAULT NULL,
  `is_exist` tinyint(1) NULL DEFAULT NULL,
  `has_warranty` tinyint(1) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `products_product_brand_id_3e2e8fd1`(`brand_id` ASC) USING BTREE,
  INDEX `products_product_indicator_id_id_72772582`(`indicator_id_id` ASC) USING BTREE,
  INDEX `products_product_moblie_pic_id_40a187c0`(`mobile_pic_id` ASC) USING BTREE,
  INDEX `products_product_supplier_id_b9ff64a9`(`supplier_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3384 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for product_brand
-- ----------------------------
DROP TABLE IF EXISTS `product_brand`;
CREATE TABLE `product_brand`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `priority` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 90 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for product_tags
-- ----------------------------
DROP TABLE IF EXISTS `product_tags`;
CREATE TABLE `product_tags`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_id` int UNSIGNED NOT NULL,
  `const_id` int UNSIGNED NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 447 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for products_comment
-- ----------------------------
DROP TABLE IF EXISTS `products_comment`;
CREATE TABLE `products_comment`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `text` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `sts` int NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  `product_id_id` int NOT NULL,
  `reply_id_id` int NULL DEFAULT NULL,
  `user_id_id` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `products_comment_product_id_id_3a4bf5bf`(`product_id_id` ASC) USING BTREE,
  INDEX `products_comment_reply_id_id_9be615e0`(`reply_id_id` ASC) USING BTREE,
  INDEX `products_comment_user_id_id_f4522726`(`user_id_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for products_productimage
-- ----------------------------
DROP TABLE IF EXISTS `products_productimage`;
CREATE TABLE `products_productimage`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `image_id` int NULL DEFAULT NULL,
  `product_id` int NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `w` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `body` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `products_productimage_image_id_8002c73c`(`image_id` ASC) USING BTREE,
  INDEX `products_productimage_product_id_e747596a`(`product_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 30003 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for products_productvarient
-- ----------------------------
DROP TABLE IF EXISTS `products_productvarient`;
CREATE TABLE `products_productvarient`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `barcode` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `color` smallint NULL DEFAULT NULL,
  `grams` double NULL DEFAULT NULL,
  `width` double NULL DEFAULT NULL,
  `length` double NULL DEFAULT NULL,
  `height` double NULL DEFAULT NULL,
  `rial_pay` double NULL DEFAULT NULL,
  `percentage_pay` double NULL DEFAULT NULL,
  `Inventory` int NULL DEFAULT NULL,
  `details` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `meta` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `position` double NULL DEFAULT NULL,
  `requires_shipping` tinyint(1) NULL DEFAULT NULL,
  `taxable` tinyint(1) NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `is_pre_order` tinyint(1) NULL DEFAULT NULL,
  `is_active` tinyint(1) NULL DEFAULT NULL,
  `product_id_id` int NULL DEFAULT NULL,
  `qty` int NULL DEFAULT NULL,
  `number_of_purchase` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `products_productvarient_product_id_id_82e0a53c`(`product_id_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7474 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for products_productvarient_copy1
-- ----------------------------
DROP TABLE IF EXISTS `products_productvarient_copy1`;
CREATE TABLE `products_productvarient_copy1`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `barcode` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `color` smallint NULL DEFAULT NULL,
  `grams` double NULL DEFAULT NULL,
  `width` double NULL DEFAULT NULL,
  `length` double NULL DEFAULT NULL,
  `height` double NULL DEFAULT NULL,
  `rial_pay` double NULL DEFAULT NULL,
  `percentage_pay` double NULL DEFAULT NULL,
  `Inventory` int NULL DEFAULT NULL,
  `details` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `meta` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `position` double NULL DEFAULT NULL,
  `requires_shipping` tinyint(1) NULL DEFAULT NULL,
  `taxable` tinyint(1) NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `is_pre_order` tinyint(1) NULL DEFAULT NULL,
  `is_active` tinyint(1) NULL DEFAULT NULL,
  `product_id_id` int NULL DEFAULT NULL,
  `qty` int NULL DEFAULT NULL,
  `number_of_purchase` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `products_productvarient_product_id_id_82e0a53c`(`product_id_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4055 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for products_promotion
-- ----------------------------
DROP TABLE IF EXISTS `products_promotion`;
CREATE TABLE `products_promotion`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` char(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `promotion_type` int NOT NULL,
  `sts` char(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `platform` char(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `started_at` timestamp NOT NULL,
  `ended_at` timestamp NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for products_variantpromotion
-- ----------------------------
DROP TABLE IF EXISTS `products_variantpromotion`;
CREATE TABLE `products_variantpromotion`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `discount_percentage` double NOT NULL,
  `per_promotion` int NOT NULL,
  `per_buy` int NOT NULL,
  `number_of_sold` int NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `product_id_id` int NOT NULL,
  `promotion_id_id` int NOT NULL,
  `variant_id_id` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `products_variantpromotion_product_id_id_650e8492`(`product_id_id` ASC) USING BTREE,
  INDEX `products_variantpromotion_promotion_id_id_48594f0e`(`promotion_id_id` ASC) USING BTREE,
  INDEX `products_variantpromotion_variant_id_id_227fc462`(`variant_id_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for promotion_products
-- ----------------------------
DROP TABLE IF EXISTS `promotion_products`;
CREATE TABLE `promotion_products`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `promotion_id` int NULL DEFAULT NULL,
  `promotion_item_id` int NULL DEFAULT NULL,
  `product_variant_id` int NULL DEFAULT NULL,
  `product_id` int NULL DEFAULT NULL,
  `discount` double(10, 4) NULL DEFAULT NULL,
  `type` tinyint NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `active` tinyint(1) NULL DEFAULT NULL,
  `start_at` timestamp NULL DEFAULT NULL,
  `end_at` timestamp NULL DEFAULT NULL,
  `use_only` tinyint(1) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22899 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for request_fashions
-- ----------------------------
DROP TABLE IF EXISTS `request_fashions`;
CREATE TABLE `request_fashions`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `mobile` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 101 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for request_logs
-- ----------------------------
DROP TABLE IF EXISTS `request_logs`;
CREATE TABLE `request_logs`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `ip` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `data` json NULL,
  `customer_id` bigint NULL DEFAULT NULL,
  `device` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `user_agent` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `route` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `method` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14305 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for single_promotion_used
-- ----------------------------
DROP TABLE IF EXISTS `single_promotion_used`;
CREATE TABLE `single_promotion_used`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_id` int NULL DEFAULT NULL,
  `promotion_id` int NULL DEFAULT NULL,
  `promotion_item_id` int NULL DEFAULT NULL,
  `order_id` int NULL DEFAULT NULL,
  `order_item_id` int NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `promotion_product_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_persian_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for transaction_metas
-- ----------------------------
DROP TABLE IF EXISTS `transaction_metas`;
CREATE TABLE `transaction_metas`  (
  `transaction` bigint UNSIGNED NOT NULL,
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `order_id` bigint NULL DEFAULT NULL,
  `total_weight` double NULL DEFAULT NULL,
  `percent` int NULL DEFAULT NULL,
  `order_date` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 255 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for transaction_orders
-- ----------------------------
DROP TABLE IF EXISTS `transaction_orders`;
CREATE TABLE `transaction_orders`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `customer_id` bigint UNSIGNED NULL DEFAULT NULL,
  `order_id` bigint UNSIGNED NULL DEFAULT NULL,
  `total_price` bigint NULL DEFAULT NULL,
  `transaction_type` tinyint(1) NULL DEFAULT NULL,
  `total_weight` double UNSIGNED NULL DEFAULT NULL,
  `order_date` datetime NULL DEFAULT NULL,
  `payment` tinyint(1) NULL DEFAULT 0,
  `created_at` datetime NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 249 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for transactions
-- ----------------------------
DROP TABLE IF EXISTS `transactions`;
CREATE TABLE `transactions`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `wallet` bigint UNSIGNED NOT NULL,
  `transaction_type` enum('1','2','3') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `value` double NOT NULL,
  `expire_at` datetime NULL DEFAULT NULL,
  `hash` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `customer_id` int NULL DEFAULT NULL,
  `active` tinyint NULL DEFAULT 0,
  `order_id` bigint NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 255 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for transactions_cheque
-- ----------------------------
DROP TABLE IF EXISTS `transactions_cheque`;
CREATE TABLE `transactions_cheque`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `price` double NULL DEFAULT NULL,
  `critique_at` date NOT NULL,
  `passed` tinyint(1) NOT NULL,
  `bank` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `branch` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `code` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `order_id_id` int NULL DEFAULT NULL,
  `user_id_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `transactions_cheque_order_id_id_e673514b`(`order_id_id` ASC) USING BTREE,
  INDEX `transactions_cheque_user_id_id_d5c86d51`(`user_id_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for transactions_deposittocard
-- ----------------------------
DROP TABLE IF EXISTS `transactions_deposittocard`;
CREATE TABLE `transactions_deposittocard`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `price` double NOT NULL,
  `trackint_number` char(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `order_id_id` int NOT NULL,
  `receipt_id` int NOT NULL,
  `user_id_id` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `transactions_deposittocard_order_id_id_f3eb423f`(`order_id_id` ASC) USING BTREE,
  INDEX `transactions_deposittocard_receipt_id_63f5bff0`(`receipt_id` ASC) USING BTREE,
  INDEX `transactions_deposittocard_user_id_id_2169d0c1`(`user_id_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for transactions_financialreport
-- ----------------------------
DROP TABLE IF EXISTS `transactions_financialreport`;
CREATE TABLE `transactions_financialreport`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` char(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `sts` char(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `reason` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `transactions_financialreport_user_id_9022cc28`(`user_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 106 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for transactions_meltedgold
-- ----------------------------
DROP TABLE IF EXISTS `transactions_meltedgold`;
CREATE TABLE `transactions_meltedgold`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `gram` double NOT NULL,
  `ang` char(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `laboratory` char(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `ayar` char(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `order_id_id` int NOT NULL,
  `user_id_id` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `transactions_meltedgold_order_id_id_75bca815`(`order_id_id` ASC) USING BTREE,
  INDEX `transactions_meltedgold_user_id_id_c633d05e`(`user_id_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for transactions_refund
-- ----------------------------
DROP TABLE IF EXISTS `transactions_refund`;
CREATE TABLE `transactions_refund`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `sts` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `order_adjusments` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `processed_at` timestamp NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `transaction_id_id` int NULL DEFAULT NULL,
  `user_id_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `transactions_refund_transaction_id_id_key`(`transaction_id_id` ASC) USING BTREE,
  INDEX `transactions_refund_user_id_id_1057a1db`(`user_id_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for transactions_transaction
-- ----------------------------
DROP TABLE IF EXISTS `transactions_transaction`;
CREATE TABLE `transactions_transaction`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `amount` double NULL DEFAULT NULL,
  `transaction_type` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `sts` char(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
  `message` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `receipt` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `gateway` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL,
  `is_active` tinyint(1) NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `order_id_id` int NULL DEFAULT NULL,
  `user_id_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `transactions_transaction_order_id_id_2feae4e4`(`order_id_id` ASC) USING BTREE,
  INDEX `transactions_transaction_user_id_id_fb5a704c`(`user_id_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 122 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `fname` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `lname` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `mobile` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `password` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `api_token` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `remember_token` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `permission` decimal(16, 16) NULL DEFAULT NULL,
  `ut` int UNSIGNED NULL DEFAULT NULL,
  `city_id` int UNSIGNED NULL DEFAULT NULL,
  `token_mobile` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `notify_count` int NULL DEFAULT 0,
  `branch_id` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `users_mobile_unique`(`mobile` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for wallets
-- ----------------------------
DROP TABLE IF EXISTS `wallets`;
CREATE TABLE `wallets`  (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `owner_type` enum('1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `owner` bigint NOT NULL,
  `gold` double NOT NULL,
  `hash` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `credit` bigint NOT NULL,
  `sms_at` timestamp NULL DEFAULT NULL,
  `sent` tinyint(1) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `wallets_owner_owner_type_unique`(`owner` ASC, `owner_type` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 81 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for workshops
-- ----------------------------
DROP TABLE IF EXISTS `workshops`;
CREATE TABLE `workshops`  (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NULL DEFAULT NULL,
  `user_id` int NULL DEFAULT NULL,
  `is_active` tinyint(1) NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_unicode_ci ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;