--建表脚本--

create table ORGS_MEMBER(

ORG_ID varchar(10) not null  comment '机构编码'

,USER_ID varchar(10) not null  comment '用户ID'

,MEMBER_NAME varchar(20) default null  comment '姓名'

,ENGLISH_NAME varchar(30) default null  comment '英文名'

,MAIL varchar(50) default null  comment '邮箱'

,MOBILE varchar(20) default null  comment '手机'

,TELEPHONE varchar(20) default null  comment '座机'

,SEX varchar(1) default null  comment '性别'

,NODE_ROLE_DESC varchar(50) default null  comment '组内角色描述'

,MEMO varchar(255) default null  comment '备注'

,COMPANY_NAME varchar(100) default null  comment '公司名'

,HEAD_PICTURE varchar(500) default null  comment '头像'

,EMPLOYEEID varchar(10) default null  comment '员工号'

,CREATE_TM datetime default null  comment '录入时间'

,CREATER varchar(10) default null  comment '录入人'

,CHG_TM datetime default null  comment '修改时间'

,CHANGER varchar(10) default null  comment '修改人'

,WEIXIN_FOCUS_STATUS varchar(1) default null  comment '微信企业号关注状态'

,WEIXIN_FOCUS_STATUS_TIME datetime default null  comment '加入微信关注状态时间'

,primary key (ORG_ID,USER_ID)

) comment = '机构成员列表'

--查询--

select ORG_ID as "orgId",USER_ID as "userId",MEMBER_NAME as "memberName",ENGLISH_NAME as "englishName",MAIL as "mail",MOBILE as "mobile",TELEPHONE as "telephone",SEX as "sex",NODE_ROLE_DESC as "nodeRoleDesc",MEMO as "memo",COMPANY_NAME as "companyName",HEAD_PICTURE as "headPicture",EMPLOYEEID as "employeeid",CREATE_TM as "createTm",CREATER as "creater",CHG_TM as "chgTm",CHANGER as "changer",WEIXIN_FOCUS_STATUS as "weixinFocusStatus",WEIXIN_FOCUS_STATUS_TIME as "weixinFocusStatusTime" from ORGS_MEMBER

--查询(中文字段)--

select ORG_ID as "机构编码",USER_ID as "用户ID",MEMBER_NAME as "姓名",ENGLISH_NAME as "英文名",MAIL as "邮箱",MOBILE as "手机",TELEPHONE as "座机",SEX as "性别",NODE_ROLE_DESC as "组内角色描述",MEMO as "备注",COMPANY_NAME as "公司名",HEAD_PICTURE as "头像",EMPLOYEEID as "员工号",CREATE_TM as "录入时间",CREATER as "录入人",CHG_TM as "修改时间",CHANGER as "修改人",WEIXIN_FOCUS_STATUS as "微信企业号关注状态",WEIXIN_FOCUS_STATUS_TIME as "加入微信关注状态时间" from ORGS_MEMBER

--INSERT脚本--

insert into ORGS_MEMBER(ORG_ID,USER_ID,MEMBER_NAME,ENGLISH_NAME,MAIL,MOBILE,TELEPHONE,SEX,NODE_ROLE_DESC,MEMO,COMPANY_NAME,HEAD_PICTURE,EMPLOYEEID,CREATE_TM,CREATER,CHG_TM,CHANGER,WEIXIN_FOCUS_STATUS,WEIXIN_FOCUS_STATUS_TIME) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

--UPDATE脚本--

update ORGS_MEMBER set ORG_ID=?,USER_ID=?,MEMBER_NAME=?,ENGLISH_NAME=?,MAIL=?,MOBILE=?,TELEPHONE=?,SEX=?,NODE_ROLE_DESC=?,MEMO=?,COMPANY_NAME=?,HEAD_PICTURE=?,EMPLOYEEID=?,CREATE_TM=?,CREATER=?,CHG_TM=?,CHANGER=?,WEIXIN_FOCUS_STATUS=?,WEIXIN_FOCUS_STATUS_TIME=? where ORG_ID=? AND USER_ID=?

--delete脚本--

delete from ORGS_MEMBER where ORG_ID=? AND USER_ID=?

--给字段加备注--

alter table ORGS_MEMBER comment '机构成员列表';

alter table ORGS_MEMBER modify column ORG_ID varchar(10) not null  comment '机构编码';

alter table ORGS_MEMBER modify column USER_ID varchar(10) not null  comment '用户ID';

alter table ORGS_MEMBER modify column MEMBER_NAME varchar(20) default null  comment '姓名';

alter table ORGS_MEMBER modify column ENGLISH_NAME varchar(30) default null  comment '英文名';

alter table ORGS_MEMBER modify column MAIL varchar(50) default null  comment '邮箱';

alter table ORGS_MEMBER modify column MOBILE varchar(20) default null  comment '手机';

alter table ORGS_MEMBER modify column TELEPHONE varchar(20) default null  comment '座机';

alter table ORGS_MEMBER modify column SEX varchar(1) default null  comment '性别';

alter table ORGS_MEMBER modify column NODE_ROLE_DESC varchar(50) default null  comment '组内角色描述';

alter table ORGS_MEMBER modify column MEMO varchar(255) default null  comment '备注';

alter table ORGS_MEMBER modify column COMPANY_NAME varchar(100) default null  comment '公司名';

alter table ORGS_MEMBER modify column HEAD_PICTURE varchar(500) default null  comment '头像';

alter table ORGS_MEMBER modify column EMPLOYEEID varchar(10) default null  comment '员工号';

alter table ORGS_MEMBER modify column CREATE_TM datetime default null  comment '录入时间';

alter table ORGS_MEMBER modify column CREATER varchar(10) default null  comment '录入人';

alter table ORGS_MEMBER modify column CHG_TM datetime default null  comment '修改时间';

alter table ORGS_MEMBER modify column CHANGER varchar(10) default null  comment '修改人';

alter table ORGS_MEMBER modify column WEIXIN_FOCUS_STATUS varchar(1) default null  comment '微信企业号关注状态';

alter table ORGS_MEMBER modify column WEIXIN_FOCUS_STATUS_TIME datetime default null  comment '加入微信关注状态时间';

点赞加关注，回来不迷路。

                                                                                                                     ----枯藤鸭