huimv_tuzai_erp/sql/rel_customer_market.sql

-- 客户市场维护建表脚本（仅表结构）

CREATE TABLE IF NOT EXISTS `rel_customer_market` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `org_id` varchar(64) DEFAULT NULL COMMENT '组织ID',
  `line_num` varchar(64) NOT NULL COMMENT '物流线编号',
  `market_num` varchar(64) NOT NULL COMMENT '市场编号',
  `customer_num` varchar(64) NOT NULL COMMENT '客户编号',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_line_num` (`line_num`),
  KEY `idx_market_num` (`market_num`),
  KEY `idx_customer_num` (`customer_num`),
  KEY `idx_org_del_id` (`org_id`, `del_flag`, `id`),
  KEY `idx_org_del_line_id` (`org_id`, `del_flag`, `line_num`, `id`),
  KEY `idx_org_del_market_id` (`org_id`, `del_flag`, `market_num`, `id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='客户市场维护';