Hybris 6.6 carts43sn表太大。 它是干什么用的

2020-09-15 10:58发布

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


我们发现桌子carts43sn非常大。 它包含的行数比购物车表多16倍。

它在哪里使用,如何清除?

 在此处输入代码mysql> desc carts43sn;
  + ------------------ + -------------- + ------ + ----- +-  ------- + ---------------- +
  | 领域 类型 空| 关键 默认值| 额外|
  + ------------------ + -------------- + ------ + ----- +-  ------- + ---------------- +
  |  ID |  bigint(20)| 否|  PRI |  NULL |  auto_increment |
  |  ITEMPK |  bigint(20)| 是的 MUL |  NULL |  |
  |  ITEMTYPEPK |  bigint(20)| 是的 |  NULL |  |
  | 时间戳|  datetime(6)| 是的 |  NULL |  |
  | 当前时间戳记|  datetime(6)| 是的 |  NULL |  |
  | 更改用户|  varchar(255)| 是的 |  NULL |  |
  | 上下文| 长文本| 是的 |  NULL |  |
  | 有效载荷 长文本| 是的 |  NULL |  |
  | 有效载荷后| 长文本| 是的 |  NULL |  |
  | 操作类型|  bigint(20)| 是的 |  NULL |  |
  + ------------------ + -------------- + ------ + ----- +-  ------- + ---------------- +
 
  mysql> select * from carts43sn限制1 \ G
  *************************** 1.行********************  *******
                编号:1
            宜必思:8806939263019
        产品类型PK:8796094038098
         时间戳:2018-03-21 13:47:03.711000
  当前时间戳:2018-03-21 13:47:03.770000
      更改用户:testkuser+_20171222131724@gmail.com
           上下文:{}
     之前的有效负载:{" mapBasedAttributes":{}," attributes":{}," locAttributes":{}}
      payloadafter:{" mapBasedAttributes":{}," attributes":{" date":{" type":{" type":" java.util.Date"," collection":""}," value":[  " 1521636423546"]},"代码":{"类型":{"类型":" java.lang.String","集合":""},"值":[" 200449000"]}},"支付成本"  :{" type":{" type":" java.lang.Double"," collection":""}," value":[" 0.0"]}," totalprice":{" type":{" type  ":" java.lang.Double","集合":""},"值":[" 0.0"]}," totaltaxvaluesinternal":{" type":{" type":" java.lang.String"  ," collection":""}," value":[" []"]}," discountsincludepaymentcost":{" type":{" type":" java.lang.Boolean"," collection":""}  ," value":[" false"]}," deliverycost":{" type":{" type":" java.lang.Double"," collection":""}," value":[" 0.0"  ]}," discountsincludedeliverycost":{" type":{" type":" java.lang.Boolean"," collection":""}," value":[" false"]}," totaltax":{"  type":{" type":" java.lang.Double"," collection":""}," value":[" 0.0"]}," modifiedtime":{" type":{" type":"  java.util.Date"," collection":""}," value":[" 1521636423711"]}," itemtype":{" type":{" type":" de.hybris.platform.core.PK  "," colle  ction":""}," value":[" 8796094038098"]},"小计":{" type":{" type":" java.lang.Double"," collection":""}," value  ":[" 0.0"]}," guid":{" type":{" type":" java.lang.String"," collection":""}," value":[" 83f8e42b-d7e9-420d  -bde0-e5b223ac7c88"]},"总折扣":{" type":{" type":" java.lang.Double"," collection":""}," value":[" 0.0"]}," 货币":{"类型":{"类型":" de.hybris.platform.core.PK","集合":""},"值":[" 8800746242081"]},"创建时间":{"  type":{" type":" java.util.Date"," collection":""}," value":[" 1521636423546"]}," pk":{" type":{" type":"  de.hybris.platform.core.PK"," collection":""}," value":[" 8806939263019"]}," net":{" type":{" type":" java.lang.Boolean  "," collection":""}," value":[" false"]}," calculated":{" type":{" type":" java.lang.Boolean"," collection":""}  ," value":[" false"]}," user":{" type":{" type":" de.hybris.platform.core.PK"," collection":""}," value":  [" 8797043884036"]}}," locAttributes":{}}
     操作类型:1
  设置1行(0.00秒)
  

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


我们发现桌子carts43sn非常大。 它包含的行数比购物车表多16倍。

