主数据-品牌设计文档
1、背景介绍
原先FMS和SCM各自维护自己的品牌主数据，FMS使用定时任务定时同步SCM品牌数据信息保存到FMS的镜像表中，新SCM系统则不需要再维护品牌，统一由FMS主数据-品牌进行管理。
2、数据获取方式
品牌在FMS创建和更新同时调用RPC实时同步至SCM中
- 主要涉及相关表：
FMS：basic_brand、basic_scm_brand_archives（不再使用）
新SCM：basic_brand
3、历史数据
由于FMS这边维护所以原先从SCM同步的镜像表basic_scm_brand_archives则不再使用，主要涉及到大货打印申请主表、大货打印申请明细表、打印申请主表、打印申请子表历史数据
- 解决方案
在FMS的basic_brand增加字段scm_id替换原有的basic_scm_brand_archives主键ID，则涉及的历史数据信息存储的主键ID不需要更改，由原来根据主键查询basic_scm_brand_archives表迁移到查询basic_brand表中的scm_id获取品牌信息- 对应关系
主要需要修改数据basic_brand中新增SCM_ID,根据其中原来存储的字段scm_brand_id找到basic_scm_brand_archives表中字段unique_key相对应的主键ID填充至basic_brand中的SCM_ID
4、表结构设计
- FMS的basic_brand表中新增三个字段
| 字段名 | 数据类型 | 是否非空 | 默认值 | 备注 |
|---|---|---|---|---|
| scm_id | bigint | 是 | NULL | SCM主键ID |
| drop_type | varchar(32) | 是 | NULL | 吊牌类别(A或B) |
| date_allowed | varchar(255) | 是 | NULL | 允许下单日期(允许下单日期 1:周一2:周二3:周三4:周四5:周五6:周六0:周日) |
- 新SCM新增表basic_brand
| 字段名 | 数据类型 | 是否非空 | 默认值 | 备注 |
|---|---|---|---|---|
| id | int | 是 | NULL | 主键 |
| brand_name | varchar(64) | 是 | NULL | 品牌名称 |
| brand_code | varchar(64) | 是 | NULL | 品牌编码 |
| tag_type | varchar(64) | 是 | NULL | 吊牌类别（A或B） |
| tag_display_name | varchar(64) | 是 | NULL | 吊牌显示名称 |
| gender | tinyint | 是 | NULL | 性别 0女装 1男装 2女童 3男童 4童装 5男女装 |
| date_allowed | varchar(64) | 是 | NULL | 允许下单日期(允许下单日期 1:周一2:周二3:周三4:周四5:周五6:周六0:周日) |
| warehouse | varchar(64) | 是 | NULL | 成品仓库 |
| cost_ratio | decimal | 是 | NULL | 成本倍率 |
| retail_price_mantissa | decimal | 是 | NULL | 零售价尾数 |
| company_id | bigint | 是 | NULL | 公司ID |
| company_name | varchar(255) | 是 | NULL | 公司名称 |
| company_address | varchar(255) | 是 | NULL | 公司地址 |
| company_phone | varchar(32) | 是 | NULL | 公司电话 |
| hast_trial_production_fee | tinyint | 是 | NULL | 是否含试制费 1 有 0 无 |
| enable | smallint | 是 | 1 | 启用 1 禁用 0 |
| deleted | smallint | 是 | 0 | 删除 1 未删除 0 |
| remark | varchar(255) | 否 | NULL | 备注 |
| created | timestamp | 是 | NULL | 创建时间 |
| create_user | varchar(45) | 是 | NULL | 创建人 |
| last_updated | timestamp | 否 | NULL | 更新时间(维护时间) |
| last_update_user | varchar(45) | 否 | NULL | 更新人(维护人) |
| last_update_user_id | int(64) | 否 | NULL | 更新人ID(维护人ID) |
4、初始化数据
测试环境
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (25, 'KOJO', 'K', 'A', 'KOJO', 1, '3,5,4,1,2,6,0', '萧山宇隆仓', 10.0000, 8.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', '0571-82166391', 1, 1, 0, NULL, '2019-09-17 11:30:29.963000', '管理员', NULL, '2023-04-12 00:41:40.219183', NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (26, '奢步士', 'H', 'A', 'SOUREPOSE 奢步士', 1, '3,5,1,4,2,6,0', '萧山宇隆仓', 10.0000, 8.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', '0571-82166391', 1, 1, 0, NULL, '2019-09-17 11:32:27.495000', '管理员', NULL, '2023-04-12 00:41:42.646528', NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (27, '对白', 'D', 'A', 'DUIBAI 对白', 0, '1,5,4,2,3,6,0', '萧山宇隆仓', 10.0000, 9.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', '0571-82166391', 1, 1, 0, NULL, '2019-09-17 11:33:36.494000', '管理员', NULL, '2023-04-12 00:41:44.639389', NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (28, '盛放', 'S', 'A', 'SEENFAAN 盛放', 0, '2,3,4,5,6,0,1', '萧山宇隆仓', 10.0000, 9.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', '0571-82166391', 1, 1, 0, NULL, '2019-09-17 11:34:59.705000', '管理员', NULL, '2023-04-12 00:41:46.583186', NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (29, 'EPTISON 男童', 'B', 'A', 'EPTISON 衣品天成', 3, '2,3,4,0,6,1,5', '萧山瓜沥仓', 10.0000, 8.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', '0571-82166391', 1, 1, 0, NULL, '2019-09-17 11:37:45.786000', '管理员', NULL, '2023-04-12 00:41:48.558953', '朱阿鹏', NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (30, 'EPTISON 女童', 'G', 'A', 'EPTISON 衣品天成', 2, '2,3,4,0,5,1,6', '萧山瓜沥仓', 10.0000, 9.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', '0571-82166391', 1, 1, 0, NULL, '2019-09-17 11:39:26.686000', '管理员', NULL, '2023-04-12 00:41:50.472292', NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (31, '米莱达', 'L', 'A', 'MEETLADY 米莱达', 0, '3,5,4,0,6,1,2', '萧山宇隆仓', 10.0000, 9.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', '0571-82166391', 1, 1, 0, NULL, '2019-09-17 11:43:14.524000', '管理员', NULL, '2023-04-12 00:41:52.346622', NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (32, 'N-MAX', 'N', 'A', ' N-MAX', 1, '2,5,4,0,1,3,6', '萧山宇隆仓', 10.0000, 8.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', '0571-82166391 ', 1, 1, 0, NULL, '2019-09-17 11:45:47.448000', '管理员', NULL, '2023-04-12 00:41:54.065526', NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (33, '衣品天成男装', 'M', 'A', 'EPTISON 衣品天成', 1, '5,3,4,1,6,0,2', '萧山瓜沥仓', 10.0000, 8.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', '0571-82166391', 1, 1, 0, NULL, '2019-09-17 11:48:35.841000', '管理员', NULL, '2023-04-12 00:41:56.084367', NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (34, '衣品天成女装', 'W', 'A', 'EPTISON 衣品天成', 0, '5,2,4,1,6,3,0', '萧山瓜沥仓', 10.0000, 9.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', '0571-82166391', 1, 1, 0, NULL, '2019-09-17 11:50:03.065000', '管理员', NULL, '2023-04-12 00:41:59.030981', NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (35, 'LEKE男装', 'Y', 'A', 'LEKE', 1, '1,5,3,2,4,6,0', '萧山瓜沥仓', 10.0000, 8.0000, 34, '宿迁维卓电子商务有限公司', '宿迁市宿豫区洪泽湖东路19号通元大厦B座', NULL, 0, 1, 0, NULL, '2019-09-17 11:51:04.045000', '管理员', NULL, '2023-04-12 00:42:02.344606', '管理员', NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (36, 'LEKE女装', 'X', 'A', 'LEKE', 0, '1,5,4,3,2,6,0', '萧山瓜沥仓', 10.0000, 8.0000, 34, '宿迁维卓电子商务有限公司', '宿迁市宿豫区洪泽湖东路19号通元大厦B座', NULL, 0, 1, 0, NULL, '2019-09-17 11:51:55.775000', '管理员', NULL, '2023-04-12 00:42:05.031482', '朱阿鹏', NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (37, 'LA Crawfish', 'C', 'A', 'LA Crawfish', 0, '1,2,3,4,5,6,0', '萧山瓜沥仓', 13.0000, 9.0000, 35, '湖州全尚科技有限公司', '浙江省湖州市长兴县吕山乡吕山村', '0572-6321863', 0, 1, 0, NULL, '2019-09-17 11:53:04.327000', '管理员', NULL, '2023-04-12 00:42:08.180052', '05051', NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (38, 'I\'M ONE', 'T', 'A', 'I\'M ONE', 0, '5,3,1,4,0,2,6', '萧山瓜沥仓', 10.0000, 9.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', '0571-82166391', 1, 1, 0, NULL, '2019-09-17 11:54:13.376000', '管理员', NULL, '2023-04-12 00:42:10.650383', '05134', NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (39, '奢步士女装', 'E', 'A', 'SOUREPOSE 奢步士', 0, '3,1,6,0,2,4,5', '萧山宇隆仓', 10.0000, 9.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', NULL, 1, 1, 0, NULL, '2019-09-17 11:56:10.620000', '管理员', NULL, '2023-04-12 00:42:12.464186', NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (40, 'LACHATA', 'F', 'A', 'LACHATA', 0, '1,3,2,4,5,6,0', '萧山宇隆仓', 10.0000, 9.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', NULL, 1, 1, 0, NULL, '2019-09-17 11:56:46.110000', '管理员', NULL, '2023-04-12 00:42:14.498039', NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (41, 'FSK', 'Z', 'A', 'FSK', 1, '1,2,3,4,5,0,6', '萧山瓜沥仓', 10.0000, 8.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', '0571-82166391', 1, 1, 0, NULL, '2019-09-17 11:59:51.856000', '管理员', NULL, '2023-04-12 00:42:17.604755', NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (42, 'Lierkiss', 'Q', 'A', 'Lierkiss', 1, '1,2,3,4,5,6', '萧山瓜沥仓', 10.0000, 9.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', NULL, 1, 1, 0, NULL, '2019-09-17 12:00:42.343000', '管理员', NULL, '2023-04-12 00:42:19.628522', NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (48, 'EPTISON童装', 'R', 'A', 'EPTISON童装', 4, '', '萧山瓜沥仓', 10.0000, 9.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', '0571-82166391', 1, 1, 0, NULL, '2019-09-23 10:42:26.922000', '05051', NULL, '2023-04-12 00:42:22.259269', NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (49, 'LEKE男女装', 'XY', 'A', 'LEKE男女装', 5, '', '萧山瓜沥仓', 10.0000, 9.0000, 34, '宿迁维卓电子商务有限公司', '宿迁市宿豫区洪泽湖东路19号通元大厦B座', NULL, 1, 1, 0, NULL, '2019-09-23 14:20:02.160000', '05051', NULL, '2023-04-12 00:42:24.591562', NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (50, '衣品天成男女装', 'WM', 'A', '衣品天成男女装', 5, '', '萧山瓜沥仓', 10.0000, 8.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', '0571-82166391', 1, 1, 0, NULL, '2019-09-23 14:30:40.620000', '05051', NULL, '2023-04-12 00:42:26.706892', NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (51, '全尚优选', 'QS', 'A', '全尚', 5, '', '萧山宇隆仓', 10.0000, 9.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', NULL, 1, 1, 0, NULL, '2019-09-24 13:26:34.070000', '05051', NULL, '2023-04-12 00:42:28.462419', NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (54, 'EPTISON', 'BD201706010003', 'A', NULL, NULL, '', NULL, NULL, NULL, 33, '杭州全尚科技股份有限公司', NULL, NULL, NULL, 1, 0, NULL, '2019-12-27 00:00:00.356000', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (55, '新品牌-NS', 'BD201706010006', '', NULL, NULL, '', NULL, NULL, NULL, 33, '杭州全尚科技股份有限公司', NULL, NULL, NULL, 1, 0, NULL, '2019-12-27 00:00:00.354000', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (58, '无', 'BRAND', 'A', NULL, NULL, '', NULL, NULL, NULL, 33, '杭州全尚科技股份有限公司', NULL, NULL, NULL, 1, 0, NULL, '2019-12-27 00:00:00.356000', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (63, 'ECKO女装', 'V', 'A', 'ECKO', 0, '1,3,2,4,5,6,0', '萧山宇隆仓', 12.0000, 9.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', NULL, 1, 1, 0, NULL, '2020-07-11 00:00:00.575000', NULL, NULL, '2023-04-12 00:42:32.484836', '管理员', NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (64, 'ECKO男装', 'U', '', 'ECKO', 1, '1,2,3,5,4,0,6', '萧山宇隆仓', 12.0000, 9.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', NULL, 1, 1, 0, NULL, '2020-07-11 00:00:00.592000', NULL, NULL, '2023-04-12 00:42:36.140414', '管理员', NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (72, '公共', '999999', 'A', '公共', 5, '', '萧山宇隆仓', 0.0000, 0.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', NULL, 0, 1, 0, NULL, '2020-12-30 15:01:29.746000', '李怡文', NULL, '2023-04-12 00:42:39.561661', '朱阿鹏', NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (73, 'ROCAWEAR', 'ROCAWEAR', 'A', 'ROCAWEAR', 5, '1,3,5,2,4,6,0', '萧山瓜沥仓', 13.0000, 9.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', NULL, 1, 1, 0, NULL, '2021-01-19 10:14:08.910000', '汪归', NULL, '2023-04-12 00:42:41.647019', '周涛', NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (74, 'NPC', 'P', 'A', 'NPC', 1, '1,3,2,4,5,6,0', '萧山瓜沥仓', 12.0000, 9.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', NULL, 1, 1, 0, NULL, '2021-01-22 14:03:17.389000', NULL, NULL, '2023-04-12 00:42:44.941650', '杨帅', NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (75, 'ECKO童装', 'I', 'A', 'ECKO童装', 1, '', '萧山瓜沥仓', 12.0000, 9.0000, 35, '湖州全尚科技有限公司', '浙江省湖州市长兴县吕山乡吕山村', '0571-82166391', 1, 1, 0, NULL, '2021-01-22 14:03:17.391000', NULL, NULL, '2023-04-12 00:42:47.087520', '杨帅', NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (432, '衣品天成童装', 'TZ', 'A', '衣品天成童装', 4, '', '萧山瓜沥仓', 10.0000, 9.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', '0571-82166391', 1, 1, 0, NULL, '2022-05-19 10:04:02.486000', '杨帅', NULL, '2023-04-12 00:42:50.228125', '杨帅', NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (756, 'CHIC PARK', 'CK', 'A', 'CHIC PARK', 1, '1,2,3,4,5,6,0', '萧山宇隆仓', 10.0000, 8.0000, 33, '杭州全尚科技股份有限公司', '杭州市萧山区宁围街道萧山农业大厦2栋14-18层', '0571-82166391', 1, 1, 0, NULL, '2022-06-28 12:14:39.088000', '乔通', NULL, '2023-04-12 00:42:52.178391', '乔通', NULL);
INSERT INTO `scm_test`.`basic_brand`(`id`, `brand_name`, `brand_code`, `tag_type`, `tag_display_name`, `gender`, `date_allowed`, `warehouse`, `cost_ratio`, `retail_price_mantissa`, `company_id`, `company_name`, `company_address`, `company_phone`, `hast_trial_production_fee`, `enable`, `deleted`, `remark`, `created`, `create_user`, `create_user_id`, `last_updated`, `last_update_user`, `last_update_user_id`) VALUES (4592, 'chictype', 'J', 'A', 'chictype', 5, '', '萧山宇隆仓', 12.0000, 9.0000, 35, '湖州全尚科技有限公司', '浙江省湖州市长兴县吕山乡吕山村', NULL, 1, 1, 0, NULL, '2022-07-08 16:10:00.846000', NULL, NULL, '2023-04-12 00:42:55.467647', '朱阿鹏', NULL);