FiledRename.txt

--------------------MAIL_SEND

select
c.AUTO_SIGN, c.CAN_DOWNLOAD, c.CMJY_MAIL_S_ID, c.DOC_TYPE, c.EDMS_MAIL_S_ID, c.EFF_DATE, c.EMERGENCY, c.FILE_SYS_ID, c.FILE_TYPE, c.MAIL_TYPE, c.MSG_CONTENT, c.NEED_MSG, c.PARTY_TIME, c.PRINT_NUM, c.REMARK, c.SAFE_LEVEL, c.S_DEPT_ID, c.S_DEPT_NAME, c.S_NUIMBER, c.S_PAGE,
e.ATTACHMENT_COUNT, e.MAIL_RECEIVE_ORIG_ID, e.MAIL_SIZE, e.MAIL_STATUS, e.MAIL_TEXT, e.MAIL_TITLE, e.SEND_TIME, e.USER_ID, e.USER_NAME
from CMJY_MAIL_S c, EDMS_MAIL_S e where c.EDMS_MAIL_S_ID= e.EDMS_MAIL_S_ID

属性名转换：
[
	{
		"fromFieldExpression": "/EDMS_MAIL_S_ID",
		"toFieldExpression": "/ID"
	},
	{
		"fromFieldExpression": "/S_DEPT_ID",
		"toFieldExpression": "/DEPT_ID"
	},
	{
		"fromFieldExpression": "/S_DEPT_NAME",
		"toFieldExpression": "/DEPT_NAME"
	},
	{
		"fromFieldExpression": "/S_NUIMBER",
		"toFieldExpression": "/MAIL_NO"
	},
	{
		"fromFieldExpression": "/S_PAGE",
		"toFieldExpression": "/MAIL_PAGE"
	},
	{
		"fromFieldExpression": "/MAIL_STATUS",
		"toFieldExpression": "/STATUS"
	}
]

类型转换：
按类型：DECIMAL --> STRING
按名称：/PRINT_NUM,/MAIL_PAGE  --> INTEGER, /EFF_DATE --> DATE


--------------------MAIL_RECEIVE

select
c.CMJY_MAIL_R_ID, c.EDMS_MAIL_R_ID, c.EFF_DATE, c.HANDLE_STATE, c.IS_EXTEND_TIME, c.IS_LOCKED, c.IS_LOCKED_PRINT, c.REMARK, c.REPLY_TEXT, c.R_DEPT_ID, c.R_DEPT_NAME,
e.EDMS_MAIL_S_ID, e.IS_READ, e.IS_REPALY, e.RECEIVE_DATE, e.STATUS, e.USER_ID, e.USER_NAME, e.USER_TYPE
from CMJY_MAIL_R c, EDMS_MAIL_R e where c.EDMS_MAIL_R_ID=e.EDMS_MAIL_R_ID

属性名转换：
[
	{
		"fromFieldExpression": "/EDMS_MAIL_R_ID",
		"toFieldExpression": "/ID"
	},
	{
		"fromFieldExpression": "/R_DEPT_ID",
		"toFieldExpression": "/RECEIVE_USER_ID"
	},
	{
		"fromFieldExpression": "/R_DEPT_NAME",
		"toFieldExpression": "/RECEIVE_USER_NAME"
	},
	{
		"fromFieldExpression": "/EDMS_MAIL_S_ID",
		"toFieldExpression": "/MAIL_SEND_ID"
	},
	{
		"fromFieldExpression": "/USER_ID",
		"toFieldExpression": "/DEPT_ID"
	},
	{
		"fromFieldExpression": "/USER_NAME",
		"toFieldExpression": "/DEPT_NAME"
	}
]

类型转换：
按类型：DECIMAL --> STRING


--------------------LOGIN_LOG

select * from PRI_LOGIN_LOG t