它在哪里使用,如何清除?

 在此处输入代码mysql> desc carts43sn;
  + ------------------ + -------------- + ------ + ----- +-  ------- + ---------------- +
  | 领域 类型 空| 关键 默认值| 额外|
  + ------------------ + -------------- + ------ + ----- +-  ------- + ---------------- +
  |  ID |  bigint(20)| 否|  PRI |  NULL |  auto_increment |
  |  ITEMPK |  bigint(20)| 是的 MUL |  NULL |  |
  |  ITEMTYPEPK |  bigint(20)| 是的 |  NULL |  |
  | 时间戳|  datetime(6)| 是的 |  NULL |  |
  | 当前时间戳记|  datetime(6)| 是的 |  NULL |  |
  | 更改用户|  varchar(255)| 是的 |  NULL |  |
  | 上下文| 长文本| 是的 |  NULL |  |
  | 有效载荷 长文本| 是的 |  NULL |  |
  | 有效载荷后| 长文本| 是的 |  NULL |  |
  | 操作类型|  bigint(20)| 是的 |  NULL |  |
  + ------------------ + -------------- + ------ + ----- +-  ------- + ---------------- +
 
  mysql> select * from carts43sn限制1 \ G
  *************************** 1.行********************  *******
                编号:1
            宜必思:8806939263019
        产品类型PK:8796094038098
         时间戳:2018-03-21 13:47:03.711000
  当前时间戳:2018-03-21 13:47:03.770000
      更改用户:testkuser+_20171222131724@gmail.com
           上下文:{}
     之前的有效负载:{" mapBasedAttributes":{}," attributes":{}," locAttributes":{}}
      payloadafter:{" mapBasedAttributes":{}," attributes":{" date":{" type":{" type":" java.util.Date"," collection":""}," value":[  " 1521636423546"]},"代码":{"类型":{"类型":" java.lang.String","集合":""},"值":[" 200449000"]}},"支付成本"  :{" type":{" type":" java.lang.Double"," collection":""}," value":[" 0.0"]}," totalprice":{" type":{" type  ":" java.lang.Double","集合":""},"值":[" 0.0"]}," totaltaxvaluesinternal":{" type":{" type":" java.lang.String"  ," collection":""}," value":[" []"]}," discountsincludepaymentcost":{" type":{" type":" java.lang.Boolean"," collection":""}  ," value":[" false"]}," deliverycost":{" type":{" type":" java.lang.Double"," collection":""}," value":[" 0.0"  ]}," discountsincludedeliverycost":{" type":{" type":" java.lang.Boolean"," collection":""}," value":[" false"]}," totaltax":{"  type":{" type":" java.lang.Double"," collection":""}," value":[" 0.0"]}," modifiedtime":{" type":{" type":"  java.util.Date"," collection":""}," value":[" 1521636423711"]}," itemtype":{" type":{" type":" de.hybris.platform.core.PK  "," colle  ction":""}," value":[" 8796094038098"]},"小计":{" type":{" type":" java.lang.Double"," collection":""}," value  ":[" 0.0"]}," guid":{" type":{" type":" java.lang.String"," collection":""}," value":[" 83f8e42b-d7e9-420d  -bde0-e5b223ac7c88"]},"总折扣":{" type":{" type":" java.lang.Double"," collection":""}," value":[" 0.0"]}," 货币":{"类型":{"类型":" de.hybris.platform.core.PK","集合":""},"值":[" 8800746242081"]},"创建时间":{"  type":{" type":" java.util.Date"," collection":""}," value":[" 1521636423546"]}," pk":{" type":{" type":"  de.hybris.platform.core.PK"," collection":""}," value":[" 8806939263019"]}," net":{" type":{" type":" java.lang.Boolean  "," collection":""}," value":[" false"]}," calculated":{" type":{" type":" java.lang.Boolean"," collection":""}  ," value":[" false"]}," user":{" type":{" type":" de.hybris.platform.core.PK"," collection":""}," value":  [" 8797043884036"]}}," locAttributes":{}}
     操作类型:1
  设置1行(0.00秒)
  
付费偷看设置
发送
1条回答
宇峰
1楼 · 2020-09-15 11:59.采纳回答

找到了。 这是通用的审计逻辑。 并且可以在配置中将其关闭。 https://help.hybris.com/6.6.0/hcd/3e2b8491449d43b391eb1ce9c73cbb7f.html

一周热门 更多>