shanxia2.0/docs/sql/20261023_mobile_plan_stop_product_meta.sql

-- Prepared migration only. Apply before enabling PL_MOBILE_PLAN_PRODUCT_META_ENABLED.
-- No alteration of existing tables; disabling the flag restores the original Web path.
CREATE TABLE IF NOT EXISTS pl_plan_stop_product_meta (
  id VARCHAR(64) NOT NULL,
  plan_id VARCHAR(64) NOT NULL DEFAULT '',
  stop_type VARCHAR(16) NOT NULL DEFAULT '',
  stop_id VARCHAR(64) NOT NULL DEFAULT '',
  stop_product_id VARCHAR(64) NOT NULL DEFAULT '',
  contract_id VARCHAR(64) NOT NULL DEFAULT '',
  contract_product_id VARCHAR(64) NOT NULL DEFAULT '',
  product_id VARCHAR(64) NOT NULL DEFAULT '',
  package_spec VARCHAR(200) NOT NULL DEFAULT '',
  model VARCHAR(100) NOT NULL DEFAULT '',
  unit VARCHAR(20) NOT NULL DEFAULT '',
  product_name VARCHAR(200) NOT NULL DEFAULT '',
  alias_name VARCHAR(200) DEFAULT NULL COMMENT 'NULL按已存名称识别，空串为明确清空',
  brand_mode VARCHAR(20) NOT NULL DEFAULT '',
  brand_id VARCHAR(64) NOT NULL DEFAULT '',
  brand_name VARCHAR(200) NOT NULL DEFAULT '',
  source_product_name VARCHAR(200) NOT NULL DEFAULT '',
  source_brand_mode VARCHAR(20) NOT NULL DEFAULT '',
  source_brand_id VARCHAR(64) NOT NULL DEFAULT '',
  source_brand_name VARCHAR(200) NOT NULL DEFAULT '',
  tenant_no VARCHAR(64) NOT NULL,
  order_num INT DEFAULT NULL,
  remark VARCHAR(512) DEFAULT NULL,
  create_by VARCHAR(64) DEFAULT NULL,
  create_dept_id VARCHAR(64) NOT NULL DEFAULT '',
  create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  update_by VARCHAR(64) DEFAULT NULL,
  update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  del_flag SMALLINT NOT NULL DEFAULT 0,
  PRIMARY KEY (id),
  KEY ix_pl_stop_meta_scope (tenant_no, plan_id, del_flag),
  KEY ix_pl_stop_meta_row (tenant_no, stop_type, stop_product_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;