属性名转换：
[
	{
		"fromFieldExpression": "/PRI_LOGIN_LOG_ID",
		"toFieldExpression": "/ID"
	},
	{
		"fromFieldExpression": "/LOGIN_DATE",
		"toFieldExpression": "/LOGIN_TIME"
	},
	{
		"fromFieldExpression": "/PRI_USER_ID",
		"toFieldExpression": "/USER_ID"
	},
	{
		"fromFieldExpression": "/USER_IP",
		"toFieldExpression": "/IP"
	}
]

类型转换：无


--------------------ATTACHMENT

select
t.EDMS_DISK_FILE_ID, t.EDMS_FILE_ID, t.EDMS_MAIL_FILE_ID, t.EDMS_MAIL_S_ID, t.FILE_NAME, t.FILE_SIZE, t.FILE_TYPE, t.FILE_VER, t.IS_DIR, t.PARENT_ID, t.SAFE_LEVEL, t.SHOW_DEPT_ID, t.SHOW_TYPE,
f.AUTHOR_ID, f.AUTHOR_NAME, f.CREATE_TIME, f.DEPT_ID, f.DIR_TYPE, f.EDMS_DIR_ID, f.FILE_ORIGINAL_SIZE, f.FILE_PATH, f.FILE_STATUS, f.FILE_TOTAL_SIZE, f.FROM_FILE_ID, f.IS_SJZ, f.LAST_MODIFY_TIME, f.LAST_VER, f.STUDIO_TYPE
from EDMS_MAIL_FILE t, EDMS_FILE f where t.EDMS_FILE_ID=f.EDMS_FILE_ID

属性名转换：
[
	{
		"fromFieldExpression": "/EDMS_MAIL_FILE_ID",
		"toFieldExpression": "/ID"
	},
	{
		"fromFieldExpression": "/EDMS_DISK_FILE_ID",
		"toFieldExpression": "/DISK_FILE_ID"
	},
	{
		"fromFieldExpression": "/EDMS_MAIL_S_ID",
		"toFieldExpression": "/RELEVANCE_ID"
	},
	{
		"fromFieldExpression": "/AUTHOR_ID",
		"toFieldExpression": "/CREATOR_ID"
	},
	{
		"fromFieldExpression": "/AUTHOR_NAME",
		"toFieldExpression": "/CREATOR_NAME"
	},
	{
		"fromFieldExpression": "/DEPT_ID",
		"toFieldExpression": "/CREATE_DEPT_ID"
	}
]

类型转换：
按类型：DECIMAL --> STRING


--------------------DISK_FILE

select t.*, b.ORIGINAL_NAME
from EDMS_DISK_FILE t left join
(select f.EDMS_DISK_FILE_ID, min(f.FILE_NAME) as ORIGINAL_NAME from EDMS_MAIL_FILE f group by f.EDMS_DISK_FILE_ID) b
on t.EDMS_DISK_FILE_ID=b.EDMS_DISK_FILE_ID

属性名转换：
[
	{
		"fromFieldExpression": "/EDMS_DISK_FILE_ID",
		"toFieldExpression": "/ID"
	},
	{
		"fromFieldExpression": "/FILE_PATH",
		"toFieldExpression": "/PATH"
	},
	{
		"fromFieldExpression": "/FILE_TYPE",
		"toFieldExpression": "/EXT"
	}
]

类型转换：无

--------------------LOGS

select * from PRI_COMMON_LOG t

属性名转换：
[
	{
		"fromFieldExpression": "/PRI_COMMON_LOG_ID",
		"toFieldExpression": "/ID"
	},
	{
		"fromFieldExpression": "/ERROR_LOCATION",
		"toFieldExpression": "/ERROR_MSG"
	},
	{
		"fromFieldExpression": "/LOG_CONTENT",
		"toFieldExpression": "/OPERATE_OBJECT"
	},
	{
		"fromFieldExpression": "/LOG_DATE",
		"toFieldExpression": "/CREATE_TIME"
	},
	{
		"fromFieldExpression": "/LOG_DETAIL",
		"toFieldExpression": "/OPERATE"
	},
	{
		"fromFieldExpression": "/LOG_RESULT",
		"toFieldExpression": "/STATUS"
	},
	{
		"fromFieldExpression": "/USER_IP",
		"toFieldExpression": "/IP"
	}
]

