sckw-service-platform/sql/2025/11/30/2025_11_30_cxf_alert.sql

ALTER TABLE kwc_contract_trade ADD settlement tinyint NOT NULL default 1 comment '结算方式 (1线下结算，线上结算)';
ALTER TABLE kwc_contract_trade ADD consignment tinyint NOT NULL default 0 comment '托运方式 1-采购方托运，2-供应方托运';
ALTER TABLE kwc_contract_trade ADD unload_way tinyint      NOT NULL default 0  comment '1按装货量、2按卸货量';
ALTER TABLE kwc_contract_trade ADD salesman_id tinyint   NOT NULL default 0  comment '销售人员id（对应供应方的员工信息）';
ALTER TABLE kwc_contract_trade ADD salesman_phone varchar(11)   NOT NULL default ''  comment '销售人员电话';

ALTER TABLE kwc_contract_trade ADD sign_time  datetime   NULL  comment '签约时间';

ALTER TABLE kwp_goods ADD price_unit varchar(10)   NOT NULL default ''  comment '价格单位(元，万元)';


ALTER TABLE kws_role ADD ent_id bigint NOT NULL default 0  comment '企业id';

ALTER TABLE kwc_contract_trade_goods ADD start_time date NOT NULL default '1000-01-01'  comment '开始日期';

ALTER TABLE kwc_contract_trade_goods ADD end_time date NOT NULL default '1000-01-01'  comment '结束日期';

# ALTER TABLE kwc_contract_trade_order ADD goods_id  bigint NOT NULL default '0'  comment '商品id';
# ALTER TABLE kwc_contract_trade_order ADD billing_way  bigint NOT NULL default '0'  comment '计费方式';
# ALTER TABLE kwc_contract_trade_order ADD amount decimal(10, 2)  NOT NULL default '0'  comment '下单量';
# ALTER TABLE kwc_contract_trade_order ADD load_amount  decimal(10, 2) NOT NULL default '0'  comment '累计装货量';
# ALTER TABLE kwc_contract_trade_order ADD unload_amount  decimal(10, 2) NOT NULL default '0'  comment '累计卸货量';
# ALTER TABLE kwc_contract_trade_order ADD load_address  varchar(255) NOT NULL default ''  comment '装货地址';
# ALTER TABLE kwc_contract_trade_order ADD unload_address  varchar(255) NOT NULL default ''  comment '卸货地址';

# ALTER TABLE kwc_contract_logistics_goods ADD price decimal(10, 2)  NOT NULL default '0'  comment '运输单价';

ALTER TABLE kwc_contract_logistics ADD common_price decimal(10, 2)  NOT NULL default '0'  comment '通用价格';


ALTER TABLE kwo_trade_order ADD charge_type TINYINT NOT NULL default '0'  comment '计费方式';
ALTER TABLE kwo_trade_order ADD consignment_way TINYINT NOT NULL default '0'  comment '托运方式 1-采购方托运，2-供应方托运';
ALTER TABLE kwo_trade_order_goods ADD goods_name varchar(255)   NOT NULL default ''  comment '商品名称';



ALTER TABLE kwt_waybill_order_ticket ADD uploading_time  datetime NULL comment '上传凭证时间';




# create table kwt_node_trajectory
# (
#     id           bigint        not null comment '主键'
#         primary key,
#     w_order_id   bigint        not null comment '车辆运单id',
#     w_subtask_id bigint        null comment '运单关联子单ID',
#     w_address_id bigint        null comment '车辆运单地址ID',
#     order_status tinyint       null comment '运单状态',
#     truck_id     bigint        null comment '车辆id',
#     truck_no     varchar(11)        null comment '车牌号',
#     driver_id    bigint        null comment '司机id',
#     driver_name    bigint        null comment '司机名称',
#     weighbridge_id  bigint      null comment '地磅id',
#     weighbridge_name  bigint      null comment '地磅名称',
#     create_by    bigint        not null default 0 comment '创建人',
#     create_time  datetime      not null default CURRENT_TIMESTAMP comment '创建时间'
# )
#     comment '车辆运单-节点轨迹';