| 12345678910111213141516171819202122232425262728293031323334 |
- 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 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 kwf_truck ADD selected_capacity tinyint NOT NULL default '0' comment '已选运力（0-未选运力，1-已选运力）';
|
