ID_,USER_ID_,REL_ID_,TYPE_ID_,UPDATE_TIME_,IS_DELE_,VERSION_
SELECT a.*,
b.FULLNAME_ as USER_NAME,b.ACCOUNT_ as USER_ACCOUNT,c.NAME_ as REL_NAME,c.PATH_ as REL_PATH
FROM UC_REL_AUTH a
left join UC_USER b on a.USER_ID_ = b.ID_
left join UC_USER_REL c on a.REL_ID_ = c.ID_
WHERE
a.ID_=#{id} AND a.IS_DELE_!='1' AND b.IS_DELE_!='1' AND c.IS_DELE_!='1'
SELECT a.ID_,a.USER_ID_,a.REL_ID_,a.TYPE_ID_,
b.FULLNAME_ as USER_NAME,b.ACCOUNT_ as USER_ACCOUNT,c.NAME_ as REL_NAME,c.PATH_ as REL_PATH
FROM UC_REL_AUTH a
left join UC_USER b on a.USER_ID_ = b.ID_
left join UC_USER_REL c on a.REL_ID_ = c.ID_
${ew.customSqlSegment}
SELECT * FROM UC_REL_AUTH
${ew.customSqlSegment}
DELETE FROM UC_REL_AUTH WHERE IS_DELE_='1'
SELECT a.ID_,a.USER_ID_,a.REL_ID_,a.TYPE_ID_,
b.FULLNAME_ as USER_NAME,b.ACCOUNT_ as USER_ACCOUNT,c.NAME_ as REL_NAME,c.PATH_ as REL_PATH
FROM UC_REL_AUTH a
inner join UC_USER b on a.USER_ID_ = b.ID_
inner join UC_USER_REL c on a.REL_ID_ = c.ID_
WHERE 1= 1 AND a.IS_DELE_!='1' AND b.IS_DELE_!='1' AND c.IS_DELE_!='1'
AND a.USER_ID_ =#{ew.paramNameValuePairs.userId}
AND a.REL_ID_ = #{ew.paramNameValuePairs.relId}
AND b.FULLNAME_ = #{ew.paramNameValuePairs.userName}
AND c.NAME_ = #{ew.paramNameValuePairs.relName}
AND a.TYPE_ID_ = #{ew.paramNameValuePairs.typeId}
ORDER BY ${ew.paramNameValuePairs.orderBySql}
SELECT a.*,b.FULLNAME_ as USER_NAME,b.ACCOUNT_ as USER_ACCOUNT,c.NAME_ as REL_NAME,c.PATH_ as REL_PATH
FROM UC_REL_AUTH a
inner join UC_USER b on a.USER_ID_ = b.ID_
inner join UC_USER_REL c on a.REL_ID_ = c.ID_
where a.REL_ID_ = #{relId} and a.USER_ID_ = #{userId} AND a.IS_DELE_!='1'
UPDATE UC_REL_AUTH SET IS_DELE_='1',UPDATE_TIME_ = #{updateTime,jdbcType=TIMESTAMP}
WHERE
REL_ID_=#{relId}
SELECT a.ID_,a.USER_ID_,a.REL_ID_,a.TYPE_ID_,
b.FULLNAME_ as USER_NAME,b.ACCOUNT_ as USER_ACCOUNT,c.NAME_ as REL_NAME,c.PATH_ as REL_PATH
FROM UC_REL_AUTH a
left join UC_USER b on a.USER_ID_ = b.ID_
left join UC_USER_REL c on a.REL_ID_ = c.ID_
where a.USER_ID_ = #{userId}
AND a.IS_DELE_!='1' AND b.IS_DELE_!='1' AND c.IS_DELE_!='1'
SELECT a.ID_,a.USER_ID_,a.REL_ID_,a.TYPE_ID_,
b.FULLNAME_ as USER_NAME,b.ACCOUNT_ as USER_ACCOUNT,c.NAME_ as REL_NAME,c.PATH_ as REL_PATH
FROM UC_REL_AUTH a
left join UC_USER b on a.USER_ID_ = b.ID_
left join UC_USER_REL c on a.REL_ID_ = c.ID_
WHERE b.ACCOUNT_=#{account} AND a.IS_DELE_!='1'
SELECT a.ID_,a.USER_ID_,a.REL_ID_,a.TYPE_ID_,
b.FULLNAME_ as USER_NAME,b.ACCOUNT_ as USER_ACCOUNT,c.NAME_ as REL_NAME,c.PATH_ as REL_PATH
FROM UC_REL_AUTH a
left join UC_USER b on a.USER_ID_ = b.ID_
left join UC_USER_REL c on a.REL_ID_ = c.ID_
WHERE b.ID_=#{userId} AND a.IS_DELE_!='1'