okayapi_72crm_crm_product

-- MySQL Table okayapi_72crm_crm_product
-- From: OkayAPI.com
CREATE TABLE `okayapi_72crm_crm_product` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `product_id` int(11) NOT NULL COMMENT '',
    `okayapi_72crm_crm_product_name` varchar(255) NOT NULL COMMENT '产品名称',
    `num` varchar(255) NOT NULL COMMENT '产品编码',
    `unit` varchar(255) NOT NULL COMMENT '单位',
    `price` decimal(18,2) NOT NULL COMMENT '价格',
    `okayapi_72crm_crm_product_status` int(1) NOT NULL DEFAULT '0' COMMENT '状态 1 上架 0 下架 3 删除',
    `category_id` int(11) NOT NULL COMMENT '产品分类ID',
    `description` text NOT NULL COMMENT '产品描述',
    `create_user_id` bigint(20) NOT NULL COMMENT '创建人ID',
    `owner_user_id` bigint(20) NOT NULL COMMENT '负责人ID',
    `create_time` datetime NOT NULL COMMENT '创建时间',
    `batch_id` varchar(32) NOT NULL COMMENT '批次',
    KEY `product_id` (`product_id`),
    KEY `okayapi_72crm_crm_product_name` (`okayapi_72crm_crm_product_name`),
    KEY `num` (`num`),
    KEY `unit` (`unit`),
    KEY `price` (`price`),
    KEY `okayapi_72crm_crm_product_status` (`okayapi_72crm_crm_product_status`),
    KEY `category_id` (`category_id`),
    KEY `description` (`description`),
    KEY `create_user_id` (`create_user_id`),
    KEY `owner_user_id` (`owner_user_id`),
    KEY `create_time` (`create_time`),
    KEY `batch_id` (`batch_id`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CRM-产品表';

After replication, you can go to the database to create the database table.