crm/database/migrations/20230509034857_create_fish_data_table.php

<?php

use think\facade\Db;
use think\migration\Migrator;
use think\migration\db\Column;

class CreateFishDataTable extends Migrator
{
    /**
     * Change Method.
     *
     * Write your reversible migrations using this method.
     *
     * More information on writing migrations is available here:
     * http://docs.phinx.org/en/latest/migrations.html#the-abstractmigration-class
     *
     * The following commands can be used in this method and Phinx will
     * automatically reverse them when rolling back:
     *
     *    createTable
     *    renameTable
     *    addColumn
     *    renameColumn
     *    addIndex
     *    addForeignKey
     *
     * Remember to call "create()" or "update()" and NOT "save()" when working
     * with the Table class.
     */
    public function change()
    {
        Db::execute("CREATE TABLE `fl_fish_data`  (
            `id` int(11) NOT NULL AUTO_INCREMENT,
            `clue_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '线索ID',
            `advertiser_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '广告主ID',
            `advertiser_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '广告主名',
            `ad_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '计划ID',
            `ad_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '计划名',
            `creative_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '广告创意id',
            `promotion_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '升级版广告名称',
            `promotion_id` int(11) NULL DEFAULT NULL COMMENT '升级版广告ID',
            `mid_info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '升级版素材组',
            `site_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '站点ID',
            `site_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '站点名称',
            `intention_estimation` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '线索意向',
            `external_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '落地页 url',
            `clue_type` int(5) NOT NULL COMMENT '组件类型',
            `module_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组件名字',
            `module_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组件ID',
            `create_time` date NULL DEFAULT NULL COMMENT '线索创建时间',
            `create_time_detail` timestamp NULL DEFAULT NULL COMMENT '线索创建时间',
            `date` date NULL DEFAULT NULL COMMENT '日期',
            `clue_source` int(5) NULL DEFAULT NULL COMMENT '线索来源',
            `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
            `telephone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
            `gender` int(1) NULL DEFAULT NULL COMMENT '线索来源',
            `age` int(5) NOT NULL COMMENT '年龄',
            `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
            `weixin` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信',
            `qq` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'QQ',
            `province_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '省份',
            `city_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '城市',
            `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '详细地址',
            `location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户地址信息',
            `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户备注留言',
            `remark_dict` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '广告主自定义的其它字段信息',
            `form_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '广告主表单自定义字段',
            `app_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流量来源',
            `convert_status` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '转化状态',
            `req_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '当前线索对应广告的请求id',
            `clue_state` int(5) NULL DEFAULT NULL COMMENT '线索来源',
            `clue_state_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '线索状态名称',
            `clue_owner_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属人姓名',
            `follow_state_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '线索通话状态名称',
            `country_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所在城市中的【区】字段',
            `system_tags` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '线索被打上的系统标签',
            `tags` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '线索被打上的人工标签',
            `allocation_status` int(5) NULL DEFAULT NULL COMMENT '分配状态值',
            `store` json NULL COMMENT '门店信息',
            `extra_info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自定义',
            `root_id` int(11) NULL DEFAULT NULL COMMENT '关联组织',
            `org_id` int(11) NULL DEFAULT NULL COMMENT '部门',
            `employee_id` int(11) NULL DEFAULT NULL COMMENT '员工id',
            `is_allocation` tinyint(1) NULL DEFAULT 0 COMMENT '是否被分配',
            `type` tinyint(1) NULL DEFAULT 1 COMMENT '1飞鱼2腾讯3欧派',
            `customer_id` int(11) NULL DEFAULT 0 COMMENT '客户id',
            `is_contact` tinyint(1) NULL DEFAULT 0 COMMENT '是否联系',
            `update_time_detail` timestamp NULL DEFAULT NULL COMMENT '更新时间',
            `employee_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销售标记',
            PRIMARY KEY (`id`) USING BTREE,
            INDEX `advertiser_id`(`advertiser_id`) USING BTREE,
            INDEX `root_id`(`root_id`) USING BTREE,
            INDEX `employee_id`(`employee_id`) USING BTREE,
            INDEX `customer_id`(`customer_id`) USING BTREE
          ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '飞鱼线索' ROW_FORMAT = Dynamic;");
    }
}