MOBILE NUMBER, STATE VARCHAR2(2), USERNAME VARCHAR2(30), SERVICE VARCHAR2(30), PAPERTYPE VARCHAR2(30), PAPERID VARCHAR2(30), AREA VARCHAR2(30), CITY VARCHAR2(30), BUSADD VARCHAR2(30), CHANNEL VARCHAR2(30), OPETYPE VARCHAR2(30), MAIN VARCHAR2(30), LAST VARCHAR2(30), SETTIME VARCHAR2(30), ISGROUP VARCHAR2(2), CLIENTDATE VARCHAR2(30), CLIMANID NUMBER, comment on column T_USER.MOBILE is '用户手机号码';comment on column T_USER.STATE is '积分申请标志';comment on column T_USER.USERNAME is '客户姓名';comment on column T_USER.SERVICE is '服务类型';comment on column T_USER.PAPERTYPE is '证件类型';comment on column T_USER.PAPERID is '证件号码';comment on column T_USER.AREA is '地区';comment on column T_USER.CITY is '县市';comment on column T_USER.BUSADD is '营业厅';comment on column T_USER.CHANNEL is '发货渠道';comment on column T_USER.OPETYPE is '业务类型';comment on column T_USER.MAIN is '主套餐';comment on column T_USER.LAST is '上月套餐';comment on column T_USER.SETTIME is '开户时间';comment on column T_USER.ISGROUP is '是否集团客户';comment on column T_USER.CLIENTDATE is '成为大客户日期';comment on column T_USER.CLIMANID is '所属客户经理ID号'; 主要字段
STATE VARCHAR2(2),
USERNAME VARCHAR2(30),
SERVICE VARCHAR2(30),
PAPERTYPE VARCHAR2(30),
PAPERID VARCHAR2(30),
AREA VARCHAR2(30),
CITY VARCHAR2(30),
BUSADD VARCHAR2(30),
CHANNEL VARCHAR2(30),
OPETYPE VARCHAR2(30),
MAIN VARCHAR2(30),
LAST VARCHAR2(30),
SETTIME VARCHAR2(30),
ISGROUP VARCHAR2(2),
CLIENTDATE VARCHAR2(30),
CLIMANID NUMBER,
comment on column T_USER.MOBILE is
'用户手机号码';comment on column T_USER.STATE is
'积分申请标志';comment on column T_USER.USERNAME is
'客户姓名';comment on column T_USER.SERVICE is
'服务类型';comment on column T_USER.PAPERTYPE is
'证件类型';comment on column T_USER.PAPERID is
'证件号码';comment on column T_USER.AREA is
'地区';comment on column T_USER.CITY is
'县市';comment on column T_USER.BUSADD is
'营业厅';comment on column T_USER.CHANNEL is
'发货渠道';comment on column T_USER.OPETYPE is
'业务类型';comment on column T_USER.MAIN is
'主套餐';comment on column T_USER.LAST is
'上月套餐';comment on column T_USER.SETTIME is
'开户时间';comment on column T_USER.ISGROUP is
'是否集团客户';comment on column T_USER.CLIENTDATE is
'成为大客户日期';comment on column T_USER.CLIMANID is
'所属客户经理ID号';
主要字段