docusaurus/blog/2026-01-01-xy/2-数据库表.md

title, tags

title	tags
数据库表	develop

查生产用

委托合同

-- 合同信息 
select * from wk_sf_contract where contractcode = 'YW10495945';
select * from wk_sf_contract where ownerphoneno = '19268402308';

-- 履历
select * from WIWJ_CONTRACT_TRACKING where contractid = 10897558 and CONTRACTTYPE = 'SF' order by ACTIONDATE desc;

-- 周期
select * from wk_sf_cycle where contractid = 10040639;
select * from wk_sf_cycle_price where contractid = 10040639;

select * from WK_SF_CYCLE_PRICE_BACKUPS;

-- 共有人
select * from WK_SF_CONTRACT_OWNER where OWNERNAME like '% %';

-- 打印日志
select * from WIWJ_AGREEMENT_PRINT_HISTORY where VERSIONKEY = 'SFXY08133183';
select * from WIWJ_PRINT_HISTORY_SUMMARY where BUSINESSCODE = 'SFXY08133183';

select * from WIWJ_FILEPATH_TEMPSAVE where FILEPATHSIGNATURE = '/program/xydocbase1/bjtest/sfAgreement/20241107/AFWT10555147ZY_1001200010020/signatrue/AFWT10555147ZY_1001200010020_1_20241107164916.pdf';

-- 锁
select * from WIWJ_SEE_SIGN_WAIT_INFO where house_id =  ;
select * from WIWJ_LOCK_INFO where isDel = 1 AND is_control = 1 AND  contract_code = ? order by createtime asc;

-- 新续关系
select * from WIWJ_SF_CONTRACT_XY_NEW_REL where contractid = '10770742';

-- 手机号历史
select * from WIWJ_CONTRACT_PHONE_HIS;

-- 附件
select * from WIWJ_APPENDIX;
select * from WIWJ_APPENDIX_LACK_INFO;
select * from WIWJ_APPENDIX_LOG where CONTRACT_ID = 10448729 and CONTRACT_TYPE = 'SF' order by CREATETIME desc;

-- 签章
select * from WIWJ_SIGN_RULE where CODE in ('030037','9754');

-- 绑定
select * from WIWJ_USER_REL_CONTRACT where CITY_CODE = 'hangzhou' and CONTRACTTYPE = 'SF';
INSERT INTO WIWJ_USER_REL_CONTRACT(ID, USERID, CONTRACTID, ISDEL, CREATETIME, LASTMODIFIEDTIME, CONTRACTTYPE, CITY_CODE)
 VALUES (USER_REL_CONTRACT_SEQ.NEXTVAL, (SELECT ID FROM CUSTOMER_USER WHERE MOBILE = '18835995130'), '10304863', '1', sysdate, sysdate, 'SF', 'hangzhou');

系统

-- 人 角色 管辖
select * from taw_system_user where userid = '527036';
select * from TAW_SYSTEM_USERREFROLE where USERID = '328601'; 

select * from WIWJ_USER_REGION_REL where USER_ID = '527036' and IS_DEL = '1';
select * from WIWJ_USER_REGION_REL urr
left join TAW_SYSTEM_USERREFROLE ur on urr.USER_ID = ur.USERID
where ROLEID = '565' and is_del = '1';

select REGION_NAME,DQ_REGION_CODE from wiwj_management_region where REGION_TYPE = '3';

-- 敏感词
select * from WIWJ_USER_ACCESS_HISTORY where user_id ='8439098' and TARGET_TYPE = 'viewHouseDetail' and trunc(ACCESS_DATE_DAY) = '2026-04-25';


-- 审批流
select userid from VIEW_APVL_USERROLEFLOW  
where DATA_CODE='XW10322406'
order by FLOWID desc;

select v.* FROM  APPROVAL_TOAPPR_VIEW_NEW v
LEFT JOIN ACT_APPROVAL_INS_INFO info ON v.TARGETID = info.TARGETID 
WHERE info.TARGETCODE = 'AFWT10154186ZY';