类型转换：无


--------------------SELF_DEFINED_GROUP

select * from EDMS_ADDRESS_BOOK t

属性名转换：
[
	{
		"fromFieldExpression": "/EDMS_ADDRESS_BOOK_ID",
		"toFieldExpression": "/ID"
	},
	{
		"fromFieldExpression": "/DESCRIPTION",
		"toFieldExpression": "/DESCRIBTION"
	},
	{
		"fromFieldExpression": "/OWNER_ID",
		"toFieldExpression": "/CREATE_USER_ID"
	}
]

类型转换：无


--------------------SELF_DEFINED_GROUP_USER

select * from EDMS_ADDRESS_BOOK_USER t

属性名转换：
[
	{
		"fromFieldExpression": "/EDMS_ADDRESS_BOOK_USER_ID",
		"toFieldExpression": "/ID"
	},
	{
		"fromFieldExpression": "/EDMS_ADDRESS_BOOK_ID",
		"toFieldExpression": "/GROUP_ID"
	},
	{
		"fromFieldExpression": "/USER_ID",
		"toFieldExpression": "/DEPT_ID"
	},
	{
		"fromFieldExpression": "/USER_NAME",
		"toFieldExpression": "/DEPT_NAME"
	}
]

类型转换：无


--------------------RE_PRINT_APPLY

select t.*, c.CMJY_APPLY_INFO_ID, c.BIZ_ID
from CMJY_APPLY t, CMJY_APPLY_INFO c
where t.CMJY_APPLY_ID=c.CMJY_APPLY_ID
and t.APPLY_TYPE=1

属性名转换：
[
	{
		"fromFieldExpression": "/CMJY_APPLY_INFO_ID",
		"toFieldExpression": "/ID"
	},
	{
		"fromFieldExpression": "/APPLY_DATE",
		"toFieldExpression": "/CREATE_TIME"
	},
	{
		"fromFieldExpression": "/APPLY_REASON",
		"toFieldExpression": "/RE_PRINT_REASON"
	},
	{
		"fromFieldExpression": "/APPROVE_DETAIL",
		"toFieldExpression": "/APPROVED_TEXT"
	},
	{
		"fromFieldExpression": "/APPROVE_RESULT",
		"toFieldExpression": "/STATUS"
	},
	{
		"fromFieldExpression": "/APPROVE_USER_ID",
		"toFieldExpression": "/APPROVED_USER_ID"
	},
	{
		"fromFieldExpression": "/APPROVE_DATE",
		"toFieldExpression": "/APPROVED_DATE"
	},
	{
		"fromFieldExpression": "/MAIL_ID",
		"toFieldExpression": "/MAIL_RECEIVE_ID"
	},
	{
		"fromFieldExpression": "/PRINT_NUM",
		"toFieldExpression": "/RE_PRINT_NUM"
	},
	{
		"fromFieldExpression": "/BIZ_ID",
		"toFieldExpression": "/RE_ATTACHMENT_ID"
	},
	{
		"fromFieldExpression": "/FILE_NAME",
		"toFieldExpression": "/RE_ATTACHMENT_NAME"
	}
]

类型转换：
按类型：DECIMAL --> STRING


--------------------EXPIRE_APPLY

select t.*, c.CMJY_APPLY_INFO_ID, c.BIZ_ID
from CMJY_APPLY t, CMJY_APPLY_INFO c
where t.CMJY_APPLY_ID=c.CMJY_APPLY_ID
and t.APPLY_TYPE=2

属性名转换：
[
	{
		"fromFieldExpression": "/CMJY_APPLY_INFO_ID",
		"toFieldExpression": "/ID"
	},
	{
		"fromFieldExpression": "/BIZ_ID",
		"toFieldExpression": "/MAIL_RECEIVE_ID"
	}
]

类型转换：
按名称：APPROVE_RESULT --> INTEGER