天瑞部分表同步

  1. 1. 将以下两表权限给 TX_SUPERMAN
  2. //个检订单表 HM_YW_TJZ000_QZJ， 
  3. //个检项目表 HM_YW_TJYW00_QZJ ，
  4. //团检订单表 ESI_HMZXDD_TTTJZ0
  5. //团检项目表 ESI_HMZXDD_TTYWZJ
  6. 执行SQL如下。另外三表同下
  7. grant select on ESI_HMZXDD_TTYWZJ to TX_SUPERMAN;
  8. CREATE OR REPLACE PUBLIC SYNONYM ESI_HMZXDD_TTYWZJ FOR tx_jk.ESI_HMZXDD_TTYWZJ;
  10. 2.确认表结构
  11. create table HM_YW_TJYW00_QZJ
  12. (
  13.   sfywid NUMBER(30) not null,
  14.   tjh000 NUMBER(30) not null,
  15.   ttid00 NUMBER(10) default 0 not null,
  16.   rwid00 NUMBER(10) default 0 not null,
  17.   sqxmid NUMBER(5) not null,
  18.   sfxmmc VARCHAR2(50),
  19.   zyflid NUMBER(5),
  20.   ysje00 NUMBER(12,2) default 0 not null,
  21.   dj0000 NUMBER(12,2) default 0 not null,
  22.   sl0000 NUMBER(12,2) default 1 not null,
  23.   tsje00 NUMBER(12,2) default 0 not null,
  24.   gwyje0 NUMBER(12,2) default 0 not null,
  25.   zfje00 NUMBER(12,2) default 0 not null,
  26.   ydj000 VARCHAR2(1) default '0' not null,
  27.   fsxx00 VARCHAR2(20),
  28.   djr000 NUMBER(6),
  29.   djrq00 CHAR(8),
  30.   djsj00 CHAR(8),
  31.   txm000 VARCHAR2(12),
  32.   cjrq00 CHAR(8),
  33.   cjsj00 CHAR(8),
  34.   cjr000 NUMBER(6),
  35.   ybcjks NUMBER(6),
  36.   jyyljg VARCHAR2(1) default '0' not null,
  37.   jyylrq CHAR(8),
  38.   jyylsj CHAR(8),
  39.   qj0000 VARCHAR2(1) default '0' not null,
  40.   jcbz00 VARCHAR2(1) default '0' not null,
  41.   tfntbz VARCHAR2(1) default '0' not null,
  42.   jcksid NUMBER(6) not null,
  43.   kdrq00 CHAR(8) default to_char(sysdate,'YYYYMMDD') not null,
  44.   kdsj00 CHAR(8) default to_char(sysdate,'HH24:MI:SS') not null,
  45.   fkksrq CHAR(8) default '00000000',
  46.   fkkssj CHAR(8),
  47.   fkjsrq CHAR(8),
  48.   fkjssj CHAR(8),
  49.   kdys00 NUMBER(6),
  50.   sfsf00 VARCHAR2(1) default '0' not null,
  51.   sfjz00 VARCHAR2(1) default '0' not null,
  52.   sfrq00 CHAR(8),
  53.   sfsj00 CHAR(8),
  54.   ksczy0 NUMBER(6),
  55.   jcysid NUMBER(6),
  56.   jcysxm VARCHAR2(30),
  57.   jcrq00 CHAR(8),
  58.   jcsj00 CHAR(8),
  59.   zhxmid NUMBER(5),
  60.   fywid0 NUMBER(10) default -1 not null,
  61.   khqrbz VARCHAR2(1) default '0' not null,
  62.   topacs VARCHAR2(1) default '0',
  63.   fkjcid NUMBER(10),
  64.   yyrq00 CHAR(8) default '00000000',
  65.   bz0000 VARCHAR2(100),
  66.   ypffy0 NUMBER(6),
  67.   ypffrq VARCHAR2(30),
  68.   jpydy0 VARCHAR2(1) default '0' not null,
  69.   sgywid NUMBER(12) default 0,
  70.   jpksid NUMBER(5),
  71.   djywid NUMBER(12),
  72.   xh0000 NUMBER(5),
  73.   wsbz00 VARCHAR2(1),
  74.   jyfs00 VARCHAR2(1) default '0' not null,
  75.   txmold VARCHAR2(12),
  76.   ywid00 NUMBER(12),
  77.   jgflag VARCHAR2(1) default '0',
  78.   jgzfje NUMBER(12,2) default 0,
  79.   jgtsje NUMBER(12,2) default 0,
  80.   sfttxm VARCHAR2(1) default '0',
  81.   wwtjh  VARCHAR2(30),
  82.   code   VARCHAR2(30)
  83. )
  85. create table HM_YW_TJZ000_QZJ
  86. (
  87.   tjh000        NUMBER(30) not null,
  88.   tjdm00        VARCHAR2(30),
  89.   daid00        NUMBER(20),
  90.   xm0000        VARCHAR2(30),
  91.   pysm00        VARCHAR2(15),
  92.   wbsm00        VARCHAR2(15),
  93.   xb0000        VARCHAR2(1) default '0',
  94.   nl0000        NUMBER(5),
  95.   csrq00        VARCHAR2(8),
  96.   nlys00        NUMBER(3),
  97.   dh0000        VARCHAR2(30),
  98.   dhfbr0        VARCHAR2(1),
  99.   dz0000        VARCHAR2(120),
  100.   sfzh00        VARCHAR2(30),
  101.   nldwid        NUMBER(5),
  102.   hyzkid        NUMBER(5),
  103.   mzid00        NUMBER(5) default 1,
  104.   dzyj00        VARCHAR2(80),
  105.   zp0000        BLOB,
  106.   brid00        NUMBER(12),
  107.   ttid00        NUMBER(5) default 0,
  108.   rwid00        NUMBER(10) default 0,
  109.   fzid00        NUMBER(10),
  110.   ttbm00        VARCHAR2(100),
  111.   rwydid        NUMBER(12),
  112.   kl0000        NUMBER(5,1),
  113.   tsxe00        NUMBER(12,2),
  114.   kdysid        NUMBER(6),
  115.   lxid00        NUMBER(5) default 1,
  116.   tjlxid        NUMBER(5) default 1,
  117.   sfyd00        VARCHAR2(1) default '0',
  118.   jyid00        NUMBER(5),
  119.   zyid00        NUMBER(5),
  120.   dqid00        NUMBER(5) default 202,
  121.   rzrq00        CHAR(8),
  122.   cjr000        NUMBER(6),
  123.   cjrq00        CHAR(8) default to_char(sysdate,'YYYYMMDD'),
  124.   cjsj00        CHAR(8) default to_char(sysdate,'HH24:MI:SS'),
  125.   djrq00        CHAR(8),
  126.   djsj00        CHAR(8),
  127.   yyrq00        CHAR(8),
  128.   zydsm0        VARCHAR2(200),
  129.   ydj000        VARCHAR2(1) default '0',
  130.   djyid0        NUMBER(6),
  131.   zydyd0        VARCHAR2(1) default '0',
  132.   yjf000        VARCHAR2(1) default '0',
  133.   ykstj0        VARCHAR2(1) default '0',
  134.   fjwc00        VARCHAR2(1) default '0',
  135.   fjwcrq        CHAR(8) default '00000000',
  136.   zjsd00        VARCHAR2(1) default '0',
  137.   zjjsyy        VARCHAR2(2000),
  138.   zjjsrq        VARCHAR2(20),
  139.   zjwc00        VARCHAR2(1) default '0',
  140.   zswc00        VARCHAR2(1) default '0',
  141.   zjysid        NUMBER(6),
  142.   zjrq00        CHAR(8) default '00000000',
  143.   zjsj00        CHAR(8),
  144.   zsys00        NUMBER(6),
  145.   fshys0        NUMBER(6),
  146.   zsrq00        CHAR(8) default '00000000',
  147.   zssj00        CHAR(8),
  148.   bgfmyd        VARCHAR2(1) default '0',
  149.   bgydy0        VARCHAR2(1) default '0',
  150.   bgdyid        NUMBER(6),
  151.   bgdyrq        CHAR(8) default '00000000',
  152.   bgdysj        CHAR(8),
  153.   bglqtz        VARCHAR2(1) default '0',
  154.   lqtzr0        NUMBER(6),
  155.   lqtzrq        CHAR(8),
  156.   lqtzsj        CHAR(8),
  157.   tzfs00        NUMBER(5) default 2,
  158.   lqfs00        NUMBER(5) default 6,
  159.   bgyq00        VARCHAR2(1) default '0',
  160.   bglqrq        CHAR(8) default '00000000',
  161.   bglqsj        CHAR(8),
  162.   zdjb00        VARCHAR2(1) default '0',
  163.   ja0000        VARCHAR2(1) default '0',
  164.   jarq00        CHAR(8) default '00000000',
  165.   jasj00        CHAR(8),
  166.   xygz00        VARCHAR2(1) default '0',
  167.   fbrtj0        VARCHAR2(1) default '0',
  168.   mj0000        VARCHAR2(1) default '0',
  169.   jmdj00        NUMBER(3) default 0,
  170.   yj0000        VARCHAR2(1) default '0',
  171.   zxid00        VARCHAR2(60),
  172.   zxmc00        VARCHAR2(200),
  173.   sfsf00        VARCHAR2(1) default '0',
  174.   bz0000        VARCHAR2(2000),
  175.   zzjb00        NUMBER(5),
  176.   zzsm00        VARCHAR2(50),
  177.   zzytz0        VARCHAR2(1) default '0',
  178.   zztzrq        CHAR(8),
  179.   zztzsj        CHAR(8),
  180.   zztzr0        NUMBER(5),
  181.   zs0000        VARCHAR2(4000),
  182.   jl0000        VARCHAR2(4000),
  183.   jy0000        CLOB,
  184.   jkjy00        VARCHAR2(4000),
  185.   ysjy00        VARCHAR2(4000),
  186.   yxjy00        VARCHAR2(4000),
  187.   jkzs00        VARCHAR2(4000),
  188.   wxts00        VARCHAR2(4000),
  189.   yxzs00        VARCHAR2(4000),
  190.   zsthyy        VARCHAR2(4000),
  191.   zsthfk        VARCHAR2(4000),
  192.   thbz00        VARCHAR2(1) default '0',
  193.   zfje00        NUMBER(12,2) default 0,
  194.   jzje00        NUMBER(12,2) default 0,
  195.   fbbh00        NUMBER(5) default 1,
  196.   ybjgbh        VARCHAR2(2),
  197.   ybrylb        NUMBER(2),
  198.   ybkh00        VARCHAR2(30),
  199.   shbzh0        VARCHAR2(30),
  200.   ybghh0        VARCHAR2(20),
  201.   ybghrq        CHAR(8),
  202.   ybdjrq        CHAR(8) default '00000000',
  203.   ckyf00        VARCHAR2(1) default '0',
  204.   jj0000        VARCHAR2(1) default '0',
  205.   sfhy00        VARCHAR2(1) default '0',
  206.   jabz00        VARCHAR2(2000),
  207.   jasfcl        CHAR(1) default '0',
  208.   sfcjja        CHAR(1) default '0',
  209.   ybdjr0        NUMBER(6),
  210.   djtsxx        VARCHAR2(100),
  211.   ttgh00        VARCHAR2(20),
  212.   yybh00        CHAR(6) default '0',
  213.   sjrq00        CHAR(8) default '00000000',
  214.   zjwljj        VARCHAR2(1) default '0',
  215.   total_fee     NUMBER(12,2) default 0,
  216.   price         NUMBER(12,2) default 0,
  217.   code          VARCHAR2(30),
  218.   state         NUMBER(1) default 0,
  219.   discount      VARCHAR2(10),
  220.   suggestion    VARCHAR2(1000),
  221.   check_items   VARCHAR2(1000),
  222.   nwtjh         VARCHAR2(30),
  223.   yyqssj        VARCHAR2(8),
  224.   yyzzsj        VARCHAR2(8),
  225.   tjlxmc        VARCHAR2(30),
  226.   hyzk00        VARCHAR2(30),
  227.   xsjfje        NUMBER(12,2),
  228.   mqxm00        VARCHAR2(30),
  229.   mqsfzh        VARCHAR2(30),
  230.   csdz00        NUMBER(5),
  231.   fjdz00        NUMBER(5),
  232.   tcid00        NUMBER(10),
  233.   tjly00        VARCHAR2(40),
  234.   ykj000        VARCHAR2(1),
  235.   ykjje0        NUMBER(12,2),
  236.   ytjh00        NUMBER(12),
  237.   bjh000        VARCHAR2(20),
  238.   hishospitalld VARCHAR2(20)
  239. );
  241. -- Create table
  242. create table TX_JK.ESI_HMZXDD_TTYWZJ
  243. (
  244.   TJH000 NUMBER(12) not null,
  245.   SFYWID NUMBER(12),
  246.   LB0000 NUMBER(5) not null,
  247.   SQXMID NUMBER(10) not null,
  248.   SQXMMC VARCHAR2(50),
  249.   DJ0000 NUMBER(12,2),
  250.   JE0000 NUMBER(12,2),
  251.   CZRQ00 CHAR(8) default to_char(sysdate, 'YYYYMMDD'),
  252.   CZSJ00 CHAR(8) default to_char(sysdate,'HH24:MI:SS'),  --操作时间,
  253.   SFXMMC VARCHAR2(200)
  254. )
  255. tablespace TS_JK
  256.   pctfree 10
  257.   initrans 1
  258.   maxtrans 255
  259.   storage
  260.   (
  261.     initial 64
  262.     minextents 1
  263.     maxextents unlimited
  264.   );
  265. -- Create/Recreate indexes 
  266. create index TX_JK.IDX_ESI_HMZXDD_TTYWZJ_SFYWID on TX_JK.ESI_HMZXDD_TTYWZJ (SFYWID)
  267.   tablespace TS_JK_IND
  268.   pctfree 10
  269.   initrans 2
  270.   maxtrans 255
  271.   storage
  272.   (
  273.     initial 64K
  274.     minextents 1
  275.     maxextents unlimited
  276.   );
  277. create index TX_JK.IDX_ESI_HMZXDD_TTYWZJ_TJH000 on TX_JK.ESI_HMZXDD_TTYWZJ (TJH000)
  278.   tablespace TS_JK_IND
  279.   pctfree 10
  280.   initrans 2
  281.   maxtrans 255
  282.   storage
  283.   (
  284.     initial 64K
  285.     minextents 1
  286.     maxextents unlimited
  287.   );
  288. -- Grant/Revoke object privileges 
  289. grant select on TX_JK.ESI_HMZXDD_TTYWZJ to TX_SUPERMAN;
  292. -- Create table
  293. create table TX_JK.ESI_HMZXDD_TTTJZ0
  294. (
  295.   TJH000 NUMBER(12) not null,
  296.   XM0000 VARCHAR2(30),
  297.   XB0000 VARCHAR2(30),
  298.   NL0000 NUMBER(3),
  299.   CSRQ00 VARCHAR2(8),
  300.   SFZH00 VARCHAR2(18),
  301.   HYZK00 VARCHAR2(4),
  302.   SFHY00 VARCHAR2(1),
  303.   DH0000 VARCHAR2(12),
  304.   YYRQ00 VARCHAR2(8),
  305.   YYQSSJ VARCHAR2(8),
  306.   YYZZSJ VARCHAR2(8),
  307.   CZRQ00 CHAR(8) default to_char(sysdate, 'YYYYMMDD'),
  308.   CZSJ00 CHAR(8) default to_char(sysdate,'HH24:MI:SS'),
  309.   YDJ000 VARCHAR2(2) default '0' not null,
  310.   TJLXMC VARCHAR2(30),
  311.   SFXMMC VARCHAR2(200)
  312. )
  313. tablespace TS_JK
  314.   pctfree 10
  315.   initrans 1
  316.   maxtrans 255
  317.   storage
  318.   (
  319.     initial 64
  320.     minextents 1
  321.     maxextents unlimited
  322.   );
  323. -- Create/Recreate indexes 
  324. create unique index TX_JK.IDX_ESI_HMZXDD_TTTJZ0_TJH000 on TX_JK.ESI_HMZXDD_TTTJZ0 (TJH000)
  325.   tablespace TS_JK_IND
  326.   pctfree 10
  327.   initrans 2
  328.   maxtrans 255
  329.   storage
  330.   (
  331.     initial 64K
  332.     minextents 1
  333.     maxextents unlimited
  334.   );
  335. -- Grant/Revoke object privileges 
  336. grant select on TX_JK.ESI_HMZXDD_TTTJZ0 to TX_SUPERMAN;
文档更新时间: 2024-07-11 16:48