ID,NAME,ALIAS,CATALOG,COL_TYPE,DATA_MODE,REQUEST_TYPE,DATA_FROM,DATA_PARAM,DS_ALIAS,DS_NAME,COL_HEIGHT,COL_URL,TEMPLATE_HTML,IS_PUBLIC,ORG_ID,SUPPORT_REFESH,REFESH_TIME,SHOW_EFFECT,MEMO,NEEDPAGE,CATALOG_NAME,CREATOR,CREATE_BY_,CREATE_ORG_ID_,CREATE_TIME_,UPDATE_BY_,UPDATE_TIME_,tenant_id_ DELETE FROM portal_sys_column WHERE ID=#{id} SELECT FROM portal_sys_column WHERE ALIAS=#{alias} SELECT , CASE WHEN ID IN (${hasRightsColIds}) THEN 1 ELSE 0 END as displayRights FROM portal_sys_column WHERE ALIAS in #{alias} SELECT , false as displayRights FROM portal_sys_column WHERE ALIAS in #{alias} SELECT count(id) FROM portal_sys_column SELECT count(*) amount FROM portal_sys_column where alias=#{alias} AND id <> #{id} SELECT FROM portal_sys_column where IS_PUBLIC=#{isPublic} select from portal_sys_column where ID in( select t.id from ( select r.id from portal_sys_column r,portal_sys_auth_user rig where rig.AUTHORIZE_ID_=r.id and rig.RIGHT_TYPE_=#{key} and rig.OBJ_TYPE_=#{objType} and IS_PUBLIC = #{isPublic} and rig.OWNER_ID_ in #{id} select id from portal_sys_column where ORG_ID in #{id} ) t ) and tenant_id_ in #{tid} order by CREATE_TIME_ desc delete from portal_sys_column where id in (select COLUMN_ID_ from portal_news_tree_ where PARENT_ID_ = #{parentId})