db_detail.txt 64 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349
  1. a.ID
  2. a.lv
  3. a.pid
  4. aa.productId
  5. account.accountCd // 存管账户账号
  6. account.accountId
  7. account.accountNm
  8. account.accountPayAgreementNo
  9. account.accountPhone
  10. account.amountFronze
  11. account.amountTotal
  12. account.amountVerify
  13. account.authorize
  14. account.autoBidAgreementNo
  15. account.createBy
  16. account.createTime
  17. account.defaultAccount
  18. account.memberId
  19. account.payPwd
  20. account.statusCode
  21. account.statusDesc
  22. account.trxId
  23. account.version
  24. account_client.accountClientId
  25. account_client.createBy
  26. account_client.createTime
  27. account_client.deleted
  28. account_client.fastCode
  29. account_client.fullName
  30. account_client.shorterName
  31. account_client.updateBy
  32. account_client.updateTime
  33. account_client.version
  34. account_detail.accountDetailId
  35. account_detail.accountId
  36. account_detail.balance
  37. account_detail.clientNm
  38. account_detail.clientSNm
  39. account_detail.createBy
  40. account_detail.createTime
  41. account_detail.credit
  42. account_detail.debit
  43. account_detail.deleted
  44. account_detail.no
  45. account_detail.productCd
  46. account_detail.productId
  47. account_detail.productNm
  48. account_detail.pzh
  49. account_detail.summary
  50. account_detail.updateBy
  51. account_detail.updateTime
  52. account_detail.version
  53. account_recharge.accountId
  54. account_recharge.accountStatementNo
  55. account_recharge.addip
  56. account_recharge.amount
  57. account_recharge.bankCardId
  58. account_recharge.collected
  59. account_recharge.createBy
  60. account_recharge.createTime
  61. account_recharge.fee
  62. account_recharge.memberId
  63. account_recharge.orderCd
  64. account_recharge.platCardno
  65. account_recharge.rechargeId
  66. account_recharge.remark
  67. account_recharge.resultCode
  68. account_recharge.status
  69. account_recharge.transferKind
  70. account_recharge.type
  71. account_recharge.userCardno
  72. account_recharge.verifyManager
  73. account_recharge.verifyReason
  74. account_recharge.verifyRemark
  75. account_recharge.verifyResult
  76. account_recharge.verifyTime
  77. account_recharge.version
  78. account_subject.accountCd
  79. account_subject.accountId
  80. account_subject.accountNm
  81. account_subject.accountPid
  82. account_subject.balance
  83. account_subject.beginBalance
  84. account_subject.createBy
  85. account_subject.createTime
  86. account_subject.creditAmount
  87. account_subject.debitAmount
  88. account_subject.deleted
  89. account_subject.fastCode
  90. account_subject.flag
  91. account_subject.hasChild
  92. account_subject.level
  93. account_subject.updateBy
  94. account_subject.updateTime
  95. account_subject.version
  96. account_subject_over_dtl.accountCd
  97. account_subject_over_dtl.accountId
  98. account_subject_over_dtl.accountNm
  99. account_subject_over_dtl.accountSubjectOverDtlId
  100. account_subject_over_dtl.accountSubjectOverMstId
  101. account_subject_over_dtl.balance
  102. account_subject_over_dtl.beginBalance
  103. account_subject_over_dtl.createBy
  104. account_subject_over_dtl.createTime
  105. account_subject_over_dtl.creditAmount
  106. account_subject_over_dtl.debitAmount
  107. account_subject_over_dtl.deleted
  108. account_subject_over_dtl.flag
  109. account_subject_over_dtl.updateBy
  110. account_subject_over_dtl.updateTime
  111. account_subject_over_dtl.version
  112. account_subject_over_mst.accountSubjectOverMstId
  113. account_subject_over_mst.createBy
  114. account_subject_over_mst.createTime
  115. account_subject_over_mst.curMonth
  116. account_subject_over_mst.curYear
  117. account_subject_over_mst.deleted
  118. account_subject_over_mst.updateBy
  119. account_subject_over_mst.updateTime
  120. account_subject_over_mst.version
  121. account_summary.accountSummaryId
  122. account_summary.createBy
  123. account_summary.createTime
  124. account_summary.deleted
  125. account_summary.fastCode
  126. account_summary.summary
  127. account_summary.updateBy
  128. account_summary.updateTime
  129. account_summary.version
  130. account_sys_voucher_dtl.accountId
  131. account_sys_voucher_dtl.accountSysVoucherDtlId
  132. account_sys_voucher_dtl.accountSysVoucherMstId
  133. account_sys_voucher_dtl.createBy
  134. account_sys_voucher_dtl.createTime
  135. account_sys_voucher_dtl.deleted
  136. account_sys_voucher_dtl.flag
  137. account_sys_voucher_dtl.no
  138. account_sys_voucher_dtl.summary
  139. account_sys_voucher_dtl.updateBy
  140. account_sys_voucher_dtl.updateTime
  141. account_sys_voucher_dtl.version
  142. account_sys_voucher_mst.accountSysVoucherMstId
  143. account_sys_voucher_mst.createBy
  144. account_sys_voucher_mst.createTime
  145. account_sys_voucher_mst.deleted
  146. account_sys_voucher_mst.description
  147. account_sys_voucher_mst.node
  148. account_sys_voucher_mst.title
  149. account_sys_voucher_mst.updateBy
  150. account_sys_voucher_mst.updateTime
  151. account_sys_voucher_mst.version
  152. addr_idcard.addridcardCd
  153. addr_idcard.addridcardId
  154. addr_idcard.addridcardNm
  155. addr_idcard.createBy
  156. addr_idcard.createTime
  157. addr_idcard.deleted
  158. addr_idcard.provinceCd
  159. addr_idcard.provinceNm
  160. addr_idcard.updateBy
  161. addr_idcard.updateTime
  162. addr_idcard.version
  163. agreement.__title__ 合同表
  164. agreement.agreementCd
  165. agreement.agreementId
  166. agreement.agreementKind
  167. agreement.agreementUrl
  168. agreement.createBy
  169. agreement.createTime
  170. agreement.orderId
  171. agreement.productCreditId
  172. agreement.productId
  173. agreement.seqNumber
  174. agreement.signed
  175. agreement.status
  176. agreement.version
  177. asset.__title__ 资产表; 是否使用:product != null,表中无体现
  178. asset.acceptedCompany 承兑机构
  179. asset.acceptedNo
  180. asset.assetCd 资产编号
  181. asset.assetType
  182. asset.attachmentDirId
  183. asset.bankBranchNo 开户行银联号 开户行号
  184. asset.borrowAmt 约定借款金额(元)
  185. asset.borrowCompany
  186. asset.borrowerCardName 收款人 持卡人姓名
  187. asset.borrowerCardNumber 收款人 持卡人卡号
  188. asset.borrowerCd 借款人代码,锚定值,ref member.memberCd
  189. asset.borrowerName 借款人姓名
  190. asset.borrowerPhone 借款人证照号
  191. asset.businessType // 1=票据类,2=p2p
  192. asset.createBy
  193. asset.createTime
  194. asset.groundTime 申请上线时间
  195. asset.id
  196. asset.idCard 营业执照号
  197. asset.invalidBid 是否废标(废标 not null)
  198. asset.isCurrentBankFlag 是否本行: 0本行 1他行,注意,与member.bankcardType 相反
  199. asset.isPersonFlag (收款人)是否个人: 0个人,1企业
  200. asset.memberKind (借款人)客户类型 0 个人 1企业
  201. asset.outTicketPerson
  202. asset.phoneOrCompanyCd
  203. asset.productBusinessTypeId
  204. asset.productBusinessTypeNm
  205. asset.productContent
  206. asset.productNm
  207. asset.productTypeName 资产类别
  208. asset.productTypeRuleId
  209. asset.properties
  210. asset.receivablesPerson
  211. asset.receiverCd 收款人代码,锚定值,ref member.memberCd
  212. asset.registerNameOrCompanyNm 借款发起用户 注册人名称/企业名称
  213. asset.registerPhoneOrCompanyCd 借款发起用户手机 注册人手机号/组织机构代码
  214. asset.safeguardWay 保障方式
  215. asset.spv
  216. asset.spvCd 锚定值,ref member.memberCd
  217. asset.tenderEnd 投标结束时间
  218. asset.tenderStart 投标开始时间
  219. asset.ticketAmt 票面金额/约定还款金额 还款总额
  220. asset.ticketCode 票号
  221. asset.ticketDueDate 票据到期日/项目结息日
  222. asset.ticketIssueDate 票据签发日/项目发起日
  223. asset.version
  224. asset_attachment.assetId
  225. asset_attachment.attachmentId
  226. attachment.attachmentExt
  227. attachment.attachmentGroup
  228. attachment.attachmentHash
  229. attachment.attachmentId
  230. attachment.attachmentNm
  231. attachment.attachmentPath
  232. attachment.attachmentSize
  233. attachment.attachmentTitle
  234. attachment.createBy
  235. attachment.createTime
  236. attachment.isTemp
  237. attachment.uploadip
  238. attachment.version
  239. autobidset.amount
  240. autobidset.autoBidSetId
  241. autobidset.createBy
  242. autobidset.createTime
  243. autobidset.flag
  244. autobidset.freqFlag
  245. autobidset.memberId
  246. autobidset.orderNo
  247. autobidset.periodRangFrom
  248. autobidset.periodRangTo
  249. autobidset.productTypeRang
  250. autobidset.rateRangFrom
  251. autobidset.rateRangTo
  252. autobidset.singleBidRangFrom
  253. autobidset.singleBidRangTo
  254. autobidset.version
  255. autobidsetlog.autoBidSetId
  256. autobidsetlog.autoBidSetLogId
  257. autobidsetlog.createBy
  258. autobidsetlog.createTime
  259. autobidsetlog.flag
  260. autobidsetlog.freqFlag
  261. autobidsetlog.memberId
  262. autobidsetlog.operationSrc
  263. autobidsetlog.orderNo
  264. autobidsetlog.periodRangFrom
  265. autobidsetlog.periodRangTo
  266. autobidsetlog.productTypeRang
  267. autobidsetlog.rateRangFrom
  268. autobidsetlog.rateRangTo
  269. autobidsetlog.resultStr
  270. autobidsetlog.singleBidRangFrom
  271. autobidsetlog.singleBidRangTo
  272. autobidsetlog.vCode
  273. autobidsetlog.version
  274. bank.bankCd
  275. bank.bankId
  276. bank.bankNm
  277. bank.createBy
  278. bank.createTime
  279. bank.isValid
  280. bank.logoUrl
  281. bank.version
  282. bank.withdraw
  283. bankbase.bankNm
  284. bankbase.bankNo
  285. bankbase.createBy
  286. bankbase.createTime
  287. bankbase.deleted
  288. bankbase.status
  289. bankbase.updateBy
  290. bankbase.updateTime
  291. bankbase.version
  292. bankbranchcity.branchCityNm
  293. bankbranchcity.branchCityNo
  294. bankbranchcity.branchLevel
  295. bankbranchcity.cityNo
  296. bankbranchcity.createBy
  297. bankbranchcity.createTime
  298. bankbranchcity.deleted
  299. bankbranchcity.updateBy
  300. bankbranchcity.updateTime
  301. bankbranchcity.version
  302. bankbranchinfo.bankNo
  303. bankbranchinfo.bankType
  304. bankbranchinfo.branchCityNo
  305. bankbranchinfo.branchNm
  306. bankbranchinfo.branchNo
  307. bankbranchinfo.createBy
  308. bankbranchinfo.createTime
  309. bankbranchinfo.deleted
  310. bankbranchinfo.status
  311. bankbranchinfo.updateBy
  312. bankbranchinfo.updateTime
  313. bankbranchinfo.version
  314. bankcard.area
  315. bankcard.areaCd
  316. bankcard.areaNm
  317. bankcard.bankAddress
  318. bankcard.bankBranch
  319. bankcard.bankCardId
  320. bankcard.bankCardType
  321. bankcard.bankCd
  322. bankcard.bankNo
  323. bankcard.bankTelephone
  324. bankcard.bankType
  325. bankcard.city
  326. bankcard.cityCd
  327. bankcard.cityNm
  328. bankcard.createBy
  329. bankcard.createTime
  330. bankcard.defaultCard
  331. bankcard.deleted
  332. bankcard.eAccountNo
  333. bankcard.idCard
  334. bankcard.memberId
  335. bankcard.operationSrc
  336. bankcard.protocolNo
  337. bankcard.province
  338. bankcard.provinceCd
  339. bankcard.provinceNm
  340. bankcard.status
  341. bankcard.statusCode
  342. bankcard.statusDesc
  343. bankcard.trxId
  344. bankcard.updateBy
  345. bankcard.updateTime
  346. bankcard.version
  347. bankcity.cityNm
  348. bankcity.cityNo
  349. bankcity.createBy
  350. bankcity.createTime
  351. bankcity.deleted
  352. bankcity.provinceNo
  353. bankcity.updateBy
  354. bankcity.updateTime
  355. bankcity.version
  356. bankinvesttransfer.accountCd
  357. bankinvesttransfer.accountId
  358. bankinvesttransfer.amount
  359. bankinvesttransfer.bankCardId
  360. bankinvesttransfer.bankCardNo
  361. bankinvesttransfer.bankInvestTransferId
  362. bankinvesttransfer.createBy
  363. bankinvesttransfer.createTime
  364. bankinvesttransfer.orderId
  365. bankinvesttransfer.status
  366. bankinvesttransfer.transferKind
  367. bankinvesttransfer.verifyDate
  368. bankinvesttransfer.verifyMemberId
  369. bankinvesttransfer.verifyMemberNm
  370. bankinvesttransfer.verifyReason
  371. bankinvesttransfer.version
  372. bankprovince.createBy
  373. bankprovince.createTime
  374. bankprovince.deleted
  375. bankprovince.provinceNm
  376. bankprovince.provinceNo
  377. bankprovince.status
  378. bankprovince.updateBy
  379. bankprovince.updateTime
  380. bankprovince.version
  381. bankquota.bankNm
  382. bankquota.bankQuotaId
  383. bankquota.createBy
  384. bankquota.createTime
  385. bankquota.deleted
  386. bankquota.onedayCumulativeLimit
  387. bankquota.singleTransferLimit
  388. bankquota.status
  389. bankquota.updateBy
  390. bankquota.updateTime
  391. bankquota.version
  392. borrower_card.__title__ 借款人银行卡,每创建一个项目,生成一条记录
  393. bindcardmodifylog.bankNoNew
  394. bindcardmodifylog.bankNoOld
  395. bindcardmodifylog.bindCardModifyLogId
  396. bindcardmodifylog.createBy
  397. bindcardmodifylog.createTime
  398. bindcardmodifylog.memberId
  399. bindcardmodifylog.memberKind
  400. bindcardmodifylog.phone
  401. bindcardmodifylog.realCd
  402. bindcardmodifylog.realNm
  403. bindcardmodifylog.resultStr
  404. bindcardmodifylog.status
  405. bindcardmodifylog.version
  406. borrower_card.bankBranchNo
  407. borrower_card.borrowerCardId
  408. borrower_card.borrowerCardName
  409. borrower_card.borrowerCardNumber
  410. borrower_card.borrowerType
  411. borrower_card.createBy
  412. borrower_card.createTime
  413. borrower_card.idCard
  414. borrower_card.idType
  415. borrower_card.idTypeNm
  416. borrower_card.isCurrentBankFlag
  417. borrower_card.isPersonFlag
  418. borrower_card.productId
  419. borrower_card.version
  420. borroweradditionalinfo.borrowerAdditionalInfoId
  421. borroweradditionalinfo.borrowerNm
  422. borroweradditionalinfo.borrowingTimes
  423. borroweradditionalinfo.cityNm
  424. borroweradditionalinfo.createBy
  425. borroweradditionalinfo.createTime
  426. borroweradditionalinfo.creditInfo
  427. borroweradditionalinfo.gender
  428. borroweradditionalinfo.income
  429. borroweradditionalinfo.industry
  430. borroweradditionalinfo.industryNm
  431. borroweradditionalinfo.liabilities
  432. borroweradditionalinfo.maritalStatus
  433. borroweradditionalinfo.productId
  434. borroweradditionalinfo.realEstateInfo
  435. borroweradditionalinfo.version
  436. borroweradditionalinfo.yearIncome
  437. broker.brokerKind
  438. broker.brokerLevel
  439. broker.commStatus
  440. broker.commlevel
  441. broker.createBy
  442. broker.createTime
  443. broker.deleted
  444. broker.effTime
  445. broker.expTime
  446. broker.memberId
  447. broker.memberId1
  448. broker.memberId2
  449. broker.realCd1
  450. broker.realCd2
  451. broker.realNm1
  452. broker.realNm2
  453. broker.state
  454. broker.stateReason
  455. broker.stateTime
  456. broker.status
  457. broker.updateBy
  458. broker.updateTime
  459. broker.upgradeState
  460. broker.version
  461. broker_status_log.brokerId
  462. broker_status_log.createBy
  463. broker_status_log.createTime
  464. broker_status_log.endTime
  465. broker_status_log.id
  466. broker_status_log.operationType
  467. broker_status_log.remark
  468. broker_status_log.startTime
  469. broker_status_log.status
  470. broker_status_log.statusType
  471. broker_status_log.userCd
  472. broker_status_log.version
  473. brokerageapplyrecord.actualAmount
  474. brokerageapplyrecord.amount
  475. brokerageapplyrecord.applyDate
  476. brokerageapplyrecord.auditRemark
  477. brokerageapplyrecord.bankCard
  478. brokerageapplyrecord.bankNm
  479. brokerageapplyrecord.cashCode
  480. brokerageapplyrecord.cashId
  481. brokerageapplyrecord.confirmDate
  482. brokerageapplyrecord.confirmUser
  483. brokerageapplyrecord.createBy
  484. brokerageapplyrecord.createTime
  485. brokerageapplyrecord.financialConfirmDate
  486. brokerageapplyrecord.financialConfirmor
  487. brokerageapplyrecord.memberId
  488. brokerageapplyrecord.orderId
  489. brokerageapplyrecord.phone
  490. brokerageapplyrecord.promotionId
  491. brokerageapplyrecord.quantity
  492. brokerageapplyrecord.realCd
  493. brokerageapplyrecord.realNm
  494. brokerageapplyrecord.remark
  495. brokerageapplyrecord.status
  496. brokerageapplyrecord.taxAmount
  497. brokerageapplyrecord.version
  498. brokeragerecord.amount
  499. brokeragerecord.cashCode
  500. brokeragerecord.cashId
  501. brokeragerecord.createBy
  502. brokeragerecord.createTime
  503. brokeragerecord.investAmount
  504. brokeragerecord.investDate
  505. brokeragerecord.investorMemberId
  506. brokeragerecord.investorPhone
  507. brokeragerecord.investorRealCd
  508. brokeragerecord.itemCode
  509. brokeragerecord.itemName
  510. brokeragerecord.memberId
  511. brokeragerecord.orderId
  512. brokeragerecord.phone
  513. brokeragerecord.productId
  514. brokeragerecord.rate
  515. brokeragerecord.realCd
  516. brokeragerecord.realNm
  517. brokeragerecord.recordId
  518. brokeragerecord.status
  519. brokeragerecord.version
  520. calendardata.calendarId
  521. calendardata.calendarType
  522. calendardata.createBy
  523. calendardata.createTime
  524. calendardata.endTime
  525. calendardata.holidayName
  526. calendardata.isAllDay
  527. calendardata.isHoliday
  528. calendardata.startTime
  529. calendardata.version
  530. category.categoryCd 用于查询某个属性的key,可能对应多个值
  531. category.categoryDesc
  532. category.categoryId
  533. category.categoryNm
  534. category.configed
  535. category.createBy
  536. category.createTime
  537. category.edited
  538. category.effTime
  539. category.expTime
  540. category.listSort
  541. category.remark
  542. category.state
  543. category.stateTime
  544. category.version
  545. categoryattr.actualval
  546. categoryattr.attrCd
  547. categoryattr.attrId
  548. categoryattr.attrNm
  549. categoryattr.attrRequired
  550. categoryattr.categoryId
  551. categoryattr.createBy
  552. categoryattr.createTime
  553. categoryattr.defaultVal
  554. categoryattr.effTime
  555. categoryattr.expTime
  556. categoryattr.listSort
  557. categoryattr.remark
  558. categoryattr.state
  559. categoryattr.stateTime
  560. categoryattr.version
  561. claimdetail.amount
  562. claimdetail.claimDate
  563. claimdetail.claimDetailId
  564. claimdetail.claimMan
  565. claimdetail.createBy
  566. claimdetail.createTime
  567. claimdetail.productId
  568. claimdetail.reClaimMan
  569. claimdetail.reClaimtime
  570. claimdetail.recoveryStatus
  571. claimdetail.status
  572. claimdetail.version
  573. claimitem.claimDetailId
  574. claimitem.claimItemId
  575. claimitem.createBy
  576. claimitem.createTime
  577. claimitem.factItemAmount
  578. claimitem.itemAmount
  579. claimitem.itemTypeCd
  580. claimitem.itemTypeNm
  581. claimitem.recoveryStatus
  582. claimitem.version
  583. cms_article.activityType
  584. cms_article.article_content
  585. cms_article.article_id
  586. cms_article.article_keyword
  587. cms_article.article_outline
  588. cms_article.article_subtitle
  589. cms_article.article_title
  590. cms_article.channel_code
  591. cms_article.channel_id
  592. cms_article.createBy
  593. cms_article.createTime
  594. cms_article.deleted
  595. cms_article.link_url
  596. cms_article.listSort
  597. cms_article.recomment
  598. cms_article.status
  599. cms_article.updateBy
  600. cms_article.updateTime
  601. cms_article.version
  602. cms_article_attachment.articleId
  603. cms_article_attachment.attachmentId
  604. cms_channel._title_ 资讯频道 每个频道可以有篇文章
  605. cms_channel.channel_code
  606. cms_channel.channel_id
  607. cms_channel.channel_name
  608. cms_channel.channel_param1
  609. cms_channel.channel_param2
  610. cms_channel.channel_param3
  611. cms_channel.channel_remark
  612. cms_channel.createBy
  613. cms_channel.createTime
  614. cms_channel.deleted
  615. cms_channel.editable
  616. cms_channel.parent_id 通过channel_id - parent_id建立tree:@ManyToOne @JoinColumn(name = "parent_id")
  617. cms_channel.updateBy
  618. cms_channel.updateTime
  619. cms_channel.version
  620. cms_fragment.channel_code
  621. cms_fragment.channel_id
  622. cms_fragment.createBy
  623. cms_fragment.createTime
  624. cms_fragment.deleted
  625. cms_fragment.fragment_content
  626. cms_fragment.fragment_id
  627. cms_fragment.fragment_title
  628. cms_fragment.path
  629. cms_fragment.status
  630. cms_fragment.updateBy
  631. cms_fragment.updateTime
  632. cms_fragment.version
  633. cms_link.channel_code
  634. cms_link.channel_id
  635. cms_link.createBy
  636. cms_link.createTime
  637. cms_link.link_id
  638. cms_link.link_title
  639. cms_link.link_url
  640. cms_link.listSort
  641. cms_link.status
  642. cms_link.updateBy
  643. cms_link.updateTime
  644. cms_link.version
  645. cms_link_attachment.attachmentId
  646. cms_link_attachment.linkId
  647. cms_operational_detail.cmsChannelId
  648. cms_operational_detail.cmsOperationalDetailId
  649. cms_operational_detail.cmsReportId
  650. cms_operational_detail.contentFileId
  651. cms_operational_detail.coverImageId
  652. cms_operational_detail.createBy
  653. cms_operational_detail.createTime
  654. cms_operational_detail.deleted
  655. cms_operational_detail.listSort
  656. cms_operational_detail.status
  657. cms_operational_detail.title
  658. cms_operational_detail.updateBy
  659. cms_operational_detail.updateTime
  660. cms_operational_detail.version
  661. cms_slide.channel_code
  662. cms_slide.channel_id
  663. cms_slide.createBy
  664. cms_slide.createTime
  665. cms_slide.effTime
  666. cms_slide.expTime
  667. cms_slide.listSort
  668. cms_slide.position
  669. cms_slide.slide_id
  670. cms_slide.slide_title
  671. cms_slide.slide_url
  672. cms_slide.slide_written
  673. cms_slide.status
  674. cms_slide.updateBy
  675. cms_slide.updateTime
  676. cms_slide.version
  677. cms_slide_attachment.attachmentId
  678. cms_slide_attachment.slideId
  679. comm_config.amountVerify
  680. comm_config.brokerKind
  681. comm_config.commConfigId
  682. comm_config.commMonth
  683. comm_config.commNm
  684. comm_config.commRate
  685. comm_config.commlevel
  686. comm_config.createBy
  687. comm_config.createTime
  688. comm_config.gradeLimit
  689. comm_config.investingAmt
  690. comm_config.rate21
  691. comm_config.rate22
  692. comm_config.rate31
  693. comm_config.rate32
  694. comm_config.rate33
  695. comm_config.remark
  696. comm_config.version
  697. company.account 企业账号(银行卡号)
  698. company.bankBranchNo 开户行联行号
  699. company.companyAddress
  700. company.companyCd 组织机构代码
  701. company.companyComplaint
  702. company.companyCredit
  703. company.companyDesc
  704. company.companyFinance
  705. company.companyLicence 营业执照号
  706. company.companyNm
  707. company.companyOperate
  708. company.companyRange
  709. company.createBy
  710. company.createTime
  711. company.foundTime
  712. company.isCurrentBankFlag 0 浙商 1他行
  713. company.legalPerson
  714. company.legalPersonIDCard
  715. company.memberId ref member,1 v 1
  716. company.phone 没有使用??
  717. company.registedFund
  718. company.status 审核状态:0,申请.1、确认.2.失败
  719. company.taxNo 税务登记号
  720. company.upateTime
  721. company.updateBy
  722. company.version
  723. company_attachment.attachmentId
  724. company_attachment.memberId
  725. companycontact.contactDesc
  726. companycontact.contactDuty
  727. companycontact.contactFax
  728. companycontact.contactId
  729. companycontact.contactKind
  730. companycontact.contactNm
  731. companycontact.contactPhone
  732. companycontact.createBy
  733. companycontact.createTime
  734. companycontact.email
  735. companycontact.memberId
  736. companycontact.officePhone
  737. companycontact.version
  738. compensation.amount
  739. compensation.claimAmount
  740. compensation.createBy
  741. compensation.createTime
  742. compensation.memberId
  743. compensation.productId
  744. compensation.repayId
  745. compensation.status
  746. compensation.version
  747. contract_template.createBy
  748. contract_template.createTime
  749. contract_template.fileName
  750. contract_template.id
  751. contract_template.isDefault
  752. contract_template.remark
  753. contract_template.status
  754. contract_template.templateCode
  755. contract_template.templateNm
  756. contract_template.templateTypeCode
  757. contract_template.version
  758. contract_template_producttyperule.contractTemplateId
  759. contract_template_producttyperule.productTypeRuleId
  760. contractsignrecord.agreementId
  761. contractsignrecord.borrowerSignServiceId
  762. contractsignrecord.borrowerStatus
  763. contractsignrecord.createBy
  764. contractsignrecord.createTime
  765. contractsignrecord.investorSignServiceId
  766. contractsignrecord.investorStatus
  767. contractsignrecord.memberId
  768. contractsignrecord.platformSignServiceId
  769. contractsignrecord.platformStatus
  770. contractsignrecord.recId
  771. contractsignrecord.retry
  772. contractsignrecord.sceneEvid
  773. contractsignrecord.sceneUrl
  774. contractsignrecord.scened
  775. contractsignrecord.sourceFile
  776. contractsignrecord.status
  777. contractsignrecord.version
  778. coupon.applyDate
  779. coupon.couponAmount
  780. coupon.couponCd
  781. coupon.couponId
  782. coupon.couponNm
  783. coupon.couponRuleId
  784. coupon.couponSrc
  785. coupon.couponSrcDetailDesc
  786. coupon.couponSrcObjId
  787. coupon.couponType
  788. coupon.createBy
  789. coupon.createTime
  790. coupon.deleted
  791. coupon.expirationDate
  792. coupon.limitAmount
  793. coupon.limitDays
  794. coupon.memberId
  795. coupon.orderId
  796. coupon.remark
  797. coupon.ruleId
  798. coupon.sendDate
  799. coupon.status
  800. coupon.updateBy
  801. coupon.updateTime
  802. coupon.useDate
  803. coupon.version
  804. coupon_rule.couponAmount
  805. coupon_rule.couponAmtOrRate
  806. coupon_rule.couponNm
  807. coupon_rule.couponNum
  808. coupon_rule.couponType
  809. coupon_rule.createBy
  810. coupon_rule.createTime
  811. coupon_rule.deleted
  812. coupon_rule.isNeedAudit
  813. coupon_rule.isPemanent
  814. coupon_rule.limitAmount
  815. coupon_rule.limitDate
  816. coupon_rule.limitDays
  817. coupon_rule.maxDiscountAmt
  818. coupon_rule.maxLimitInvestAmt
  819. coupon_rule.minLimitInvestAmt
  820. coupon_rule.ruleCd
  821. coupon_rule.ruleId
  822. coupon_rule.sendQuantity
  823. coupon_rule.status
  824. coupon_rule.totalQuantity
  825. coupon_rule.updateBy
  826. coupon_rule.updateTime
  827. coupon_rule.useLimitAmt
  828. coupon_rule.usedQuantity
  829. coupon_rule.version
  830. coupon_send_setting.couponRuleId
  831. coupon_send_setting.couponSendSettingId
  832. coupon_send_setting.createBy
  833. coupon_send_setting.createTime
  834. coupon_send_setting.limitAmt
  835. coupon_send_setting.limitDays
  836. coupon_send_setting.maxNumber
  837. coupon_send_setting.minNumber
  838. coupon_send_setting.settingType
  839. coupon_send_setting.status
  840. coupon_send_setting.version
  841. coupon_used.couponId
  842. coupon_used.createBy
  843. coupon_used.createTime
  844. coupon_used.deleted
  845. coupon_used.orderId
  846. coupon_used.remark
  847. coupon_used.status
  848. coupon_used.updateBy
  849. coupon_used.updateTime
  850. coupon_used.usedCd
  851. coupon_used.usedId
  852. coupon_used.version
  853. credit_assignment_application.accruedInterest
  854. credit_assignment_application.actualUnitPrice
  855. credit_assignment_application.applicationDate
  856. credit_assignment_application.castQuantity
  857. credit_assignment_application.createBy
  858. credit_assignment_application.createTime
  859. credit_assignment_application.creditRightId
  860. credit_assignment_application.expectArrivalAmount
  861. credit_assignment_application.fullScaleTime
  862. credit_assignment_application.groundTime
  863. credit_assignment_application.lastUpdateDate
  864. credit_assignment_application.minFullQuantity
  865. credit_assignment_application.nextRepayDate
  866. credit_assignment_application.nowStock
  867. credit_assignment_application.previousRepayDate
  868. credit_assignment_application.productId
  869. credit_assignment_application.quantity
  870. credit_assignment_application.remark
  871. credit_assignment_application.sellingMemberId
  872. credit_assignment_application.status
  873. credit_assignment_application.tenderEnd
  874. credit_assignment_application.tenderStart
  875. credit_assignment_application.todayStock
  876. credit_assignment_application.transferAppliCd
  877. credit_assignment_application.transferAppliId
  878. credit_assignment_application.transferDiscount
  879. credit_assignment_application.transferPrice
  880. credit_assignment_application.transferServerFee
  881. credit_assignment_application.transferTimes
  882. credit_assignment_application.transferredRate
  883. credit_assignment_application.unitPrice
  884. credit_assignment_application.version
  885. credit_assignment_setup.allowSplitFlag
  886. credit_assignment_setup.allowTransferAgainFlag
  887. credit_assignment_setup.createBy
  888. credit_assignment_setup.createTime
  889. credit_assignment_setup.creditAssignmentSetupId
  890. credit_assignment_setup.holdTimeoutLimit
  891. credit_assignment_setup.maxTransferTime
  892. credit_assignment_setup.minHoldAmount
  893. credit_assignment_setup.minHoldTime
  894. credit_assignment_setup.transferDiscount
  895. credit_assignment_setup.updateBy
  896. credit_assignment_setup.updateDate
  897. credit_assignment_setup.version
  898. credit_transaction_record.actualUnitPrice
  899. credit_transaction_record.buyCreditId
  900. credit_transaction_record.buyingMemberId
  901. credit_transaction_record.buyingQuantity
  902. credit_transaction_record.createBy
  903. credit_transaction_record.createTime
  904. credit_transaction_record.creditRightId
  905. credit_transaction_record.creditTransactionCd
  906. credit_transaction_record.creditTransactionId
  907. credit_transaction_record.endDate
  908. credit_transaction_record.orderID
  909. credit_transaction_record.productId
  910. credit_transaction_record.sellingMemberId
  911. credit_transaction_record.status
  912. credit_transaction_record.transactionDate
  913. credit_transaction_record.transferAppliId
  914. credit_transaction_record.transferFee
  915. credit_transaction_record.transferPrice
  916. credit_transaction_record.transferRate
  917. credit_transaction_record.transferredRate
  918. credit_transaction_record.unitPrice
  919. credit_transaction_record.version
  920. creditright.actualUnitPrice
  921. creditright.createBy
  922. creditright.createTime
  923. creditright.creditRightId
  924. creditright.effTime
  925. creditright.expTime
  926. creditright.memberId
  927. creditright.orderId
  928. creditright.productId
  929. creditright.quantity
  930. creditright.status
  931. creditright.unitPrice
  932. creditright.version
  933. customercomment.auditDesc
  934. customercomment.auditTime
  935. customercomment.auditor
  936. customercomment.centent
  937. customercomment.cententType
  938. customercomment.commentId
  939. customercomment.createBy
  940. customercomment.createTime
  941. customercomment.deleted
  942. customercomment.email
  943. customercomment.memberId
  944. customercomment.phone
  945. customercomment.realCd
  946. customercomment.realNm
  947. customercomment.updateBy
  948. customercomment.updateTime
  949. customercomment.version
  950. incomeplan.createBy
  951. incomeplan.createTime
  952. incomeplan.incomePlanId
  953. incomeplan.period
  954. incomeplan.planCapital
  955. incomeplan.planInterest
  956. incomeplan.planTime
  957. incomeplan.planTotal
  958. incomeplan.productId
  959. incomeplan.status
  960. incomeplan.version
  961. integralrecord.amount
  962. integralrecord.createBy
  963. integralrecord.createTime
  964. integralrecord.deleted
  965. integralrecord.failureTime
  966. integralrecord.integralVal
  967. integralrecord.isAddFlag
  968. integralrecord.isPermanent
  969. integralrecord.memberId
  970. integralrecord.objId
  971. integralrecord.objType
  972. integralrecord.recordId
  973. integralrecord.remark
  974. integralrecord.status
  975. integralrecord.updateBy
  976. integralrecord.updateTime
  977. integralrecord.version
  978. integralrule.amount
  979. integralrule.businessType
  980. integralrule.createBy
  981. integralrule.createTime
  982. integralrule.deleted
  983. integralrule.editor
  984. integralrule.integralVal
  985. integralrule.oneceLimit
  986. integralrule.ruleId
  987. integralrule.status
  988. integralrule.updateBy
  989. integralrule.updateTime
  990. integralrule.version
  991. invest_order.order_id
  992. invest_order.product_id
  993. itemtemplate.createBy
  994. itemtemplate.createTime
  995. itemtemplate.defaultFlag
  996. itemtemplate.templateId
  997. itemtemplate.templateNm
  998. itemtemplate.version
  999. itemtemplate_itemtype.itemtemplate_id
  1000. itemtemplate_itemtype.itemtype_id
  1001. itemtype.biller
  1002. itemtype.calOnlineFlag
  1003. itemtype.charger
  1004. itemtype.createBy
  1005. itemtype.createTime
  1006. itemtype.edited
  1007. itemtype.feeType
  1008. itemtype.itemTypeCd
  1009. itemtype.itemTypeId
  1010. itemtype.itemTypeNm
  1011. itemtype.itemTypePCd
  1012. itemtype.maxAmount
  1013. itemtype.minAmount
  1014. itemtype.node
  1015. itemtype.periodOrDay
  1016. itemtype.rate
  1017. itemtype.rateReferened
  1018. itemtype.version
  1019. loandetail.amount
  1020. loandetail.charger
  1021. loandetail.createBy
  1022. loandetail.createTime
  1023. loandetail.loanDetailId
  1024. loandetail.loanId
  1025. loandetail.memberId
  1026. loandetail.outTransferNo
  1027. loandetail.outsideOrderNo
  1028. loandetail.outsideSerialNo
  1029. loandetail.paymentTime
  1030. loandetail.productId
  1031. loandetail.resultStr
  1032. loandetail.status
  1033. loandetail.version
  1034. loaninfo.__title__ 放款明细
  1035. loaninfo.createBy
  1036. loaninfo.createTime
  1037. loaninfo.loanAmount
  1038. loaninfo.loanId
  1039. loaninfo.loanTime
  1040. loaninfo.loanType
  1041. loaninfo.outsideOrderNo
  1042. loaninfo.outsideSerialNo
  1043. loaninfo.paymentTimes
  1044. loaninfo.productId
  1045. loaninfo.status
  1046. loaninfo.version
  1047. loanrecord.createBy
  1048. loanrecord.createTime
  1049. loanrecord.loanAmount
  1050. loanrecord.loanDate
  1051. loanrecord.loanEndDate
  1052. loanrecord.loanId
  1053. loanrecord.loanOperator
  1054. loanrecord.loanOrderId
  1055. loanrecord.objId
  1056. loanrecord.objType
  1057. loanrecord.status
  1058. loanrecord.version
  1059. member.__title__ // 用户/企业表
  1060. member.auditType //认证方式1 :身份证认证(实名认证) 2 :银行卡认证 4 : 邮箱验证 8 : 手机验证 16:授权 ; 浙商开户后,16授权为on
  1061. member.bankNo // 银行卡号,浙商返回,可能带****
  1062. member.bankcardType 0本行 1 他行 注意,与borrower_card.isCurrentBankFlag相反
  1063. member.createBy
  1064. member.createTime
  1065. member.deleted
  1066. member.deviceTokenIOS
  1067. member.eSealStatus
  1068. member.eSignAccountId
  1069. member.email
  1070. member.errorloginCount
  1071. member.idCard
  1072. member.isNewSysMember
  1073. member.isOpenZJB
  1074. member.lastLogin
  1075. member.lastLoginIp
  1076. member.level
  1077. member.loginCount
  1078. member.memberCd // 用于锚定的唯一值。因为企业的锚定值不一定是手机号
  1079. member.memberId
  1080. member.memberIdZ
  1081. member.memberKind // 客户类型0:个人,1:企业
  1082. member.noviceStandardQuota
  1083. member.operationSrc
  1084. member.passSalt
  1085. member.password
  1086. member.phone // 手机号
  1087. member.promotionId
  1088. member.realCd 登录帐号
  1089. member.realCdZ
  1090. member.realNm // 用户名/企业名称
  1091. member.realNmZ
  1092. member.registTime
  1093. member.riskResult
  1094. member.riskResultDate
  1095. member.status
  1096. member.statusZ
  1097. member.updateBy
  1098. member.updateTime
  1099. member.version
  1100. member_audit.auditAuthor
  1101. member_audit.auditDesc
  1102. member_audit.auditId
  1103. member_audit.auditTime
  1104. member_audit.auditType
  1105. member_audit.createBy
  1106. member_audit.createTime
  1107. member_audit.memberId
  1108. member_audit.status
  1109. member_audit.submitTime
  1110. member_audit.version
  1111. member_old_capital_flow.amount
  1112. member_old_capital_flow.createBy
  1113. member_old_capital_flow.createTime
  1114. member_old_capital_flow.deleted
  1115. member_old_capital_flow.flag
  1116. member_old_capital_flow.flowId
  1117. member_old_capital_flow.memberId
  1118. member_old_capital_flow.remark
  1119. member_old_capital_flow.status
  1120. member_old_capital_flow.updateBy
  1121. member_old_capital_flow.updateTime
  1122. member_old_capital_flow.version
  1123. member_old_info.balance
  1124. member_old_info.createBy
  1125. member_old_info.createTime
  1126. member_old_info.deleted
  1127. member_old_info.infoId
  1128. member_old_info.memberId
  1129. member_old_info.oldId
  1130. member_old_info.oldIdCard
  1131. member_old_info.oldName
  1132. member_old_info.outsideOrderNo
  1133. member_old_info.outsideSerialNo
  1134. member_old_info.remark
  1135. member_old_info.updateBy
  1136. member_old_info.updateTime
  1137. member_old_info.version
  1138. member_operation_log.createBy
  1139. member_operation_log.createTime
  1140. member_operation_log.logId
  1141. member_operation_log.memberId
  1142. member_operation_log.operateContent
  1143. member_operation_log.operateType
  1144. member_operation_log.version
  1145. member_receivables.__title__ // 还款计划表?
  1146. member_receivables.InterestDateBegin
  1147. member_receivables.InterestDateEnd
  1148. member_receivables.actualAmount 实际总金额(本金+利息)
  1149. member_receivables.actualCapital 实际本金
  1150. member_receivables.actualDate
  1151. member_receivables.actualInterest 实际利息
  1152. member_receivables.actualOtherFee
  1153. member_receivables.advanceRepayPenaltyAmt
  1154. member_receivables.createBy
  1155. member_receivables.createTime
  1156. member_receivables.currentOutsideOrderNo
  1157. member_receivables.currentOutsideSerialNo
  1158. member_receivables.expectAmount // 预期总金额
  1159. member_receivables.expectCapital // 预期本金?
  1160. member_receivables.expectDate
  1161. member_receivables.expectInterest // 预期利息
  1162. member_receivables.memberId
  1163. member_receivables.orderId
  1164. member_receivables.orderNo
  1165. member_receivables.outsideOrderDate
  1166. member_receivables.outsideOrderNo
  1167. member_receivables.outsideSerialNo
  1168. member_receivables.period
  1169. member_receivables.preReapyInterest
  1170. member_receivables.productId
  1171. member_receivables.recId
  1172. member_receivables.repayApplyStatus
  1173. member_receivables.repayAuditStatus
  1174. member_receivables.repayOutsideOrderDate
  1175. member_receivables.repayOutsideOrderNo
  1176. member_receivables.repayOutsideSerialNo
  1177. member_receivables.status // 0:未收款 1:已收款 2:废除
  1178. member_receivables.version
  1179. memberintegral.createBy
  1180. memberintegral.createTime
  1181. memberintegral.deleted
  1182. memberintegral.integralVal
  1183. memberintegral.maxInvestAmount
  1184. memberintegral.memberId
  1185. memberintegral.total
  1186. memberintegral.updateBy
  1187. memberintegral.updateTime
  1188. memberintegral.usedAmount
  1189. memberintegral.usedValue
  1190. memberintegral.version
  1191. memberrisktestanswer.createBy
  1192. memberrisktestanswer.createTime
  1193. memberrisktestanswer.deleted
  1194. memberrisktestanswer.memberId
  1195. memberrisktestanswer.memberRiskTestAnswerId
  1196. memberrisktestanswer.riskTestAnswer
  1197. memberrisktestanswer.updateBy
  1198. memberrisktestanswer.updateTime
  1199. memberrisktestanswer.version
  1200. memberseal.createBy
  1201. memberseal.createTime
  1202. memberseal.deleted
  1203. memberseal.evid
  1204. memberseal.memberId
  1205. memberseal.relateStatus
  1206. memberseal.sealData
  1207. memberseal.sealId
  1208. memberseal.updateBy
  1209. memberseal.updateTime
  1210. memberseal.version
  1211. notice.acceptBy
  1212. notice.acceptNm
  1213. notice.batchNo
  1214. notice.content
  1215. notice.createBy
  1216. notice.createTime
  1217. notice.deleted
  1218. notice.effTime
  1219. notice.expTime
  1220. notice.listSort
  1221. notice.noticeId
  1222. notice.noticeTitle
  1223. notice.readed
  1224. notice.state
  1225. notice.stateTime
  1226. notice.title
  1227. notice.version
  1228. old_sys_repay.buyTime
  1229. old_sys_repay.capital
  1230. old_sys_repay.createBy
  1231. old_sys_repay.createTime
  1232. old_sys_repay.interest
  1233. old_sys_repay.oldOrderCd
  1234. old_sys_repay.oldOrderId
  1235. old_sys_repay.oldProductId
  1236. old_sys_repay.oldSysRepayId
  1237. old_sys_repay.oldUserId
  1238. old_sys_repay.outsideOrderNo
  1239. old_sys_repay.outsideSerialNo
  1240. old_sys_repay.repayTime
  1241. old_sys_repay.status
  1242. old_sys_repay.totalAmt
  1243. old_sys_repay.version
  1244. oldtable_1.itemid
  1245. oldtable_1.单价
  1246. oldtable_1.投资总金额
  1247. oldtable_1.数量
  1248. oldtable_1.融资金额
  1249. oldtable_1.融资金额-投资总金额
  1250. oldtable_1.项目投资笔数
  1251. oldtable_1.项目状态
  1252. oldtable_2.Id
  1253. oldtable_2.IdCard
  1254. oldtable_2.Name
  1255. oldtable_2.余额
  1256. oldtable_2.充值成功笔数
  1257. oldtable_2.充值成功金额
  1258. oldtable_2.已收款笔数
  1259. oldtable_2.已收款金额
  1260. oldtable_2.待收款笔数
  1261. oldtable_2.待收款金额
  1262. oldtable_2.投资成功笔数
  1263. oldtable_2.投资成功金额
  1264. oldtable_2.提现成功笔数
  1265. oldtable_2.提现成功金额
  1266. oldtable_4.TYPE
  1267. oldtable_4.数量
  1268. order_detail.createBy
  1269. order_detail.createTime
  1270. order_detail.itemAmount
  1271. order_detail.itemTypeCd
  1272. order_detail.itemTypeNm
  1273. order_detail.memberIdA
  1274. order_detail.memberIdZ
  1275. order_detail.orderId
  1276. order_detail.orderdetailId
  1277. order_detail.version
  1278. order_extra_info.createBy
  1279. order_extra_info.createTime
  1280. order_extra_info.infoId
  1281. order_extra_info.orderId
  1282. order_extra_info.orderInfoNm
  1283. order_extra_info.orderInfoVal
  1284. order_extra_info.payPlatform
  1285. order_extra_info.payPlatformCd
  1286. order_extra_info.remark
  1287. order_extra_info.version
  1288. outsideorderrecord.createBy
  1289. outsideorderrecord.createTime
  1290. outsideorderrecord.orderId
  1291. outsideorderrecord.outsideId
  1292. outsideorderrecord.outsideOrderId
  1293. outsideorderrecord.outsideSerialNo
  1294. outsideorderrecord.version
  1295. payrespdata.createBy
  1296. payrespdata.createTime
  1297. payrespdata.deleted
  1298. payrespdata.remark
  1299. payrespdata.respCd
  1300. payrespdata.respId
  1301. payrespdata.respMsg
  1302. payrespdata.returnType
  1303. payrespdata.returnTypeCd
  1304. payrespdata.showCd
  1305. payrespdata.showMsg
  1306. payrespdata.status
  1307. payrespdata.subType
  1308. payrespdata.subTypeCd
  1309. payrespdata.updateBy
  1310. payrespdata.updateTime
  1311. payrespdata.version
  1312. personal.address
  1313. personal.area
  1314. personal.areaNm
  1315. personal.birthday
  1316. personal.borrowingTimes
  1317. personal.city
  1318. personal.cityNm
  1319. personal.contactFax
  1320. personal.createBy
  1321. personal.createTime
  1322. personal.creditInfo
  1323. personal.deleted
  1324. personal.ecpName
  1325. personal.ecpRelation
  1326. personal.ecpTelephone
  1327. personal.education
  1328. personal.email
  1329. personal.gender
  1330. personal.income
  1331. personal.industry
  1332. personal.industryNm
  1333. personal.legalPersonIDCard
  1334. personal.liabilities
  1335. personal.memberId
  1336. personal.monthIncome
  1337. personal.msn
  1338. personal.officePhone
  1339. personal.province
  1340. personal.provinceNm
  1341. personal.qq
  1342. personal.status
  1343. personal.telephone
  1344. personal.updateBy
  1345. personal.updateTime
  1346. personal.version
  1347. praise.createBy
  1348. praise.createTime
  1349. praise.deleted
  1350. praise.isPraise
  1351. praise.memberId
  1352. praise.praiseId
  1353. praise.themeId
  1354. praise.updateBy
  1355. praise.updateTime
  1356. praise.version
  1357. processaudithistory.auditContent
  1358. processaudithistory.auditContentWeb
  1359. processaudithistory.auditDate
  1360. processaudithistory.auditOpinion
  1361. processaudithistory.auditResult
  1362. processaudithistory.auditor
  1363. processaudithistory.createBy
  1364. processaudithistory.createTime
  1365. processaudithistory.historyId
  1366. processaudithistory.objId
  1367. processaudithistory.objType
  1368. processaudithistory.remark
  1369. processaudithistory.title
  1370. processaudithistory.version
  1371. product.agreementCd
  1372. product._title_ // 产品,核心
  1373. product.amount // 募集金额(借款金额)(元) = 放款金额 + 前置服务费 = 本金 = 数量 * 单价
  1374. product.assetId ref // 资产id
  1375. product.auditPassedQuantity
  1376. product.autoQuantity
  1377. product.awardAmount
  1378. product.awardFail
  1379. product.awardRate
  1380. product.awardTotal
  1381. product.borrowAmt // 放款金额 在创建项目时=资产的 约定借款金额 但可以修改。
  1382. product.borrowerIdCard
  1383. product.borrowerName // 借款人
  1384. product.brokerageStatus
  1385. product.brrowUse
  1386. product.brrowUseName
  1387. product.businessType // 1=票据类,2=p2p
  1388. product.businessTypeNm
  1389. product.canAutobid
  1390. product.canTransfer
  1391. product.canUseCoupon
  1392. product.castQuantity // 实际满标数量
  1393. product.checkTime
  1394. product.commissionBalanceStatus
  1395. product.compenInterest
  1396. product.contractEffTime
  1397. product.createBy
  1398. product.createTime
  1399. product.credit
  1400. product.deleted
  1401. product.directPassword
  1402. product.ecardName
  1403. product.ecardNo
  1404. product.financingDays
  1405. product.fullScaleSureTime 满标确认时间
  1406. product.fullScaleTime // 满标时间?
  1407. product.fundUse
  1408. product.groundTime 申请上线时间
  1409. product.guaranteeInfo
  1410. product.holidayDelay
  1411. product.industry
  1412. product.interestAlgorithm
  1413. product.interestBeginTime
  1414. product.interestEndTime
  1415. product.interestStartTime
  1416. product.interestType
  1417. product.interestTypeName
  1418. product.isNewSysProduct
  1419. product.lastRepayDate
  1420. product.loanDays
  1421. product.loanStatus
  1422. product.loaneeBankAccountName
  1423. product.loaneeBankAccountNumber
  1424. product.loaneeBankBranchNm
  1425. product.loaneeBankBranchNo
  1426. product.loaneeBankCityNm
  1427. product.loaneeBankCityNo
  1428. product.loaneeBankCode
  1429. product.loaneeBankName
  1430. product.loaneeBankProvinceNm
  1431. product.loaneeBankProvinceNo
  1432. product.maxTenderQuantity
  1433. product.memberId 非借款人id
  1434. product.minFullQuantity
  1435. product.minHoldDay
  1436. product.minTenderQuantity
  1437. product.mobileAwardRate
  1438. product.nature
  1439. product.oldItemId
  1440. product.online
  1441. product.period 借款期限
  1442. product.periodType
  1443. product.personInfo
  1444. product.personalLoan
  1445. product.preServiceFeeAmt // 前置服务费
  1446. product.preSubsidyAmt // 前置补贴
  1447. product.productCd // 项目编号
  1448. product.productContent 承兑机构
  1449. product.productGrade
  1450. product.productId
  1451. product.productNm // 标题 项目名称 银票宝8268期
  1452. product.productTypeRuleId
  1453. product.promotionType
  1454. product.promotionTypeName
  1455. product.quantity // 总数量
  1456. product.rate 利率
  1457. product.repayDelay
  1458. product.repayMethod
  1459. product.repayMethodName 还款方式
  1460. product.repayPeriod
  1461. product.repayPlayTime // 预计还款日
  1462. product.repaySource
  1463. product.singleInvestPen
  1464. product.spv
  1465. product.status // 10 "草稿"; 11 "待审核"; 12 "已废弃"; 13 "已撤回"; 14 "审核驳回"; 15 "审核失败"; 31 "待招标(待上线)"; 40 "已撤标"; 32 "已上线"; 30 "招标中"; 60 "满标待审"; 61 "流标待处理"; 80 "待放款"; 85 "放款中"; 90 "还款中"; 100 "已还完"; 70 "废标待退款"; 101 "废标已退款"; 71 "流标待退款"; 73 "撤标待退款"; 102 "流标已退款"; 50 "已流标"; 103 "撤标已退款"; ProductOrderDto.java
  1466. 30 "招标中"; 60 "满标待审"; 80 "待放款"; 85 "放款中"; 90 "还款中"; 100 "已还完";
  1467. product.statusName 状态name
  1468. product.sufServiceFeeAmt // 后置服务费 满标审核通过时计算,与sufSubsidyAmt只有一个值非零
  1469. product.sufSubsidyAmt // 后置补贴
  1470. product.tenderEnd 投标截止时间
  1471. product.tenderKind
  1472. product.tenderKindName
  1473. product.tenderStart 投标开始时间
  1474. product.ticketAmt 票面金额/约定还款金额 还款总额
  1475. product.totalPeriod
  1476. product.unitPrice 单价
  1477. product.updateBy
  1478. product.updateTime
  1479. product.version
  1480. product.virtualAcc
  1481. product.virtualAccname
  1482. product_apply.acceptedBank
  1483. product_apply.acceptedBankType
  1484. product_apply.address
  1485. product_apply.applyTime
  1486. product_apply.applyType
  1487. product_apply.assetType
  1488. product_apply.borrowAmount
  1489. product_apply.borrowCd
  1490. product_apply.borrowId
  1491. product_apply.borrowName
  1492. product_apply.borrowReason
  1493. product_apply.borrowType
  1494. product_apply.createBy
  1495. product_apply.createTime
  1496. product_apply.interest
  1497. product_apply.memberId
  1498. product_apply.mobile
  1499. product_apply.period
  1500. product_apply.periodType
  1501. product_apply.productId
  1502. product_apply.profession
  1503. product_apply.rate
  1504. product_apply.remark
  1505. product_apply.repayMethod
  1506. product_apply.safeguardDesc
  1507. product_apply.status
  1508. product_apply.ticketDueDate
  1509. product_apply.ticketType
  1510. product_apply.verifyManger
  1511. product_apply.verifyTime
  1512. product_apply.version
  1513. product_apply.yearIncomeAmt
  1514. product_apply_attachment.attachmentId
  1515. product_apply_attachment.borrowId
  1516. product_apply_detail.address
  1517. product_apply_detail.annualSalesVolume
  1518. product_apply_detail.borrowId
  1519. product_apply_detail.companyNm
  1520. product_apply_detail.createBy
  1521. product_apply_detail.createTime
  1522. product_apply_detail.detailId
  1523. product_apply_detail.familyIncome
  1524. product_apply_detail.gender
  1525. product_apply_detail.idcard
  1526. product_apply_detail.legalRepresentative
  1527. product_apply_detail.monthlyIncome
  1528. product_apply_detail.occupation
  1529. product_apply_detail.operatingLife
  1530. product_apply_detail.organizationCd
  1531. product_apply_detail.registeredCapital
  1532. product_apply_detail.safeguard
  1533. product_apply_detail.safeguardDesc
  1534. product_apply_detail.totalAssets
  1535. product_apply_detail.version
  1536. product_apply_detail.workinfo
  1537. product_attachment.attachmentId
  1538. product_attachment.productId
  1539. product_authinfo.auditProject
  1540. product_authinfo.auditProjectNm
  1541. product_authinfo.createBy
  1542. product_authinfo.createTime
  1543. product_authinfo.id
  1544. product_authinfo.infoType
  1545. product_authinfo.passTime
  1546. product_authinfo.productId
  1547. product_authinfo.status
  1548. product_authinfo.version
  1549. product_contract_template.contractTemplateId
  1550. product_contract_template.productId
  1551. product_order.__title__ // 订单表
  1552. product_order.amount // 金额 本金
  1553. product_order.anticipatedIncome
  1554. product_order.couponAmount // 优惠补贴 红包等产生的金额
  1555. product_order.couponOutsideOrderNo
  1556. product_order.createBy
  1557. product_order.createDate
  1558. product_order.createTime // 下单时间
  1559. product_order.deleted
  1560. product_order.expectedIncome // 收益 利息
  1561. product_order.freezeStatus
  1562. product_order.freezeTrxId // 资金冻结银行流水号
  1563. product_order.investWay // 投资方式 0 手动 1 自动?
  1564. /**
  1565. * 手动出借
  1566. */
  1567. public static final Integer ORDERTYPE_HANDLEINVEST = 0;
  1568. /**
  1569. * 自动出借
  1570. */
  1571. public static final Integer ORDERTYPE_AUTOINVEST = 1;
  1572. /**
  1573. * 债权转让
  1574. */
  1575. public static final Integer ORDERTYPE_CREDITTRANSFER = 2;
  1576. /**
  1577. * 充值
  1578. */
  1579. public static final Integer ORDERTYPE_RECHARGE = 3;
  1580. /**
  1581. * 提现
  1582. */
  1583. public static final Integer ORDERTYPE_CASH = 4;
  1584. /**
  1585. * 放款
  1586. */
  1587. public static final Integer ORDERTYPE_LOANS = 5;
  1588. /**
  1589. * 还款
  1590. */
  1591. public static final Integer ORDERTYPE_REPAYMENT = 6;
  1592. /**
  1593. * 转账
  1594. */
  1595. public static final Integer ORDERTYPE_TRANSFER = 7;
  1596. product_order.memberId
  1597. product_order.operationSrc // 认购标识 0 pc 1 微网站 2 android 3 ios;
  1598. product_order.orderCd
  1599. product_order.orderDate
  1600. product_order.orderId
  1601. product_order.orderNo // 订单编号
  1602. product_order.outsideOrderNo //
  1603. product_order.outsideSerialNo // 资金冻结银行流水号
  1604. product_order.payEndDate // 支付时间
  1605. product_order.payStatus 支付状态 0 待支付 1 支付成功 2 支付失败 3 待退款 4 已退款
  1606. product_order.payUrl
  1607. product_order.productId
  1608. product_order.quantity
  1609. product_order.rate
  1610. product_order.resultStr
  1611. product_order.stageFlag // 0:已还款 1:出借 2:已放款 3:临时还款前 4:临时还款后 5:已放款;老系统数据,全为0
  1612. product_order.status // 订单状态 0 申请 1 确认 2 废弃
  1613. product_order.tradeBankCard 交易卡号
  1614. product_order.tradeRealNm
  1615. product_order.trxId // 资金冻结银行流水号
  1616. product_order.unitprice
  1617. product_order.updateBy
  1618. product_order.updateTime
  1619. product_order.verifyStatus // 审核状态 0 待审核 1 审核通过 2 审核驳回
  1620. product_order.version
  1621. product_pledge.auctionCompany
  1622. product_pledge.auctionTime
  1623. product_pledge.author
  1624. product_pledge.createBy
  1625. product_pledge.createTime
  1626. product_pledge.dealAmt
  1627. product_pledge.id
  1628. product_pledge.pledgeType
  1629. product_pledge.productId
  1630. product_pledge.remark
  1631. product_pledge.size
  1632. product_pledge.version
  1633. product_pledge.workName
  1634. productaudit.auditDesc
  1635. productaudit.auditOpinion
  1636. productaudit.auditTime
  1637. productaudit.createBy
  1638. productaudit.createTime
  1639. productaudit.deleted
  1640. productaudit.newStatus
  1641. productaudit.newStatusNm
  1642. productaudit.oldStatus
  1643. productaudit.oldStatusNm
  1644. productaudit.productAuditId
  1645. productaudit.productId
  1646. productaudit.updateBy
  1647. productaudit.updateTime
  1648. productaudit.version
  1649. productbusinesstype._title_ 产品种类规则
  1650. productbusinesstype.abbreviation 单字简称
  1651. productbusinesstype.backColor 背景色
  1652. productbusinesstype.businessType 业务类型:1 票据类, 2 p2p类
  1653. productbusinesstype.businessTypeNm 业务类型:1 票据类, 2 p2p类
  1654. productbusinesstype.createBy
  1655. productbusinesstype.createTime
  1656. productbusinesstype.currNo 当前期数
  1657. productbusinesstype.deleted
  1658. productbusinesstype.prefixName 前缀名称:银票宝 商票宝 车贷宝
  1659. productbusinesstype.productBusinessTypeId
  1660. productbusinesstype.productBusinessTypeNm 产品种类:银票(电子) 商票(电子) 银行承兑汇票 电子银票 纸质商票
  1661. productbusinesstype.updateBy
  1662. productbusinesstype.updateTime
  1663. productbusinesstype.version
  1664. productitemtype.biller
  1665. productitemtype.calOnlineFlag
  1666. productitemtype.charger
  1667. productitemtype.createBy
  1668. productitemtype.createTime
  1669. productitemtype.edited
  1670. productitemtype.feeType
  1671. productitemtype.itemTypeCd
  1672. productitemtype.itemTypeId
  1673. productitemtype.itemTypeNm
  1674. productitemtype.itemTypePCd
  1675. productitemtype.maxAmount
  1676. productitemtype.minAmount
  1677. productitemtype.node
  1678. productitemtype.periodOrDay
  1679. productitemtype.productId
  1680. productitemtype.productItemTypeId
  1681. productitemtype.rate
  1682. productitemtype.rateReferened
  1683. productitemtype.templateId
  1684. productitemtype.templateNm
  1685. productitemtype.version
  1686. productraterule.beginDay
  1687. productraterule.createBy
  1688. productraterule.createTime
  1689. productraterule.deleted
  1690. productraterule.endDay
  1691. productraterule.productRateRuleId
  1692. productraterule.productTypeRuleId
  1693. productraterule.rate
  1694. productraterule.updateBy
  1695. productraterule.updateTime
  1696. productraterule.version
  1697. producttyperule._title_ 产品类型规则(产品模板,依赖productbusinesstype)
  1698. producttyperule.createBy
  1699. producttyperule.createTime
  1700. producttyperule.deleted
  1701. producttyperule.holidayDelay
  1702. producttyperule.interestType
  1703. producttyperule.interestTypeName 计息方式:项目成立计息 即投即生息
  1704. producttyperule.periodType
  1705. producttyperule.periodTypeName
  1706. producttyperule.productBusinessTypeId
  1707. producttyperule.productPrefixName
  1708. producttyperule.productPrifName
  1709. producttyperule.productTypeName 产品名称(资产类别):村镇 国股 城商 三农
  1710. producttyperule.productTypeRuleId
  1711. producttyperule.repayDelay
  1712. producttyperule.repayDelayDays 最迟还款延期,一般都是3
  1713. producttyperule.repayMethod
  1714. producttyperule.repayMethodName 还款方式:按期还息到期还本 到期一次返还本息
  1715. producttyperule.updateBy
  1716. producttyperule.updateTime
  1717. producttyperule.version
  1718. rechargecashrecord.account
  1719. rechargecashrecord.actualAmount
  1720. rechargecashrecord.amount
  1721. rechargecashrecord.bankCard
  1722. rechargecashrecord.bankCardId
  1723. rechargecashrecord.bankCode
  1724. rechargecashrecord.channel
  1725. rechargecashrecord.channelNm
  1726. rechargecashrecord.checkValue
  1727. rechargecashrecord.city
  1728. rechargecashrecord.clientFee
  1729. rechargecashrecord.createBy
  1730. rechargecashrecord.createTime
  1731. rechargecashrecord.doType
  1732. rechargecashrecord.fee
  1733. rechargecashrecord.feeReceivables
  1734. rechargecashrecord.freeLimit
  1735. rechargecashrecord.memberId
  1736. rechargecashrecord.operationSrc
  1737. rechargecashrecord.orderId
  1738. rechargecashrecord.outsideOrderNo
  1739. rechargecashrecord.outsideSerialNo
  1740. rechargecashrecord.platFee
  1741. rechargecashrecord.province
  1742. rechargecashrecord.realName
  1743. rechargecashrecord.recordId
  1744. rechargecashrecord.recordType 1 充值 2提现
  1745. rechargecashrecord.remark
  1746. rechargecashrecord.resultStr
  1747. rechargecashrecord.serviceFee
  1748. rechargecashrecord.serviceFeeReceivables
  1749. rechargecashrecord.status 0 初始 1 成功 2 失败 3 废弃
  1750. rechargecashrecord.transferDate
  1751. rechargecashrecord.transferEndDate
  1752. rechargecashrecord.version
  1753. recommend.createBy
  1754. recommend.createTime
  1755. recommend.effTime
  1756. recommend.expTime
  1757. recommend.listSort
  1758. recommend.recommendId
  1759. recommend.state
  1760. recommend.stateTime
  1761. recommend.targetId
  1762. recommend.targetNm
  1763. recommend.targetType
  1764. recommend.version
  1765. region.createBy
  1766. region.createTime
  1767. region.listSort
  1768. region.regionCd
  1769. region.regionId
  1770. region.regionNm
  1771. region.regionPCd
  1772. region.regionPid
  1773. region.regionType
  1774. region.version
  1775. repay.__title__ // 还款表,总表,每一期的还款金额等;还款申请 时插入
  1776. repay.advanceRepayFlag 提前还款标记 0/null 普通还款 1 提前结清申请 2 前置结清申请 3 提前结清完毕 4 前置结清完毕
  1777. repay.auditID 确认人
  1778. repay.auditRemark 审核意见
  1779. repay.auditTime 确认时间
  1780. repay.createBy
  1781. repay.createTime
  1782. repay.memberId 还款人或代偿人
  1783. repay.orderId
  1784. repay.period 期数
  1785. repay.productId
  1786. repay.receivableAmount 出借人收款总额
  1787. repay.repayId
  1788. repay.repayKind 是否代偿(0:自还,1:代偿)
  1789. repay.repayRemark 还款备注
  1790. repay.repayTime 还款日期
  1791. repay.repayTotal 还款总额 还款金额
  1792. repay.status // 实际还款状态:0:申请还款 1:还款中-审核完成,调用接口开始还款 2:完成-还款支付成功 3:还款失败
  1793. repay.version
  1794. repayitem.__title__ // 没啥用,有用的数据 repayitemplan 都有,可能是起到关联 repay repayitemplan 两表的作用?
  1795. repayitem.ItemAmount
  1796. repayitem.ItemTypeId
  1797. repayitem.createBy
  1798. repayitem.createTime
  1799. repayitem.itemNm
  1800. repayitem.repayId
  1801. repayitem.repayItemId
  1802. repayitem.repayItemPlanId
  1803. repayitem.version
  1804. repayitemplan.__title__ // 还款表,每一期的还款明细表
  1805. repayitemplan.ItemTypeId
  1806. repayitemplan.createBy
  1807. repayitemplan.createTime
  1808. repayitemplan.interestDateBegin
  1809. repayitemplan.interestDateEnd
  1810. repayitemplan.itemAmount
  1811. repayitemplan.itemNm
  1812. repayitemplan.period
  1813. repayitemplan.productId
  1814. repayitemplan.repayDate
  1815. repayitemplan.repayItemPlanId
  1816. repayitemplan.status // 计划还款状态:0:未还款 1:已还款(还款后并不会设为此值,见 repay.status) 2:废弃 3:已代偿 4:已追偿完毕
  1817. repayitemplan.version
  1818. repayment_summary.DueincollectedOverdueInterest
  1819. repayment_summary.actualDueinCapital
  1820. repayment_summary.actualDueinInterest
  1821. repayment_summary.actualDueinTotal
  1822. repayment_summary.actualRepayCapital
  1823. repayment_summary.actualRepayInterest
  1824. repayment_summary.actualRepayPeriod
  1825. repayment_summary.actualRepayTotal
  1826. repayment_summary.claimDay
  1827. repayment_summary.collectedOverdueInterest
  1828. repayment_summary.createBy
  1829. repayment_summary.createTime
  1830. repayment_summary.nextRepayDate
  1831. repayment_summary.nextRepayTotal
  1832. repayment_summary.overdueDay
  1833. repayment_summary.overdueInterest
  1834. repayment_summary.planRepayCapital
  1835. repayment_summary.planRepayInterest
  1836. repayment_summary.planRepayPeriod
  1837. repayment_summary.planRepayTotal
  1838. repayment_summary.productId
  1839. repayment_summary.stillDueinCapital
  1840. repayment_summary.stillDueinInterest
  1841. repayment_summary.stillDueinTotal
  1842. repayment_summary.stillRepayCapital
  1843. repayment_summary.stillRepayInterest
  1844. repayment_summary.stillRepayPeriod
  1845. repayment_summary.stillRepayTotal
  1846. repayment_summary.version
  1847. repaymenttrack.advanceRepayFlag
  1848. repaymenttrack.auditDate
  1849. repaymenttrack.auditorCd
  1850. repaymenttrack.auditorId
  1851. repaymenttrack.createBy
  1852. repaymenttrack.createTime
  1853. repaymenttrack.deleted
  1854. repaymenttrack.interestDateBegin
  1855. repaymenttrack.interestDateEnd
  1856. repaymenttrack.memberId
  1857. repaymenttrack.memberType
  1858. repaymenttrack.orderId
  1859. repaymenttrack.outsideOrderNo
  1860. repaymenttrack.outsideSerialNo
  1861. repaymenttrack.overdueDays
  1862. repaymenttrack.overdueInterest
  1863. repaymenttrack.period
  1864. repaymenttrack.planCapital
  1865. repaymenttrack.planInterest
  1866. repaymenttrack.planReceivableAmount
  1867. repaymenttrack.planRepayAmount
  1868. repaymenttrack.planRepayDate
  1869. repaymenttrack.planStatus
  1870. repaymenttrack.preReapyDays
  1871. repaymenttrack.preReapyInterest
  1872. repaymenttrack.productId
  1873. repaymenttrack.receivableAmount
  1874. repaymenttrack.repayAccount
  1875. repaymenttrack.repayAccountNm
  1876. repaymenttrack.repayAccountNo
  1877. repaymenttrack.repayAmount
  1878. repaymenttrack.repayBankNm
  1879. repaymenttrack.repayBankNo
  1880. repaymenttrack.repayCapital
  1881. repaymenttrack.repayDate
  1882. repaymenttrack.repayInterest
  1883. repaymenttrack.repayRemark
  1884. repaymenttrack.repayStatus
  1885. repaymenttrack.repayWay
  1886. repaymenttrack.sufSubsidyOutsideOrderNo
  1887. repaymenttrack.sufSubsidyOutsideSerialNo
  1888. repaymenttrack.sufSubsidyPassDate
  1889. repaymenttrack.sufSubsidyStatus
  1890. repaymenttrack.trackId
  1891. repaymenttrack.updateBy
  1892. repaymenttrack.updateTime
  1893. repaymenttrack.version
  1894. safeguard.backletterCd
  1895. safeguard.companyId
  1896. safeguard.companyNm
  1897. safeguard.createBy
  1898. safeguard.createTime
  1899. safeguard.debtDesc
  1900. safeguard.guaranteeDesc
  1901. safeguard.pawnDesc
  1902. safeguard.productId
  1903. safeguard.riskDesc
  1904. safeguard.safeguardDesc
  1905. safeguard.version
  1906. sms_notice.VERSION
  1907. sms_notice.acceptBy
  1908. sms_notice.acceptNm
  1909. sms_notice.batchNo
  1910. sms_notice.content
  1911. sms_notice.createBy
  1912. sms_notice.createTime
  1913. sms_notice.deleted
  1914. sms_notice.effTime
  1915. sms_notice.expTime
  1916. sms_notice.listSort
  1917. sms_notice.noticeId
  1918. sms_notice.readed
  1919. sms_notice.state
  1920. sms_notice.stateTime
  1921. sms_notice.title
  1922. sms_provider.PASSWORD
  1923. sms_provider.VERSION
  1924. sms_provider.createBy
  1925. sms_provider.createTime
  1926. sms_provider.effTime
  1927. sms_provider.expTime
  1928. sms_provider.extra
  1929. sms_provider.listSort
  1930. sms_provider.maxDestination
  1931. sms_provider.providerCode
  1932. sms_provider.providerId
  1933. sms_provider.providerName
  1934. sms_provider.remark
  1935. sms_provider.signPrefix
  1936. sms_provider.signSuffix
  1937. sms_provider.state
  1938. sms_provider.stateTime
  1939. sms_provider.userName
  1940. sms_provider_log.STATUS
  1941. sms_provider_log.VERSION
  1942. sms_provider_log.createBy
  1943. sms_provider_log.createTime
  1944. sms_provider_log.deleted
  1945. sms_provider_log.destination
  1946. sms_provider_log.extra
  1947. sms_provider_log.providerId
  1948. sms_provider_log.providerLogId
  1949. sms_provider_log.requestContent
  1950. sms_provider_log.requestTime
  1951. sms_provider_log.requestTitle
  1952. sms_provider_log.responseContent
  1953. sms_provider_log.responseTime
  1954. sms_provider_log.triggerNode
  1955. sms_provider_log.updateBy
  1956. sms_provider_log.updateTime
  1957. sms_send_queue.STATUS
  1958. sms_send_queue.VERSION
  1959. sms_send_queue.content
  1960. sms_send_queue.createBy
  1961. sms_send_queue.createTime
  1962. sms_send_queue.deleted
  1963. sms_send_queue.destination
  1964. sms_send_queue.extra
  1965. sms_send_queue.planSendTime
  1966. sms_send_queue.providerId
  1967. sms_send_queue.sendQueueId
  1968. sms_send_queue.sendTime
  1969. sms_send_queue.title
  1970. sms_send_queue.triggerNode
  1971. sms_send_queue.updateBy
  1972. sms_send_queue.updateTime
  1973. sms_template.VERSION
  1974. sms_template.createBy
  1975. sms_template.createTime
  1976. sms_template.effTime
  1977. sms_template.expTime
  1978. sms_template.hasTimer
  1979. sms_template.listSort
  1980. sms_template.providerId
  1981. sms_template.receiver
  1982. sms_template.state
  1983. sms_template.stateTime
  1984. sms_template.templateContent
  1985. sms_template.templateId
  1986. sms_template.triggerNode
  1987. sms_template.triggerNodeNm
  1988. sys_app.appCd
  1989. sys_app.appDesc
  1990. sys_app.appId
  1991. sys_app.appNm
  1992. sys_app.context
  1993. sys_app.createBy
  1994. sys_app.createTime
  1995. sys_app.effTime
  1996. sys_app.expTime
  1997. sys_app.host
  1998. sys_app.isBusiness
  1999. sys_app.listSort
  2000. sys_app.port
  2001. sys_app.state
  2002. sys_app.stateTime
  2003. sys_app.version
  2004. sys_permission.createBy
  2005. sys_permission.createTime
  2006. sys_permission.effTime
  2007. sys_permission.expTime
  2008. sys_permission.listSort
  2009. sys_permission.permissionId
  2010. sys_permission.permissionType
  2011. sys_permission.resourceId
  2012. sys_permission.roleId
  2013. sys_permission.state
  2014. sys_permission.stateTime
  2015. sys_permission.userId
  2016. sys_permission.version
  2017. sys_resource.__title__ // 菜单 menu
  2018. sys_resource.appCd
  2019. sys_resource.appId
  2020. sys_resource.bigIcon
  2021. sys_resource.createBy
  2022. sys_resource.createTime
  2023. sys_resource.effTime
  2024. sys_resource.expTime
  2025. sys_resource.listSort
  2026. sys_resource.resourceCd
  2027. sys_resource.resourceId // id
  2028. sys_resource.resourceLevel //
  2029. sys_resource.resourceLink
  2030. sys_resource.resourceNm // 显示的name
  2031. sys_resource.resourcePid // pid
  2032. sys_resource.resourceType
  2033. sys_resource.smallIcon
  2034. sys_resource.state
  2035. sys_resource.stateTime
  2036. sys_resource.target
  2037. sys_resource.version
  2038. sys_role.createBy
  2039. sys_role.createTime
  2040. sys_role.effTime
  2041. sys_role.expTime
  2042. sys_role.listSort
  2043. sys_role.roleCd
  2044. sys_role.roleDesc
  2045. sys_role.roleId
  2046. sys_role.roleNm
  2047. sys_role.state
  2048. sys_role.stateTime
  2049. sys_role.version
  2050. sys_taskconfig.__title__ // 定时任务
  2051. sys_taskconfig.createBy
  2052. sys_taskconfig.createTime
  2053. sys_taskconfig.effTime
  2054. sys_taskconfig.expTime
  2055. sys_taskconfig.listSort
  2056. sys_taskconfig.state // F0X 禁止运行;
  2057. sys_taskconfig.stateTime
  2058. sys_taskconfig.taskCd
  2059. sys_taskconfig.taskCron
  2060. sys_taskconfig.taskDesc
  2061. sys_taskconfig.taskFixedDelay
  2062. sys_taskconfig.taskFixedRate
  2063. sys_taskconfig.taskId
  2064. sys_taskconfig.taskInitialDelay
  2065. sys_taskconfig.taskMethod
  2066. sys_taskconfig.taskNm
  2067. sys_taskconfig.taskRef
  2068. sys_taskconfig.taskRun
  2069. sys_taskconfig.taskTrigger
  2070. sys_taskconfig.version
  2071. sys_taskconfig.writeLog
  2072. sys_taskconfig2.createBy
  2073. sys_taskconfig2.createTime
  2074. sys_taskconfig2.effTime
  2075. sys_taskconfig2.expTime
  2076. sys_taskconfig2.listSort
  2077. sys_taskconfig2.state
  2078. sys_taskconfig2.stateTime
  2079. sys_taskconfig2.taskCd
  2080. sys_taskconfig2.taskCron
  2081. sys_taskconfig2.taskDesc
  2082. sys_taskconfig2.taskFixedDelay
  2083. sys_taskconfig2.taskFixedRate
  2084. sys_taskconfig2.taskId
  2085. sys_taskconfig2.taskInitialDelay
  2086. sys_taskconfig2.taskMethod
  2087. sys_taskconfig2.taskNm
  2088. sys_taskconfig2.taskRef
  2089. sys_taskconfig2.taskRun
  2090. sys_taskconfig2.taskTrigger
  2091. sys_taskconfig2.version
  2092. sys_taskconfig2.writeLog
  2093. sys_tasklog.createBy
  2094. sys_tasklog.createTime
  2095. sys_tasklog.execDate
  2096. sys_tasklog.execTime
  2097. sys_tasklog.message
  2098. sys_tasklog.status
  2099. sys_tasklog.taskCd
  2100. sys_tasklog.taskLogId
  2101. sys_tasklog.taskNm
  2102. sys_tasklog.version
  2103. sys_user.createBy
  2104. sys_user.createTime
  2105. sys_user.effTime
  2106. sys_user.expTime
  2107. sys_user.isAdmin
  2108. sys_user.lastIp
  2109. sys_user.lastLogin
  2110. sys_user.listSort
  2111. sys_user.password
  2112. sys_user.state
  2113. sys_user.stateTime
  2114. sys_user.userCd
  2115. sys_user.userId
  2116. sys_user.userNm
  2117. sys_user.version
  2118. sys_user_role.createBy
  2119. sys_user_role.createTime
  2120. sys_user_role.effTime
  2121. sys_user_role.expTime
  2122. sys_user_role.listSort
  2123. sys_user_role.roleId
  2124. sys_user_role.state
  2125. sys_user_role.stateTime
  2126. sys_user_role.userId
  2127. sys_user_role.userRoleId
  2128. sys_user_role.version
  2129. sysoperationlog.createBy
  2130. sysoperationlog.createTime
  2131. sysoperationlog.logId
  2132. sysoperationlog.operateContent
  2133. sysoperationlog.operateObj
  2134. sysoperationlog.operateObjName
  2135. sysoperationlog.operateObjType
  2136. sysoperationlog.operateTime
  2137. sysoperationlog.operateType
  2138. sysoperationlog.operatorAccount
  2139. sysoperationlog.operatorId
  2140. sysoperationlog.operatorType
  2141. sysoperationlog.remark
  2142. sysoperationlog.version
  2143. tax_rate_config.createBy
  2144. tax_rate_config.createTime
  2145. tax_rate_config.id
  2146. tax_rate_config.maxLimitAmt
  2147. tax_rate_config.minLimitAmt
  2148. tax_rate_config.quickDeductionAmt
  2149. tax_rate_config.taxRate
  2150. tax_rate_config.version
  2151. telcommunicationrecord.commuText
  2152. telcommunicationrecord.commuTime
  2153. telcommunicationrecord.createBy
  2154. telcommunicationrecord.createTime
  2155. telcommunicationrecord.memberAccount
  2156. telcommunicationrecord.memberId
  2157. telcommunicationrecord.operatorAccount
  2158. telcommunicationrecord.operatorId
  2159. telcommunicationrecord.orderCd
  2160. telcommunicationrecord.orderId
  2161. telcommunicationrecord.productId
  2162. telcommunicationrecord.productNm
  2163. telcommunicationrecord.recordId
  2164. telcommunicationrecord.status
  2165. telcommunicationrecord.version
  2166. test_call.id
  2167. test_call.param
  2168. tradedetail.__title__ // 交易明细 流水
  2169. tradedetail.accountCd
  2170. tradedetail.createBy
  2171. tradedetail.createTime
  2172. tradedetail.currentBalance
  2173. tradedetail.itemAmount
  2174. tradedetail.itemTypeCd
  2175. tradedetail.itemTypeNm
  2176. tradedetail.memberId
  2177. tradedetail.nodeFlag
  2178. tradedetail.nodePk // 投资时ref product_order.orderid;还款时ref repay.repayid;其他情况为null?
  2179. tradedetail.operationSrc
  2180. tradedetail.productId // 绝大多数情况下是null,因此对应是哪期项目只能通过remark字段查找。
  2181. tradedetail.remark
  2182. tradedetail.rollInout
  2183. tradedetail.serialNbr // 资金冻结银行流水号
  2184. tradedetail.status // 0 初始化 1 已确认 2 已失败
  2185. tradedetail.tradeDetailId
  2186. tradedetail.version
  2187. tradedetailrecord.createBy
  2188. tradedetailrecord.createTime
  2189. tradedetailrecord.deleted
  2190. tradedetailrecord.feeType
  2191. tradedetailrecord.hasChecked
  2192. tradedetailrecord.inMemberId
  2193. tradedetailrecord.isMainRecord
  2194. tradedetailrecord.itemTypeCd
  2195. tradedetailrecord.itemTypeNm
  2196. tradedetailrecord.outMemberId
  2197. tradedetailrecord.remark
  2198. tradedetailrecord.saveStatus
  2199. tradedetailrecord.status
  2200. tradedetailrecord.tradeAmount
  2201. tradedetailrecord.tradeDetailId
  2202. tradedetailrecord.tradeEndTime
  2203. tradedetailrecord.tradeId
  2204. tradedetailrecord.updateBy
  2205. tradedetailrecord.updateTime
  2206. tradedetailrecord.version
  2207. tradesummary.createBy
  2208. tradesummary.createTime
  2209. tradesummary.deleted
  2210. tradesummary.hasChecked
  2211. tradesummary.inOutFlag
  2212. tradesummary.memberId
  2213. tradesummary.realCd
  2214. tradesummary.remark
  2215. tradesummary.serialId
  2216. tradesummary.sourceDataId
  2217. tradesummary.sourceDataName
  2218. tradesummary.status
  2219. tradesummary.tradeAmount
  2220. tradesummary.tradeEndTime
  2221. tradesummary.tradeId
  2222. tradesummary.tradeType
  2223. tradesummary.updateBy
  2224. tradesummary.updateTime
  2225. tradesummary.version
  2226. transaction_flow.callbackParams
  2227. transaction_flow.callbackTime
  2228. transaction_flow.callbackUrl
  2229. transaction_flow.createBy
  2230. transaction_flow.createTime
  2231. transaction_flow.id
  2232. transaction_flow.requestParams
  2233. transaction_flow.requestTime
  2234. transaction_flow.requestUrl
  2235. transaction_flow.version
  2236. transferdetail.bankInvestTransferId
  2237. transferdetail.createBy
  2238. transferdetail.createTime
  2239. transferdetail.itemAmount
  2240. transferdetail.itemTypeCd
  2241. transferdetail.itemTypeNm
  2242. transferdetail.memberIdA
  2243. transferdetail.memberIdZ
  2244. transferdetail.transferDetailId
  2245. transferdetail.version
  2246. transferspecial.amount
  2247. transferspecial.ceateByName
  2248. transferspecial.createBy
  2249. transferspecial.createTime
  2250. transferspecial.deleted
  2251. transferspecial.inAccountCd
  2252. transferspecial.inMemberId
  2253. transferspecial.inPhone
  2254. transferspecial.inRealCd
  2255. transferspecial.inRealNm
  2256. transferspecial.orderId
  2257. transferspecial.outAccountCd
  2258. transferspecial.outMemberId
  2259. transferspecial.outPhone
  2260. transferspecial.outRealCd
  2261. transferspecial.outRealNm
  2262. transferspecial.outsideOrderNo
  2263. transferspecial.outsideSerialNo
  2264. transferspecial.remark
  2265. transferspecial.status
  2266. transferspecial.transferSpecialId
  2267. transferspecial.updateBy
  2268. transferspecial.updateTime
  2269. transferspecial.version
  2270. user_summary.amountAward
  2271. user_summary.amountAwardInvest
  2272. user_summary.amountAwardRow
  2273. user_summary.amountCash
  2274. user_summary.amountCashRow
  2275. user_summary.amountDueRepayAll
  2276. user_summary.amountDueRepayCapital
  2277. user_summary.amountDueRepayInterest
  2278. user_summary.amountDueRepayRow
  2279. user_summary.amountDueRepayedAll
  2280. user_summary.amountDueRepayedCapital
  2281. user_summary.amountDueRepayedInterest
  2282. user_summary.amountDueRepayedRow
  2283. user_summary.amountDueinAll
  2284. user_summary.amountDueinCapital
  2285. user_summary.amountDueinInterest
  2286. user_summary.amountDueinRow
  2287. user_summary.amountInedAll
  2288. user_summary.amountInedCapital
  2289. user_summary.amountInedInterest
  2290. user_summary.amountInedRow
  2291. user_summary.amountInterestFee
  2292. user_summary.amountInvest
  2293. user_summary.amountInvestRow
  2294. user_summary.amountInvit
  2295. user_summary.amountRecharge
  2296. user_summary.amountRechargeRow
  2297. user_summary.createBy
  2298. user_summary.createTime
  2299. user_summary.id
  2300. user_summary.investIntegral
  2301. user_summary.memberId
  2302. user_summary.version
  2303. visitdata.createBy
  2304. visitdata.createTime
  2305. visitdata.dataId
  2306. visitdata.userData
  2307. visitdata.version
  2308. visitdata.visitIp
  2309. visitdata.visitType
  2310. xe_u_user.Cipher
  2311. xe_u_user.Email
  2312. xe_u_user.Enabled
  2313. xe_u_user.GroupId
  2314. xe_u_user.Id
  2315. xe_u_user.IdCard
  2316. xe_u_user.Ip
  2317. xe_u_user.Name
  2318. xe_u_user.PassSalt
  2319. xe_u_user.Password
  2320. xe_u_user.Payment
  2321. xe_u_user.Recommend
  2322. xe_u_user.Tel
  2323. xe_u_user.Tel_Code
  2324. xe_u_user.UpTime
  2325. xe_u_user.channel