alter table hls_lease_item add (DIVISION varchar2(100)); comment on column hls_lease_item.DIVISION is '产品线'; alter table hls_lease_item add (machine_model varchar2(100)); comment on column hls_lease_item.machine_model is '机型'; alter table hls_lease_item add (origin_place varchar2(100)); comment on column hls_lease_item.origin_place is '国产/进口'; alter table hls_lease_item add (purchase_price number); comment on column hls_lease_item.purchase_price is '留购价'; alter table hls_lease_item add (equipments varchar2(100)); comment on column hls_lease_item.equipments is '装备'; alter table hls_lease_item add (Accessories varchar2(100)); comment on column hls_lease_item.Accessories is '附属品'; alter table hls_lease_item add (machine_model_class varchar2(100)); comment on column hls_lease_item.machine_model_class is '机型分类'; alter table hls_lease_item add (machine_model varchar2(100)); alter table hls_lease_item add (machine_number varchar2(100)); alter table hls_lease_item add (agency varchar2(100)); alter table hls_lease_item add (contract_number varchar2(100)); alter table hls_lease_item add (contract_name varchar2(2000)); alter table hls_lease_item add (bp_name varchar2(100)); alter table hls_lease_item add (lease_start_date date); alter table hls_lease_item add (working_hours_latest number); alter table hls_lease_item add (working_hours_new_m number); alter table hls_lease_item add (working_hours_ave_m number); alter table hls_lease_item add (machine_location varchar2(2000)); alter table hls_lease_item add (note varchar2(2000)); alter table hls_lease_item add (attention varchar2(2000)); alter table hls_lease_item add (machine_number_full varchar2(2000)); comment on column hls_lease_item.machine_model is '机型'; comment on column hls_lease_item.machine_number is '机号'; comment on column hls_lease_item.agency is '代理店'; comment on column hls_lease_item.contract_number is '合同编号'; comment on column hls_lease_item.contract_name is '合同名称'; comment on column hls_lease_item.bp_name is '客户名称'; comment on column hls_lease_item.lease_start_date is '租赁开始日'; comment on column hls_lease_item.working_hours_latest is '最新工作小时数'; comment on column hls_lease_item.working_hours_new_m is '本月新增工作小时数'; comment on column hls_lease_item.working_hours_ave_m is '本月平均工作小时数'; comment on column hls_lease_item.machine_location is '机器位置'; comment on column hls_lease_item.note is '备注'; comment on column hls_lease_item.attention is '注意'; comment on column hls_lease_item.machine_number_full is '完整机号';