组织结构1.1 ORGS_MEMBER 机构成员列表

--建表脚本--

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 "修改时间",CHA