select apvl.* from WIWJ_APVLFLOW apvl where apvl.APVLFLOW_DEF_ID = '200011001'  and apvl.DATA_ID = '862908' ;--CREATE_TIME 2026-04-27 11:38:11 START_TIME 2026-04-27 11:38:11   END_TIME 2026-04-27 13:24:07
select * from(select * from WIWJ_APVLNODE_RUNNING union all select * from WIWJ_APVLNODE_OVER) war 
where war.apvlflow_id like '% %'; 

select * from(
sf.product_item as productItem,
 )view1 
 where
 view1.flowdefid = '1000600010115'
and  view1.CURRENT_NODE_NAME = '租赁总监审核'
and view1.productItem != 'PRODUCT_000004'


select * from ACT_DETAIL_APPRPROC_DEF where PROCVARIABLEVALUE like '1000600010007%' and DEFENABLE = 'ENABLE';

select * from ACT_DETAIL_APPRPROC_DEF where PROCVARIABLEVALUE like '10006000100070001%';
select * from ACT_DETAIL_APPRPROC_DEF order by id desc;--8091
select SEQ_DETAIL_APPRPROC_DEF.nextval from dual;


-- 中台视图
VIEW_APP_MYGJ_%


-- cbs交互日志
select CITY_CODE,count(0) from SYNC_BUILDINGHOUSE_LOG where INTERFACE_CODE = 'CX01'  and  trunc(UPDATE_TIME) > '2025-01-20' group by CITY_CODE;

select *from WIWJ_SYNC_BUILDINGHOUSE_LOG where CHANNELNAME = 'HR01' and REQUEST like '%%' order by TRANSFERDATETIME desc;

委托协议

select * from wiwj_agreement_info where CONFERNO = 'SFXY08465955';
select * from wiwj_agreement_info where CONTRACTTYPE = 'SF' and contractsid = '10660041' order by CREATETIME;

select * from wiwj_agreement_detail_info where CONFERID = 'SFXY08465955';
 select ph.*,agr.* 
        from wiwj_agreement_info agr
        left join wiwj_agreement_detail_info detail on agr.id = detail.CONFERID
        left join WIWJ_AGREEMENT_PRINT_HISTORY ph on ph.VERSIONKEY = agr.CONFERNO
        where detail.NAME  = 'cycleLetDaysChange' --referenceRentChange
            and detail.VALUE = 'Y'
            and agr.ISPRINT = '1'
            ;

房源

-- 房源
select BUILDINGHOUSEID from wk_jc_house_info where id = 1000263706;
select * from WK_JC_BUILDING_HOUSE where id = 6307038298;
WK_JC_PROJECT

select * from WIWJ_HOUSEINFO_LOG where id in (3744206,3744210,3745103,3746402);
delete from WIWJ_HOUSEINFO_LOG where id in (3744206,3744210,3745103,3746402);

-- 房间
select * from WIWJ_SF_ROOM_PRICE where sfcontractid = '10033448';

select * from WIWJ_SF_ROOM_PERIOD_PRICE where MODIFY_CAUSE is null and ROOM_PRICE like '%.%' order by GMT_CREATE desc;
select * from WIWJ_SF_ROOM_PERIOD_PRICE where MODIFY_CAUSE = 'init' and ROOM_PRICE like '%.%' order by GMT_CREATE desc;--22年1月
select * from WIWJ_SF_ROOM_PERIOD_PRICE where MODIFY_CAUSE = 'agr_change_add' and ROOM_PRICE like '%.%' order by GMT_CREATE desc;--有
select * from WIWJ_SF_ROOM_PERIOD_PRICE where MODIFY_CAUSE = 'add' and ROOM_PRICE like '%.%' order by GMT_CREATE desc;
select * from WIWJ_SF_ROOM_PERIOD_PRICE where MODIFY_CAUSE = 'del' and ROOM_PRICE like '%.%' order by GMT_CREATE desc;


-- 评估单
select * from wk_sf_contract sf
--LEFT JOIN WIWJ_ESTIMATE_PRODUCT_REL epr ON epr.id = sf.product_code
where sf.CountPeople is null and sf.checkstate = '1011702' order by sf.createtime desc;

