登记簿数据库关系

1、表权利人QLR

表结构

sql语句

select bsm,ywh,qlrlb,qlbm,qlbsm,qlrmc,zjzl,qlrlx,qszt,zsbsm,yxtbm,yxtbsm,qxdm,rev_,gxsj,bz_right_id 
from qlr 
where  rownum<101;

案例查询结果

2、表房地产权FDCQ

表结构

sql语句

select bsm,ywh,qllx,djlx,bdcqzh,djsj,fj,qszt,yxtbm,yxtbsm,qxdm,rev_,djjg,gxsj,bz_syqzid,bz_ywslid from fdcq where rownum<101;

案例查询结果

3、表审核SH

表字段结构

sql语句

select bsm,ywh,qlbm,qlbsm,shlx,qllx,bdclx,qlxz,qszt,yxtbm,qxdm,rev_,gxsj,yxtbsm from sh where rownum<100;

案例查询结果

4、表登记房证-产权证书DJFZ_CQZS2

表结构

sql

select bsm,ywh,qlbsm,qlbm,bdcqzh,qlr,zl,qllx,qlxz,qlxz1,yt,yt1,mj,mj1,syqx,fzdq,fznf,fzbm,fzxh,qxdm,yxtbsm,yxtbm,rev_,qszt,zslx,gxsj from djfz_cqzs where rownum<100;

案例查询结果

5、表房地产权-单元关系FDCQ_DYGX

表结构

sql

select * from fdcq_dygx where rownum<100;

案例查询结果

6、表户H

表结构

sql

select bsm,zrzbsm,fwbm,hh,ycjzmj,fwxz,yxtfwxzmc,fwlb,yxtbm,yxtbsm,dcbsm,qxdm,rev_,fflb,gxsj,bz_fwcode,bz_fwid,qszt,bz_zid,sfjsmj,bbh from h where rownum<100;

案例查询结果

7.表层C

表结构

sql

select bsm,zrzbsm,ch,zrzh,sjc,yxtbm,yxtbsm,qxdm,rev_,gxsj from c where rownum<100;

案例查询结果

8、表自然幢ZRZ

表结构

sql

select bsm,zrzh,ycjzmj,scjzmj,zcs,dscs,dxcs,fwjg,zts,bz,xqmc,zl,tfh,qh,yxtbm,yxtbsm,dcbsm,qxdm,rev_,zddm,zdshiyqbsm,gxsj,bz_fcfhtid,bz_zrzcode,BZ_LPMID,bz_qszt from zrz where rownum<100;

查询案例

9、表逻辑幢LJZ

结构

sql

案例查询

10、申请人

结构

sql

select bsm,ywh,sqrlb,sqrlx,sqrmc,sqrzjzl,sqrzjh,sqrtxdz,sqryddh,sqrfrmc,qxdm,rev_,gxsj from sqr where rownum<100;

查询案例

11、表受理申请SLSQ

表结构

sql

select bsm,ywh,djdl,djxl,sqzsbs,sqfbcz,zl,bz,bdclx,ybdcqzh,sqly,sfgg,blts,czrmc,lzrmc,lzrzjzl,lzrzjh,lzrlxdh,slr,slsj,slyj,adyfbfz,rev_,zllb,sfsm,gxsj,sfjnqs,blss,ssxzq,ggslh,dysj from slsq where rownum<100;

案例查询