target 平台商品刊登设计

```sql
CREATE TABLE `db_category` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `category_id` varchar(50) NOT NULL DEFAULT '' COMMENT '分类id',
    `item_type_id` varchar(50) NOT NULL DEFAULT '' COMMENT '末级类目id',
  `parent_id` varchar(50) NOT NULL DEFAULT '0' COMMENT '父类目id',
  `name_zh` varchar(200) NOT NULL DEFAULT '' COMMENT '类目中文名称',
  `name_en` varchar(200) NOT NULL DEFAULT '' COMMENT '类目英文名称',
  `category_id_path` varchar(400) NOT NULL DEFAULT '' COMMENT 'id路径',
  `name_zh_path` varchar(400) NOT NULL DEFAULT '' COMMENT '类目中文名称路径',
  `name_en_path` varchar(400) NOT NULL DEFAULT '' COMMENT '类目英文名称路径',
  
  `is_leaf` tinyint(1) NOT NULL DEFAULT '2' COMMENT '是否为叶子节点:1：true 2：false',
  `cat_level` tinyint(1) NOT NULL DEFAULT '0' COMMENT '分类层级',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
  /*T![clustered_index] CLUSTERED */,
  KEY `idx_cat_id` (`category_id`),
  KEY `idx_parent_id` (`parent_id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin AUTO_INCREMENT = 0 COMMENT = 'target分类表'
