子表脚本

DROP TABLE IF EXISTS market_subTable;
CREATE TABLE market_subTable (
  #id varchar(32) COLLATE utf8_unicode_ci NOT NULL COMMENT '主键ID',
  tenantid varchar(36) DEFAULT NULL,
  company_id varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
  dr int(2) DEFAULT NULL COMMENT '是否删除',
  ts timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  #mainTable_id varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '外键',
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='market_subTable';