1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
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 '完整机号';