```

```sql
CREATE TABLE `db_category_attribute` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `category_id` int(11) NOT NULL DEFAULT '0' COMMENT '类目id',
  `category_name_en` varchar(200) NOT NULL DEFAULT '' COMMENT '类目英文名称',
   `attribute_id` varchar(200) NOT NULL DEFAULT '' COMMENT '类目属性id',
   `attribute_name` varchar(200) NOT NULL DEFAULT '' COMMENT '类目属性名',
    `attribute_type` varchar(200) NOT NULL DEFAULT '' COMMENT '字段类型(是/否单独写入)',
	 `max_selections` varchar(200) NOT NULL DEFAULT '' COMMENT '最多可以选择多少项',
    `required` int(11) NOT NULL DEFAULT 0 COMMENT '1-必填 2-非必填',
  `attribute_values` mediumtext NOT NULL COMMENT '类目属性值value',
    `order` int(11) NOT NULL DEFAULT 0 COMMENT '1, 2,3',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
  /*T![clustered_index] CLUSTERED */,
  KEY `idx_category_id` (`category_id`),
  UNIQUE KEY `uniq_category_name_en` (`category_name_en`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin AUTO_INCREMENT = 0 COMMENT = 'target分类属性表'
```
### 
### 商品刊登表结构
```sql
CREATE TABLE `db_targettask` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `company_id` int(11) NOT NULL COMMENT '企业编号',
  `shop_id` int(11) DEFAULT NULL COMMENT '店铺id',
   `shop_name` varchar(256) DEFAULT NULL COMMENT '店铺名称',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `category_id` varchar(30) DEFAULT NULL COMMENT '类目id',
  `category_name` varchar(256) DEFAULT NULL COMMENT '类目名称',
   `parent_sku` varchar(256) DEFAULT NULL COMMENT '父类sku',
 `brand` varchar(512) DEFAULT NULL COMMENT '品牌名称',
  `price` decimal(15, 4) DEFAULT NULL COMMENT '原价格',
   `offer_price` decimal(15, 4) DEFAULT NULL COMMENT '售价',
   `map_price` decimal(15, 4) DEFAULT NULL COMMENT 'MAP售价',
  `currency_id` varchar(30) DEFAULT NULL COMMENT '货币符号，以美元计价',
  `available_quantity` varchar(255) DEFAULT NULL COMMENT '可用数量',
  `picture_main_url` varchar(255) DEFAULT NULL COMMENT '商品主图',
   `picture_additional_url` varchar(255) DEFAULT NULL COMMENT '商品额外图',
  `description` mediumtext DEFAULT NULL COMMENT '商品描述',
  `bar_code` varchar(256) NOT NULL DEFAULT '' COMMENT '商品条码',
   `package_length` int(10) DEFAULT NULL COMMENT '包裹长度',
  `package_width` int(10) DEFAULT NULL COMMENT '包裹宽度',
  `package_height` int(10) DEFAULT NULL COMMENT '包裹高度',
   `package_weight` decimal(10, 2) unsigned DEFAULT NULL COMMENT '包裹重量',
   `product_length` int(10) DEFAULT NULL COMMENT '产品长度',
  `product_width` int(10) DEFAULT NULL COMMENT '产品宽度',
  `product_height` int(10) DEFAULT NULL COMMENT '产品高度',
   `product_weight` decimal(10, 2) unsigned DEFAULT NULL COMMENT '产品重量',
  `import_settings` varchar(255) DEFAULT NULL COMMENT '进口设定',
  `california_bill_warning` varchar(255) DEFAULT NULL COMMENT '加州 65 号法案警告',
  `have_variations` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否有子属性 1,有 2,无',
  `sales_attributes`  text DEFAULT NULL COMMENT '销售信息扩展参数',
  `logistics_attributes`  text DEFAULT NULL COMMENT '物流信息扩展参数',
  `compliance_attributes`  text DEFAULT NULL COMMENT '合规信息扩展参数',
  `createoper_id` int(10) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_oper_td` int(10) DEFAULT NULL COMMENT '修改人',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `flag` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：1.待刊登 2.刊登中  6.刊登失败 7.部分子商品刊登失败 9.刊登成功',
  `error_message` text DEFAULT NULL COMMENT '错误描述',
  `source_url` text DEFAULT NULL COMMENT '来源URL',
  `is_timing` tinyint(1) DEFAULT '2' COMMENT '是否定时刊登 1是 2否',
  `remark` varchar(500) DEFAULT '' COMMENT '备注信息',
  `developer_id` int(11) DEFAULT NULL COMMENT '开发员id',
  `product_id` varchar(255) DEFAULT NULL COMMENT '商品刊登成功回写productid',
  `bullet_attributes` varchar(200) DEFAULT NULL COMMENT 'bullet 信息',
  `variation_theme` varchar(512) DEFAULT NULL COMMENT '变体主题',
  `cecter_request_id` varchar(50) NOT NULL DEFAULT '' COMMENT '中台id',
  PRIMARY KEY (`id`)
  /*T![clustered_index] CLUSTERED */,
  KEY `idx_flag_updatetime` (`flag`, `update_time`),
  KEY `idx_companyid_flag_shopid` (`company_id`, `flag`, `shop_id`),
  KEY `i_utime` (`update_time`),
  KEY `idx_cecter_request_id` (`cecter_request_id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin AUTO_INCREMENT = 0 COMMENT = 'target刊登主表'
```

```sql
CREATE TABLE `db_target_variation` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '企业编号',
  `shop_id` int(11) NOT NULL DEFAULT '0' COMMENT '店铺编号',
  `task_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '草稿主键',
  `sku` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'sku',
    `sku_title` varchar(512) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'sku主题',
	 `price` decimal(15, 4) DEFAULT NULL COMMENT '原价格',
  `variation_specifics` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '变体主题属性',
  `available_quantity` int(11) NOT NULL DEFAULT '0' COMMENT '可用库存',
  `attribute_variation_combinations` text COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '变体属性',
  `pictures` text COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片',
  `bar_code` varchar(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品条码 upc ean gtin',
  `package_info` varchar(512) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '包装信息',
  `stock_info` text COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '库存信息',
   `package_weight` varchar(512) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '重量信息',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
  /*T![clustered_index] CLUSTERED */,
  KEY `idx_cid_sid` (`company_id`, `shop_id`) COMMENT '企业店铺索引',
  KEY `idx_cid_tid` (`company_id`, `task_id`) COMMENT '企业主表id索引'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'target变体草稿表'
```
```sql
CREATE TABLE `mps_target_task` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `app_id` bigint(20) DEFAULT NULL COMMENT 'appid',
  `shop_id` bigint(20) DEFAULT NULL COMMENT '店铺id',
  `site` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '站点',
  `type` int(11) DEFAULT NULL COMMENT '任务类型  1: 正常刊登   2: 海外版刊登',
  `product_type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '产品编码类型',
  `title` text COLLATE utf8mb4_bin COMMENT '商品名称',
  `description` text COLLATE utf8mb4_bin COMMENT '商品描述',
  `stock` int(11) DEFAULT NULL COMMENT '库存',
  `category_id` bigint(20) DEFAULT NULL COMMENT '类目id',
  `category` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '类目名称',
  `sku` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '商品的 sku ',
  `attribute_list` mediumtext COLLATE utf8mb4_bin COMMENT '属性列表',
  `status` tinyint(4) DEFAULT NULL COMMENT '刊登状态，1：待刊登   2：刊登中   3：定时刊登  6：刊登失败 7：部分失败  9：刊登成功',
  `result` longtext COLLATE utf8mb4_bin COMMENT '刊登结果',
  `product_id` bigint(20) DEFAULT NULL COMMENT '刊登成功回写商品id',
  `step` int(11) DEFAULT NULL COMMENT '当前执行步骤',
  `feed_id` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '结果id,用来轮询获取结果id字段',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '最后修改时间',
  `is_timer` int(11) DEFAULT NULL COMMENT '定时执行  1: 执行  2: 未执行',
  PRIMARY KEY (`id`),
  KEY `shop_id` (`shop_id`) COMMENT '店铺id',
  KEY `idx_shop_process` (`shop_id`, `process_id`),
  KEY `idx_sku` (`sku`),
  KEY `idx_time` (`create_time`),
  KEY `idx_status` (`status`),
  KEY `idx_step` (`step`),
  KEY `idx_process_id` (`process_id`)
) CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'target刊登表'
```
```sql
CREATE TABLE `mps_target_task_varation` (
  `id` bigint(20) NOT NULL,
  `app_id` bigint(20) DEFAULT NULL COMMENT 'appid',
  `shop_id` bigint(20) DEFAULT NULL COMMENT '店铺id',
  `task_id` bigint(20) DEFAULT NULL COMMENT '关联任务表ID',
  `sku` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '子商品的 sku ',
  `product_type` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '产品编码类型',
  `attribute_list` mediumtext COLLATE utf8mb4_bin COMMENT '属性列表',
  `status` tinyint(4) DEFAULT NULL COMMENT '刊登状态，1：待刊登   2：刊登中  3：定时刊登  6：刊登失败 7：部分失败  9：刊登成功',
  `result` longtext COLLATE utf8mb4_bin COMMENT '刊登结果',
  `product_id` bigint(20) DEFAULT NULL COMMENT '刊登成功回写商品id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '最后修改时间',
  `process_id` bigint(20) DEFAULT NULL COMMENT '批次Id',
  PRIMARY KEY (`id`),
  KEY `shopId` (`shop_id`) COMMENT '店铺id',
  KEY `taskId` (`task_id`) COMMENT '父任务id',
  KEY `idx_task` (`task_id`),
  KEY `idx_sku` (`sku`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = 'target变种子刊登表'
```
### 选举一级类目
```java
 GET /item_taxonomies/v2/taxonomies
 https://stage-api.target.com/item_taxonomies/v2/taxonomies?page=1&per_page=100&status=ACTIVE&id=535
 respone:
  [
    {
        "name": "HOME",
        "type": "PRODUCT_TYPE",
        "parent_id": "root",
        "targets": [
            "INTERNAL"
        ],
        "id": "535",
        "status": "ACTIVE",
        "breadcrumbs": [
            {
                "id": "root",
                "name": "Target Products",
                "status": "ACTIVE",
                "type": "ROOT"
            }
        ],
        "last_modified": "2019-07-18T07:00:00.493Z",
        "child_count": 8
    }
]
```

### 获取一级类目具体属性
```java
https://stage-api.target.com/item_taxonomies/v2/assignments?taxonomy_id=535&attribute_group=SELLING,CORE,TAX,LOGISTICS&target=EXTERNAL

response:

[
    {
        "taxonomy_id": "root",
        "attribute_id": "498510364",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "id": "762615937",
        "created": "2022-04-25T20:11:15.401Z",
        "last_modified": "2023-06-15T20:34:49.503Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "498510364",
            "name": "Bullet Feature 8",
            "description": "Highlights or features about the product, up to fifteen bullets.",
            "notes": "Used for item ingestion.",
            "type": "TEXT",
            "attribute_group": "CORE",
            "attribute_level": "GROUP",
            "mapped_property": "descriptions.bullets[8]"
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "1951696667",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "value_group_ids": [
            "174550-284395"
        ],
        "id": "979315083",
        "created": "2024-07-08T18:49:51.109Z",
        "last_modified": "2024-07-08T18:49:51.109Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "1951696667",
            "name": "Carbon and Emission Claims",
            "description": "Indicates if this item is subjective to California AB-1305 Voluntary Carbon Market Disclosures. If Yes then Carbon and Emission Claims URL or Carbon and Emission Qualifiers must also be entered.",
            "type": "VALUE",
            "attribute_group": "CORE",
            "attribute_level": "GROUP",
            "mapped_property": "compliance.is_carbon_neutral"
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "614426828",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "id": "190831330",
        "created": "2024-07-08T18:49:55.045Z",
        "last_modified": "2024-07-08T18:49:55.046Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "614426828",
            "name": "Carbon and Emission Claims URL",
            "description": "If California AB-1305 Voluntary Carbon Market Disclosures applies to the item, this is the URL that links to a website that provides the legally required information that must be disclosed as per CA AB-2331 law. The URL must begin with a standard prefix such as www. or http:// or https://.",
            "type": "TEXT",
            "attribute_group": "CORE",
            "attribute_level": "GROUP",
            "mapped_property": "compliance.carbon_neutral_url"
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "909953362",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "id": "717479983",
        "created": "2022-04-25T20:12:14.044Z",
        "last_modified": "2023-06-15T20:33:45.331Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "909953362",
            "name": "Bullet Feature 12",
            "description": "Highlights or features about the product, up to fifteen bullets.",
            "notes": "Used for item ingestion.",
            "type": "TEXT",
            "attribute_group": "CORE",
            "attribute_level": "GROUP",
            "mapped_property": "descriptions.bullets[12]"
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "125189397",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "id": "81458415",
        "created": "2022-04-25T20:11:30.784Z",
        "last_modified": "2023-06-15T20:34:55.174Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "125189397",
            "name": "Bullet Feature 9",
            "description": "Highlights or features about the product, up to fifteen bullets.",
            "notes": "Used for item ingestion.",
            "type": "TEXT",
            "attribute_group": "CORE",
            "attribute_level": "GROUP",
            "mapped_property": "descriptions.bullets[9]"
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "884552873",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "id": "1028235015",
        "created": "2021-03-18T19:40:23.100Z",
        "last_modified": "2023-06-15T20:38:15.666Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "884552873",
            "name": "Product Name",
            "description": "A short name or additional description of an item which will be used to populate the item’s product title. This should be used for information that is not captured in the attributes.  ",
            "notes": "Tool_Dependent 7/30/20 Created MTA for T+ product title automation. LK",
            "type": "TEXT",
            "attribute_group": "SELLING",
            "attribute_level": "GROUP",
            "mapped_property": "884552873"
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "365354122",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "id": "730671671",
        "created": "2024-07-08T18:49:59.272Z",
        "last_modified": "2024-07-08T18:49:59.272Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "365354122",
            "name": "Carbon and Emission Qualifiers",
            "description": "If a URL is not available, provide the legally required information as specified in California AB-1305 Voluntary Carbon Market Disclosures. ",
            "type": "TEXT",
            "attribute_group": "CORE",
            "attribute_level": "GROUP",
            "mapped_property": "compliance.carbon_emission_qualifiers"
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "934571693",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "id": "1979302080",
        "created": "2022-04-25T20:13:02.081Z",
        "last_modified": "2023-06-15T20:34:03.275Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "934571693",
            "name": "Bullet Feature 15",
            "description": "Highlights or features about the product, up to fifteen bullets.",
            "notes": "Used for item ingestion.",
            "type": "TEXT",
            "attribute_group": "CORE",
            "attribute_level": "GROUP",
            "mapped_property": "descriptions.bullets[15]"
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "884589648",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "id": "1189041845",
        "created": "2022-04-25T20:12:31.395Z",
        "last_modified": "2023-06-15T20:33:51.031Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "884589648",
            "name": "Bullet Feature 13",
            "description": "Highlights or features about the product, up to fifteen bullets.",
            "notes": "Used for item ingestion.",
            "type": "TEXT",
            "attribute_group": "CORE",
            "attribute_level": "GROUP",
            "mapped_property": "descriptions.bullets[13]"
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "431639027",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "id": "1182742469",
        "created": "2020-12-09T19:38:28.241Z",
        "last_modified": "2023-06-15T20:38:54.268Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "431639027",
            "name": "Return Policy",
            "description": "Identify a return policy (ex. AAA, AAB) for your item, if a policy is not provided Target will select one to assign",
            "type": "TEXT",
            "attribute_group": "LOGISTICS",
            "attribute_level": "BUYABLE",
            "mapped_property": "seller_return_policy",
            "tags": [
                "review_not_required"
            ],
            "minimum_value": 3,
            "maximum_value": 3
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "1123763136",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "id": "857022169",
        "created": "2022-04-25T20:11:47.206Z",
        "last_modified": "2023-06-15T20:33:32.245Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "1123763136",
            "name": "Bullet Feature 10",
            "description": "Highlights or features about the product, up to fifteen bullets.",
            "notes": "Used for item ingestion.",
            "type": "TEXT",
            "attribute_group": "CORE",
            "attribute_level": "GROUP",
            "mapped_property": "descriptions.bullets[10]"
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "37972488",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "value_group_ids": [
            "335921198"
        ],
        "id": "1019234041",
        "created": "2023-07-18T20:34:22.547Z",
        "last_modified": "2023-07-18T20:34:22.547Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "37972488",
            "name": "Net Contents Unit of Measure",
            "description": "The unit of measure used to describe the amount of the consumable product of the trade item contained in a package, as declared on the label, which may include net weight, volume, count, units.",
            "notes": "7/18/23 JH: To be used only for EXTERNAL (3P/T+) Taxonomy.",
            "type": "VALUE",
            "attribute_group": "CORE",
            "attribute_level": "GROUP",
            "mapped_property": "compliance.net_content_unit_of_measure"
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "1446051420",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "id": "131464976",
        "created": "2022-04-25T20:12:01.489Z",
        "last_modified": "2023-06-15T20:33:39.732Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "1446051420",
            "name": "Bullet Feature 11",
            "description": "Highlights or features about the product, up to fifteen bullets.",
            "notes": "Used for item ingestion.",
            "type": "TEXT",
            "attribute_group": "CORE",
            "attribute_level": "GROUP",
            "mapped_property": "descriptions.bullets[11]"
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "1067311628",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "id": "194063777",
        "created": "2022-04-25T20:10:43.459Z",
        "last_modified": "2023-06-15T20:34:43.988Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "1067311628",
            "name": "Bullet Feature 7",
            "description": "Highlights or features about the product, up to fifteen bullets.",
            "notes": "Used for item ingestion.",
            "type": "TEXT",
            "attribute_group": "CORE",
            "attribute_level": "GROUP",
            "mapped_property": "descriptions.bullets[7]"
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "2002576117",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "id": "510743932",
        "created": "2022-04-25T20:12:46.795Z",
        "last_modified": "2023-06-15T20:33:56.828Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "2002576117",
            "name": "Bullet Feature 14",
            "description": "Highlights or features about the product, up to fifteen bullets.",
            "notes": "Used for item ingestion.",
            "type": "TEXT",
            "attribute_group": "CORE",
            "attribute_level": "GROUP",
            "mapped_property": "descriptions.bullets[14]"
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "1762622332",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "id": "393246546",
        "created": "2022-04-25T20:09:58.501Z",
        "last_modified": "2023-06-15T20:34:38.118Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "1762622332",
            "name": "Bullet Feature 6",
            "description": "Highlights or features about the product, up to fifteen bullets.",
            "notes": "Used for item ingestion.",
            "type": "TEXT",
            "attribute_group": "CORE",
            "attribute_level": "GROUP",
            "mapped_property": "descriptions.bullets[6]"
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "2057497820",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "id": "1902016129",
        "created": "2023-07-18T20:33:41.819Z",
        "last_modified": "2023-07-18T20:33:41.819Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "2057497820",
            "name": "Net Contents Quantity",
            "description": "The numerical amount of the consumable product of the trade item contained in a package, as declared on the label, which may include net weight, volume, count, units.",
            "notes": "7/18/23 JH: To be used only for EXTERNAL (3P/T+) Taxonomy.",
            "type": "NUMBER",
            "attribute_group": "CORE",
            "attribute_level": "GROUP",
            "mapped_property": "compliance.net_content_quantity"
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "1272385820",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "id": "1384469235",
        "created": "2020-04-21T18:27:50.003Z",
        "last_modified": "2023-06-15T20:31:48.043Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "1272385820",
            "name": "Additional Image 1",
            "description": "Alternate product image URL. Images must be JPGs. Images must be RGB. Preferred minimum dimensions are 2400x2400px. Recommended minimum dimensions are 1200x1200px. Lifestyle images should show product, at scale, in use. Product images should present a great view of the item and highlight top features. When applicable images should showcase size, scale, shape, and/or capacity. Front of packaging is acceptable if it is clearly in-package (not a graphic/illustration/CAD of the package). Must not contain any watermarks, promotional language, or graphic content. Filler/placeholder images, such as \"No Image\" images, are not allowed. Do not feature items that do not come with, or are not part of, the item (using a relevant prop is acceptable if you are calling attention to physical scale (e.g., prop a vase with a single flower). Props should be sparse and neutral (white) whenever possible. Images must have full usage rights. Product should be shot either overhead, (slightly) 3/4 overhead or straight on. The approach is graphic and clean. The product should never appear fussy or overworked. Think modern yet warm. Retouching should be minimal, clean-up product as necessary. Shadows may need to be adjusted but should retain their natural state and not look manufactured. The shadow should follow the shape of the item and be soft with a little deeper value adjacent to the edges of the product.",
            "notes": "Used for item ingestion",
            "type": "TEXT",
            "attribute_group": "CORE",
            "attribute_level": "BUYABLE",
            "mapped_property": "digital_assets.images.alternate_image_urls[1]"
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "999763752",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "id": "351516397",
        "created": "2020-04-21T18:27:59.291Z",
        "last_modified": "2023-06-15T20:31:51.692Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "999763752",
            "name": "Additional Image 10",
            "description": "Alternate product image URL. Images must be JPGs. Images must be RGB. Preferred minimum dimensions are 2400x2400px. Recommended minimum dimensions are 1200x1200px. Lifestyle images should show product, at scale, in use. Product images should present a great view of the item and highlight top features. When applicable images should showcase size, scale, shape, and/or capacity. Front of packaging is acceptable if it is clearly in-package (not a graphic/illustration/CAD of the package). Must not contain any watermarks, promotional language, or graphic content. Filler/placeholder images, such as \"No Image\" images, are not allowed. Do not feature items that do not come with, or are not part of, the item (using a relevant prop is acceptable if you are calling attention to physical scale (e.g., prop a vase with a single flower). Props should be sparse and neutral (white) whenever possible. Images must have full usage rights. Product should be shot either overhead, (slightly) 3/4 overhead or straight on. The approach is graphic and clean. The product should never appear fussy or overworked. Think modern yet warm. Retouching should be minimal, clean-up product as necessary. Shadows may need to be adjusted but should retain their natural state and not look manufactured. The shadow should follow the shape of the item and be soft with a little deeper value adjacent to the edges of the product.",
            "notes": "Used for item ingestion",
            "type": "TEXT",
            "attribute_group": "CORE",
            "attribute_level": "BUYABLE",
            "mapped_property": "digital_assets.images.alternate_image_urls[10]"
        }
    },
    {
        "taxonomy_id": "root",
        "attribute_id": "870272585",
        "targets": [
            "EXTERNAL"
        ],
        "required": false,
        "is_ai_derivable": false,
        "is_review_required": false,
        "max_selections": 1,
        "allow_value_requests": false,
        "id": "1057719888",
        "created": "2019-03-01T16:40:04.507Z",
        "last_modified": "2023-06-15T20:31:55.555Z",
        "taxonomy": {
            "id": "root",
            "name": "Target Products",
            "status": "ACTIVE",
            "type": "ROOT",
            "breadcrumbs": []
        },
        "attribute": {
            "id": "870272585",
            "name": "Additional Image 11",
            "description": "Alternate product image URL. Images must be JPGs. Images must be RGB. Preferred minimum dimensions are 2400x2400px. Recommended minimum dimensions are 1200x1200px. Lifestyle images should show product, at scale, in use. Product images should present a great view of the item and highlight top features. When applicable images should showcase size, scale, shape, and/or capacity. Front of packaging is acceptable if it is clearly in-package (not a graphic/illustration/CAD of the package). Must not contain any watermarks, promotional language, or graphic content. Filler/placeholder images, such as \"No Image\" images, are not allowed. Do not feature items that do not come with, or are not part of, the item (using a relevant prop is acceptable if you are calling attention to physical scale (e.g., prop a vase with a single flower). Props should be sparse and neutral (white) whenever possible. Images must have full usage rights. Product should be shot either overhead, (slightly) 3/4 overhead or straight on. The approach is graphic and clean. The product should never appear fussy or overworked. Think modern yet warm. Retouching should be minimal, clean-up product as necessary. Shadows may need to be adjusted but should retain their natural state and not look manufactured. The shadow should follow the shape of the item and be soft with a little deeper value adjacent to the edges of the product.",
            "notes": "Used for item ingestion",
            "type": "TEXT",
            "attribute_group": "CORE",
            "attribute_level": "BUYABLE",
            "mapped_property": "digital_assets.images.alternate_image_urls[11]"
        }
    }
]
```
### 属性id 获取属性valueId
```java
https://stage-api.target.com/item_taxonomies/v2/attribute_values?taxonomy_id=99519648&attribute_id=134352

response:

[
    {
        "name": "Collapsible",
        "id": "379759",
        "last_modified": "2020-06-09T15:03:21.068Z",
        "status": "ACTIVE",
        "alias_ids": [
            "379759"
        ]
    },
    {
        "name": "Dome",
        "id": "279136",
        "last_modified": "2020-06-08T15:45:25.305Z",
        "status": "ACTIVE",
        "alias_ids": [
            "279136"
        ]
    },
    {
        "name": "Fold Over Top",
        "id": "430126",
        "last_modified": "2023-09-20T20:31:31.482Z",
        "status": "ACTIVE",
        "alias_ids": [
            "430126"
        ]
    },
    {
        "name": "Hardside",
        "id": "828282",
        "last_modified": "2020-06-09T15:05:49.716Z",
        "status": "ACTIVE",
        "alias_ids": [
            "828282"
        ]
    },
    {
        "name": "Lightweight",
        "id": "332192",
        "last_modified": "2023-07-05T16:47:39.862Z",
        "status": "ACTIVE",
        "alias_ids": [
            "332192"
        ]
    },
    {
        "name": "Miniature",
        "id": "807963",
        "last_modified": "2020-06-09T15:05:30.577Z",
        "status": "ACTIVE",
        "alias_ids": [
            "807963"
        ]
    },
    {
        "name": "Pouch",
        "id": "400305",
        "last_modified": "2020-06-08T15:45:14.080Z",
        "status": "ACTIVE",
        "alias_ids": [
            "400305"
        ]
    },
    {
        "name": "Skate Wheels",
        "id": "828286",
        "last_modified": "2020-06-09T15:05:50.089Z",
        "status": "ACTIVE",
        "alias_ids": [
            "828286"
        ]
    },
    {
        "name": "Softside",
        "id": "828283",
        "last_modified": "2020-06-09T15:05:49.784Z",
        "status": "ACTIVE",
        "alias_ids": [
            "828283"
        ]
    },
    {
        "name": "Spinner Wheels",
        "id": "828285",
        "last_modified": "2020-06-09T15:05:49.989Z",
        "status": "ACTIVE",
        "alias_ids": [
            "828285"
        ]
    },
    {
        "name": "Square",
        "id": "240517",
        "last_modified": "2020-06-08T15:44:50.533Z",
        "status": "ACTIVE",
        "alias_ids": [
            "240517"
        ]
    },
    {
        "name": "Structured",
        "id": "379905",
        "last_modified": "2020-06-09T15:03:21.296Z",
        "status": "ACTIVE",
        "alias_ids": [
            "379905"
        ]
    },
    {
        "name": "Underseater",
        "id": "828281",
        "last_modified": "2020-06-09T15:05:49.653Z",
        "status": "ACTIVE",
        "alias_ids": [
            "828281"
        ]
    },
    {
        "name": "Unstructured",
        "id": "379906",
        "last_modified": "2020-06-09T15:03:21.394Z",
        "status": "ACTIVE",
        "alias_ids": [
            "379906"
        ]
    }
]

```
### 刊登接口梳理

| 序号 | 模块功能 | 功能描述 | 备注 |
| --- | --- | --- | --- |
|  1 | 前端功能 | 查询店铺列表 | php 提供 |
|  2 |  前端功能| 查询类目数 |  |
|  3 | 前端功能 | 查询类目属性信息 |  |
|  4 |  前端功能| 查询可用仓库列表 |  |
|  5 |  前端功能| 查询品牌列表 |  |
|  6 |  前端功能| 查询商品详情页 |  |
|  7 |  前端功能| 保存刊登任务 |  |
|  8 |  前端功能| 保存并刊登 |  |
|  9 |  前端功能| 查询商品列表查询 |  |
|  10 |  前端功能| 批量立即刊登 |  |
|  11 |  前端功能| 批量定时刊登 |  |
|  12 |  前端功能| 批量修改价格 |  |
|  13 |  前端功能| 批量修改库存 |  |
|  14 |  前端功能| 批量复制商品 |  |
|  15 |  前端功能| 批量备注商品 |  |
|  16 |  前端功能| 批量删除商品 |  |
|  17 |  前端功能| 查询退货政策 |  |

### 在线商品
| 序号 | 模块功能 | 功能描述 | 备注 |
| --- | --- | --- | --- |
|  1 | 前端功能 | 查询在线商品列表 |  |
|  2 |  前端功能| 批量同步在线商品 |  |
|  3 | 前端功能 | 批量修改库存 |  |
|  4 |  前端功能| 批量修改价格 |  |

### target 平台通道
| 序号 | 模块功能 | 功能描述 | 备注 |
| --- | --- | --- | --- |
|  1 | 平台交互功能 | 定时拉取同步类目分类信息 |  |
|  2 |  平台交互功能| 定时拉取同步类目分类属性信息 |  |
|  3 | 平台交互功能 | 定时拉取同步类目分类属性值信息 |  |
|  4 |  平台交互功能| 定时/手动 拉取同步可用仓库列表 |  |
|  5 |  平台交互功能| 定时/手动 拉取同步可用品牌列表 |  |
|  6 |  平台交互功能| 定时/手动 拉取同步可用商户承运接口 |  |
|  7 |  平台交互功能| 刊登商品 |  |
|  8 |  平台交互功能| 商品刊登审核状态 |  |
|  9 |  平台交互功能| 退货政策接口 |  |

### 所有关于图片类的相关基础接口，全部走以前的通用能力接口(php)
### 前置基础信息
#### 获取平台商品类目
- 调用平台商品类目api（父子关联）

### 获取类目属性
- 指定商品类目下的属性
- 通过类目 id 与属性id 获取具体的属性值

### 香港表结构todo