WIWJ_ESTIMATE_PRODUCT_REL
WIWJ_ESTIMATE
-- 超时但没过期
SELECT * FROM WIWJ_EVALUATE WHERE EVALUATE_CODE = 'PGD01978458';
UPDATE WIWJ_EVALUATE SET GMT_CREATE = TIMESTAMP '2026-06-29 10:02:35' WHERE EVALUATE_CODE = 'PGD01978458';

-- 推荐表
select * from wiwj_owner_recommend where cbs_house_id = '503903621';

承租

-- 待租
select * from WIWJ_HOUSEVR_INFO  order by PHOTO_TIME desc;--where houseid = '1000050664'
select * from WIWJ_VR_REMIND_INFO;

app

-- 用户 认证
select * from CUSTOMER_USER where MOBILE = '19268402308';
select * from WIWJ_USER_AUTHINFO where id in(2242676);

-- 消息
select * from WK_PUSHMESSAGE where userid = '6134510' and trunc(CREATETIME) = trunc(sysdate);

解约

select * from WIWJ_SFJY_APPLICATION where APPLICATION_CODE = 'WTTZSQ0000024048'; 
select TERMINATIONDATE from WK_SF_JY_TERMINATION where TERMINATIONCODE = 'WTJY100168566';

其他

WIWJ_PROPERTY_REPRINT_APPLY 上海-交割单再次打印申请
wiwj_contract_print_history 合同打印履历
WIWJ_FILEPATH_TEMPSAVE 文件路径保存

{/* truncate */}

统计表

