spawn scp -o StrictHostKeyChecking=no /tmp/csfzx_order_schema_probe.sql opsuser@8.147.119.215:/tmp/csfzx_order_schema_probe.sql

opsuser@8.147.119.215's password:

csfzx_order_schema_probe.sql                    0%    0     0.0KB/s   --:-- ETA
csfzx_order_schema_probe.sql                  100%  507    53.9KB/s   00:00
spawn ssh -o StrictHostKeyChecking=no opsuser@8.147.119.215 su - root -c 'mysql -h127.0.0.1 -P2883 -u"zhct_user@sys#city_subcenter_ob" -p"Zhct_OB_20260615" --table < /tmp/csfzx_order_schema_probe.sql'

opsuser@8.147.119.215's password:
Password: T8bN!3vGx$6jHy%1c
mysql: [Warning] Using a password on the command line interface can be insecure.
*************************** 1. row ***************************
       Table: ydy_meal_order
Create Table: CREATE TABLE `ydy_meal_order` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '订单ID',
  `order_no` varchar(20) NOT NULL DEFAULT '' COMMENT '订单号',
  `third_party_order_no` text NOT NULL COMMENT '三方订单号(多个逗号隔开)',
  `total_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '商品总金额(不含优惠折扣)',
  `ori_total_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '商品原始总金额',
  `order_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '订单金额(含优惠折扣)',
  `pay_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '实际付款金额(包含运费)',
  `cash` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '现金支付金额',
  `subsidy` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '补贴支付金额',
  `pay_method` varchar(20) NOT NULL DEFAULT '' COMMENT '支付方式(余额/微信/支付宝)',
  `pay_status` tinyint(3) unsigned NOT NULL DEFAULT '10' COMMENT '付款状态(10未付款 20已付款)',
  `pay_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '付款时间',
  `meal_date` date NOT NULL DEFAULT '2000-01-01' COMMENT '餐单日期',
  `meal_times` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '餐次 1早餐 2午餐 3晚餐',
  `meal_number` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '菜品数量',
  `bind_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '绑盘id/支付码id/0=虚拟订单',
  `bind_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '绑盘时间/订单创建时间',
  `equipment_code` varchar(32) NOT NULL DEFAULT '' COMMENT '设备编号',
  `last_meal_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '最后就餐时间',
  `source` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '订单来源1=绑盘机2=消费机3=虚拟订单4=AI运动营养师',
  `is_booking` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否订餐订单：0=否，1=是',
  `booking_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '订餐类型：0=非订餐，1=本人订餐，2=亲友餐，3=招待餐',
  `booking_batch_no` varchar(32) NOT NULL DEFAULT '' COMMENT '订餐批次号，一次提交多日期/多餐次共用',
  `booking_verify_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '订餐核销方式：0=无，1=人脸，2=二维码',
  `booking_verify_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '订餐核销状态：0=非订餐，10=待核销，20=已核销',
  `booking_unit_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '订餐单人餐费原价快照',
  `booking_qr_token` varchar(64) NOT NULL DEFAULT '' COMMENT '亲友/招待餐二维码核销token',
  `booking_guest_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '亲友常用人ID',
  `booking_reception_ext_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '招待餐扩展信息ID',
  `booking_cancel_deadline` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '订餐取消截止时间快照',
  `booking_dining_start_time` varchar(8) NOT NULL DEFAULT '' COMMENT '错峰就餐开始时间快照，格式HH:mm',
  `expense_owner_type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '费用归属：1=个人账户，2=部门账户',
  `expense_owner_id` varchar(64) NOT NULL DEFAULT '' COMMENT '费用归属ID：个人user_id或部门账户ID',
  `expense_owner_name` varchar(128) NOT NULL DEFAULT '' COMMENT '费用归属名称快照',
  `settled_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态0=未结算1结算中2结算成功3结算失败',
  `settled_start_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '结算开始时间',
  `settled_end_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '付款时间',
  `settled_order_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '结算订单id',
  `settled_res` text DEFAULT NULL COMMENT '结算返回值',
  `user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `origin_department_uuid` char(36) NOT NULL DEFAULT '' COMMENT '订单创建时原部门UUID',
  `origin_department_name` varchar(256) NOT NULL DEFAULT '' COMMENT '订单创建时原部门名称',
  `origin_department_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '订单创建时原部门状态：0停用/不存在 1有效',
  `origin_department_path` varchar(1024) NOT NULL DEFAULT '' COMMENT '原组织路径',
  `origin_department_snapshot_time` datetime DEFAULT NULL COMMENT '原部门快照生成时间',
  `restaurant_id` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '餐厅ID',
  `user_mobile` varchar(64) NOT NULL DEFAULT '' COMMENT '取餐人姓名',
  `user_name` varchar(64) NOT NULL DEFAULT '' COMMENT '取餐人手机号',
  `restaurant_method` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT '取餐方式：1=堂食 2=自提',
  `locker_code` varchar(64) NOT NULL DEFAULT '' COMMENT '取餐柜设备编号，对应ydy_equipment.code',
  `locker_address` varchar(255) NOT NULL DEFAULT '' COMMENT '取餐柜地址快照，小票打印和订单详情展示使用',
  `locker_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '取餐状态：0无需存餐，1未存餐，2已存餐，3已取餐，4已撤销',
  `locker_store_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '存餐时间',
  `locker_pickup_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '取餐时间',
  `locker_cell_no` varchar(255) NOT NULL DEFAULT '' COMMENT '存餐柜子编号，对应cellNo，可能为ID列表',
  `locker_cancel_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '撤销时间',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '用户备注',
  `package_fee` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '打包费',
  `order_status` tinyint(3) unsigned NOT NULL DEFAULT '10' COMMENT '订单状态(10进行中 20取消 21待取消 30已完成)',
  `evaluate_status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '就餐评价状态：1未评价2已评价',
  `evaluate_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '就餐评价id',
  `quota` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否是定额扣费：1是0否',
  `quota_price` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '定额扣费金额',
  `paycode` varchar(32) NOT NULL DEFAULT '' COMMENT '支付二维码',
  `card_id` varchar(64) NOT NULL DEFAULT '' COMMENT 'IC卡号',
  `msgid` varchar(64) NOT NULL DEFAULT '' COMMENT '设备端唯一值',
  `order_type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '消费机收款方式：1=在线；2=离线',
  `refund_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '退款金额(现金+补贴)',
  `refund_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '退款状态：0=未退款，1=退款中，2=部分退款，3=全部退款',
  `cash_refund_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '已退款现金',
  `subsidy_refund_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '已退款补贴',
  `remain_balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '剩余余额（现金+补贴）',
  `remain_cash` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '剩余现金',
  `remain_subsidy` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '剩余补贴',
  `management_fee` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '管理费金额',
  `discount_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '优惠金额',
  `marketing_strategy_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '营销策略ID',
  `marketing_strategy_time_range_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '消费策略命中时间段ID',
  `time_range_mode` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '消费策略时间段模式快照',
  `strategy_time_range_text` varchar(64) NOT NULL DEFAULT '' COMMENT '消费策略命中时间段文本快照',
  `actual_strategy_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '实际命中策略类型快照',
  `actual_strategy_value` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '实际命中策略值快照',
  `zhaodai_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '招待人数',
  `peitong_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '陪同人数',
  `take_time_start` varchar(32) NOT NULL DEFAULT '' COMMENT '取餐开始时间',
  `take_time_end` varchar(32) NOT NULL DEFAULT '' COMMENT '取餐结束时间',
  `print_status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '打印状态：0=无需打印1=待打印2=打印中3=已打印',
  `print_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '打印时间',
  `api_account` varchar(64) NOT NULL DEFAULT '' COMMENT 'api账号',
  `third_party_business_type` varchar(32) NOT NULL DEFAULT '' COMMENT '第三方业务类型：shop商城订单/service服务订单/jd京东订单/canteen食堂外卖/offline线下支付',
  `pay_type` tinyint(4) unsigned NOT NULL DEFAULT '10' COMMENT '支付方式：10=线上20=刷卡30=消费码40=刷脸',
  `is_delete` tinyint(3) unsigned 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`),
  UNIQUE KEY `order_no` (`order_no`) BLOCK_SIZE 16384 LOCAL,
  KEY `bind_id` (`bind_id`) BLOCK_SIZE 16384 LOCAL,
  KEY `user_idx` (`user_id`, `meal_date`, `meal_times`) BLOCK_SIZE 16384 LOCAL,
  KEY `user_bind` (`bind_time`, `user_id`) BLOCK_SIZE 16384 LOCAL,
  KEY `last_meal_time` (`last_meal_time`) BLOCK_SIZE 16384 LOCAL,
  KEY `meal_date` (`meal_date`) BLOCK_SIZE 16384 LOCAL,
  KEY `msgid` (`msgid`) BLOCK_SIZE 16384 LOCAL,
  KEY `idx_locker_code` (`locker_code`) BLOCK_SIZE 16384 LOCAL,
  KEY `idx_booking_order` (`is_booking`, `booking_type`, `meal_date`, `meal_times`) BLOCK_SIZE 16384 LOCAL,
  KEY `idx_booking_batch` (`booking_batch_no`) BLOCK_SIZE 16384 LOCAL,
  KEY `idx_booking_verify` (`booking_verify_status`, `meal_date`, `meal_times`) BLOCK_SIZE 16384 LOCAL,
  KEY `idx_booking_qr_token` (`booking_qr_token`) BLOCK_SIZE 16384 LOCAL,
  KEY `idx_expense_owner` (`expense_owner_type`, `expense_owner_id`) BLOCK_SIZE 16384 LOCAL
) ORGANIZATION INDEX AUTO_INCREMENT = 1 AUTO_INCREMENT_MODE = 'ORDER' DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE ENABLE_MACRO_BLOCK_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 COMMENT = '就餐订单表'
+-------------------+
| sample_plate_bind |
+-------------------+
|                 5 |
+-------------------+
+----+-------------------------+--------------------------------------+-------------+---------------------+
| id | plate_code              | staff_uuid                           | bind_status | bind_time           |
+----+-------------------------+--------------------------------------+-------------+---------------------+
|  1 | CSFZX_PLATE_SAMPLE_0001 | 7A631162-0ADB-D068-FA84-7AB5B8CD6E1B |           1 | 2026-06-22 18:17:17 |
|  2 | CSFZX_PLATE_SAMPLE_0002 | 97D956F9-4C03-01B7-29FD-8A7DBA131ABB |           1 | 2026-06-22 18:17:17 |
|  3 | CSFZX_PLATE_SAMPLE_0003 | 8BC0C584-CBA9-DC8E-7C68-DCB416DB17ED |           1 | 2026-06-22 18:17:17 |
|  4 | CSFZX_PLATE_SAMPLE_0004 | FE3CE9FB-B9AE-5338-C897-F35F18BE8A38 |           1 | 2026-06-22 18:17:18 |
|  5 | CSFZX_PLATE_SAMPLE_0005 | D41EE997-E5DC-4F31-988F-1BD13DFEDD3E |           1 | 2026-06-22 18:17:18 |
+----+-------------------------+--------------------------------------+-------------+---------------------+
+---------------------------+
| sample_plate_after_delete |
+---------------------------+
|                         0 |
+---------------------------+