物理名	别名	中文名	说明
小区与管辖
WK_JC_PROJECT_INFO	ProjectInfo	小区表
WK_JC_BUILDING_HOUSE	BuildingHouse	小区信息详情表
WK_JC_BUILDING_INFO	BuildingInfo	楼盘库bid对应表
WIWJ_REGION_PROJECT_REL	RegionProjectRel	小区和管辖区域关系表
WIWJ_PROJECT_REGION_SHARE_REL	ProjectRegionShareRel	共享小区与管辖区域关系表
WIWJ_MANAGEMENT_REGION	TawSystemManagementRegion	店组管辖区域(小区对应的责任信息表)
房源
WK_JC_HOUSE_INFO	HouseInfo	房源表
WK_JC_BUSINESS_CIRCLE		小区商圈表
WK_JC_OWNER_LINK_HOUSE	OwnerLinkHouse	业主房屋关联表
WK_JC_OWNER_INFO	OwnerInfo	业主表
WIWJ_PRICE_INFO_UPDATE	priceInfoUpdate	价格调整表
WIWJ_OWNER_PHONE_INFO	OwnerPhoneInfo	业主电话表
WK_JC_OWNER_HOUSE_HISTORY	OwnerLinkHouseHistory	业主履历表
WK_JC_OWNER_HOUSE_HISTORY	OwnerLinkHouseHistory	房源业主履历中间表
WK_JC_HOUSE_INFO_HISTORY	HouseInfoHistory	房源履历表
WIWJ_CONTACT_RESULT	WiwjContactResult	沟通记录表
WIWJ_ORDER_REASON	OrderReason	操作记录 (房源日志)	(1.房源操作记录)
WIWJ_HOUSEINFO_LOG		新版房源日志
评估单
WIWJ_ESTIMATE		评估单产品表	新版评估单弃用
WIWJ_ESTIMATE_ALLOCATION_DATA	EstimateAllocationData	局装,原装基础数据表	新版评估单新表
WIWJ_ESTIMATE_ALLOCATION_REL	EstimateAllocationRel	局装,原装的真实数据	新版评估单新表
WIWJ_ESTIMATE_ROOMS	EstimateRooms	产品房间	新版评估单新表
WIWJ_DECORATION_BASE_DATA	DecorationBaseData	标装(整装)预估装配基础数据	新版评估单新表
WIWJ_ESTIMATE_DECORATION_REL	EstimateDecorationRel	标装(整装)其他装修项目	新版评估单新表
WIWJ_ESTIMATE_DECORATION_DATA	EstimateDecorationData	标装(整装)基础数据	新版评估单新表
评估单产品
WIWJ_ESTIMATE_PRODUCT_REL	EstimateProductRel	评估单产品详情表	新版评估单成为产品单主表
WIWJ_ESTIMATE_DECORATION	EstimateDecoration	评估单产品装配表
WIWJ_ESTIMATE_ROOM_PRICE	EstimateRoomPrice	评估单产品房间价格表
WIWJ_ESTIMATE_PRODUCT_REL_BAK		产品预估详情bak表
WIWJ_ESTIMATE_DECORATION_BAK	EstimateProductRelBak	产品装配bak表	新版评估单也在用
WIWJ_ESTIMATE_AUDIT_LOG	estimateAuditLog	产品审核log表
WIWJ_PRODUCT_ITEM	ProductItem	产品模板表	分组整租模板
合同
WK_SF_CONTRACT	ContractMainInfo	收房合同表	pre是实际结束日
WIWJ_OWNER_GRADING	OwnerGrading	合同业主	只存代理委托和共有人
WK_SF_CONTRACT_OWNER	SFContractOwner	共有人表
WK_SF_HOUSE_CERTIFICATE	SFHouseCertificate	其他房产证表
WK_SF_CYCLE	CycleInfo	合同免租周期表(周期)
WK_SF_CYCLE_PRICE	CyclePriceInfo	合同租金表(价格周期)
WIWJ_HOUSEINFOLINKROOMS_INFO	HouseInfoLinkRooms	房屋关联房间表	相辅相成
WIWJ_SF_ROOM_PRICE	SFContracRoomPrice	房间表
WIWJ_SF_ROOM_PRICE_CHANGE_LOG	SfRoomPriceChangeLog	合同房间履历表
WTBLACKLIST	WTBlackList	委托黑名单表
WIWJ_BLACK_HISTORY		黑名单历史表
WIWJ_CONTRACT_TRACKING	ContractTracking	合同记录追踪表(合同履历表)
WIWJ_DEDUCTION_ORDER	DeductionOrder	扣款单表(维修基金)
WK_PAYMENT_DEDUCT_INFO	paymentDeductInfo	付款计划和扣款单中间表
WK_PAYMENT_ORDER	PaymentOrder	付款计划表
WIWJ_SIGNPIC_RE_SF_CONTRACT		签字图片表
WIWJ_PROPERTY_FILING_APPLY	PropertyFilingApply	产权备案申请表
WIWJ_ATTACHMENT_FILE	AttachmentFile	附件文件表
WIWJ_ATTACHMENT_SETTING		附件模板表	有数量
WIWJ_FILEPATH_TEMPSAVE	FilePathTempSave	合同生成表
WIWJ_LET_RESUME	LetResumeInfo	招租失败履历表
WIWJ_SIGN		签约表	出房签约表
WIWJ_SF_SUPPLE_AGREEMENT	SfSuppleAgreement	补充协议(3个字段 id 合同id 内容)
WIWJ_SF_CONTRACT_BASE_PRICE	ContractBasePrice	什么基准价
TAW_COMMON_LOGOPERATOR	tawCommonLogOperator	合同日志表
WIWJ_PRINT_HISTORY_SUMMARY	PrintHistorySummary	合同打印次数表
WK_JC_TEMPLATE_INFO	TemplateInfo	装修类型模板表
附件
WIWJ_APPENDIX	Appendix	附件表	附件模板
WIWJ_APPENDIX_LACK_INFO	AppendixLackInfo	附件缺件表
WIWJ_APPENDIX_LOG	AppendixLog	附件日志表
WIWJ_IDENTIFY_ACCOUNT_HIS	IdentifyAccountHistory	银行卡什么表..
WIWJ_ATTACHMENT_ADDRESSEE	ContractAttachmentAddressee	附件收件表
WIWJ_XY_INN_HOUSE	HouseInfoFilter	过滤房源	INN,限量,顺义大区,甲醛房
WIWJ_SIGN	Sign	签约表
WK_SF_CONTRACT_CHECK_LINK	ContractCheckLink	合同检查关联表
WIWJ_ANNUAL_REVENUE_CYCLE	AnnualRevenueCycle	分益租周期表
WK_SF_PRICE_FIXING	PriceFixing	房源定价表
WIWJ_USER_ACTION_LOG	UserActionLog	app用户访问日志
WIWJ_USER_REL_CONTRACT	UserRelContract	合同绑定app用户关联表
WIWJ_INN_CYCLE	InnCycle	Inn周期	可能是承租
WIWJ_SK_PLAN	SkPlan	收款单	(不是park PK)向业主收钱
WIWJ_EXPIRATION_REMINDER	ExpirationReminder	到期提醒表
WIWJ_SF_ROOM_PERIOD_PRICE	SfRoomPeriodPrice	合同房间价格履历	房间价格周期
协议
wiwj_agreement_info	AgreementInfo	协议详情表	协议主表(当时为什么写的详情)
wiwj_agreement_detail_info	AgreementDetailInfo	协议表(一条数据拆分成几十条信息)	协议详情表(当时为什么写的主表)
WIWJ_AGREEMENT_TRACKING	AgreementTracking	协议日志
taw_system_dicttype	TawSystemDictType	收房协议模板列表(字典表.....)	字典表.....
WIWJ_CONTRACT_AGREEMENT_FILE	ContractAgreementFile	协议附件表
WIWJ_AGREEMENT_LACK_INFO	AppendixAgreementLackInfo	附件协议关联表(附件缺件表)
WIWJ_AGREEMENT_PRINT_HISTORY	PrintAgreementHistory	协议打印历史	算次数用
WIWJ_PRINT_HISTORY_SUMMARY	PrintHistorySummary	打印历史(本页写第二次)	跟合同用的打印是一个
WK_SF_CYCLE_PRICE_BACKUPS	CyclePriceBackupsInfo	价格周期备份表
WK_SF_XYYX_PRICE_BACKUPS	SigningAmountBackupsInfo	基准租金价格变更留存表
交割单
WIWJ_PROPERTY_SETTLEMENT_INFO	PropertySettlement	交割单表	三种交割单 新,续签,退租
WIWJ_SF_PROPERTY_ITEM	SFPropertyItem	交割单详情列表	数据所在
WIWJ_PROJECT_SKACCOUNT_INFO	ProjectSkaccountInfo	整个小区的物业信息
WIWJ_PROPERTY_PIC	PropertyPic	交割单图片表
WIWJ_PROPERTY_BASEDATA	PropertyBaseData	交割单物品基础数据模板	物品模板
WIWJ_PROPERTY_ITEM_STANDARD	PropertyItemStandard	交割单基础物品规格数据模板	物品规格模板
WIWJ_SF_RENTAUDIT_CASE	SfRentauditCase	交割单错误原因表
wiwj_SF_CHARGE_TYPE	SFPropertyChargeType	收款单位二级联动数据	一二级信息
WIWJ_SF_PROPERTY_ITEM_LOG	SFPropertyItemLog	交割单日志表(物品修改记录表)
WIWJ_SF_PROPERTY_ITEM_HISTORY	SFPropertyItemHistory	交割单历史数据
WIWJ_PROPERTY_PIC_HISTORY	PropertyPicHistory	交割单历史图片
WIWJ_ACCOUNT_NUMBER_INFO	AccountNumberInfo	户号信息表
WK_SF_COST_ONE	CostOne	费用一 表
wiwj_contract_print_history	PrintHistory	物业/合同打印次数表	50交割 51承租 空 合同
WIWJ_SIGNPIC_RE_PROPERTY	SignpicReProperty	承租交割单录入及租客APP确认
WIWJ_PROPERTY_SETTLEMENT_HIS	PropertySettlementHistory	新版交割单履历	(上海市打印历史)
WIWJ_PRINT_HISTORY_SUMMARY	PrintHistorySummary	打印历史(本页写第三次)	跟合同用的打印是一个
WIWJ_PROPERTY_ITEM_APPLY	PropertyItemApply	户号变更申请表
WIWJ_PROPERTY_CHECK_LOG	propertyCheckLog	交割单审核记录
WIWJ_SF_RENTAUDIT_ITEM	SfRentauditItem	收房租务审核字典表
WIWJ_PROPERTY_ITEM_APPLY_LOG	PropertyItemApplyLog	户号变更履历
WIWJ_PROPERTY_MANAGE_ITEM	PropertyManageItem	在管期间操作表(交割单物品审核表)
WIWJ_PROPERTY_MANAGE_PIC	PropertyManagePic	在管期间操作图片表
WIWJ_PROPERTY_REPRINT_APPLY		上海-交割单再次打印申请
退租申请
WIWJ_SFJY_APPLICATION	SfjyApplication	收房退租申请表
WIWJ_ANNUAL_REVENUE_CYCLE	AnnualRevenueCycle	年度收益周期表(分益租周期表)
WIWJ_CFJY_APPLICATION	CfjyApplication	出房退租申请
WIWJ_SF_JYAPPLY_PRINT_HISTORY	SfjyApplyPrintHistory	解约打印历史表
解约协议
WK_SF_JY_TERMINATION	SFJYTermination	解约表	收房解约表
WIWJ_PRINT_HISTORY_SUMMARY	PrintHistorySummary	打印历史(本页写第四次)	跟合同用的打印是一个
WIWJ_SF_TERMINATION_APPLY_REL	TerminationApplyRelSF	解约协议和退租申请关系表
WK_SF_JY_CLEANING_LIST	SFJYCleaningList	收房解约结算单
WK_SF_JY_CLEANING_DETAIL	SFJYCleaningDetail	收房解约结算单明细
WIWJ_ADVANCE_DEDUCTION	AdvanceDeduction	生活费用可扣金额(承租预扣款信息表)
WIWJ_SF_JY_PROPERTY_ITEM	SFJyPropertyItem	解约交割单详情
WIWJ_REFUND_ORDER	RefundOrder	退款订单列表
WK_SF_JY_COST_INFORMATION_ONE	SFJYCostInformationOne	收房解约费用信息
WIWJ_SF_JY_PROPERTY_ITEM_HIS	SFJYPropertyItemHistory	解约交割履历
系统相关
taw_system_priv_menuitem		菜单表
taw_system_priv_operation		菜单中间表
TAW_SYSTEM_USER		用户表	下边常量
wiwj_ehr_user_info		ehr表用户表
TAW_SYSTEM_DICTTYPE		字典表
WIWJ_STATUS_INFO	StatusInfo	状态表
TAW_SYSTEM_AREA		行政区划
TAW_SYSTEM_ROLE	TawSystemRole	角色表
TAW_SYSTEM_USERREFROLE	TawSystemUserRefRole	用户和角色关系表
WIWJ_USER_REGION_REL	UserRegionRel	用户和管辖范围关系表
到期管理
WIWJ_EXPIRATION_REMINDER		到期提醒表
WIWJ_CONTACT_RESULT_DETAIL_SF	ContactResultDetailSf	合同到期沟通记录 收房
交互日志
WIWJ_SYNC_BUILDINGHOUSE_LOG		cbs
WIWJ_SYNC_HOUSE_LOG		crm
APP用户相关
CUSTOMER_USER	CustomerUser	app用户表	建行创建用户(app用户)
WIWJ_USER_AUTHINFO	UserAuthInfo	实名认证表
WIWJ_SHORTMESSAGE		短信表
WK_PUSHMESSAGE_HZ		app消息 通知
WK_PUSHMESSAGE		app消息 通知
ALLUSERS		历史用户
WIWJ_SIGNPIC_RE_SF_CONTRACT	SignpicReSfContract	业主签字图片所在
审批流
WIWJ_APVLFLOW	ApvlFlow	审批流表
WIWJ_APVLFLOW_DEF		审批流基础表
ACT_APPROVAL_INS_INFO	ActApprovalInsInfo	非收房审批流信息表
ACT_APPROVAL_PROCDEF		非收房审批流基础表
ACT_DETAIL_APPRPROC_DEF		非收房子审批流基础表
act_ru_variable		流程变量表
act_ru_task		流程进度表
act_hi_taskinst		流程历史
crm推荐
WIWJ_OWNER_RECOMMEND		业主推荐表
承租
WIWJ_HOUSE_VACANT_INFO		待租表
WIWJ_HOUSING_DISCOUNT_APPLY		杭州-待租优惠信息表
调配
WIWJ_CHANGE_CONTRACT_BATCH	ChangeContractBatch	合同调配
APP中台
WIWJ_CITY_CONFIG		中台接口地址
WIWJ_WT_INFO		北京相寓app业主手动委托
park楼栋关联信息
WK_JC_business_circle		村镇
WK_JC_APARTMENT_INFO		公寓
WK_JC_PROJECT_INFO		楼栋
WK_JC_house_INFO
私盘公盘
WIWJ_DEPOSIT_MESSAGE	Deposit	委托表(私盘)
WIWJ_BLACK_APPLY	BlackApply	委托黑名单限制申请表	新版评估单新表
WIWJ_DEPOSIT_LINK_HOUSEKEEPER	DepositLinkHousekeeper	委托管家表
WIWJ_EVALUATE	Evaluate	评估单
WIWJ_EVALUATE_DETAIL	EvaluateDetail	评估单详细表
WIWJ_EVALUATE_CONFIGURATION	EvaluateConfiguration	评估单详细装配评估表
WIWJ_EVALUATE_IMAGE	EvaluateImage	评估单图片表
WIWJ_EVALUATE_ROOM	EvaluateRoom	评估单面积表
杂
WK_PAYMENT_FROM_SKPLAN	PaymentFromSkplan	收款单和付款计划关联表
WIWJ_SF_DEDUCTIONS_PERFORMANCE		扣业绩
WIWJ_SK_PLAN_OPERATE_HIS	SkPlanOperateHis	收款计划履历
WIWJ_FILEPATH_TEMPSAVE	FilePathTempSave	文件路径保存
WIWJ_JJR_WHITELIST		经纪人白名单
WIWJ_EVALUATE_ITEM		房源整体列表
WIWJ_EVALUATE_SELECT		房源整体详细列表(多选框)(分组加权标准)
WIWJ_CONFIGURATION_SELECT		装配评估表
WIWJ_EVALUATE_DISPATCH	EvaluateDispatch	评估推荐单列表	过时
WIWJ_PRODUCT_CONFIGURE_REGION	ProductConfigureRegion	不可录入评估单的大区表
WIWJ_MKTPRICE_BASEPRICE		小区基准价表	Basepricemid
WIWJ_MKTPRICE_PROJ_MONINDEX			分组和整租都用
WIWJ_MKTPRICE_PROJ_HOUSE_TYPE			整租用
WIWJ_MKTPRICE_HOUSE_AREA		最大最小面积	整租用
WIWJ_JC_BANK_BRANCH_INFO		银行表
WIWJ_WORK_CALENDAR		节假日历
WIWJ_OWNER_FOLLOWUP_RECORD		业主追踪表	应该不用了(用了 换签)
WIWJ_CLEANING_ORDER	WiwjCleaningOrder	空气治理房源
WIWJ_AIRCONTROL_TRACK	AircontrolTrack	无需空气治理房
WIWJ_DECORATION	Decoration	装修单
V_LIST_ORDER_DEPOSIT_WITH_SUB	OrderDepositWithSub	私盘列表	视图
USERS2_TEMP	User2Temp	导表
WIWJ_SEE_SIGN_RESULT	SeeSignResult	实勘表(删图片用)	where houseId = '26725833'
WIWJ_USER_ACCESS_HISTORY	UserAccessHistory	敏感信息
WIWJ_WT_INFO		全国北京库业主app推荐信息
WIWJ_SF_BLACK_APPLY	SFBlackApply	上海黑名单申请
WIWJ_SF_PRODUCT_ITEM		郑州成都不知道啥表
WIWJ_MKTPRICE_BASEPRICE_IMPORT		成都直营评估单新增修改表
WIWJ_MKTPRICE_PZPRICE
WIWJ_HIDE_CALL_INFO			隐号拨打回调记录
CHANGESYSAGENTID		杭州合同更改所属人	存储过程