Attachment 'JGGZ_Table_script.sql'
Download 1 DROP TABLE JGGZ.A CASCADE CONSTRAINTS;
2
3 CREATE TABLE JGGZ.A
4 (
5 A DATE
6 )
7 LOGGING
8 NOCACHE
9 NOPARALLEL;
10
11
12 DROP TABLE JGGZ.BML_LJINFO_TMP CASCADE CONSTRAINTS;
13
14 CREATE TABLE JGGZ.BML_LJINFO_TMP
15 (
16 ID VARCHAR2(32 BYTE) NOT NULL,
17 ZF_ID VARCHAR2(12 BYTE),
18 RJ_DATE DATE,
19 LJ_DATE DATE,
20 DB VARCHAR2(32 BYTE),
21 LJ_TYPE VARCHAR2(12 BYTE),
22 RJ_TYPE VARCHAR2(12 BYTE),
23 C_DATE DATE,
24 U_DATE DATE,
25 DEL_FLAG CHAR(1 BYTE),
26 DDFLAG CHAR(1 BYTE),
27 LJQX VARCHAR2(20 BYTE),
28 DRDB VARCHAR2(32 BYTE)
29 )
30 LOGGING
31 NOCACHE
32 NOPARALLEL;
33
34
35 DROP TABLE JGGZ.BML_XQBG_TMP CASCADE CONSTRAINTS;
36
37 CREATE TABLE JGGZ.BML_XQBG_TMP
38 (
39 XQBG_NO VARCHAR2(32 BYTE) NOT NULL,
40 ZF_ID VARCHAR2(12 BYTE),
41 SPB_NO VARCHAR2(32 BYTE),
42 BD_TYPE VARCHAR2(20 BYTE),
43 JYJ_PZ_DATE DATE,
44 PJ_DATE DATE,
45 PJ_NO1 VARCHAR2(32 BYTE),
46 PJ_NO2 VARCHAR2(32 BYTE),
47 PJ_JG VARCHAR2(50 BYTE),
48 PJ_XZQH VARCHAR2(32 BYTE),
49 CD_FD VARCHAR2(32 BYTE),
50 BZ_NX VARCHAR2(8 BYTE),
51 XZ VARCHAR2(20 BYTE),
52 SJ_XQ VARCHAR2(32 BYTE),
53 YXQ VARCHAR2(8 BYTE),
54 YBZNX VARCHAR2(8 BYTE),
55 YXZ VARCHAR2(20 BYTE),
56 YXQ_START_DATE DATE,
57 YXQ_END_DATE DATE,
58 START_DATE DATE,
59 END_DATE DATE,
60 ZX_DATE DATE,
61 CD_SJ_QK VARCHAR2(4000 BYTE),
62 SPB_TYPE CHAR(1 BYTE),
63 MEMO VARCHAR2(4000 BYTE),
64 C_DATE DATE,
65 U_DATE DATE,
66 DEL_FLAG CHAR(1 BYTE),
67 YPJ_NO1 VARCHAR2(32 BYTE),
68 YPJ_NO2 VARCHAR2(32 BYTE),
69 YPJ_JG VARCHAR2(50 BYTE),
70 YPJ_XZQH VARCHAR2(32 BYTE),
71 YPJ_DATE DATE,
72 C_USER VARCHAR2(32 BYTE),
73 SZ_DB VARCHAR2(32 BYTE),
74 CB_DATE DATE
75 )
76 LOGGING
77 NOCACHE
78 NOPARALLEL;
79
80
81 DROP TABLE JGGZ.BML_ZFLJ_TMP CASCADE CONSTRAINTS;
82
83 CREATE TABLE JGGZ.BML_ZFLJ_TMP
84 (
85 ID VARCHAR2(32 BYTE) NOT NULL,
86 ZF_ID VARCHAR2(12 BYTE),
87 LJ_TYPE VARCHAR2(20 BYTE),
88 LJ_DOC_NO VARCHAR2(64 BYTE),
89 LJ_ADDR_XZQH VARCHAR2(16 BYTE),
90 LJ_ADDR_DETAIL VARCHAR2(256 BYTE),
91 LJ_POL VARCHAR2(32 BYTE),
92 LJ_DATE DATE,
93 PJ_NO1 VARCHAR2(16 BYTE),
94 PJ_NO2 VARCHAR2(32 BYTE),
95 PJXZQH VARCHAR2(32 BYTE),
96 PJJG VARCHAR2(32 BYTE),
97 PJDATE DATE,
98 C_USER VARCHAR2(64 BYTE),
99 LJ_STATUS CHAR(1 BYTE),
100 SJ_DATE DATE,
101 DR_DATE DATE,
102 YDB VARCHAR2(32 BYTE),
103 MEMO VARCHAR2(1000 BYTE),
104 C_DATE DATE,
105 U_DATE DATE,
106 DEL_FLAG CHAR(1 BYTE)
107 )
108 LOGGING
109 NOCACHE
110 NOPARALLEL;
111
112
113 DROP TABLE JGGZ.CRJ_JYJ_TMP CASCADE CONSTRAINTS;
114
115 CREATE TABLE JGGZ.CRJ_JYJ_TMP
116 (
117 ID VARCHAR2(32 BYTE) NOT NULL,
118 ZF_ID VARCHAR2(12 BYTE),
119 RJ_DATE DATE,
120 LJ_DATE DATE,
121 DB VARCHAR2(32 BYTE),
122 LJ_TYPE VARCHAR2(12 BYTE),
123 RJ_TYPE VARCHAR2(12 BYTE),
124 C_DATE DATE,
125 U_DATE DATE,
126 DEL_FLAG CHAR(1 BYTE),
127 DDFLAG CHAR(1 BYTE),
128 LJQX VARCHAR2(20 BYTE),
129 DRDB VARCHAR2(32 BYTE)
130 )
131 LOGGING
132 NOCACHE
133 NOPARALLEL;
134
135
136 DROP TABLE JGGZ.CRJ_TMP CASCADE CONSTRAINTS;
137
138 CREATE TABLE JGGZ.CRJ_TMP
139 (
140 ID VARCHAR2(32 BYTE) NOT NULL,
141 ZF_ID VARCHAR2(12 BYTE),
142 RJ_DATE DATE,
143 LJ_DATE DATE,
144 DB VARCHAR2(32 BYTE),
145 LJ_TYPE VARCHAR2(12 BYTE),
146 RJ_TYPE VARCHAR2(12 BYTE),
147 C_DATE DATE,
148 U_DATE DATE,
149 DEL_FLAG CHAR(1 BYTE),
150 DDFLAG CHAR(1 BYTE),
151 LJQX VARCHAR2(20 BYTE),
152 DRDB VARCHAR2(32 BYTE)
153 )
154 LOGGING
155 NOCACHE
156 NOPARALLEL;
157
158
159 DROP TABLE JGGZ.CXPT_MBTJ CASCADE CONSTRAINTS;
160
161 CREATE TABLE JGGZ.CXPT_MBTJ
162 (
163 ID VARCHAR2(32 BYTE) NOT NULL,
164 MB_ID VARCHAR2(32 BYTE),
165 FIELD_ID VARCHAR2(32 BYTE),
166 XSZD_TITLE VARCHAR2(100 BYTE),
167 ORDERID NUMBER(12),
168 ISCHECKED CHAR(1 BYTE),
169 FIELD_CODE VARCHAR2(500 BYTE),
170 FIELD_NAME VARCHAR2(100 BYTE),
171 FIELD_SIZE NUMBER(6),
172 FIELD_TYPE NUMBER,
173 CODE_NAME VARCHAR2(6 BYTE),
174 TABLE_ID VARCHAR2(32 BYTE) NOT NULL,
175 TABLE_NAME VARCHAR2(100 BYTE),
176 TABLE_CODE VARCHAR2(40 BYTE)
177 )
178 LOGGING
179 NOCACHE
180 NOPARALLEL;
181
182
183 DROP TABLE JGGZ.DBDD_TMP CASCADE CONSTRAINTS;
184
185 CREATE TABLE JGGZ.DBDD_TMP
186 (
187 ID RAW(16),
188 ZF_ID VARCHAR2(12 BYTE),
189 DD_DATE DATE,
190 DDQ_DB CHAR(4 BYTE),
191 DDH_DB VARCHAR2(20 BYTE),
192 C_DATE DATE,
193 U_DATE DATE,
194 DEL_FLAG CHAR(1 BYTE)
195 )
196 LOGGING
197 NOCACHE
198 NOPARALLEL;
199
200
201 DROP TABLE JGGZ.DZB CASCADE CONSTRAINTS;
202
203 CREATE TABLE JGGZ.DZB
204 (
205 DANWEI VARCHAR2(20 BYTE),
206 LB VARCHAR2(2 BYTE),
207 BM VARCHAR2(8 BYTE),
208 MC VARCHAR2(54 BYTE),
209 NLB VARCHAR2(2 BYTE),
210 NBM VARCHAR2(20 BYTE),
211 NMC VARCHAR2(54 BYTE),
212 DELETED CHAR(1 BYTE),
213 STATUS CHAR(20 BYTE),
214 REMARK VARCHAR2(1000 BYTE),
215 LRM VARCHAR2(28 BYTE),
216 DWBM VARCHAR2(8 BYTE)
217 )
218 LOGGING
219 NOCACHE
220 NOPARALLEL;
221
222
223 DROP TABLE JGGZ.DZB_BM CASCADE CONSTRAINTS;
224
225 CREATE TABLE JGGZ.DZB_BM
226 (
227 SM VARCHAR2(255 BYTE),
228 BM VARCHAR2(255 BYTE),
229 NSM VARCHAR2(255 BYTE),
230 NBM VARCHAR2(255 BYTE)
231 )
232 LOGGING
233 NOCACHE
234 NOPARALLEL;
235
236
237 DROP TABLE JGGZ.DZB_JC CASCADE CONSTRAINTS;
238
239 CREATE TABLE JGGZ.DZB_JC
240 (
241 DANWEI VARCHAR2(20 BYTE),
242 LB VARCHAR2(2 BYTE),
243 BM VARCHAR2(8 BYTE),
244 MC VARCHAR2(54 BYTE),
245 NLB VARCHAR2(2 BYTE),
246 NBM VARCHAR2(20 BYTE),
247 NMC VARCHAR2(54 BYTE),
248 DELETED CHAR(1 BYTE),
249 STATUS CHAR(20 BYTE),
250 REMARK VARCHAR2(1000 BYTE),
251 LRM VARCHAR2(28 BYTE),
252 DWBM VARCHAR2(8 BYTE)
253 )
254 LOGGING
255 NOCACHE
256 NOPARALLEL;
257
258
259 ALTER TABLE JGGZ.KBH_TEMP_TABLE DROP PRIMARY KEY CASCADE;
260 DROP TABLE JGGZ.KBH_TEMP_TABLE CASCADE CONSTRAINTS;
261
262 CREATE TABLE JGGZ.KBH_TEMP_TABLE
263 (
264 KFH NUMBER,
265 FLAG VARCHAR2(1 BYTE)
266 )
267 LOGGING
268 NOCACHE
269 NOPARALLEL;
270
271
272 DROP TABLE JGGZ.PLAN_TABLE CASCADE CONSTRAINTS;
273
274 CREATE TABLE JGGZ.PLAN_TABLE
275 (
276 STATEMENT_ID VARCHAR2(30 BYTE),
277 TIMESTAMP DATE,
278 REMARKS VARCHAR2(80 BYTE),
279 OPERATION VARCHAR2(30 BYTE),
280 OPTIONS VARCHAR2(30 BYTE),
281 OBJECT_NODE VARCHAR2(128 BYTE),
282 OBJECT_OWNER VARCHAR2(30 BYTE),
283 OBJECT_NAME VARCHAR2(30 BYTE),
284 OBJECT_INSTANCE INTEGER,
285 OBJECT_TYPE VARCHAR2(30 BYTE),
286 OPTIMIZER VARCHAR2(255 BYTE),
287 SEARCH_COLUMNS NUMBER,
288 ID INTEGER,
289 PARENT_ID INTEGER,
290 POSITION INTEGER,
291 COST INTEGER,
292 CARDINALITY INTEGER,
293 BYTES INTEGER,
294 OTHER_TAG VARCHAR2(255 BYTE),
295 PARTITION_START VARCHAR2(255 BYTE),
296 PARTITION_STOP VARCHAR2(255 BYTE),
297 PARTITION_ID INTEGER,
298 OTHER LONG,
299 DISTRIBUTION VARCHAR2(30 BYTE),
300 CPU_COST INTEGER,
301 IO_COST INTEGER,
302 TEMP_SPACE INTEGER
303 )
304 LOGGING
305 NOCACHE
306 NOPARALLEL;
307
308
309 DROP TABLE JGGZ.RJ_TMP CASCADE CONSTRAINTS;
310
311 CREATE TABLE JGGZ.RJ_TMP
312 (
313 ID VARCHAR2(32 BYTE) NOT NULL,
314 ZF_ID VARCHAR2(12 BYTE),
315 RJ_DATE DATE,
316 LJ_DATE DATE,
317 DB VARCHAR2(32 BYTE),
318 LJ_TYPE VARCHAR2(12 BYTE),
319 RJ_TYPE VARCHAR2(12 BYTE),
320 C_DATE DATE,
321 U_DATE DATE,
322 DEL_FLAG CHAR(1 BYTE),
323 DDFLAG CHAR(1 BYTE),
324 LJQX VARCHAR2(20 BYTE),
325 DRDB VARCHAR2(32 BYTE)
326 )
327 LOGGING
328 NOCACHE
329 NOPARALLEL;
330
331
332 DROP TABLE JGGZ.SGSZK_TMP CASCADE CONSTRAINTS;
333
334 CREATE TABLE JGGZ.SGSZK_TMP
335 (
336 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
337 DR_DATE DATE
338 )
339 LOGGING
340 NOCACHE
341 NOPARALLEL;
342
343
344 DROP TABLE JGGZ.SQLEXPERT_PLAN1 CASCADE CONSTRAINTS;
345
346 CREATE TABLE JGGZ.SQLEXPERT_PLAN1
347 (
348 STATEMENT_ID VARCHAR2(30 BYTE),
349 TIMESTAMP DATE,
350 REMARKS VARCHAR2(80 BYTE),
351 OPERATION VARCHAR2(30 BYTE),
352 OPTIONS VARCHAR2(30 BYTE),
353 OBJECT_NODE VARCHAR2(128 BYTE),
354 OBJECT_OWNER VARCHAR2(30 BYTE),
355 OBJECT_NAME VARCHAR2(30 BYTE),
356 OBJECT_INSTANCE NUMBER,
357 OBJECT_TYPE VARCHAR2(30 BYTE),
358 OPTIMIZER VARCHAR2(255 BYTE),
359 SEARCH_COLUMNS NUMBER,
360 ID NUMBER,
361 PARENT_ID NUMBER,
362 POSITION NUMBER,
363 COST NUMBER,
364 CARDINALITY NUMBER,
365 BYTES NUMBER,
366 OTHER_TAG VARCHAR2(255 BYTE),
367 PARTITION_START VARCHAR2(255 BYTE),
368 PARTITION_STOP VARCHAR2(255 BYTE),
369 PARTITION_ID NUMBER,
370 OTHER LONG
371 )
372 LOGGING
373 NOCACHE
374 NOPARALLEL;
375
376
377 ALTER TABLE JGGZ.SYN_SQL DROP PRIMARY KEY CASCADE;
378 DROP TABLE JGGZ.SYN_SQL CASCADE CONSTRAINTS;
379
380 CREATE TABLE JGGZ.SYN_SQL
381 (
382 ID VARCHAR2(32 BYTE) NOT NULL,
383 HOST VARCHAR2(32 BYTE),
384 OP_TYPE VARCHAR2(16 BYTE) NOT NULL,
385 SQL_TXT VARCHAR2(4000 BYTE),
386 OP_DATE DATE NOT NULL
387 )
388 LOGGING
389 NOCACHE
390 NOPARALLEL;
391
392
393 DROP TABLE JGGZ.TEMP_KKK CASCADE CONSTRAINTS;
394
395 CREATE TABLE JGGZ.TEMP_KKK
396 (
397 ID VARCHAR2(64 BYTE) NOT NULL,
398 DEPID VARCHAR2(30 BYTE)
399 )
400 LOGGING
401 NOCACHE
402 NOPARALLEL;
403
404
405 DROP TABLE JGGZ.TMP_AA CASCADE CONSTRAINTS;
406
407 CREATE TABLE JGGZ.TMP_AA
408 (
409 ZF_ID VARCHAR2(32 BYTE),
410 ID VARCHAR2(32 BYTE) NOT NULL,
411 XZ_ID VARCHAR2(32 BYTE),
412 SCOREVALUE NUMBER(10,2),
413 SCOREDATE DATE,
414 DEL_FLAG CHAR(1 BYTE),
415 C_DATE DATE,
416 U_DATE DATE,
417 OPERATOR VARCHAR2(50 BYTE),
418 JFGJ VARCHAR2(50 BYTE),
419 SPJ VARCHAR2(20 BYTE),
420 JYSS VARCHAR2(200 BYTE),
421 DL VARCHAR2(50 BYTE),
422 LB VARCHAR2(2 BYTE),
423 FLAG VARCHAR2(3 BYTE),
424 DEPID VARCHAR2(30 BYTE),
425 ACCORDING VARCHAR2(300 BYTE),
426 JFGJID VARCHAR2(32 BYTE),
427 NO NUMBER
428 )
429 LOGGING
430 NOCACHE
431 NOPARALLEL;
432
433
434 DROP TABLE JGGZ.TMP_T_YZ_ZF_JK CASCADE CONSTRAINTS;
435
436 CREATE TABLE JGGZ.TMP_T_YZ_ZF_JK
437 (
438 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
439 ZF_FH VARCHAR2(5 BYTE),
440 ZF_NAME VARCHAR2(80 BYTE),
441 ZB_NAME VARCHAR2(80 BYTE),
442 ZF_GENDER VARCHAR2(32 BYTE),
443 ZF_BIRTH DATE,
444 ZF_MZ VARCHAR2(32 BYTE),
445 ZF_MARRIAGE VARCHAR2(32 BYTE),
446 PJ_NO1 VARCHAR2(50 BYTE),
447 PJ_NO2 VARCHAR2(16 BYTE),
448 ZM VARCHAR2(32 BYTE),
449 XZ VARCHAR2(32 BYTE),
450 XQ VARCHAR2(8 BYTE),
451 XQ_START_DATE DATE,
452 XQ_END_DATE DATE,
453 BZNX VARCHAR2(8 BYTE),
454 ZF_SOURCE VARCHAR2(64 BYTE),
455 FY_TYPE VARCHAR2(32 BYTE),
456 NYDW VARCHAR2(32 BYTE),
457 JY_FLAG CHAR(1 BYTE),
458 JYXQ VARCHAR2(8 BYTE),
459 JY_START_DATE DATE,
460 JY_END_DATE DATE,
461 SJ_TYPE VARCHAR2(32 BYTE),
462 SY_STATUS VARCHAR2(32 BYTE),
463 SC_CA VARCHAR2(32 BYTE),
464 HJ_ADDR_XZQH VARCHAR2(32 BYTE),
465 HJ_ADDR_DETAIL VARCHAR2(64 BYTE),
466 C_DATE DATE,
467 U_DATE DATE,
468 DEL_FLAG CHAR(1 BYTE),
469 FL_FLAG CHAR(1 BYTE),
470 C_USER VARCHAR2(32 BYTE),
471 DB VARCHAR2(32 BYTE)
472 )
473 LOGGING
474 NOCACHE
475 NOPARALLEL;
476
477
478 DROP TABLE JGGZ.TMP_T_YZ_ZF_JL CASCADE CONSTRAINTS;
479
480 CREATE TABLE JGGZ.TMP_T_YZ_ZF_JL
481 (
482 ID VARCHAR2(32 BYTE) NOT NULL,
483 ZF_ID VARCHAR2(12 BYTE),
484 START_DATE VARCHAR2(32 BYTE),
485 END_DATE VARCHAR2(32 BYTE),
486 DW_ADDR_XZQH VARCHAR2(32 BYTE),
487 DW_ADDR_DETAIL VARCHAR2(200 BYTE),
488 DW_MC VARCHAR2(200 BYTE),
489 ZF_ZY VARCHAR2(32 BYTE),
490 ZF_ZW VARCHAR2(32 BYTE),
491 MEMO VARCHAR2(4000 BYTE),
492 C_DATE DATE,
493 U_DATE DATE,
494 DEL_FLAG CHAR(1 BYTE),
495 HJ_XZQH VARCHAR2(32 BYTE),
496 HJ_DETAIL VARCHAR2(64 BYTE),
497 XH VARCHAR2(10 BYTE)
498 )
499 LOGGING
500 NOCACHE
501 NOPARALLEL;
502
503
504 DROP TABLE JGGZ.TMP_T_YZ_ZF_LBC CASCADE CONSTRAINTS;
505
506 CREATE TABLE JGGZ.TMP_T_YZ_ZF_LBC
507 (
508 LBC_NO VARCHAR2(32 BYTE) NOT NULL,
509 SP_ID VARCHAR2(10 BYTE),
510 ZF_ID VARCHAR2(12 BYTE),
511 LBCSP_NO VARCHAR2(32 BYTE),
512 LBC_TYPE VARCHAR2(6 BYTE),
513 SICK_HISTORY VARCHAR2(4000 BYTE),
514 BC_TYPE VARCHAR2(6 BYTE),
515 DJ_DATE DATE,
516 SC_INFO VARCHAR2(2000 BYTE),
517 BC_YJ VARCHAR2(4000 BYTE),
518 HOSPITAL_YJ VARCHAR2(4000 BYTE),
519 HOSPITAL_DATE DATE,
520 CXLBC_DATE DATE,
521 JD_YS1 VARCHAR2(20 BYTE),
522 YS_ZW1 VARCHAR2(6 BYTE),
523 YS_ZC1 VARCHAR2(6 BYTE),
524 JD_YS2 VARCHAR2(20 BYTE),
525 YS_ZW2 VARCHAR2(6 BYTE),
526 YS_ZC2 VARCHAR2(6 BYTE),
527 JD_YS3 VARCHAR2(20 BYTE),
528 YS_ZW3 VARCHAR2(6 BYTE),
529 YS_ZC3 VARCHAR2(6 BYTE),
530 C_DATE DATE,
531 U_DATE DATE,
532 DEL_FLAG CHAR(1 BYTE)
533 )
534 LOGGING
535 NOCACHE
536 NOPARALLEL;
537
538
539 DROP TABLE JGGZ.TMP_T_YZ_ZF_SHGX CASCADE CONSTRAINTS;
540
541 CREATE TABLE JGGZ.TMP_T_YZ_ZF_SHGX
542 (
543 ZF_ID VARCHAR2(12 BYTE),
544 SHGX_NO VARCHAR2(32 BYTE) NOT NULL,
545 GX_NAME VARCHAR2(100 BYTE),
546 NAME VARCHAR2(64 BYTE),
547 AGE VARCHAR2(12 BYTE),
548 GENDER VARCHAR2(64 BYTE),
549 DW VARCHAR2(64 BYTE),
550 DW_ADDR_XZQH VARCHAR2(64 BYTE),
551 DW_ADDR_DETAIL VARCHAR2(200 BYTE),
552 ZW VARCHAR2(64 BYTE),
553 ZZD_ADDR_XZQH VARCHAR2(64 BYTE),
554 ZZD_ADDR_DETIAL VARCHAR2(200 BYTE),
555 ZZMM VARCHAR2(64 BYTE),
556 ZJ_TYPE VARCHAR2(64 BYTE),
557 ZJ_NO VARCHAR2(36 BYTE),
558 TELEPHONE VARCHAR2(50 BYTE),
559 C_DATE DATE,
560 U_DATE DATE,
561 DEL_FLAG CHAR(1 BYTE),
562 XH VARCHAR2(32 BYTE)
563 )
564 LOGGING
565 NOCACHE
566 NOPARALLEL;
567
568
569 DROP TABLE JGGZ.TMP_T_YZ_ZF_TC CASCADE CONSTRAINTS;
570
571 CREATE TABLE JGGZ.TMP_T_YZ_ZF_TC
572 (
573 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
574 TC_CODE VARCHAR2(32 BYTE),
575 TC VARCHAR2(100 BYTE) NOT NULL,
576 C_DATE DATE,
577 U_DATE DATE,
578 DEL_FLAG CHAR(1 BYTE)
579 )
580 LOGGING
581 NOCACHE
582 NOPARALLEL;
583
584
585 DROP TABLE JGGZ.TMP_T_YZ_ZF_TG CASCADE CONSTRAINTS;
586
587 CREATE TABLE JGGZ.TMP_T_YZ_ZF_TG
588 (
589 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
590 TGLB VARCHAR2(20 BYTE) NOT NULL,
591 XH VARCHAR2(5 BYTE)
592 )
593 LOGGING
594 NOCACHE
595 NOPARALLEL;
596
597
598 DROP TABLE JGGZ.TMP_T_YZ_ZF_TMTZ CASCADE CONSTRAINTS;
599
600 CREATE TABLE JGGZ.TMP_T_YZ_ZF_TMTZ
601 (
602 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
603 HEIGHT VARCHAR2(10 BYTE),
604 BODY_TYPE VARCHAR2(32 BYTE),
605 BLOOD_TYPE VARCHAR2(32 BYTE),
606 FACE_TYPE VARCHAR2(32 BYTE),
607 ACCENT VARCHAR2(50 BYTE),
608 FOOT_LEN VARCHAR2(10 BYTE),
609 SKIN_FEATURE VARCHAR2(1000 BYTE),
610 CHARACTER VARCHAR2(256 BYTE),
611 C_DATE DATE,
612 U_DATE DATE,
613 DEL_FLAG CHAR(1 BYTE)
614 )
615 LOGGING
616 NOCACHE
617 NOPARALLEL;
618
619
620 DROP TABLE JGGZ.TMP_T_YZ_ZF_XQBG CASCADE CONSTRAINTS;
621
622 CREATE TABLE JGGZ.TMP_T_YZ_ZF_XQBG
623 (
624 XQBG_NO VARCHAR2(32 BYTE) NOT NULL,
625 ZF_ID VARCHAR2(12 BYTE),
626 SPB_NO VARCHAR2(32 BYTE),
627 BD_TYPE VARCHAR2(20 BYTE),
628 JYJ_PZ_DATE DATE,
629 PJ_DATE DATE,
630 PJ_NO1 VARCHAR2(32 BYTE),
631 PJ_NO2 VARCHAR2(32 BYTE),
632 PJ_JG VARCHAR2(50 BYTE),
633 PJ_XZQH VARCHAR2(32 BYTE),
634 CD_FD VARCHAR2(32 BYTE),
635 BZ_NX VARCHAR2(8 BYTE),
636 XZ VARCHAR2(20 BYTE),
637 SJ_XQ VARCHAR2(32 BYTE),
638 YXQ VARCHAR2(8 BYTE),
639 YBZNX VARCHAR2(8 BYTE),
640 YXZ VARCHAR2(20 BYTE),
641 YXQ_START_DATE DATE,
642 YXQ_END_DATE DATE,
643 START_DATE DATE,
644 END_DATE DATE,
645 ZX_DATE DATE,
646 CD_SJ_QK VARCHAR2(4000 BYTE),
647 SPB_TYPE CHAR(1 BYTE),
648 MEMO VARCHAR2(4000 BYTE),
649 C_DATE DATE,
650 U_DATE DATE,
651 DEL_FLAG CHAR(1 BYTE),
652 YPJ_NO1 VARCHAR2(32 BYTE),
653 YPJ_NO2 VARCHAR2(32 BYTE),
654 YPJ_JG VARCHAR2(50 BYTE),
655 YPJ_XZQH VARCHAR2(32 BYTE),
656 YPJ_DATE DATE,
657 C_USER VARCHAR2(32 BYTE),
658 SZ_DB VARCHAR2(32 BYTE),
659 CB_DATE DATE
660 )
661 LOGGING
662 NOCACHE
663 NOPARALLEL;
664
665
666 DROP TABLE JGGZ.TMP_T_YZ_ZF_ZK CASCADE CONSTRAINTS;
667
668 CREATE TABLE JGGZ.TMP_T_YZ_ZF_ZK
669 (
670 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
671 ZF_ADDR_XZQH VARCHAR2(32 BYTE),
672 ZF_ADDR_DETAIL VARCHAR2(64 BYTE),
673 FILE_NO VARCHAR2(16 BYTE),
674 RJ_DATE DATE,
675 DR_DATE DATE,
676 BH_NAME VARCHAR2(64 BYTE),
677 BQWH VARCHAR2(32 BYTE),
678 XWH VARCHAR2(32 BYTE),
679 BQZY VARCHAR2(32 BYTE),
680 BQMM VARCHAR2(32 BYTE),
681 ZF_NATION VARCHAR2(32 BYTE),
682 PCS VARCHAR2(32 BYTE),
683 JD VARCHAR2(32 BYTE),
684 SY_TYPE VARCHAR2(32 BYTE),
685 DBJG_XZQH VARCHAR2(32 BYTE),
686 DBJG_ZXJG VARCHAR2(50 BYTE),
687 DB_DATE DATE,
688 PJJG_XZQH VARCHAR2(32 BYTE),
689 PJJG_ZXJG VARCHAR2(50 BYTE),
690 PJ_DATE DATE,
691 YAF_TYPE VARCHAR2(32 BYTE),
692 XAF_TYPE VARCHAR2(32 BYTE),
693 YS_DEPT_XZQH VARCHAR2(32 BYTE),
694 YS_DEPT VARCHAR2(32 BYTE),
695 YS_NO1 VARCHAR2(32 BYTE),
696 YS_NO2 VARCHAR2(32 BYTE),
697 LJ_TIMES VARCHAR2(4 BYTE),
698 QK_TIMES VARCHAR2(4 BYTE),
699 LGF VARCHAR2(32 BYTE),
700 DB VARCHAR2(32 BYTE),
701 FG_LEVEL VARCHAR2(32 BYTE),
702 WORKER_LEVEL VARCHAR2(32 BYTE),
703 GZ VARCHAR2(50 BYTE),
704 NWFG VARCHAR2(50 BYTE),
705 ID_CARD VARCHAR2(36 BYTE),
706 HK_TYPE VARCHAR2(32 BYTE),
707 LC_TYPE VARCHAR2(32 BYTE),
708 JX_MEASURE VARCHAR2(32 BYTE),
709 LBC_FLAG VARCHAR2(32 BYTE),
710 CUR_START_DATE DATE,
711 CUR_END_DATE DATE,
712 CUR_BZNX VARCHAR2(8 BYTE),
713 CUR_XZ VARCHAR2(32 BYTE),
714 CURRENT_XQ VARCHAR2(8 BYTE),
715 LAST_START_DATE DATE,
716 LAST_END_DATE DATE,
717 LAST_FX_XZQH VARCHAR2(32 BYTE),
718 LAST_FX_JY VARCHAR2(64 BYTE),
719 JXHG_FLAG CHAR(1 BYTE),
720 SS_FLAG CHAR(1 BYTE),
721 TC VARCHAR2(1000 BYTE),
722 FJ VARCHAR2(100 BYTE),
723 C_DATE DATE,
724 U_DATE DATE,
725 DEL_FLAG CHAR(1 BYTE)
726 )
727 LOGGING
728 NOCACHE
729 NOPARALLEL;
730
731
732 DROP TABLE JGGZ.TMP_T_YZ_ZF_ZM CASCADE CONSTRAINTS;
733
734 CREATE TABLE JGGZ.TMP_T_YZ_ZF_ZM
735 (
736 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
737 ZM_CODE VARCHAR2(6 BYTE) NOT NULL,
738 ZM_SEQ NUMBER(2),
739 C_DATE DATE,
740 U_DATE DATE,
741 DEL_FLAG CHAR(1 BYTE)
742 )
743 LOGGING
744 NOCACHE
745 NOPARALLEL;
746
747
748 DROP TABLE JGGZ.TMP_T_YZ_ZF_ZMBK CASCADE CONSTRAINTS;
749
750 CREATE TABLE JGGZ.TMP_T_YZ_ZF_ZMBK
751 (
752 XQBGNO VARCHAR2(32 BYTE) NOT NULL,
753 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
754 XH VARCHAR2(5 BYTE),
755 ZM VARCHAR2(20 BYTE) NOT NULL
756 )
757 LOGGING
758 NOCACHE
759 NOPARALLEL;
760
761
762 DROP TABLE JGGZ.TMP_ZC_ZF_ID CASCADE CONSTRAINTS;
763
764 CREATE TABLE JGGZ.TMP_ZC_ZF_ID
765 (
766 ZF_ID VARCHAR2(12 BYTE)
767 )
768 LOGGING
769 NOCACHE
770 NOPARALLEL;
771
772
773 DROP TABLE JGGZ.TMP_ZFLJ_3112_60 CASCADE CONSTRAINTS;
774
775 CREATE TABLE JGGZ.TMP_ZFLJ_3112_60
776 (
777 ID VARCHAR2(32 BYTE) NOT NULL,
778 ZF_ID VARCHAR2(12 BYTE),
779 LJ_TYPE VARCHAR2(20 BYTE),
780 LJ_DOC_NO VARCHAR2(64 BYTE),
781 LJ_ADDR_XZQH VARCHAR2(16 BYTE),
782 LJ_ADDR_DETAIL VARCHAR2(256 BYTE),
783 LJ_POL VARCHAR2(32 BYTE),
784 LJ_DATE DATE,
785 PJ_NO1 VARCHAR2(16 BYTE),
786 PJ_NO2 VARCHAR2(32 BYTE),
787 PJXZQH VARCHAR2(32 BYTE),
788 PJJG VARCHAR2(32 BYTE),
789 PJDATE DATE,
790 C_USER VARCHAR2(64 BYTE),
791 LJ_STATUS CHAR(1 BYTE),
792 SJ_DATE DATE,
793 DR_DATE DATE,
794 YDB VARCHAR2(32 BYTE),
795 MEMO VARCHAR2(1000 BYTE),
796 C_DATE DATE,
797 U_DATE DATE,
798 DEL_FLAG CHAR(1 BYTE)
799 )
800 LOGGING
801 NOCACHE
802 NOPARALLEL;
803
804
805 DROP TABLE JGGZ.TMP_ZFLJ_ID CASCADE CONSTRAINTS;
806
807 CREATE TABLE JGGZ.TMP_ZFLJ_ID
808 (
809 ID VARCHAR2(32 BYTE)
810 )
811 LOGGING
812 NOCACHE
813 NOPARALLEL;
814
815
816 ALTER TABLE JGGZ.T_JXJS_BM_BL DROP PRIMARY KEY CASCADE;
817 DROP TABLE JGGZ.T_JXJS_BM_BL CASCADE CONSTRAINTS;
818
819 CREATE TABLE JGGZ.T_JXJS_BM_BL
820 (
821 ID VARCHAR2(200 BYTE),
822 NAME VARCHAR2(500 BYTE),
823 MEMO VARCHAR2(4000 BYTE),
824 TYPE VARCHAR2(100 BYTE)
825 )
826 LOGGING
827 NOCACHE
828 NOPARALLEL;
829
830
831 ALTER TABLE JGGZ.T_JXJS_FY_BM DROP PRIMARY KEY CASCADE;
832 DROP TABLE JGGZ.T_JXJS_FY_BM CASCADE CONSTRAINTS;
833
834 CREATE TABLE JGGZ.T_JXJS_FY_BM
835 (
836 ID VARCHAR2(32 BYTE),
837 NAME VARCHAR2(500 BYTE),
838 BM_ID VARCHAR2(500 BYTE),
839 MEMO VARCHAR2(4000 BYTE)
840 )
841 LOGGING
842 NOCACHE
843 NOPARALLEL;
844
845
846 ALTER TABLE JGGZ.T_JXJS_JY_BM DROP PRIMARY KEY CASCADE;
847 DROP TABLE JGGZ.T_JXJS_JY_BM CASCADE CONSTRAINTS;
848
849 CREATE TABLE JGGZ.T_JXJS_JY_BM
850 (
851 ID VARCHAR2(32 BYTE),
852 NAME VARCHAR2(500 BYTE),
853 BM_ID VARCHAR2(500 BYTE),
854 MEMO VARCHAR2(4000 BYTE)
855 )
856 LOGGING
857 NOCACHE
858 NOPARALLEL;
859
860
861 ALTER TABLE JGGZ.T_REPORT_DATA DROP PRIMARY KEY CASCADE;
862 DROP TABLE JGGZ.T_REPORT_DATA CASCADE CONSTRAINTS;
863
864 CREATE TABLE JGGZ.T_REPORT_DATA
865 (
866 COL_NUM NUMBER(5),
867 ROW_NUM NUMBER(5),
868 VAL VARCHAR2(512 BYTE),
869 C_TIME DATE,
870 SESSION_ID VARCHAR2(32 BYTE),
871 PAGE_NUM NUMBER(5),
872 ID VARCHAR2(32 BYTE) DEFAULT sys_guid() NOT NULL
873 )
874 LOGGING
875 NOCACHE
876 NOPARALLEL;
877
878
879 ALTER TABLE JGGZ.T_REPORT_PROCEDURE DROP PRIMARY KEY CASCADE;
880 DROP TABLE JGGZ.T_REPORT_PROCEDURE CASCADE CONSTRAINTS;
881
882 CREATE TABLE JGGZ.T_REPORT_PROCEDURE
883 (
884 ID VARCHAR2(32 BYTE),
885 REPORT_NAME VARCHAR2(50 BYTE),
886 PROCEDURE_NAMES VARCHAR2(1000 BYTE),
887 CATEGORY_ID VARCHAR2(2 BYTE),
888 REPORT_DESC VARCHAR2(50 BYTE)
889 )
890 LOGGING
891 NOCACHE
892 NOPARALLEL;
893
894
895 ALTER TABLE JGGZ.T_SYS_JFKH_AUTOYJ DROP PRIMARY KEY CASCADE;
896 DROP TABLE JGGZ.T_SYS_JFKH_AUTOYJ CASCADE CONSTRAINTS;
897
898 CREATE TABLE JGGZ.T_SYS_JFKH_AUTOYJ
899 (
900 JYBM VARCHAR2(12 BYTE) NOT NULL,
901 STARTDATE VARCHAR2(2 BYTE) DEFAULT -1,
902 AUTOFLAG VARCHAR2(1 BYTE) DEFAULT 0,
903 JFGJID VARCHAR2(64 BYTE),
904 U_DATE DATE,
905 OPUSER VARCHAR2(64 BYTE),
906 STARTTIME NUMBER(2) DEFAULT 18,
907 DELAYTIME NUMBER DEFAULT 3600000
908 )
909 LOGGING
910 NOCACHE
911 NOPARALLEL;
912
913
914 ALTER TABLE JGGZ.T_YZ_AUTHORITY_TEST DROP PRIMARY KEY CASCADE;
915 DROP TABLE JGGZ.T_YZ_AUTHORITY_TEST CASCADE CONSTRAINTS;
916
917 CREATE TABLE JGGZ.T_YZ_AUTHORITY_TEST
918 (
919 AUTH_ID VARCHAR2(32 BYTE) DEFAULT sys_guid() NOT NULL,
920 PARENT_AUTH_ID VARCHAR2(32 BYTE),
921 AUTH_NAME VARCHAR2(50 BYTE),
922 AUTH_TYPE VARCHAR2(6 BYTE),
923 AUTH_URL VARCHAR2(256 BYTE),
924 RIGHT CHAR(1 BYTE),
925 C_DATE DATE,
926 U_DATE DATE,
927 DEL_FLAG CHAR(1 BYTE),
928 SXH VARCHAR2(15 BYTE)
929 )
930 NOLOGGING
931 NOCACHE
932 NOPARALLEL;
933
934
935 DROP TABLE JGGZ.T_YZ_COL_COMMENTS CASCADE CONSTRAINTS;
936
937 CREATE TABLE JGGZ.T_YZ_COL_COMMENTS
938 (
939 ID VARCHAR2(32 BYTE) DEFAULT sys_guid(),
940 TABLE_NAME VARCHAR2(30 BYTE),
941 COLUMN_NAME VARCHAR2(30 BYTE),
942 COMMENTS VARCHAR2(4000 BYTE)
943 )
944 NOLOGGING
945 NOCACHE
946 NOPARALLEL;
947
948
949 ALTER TABLE JGGZ.T_YZ_CXPT_DXKTJ DROP PRIMARY KEY CASCADE;
950 DROP TABLE JGGZ.T_YZ_CXPT_DXKTJ CASCADE CONSTRAINTS;
951
952 CREATE TABLE JGGZ.T_YZ_CXPT_DXKTJ
953 (
954 MBTJ_ID VARCHAR2(32 BYTE) NOT NULL,
955 TJ_ITEM_NUM NUMBER,
956 TJ_ITEM_VALUE VARCHAR2(100 BYTE),
957 TJ_ITEM_TITLE VARCHAR2(100 BYTE)
958 )
959 NOLOGGING
960 NOCACHE
961 NOPARALLEL;
962
963
964 ALTER TABLE JGGZ.T_YZ_CXPT_FXKTJ DROP PRIMARY KEY CASCADE;
965 DROP TABLE JGGZ.T_YZ_CXPT_FXKTJ CASCADE CONSTRAINTS;
966
967 CREATE TABLE JGGZ.T_YZ_CXPT_FXKTJ
968 (
969 MBTJ_ID VARCHAR2(32 BYTE) NOT NULL,
970 TJ_ITEM_NUM NUMBER,
971 TJ_ITEM_VALUE VARCHAR2(100 BYTE),
972 TJ_ITEM_TITLE VARCHAR2(100 BYTE)
973 )
974 NOLOGGING
975 NOCACHE
976 NOPARALLEL;
977
978
979 ALTER TABLE JGGZ.T_YZ_CXPT_MB DROP PRIMARY KEY CASCADE;
980 DROP TABLE JGGZ.T_YZ_CXPT_MB CASCADE CONSTRAINTS;
981
982 CREATE TABLE JGGZ.T_YZ_CXPT_MB
983 (
984 MB_ID VARCHAR2(32 BYTE) NOT NULL,
985 U_DATE DATE,
986 MB_NAME VARCHAR2(100 BYTE),
987 IS_JION CHAR(1 BYTE),
988 IS_SQL CHAR(1 BYTE),
989 SELECT_SQL VARCHAR2(4000 BYTE),
990 FROM_SQL VARCHAR2(4000 BYTE),
991 WHERE_SQL VARCHAR2(4000 BYTE),
992 GROUP_SQL VARCHAR2(4000 BYTE),
993 ORDER_SQL VARCHAR2(4000 BYTE),
994 ZF_URL VARCHAR2(4000 BYTE),
995 MOD_URL VARCHAR2(4000 BYTE),
996 MOD_ID VARCHAR2(4000 BYTE),
997 DEL_URL VARCHAR2(4000 BYTE),
998 IS_COUNT CHAR(1 BYTE) DEFAULT '0',
999 IS_KP CHAR(1 BYTE),
1000 MB_TAB VARCHAR2(64 BYTE)
1001 )
1002 NOLOGGING
1003 NOCACHE
1004 NOPARALLEL;
1005
1006
1007 ALTER TABLE JGGZ.T_YZ_CXPT_MBGL DROP PRIMARY KEY CASCADE;
1008 DROP TABLE JGGZ.T_YZ_CXPT_MBGL CASCADE CONSTRAINTS;
1009
1010 CREATE TABLE JGGZ.T_YZ_CXPT_MBGL
1011 (
1012 ID NUMBER NOT NULL,
1013 MB_ID NUMBER,
1014 FIRST_FIELD_ID NUMBER,
1015 SECOND_FIELD_ID NUMBER
1016 )
1017 NOLOGGING
1018 NOCACHE
1019 NOPARALLEL;
1020
1021
1022 ALTER TABLE JGGZ.T_YZ_CXPT_MBPX DROP PRIMARY KEY CASCADE;
1023 DROP TABLE JGGZ.T_YZ_CXPT_MBPX CASCADE CONSTRAINTS;
1024
1025 CREATE TABLE JGGZ.T_YZ_CXPT_MBPX
1026 (
1027 ID VARCHAR2(32 BYTE) NOT NULL,
1028 MB_ID VARCHAR2(32 BYTE),
1029 FIELD_ID VARCHAR2(32 BYTE),
1030 PX_CONTENT NUMBER(10),
1031 PX_NAME VARCHAR2(32 BYTE)
1032 )
1033 NOLOGGING
1034 NOCACHE
1035 NOPARALLEL;
1036
1037
1038 ALTER TABLE JGGZ.T_YZ_CXPT_MBTJ DROP PRIMARY KEY CASCADE;
1039 DROP TABLE JGGZ.T_YZ_CXPT_MBTJ CASCADE CONSTRAINTS;
1040
1041 CREATE TABLE JGGZ.T_YZ_CXPT_MBTJ
1042 (
1043 MBTJ_ID VARCHAR2(32 BYTE) NOT NULL,
1044 MB_ID VARCHAR2(32 BYTE),
1045 FIELD_ID VARCHAR2(32 BYTE),
1046 XS_TYPE NUMBER,
1047 XS_TITLE VARCHAR2(100 BYTE),
1048 ORDERID NUMBER(12),
1049 FIELD_CODE VARCHAR2(200 BYTE),
1050 FIELD_TYPE VARCHAR2(200 BYTE),
1051 FIELD_SIZE VARCHAR2(200 BYTE),
1052 FIELDNAME VARCHAR2(200 BYTE),
1053 CODE_NAME VARCHAR2(200 BYTE),
1054 IS_SQL VARCHAR2(200 BYTE),
1055 ZH_FIELD VARCHAR2(200 BYTE),
1056 TABLE_ID VARCHAR2(200 BYTE),
1057 TABNAME VARCHAR2(200 BYTE),
1058 TABCODE VARCHAR2(200 BYTE),
1059 TEMP_SQL VARCHAR2(4000 BYTE),
1060 APPEND_TYPE VARCHAR2(100 BYTE)
1061 )
1062 NOLOGGING
1063 NOCACHE
1064 NOPARALLEL;
1065
1066
1067 ALTER TABLE JGGZ.T_YZ_CXPT_MBXGB DROP PRIMARY KEY CASCADE;
1068 DROP TABLE JGGZ.T_YZ_CXPT_MBXGB CASCADE CONSTRAINTS;
1069
1070 CREATE TABLE JGGZ.T_YZ_CXPT_MBXGB
1071 (
1072 MBXGB_ID VARCHAR2(32 BYTE) NOT NULL,
1073 MB_ID VARCHAR2(32 BYTE),
1074 TABLE_ID VARCHAR2(32 BYTE),
1075 U_DATE DATE
1076 )
1077 NOLOGGING
1078 NOCACHE
1079 NOPARALLEL;
1080
1081
1082 ALTER TABLE JGGZ.T_YZ_CXPT_MBXSZD DROP PRIMARY KEY CASCADE;
1083 DROP TABLE JGGZ.T_YZ_CXPT_MBXSZD CASCADE CONSTRAINTS;
1084
1085 CREATE TABLE JGGZ.T_YZ_CXPT_MBXSZD
1086 (
1087 ID VARCHAR2(32 BYTE) NOT NULL,
1088 MB_ID VARCHAR2(32 BYTE),
1089 FIELD_ID VARCHAR2(32 BYTE),
1090 XSZD_TITLE VARCHAR2(100 BYTE),
1091 ORDERID NUMBER(12),
1092 ISCHECKED CHAR(1 BYTE),
1093 FIELD_CODE VARCHAR2(500 BYTE),
1094 FIELD_NAME VARCHAR2(100 BYTE),
1095 FIELD_SIZE NUMBER(6),
1096 FIELD_TYPE NUMBER,
1097 CODE_NAME VARCHAR2(6 BYTE),
1098 TABLE_ID VARCHAR2(32 BYTE) NOT NULL,
1099 TABLE_NAME VARCHAR2(100 BYTE),
1100 TABLE_CODE VARCHAR2(40 BYTE),
1101 ZH_FIELD VARCHAR2(32 BYTE),
1102 GROUP_SYMBOL VARCHAR2(32 BYTE),
1103 OBLIGATE_FIELD_1 VARCHAR2(100 BYTE),
1104 OBLIGATE_FIELD_2 VARCHAR2(100 BYTE),
1105 OBLIGATE_FIELD_3 VARCHAR2(100 BYTE),
1106 OBLIGATE_FIELD_4 VARCHAR2(100 BYTE),
1107 OBLIGATE_FIELD_5 VARCHAR2(100 BYTE),
1108 OBLIGATE_FIELD_6 VARCHAR2(100 BYTE)
1109 )
1110 LOGGING
1111 NOCACHE
1112 NOPARALLEL;
1113
1114
1115 ALTER TABLE JGGZ.T_YZ_CXPT_NOOUTLINKTAB DROP PRIMARY KEY CASCADE;
1116 DROP TABLE JGGZ.T_YZ_CXPT_NOOUTLINKTAB CASCADE CONSTRAINTS;
1117
1118 CREATE TABLE JGGZ.T_YZ_CXPT_NOOUTLINKTAB
1119 (
1120 ID VARCHAR2(32 BYTE) NOT NULL,
1121 MB_ID VARCHAR2(32 BYTE) NOT NULL,
1122 TABLE_ID VARCHAR2(32 BYTE) NOT NULL,
1123 U_DATE DATE NOT NULL
1124 )
1125 LOGGING
1126 NOCACHE
1127 NOPARALLEL;
1128
1129
1130 ALTER TABLE JGGZ.T_YZ_CXPT_SYS_FIELD DROP PRIMARY KEY CASCADE;
1131 DROP TABLE JGGZ.T_YZ_CXPT_SYS_FIELD CASCADE CONSTRAINTS;
1132
1133 CREATE TABLE JGGZ.T_YZ_CXPT_SYS_FIELD
1134 (
1135 FIELD_ID VARCHAR2(32 BYTE) NOT NULL,
1136 TABLE_ID VARCHAR2(32 BYTE),
1137 CN_NAME VARCHAR2(100 BYTE),
1138 EN_NAME VARCHAR2(500 BYTE),
1139 IS_KEY NUMBER,
1140 TYPE NUMBER,
1141 FIELD_SIZE NUMBER(6),
1142 IS_CODE NUMBER,
1143 CODE_NAME VARCHAR2(6 BYTE),
1144 U_DATE DATE,
1145 ZH_FIELD VARCHAR2(32 BYTE),
1146 IS_SQL CHAR(1 BYTE),
1147 TEMP_SQL VARCHAR2(4000 BYTE),
1148 GROUP_FLAG VARCHAR2(32 BYTE),
1149 EXTEND_FIELD_1 VARCHAR2(100 BYTE),
1150 EXTEND_FIELD_2 VARCHAR2(100 BYTE),
1151 EXTEND_FIELD_3 VARCHAR2(100 BYTE),
1152 EXTEND_FIELD_4 VARCHAR2(100 BYTE),
1153 EXTEND_FIELD_5 VARCHAR2(100 BYTE),
1154 EXTEND_FIELD_6 VARCHAR2(100 BYTE)
1155 )
1156 LOGGING
1157 NOCACHE
1158 NOPARALLEL;
1159
1160
1161 ALTER TABLE JGGZ.T_YZ_CXPT_SYS_TABLE DROP PRIMARY KEY CASCADE;
1162 DROP TABLE JGGZ.T_YZ_CXPT_SYS_TABLE CASCADE CONSTRAINTS;
1163
1164 CREATE TABLE JGGZ.T_YZ_CXPT_SYS_TABLE
1165 (
1166 TABLE_ID VARCHAR2(32 BYTE) NOT NULL,
1167 CN_NAME VARCHAR2(100 BYTE),
1168 EN_NAME VARCHAR2(40 BYTE),
1169 U_DATE DATE,
1170 TEMP_NAME VARCHAR2(4000 BYTE)
1171 )
1172 NOLOGGING
1173 NOCACHE
1174 NOPARALLEL;
1175
1176
1177 DROP TABLE JGGZ.T_YZ_CXPT_XSZDMR CASCADE CONSTRAINTS;
1178
1179 CREATE TABLE JGGZ.T_YZ_CXPT_XSZDMR
1180 (
1181 ID VARCHAR2(32 BYTE) NOT NULL,
1182 XSZD_ID VARCHAR2(32 BYTE),
1183 MB_ID VARCHAR2(32 BYTE),
1184 USER_ID VARCHAR2(32 BYTE)
1185 )
1186 LOGGING
1187 NOCACHE
1188 NOPARALLEL;
1189
1190
1191 ALTER TABLE JGGZ.T_YZ_CXPT_ZHXTJ DROP PRIMARY KEY CASCADE;
1192 DROP TABLE JGGZ.T_YZ_CXPT_ZHXTJ CASCADE CONSTRAINTS;
1193
1194 CREATE TABLE JGGZ.T_YZ_CXPT_ZHXTJ
1195 (
1196 FIELD_ID VARCHAR2(32 BYTE) NOT NULL,
1197 MBTJ_ID VARCHAR2(32 BYTE) NOT NULL
1198 )
1199 NOLOGGING
1200 NOCACHE
1201 NOPARALLEL;
1202
1203
1204 ALTER TABLE JGGZ.T_YZ_DEPT_TEST DROP PRIMARY KEY CASCADE;
1205 DROP TABLE JGGZ.T_YZ_DEPT_TEST CASCADE CONSTRAINTS;
1206
1207 CREATE TABLE JGGZ.T_YZ_DEPT_TEST
1208 (
1209 DEPT_ID VARCHAR2(100 BYTE) NOT NULL,
1210 DEPT_SERIAL VARCHAR2(100 BYTE),
1211 DEPT_NAME VARCHAR2(100 BYTE),
1212 DEPT_DESC VARCHAR2(200 BYTE),
1213 C_DATE DATE,
1214 U_DATE DATE,
1215 DEL_FLAG CHAR(1 BYTE),
1216 DEPT_BM VARCHAR2(16 BYTE) NOT NULL,
1217 FILTER_CODE VARCHAR2(512 BYTE)
1218 )
1219 NOLOGGING
1220 NOCACHE
1221 NOPARALLEL;
1222
1223
1224 ALTER TABLE JGGZ.T_YZ_JFKH_DJG DROP PRIMARY KEY CASCADE;
1225 DROP TABLE JGGZ.T_YZ_JFKH_DJG CASCADE CONSTRAINTS;
1226
1227 CREATE TABLE JGGZ.T_YZ_JFKH_DJG
1228 (
1229 ID VARCHAR2(64 BYTE),
1230 ZF_ID VARCHAR2(12 BYTE),
1231 DJ VARCHAR2(20 BYTE),
1232 LXID VARCHAR2(64 BYTE),
1233 YEAR VARCHAR2(4 BYTE),
1234 MONTH VARCHAR2(2 BYTE),
1235 C_DATE DATE,
1236 U_DATE DATE,
1237 DEL_FLAG VARCHAR2(1 BYTE)
1238 )
1239 LOGGING
1240 NOCACHE
1241 NOPARALLEL;
1242
1243
1244 ALTER TABLE JGGZ.T_YZ_JFKH_FJCY_CONFIG DROP PRIMARY KEY CASCADE;
1245 DROP TABLE JGGZ.T_YZ_JFKH_FJCY_CONFIG CASCADE CONSTRAINTS;
1246
1247 CREATE TABLE JGGZ.T_YZ_JFKH_FJCY_CONFIG
1248 (
1249 JB VARCHAR2(16 BYTE) NOT NULL,
1250 LJF VARCHAR2(8 BYTE),
1251 YCKF VARCHAR2(8 BYTE),
1252 LJKF VARCHAR2(8 BYTE)
1253 )
1254 LOGGING
1255 NOCACHE
1256 NOPARALLEL;
1257
1258
1259 DROP TABLE JGGZ.T_YZ_JFKH_FJQ CASCADE CONSTRAINTS;
1260
1261 CREATE TABLE JGGZ.T_YZ_JFKH_FJQ
1262 (
1263 ID VARCHAR2(32 BYTE) NOT NULL,
1264 DEP_ID VARCHAR2(32 BYTE),
1265 RJF FLOAT(126) DEFAULT 5,
1266 FDF FLOAT(126) DEFAULT 0,
1267 C_DATE DATE,
1268 U_DATE DATE,
1269 DEL_FLAG CHAR(1 BYTE),
1270 DEP_NAME VARCHAR2(100 BYTE),
1271 PARENT_ID VARCHAR2(50 BYTE),
1272 JZ_FLAG VARCHAR2(10 BYTE) DEFAULT 0
1273 )
1274 LOGGING
1275 NOCACHE
1276 NOPARALLEL;
1277
1278
1279 DROP TABLE JGGZ.T_YZ_JFKH_JC CASCADE CONSTRAINTS;
1280
1281 CREATE TABLE JGGZ.T_YZ_JFKH_JC
1282 (
1283 ID VARCHAR2(32 BYTE),
1284 ZF_ID VARCHAR2(32 BYTE),
1285 JC VARCHAR2(100 BYTE),
1286 JC_REASON VARCHAR2(300 BYTE),
1287 JC_DATE DATE,
1288 AUTO_FLAG CHAR(1 BYTE),
1289 C_DATE DATE,
1290 U_DATE DATE,
1291 DEL_FLAG CHAR(1 BYTE),
1292 GJ VARCHAR2(32 BYTE),
1293 OPERATOR VARCHAR2(32 BYTE)
1294 )
1295 LOGGING
1296 NOCACHE
1297 NOPARALLEL;
1298
1299
1300 DROP TABLE JGGZ.T_YZ_JFKH_JZ CASCADE CONSTRAINTS;
1301
1302 CREATE TABLE JGGZ.T_YZ_JFKH_JZ
1303 (
1304 ID VARCHAR2(30 BYTE) NOT NULL,
1305 JZ_NAME VARCHAR2(100 BYTE),
1306 BZGJ VARCHAR2(50 BYTE),
1307 ZFZZ VARCHAR2(40 BYTE)
1308 )
1309 LOGGING
1310 NOCACHE
1311 NOPARALLEL;
1312
1313
1314 ALTER TABLE JGGZ.T_YZ_JFKH_LXFZ DROP PRIMARY KEY CASCADE;
1315 DROP TABLE JGGZ.T_YZ_JFKH_LXFZ CASCADE CONSTRAINTS;
1316
1317 CREATE TABLE JGGZ.T_YZ_JFKH_LXFZ
1318 (
1319 ID VARCHAR2(64 BYTE),
1320 LXID VARCHAR2(64 BYTE),
1321 FZTYPE VARCHAR2(8 BYTE),
1322 FZDES VARCHAR2(50 BYTE),
1323 LB VARCHAR2(8 BYTE),
1324 FZ NUMBER
1325 )
1326 LOGGING
1327 NOCACHE
1328 NOPARALLEL;
1329
1330
1331 ALTER TABLE JGGZ.T_YZ_JFKH_REPORT_TEMP DROP PRIMARY KEY CASCADE;
1332 DROP TABLE JGGZ.T_YZ_JFKH_REPORT_TEMP CASCADE CONSTRAINTS;
1333
1334 CREATE TABLE JGGZ.T_YZ_JFKH_REPORT_TEMP
1335 (
1336 SESSIONID VARCHAR2(64 BYTE) NOT NULL,
1337 ZFID VARCHAR2(12 BYTE) NOT NULL,
1338 ZFFH VARCHAR2(5 BYTE),
1339 ZFNAME VARCHAR2(100 BYTE),
1340 DB VARCHAR2(20 BYTE),
1341 LJF NUMBER(10,2) DEFAULT 0
1342 )
1343 LOGGING
1344 NOCACHE
1345 NOPARALLEL;
1346
1347
1348 ALTER TABLE JGGZ.T_YZ_JFKH_SCORE DROP PRIMARY KEY CASCADE;
1349 DROP TABLE JGGZ.T_YZ_JFKH_SCORE CASCADE CONSTRAINTS;
1350
1351 CREATE TABLE JGGZ.T_YZ_JFKH_SCORE
1352 (
1353 ZF_ID VARCHAR2(32 BYTE),
1354 ID VARCHAR2(32 BYTE) NOT NULL,
1355 XZ_ID VARCHAR2(32 BYTE),
1356 SCOREVALUE NUMBER(10,2),
1357 SCOREDATE DATE,
1358 DEL_FLAG CHAR(1 BYTE),
1359 C_DATE DATE,
1360 U_DATE DATE,
1361 OPERATOR VARCHAR2(50 BYTE),
1362 JFGJ VARCHAR2(50 BYTE),
1363 SPJ VARCHAR2(20 BYTE),
1364 JYSS VARCHAR2(200 BYTE),
1365 DL VARCHAR2(50 BYTE),
1366 LB VARCHAR2(2 BYTE),
1367 FLAG VARCHAR2(3 BYTE) DEFAULT 2,
1368 DEPID VARCHAR2(30 BYTE),
1369 ACCORDING VARCHAR2(300 BYTE),
1370 JFGJID VARCHAR2(32 BYTE)
1371 )
1372 LOGGING
1373 NOCACHE
1374 NOPARALLEL;
1375
1376
1377 ALTER TABLE JGGZ.T_YZ_JFKH_SCORE_CLEAR DROP PRIMARY KEY CASCADE;
1378 DROP TABLE JGGZ.T_YZ_JFKH_SCORE_CLEAR CASCADE CONSTRAINTS;
1379
1380 CREATE TABLE JGGZ.T_YZ_JFKH_SCORE_CLEAR
1381 (
1382 ZF_ID VARCHAR2(32 BYTE),
1383 REASON VARCHAR2(2000 BYTE),
1384 SCORE NUMBER(10,2),
1385 SCOREDATE DATE,
1386 ID VARCHAR2(32 BYTE) NOT NULL,
1387 DEL_FLAG CHAR(1 BYTE),
1388 JFQR DATE,
1389 JFGJ VARCHAR2(32 BYTE),
1390 OPERATOR VARCHAR2(32 BYTE)
1391 )
1392 LOGGING
1393 NOCACHE
1394 NOPARALLEL;
1395
1396
1397 ALTER TABLE JGGZ.T_YZ_JFKH_SCORE_HISTORY DROP PRIMARY KEY CASCADE;
1398 DROP TABLE JGGZ.T_YZ_JFKH_SCORE_HISTORY CASCADE CONSTRAINTS;
1399
1400 CREATE TABLE JGGZ.T_YZ_JFKH_SCORE_HISTORY
1401 (
1402 ZF_ID VARCHAR2(32 BYTE),
1403 ID VARCHAR2(32 BYTE) NOT NULL,
1404 XZ_ID VARCHAR2(32 BYTE),
1405 SCOREVALUE NUMBER(10,2),
1406 SCOREDATE DATE,
1407 DEL_FLAG CHAR(1 BYTE),
1408 C_DATE DATE,
1409 U_DATE DATE,
1410 OPERATOR VARCHAR2(50 BYTE),
1411 JFGJ VARCHAR2(50 BYTE),
1412 SPJ VARCHAR2(20 BYTE),
1413 JYSS VARCHAR2(200 BYTE),
1414 DL VARCHAR2(50 BYTE),
1415 LB VARCHAR2(2 BYTE),
1416 FLAG VARCHAR2(3 BYTE) DEFAULT 2,
1417 DEPID VARCHAR2(30 BYTE),
1418 ACCORDING VARCHAR2(300 BYTE),
1419 JFGJID VARCHAR2(32 BYTE)
1420 )
1421 LOGGING
1422 NOCACHE
1423 NOPARALLEL;
1424
1425
1426 ALTER TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH DROP PRIMARY KEY CASCADE;
1427 DROP TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH CASCADE CONSTRAINTS;
1428
1429 CREATE TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH
1430 (
1431 ID VARCHAR2(64 BYTE) NOT NULL,
1432 ZF_ID VARCHAR2(32 BYTE),
1433 REAL_SCORE NUMBER(10,2) DEFAULT 0,
1434 BALANCE_SCORE NUMBER(10,2) DEFAULT 0,
1435 AWARD_SCORE NUMBER(10,2) DEFAULT 0,
1436 PUNISH_SCORE NUMBER(10,2) DEFAULT 0,
1437 CLEAR_SCORE NUMBER(10,2) DEFAULT 0,
1438 HALF_FLAG CHAR(1 BYTE),
1439 YJ_FLAG CHAR(1 BYTE) DEFAULT 0,
1440 C_DATE DATE,
1441 U_DATE DATE,
1442 DEL_FLAG CHAR(1 BYTE) DEFAULT 0,
1443 SUM_SCORE NUMBER(10,2),
1444 DEPID VARCHAR2(30 BYTE),
1445 YEAR VARCHAR2(8 BYTE),
1446 MONTH VARCHAR2(8 BYTE),
1447 JY VARCHAR2(32 BYTE)
1448 )
1449 LOGGING
1450 NOCACHE
1451 NOPARALLEL;
1452
1453
1454 DROP TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH_0000 CASCADE CONSTRAINTS;
1455
1456 CREATE TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH_0000
1457 (
1458 ZF_ID VARCHAR2(32 BYTE),
1459 YM VARCHAR2(6 BYTE),
1460 JF NUMBER,
1461 KF NUMBER,
1462 QXF NUMBER,
1463 PHF NUMBER,
1464 FKF NUMBER
1465 )
1466 LOGGING
1467 NOCACHE
1468 NOPARALLEL;
1469
1470
1471 DROP TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH_1111 CASCADE CONSTRAINTS;
1472
1473 CREATE TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH_1111
1474 (
1475 ID VARCHAR2(64 BYTE) NOT NULL,
1476 ZF_ID VARCHAR2(32 BYTE),
1477 REAL_SCORE NUMBER(10,2),
1478 BALANCE_SCORE NUMBER(10,2),
1479 AWARD_SCORE NUMBER(10,2),
1480 PUNISH_SCORE NUMBER(10,2),
1481 CLEAR_SCORE NUMBER(10,2),
1482 HALF_FLAG CHAR(1 BYTE),
1483 YJ_FLAG CHAR(1 BYTE),
1484 C_DATE DATE,
1485 U_DATE DATE,
1486 DEL_FLAG CHAR(1 BYTE),
1487 SUM_SCORE NUMBER(10,2),
1488 DEPID VARCHAR2(30 BYTE),
1489 YEAR VARCHAR2(8 BYTE),
1490 MONTH VARCHAR2(8 BYTE),
1491 JY VARCHAR2(32 BYTE)
1492 )
1493 LOGGING
1494 NOCACHE
1495 NOPARALLEL;
1496
1497
1498 DROP TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH_TEMP CASCADE CONSTRAINTS;
1499
1500 CREATE TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH_TEMP
1501 (
1502 ID VARCHAR2(64 BYTE) NOT NULL,
1503 ZF_ID VARCHAR2(32 BYTE),
1504 REAL_SCORE NUMBER(10,2),
1505 BALANCE_SCORE NUMBER(10,2),
1506 AWARD_SCORE NUMBER(10,2),
1507 PUNISH_SCORE NUMBER(10,2),
1508 CLEAR_SCORE NUMBER(10,2),
1509 HALF_FLAG CHAR(1 BYTE),
1510 YJ_FLAG CHAR(1 BYTE),
1511 C_DATE DATE,
1512 U_DATE DATE,
1513 DEL_FLAG CHAR(1 BYTE),
1514 SUM_SCORE NUMBER(10,2),
1515 DEPID VARCHAR2(30 BYTE),
1516 YEAR VARCHAR2(8 BYTE),
1517 MONTH VARCHAR2(8 BYTE),
1518 JY VARCHAR2(32 BYTE)
1519 )
1520 LOGGING
1521 NOCACHE
1522 NOPARALLEL;
1523
1524
1525 ALTER TABLE JGGZ.T_YZ_JFKH_SPJ DROP PRIMARY KEY CASCADE;
1526 DROP TABLE JGGZ.T_YZ_JFKH_SPJ CASCADE CONSTRAINTS;
1527
1528 CREATE TABLE JGGZ.T_YZ_JFKH_SPJ
1529 (
1530 ID VARCHAR2(32 BYTE) NOT NULL,
1531 NAME VARCHAR2(200 BYTE),
1532 JFLIMIT VARCHAR2(10 BYTE)
1533 )
1534 LOGGING
1535 NOCACHE
1536 NOPARALLEL;
1537
1538
1539 ALTER TABLE JGGZ.T_YZ_JFKH_USER DROP PRIMARY KEY CASCADE;
1540 DROP TABLE JGGZ.T_YZ_JFKH_USER CASCADE CONSTRAINTS;
1541
1542 CREATE TABLE JGGZ.T_YZ_JFKH_USER
1543 (
1544 USER_ID VARCHAR2(32 BYTE),
1545 JF_DEPT VARCHAR2(20 BYTE),
1546 DEL_FLAG CHAR(1 BYTE),
1547 C_DATE DATE,
1548 U_DATE DATE,
1549 SPJ VARCHAR2(32 BYTE),
1550 ID VARCHAR2(32 BYTE) NOT NULL
1551 )
1552 LOGGING
1553 NOCACHE
1554 NOPARALLEL;
1555
1556
1557 ALTER TABLE JGGZ.T_YZ_JFKH_XBF DROP PRIMARY KEY CASCADE;
1558 DROP TABLE JGGZ.T_YZ_JFKH_XBF CASCADE CONSTRAINTS;
1559
1560 CREATE TABLE JGGZ.T_YZ_JFKH_XBF
1561 (
1562 ID VARCHAR2(64 BYTE),
1563 XBDATE DATE,
1564 XBDEP VARCHAR2(64 BYTE),
1565 XBFS NUMBER(10,2),
1566 JSDEP VARCHAR2(64 BYTE),
1567 C_DATE DATE,
1568 U_DATE DATE,
1569 DEL_FLAG CHAR(1 BYTE),
1570 OPERATOR VARCHAR2(32 BYTE),
1571 XBREASON VARCHAR2(200 BYTE),
1572 FLAG CHAR(1 BYTE) DEFAULT 0
1573 )
1574 LOGGING
1575 NOCACHE
1576 NOPARALLEL;
1577
1578
1579 ALTER TABLE JGGZ.T_YZ_JFKH_XBF_DEPT DROP PRIMARY KEY CASCADE;
1580 DROP TABLE JGGZ.T_YZ_JFKH_XBF_DEPT CASCADE CONSTRAINTS;
1581
1582 CREATE TABLE JGGZ.T_YZ_JFKH_XBF_DEPT
1583 (
1584 ID VARCHAR2(32 BYTE) NOT NULL,
1585 PARENTID VARCHAR2(32 BYTE),
1586 NAME VARCHAR2(50 BYTE),
1587 BM VARCHAR2(30 BYTE),
1588 CANADD CHAR(1 BYTE) DEFAULT 0,
1589 USEFULLIFE NUMBER(2) DEFAULT 0,
1590 USEFULLIFETYPE CHAR(1 BYTE),
1591 LIMIT CHAR(1 BYTE) DEFAULT 1,
1592 FZTYPE CHAR(1 BYTE),
1593 BASEFZ NUMBER(6,2) DEFAULT 0,
1594 C_DATE DATE,
1595 U_DATE DATE,
1596 DEL_FLAG CHAR(1 BYTE) DEFAULT 0,
1597 DEPTTYPE CHAR(1 BYTE)
1598 )
1599 LOGGING
1600 NOCACHE
1601 NOPARALLEL;
1602
1603
1604 ALTER TABLE JGGZ.T_YZ_JFKH_XBF_DETAIL DROP PRIMARY KEY CASCADE;
1605 DROP TABLE JGGZ.T_YZ_JFKH_XBF_DETAIL CASCADE CONSTRAINTS;
1606
1607 CREATE TABLE JGGZ.T_YZ_JFKH_XBF_DETAIL
1608 (
1609 ID VARCHAR2(32 BYTE) NOT NULL,
1610 XBDATE DATE,
1611 XBDEPT VARCHAR2(30 BYTE),
1612 XBFS NUMBER(10,2) DEFAULT 0,
1613 JSDEPT VARCHAR2(30 BYTE),
1614 C_DATE DATE,
1615 U_DATE DATE,
1616 DEL_FLAG CHAR(1 BYTE) DEFAULT 0,
1617 OPERATOR VARCHAR2(32 BYTE),
1618 XBREASON VARCHAR2(200 BYTE)
1619 )
1620 LOGGING
1621 NOCACHE
1622 NOPARALLEL;
1623
1624
1625 ALTER TABLE JGGZ.T_YZ_JFKH_XBF_USER DROP PRIMARY KEY CASCADE;
1626 DROP TABLE JGGZ.T_YZ_JFKH_XBF_USER CASCADE CONSTRAINTS;
1627
1628 CREATE TABLE JGGZ.T_YZ_JFKH_XBF_USER
1629 (
1630 USERID VARCHAR2(32 BYTE) NOT NULL,
1631 XBFDEPTBM VARCHAR2(30 BYTE)
1632 )
1633 LOGGING
1634 NOCACHE
1635 NOPARALLEL;
1636
1637
1638 ALTER TABLE JGGZ.T_YZ_JFKH_XZ DROP PRIMARY KEY CASCADE;
1639 DROP TABLE JGGZ.T_YZ_JFKH_XZ CASCADE CONSTRAINTS;
1640
1641 CREATE TABLE JGGZ.T_YZ_JFKH_XZ
1642 (
1643 ID VARCHAR2(32 BYTE) NOT NULL,
1644 CONTENT VARCHAR2(4000 BYTE),
1645 ACCORDING VARCHAR2(1000 BYTE),
1646 U_LIMIT VARCHAR2(16 BYTE),
1647 L_LIMIT VARCHAR2(16 BYTE),
1648 F_LIMIT VARCHAR2(16 BYTE),
1649 O_LEVEL VARCHAR2(16 BYTE),
1650 C_DATE DATE,
1651 U_DATE DATE,
1652 DEL_FLAG CHAR(1 BYTE),
1653 LRM VARCHAR2(200 BYTE),
1654 JFLB VARCHAR2(100 BYTE),
1655 DL VARCHAR2(32 BYTE),
1656 JBF VARCHAR2(10 BYTE),
1657 FLAG VARCHAR2(32 BYTE) DEFAULT 0
1658 )
1659 LOGGING
1660 NOCACHE
1661 NOPARALLEL;
1662
1663
1664 DROP TABLE JGGZ.T_YZ_JFKH_XZL CASCADE CONSTRAINTS;
1665
1666 CREATE TABLE JGGZ.T_YZ_JFKH_XZL
1667 (
1668 ID VARCHAR2(32 BYTE),
1669 NAME VARCHAR2(200 BYTE)
1670 )
1671 LOGGING
1672 NOCACHE
1673 NOPARALLEL;
1674
1675
1676 ALTER TABLE JGGZ.T_YZ_JFKH_YJ_DEPT DROP PRIMARY KEY CASCADE;
1677 DROP TABLE JGGZ.T_YZ_JFKH_YJ_DEPT CASCADE CONSTRAINTS;
1678
1679 CREATE TABLE JGGZ.T_YZ_JFKH_YJ_DEPT
1680 (
1681 DEPID VARCHAR2(32 BYTE),
1682 ID VARCHAR2(32 BYTE) NOT NULL,
1683 LASTYJSDATE DATE,
1684 LASTYJEDATE DATE,
1685 DEL_FLAG CHAR(1 BYTE) DEFAULT 0,
1686 YEAR VARCHAR2(32 BYTE),
1687 MONTH VARCHAR2(32 BYTE),
1688 RJF NUMBER(10,2),
1689 FDF NUMBER(10,2),
1690 KHRS NUMBER(10),
1691 KYJF NUMBER(10,2),
1692 PHF NUMBER(10,2),
1693 ZYRS NUMBER(10),
1694 SYJF NUMBER(10,2),
1695 XBF NUMBER(10,2),
1696 ZGDF NUMBER(10,2) DEFAULT 0,
1697 ZDDF NUMBER(10,2) DEFAULT 0,
1698 JQFKYF NUMBER(10,2) DEFAULT 0,
1699 DDBF NUMBER(10,2) DEFAULT 0
1700 )
1701 LOGGING
1702 NOCACHE
1703 NOPARALLEL;
1704
1705
1706 DROP TABLE JGGZ.T_YZ_JFKH_YJ_INFO CASCADE CONSTRAINTS;
1707
1708 CREATE TABLE JGGZ.T_YZ_JFKH_YJ_INFO
1709 (
1710 ID VARCHAR2(32 BYTE),
1711 JBF NUMBER(10,2) DEFAULT 0,
1712 WHGR NUMBER(10,2) DEFAULT 0,
1713 WMJZ NUMBER(10,2) DEFAULT 0,
1714 PHF NUMBER(10,2) DEFAULT 0,
1715 GJ NUMBER(10,2) DEFAULT 0,
1716 FJQ NUMBER(10,2) DEFAULT 0,
1717 JQ NUMBER(10,2) DEFAULT 0,
1718 JY NUMBER(10,2) DEFAULT 0,
1719 DJG NUMBER(10,2) DEFAULT 0,
1720 ZJ NUMBER(10,2) DEFAULT 0,
1721 FLAG VARCHAR2(32 BYTE),
1722 YJID VARCHAR2(32 BYTE)
1723 )
1724 LOGGING
1725 NOCACHE
1726 NOPARALLEL;
1727
1728
1729 ALTER TABLE JGGZ.T_YZ_JFKH_ZF DROP PRIMARY KEY CASCADE;
1730 DROP TABLE JGGZ.T_YZ_JFKH_ZF CASCADE CONSTRAINTS;
1731
1732 CREATE TABLE JGGZ.T_YZ_JFKH_ZF
1733 (
1734 ID VARCHAR2(32 BYTE) NOT NULL,
1735 ZF_ID VARCHAR2(32 BYTE),
1736 C_DATE DATE,
1737 DEL_FLAG CHAR(1 BYTE),
1738 U_DATE DATE,
1739 ZF_FH VARCHAR2(20 BYTE),
1740 ZF_NAME VARCHAR2(60 BYTE),
1741 ZF_DEPID VARCHAR2(20 BYTE),
1742 BIRTHDAY DATE,
1743 ZM VARCHAR2(80 BYTE),
1744 XQ VARCHAR2(20 BYTE),
1745 XQQR DATE,
1746 XQZR DATE,
1747 DR_DATE DATE,
1748 FGDJ VARCHAR2(60 BYTE),
1749 JGGJ VARCHAR2(20 BYTE),
1750 ZY_FLAG VARCHAR2(10 BYTE),
1751 LB VARCHAR2(60 BYTE),
1752 LBC VARCHAR2(60 BYTE),
1753 LH VARCHAR2(100 BYTE),
1754 JFKS_DATE DATE,
1755 CHK VARCHAR2(10 BYTE),
1756 WCNF VARCHAR2(10 BYTE),
1757 NOTSCORE_FLAG VARCHAR2(10 BYTE),
1758 BRZ VARCHAR2(1 BYTE),
1759 BJTS VARCHAR2(30 BYTE),
1760 LXID VARCHAR2(60 BYTE),
1761 BJREASON VARCHAR2(100 BYTE),
1762 JQFFLAG VARCHAR2(1 BYTE)
1763 )
1764 LOGGING
1765 NOCACHE
1766 NOPARALLEL;
1767
1768
1769 ALTER TABLE JGGZ.T_YZ_JFKH_ZFLX DROP PRIMARY KEY CASCADE;
1770 DROP TABLE JGGZ.T_YZ_JFKH_ZFLX CASCADE CONSTRAINTS;
1771
1772 CREATE TABLE JGGZ.T_YZ_JFKH_ZFLX
1773 (
1774 ID VARCHAR2(64 BYTE),
1775 LXTYPE VARCHAR2(8 BYTE),
1776 LXDES VARCHAR2(50 BYTE),
1777 DEL_FLAG VARCHAR2(8 BYTE)
1778 )
1779 LOGGING
1780 NOCACHE
1781 NOPARALLEL;
1782
1783
1784 ALTER TABLE JGGZ.T_YZ_JFKH_ZF_HISTORY DROP PRIMARY KEY CASCADE;
1785 DROP TABLE JGGZ.T_YZ_JFKH_ZF_HISTORY CASCADE CONSTRAINTS;
1786
1787 CREATE TABLE JGGZ.T_YZ_JFKH_ZF_HISTORY
1788 (
1789 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
1790 NOTSCORE_FLAG VARCHAR2(1 BYTE),
1791 BRZ VARCHAR2(1 BYTE),
1792 BJTS VARCHAR2(8 BYTE),
1793 BJREASON VARCHAR2(300 BYTE),
1794 JQFFLAG VARCHAR2(1 BYTE),
1795 YEAR VARCHAR2(4 BYTE),
1796 MONTH VARCHAR2(2 BYTE),
1797 DB VARCHAR2(12 BYTE)
1798 )
1799 LOGGING
1800 NOCACHE
1801 NOPARALLEL;
1802
1803
1804 DROP TABLE JGGZ.T_YZ_JXJS_ZF_XQBG CASCADE CONSTRAINTS;
1805
1806 CREATE TABLE JGGZ.T_YZ_JXJS_ZF_XQBG
1807 (
1808 XQBG_NO VARCHAR2(32 BYTE) NOT NULL,
1809 BD_TYPE VARCHAR2(20 BYTE),
1810 PJ_DATE DATE,
1811 PJ_NO1 VARCHAR2(32 BYTE),
1812 PJ_NO2 VARCHAR2(8 BYTE),
1813 CD_FD VARCHAR2(32 BYTE),
1814 ZX_DATE DATE,
1815 MEMO VARCHAR2(4000 BYTE),
1816 C_USER VARCHAR2(32 BYTE),
1817 CB_DATE DATE,
1818 ZF_NAME VARCHAR2(100 BYTE),
1819 BQNDH VARCHAR2(10 BYTE),
1820 BQAJZH VARCHAR2(10 BYTE),
1821 BQAJBH VARCHAR2(10 BYTE),
1822 IMPORT_FLAG VARCHAR2(1 BYTE),
1823 ZF_XB VARCHAR2(2 BYTE),
1824 ZF_NL VARCHAR2(10 BYTE),
1825 DOWNLOAD_NUM NUMBER,
1826 ZF_ID VARCHAR2(32 BYTE),
1827 JY_ID VARCHAR2(32 BYTE),
1828 JY_XQBG_NO VARCHAR2(32 BYTE)
1829 )
1830 LOGGING
1831 NOCACHE
1832 NOPARALLEL;
1833
1834
1835 ALTER TABLE JGGZ.T_YZ_LOGS DROP PRIMARY KEY CASCADE;
1836 DROP TABLE JGGZ.T_YZ_LOGS CASCADE CONSTRAINTS;
1837
1838 CREATE TABLE JGGZ.T_YZ_LOGS
1839 (
1840 TIME DATE,
1841 USERID VARCHAR2(32 BYTE),
1842 MODEL VARCHAR2(255 BYTE),
1843 ACTION VARCHAR2(255 BYTE),
1844 ZF_ID VARCHAR2(500 BYTE),
1845 OPRESULT VARCHAR2(255 BYTE),
1846 ID VARCHAR2(32 BYTE) NOT NULL
1847 )
1848 NOLOGGING
1849 NOCACHE
1850 NOPARALLEL;
1851
1852
1853 ALTER TABLE JGGZ.T_YZ_MINGCE DROP PRIMARY KEY CASCADE;
1854 DROP TABLE JGGZ.T_YZ_MINGCE CASCADE CONSTRAINTS;
1855
1856 CREATE TABLE JGGZ.T_YZ_MINGCE
1857 (
1858 ID VARCHAR2(32 BYTE) NOT NULL,
1859 PROCEDURE_NAME VARCHAR2(32 BYTE),
1860 TITLE VARCHAR2(200 BYTE),
1861 COLUMN_TITLE VARCHAR2(500 BYTE),
1862 C_DATE DATE,
1863 U_DATE DATE,
1864 C_USER VARCHAR2(32 BYTE),
1865 U_USER VARCHAR2(32 BYTE)
1866 )
1867 LOGGING
1868 NOCACHE
1869 NOPARALLEL;
1870
1871
1872 DROP TABLE JGGZ.T_YZ_PHOTO_ZFID CASCADE CONSTRAINTS;
1873
1874 CREATE TABLE JGGZ.T_YZ_PHOTO_ZFID
1875 (
1876 YH VARCHAR2(32 BYTE),
1877 ZF_ID VARCHAR2(12 BYTE)
1878 )
1879 LOGGING
1880 NOCACHE
1881 NOPARALLEL;
1882
1883
1884 ALTER TABLE JGGZ.T_YZ_PROM_INFO DROP PRIMARY KEY CASCADE;
1885 DROP TABLE JGGZ.T_YZ_PROM_INFO CASCADE CONSTRAINTS;
1886
1887 CREATE TABLE JGGZ.T_YZ_PROM_INFO
1888 (
1889 ID VARCHAR2(32 BYTE) NOT NULL,
1890 INFO VARCHAR2(4000 BYTE),
1891 TITLE VARCHAR2(500 BYTE),
1892 DELFLAG VARCHAR2(1 BYTE) DEFAULT 0,
1893 AUTHORID VARCHAR2(32 BYTE),
1894 STARTDATE DATE,
1895 ENDDATE DATE,
1896 SENDTO VARCHAR2(64 BYTE)
1897 )
1898 LOGGING
1899 NOCACHE
1900 NOPARALLEL;
1901
1902
1903 ALTER TABLE JGGZ.T_YZ_RC_GZJS DROP PRIMARY KEY CASCADE;
1904 DROP TABLE JGGZ.T_YZ_RC_GZJS CASCADE CONSTRAINTS;
1905
1906 CREATE TABLE JGGZ.T_YZ_RC_GZJS
1907 (
1908 ID VARCHAR2(32 BYTE) NOT NULL,
1909 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
1910 JSDATE DATE,
1911 JSTYPE VARCHAR2(32 BYTE),
1912 SZDB VARCHAR2(32 BYTE),
1913 MEMO VARCHAR2(2000 BYTE),
1914 C_DATE DATE,
1915 U_DATE DATE,
1916 DEL_FLAG VARCHAR2(1 BYTE)
1917 )
1918 LOGGING
1919 NOCACHE
1920 NOPARALLEL;
1921
1922
1923 DROP TABLE JGGZ.T_YZ_RC_GZJS_TMP CASCADE CONSTRAINTS;
1924
1925 CREATE TABLE JGGZ.T_YZ_RC_GZJS_TMP
1926 (
1927 ID VARCHAR2(32 BYTE) NOT NULL,
1928 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
1929 JSDATE DATE,
1930 JSTYPE VARCHAR2(32 BYTE),
1931 SZDB VARCHAR2(32 BYTE),
1932 MEMO VARCHAR2(2000 BYTE),
1933 C_DATE DATE,
1934 U_DATE DATE,
1935 DEL_FLAG VARCHAR2(1 BYTE)
1936 )
1937 LOGGING
1938 NOCACHE
1939 NOPARALLEL;
1940
1941
1942 ALTER TABLE JGGZ.T_YZ_RC_THDJ DROP PRIMARY KEY CASCADE;
1943 DROP TABLE JGGZ.T_YZ_RC_THDJ CASCADE CONSTRAINTS;
1944
1945 CREATE TABLE JGGZ.T_YZ_RC_THDJ
1946 (
1947 ID VARCHAR2(32 BYTE) NOT NULL,
1948 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
1949 THDATE DATE,
1950 SHDATE DATE,
1951 THYY VARCHAR2(4000 BYTE),
1952 THDW_XZQH VARCHAR2(255 BYTE),
1953 THDW_ARDD VARCHAR2(2000 BYTE),
1954 THQX VARCHAR2(8 BYTE),
1955 THRNAME VARCHAR2(255 BYTE),
1956 THRDH VARCHAR2(255 BYTE),
1957 SZDB VARCHAR2(255 BYTE),
1958 COMMENTS VARCHAR2(2000 BYTE),
1959 DEL_FLAG VARCHAR2(1 BYTE),
1960 C_DATE DATE,
1961 U_DATE DATE
1962 )
1963 LOGGING
1964 NOCACHE
1965 NOPARALLEL;
1966
1967
1968 ALTER TABLE JGGZ.T_YZ_ROLE_AUTHORITY_TEST DROP PRIMARY KEY CASCADE;
1969 DROP TABLE JGGZ.T_YZ_ROLE_AUTHORITY_TEST CASCADE CONSTRAINTS;
1970
1971 CREATE TABLE JGGZ.T_YZ_ROLE_AUTHORITY_TEST
1972 (
1973 AUTH_ID VARCHAR2(32 BYTE) NOT NULL,
1974 ROLE_ID VARCHAR2(32 BYTE) NOT NULL
1975 )
1976 NOLOGGING
1977 NOCACHE
1978 NOPARALLEL;
1979
1980
1981 ALTER TABLE JGGZ.T_YZ_ROLE_TEST DROP PRIMARY KEY CASCADE;
1982 DROP TABLE JGGZ.T_YZ_ROLE_TEST CASCADE CONSTRAINTS;
1983
1984 CREATE TABLE JGGZ.T_YZ_ROLE_TEST
1985 (
1986 ROLE_ID VARCHAR2(32 BYTE) NOT NULL,
1987 ROLE_NAME VARCHAR2(50 BYTE),
1988 ROLE_DESC VARCHAR2(200 BYTE),
1989 C_DATE DATE,
1990 U_DATE DATE,
1991 DEL_FLAG CHAR(1 BYTE)
1992 )
1993 NOLOGGING
1994 NOCACHE
1995 NOPARALLEL;
1996
1997
1998 ALTER TABLE JGGZ.T_YZ_SFWS DROP PRIMARY KEY CASCADE;
1999 DROP TABLE JGGZ.T_YZ_SFWS CASCADE CONSTRAINTS;
2000
2001 CREATE TABLE JGGZ.T_YZ_SFWS
2002 (
2003 SFWSID VARCHAR2(32 BYTE) NOT NULL,
2004 ZF_ID VARCHAR2(12 BYTE),
2005 SFWS_TYPE VARCHAR2(32 BYTE),
2006 SFWS_NO1 VARCHAR2(64 BYTE),
2007 SFWS_NO2 VARCHAR2(64 BYTE),
2008 WS_NR BLOB,
2009 C_DATE DATE,
2010 U_DATE DATE,
2011 DB VARCHAR2(32 BYTE)
2012 )
2013 LOGGING
2014 NOCACHE
2015 NOPARALLEL;
2016
2017
2018 ALTER TABLE JGGZ.T_YZ_SFWSNO DROP PRIMARY KEY CASCADE;
2019 DROP TABLE JGGZ.T_YZ_SFWSNO CASCADE CONSTRAINTS;
2020
2021 CREATE TABLE JGGZ.T_YZ_SFWSNO
2022 (
2023 ID VARCHAR2(32 BYTE) NOT NULL,
2024 SFWS_TYPE VARCHAR2(4 BYTE),
2025 SFWS_NO NUMBER(7),
2026 SFWS_ZNO VARCHAR2(60 BYTE),
2027 DB VARCHAR2(32 BYTE)
2028 )
2029 LOGGING
2030 NOCACHE
2031 NOPARALLEL;
2032
2033
2034 ALTER TABLE JGGZ.T_YZ_SFWS_MR DROP PRIMARY KEY CASCADE;
2035 DROP TABLE JGGZ.T_YZ_SFWS_MR CASCADE CONSTRAINTS;
2036
2037 CREATE TABLE JGGZ.T_YZ_SFWS_MR
2038 (
2039 ID VARCHAR2(32 BYTE) NOT NULL,
2040 SFWSTYPE VARCHAR2(4 BYTE),
2041 COL_NO VARCHAR2(512 BYTE),
2042 ROW_NO VARCHAR2(512 BYTE),
2043 PAGE_NO VARCHAR2(512 BYTE),
2044 DEF_STR VARCHAR2(4000 BYTE),
2045 DB VARCHAR2(32 BYTE)
2046 )
2047 LOGGING
2048 NOCACHE
2049 NOPARALLEL;
2050
2051
2052 ALTER TABLE JGGZ.T_YZ_SWDJ DROP PRIMARY KEY CASCADE;
2053 DROP TABLE JGGZ.T_YZ_SWDJ CASCADE CONSTRAINTS;
2054
2055 CREATE TABLE JGGZ.T_YZ_SWDJ
2056 (
2057 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
2058 SWDATE DATE NOT NULL,
2059 SWYYJG VARCHAR2(1000 BYTE),
2060 CENSORIDEA VARCHAR2(1000 BYTE),
2061 SCDATE DATE,
2062 YYJD VARCHAR2(1000 BYTE),
2063 YYJDDATE DATE,
2064 YYNAME VARCHAR2(200 BYTE),
2065 JCYRESULT VARCHAR2(1000 BYTE),
2066 JCUNIT VARCHAR2(10 BYTE),
2067 JCYJDDATE DATE,
2068 STDEALTYPE VARCHAR2(1 BYTE),
2069 STGHDEAL VARCHAR2(1000 BYTE),
2070 SWTIME VARCHAR2(20 BYTE) NOT NULL,
2071 PCS VARCHAR2(10 BYTE)
2072 )
2073 LOGGING
2074 NOCACHE
2075 NOPARALLEL;
2076
2077
2078 ALTER TABLE JGGZ.T_YZ_SWJD DROP PRIMARY KEY CASCADE;
2079 DROP TABLE JGGZ.T_YZ_SWJD CASCADE CONSTRAINTS;
2080
2081 CREATE TABLE JGGZ.T_YZ_SWJD
2082 (
2083 ID VARCHAR2(32 BYTE) NOT NULL,
2084 ZF_ID VARCHAR2(12 BYTE),
2085 YY_JY VARCHAR2(4000 BYTE),
2086 FY_NAME VARCHAR2(32 BYTE),
2087 JDJG_NAME VARCHAR2(64 BYTE),
2088 FY_JY VARCHAR2(2000 BYTE),
2089 FY_DATE DATE,
2090 JY_JY VARCHAR2(2000 BYTE),
2091 JY_DATE DATE,
2092 JCJG_ADDR_XZQH VARCHAR2(12 BYTE),
2093 JCJG_RESULT VARCHAR2(1000 BYTE),
2094 JCJG_DATE DATE,
2095 STCL VARCHAR2(2000 BYTE),
2096 STCLQK VARCHAR2(2000 BYTE),
2097 QSDB VARCHAR2(32 BYTE),
2098 C_DATE DATE,
2099 U_DATE DATE,
2100 DEL_FLAG CHAR(1 BYTE),
2101 C_USER VARCHAR2(32 BYTE)
2102 )
2103 NOLOGGING
2104 NOCACHE
2105 NOPARALLEL;
2106
2107
2108 DROP TABLE JGGZ.T_YZ_SYNC_REPORT CASCADE CONSTRAINTS;
2109
2110 CREATE TABLE JGGZ.T_YZ_SYNC_REPORT
2111 (
2112 ID VARCHAR2(32 BYTE) NOT NULL,
2113 DEPT VARCHAR2(32 BYTE),
2114 SYNC_STATUS VARCHAR2(1 BYTE),
2115 REPORT_TIME DATE,
2116 CREATE_TIME DATE,
2117 UPDATE_TIME DATE,
2118 DEL_FLAG VARCHAR2(1 BYTE)
2119 )
2120 LOGGING
2121 NOCACHE
2122 NOPARALLEL;
2123
2124
2125 ALTER TABLE JGGZ.T_YZ_TAB_RELATION DROP PRIMARY KEY CASCADE;
2126 DROP TABLE JGGZ.T_YZ_TAB_RELATION CASCADE CONSTRAINTS;
2127
2128 CREATE TABLE JGGZ.T_YZ_TAB_RELATION
2129 (
2130 TAB_ID VARCHAR2(32 BYTE) NOT NULL,
2131 M_TABNAME VARCHAR2(255 BYTE) NOT NULL,
2132 M_TABCNAME VARCHAR2(255 BYTE),
2133 F_TABNAME VARCHAR2(255 BYTE) NOT NULL,
2134 F_TABCNAME VARCHAR2(255 BYTE),
2135 COL_CNAME VARCHAR2(255 BYTE) NOT NULL,
2136 COL_NAME VARCHAR2(255 BYTE) NOT NULL,
2137 U_DATE DATE
2138 )
2139 NOLOGGING
2140 NOCACHE
2141 NOPARALLEL;
2142
2143
2144 ALTER TABLE JGGZ.T_YZ_TGZF DROP PRIMARY KEY CASCADE;
2145 DROP TABLE JGGZ.T_YZ_TGZF CASCADE CONSTRAINTS;
2146
2147 CREATE TABLE JGGZ.T_YZ_TGZF
2148 (
2149 ID VARCHAR2(32 BYTE) NOT NULL,
2150 ZF_ID VARCHAR2(12 BYTE),
2151 TG_LB VARCHAR2(240 BYTE),
2152 BQ_DW VARCHAR2(100 BYTE),
2153 BQZC VARCHAR2(100 BYTE),
2154 BQZW VARCHAR2(100 BYTE),
2155 JKZK VARCHAR2(1000 BYTE),
2156 HZ_NO VARCHAR2(200 BYTE),
2157 HZ_QR DATE,
2158 HZ_ZR DATE,
2159 SF_NO VARCHAR2(100 BYTE),
2160 GY_FS VARCHAR2(255 BYTE),
2161 IS_ZY_ZF VARCHAR2(255 BYTE),
2162 EN_NAME VARCHAR2(200 BYTE),
2163 M_NAME VARCHAR2(200 BYTE),
2164 EN_FNAME VARCHAR2(200 BYTE),
2165 TBR VARCHAR2(50 BYTE),
2166 SHR VARCHAR2(50 BYTE),
2167 TBRQ DATE,
2168 TG_CY_MJ VARCHAR2(255 BYTE),
2169 MEMO VARCHAR2(1000 BYTE),
2170 C_DATE DATE,
2171 U_DATE DATE,
2172 DEL_FLAG CHAR(1 BYTE)
2173 )
2174 NOLOGGING
2175 NOCACHE
2176 NOPARALLEL;
2177
2178
2179 ALTER TABLE JGGZ.T_YZ_THJH DROP PRIMARY KEY CASCADE;
2180 DROP TABLE JGGZ.T_YZ_THJH CASCADE CONSTRAINTS;
2181
2182 CREATE TABLE JGGZ.T_YZ_THJH
2183 (
2184 ID VARCHAR2(32 BYTE) NOT NULL,
2185 ZF_ID VARCHAR2(12 BYTE),
2186 THJH_TYPE VARCHAR2(6 BYTE),
2187 TH_TYPE VARCHAR2(6 BYTE),
2188 TH_REASON VARCHAR2(4000 BYTE),
2189 THR VARCHAR2(32 BYTE),
2190 TH_DW VARCHAR2(256 BYTE),
2191 DW_ADDR_XZQH VARCHAR2(16 BYTE),
2192 DW_ADDR_DETAIL VARCHAR2(256 BYTE),
2193 NY_ADDR_XZQH VARCHAR2(16 BYTE),
2194 NY_ADDR_DETAIL VARCHAR2(256 BYTE),
2195 TD_NO1 VARCHAR2(64 BYTE),
2196 TD_NO2 VARCHAR2(64 BYTE),
2197 LXR VARCHAR2(128 BYTE),
2198 TEL VARCHAR2(128 BYTE),
2199 SP_YJ VARCHAR2(4000 BYTE),
2200 JBR VARCHAR2(32 BYTE),
2201 TH_DATE DATE,
2202 TH_RESULT VARCHAR2(4000 BYTE),
2203 NSH_DATE DATE,
2204 SH_DATE DATE,
2205 C_USER VARCHAR2(64 BYTE),
2206 MEMO VARCHAR2(4000 BYTE),
2207 C_DATE DATE,
2208 U_DATE DATE,
2209 DEL_FLAG CHAR(1 BYTE),
2210 SZ_DB VARCHAR2(6 BYTE)
2211 )
2212 NOLOGGING
2213 NOCACHE
2214 NOPARALLEL;
2215
2216
2217 ALTER TABLE JGGZ.T_YZ_USER_TEST DROP PRIMARY KEY CASCADE;
2218 DROP TABLE JGGZ.T_YZ_USER_TEST CASCADE CONSTRAINTS;
2219
2220 CREATE TABLE JGGZ.T_YZ_USER_TEST
2221 (
2222 USER_ID VARCHAR2(10 BYTE) NOT NULL,
2223 ROLE_ID VARCHAR2(32 BYTE),
2224 C_DATE DATE,
2225 U_DATE DATE,
2226 DEL_FLAG CHAR(1 BYTE),
2227 DEPT_ID VARCHAR2(32 BYTE),
2228 JFQX VARCHAR2(40 BYTE)
2229 )
2230 NOLOGGING
2231 NOCACHE
2232 NOPARALLEL;
2233
2234
2235 ALTER TABLE JGGZ.T_YZ_WSSP DROP PRIMARY KEY CASCADE;
2236 DROP TABLE JGGZ.T_YZ_WSSP CASCADE CONSTRAINTS;
2237
2238 CREATE TABLE JGGZ.T_YZ_WSSP
2239 (
2240 ID VARCHAR2(32 BYTE) NOT NULL,
2241 ZF_ID VARCHAR2(12 BYTE),
2242 SPB_TYPE VARCHAR2(6 BYTE),
2243 CONTENT BLOB,
2244 C_DATE DATE,
2245 U_DATE DATE,
2246 DEL_FLAG CHAR(1 BYTE),
2247 DEPT_FILTERCODE VARCHAR2(32 BYTE),
2248 PC_NO VARCHAR2(6 BYTE),
2249 SORT_NO VARCHAR2(16 BYTE)
2250 )
2251 LOGGING
2252 NOCACHE
2253 NOPARALLEL;
2254
2255
2256 ALTER TABLE JGGZ.T_YZ_WSSP_MR DROP PRIMARY KEY CASCADE;
2257 DROP TABLE JGGZ.T_YZ_WSSP_MR CASCADE CONSTRAINTS;
2258
2259 CREATE TABLE JGGZ.T_YZ_WSSP_MR
2260 (
2261 ID VARCHAR2(32 BYTE) NOT NULL,
2262 SP_TYPE VARCHAR2(32 BYTE),
2263 SP_COL VARCHAR2(1024 BYTE),
2264 SP_ROW VARCHAR2(1024 BYTE),
2265 SP_YM VARCHAR2(1024 BYTE),
2266 MR_STR VARCHAR2(4000 BYTE),
2267 DB VARCHAR2(16 BYTE)
2268 )
2269 LOGGING
2270 NOCACHE
2271 NOPARALLEL;
2272
2273
2274 ALTER TABLE JGGZ.T_YZ_XT_BM DROP PRIMARY KEY CASCADE;
2275 DROP TABLE JGGZ.T_YZ_XT_BM CASCADE CONSTRAINTS;
2276
2277 CREATE TABLE JGGZ.T_YZ_XT_BM
2278 (
2279 ID VARCHAR2(255 BYTE) NOT NULL,
2280 PARENTID VARCHAR2(255 BYTE),
2281 SXH NUMBER(10),
2282 SM VARCHAR2(255 BYTE),
2283 LRM VARCHAR2(255 BYTE),
2284 BM VARCHAR2(255 BYTE),
2285 CREATETIME DATE,
2286 LASTMODIFIEDTIME DATE,
2287 REMOVEFLAG VARCHAR2(255 BYTE),
2288 LBID VARCHAR2(255 BYTE) NOT NULL,
2289 CANBEMODIFY VARCHAR2(1 BYTE)
2290 )
2291 LOGGING
2292 NOCACHE
2293 NOPARALLEL;
2294
2295
2296 DROP TABLE JGGZ.T_YZ_XT_BML CASCADE CONSTRAINTS;
2297
2298 CREATE TABLE JGGZ.T_YZ_XT_BML
2299 (
2300 ID VARCHAR2(255 BYTE),
2301 NAME VARCHAR2(255 BYTE),
2302 MEMO VARCHAR2(2000 BYTE),
2303 TYPE VARCHAR2(10 BYTE),
2304 CANBEMODIFY CHAR(1 BYTE),
2305 ORDERNO NUMBER(10)
2306 )
2307 NOLOGGING
2308 NOCACHE
2309 NOPARALLEL;
2310
2311
2312 ALTER TABLE JGGZ.T_YZ_XT_CHKITEMS DROP PRIMARY KEY CASCADE;
2313 DROP TABLE JGGZ.T_YZ_XT_CHKITEMS CASCADE CONSTRAINTS;
2314
2315 CREATE TABLE JGGZ.T_YZ_XT_CHKITEMS
2316 (
2317 ID VARCHAR2(64 BYTE),
2318 PARENTID VARCHAR2(64 BYTE),
2319 SELFIELD VARCHAR2(100 BYTE),
2320 SELNOTES VARCHAR2(100 BYTE),
2321 ERRMSG VARCHAR2(100 BYTE),
2322 TABLES VARCHAR2(100 BYTE),
2323 SQLWHERE VARCHAR2(500 BYTE),
2324 CHKORDER NUMBER,
2325 DEL_FALG CHAR(1 BYTE)
2326 )
2327 LOGGING
2328 NOCACHE
2329 NOPARALLEL;
2330
2331
2332 ALTER TABLE JGGZ.T_YZ_XT_CHKMODUL DROP PRIMARY KEY CASCADE;
2333 DROP TABLE JGGZ.T_YZ_XT_CHKMODUL CASCADE CONSTRAINTS;
2334
2335 CREATE TABLE JGGZ.T_YZ_XT_CHKMODUL
2336 (
2337 ID VARCHAR2(64 BYTE),
2338 CHKORDER NUMBER,
2339 CAP VARCHAR2(100 BYTE),
2340 DEL_FLAG CHAR(1 BYTE)
2341 )
2342 LOGGING
2343 NOCACHE
2344 NOPARALLEL;
2345
2346
2347 DROP TABLE JGGZ.T_YZ_XT_CHKR CASCADE CONSTRAINTS;
2348
2349 CREATE TABLE JGGZ.T_YZ_XT_CHKR
2350 (
2351 SESSIONID VARCHAR2(64 BYTE),
2352 ZF_ID VARCHAR2(12 BYTE),
2353 ZF_FH VARCHAR2(6 BYTE),
2354 ZFNAME VARCHAR2(100 BYTE),
2355 DB VARCHAR2(32 BYTE),
2356 MNAME VARCHAR2(100 BYTE),
2357 MSG1 VARCHAR2(500 BYTE),
2358 MSG2 VARCHAR2(500 BYTE),
2359 SORDER NUMBER,
2360 DEL_FLAG CHAR(1 BYTE)
2361 )
2362 LOGGING
2363 NOCACHE
2364 NOPARALLEL;
2365
2366
2367 ALTER TABLE JGGZ.T_YZ_XT_DIMEN DROP PRIMARY KEY CASCADE;
2368 DROP TABLE JGGZ.T_YZ_XT_DIMEN CASCADE CONSTRAINTS;
2369
2370 CREATE TABLE JGGZ.T_YZ_XT_DIMEN
2371 (
2372 ID VARCHAR2(32 BYTE) NOT NULL,
2373 TYPE VARCHAR2(255 BYTE),
2374 FIELDID VARCHAR2(255 BYTE),
2375 NAME VARCHAR2(255 BYTE),
2376 SYSTEMDIMEN VARCHAR2(1 BYTE),
2377 FLAGCODE VARCHAR2(255 BYTE),
2378 DWTJUSE VARCHAR2(1 BYTE),
2379 RAWID VARCHAR2(32 BYTE)
2380 )
2381 NOLOGGING
2382 NOCACHE
2383 NOPARALLEL;
2384
2385
2386 ALTER TABLE JGGZ.T_YZ_XT_DIMENMEMBER DROP PRIMARY KEY CASCADE;
2387 DROP TABLE JGGZ.T_YZ_XT_DIMENMEMBER CASCADE CONSTRAINTS;
2388
2389 CREATE TABLE JGGZ.T_YZ_XT_DIMENMEMBER
2390 (
2391 ID VARCHAR2(32 BYTE) NOT NULL,
2392 DIMENID VARCHAR2(255 BYTE),
2393 TYPE VARCHAR2(255 BYTE),
2394 PARENTID VARCHAR2(32 BYTE),
2395 NAME VARCHAR2(255 BYTE),
2396 ORDERCODE NUMBER,
2397 CHECKED VARCHAR2(1 BYTE)
2398 )
2399 NOLOGGING
2400 NOCACHE
2401 NOPARALLEL;
2402
2403
2404 ALTER TABLE JGGZ.T_YZ_XT_DISDIMENMEMBER DROP PRIMARY KEY CASCADE;
2405 DROP TABLE JGGZ.T_YZ_XT_DISDIMENMEMBER CASCADE CONSTRAINTS;
2406
2407 CREATE TABLE JGGZ.T_YZ_XT_DISDIMENMEMBER
2408 (
2409 ID VARCHAR2(255 BYTE) NOT NULL,
2410 VALUE VARCHAR2(2000 BYTE)
2411 )
2412 NOLOGGING
2413 NOCACHE
2414 NOPARALLEL;
2415
2416
2417 ALTER TABLE JGGZ.T_YZ_XT_DWTJ_CUBEDEFINE DROP PRIMARY KEY CASCADE;
2418 DROP TABLE JGGZ.T_YZ_XT_DWTJ_CUBEDEFINE CASCADE CONSTRAINTS;
2419
2420 CREATE TABLE JGGZ.T_YZ_XT_DWTJ_CUBEDEFINE
2421 (
2422 ID VARCHAR2(32 BYTE) NOT NULL,
2423 XAXISDIMENID VARCHAR2(32 BYTE),
2424 YAXISDIMENID VARCHAR2(32 BYTE),
2425 AAXISDIMENID VARCHAR2(2000 BYTE),
2426 AAXISDIMENMEMBERID VARCHAR2(2000 BYTE),
2427 ISCONTRASTED VARCHAR2(5 BYTE),
2428 STARTDATE DATE,
2429 ENDDATE DATE,
2430 TJLIMITS VARCHAR2(5 BYTE),
2431 DB VARCHAR2(32 BYTE),
2432 DBNAME VARCHAR2(255 BYTE),
2433 ZYJZ DATE,
2434 DBSTARTDATE DATE,
2435 DBENDDATE DATE,
2436 DBJZ DATE,
2437 ADDEDCONDITIONEXPRESSION VARCHAR2(2000 BYTE),
2438 SHOWEMPTYROW VARCHAR2(5 BYTE),
2439 SHOWEMPTYCOL VARCHAR2(5 BYTE),
2440 SHOWTOT VARCHAR2(5 BYTE),
2441 SHOWZJ VARCHAR2(5 BYTE),
2442 NAME VARCHAR2(255 BYTE),
2443 USERID VARCHAR2(32 BYTE)
2444 )
2445 LOGGING
2446 NOCACHE
2447 NOPARALLEL;
2448
2449
2450 ALTER TABLE JGGZ.T_YZ_XT_EDITBM DROP PRIMARY KEY CASCADE;
2451 DROP TABLE JGGZ.T_YZ_XT_EDITBM CASCADE CONSTRAINTS;
2452
2453 CREATE TABLE JGGZ.T_YZ_XT_EDITBM
2454 (
2455 ID VARCHAR2(32 BYTE) NOT NULL,
2456 TABLEID VARCHAR2(40 BYTE),
2457 FIELDID VARCHAR2(40 BYTE),
2458 BMLB VARCHAR2(5 BYTE),
2459 ORDERID VARCHAR2(2 BYTE)
2460 )
2461 LOGGING
2462 NOCACHE
2463 NOPARALLEL;
2464
2465
2466 ALTER TABLE JGGZ.T_YZ_XT_HOST DROP PRIMARY KEY CASCADE;
2467 DROP TABLE JGGZ.T_YZ_XT_HOST CASCADE CONSTRAINTS;
2468
2469 CREATE TABLE JGGZ.T_YZ_XT_HOST
2470 (
2471 ID VARCHAR2(32 BYTE) NOT NULL,
2472 SM VARCHAR2(100 BYTE),
2473 BM VARCHAR2(20 BYTE),
2474 PATH VARCHAR2(200 BYTE),
2475 HOSTADDR VARCHAR2(50 BYTE)
2476 )
2477 LOGGING
2478 NOCACHE
2479 NOPARALLEL;
2480
2481
2482 DROP TABLE JGGZ.T_YZ_XT_MRZ_ITEM CASCADE CONSTRAINTS;
2483
2484 CREATE TABLE JGGZ.T_YZ_XT_MRZ_ITEM
2485 (
2486 MIMODULEID VARCHAR2(32 BYTE),
2487 MIID VARCHAR2(32 BYTE),
2488 MICODE VARCHAR2(255 BYTE),
2489 MINAME VARCHAR2(255 BYTE),
2490 MIBML VARCHAR2(255 BYTE),
2491 MIBMLTYPE VARCHAR2(10 BYTE),
2492 MIBM VARCHAR2(255 BYTE)
2493 )
2494 LOGGING
2495 NOCACHE
2496 NOPARALLEL;
2497
2498
2499 DROP TABLE JGGZ.T_YZ_XT_MRZ_MODULE CASCADE CONSTRAINTS;
2500
2501 CREATE TABLE JGGZ.T_YZ_XT_MRZ_MODULE
2502 (
2503 MCID VARCHAR2(32 BYTE),
2504 MCCODE VARCHAR2(255 BYTE),
2505 MCNAME VARCHAR2(255 BYTE),
2506 MCBITPOS NUMBER
2507 )
2508 LOGGING
2509 NOCACHE
2510 NOPARALLEL;
2511
2512
2513 ALTER TABLE JGGZ.T_YZ_XT_MRZ_USED DROP PRIMARY KEY CASCADE;
2514 DROP TABLE JGGZ.T_YZ_XT_MRZ_USED CASCADE CONSTRAINTS;
2515
2516 CREATE TABLE JGGZ.T_YZ_XT_MRZ_USED
2517 (
2518 MUID VARCHAR2(32 BYTE),
2519 MUUSED CHAR(20 BYTE),
2520 ZF_ID VARCHAR2(12 BYTE)
2521 )
2522 LOGGING
2523 NOCACHE
2524 NOPARALLEL;
2525
2526
2527 ALTER TABLE JGGZ.T_YZ_XT_PARA DROP PRIMARY KEY CASCADE;
2528 DROP TABLE JGGZ.T_YZ_XT_PARA CASCADE CONSTRAINTS;
2529
2530 CREATE TABLE JGGZ.T_YZ_XT_PARA
2531 (
2532 PARAID VARCHAR2(255 BYTE) NOT NULL,
2533 PARANAME VARCHAR2(255 BYTE),
2534 PARACOMMENT VARCHAR2(255 BYTE),
2535 PARAVALUE VARCHAR2(2000 BYTE)
2536 )
2537 LOGGING
2538 NOCACHE
2539 NOPARALLEL;
2540
2541
2542 ALTER TABLE JGGZ.T_YZ_XT_QUERYCONFIG DROP PRIMARY KEY CASCADE;
2543 DROP TABLE JGGZ.T_YZ_XT_QUERYCONFIG CASCADE CONSTRAINTS;
2544
2545 CREATE TABLE JGGZ.T_YZ_XT_QUERYCONFIG
2546 (
2547 ID VARCHAR2(32 BYTE) NOT NULL,
2548 QCNAME VARCHAR2(32 BYTE),
2549 SQL VARCHAR2(4000 BYTE),
2550 COLUMN_TITLE VARCHAR2(1000 BYTE),
2551 MEMO VARCHAR2(500 BYTE),
2552 FIELD1 VARCHAR2(4000 BYTE),
2553 FIELD2 VARCHAR2(200 BYTE),
2554 C_DATE DATE,
2555 U_DATE DATE,
2556 C_USER VARCHAR2(32 BYTE),
2557 U_USER VARCHAR2(32 BYTE),
2558 SQL_CLOB CLOB
2559 )
2560 LOGGING
2561 NOCACHE
2562 NOPARALLEL;
2563
2564
2565 ALTER TABLE JGGZ.T_YZ_XT_SEQDIMENMEMBER DROP PRIMARY KEY CASCADE;
2566 DROP TABLE JGGZ.T_YZ_XT_SEQDIMENMEMBER CASCADE CONSTRAINTS;
2567
2568 CREATE TABLE JGGZ.T_YZ_XT_SEQDIMENMEMBER
2569 (
2570 ID VARCHAR2(255 BYTE) NOT NULL,
2571 STARTPOINT VARCHAR2(255 BYTE),
2572 ENDPOINT VARCHAR2(255 BYTE)
2573 )
2574 NOLOGGING
2575 NOCACHE
2576 NOPARALLEL;
2577
2578
2579 ALTER TABLE JGGZ.T_YZ_XT_WEB_POPEDOM DROP PRIMARY KEY CASCADE;
2580 DROP TABLE JGGZ.T_YZ_XT_WEB_POPEDOM CASCADE CONSTRAINTS;
2581
2582 CREATE TABLE JGGZ.T_YZ_XT_WEB_POPEDOM
2583 (
2584 ID VARCHAR2(32 BYTE) NOT NULL,
2585 ROLE_ID VARCHAR2(32 BYTE),
2586 WEB VARCHAR2(40 BYTE),
2587 FIELDNAME VARCHAR2(40 BYTE),
2588 FIELDPOPEDOM CHAR(1 BYTE),
2589 RANGE CHAR(1 BYTE),
2590 C_DATE DATE,
2591 U_DATE DATE,
2592 FIELDDES VARCHAR2(40 BYTE),
2593 WEBDES VARCHAR2(40 BYTE),
2594 FIELDTYPE CHAR(1 BYTE)
2595 )
2596 LOGGING
2597 NOCACHE
2598 NOPARALLEL;
2599
2600
2601 DROP TABLE JGGZ.T_YZ_XT_ZH CASCADE CONSTRAINTS;
2602
2603 CREATE TABLE JGGZ.T_YZ_XT_ZH
2604 (
2605 ZH_CN VARCHAR2(2 BYTE),
2606 PY VARCHAR2(10 BYTE)
2607 )
2608 LOGGING
2609 NOCACHE
2610 NOPARALLEL;
2611
2612
2613 ALTER TABLE JGGZ.T_YZ_ZFKG DROP PRIMARY KEY CASCADE;
2614 DROP TABLE JGGZ.T_YZ_ZFKG CASCADE CONSTRAINTS;
2615
2616 CREATE TABLE JGGZ.T_YZ_ZFKG
2617 (
2618 ID VARCHAR2(32 BYTE) NOT NULL,
2619 ZF_ID VARCHAR2(12 BYTE),
2620 KG_DATE DATE,
2621 SJR VARCHAR2(32 BYTE),
2622 LD_YJ VARCHAR2(1000 BYTE),
2623 SJ_DEP VARCHAR2(32 BYTE),
2624 ZDD_DEP VARCHAR2(32 BYTE),
2625 ZD_DATE DATE,
2626 ZDJSR VARCHAR2(32 BYTE),
2627 KG_CONTENT VARCHAR2(2000 BYTE),
2628 IS_VERIFIED VARCHAR2(20 BYTE),
2629 RESULT VARCHAR2(1000 BYTE),
2630 MEMO VARCHAR2(1000 BYTE),
2631 C_DATE DATE,
2632 U_DATE DATE,
2633 DEL_FLAG CHAR(1 BYTE),
2634 ZD_NO1 VARCHAR2(64 BYTE),
2635 ZD_NO2 VARCHAR2(64 BYTE)
2636 )
2637 NOLOGGING
2638 NOCACHE
2639 NOPARALLEL;
2640
2641
2642 ALTER TABLE JGGZ.T_YZ_ZFKG_MB DROP PRIMARY KEY CASCADE;
2643 DROP TABLE JGGZ.T_YZ_ZFKG_MB CASCADE CONSTRAINTS;
2644
2645 CREATE TABLE JGGZ.T_YZ_ZFKG_MB
2646 (
2647 KG_ID VARCHAR2(32 BYTE) NOT NULL,
2648 ID VARCHAR2(32 BYTE),
2649 KG_NAME VARCHAR2(64 BYTE),
2650 KG_ZW VARCHAR2(64 BYTE),
2651 KG_SF VARCHAR2(64 BYTE)
2652 )
2653 NOLOGGING
2654 NOCACHE
2655 NOPARALLEL;
2656
2657
2658 ALTER TABLE JGGZ.T_YZ_ZFLJ DROP PRIMARY KEY CASCADE;
2659 DROP TABLE JGGZ.T_YZ_ZFLJ CASCADE CONSTRAINTS;
2660
2661 CREATE TABLE JGGZ.T_YZ_ZFLJ
2662 (
2663 ID VARCHAR2(32 BYTE) NOT NULL,
2664 ZF_ID VARCHAR2(12 BYTE),
2665 LJ_TYPE VARCHAR2(20 BYTE),
2666 LJ_DOC_NO VARCHAR2(64 BYTE),
2667 LJ_ADDR_XZQH VARCHAR2(16 BYTE),
2668 LJ_ADDR_DETAIL VARCHAR2(256 BYTE),
2669 LJ_POL VARCHAR2(32 BYTE),
2670 LJ_DATE DATE,
2671 PJ_NO1 VARCHAR2(16 BYTE),
2672 PJ_NO2 VARCHAR2(32 BYTE),
2673 PJXZQH VARCHAR2(32 BYTE),
2674 PJJG VARCHAR2(32 BYTE),
2675 PJDATE DATE,
2676 C_USER VARCHAR2(64 BYTE),
2677 LJ_STATUS CHAR(1 BYTE),
2678 SJ_DATE DATE,
2679 DR_DATE DATE,
2680 YDB VARCHAR2(32 BYTE),
2681 MEMO VARCHAR2(1000 BYTE),
2682 C_DATE DATE,
2683 U_DATE DATE,
2684 DEL_FLAG CHAR(1 BYTE)
2685 )
2686 LOGGING
2687 NOCACHE
2688 NOPARALLEL;
2689
2690
2691 ALTER TABLE JGGZ.T_YZ_ZFSS DROP PRIMARY KEY CASCADE;
2692 DROP TABLE JGGZ.T_YZ_ZFSS CASCADE CONSTRAINTS;
2693
2694 CREATE TABLE JGGZ.T_YZ_ZFSS
2695 (
2696 ID VARCHAR2(32 BYTE) NOT NULL,
2697 ZF_ID VARCHAR2(12 BYTE),
2698 ZF_DB VARCHAR2(16 BYTE),
2699 SS_DATE DATE,
2700 ZY_REASON VARCHAR2(500 BYTE),
2701 SEND_DEP VARCHAR2(64 BYTE),
2702 SEND_DATE DATE,
2703 DF_DATE DATE,
2704 FS_DW VARCHAR2(64 BYTE),
2705 MEMO VARCHAR2(1000 BYTE),
2706 C_DATE DATE,
2707 U_DATE DATE,
2708 DEL_FLAG CHAR(1 BYTE),
2709 SS_TYPE VARCHAR2(6 BYTE),
2710 SS_RESULT VARCHAR2(6 BYTE)
2711 )
2712 LOGGING
2713 NOCACHE
2714 NOPARALLEL;
2715
2716
2717 ALTER TABLE JGGZ.T_YZ_ZFSSXX DROP PRIMARY KEY CASCADE;
2718 DROP TABLE JGGZ.T_YZ_ZFSSXX CASCADE CONSTRAINTS;
2719
2720 CREATE TABLE JGGZ.T_YZ_ZFSSXX
2721 (
2722 ID VARCHAR2(32 BYTE) NOT NULL,
2723 ZF_ID VARCHAR2(12 BYTE),
2724 SP_ID VARCHAR2(10 BYTE),
2725 SS_DW VARCHAR2(100 BYTE),
2726 SS_PCS VARCHAR2(6 BYTE),
2727 ZZ_LB VARCHAR2(6 BYTE),
2728 SS_LB VARCHAR2(6 BYTE),
2729 SS_QR DATE,
2730 SS_ZR DATE,
2731 PZ_DATE DATE,
2732 ZX_DATE DATE,
2733 LJ_DATE DATE,
2734 HJ_DATE DATE,
2735 SS_CONTENT VARCHAR2(500 BYTE),
2736 MEMO VARCHAR2(500 BYTE),
2737 C_DATE DATE,
2738 U_DATE DATE,
2739 DEL_FLAG CHAR(1 BYTE),
2740 DW_XZQH VARCHAR2(32 BYTE)
2741 )
2742 NOLOGGING
2743 NOCACHE
2744 NOPARALLEL;
2745
2746
2747 DROP TABLE JGGZ.T_YZ_ZF_BH CASCADE CONSTRAINTS;
2748
2749 CREATE TABLE JGGZ.T_YZ_ZF_BH
2750 (
2751 ID VARCHAR2(32 BYTE) NOT NULL,
2752 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
2753 RUN_CASE_NO VARCHAR2(20 BYTE),
2754 CATCH_DATE DATE,
2755 CATCH_TYPE VARCHAR2(6 BYTE),
2756 CATCH_COURSE VARCHAR2(4000 BYTE),
2757 CRI_INFO VARCHAR2(4000 BYTE),
2758 LESSON VARCHAR2(4000 BYTE),
2759 CL_YJ VARCHAR2(4000 BYTE),
2760 XWC_YJ VARCHAR2(1000 BYTE),
2761 XWC_QPR VARCHAR2(32 BYTE),
2762 XWC_QP_DATE DATE,
2763 JAIL_YJ VARCHAR2(1000 BYTE),
2764 JAIL_QPR VARCHAR2(32 BYTE),
2765 JAIL_QP_DATE DATE,
2766 MEMO VARCHAR2(4000 BYTE),
2767 C_DATE DATE NOT NULL,
2768 U_DATE DATE NOT NULL,
2769 DEL_FLAG CHAR(1 BYTE) NOT NULL
2770 )
2771 LOGGING
2772 NOCACHE
2773 NOPARALLEL;
2774
2775
2776 ALTER TABLE JGGZ.T_YZ_ZF_BSJ DROP PRIMARY KEY CASCADE;
2777 DROP TABLE JGGZ.T_YZ_ZF_BSJ CASCADE CONSTRAINTS;
2778
2779 CREATE TABLE JGGZ.T_YZ_ZF_BSJ
2780 (
2781 BSJ_NO VARCHAR2(32 BYTE) NOT NULL,
2782 ZF_ID VARCHAR2(12 BYTE),
2783 TZS_NO1 VARCHAR2(8 BYTE),
2784 TZS_NO2 VARCHAR2(16 BYTE),
2785 PJ_DEPT VARCHAR2(6 BYTE),
2786 PJ_JG VARCHAR2(64 BYTE),
2787 XDZXTZS_DATE DATE,
2788 YS_UNIT_AREA VARCHAR2(6 BYTE),
2789 YS_UNIT_ADDR VARCHAR2(64 BYTE),
2790 YSR VARCHAR2(32 BYTE),
2791 SEND_DATE DATE,
2792 JBR VARCHAR2(32 BYTE),
2793 BSJ_TYPE VARCHAR2(6 BYTE),
2794 BSJ_REASON VARCHAR2(1024 BYTE),
2795 UNTREAD_DATE DATE,
2796 SY_STATUS VARCHAR2(6 BYTE),
2797 C_DATE DATE,
2798 U_DATE DATE,
2799 DEL_FLAG CHAR(1 BYTE),
2800 ZF_NAME VARCHAR2(32 BYTE),
2801 XB VARCHAR2(32 BYTE),
2802 CSRQ VARCHAR2(32 BYTE),
2803 XQ VARCHAR2(32 BYTE),
2804 ZM VARCHAR2(60 BYTE)
2805 )
2806 LOGGING
2807 NOCACHE
2808 NOPARALLEL;
2809
2810
2811 ALTER TABLE JGGZ.T_YZ_ZF_BWXB DROP PRIMARY KEY CASCADE;
2812 DROP TABLE JGGZ.T_YZ_ZF_BWXB CASCADE CONSTRAINTS;
2813
2814 CREATE TABLE JGGZ.T_YZ_ZF_BWXB
2815 (
2816 ID VARCHAR2(32 BYTE) NOT NULL,
2817 ZF_ID VARCHAR2(12 BYTE),
2818 PZDATE DATE,
2819 XBNX VARCHAR2(8 BYTE),
2820 ENDDATE DATE,
2821 SM VARCHAR2(1000 BYTE),
2822 STARTDATE DATE,
2823 DB VARCHAR2(20 BYTE),
2824 C_DATE DATE,
2825 U_DATE DATE,
2826 DEL_FLAG VARCHAR2(1 BYTE),
2827 JWBWID VARCHAR2(32 BYTE)
2828 )
2829 LOGGING
2830 NOCACHE
2831 NOPARALLEL;
2832
2833
2834 ALTER TABLE JGGZ.T_YZ_ZF_CRJ_INFO DROP PRIMARY KEY CASCADE;
2835 DROP TABLE JGGZ.T_YZ_ZF_CRJ_INFO CASCADE CONSTRAINTS;
2836
2837 CREATE TABLE JGGZ.T_YZ_ZF_CRJ_INFO
2838 (
2839 ID VARCHAR2(32 BYTE) NOT NULL,
2840 ZF_ID VARCHAR2(12 BYTE),
2841 RJ_DATE DATE,
2842 LJ_DATE DATE,
2843 DB VARCHAR2(32 BYTE),
2844 LJ_TYPE VARCHAR2(12 BYTE),
2845 RJ_TYPE VARCHAR2(12 BYTE),
2846 C_DATE DATE,
2847 U_DATE DATE,
2848 DEL_FLAG CHAR(1 BYTE),
2849 DDFLAG CHAR(1 BYTE),
2850 LJQX VARCHAR2(20 BYTE),
2851 DRDB VARCHAR2(32 BYTE)
2852 )
2853 LOGGING
2854 NOCACHE
2855 NOPARALLEL;
2856
2857
2858 ALTER TABLE JGGZ.T_YZ_ZF_DBDD DROP PRIMARY KEY CASCADE;
2859 DROP TABLE JGGZ.T_YZ_ZF_DBDD CASCADE CONSTRAINTS;
2860
2861 CREATE TABLE JGGZ.T_YZ_ZF_DBDD
2862 (
2863 ID VARCHAR2(32 BYTE) NOT NULL,
2864 ZF_ID VARCHAR2(12 BYTE),
2865 DD_DATE DATE,
2866 DDQ_DB VARCHAR2(32 BYTE),
2867 DDH_DB VARCHAR2(32 BYTE),
2868 C_DATE DATE,
2869 U_DATE DATE,
2870 DEL_FLAG CHAR(1 BYTE)
2871 )
2872 LOGGING
2873 NOCACHE
2874 NOPARALLEL;
2875
2876
2877 DROP TABLE JGGZ.T_YZ_ZF_DFBG CASCADE CONSTRAINTS;
2878
2879 CREATE TABLE JGGZ.T_YZ_ZF_DFBG
2880 (
2881 ID VARCHAR2(32 BYTE) NOT NULL,
2882 ZF_ID VARCHAR2(12 BYTE),
2883 DD_DATE VARCHAR2(20 BYTE),
2884 DDQ_DW VARCHAR2(32 BYTE),
2885 DDH_DW VARCHAR2(32 BYTE),
2886 RECEIVE_FLAG CHAR(1 BYTE),
2887 C_DATE DATE,
2888 U_DATE DATE,
2889 DEL_FLAG CHAR(1 BYTE),
2890 ZF_NAME VARCHAR2(32 BYTE),
2891 ZF_FH VARCHAR2(32 BYTE),
2892 SYNC_FILE VARCHAR2(64 BYTE),
2893 SYNC_SUCCESS CHAR(1 BYTE),
2894 CZ_DATE VARCHAR2(20 BYTE)
2895 )
2896 LOGGING
2897 NOCACHE
2898 NOPARALLEL;
2899
2900
2901 ALTER TABLE JGGZ.T_YZ_ZF_DSJ DROP PRIMARY KEY CASCADE;
2902 DROP TABLE JGGZ.T_YZ_ZF_DSJ CASCADE CONSTRAINTS;
2903
2904 CREATE TABLE JGGZ.T_YZ_ZF_DSJ
2905 (
2906 ID VARCHAR2(32 BYTE) NOT NULL,
2907 JSDATE DATE,
2908 JSTYPE VARCHAR2(20 BYTE),
2909 JSCONTENT VARCHAR2(1000 BYTE),
2910 JSJG VARCHAR2(1000 BYTE),
2911 C_DATE DATE,
2912 U_DATE DATE,
2913 DEL_FLAG VARCHAR2(1 BYTE),
2914 DB VARCHAR2(20 BYTE)
2915 )
2916 LOGGING
2917 NOCACHE
2918 NOPARALLEL;
2919
2920
2921 ALTER TABLE JGGZ.T_YZ_ZF_FGDJ DROP PRIMARY KEY CASCADE;
2922 DROP TABLE JGGZ.T_YZ_ZF_FGDJ CASCADE CONSTRAINTS;
2923
2924 CREATE TABLE JGGZ.T_YZ_ZF_FGDJ
2925 (
2926 ID VARCHAR2(32 BYTE) NOT NULL,
2927 ZF_ID VARCHAR2(12 BYTE),
2928 PZ_DATE DATE,
2929 BDH_DJ VARCHAR2(32 BYTE),
2930 BDQ_DJ VARCHAR2(32 BYTE),
2931 C_DATE DATE,
2932 U_DATE DATE,
2933 DEL_FLAG CHAR(1 BYTE),
2934 DB VARCHAR2(32 BYTE)
2935 )
2936 LOGGING
2937 NOCACHE
2938 NOPARALLEL;
2939
2940
2941 DROP TABLE JGGZ.T_YZ_ZF_FJXX CASCADE CONSTRAINTS;
2942
2943 CREATE TABLE JGGZ.T_YZ_ZF_FJXX
2944 (
2945 ZF_ID VARCHAR2(12 BYTE),
2946 YPDYZM VARCHAR2(255 BYTE),
2947 YPXQ VARCHAR2(8 BYTE)
2948 )
2949 LOGGING
2950 NOCACHE
2951 NOPARALLEL;
2952
2953
2954 ALTER TABLE JGGZ.T_YZ_ZF_FK DROP PRIMARY KEY CASCADE;
2955 DROP TABLE JGGZ.T_YZ_ZF_FK CASCADE CONSTRAINTS;
2956
2957 CREATE TABLE JGGZ.T_YZ_ZF_FK
2958 (
2959 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
2960 BQDW_ADDR_XZQH VARCHAR2(32 BYTE),
2961 BQDW_ADDR_DETAIL VARCHAR2(200 BYTE),
2962 BIRTH_ADDR_XZQH VARCHAR2(32 BYTE),
2963 BIRTH_ADDR_DETAIL VARCHAR2(200 BYTE),
2964 JS_NO VARCHAR2(24 BYTE),
2965 CW_NO VARCHAR2(24 BYTE),
2966 JGGJ VARCHAR2(50 BYTE),
2967 DACY_MJ VARCHAR2(64 BYTE),
2968 MEDIA_FILE_NO VARCHAR2(32 BYTE),
2969 RJ_MEMO VARCHAR2(4000 BYTE),
2970 PARTY_MEMO VARCHAR2(4000 BYTE),
2971 FEEDBACK VARCHAR2(4000 BYTE),
2972 C_DATE DATE,
2973 U_DATE DATE,
2974 DEL_FLAG CHAR(1 BYTE),
2975 FZ_FACT CLOB
2976 )
2977 NOLOGGING
2978 NOCACHE
2979 NOPARALLEL;
2980
2981
2982 ALTER TABLE JGGZ.T_YZ_ZF_FLFA DROP PRIMARY KEY CASCADE;
2983 DROP TABLE JGGZ.T_YZ_ZF_FLFA CASCADE CONSTRAINTS;
2984
2985 CREATE TABLE JGGZ.T_YZ_ZF_FLFA
2986 (
2987 PLAN_NO VARCHAR2(32 BYTE) NOT NULL,
2988 PLAN_NAME VARCHAR2(64 BYTE),
2989 FOUNDER VARCHAR2(64 BYTE),
2990 CREATED_DATE DATE,
2991 MODIFID_DATE DATE,
2992 CONFIRM_DATE DATE,
2993 QR_FLAG CHAR(1 BYTE),
2994 START_DATE DATE,
2995 END_DATE DATE,
2996 C_DATE DATE,
2997 U_DATE DATE,
2998 DEL_FLAG CHAR(1 BYTE)
2999 )
3000 NOLOGGING
3001 NOCACHE
3002 NOPARALLEL;
3003
3004
3005 ALTER TABLE JGGZ.T_YZ_ZF_FLFAMC DROP PRIMARY KEY CASCADE;
3006 DROP TABLE JGGZ.T_YZ_ZF_FLFAMC CASCADE CONSTRAINTS;
3007
3008 CREATE TABLE JGGZ.T_YZ_ZF_FLFAMC
3009 (
3010 PLAN_NO VARCHAR2(32 BYTE),
3011 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
3012 YDB VARCHAR2(20 BYTE),
3013 JSDWID VARCHAR2(32 BYTE),
3014 FLREASON VARCHAR2(500 BYTE)
3015 )
3016 LOGGING
3017 NOCACHE
3018 NOPARALLEL;
3019
3020
3021 ALTER TABLE JGGZ.T_YZ_ZF_FLSZ DROP PRIMARY KEY CASCADE;
3022 DROP TABLE JGGZ.T_YZ_ZF_FLSZ CASCADE CONSTRAINTS;
3023
3024 CREATE TABLE JGGZ.T_YZ_ZF_FLSZ
3025 (
3026 ID VARCHAR2(32 BYTE) NOT NULL,
3027 JSDW VARCHAR2(100 BYTE),
3028 MAX NUMBER DEFAULT 0,
3029 CURHAVE NUMBER DEFAULT 0,
3030 YFLFLAG VARCHAR2(1 BYTE) DEFAULT 1
3031 )
3032 LOGGING
3033 NOCACHE
3034 NOPARALLEL;
3035
3036
3037 DROP TABLE JGGZ.T_YZ_ZF_FLTEMP CASCADE CONSTRAINTS;
3038
3039 CREATE TABLE JGGZ.T_YZ_ZF_FLTEMP
3040 (
3041 SESSIONID VARCHAR2(36 BYTE),
3042 JSDWID VARCHAR2(32 BYTE),
3043 JSDW VARCHAR2(100 BYTE),
3044 FLSTATUS VARCHAR2(1 BYTE),
3045 ZFID VARCHAR2(12 BYTE),
3046 ZFFH VARCHAR2(5 BYTE),
3047 ZFNAME VARCHAR2(32 BYTE),
3048 PJJGXZQH VARCHAR2(32 BYTE),
3049 PJJGZXJG VARCHAR2(50 BYTE),
3050 PJZ VARCHAR2(50 BYTE),
3051 PJH VARCHAR2(16 BYTE),
3052 ZFSOURCE VARCHAR2(64 BYTE),
3053 DB VARCHAR2(32 BYTE),
3054 DRDATE DATE,
3055 GENDER VARCHAR2(32 BYTE),
3056 BIRTH DATE,
3057 XQ VARCHAR2(8 BYTE),
3058 XQENDDATE DATE,
3059 FYTYPE VARCHAR2(32 BYTE),
3060 ZM VARCHAR2(500 BYTE),
3061 HJXZQH VARCHAR2(32 BYTE),
3062 HJADDR VARCHAR2(64 BYTE),
3063 LBC VARCHAR2(32 BYTE),
3064 SJTYPE VARCHAR2(32 BYTE),
3065 TIAOJIANMS VARCHAR2(500 BYTE),
3066 BQWH VARCHAR2(32 BYTE),
3067 BQZY VARCHAR2(32 BYTE),
3068 LGF VARCHAR2(32 BYTE),
3069 LJ VARCHAR2(4 BYTE),
3070 QK VARCHAR2(4 BYTE),
3071 YX VARCHAR2(8 BYTE),
3072 FLREASON VARCHAR2(500 BYTE),
3073 THFLAG VARCHAR2(1 BYTE) DEFAULT 0,
3074 XSCY VARCHAR2(32 BYTE)
3075 )
3076 NOLOGGING
3077 NOCACHE
3078 NOPARALLEL;
3079
3080
3081 ALTER TABLE JGGZ.T_YZ_ZF_FLTJ DROP PRIMARY KEY CASCADE;
3082 DROP TABLE JGGZ.T_YZ_ZF_FLTJ CASCADE CONSTRAINTS;
3083
3084 CREATE TABLE JGGZ.T_YZ_ZF_FLTJ
3085 (
3086 ID VARCHAR2(32 BYTE) NOT NULL,
3087 JSDWID VARCHAR2(32 BYTE),
3088 SQL VARCHAR2(2000 BYTE),
3089 TEXT VARCHAR2(2000 BYTE),
3090 TIAOJIANTYPE VARCHAR2(1 BYTE),
3091 SM VARCHAR2(500 BYTE),
3092 ZDZF VARCHAR2(2000 BYTE),
3093 RS VARCHAR2(8 BYTE)
3094 )
3095 LOGGING
3096 NOCACHE
3097 NOPARALLEL;
3098
3099
3100 DROP TABLE JGGZ.T_YZ_ZF_FYLX CASCADE CONSTRAINTS;
3101
3102 CREATE TABLE JGGZ.T_YZ_ZF_FYLX
3103 (
3104 ID NUMBER(10) NOT NULL,
3105 LB VARCHAR2(2 BYTE),
3106 BM VARCHAR2(8 BYTE),
3107 FJXX VARCHAR2(50 BYTE),
3108 LRSJ DATE,
3109 XGSJ RAW(8) NOT NULL
3110 )
3111 LOGGING
3112 NOCACHE
3113 NOPARALLEL;
3114
3115
3116 ALTER TABLE JGGZ.T_YZ_ZF_HBKC DROP PRIMARY KEY CASCADE;
3117 DROP TABLE JGGZ.T_YZ_ZF_HBKC CASCADE CONSTRAINTS;
3118
3119 CREATE TABLE JGGZ.T_YZ_ZF_HBKC
3120 (
3121 ID VARCHAR2(32 BYTE) NOT NULL,
3122 ZF_ID VARCHAR2(12 BYTE),
3123 HBKCTYPE VARCHAR2(20 BYTE),
3124 HBKCDATE DATE,
3125 HBKCNAME VARCHAR2(20 BYTE),
3126 HBKCLX VARCHAR2(20 BYTE),
3127 JMZF VARCHAR2(20 BYTE),
3128 JMQS VARCHAR2(20 BYTE),
3129 JMDDZF VARCHAR2(20 BYTE),
3130 JMPCS VARCHAR2(20 BYTE),
3131 QK VARCHAR2(1000 BYTE),
3132 C_DATE DATE,
3133 U_DATE DATE,
3134 DEL_FLAG VARCHAR2(1 BYTE),
3135 JWBWID VARCHAR2(32 BYTE)
3136 )
3137 LOGGING
3138 NOCACHE
3139 NOPARALLEL;
3140
3141
3142 ALTER TABLE JGGZ.T_YZ_ZF_JK DROP PRIMARY KEY CASCADE;
3143 DROP TABLE JGGZ.T_YZ_ZF_JK CASCADE CONSTRAINTS;
3144
3145 CREATE TABLE JGGZ.T_YZ_ZF_JK
3146 (
3147 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
3148 ZF_FH VARCHAR2(5 BYTE),
3149 ZF_NAME VARCHAR2(80 BYTE),
3150 ZB_NAME VARCHAR2(80 BYTE),
3151 ZF_GENDER VARCHAR2(32 BYTE),
3152 ZF_BIRTH DATE,
3153 ZF_MZ VARCHAR2(32 BYTE),
3154 ZF_MARRIAGE VARCHAR2(32 BYTE),
3155 PJ_NO1 VARCHAR2(50 BYTE),
3156 PJ_NO2 VARCHAR2(16 BYTE),
3157 ZM VARCHAR2(100 BYTE),
3158 XZ VARCHAR2(32 BYTE),
3159 XQ VARCHAR2(8 BYTE),
3160 XQ_START_DATE DATE,
3161 XQ_END_DATE DATE,
3162 BZNX VARCHAR2(8 BYTE),
3163 ZF_SOURCE VARCHAR2(64 BYTE),
3164 FY_TYPE VARCHAR2(32 BYTE),
3165 NYDW VARCHAR2(32 BYTE),
3166 JY_FLAG CHAR(1 BYTE),
3167 JYXQ VARCHAR2(8 BYTE),
3168 JY_START_DATE DATE,
3169 JY_END_DATE DATE,
3170 SJ_TYPE VARCHAR2(32 BYTE),
3171 SY_STATUS VARCHAR2(32 BYTE),
3172 SC_CA VARCHAR2(32 BYTE),
3173 HJ_ADDR_XZQH VARCHAR2(32 BYTE),
3174 HJ_ADDR_DETAIL VARCHAR2(64 BYTE),
3175 C_DATE DATE,
3176 U_DATE DATE,
3177 DEL_FLAG CHAR(1 BYTE),
3178 FL_FLAG CHAR(1 BYTE),
3179 C_USER VARCHAR2(32 BYTE),
3180 DB VARCHAR2(32 BYTE)
3181 )
3182 LOGGING
3183 NOCACHE
3184 NOPARALLEL;
3185
3186
3187 DROP TABLE JGGZ.T_YZ_ZF_JK_20060526184028 CASCADE CONSTRAINTS;
3188
3189 CREATE TABLE JGGZ.T_YZ_ZF_JK_20060526184028
3190 (
3191 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
3192 ZF_FH VARCHAR2(5 BYTE),
3193 ZF_NAME VARCHAR2(80 BYTE),
3194 ZB_NAME VARCHAR2(80 BYTE),
3195 ZF_GENDER VARCHAR2(32 BYTE),
3196 ZF_BIRTH DATE,
3197 ZF_MZ VARCHAR2(32 BYTE),
3198 ZF_MARRIAGE VARCHAR2(32 BYTE),
3199 PJ_NO1 VARCHAR2(50 BYTE),
3200 PJ_NO2 VARCHAR2(16 BYTE),
3201 ZM VARCHAR2(32 BYTE),
3202 XZ VARCHAR2(32 BYTE),
3203 XQ VARCHAR2(8 BYTE),
3204 XQ_START_DATE DATE,
3205 XQ_END_DATE DATE,
3206 BZNX VARCHAR2(8 BYTE),
3207 ZF_SOURCE VARCHAR2(64 BYTE),
3208 FY_TYPE VARCHAR2(32 BYTE),
3209 NYDW VARCHAR2(32 BYTE),
3210 JY_FLAG CHAR(1 BYTE),
3211 JYXQ VARCHAR2(8 BYTE),
3212 JY_START_DATE DATE,
3213 JY_END_DATE DATE,
3214 SJ_TYPE VARCHAR2(32 BYTE),
3215 SY_STATUS VARCHAR2(32 BYTE),
3216 SC_CA VARCHAR2(32 BYTE),
3217 HJ_ADDR_XZQH VARCHAR2(32 BYTE),
3218 HJ_ADDR_DETAIL VARCHAR2(64 BYTE),
3219 C_DATE DATE,
3220 U_DATE DATE,
3221 DEL_FLAG CHAR(1 BYTE),
3222 FL_FLAG CHAR(1 BYTE),
3223 C_USER VARCHAR2(32 BYTE),
3224 DB VARCHAR2(32 BYTE)
3225 )
3226 LOGGING
3227 NOCACHE
3228 NOPARALLEL;
3229
3230
3231 ALTER TABLE JGGZ.T_YZ_ZF_JL DROP PRIMARY KEY CASCADE;
3232 DROP TABLE JGGZ.T_YZ_ZF_JL CASCADE CONSTRAINTS;
3233
3234 CREATE TABLE JGGZ.T_YZ_ZF_JL
3235 (
3236 ID VARCHAR2(32 BYTE) NOT NULL,
3237 ZF_ID VARCHAR2(12 BYTE),
3238 START_DATE VARCHAR2(32 BYTE),
3239 END_DATE VARCHAR2(32 BYTE),
3240 DW_ADDR_XZQH VARCHAR2(32 BYTE),
3241 DW_ADDR_DETAIL VARCHAR2(200 BYTE),
3242 DW_MC VARCHAR2(200 BYTE),
3243 ZF_ZY VARCHAR2(32 BYTE),
3244 ZF_ZW VARCHAR2(32 BYTE),
3245 MEMO VARCHAR2(4000 BYTE),
3246 C_DATE DATE,
3247 U_DATE DATE,
3248 DEL_FLAG CHAR(1 BYTE),
3249 HJ_XZQH VARCHAR2(32 BYTE),
3250 HJ_DETAIL VARCHAR2(64 BYTE),
3251 XH VARCHAR2(10 BYTE)
3252 )
3253 LOGGING
3254 NOCACHE
3255 NOPARALLEL;
3256
3257
3258 ALTER TABLE JGGZ.T_YZ_ZF_JLXX DROP PRIMARY KEY CASCADE;
3259 DROP TABLE JGGZ.T_YZ_ZF_JLXX CASCADE CONSTRAINTS;
3260
3261 CREATE TABLE JGGZ.T_YZ_ZF_JLXX
3262 (
3263 JL_NO VARCHAR2(32 BYTE) NOT NULL,
3264 ZF_ID VARCHAR2(12 BYTE),
3265 SPB_NO VARCHAR2(32 BYTE),
3266 TYPE VARCHAR2(20 BYTE),
3267 REASON VARCHAR2(300 BYTE),
3268 DETAIL_DESC VARCHAR2(4000 BYTE),
3269 MEMO VARCHAR2(4000 BYTE),
3270 C_DATE DATE,
3271 U_DATE DATE,
3272 DEL_FLAG CHAR(1 BYTE),
3273 C_USER VARCHAR2(32 BYTE),
3274 TZS_NO1 VARCHAR2(32 BYTE),
3275 TZS_NO2 VARCHAR2(32 BYTE),
3276 TZ_DATE DATE,
3277 TZR VARCHAR2(32 BYTE),
3278 START_DATE DATE,
3279 END_DATE DATE,
3280 STATUS CHAR(1 BYTE),
3281 DB VARCHAR2(32 BYTE)
3282 )
3283 LOGGING
3284 NOCACHE
3285 NOPARALLEL;
3286
3287
3288 DROP TABLE JGGZ.T_YZ_ZF_JLXX_BAK CASCADE CONSTRAINTS;
3289
3290 CREATE TABLE JGGZ.T_YZ_ZF_JLXX_BAK
3291 (
3292 JL_NO VARCHAR2(32 BYTE) NOT NULL,
3293 ZF_ID VARCHAR2(12 BYTE),
3294 SPB_NO VARCHAR2(32 BYTE),
3295 TYPE VARCHAR2(20 BYTE),
3296 REASON VARCHAR2(300 BYTE),
3297 DETAIL_DESC VARCHAR2(4000 BYTE),
3298 MEMO VARCHAR2(4000 BYTE),
3299 C_DATE DATE,
3300 U_DATE DATE,
3301 DEL_FLAG CHAR(1 BYTE),
3302 C_USER VARCHAR2(32 BYTE),
3303 TZS_NO1 VARCHAR2(32 BYTE),
3304 TZS_NO2 VARCHAR2(32 BYTE),
3305 TZ_DATE DATE,
3306 TZR VARCHAR2(32 BYTE),
3307 START_DATE DATE,
3308 END_DATE DATE,
3309 STATUS CHAR(1 BYTE),
3310 DB VARCHAR2(32 BYTE)
3311 )
3312 LOGGING
3313 NOCACHE
3314 NOPARALLEL;
3315
3316
3317 ALTER TABLE JGGZ.T_YZ_ZF_JWBW DROP PRIMARY KEY CASCADE;
3318 DROP TABLE JGGZ.T_YZ_ZF_JWBW CASCADE CONSTRAINTS;
3319
3320 CREATE TABLE JGGZ.T_YZ_ZF_JWBW
3321 (
3322 ID VARCHAR2(32 BYTE) NOT NULL,
3323 ZF_ID VARCHAR2(12 BYTE),
3324 ZXTYPE VARCHAR2(20 BYTE),
3325 BRNAME VARCHAR2(20 BYTE),
3326 BRRELATION VARCHAR2(20 BYTE),
3327 BRADDRXZQH VARCHAR2(20 BYTE),
3328 BRADDRESS VARCHAR2(100 BYTE),
3329 BRDWXZQH VARCHAR2(20 BYTE),
3330 BRDW VARCHAR2(100 BYTE),
3331 BWADDRXZQH VARCHAR2(20 BYTE),
3332 BWADDRESS VARCHAR2(100 BYTE),
3333 POLICEXZQH VARCHAR2(20 BYTE),
3334 POLICE VARCHAR2(100 BYTE),
3335 OFFICER VARCHAR2(20 BYTE),
3336 OFFICERTEL VARCHAR2(20 BYTE),
3337 SJDATE DATE,
3338 ZZTYPE VARCHAR2(20 BYTE),
3339 DB VARCHAR2(20 BYTE),
3340 MEMO VARCHAR2(1000 BYTE),
3341 C_DATE DATE,
3342 U_DATE DATE,
3343 DEL_FLAG VARCHAR2(1 BYTE),
3344 BRTEL VARCHAR2(20 BYTE),
3345 HOSPITAL VARCHAR2(100 BYTE),
3346 STARTDATE DATE,
3347 SWREASON VARCHAR2(1000 BYTE)
3348 )
3349 LOGGING
3350 NOCACHE
3351 NOPARALLEL;
3352
3353
3354 ALTER TABLE JGGZ.T_YZ_ZF_LBC DROP PRIMARY KEY CASCADE;
3355 DROP TABLE JGGZ.T_YZ_ZF_LBC CASCADE CONSTRAINTS;
3356
3357 CREATE TABLE JGGZ.T_YZ_ZF_LBC
3358 (
3359 LBC_NO VARCHAR2(32 BYTE) NOT NULL,
3360 SP_ID VARCHAR2(10 BYTE),
3361 ZF_ID VARCHAR2(12 BYTE),
3362 LBCSP_NO VARCHAR2(32 BYTE),
3363 LBC_TYPE VARCHAR2(6 BYTE),
3364 SICK_HISTORY VARCHAR2(4000 BYTE),
3365 BC_TYPE VARCHAR2(6 BYTE),
3366 DJ_DATE DATE,
3367 SC_INFO VARCHAR2(2000 BYTE),
3368 BC_YJ VARCHAR2(4000 BYTE),
3369 HOSPITAL_YJ VARCHAR2(4000 BYTE),
3370 HOSPITAL_DATE DATE,
3371 CXLBC_DATE DATE,
3372 JD_YS1 VARCHAR2(20 BYTE),
3373 YS_ZW1 VARCHAR2(6 BYTE),
3374 YS_ZC1 VARCHAR2(6 BYTE),
3375 JD_YS2 VARCHAR2(20 BYTE),
3376 YS_ZW2 VARCHAR2(6 BYTE),
3377 YS_ZC2 VARCHAR2(6 BYTE),
3378 JD_YS3 VARCHAR2(20 BYTE),
3379 YS_ZW3 VARCHAR2(6 BYTE),
3380 YS_ZC3 VARCHAR2(6 BYTE),
3381 C_DATE DATE,
3382 U_DATE DATE,
3383 DEL_FLAG CHAR(1 BYTE)
3384 )
3385 NOLOGGING
3386 NOCACHE
3387 NOPARALLEL;
3388
3389
3390 ALTER TABLE JGGZ.T_YZ_ZF_LBC_FS DROP PRIMARY KEY CASCADE;
3391 DROP TABLE JGGZ.T_YZ_ZF_LBC_FS CASCADE CONSTRAINTS;
3392
3393 CREATE TABLE JGGZ.T_YZ_ZF_LBC_FS
3394 (
3395 LBC_ID VARCHAR2(32 BYTE),
3396 ZF_ID VARCHAR2(12 BYTE),
3397 LBC_TYPE VARCHAR2(5 BYTE),
3398 PZ_DATE DATE,
3399 FS_DATE DATE,
3400 LBC_INFO VARCHAR2(4000 BYTE),
3401 C_DATE DATE,
3402 U_DATE DATE,
3403 DEL_FLAG CHAR(1 BYTE),
3404 ID VARCHAR2(32 BYTE) NOT NULL
3405 )
3406 LOGGING
3407 NOCACHE
3408 NOPARALLEL;
3409
3410
3411 DROP TABLE JGGZ.T_YZ_ZF_LBC_TMP1 CASCADE CONSTRAINTS;
3412
3413 CREATE TABLE JGGZ.T_YZ_ZF_LBC_TMP1
3414 (
3415 LBC_NO VARCHAR2(32 BYTE) NOT NULL,
3416 SP_ID VARCHAR2(10 BYTE),
3417 ZF_ID VARCHAR2(12 BYTE),
3418 LBCSP_NO VARCHAR2(32 BYTE),
3419 LBC_TYPE VARCHAR2(6 BYTE),
3420 SICK_HISTORY VARCHAR2(4000 BYTE),
3421 BC_TYPE VARCHAR2(6 BYTE),
3422 DJ_DATE DATE,
3423 SC_INFO VARCHAR2(2000 BYTE),
3424 BC_YJ VARCHAR2(4000 BYTE),
3425 HOSPITAL_YJ VARCHAR2(4000 BYTE),
3426 HOSPITAL_DATE DATE,
3427 CXLBC_DATE DATE,
3428 JD_YS1 VARCHAR2(20 BYTE),
3429 YS_ZW1 VARCHAR2(6 BYTE),
3430 YS_ZC1 VARCHAR2(6 BYTE),
3431 JD_YS2 VARCHAR2(20 BYTE),
3432 YS_ZW2 VARCHAR2(6 BYTE),
3433 YS_ZC2 VARCHAR2(6 BYTE),
3434 JD_YS3 VARCHAR2(20 BYTE),
3435 YS_ZW3 VARCHAR2(6 BYTE),
3436 YS_ZC3 VARCHAR2(6 BYTE),
3437 C_DATE DATE,
3438 U_DATE DATE,
3439 DEL_FLAG CHAR(1 BYTE),
3440 NYDW VARCHAR2(32 BYTE)
3441 )
3442 LOGGING
3443 NOCACHE
3444 NOPARALLEL;
3445
3446
3447 DROP TABLE JGGZ.T_YZ_ZF_LBC_TMP2 CASCADE CONSTRAINTS;
3448
3449 CREATE TABLE JGGZ.T_YZ_ZF_LBC_TMP2
3450 (
3451 LBC_NO VARCHAR2(32 BYTE) NOT NULL,
3452 SP_ID VARCHAR2(10 BYTE),
3453 ZF_ID VARCHAR2(12 BYTE),
3454 LBCSP_NO VARCHAR2(32 BYTE),
3455 LBC_TYPE VARCHAR2(6 BYTE),
3456 SICK_HISTORY VARCHAR2(4000 BYTE),
3457 BC_TYPE VARCHAR2(6 BYTE),
3458 DJ_DATE DATE,
3459 SC_INFO VARCHAR2(2000 BYTE),
3460 BC_YJ VARCHAR2(4000 BYTE),
3461 HOSPITAL_YJ VARCHAR2(4000 BYTE),
3462 HOSPITAL_DATE DATE,
3463 CXLBC_DATE DATE,
3464 JD_YS1 VARCHAR2(20 BYTE),
3465 YS_ZW1 VARCHAR2(6 BYTE),
3466 YS_ZC1 VARCHAR2(6 BYTE),
3467 JD_YS2 VARCHAR2(20 BYTE),
3468 YS_ZW2 VARCHAR2(6 BYTE),
3469 YS_ZC2 VARCHAR2(6 BYTE),
3470 JD_YS3 VARCHAR2(20 BYTE),
3471 YS_ZW3 VARCHAR2(6 BYTE),
3472 YS_ZC3 VARCHAR2(6 BYTE),
3473 C_DATE DATE,
3474 U_DATE DATE,
3475 DEL_FLAG CHAR(1 BYTE)
3476 )
3477 LOGGING
3478 NOCACHE
3479 NOPARALLEL;
3480
3481
3482 ALTER TABLE JGGZ.T_YZ_ZF_MTXX DROP PRIMARY KEY CASCADE;
3483 DROP TABLE JGGZ.T_YZ_ZF_MTXX CASCADE CONSTRAINTS;
3484
3485 CREATE TABLE JGGZ.T_YZ_ZF_MTXX
3486 (
3487 MT_NO VARCHAR2(32 BYTE) NOT NULL,
3488 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
3489 MT_TYPE VARCHAR2(6 BYTE),
3490 MT_CONTENT BLOB,
3491 C_DATE DATE,
3492 U_DATE DATE,
3493 DEL_FLAG CHAR(1 BYTE)
3494 )
3495 LOGGING
3496 NOCACHE
3497 NOPARALLEL;
3498
3499
3500 ALTER TABLE JGGZ.T_YZ_ZF_MTXX_LOG DROP PRIMARY KEY CASCADE;
3501 DROP TABLE JGGZ.T_YZ_ZF_MTXX_LOG CASCADE CONSTRAINTS;
3502
3503 CREATE TABLE JGGZ.T_YZ_ZF_MTXX_LOG
3504 (
3505 ID VARCHAR2(32 BYTE) NOT NULL,
3506 ZF_ID VARCHAR2(12 BYTE),
3507 MT_TYPE VARCHAR2(10 BYTE),
3508 OP_TYPE VARCHAR2(1 BYTE),
3509 SYNC_FLAG VARCHAR2(1 BYTE),
3510 C_DATE DATE,
3511 U_DATE DATE
3512 )
3513 LOGGING
3514 NOCACHE
3515 NOPARALLEL;
3516
3517
3518 ALTER TABLE JGGZ.T_YZ_ZF_NFL DROP PRIMARY KEY CASCADE;
3519 DROP TABLE JGGZ.T_YZ_ZF_NFL CASCADE CONSTRAINTS;
3520
3521 CREATE TABLE JGGZ.T_YZ_ZF_NFL
3522 (
3523 PLAN_NO VARCHAR2(32 BYTE) NOT NULL,
3524 JSDWID VARCHAR2(32 BYTE) NOT NULL,
3525 AGE NUMBER(4) DEFAULT 0,
3526 YX NUMBER(4) DEFAULT 0,
3527 ZY NUMBER(4) DEFAULT 0
3528 )
3529 LOGGING
3530 NOCACHE
3531 NOPARALLEL;
3532
3533
3534 ALTER TABLE JGGZ.T_YZ_ZF_NFL_TJ DROP PRIMARY KEY CASCADE;
3535 DROP TABLE JGGZ.T_YZ_ZF_NFL_TJ CASCADE CONSTRAINTS;
3536
3537 CREATE TABLE JGGZ.T_YZ_ZF_NFL_TJ
3538 (
3539 ID VARCHAR2(32 BYTE) NOT NULL,
3540 JSDW VARCHAR2(32 BYTE),
3541 COLTITLE VARCHAR2(50 BYTE),
3542 TJTYPE VARCHAR2(1 BYTE),
3543 SQL VARCHAR2(4000 BYTE),
3544 TEXT VARCHAR2(4000 BYTE),
3545 RS NUMBER(4) DEFAULT 0,
3546 SCALE NUMBER DEFAULT 0
3547 )
3548 LOGGING
3549 NOCACHE
3550 NOPARALLEL;
3551
3552
3553 ALTER TABLE JGGZ.T_YZ_ZF_NWFG DROP PRIMARY KEY CASCADE;
3554 DROP TABLE JGGZ.T_YZ_ZF_NWFG CASCADE CONSTRAINTS;
3555
3556 CREATE TABLE JGGZ.T_YZ_ZF_NWFG
3557 (
3558 ID VARCHAR2(32 BYTE) NOT NULL,
3559 ZF_ID VARCHAR2(12 BYTE),
3560 PZ_DATE DATE,
3561 CH_REASON VARCHAR2(3000 BYTE),
3562 C_DATE DATE,
3563 U_DATE DATE,
3564 DEL_FLAG CHAR(1 BYTE),
3565 CX_DATE DATE,
3566 SYQX VARCHAR2(10 BYTE),
3567 FG VARCHAR2(50 BYTE)
3568 )
3569 LOGGING
3570 NOCACHE
3571 NOPARALLEL;
3572
3573
3574 ALTER TABLE JGGZ.T_YZ_ZF_QJFJ DROP PRIMARY KEY CASCADE;
3575 DROP TABLE JGGZ.T_YZ_ZF_QJFJ CASCADE CONSTRAINTS;
3576
3577 CREATE TABLE JGGZ.T_YZ_ZF_QJFJ
3578 (
3579 ID VARCHAR2(32 BYTE) NOT NULL,
3580 SPB_NO VARCHAR2(20 BYTE),
3581 ZF_ID VARCHAR2(12 BYTE),
3582 JQ_START_DATE DATE,
3583 JQ_END_DATE DATE,
3584 LEAVE_DATE DATE,
3585 BACK_DATE DATE,
3586 BACK_TYPE VARCHAR2(6 BYTE),
3587 LEAVE_TYPE VARCHAR2(6 BYTE),
3588 LJ_JZD_ADDR_XZQH VARCHAR2(6 BYTE),
3589 LJ_JZD_ADDR VARCHAR2(100 BYTE),
3590 C_DATE DATE,
3591 U_DATE DATE,
3592 DEL_FLAG CHAR(1 BYTE),
3593 PZJG VARCHAR2(6 BYTE),
3594 PZ_DATE DATE,
3595 QJ_TYPE VARCHAR2(6 BYTE),
3596 QJ_REASON VARCHAR2(500 BYTE),
3597 SZ_DB VARCHAR2(20 BYTE),
3598 QJ_FJ_TYPE VARCHAR2(6 BYTE),
3599 APPROVE_DATE DATE,
3600 ZJ_TYPE VARCHAR2(6 BYTE),
3601 MEMO VARCHAR2(4000 BYTE)
3602 )
3603 LOGGING
3604 NOCACHE
3605 NOPARALLEL;
3606
3607
3608 DROP TABLE JGGZ.T_YZ_ZF_QKLJ CASCADE CONSTRAINTS;
3609
3610 CREATE TABLE JGGZ.T_YZ_ZF_QKLJ
3611 (
3612 ID VARCHAR2(32 BYTE) NOT NULL,
3613 ZF_ID VARCHAR2(12 BYTE),
3614 QKLJ_LB VARCHAR2(6 BYTE),
3615 LB VARCHAR2(6 BYTE),
3616 QKLJTIMES NUMBER DEFAULT 0
3617 )
3618 NOLOGGING
3619 NOCACHE
3620 NOPARALLEL;
3621
3622
3623 ALTER TABLE JGGZ.T_YZ_ZF_SFZF DROP PRIMARY KEY CASCADE;
3624 DROP TABLE JGGZ.T_YZ_ZF_SFZF CASCADE CONSTRAINTS;
3625
3626 CREATE TABLE JGGZ.T_YZ_ZF_SFZF
3627 (
3628 ID VARCHAR2(32 BYTE) NOT NULL,
3629 ZF_ID VARCHAR2(30 BYTE),
3630 SFLB VARCHAR2(100 BYTE),
3631 DEL_FLAG VARCHAR2(1 BYTE),
3632 C_DATE DATE,
3633 U_DATE DATE,
3634 SFLBALL VARCHAR2(100 BYTE)
3635 )
3636 LOGGING
3637 NOCACHE
3638 NOPARALLEL;
3639
3640
3641 ALTER TABLE JGGZ.T_YZ_ZF_SHGX DROP PRIMARY KEY CASCADE;
3642 DROP TABLE JGGZ.T_YZ_ZF_SHGX CASCADE CONSTRAINTS;
3643
3644 CREATE TABLE JGGZ.T_YZ_ZF_SHGX
3645 (
3646 ZF_ID VARCHAR2(12 BYTE),
3647 SHGX_NO VARCHAR2(32 BYTE) NOT NULL,
3648 GX_NAME VARCHAR2(100 BYTE),
3649 NAME VARCHAR2(64 BYTE),
3650 AGE VARCHAR2(12 BYTE),
3651 GENDER VARCHAR2(64 BYTE),
3652 DW VARCHAR2(64 BYTE),
3653 DW_ADDR_XZQH VARCHAR2(64 BYTE),
3654 DW_ADDR_DETAIL VARCHAR2(200 BYTE),
3655 ZW VARCHAR2(64 BYTE),
3656 ZZD_ADDR_XZQH VARCHAR2(64 BYTE),
3657 ZZD_ADDR_DETIAL VARCHAR2(200 BYTE),
3658 ZZMM VARCHAR2(64 BYTE),
3659 ZJ_TYPE VARCHAR2(64 BYTE),
3660 ZJ_NO VARCHAR2(36 BYTE),
3661 TELEPHONE VARCHAR2(50 BYTE),
3662 C_DATE DATE,
3663 U_DATE DATE,
3664 DEL_FLAG CHAR(1 BYTE),
3665 XH VARCHAR2(32 BYTE)
3666 )
3667 NOLOGGING
3668 NOCACHE
3669 NOPARALLEL;
3670
3671
3672 ALTER TABLE JGGZ.T_YZ_ZF_SJZF DROP PRIMARY KEY CASCADE;
3673 DROP TABLE JGGZ.T_YZ_ZF_SJZF CASCADE CONSTRAINTS;
3674
3675 CREATE TABLE JGGZ.T_YZ_ZF_SJZF
3676 (
3677 ID VARCHAR2(32 BYTE) NOT NULL,
3678 ZF_ID VARCHAR2(30 BYTE),
3679 JNAME VARCHAR2(1 BYTE),
3680 JADDRESS VARCHAR2(1 BYTE),
3681 JDEGREE VARCHAR2(1 BYTE),
3682 JSTORY VARCHAR2(1 BYTE),
3683 DEL_FLAG VARCHAR2(1 BYTE),
3684 C_DATE DATE,
3685 U_DATE DATE,
3686 SJLB VARCHAR2(10 BYTE)
3687 )
3688 LOGGING
3689 NOCACHE
3690 NOPARALLEL;
3691
3692
3693 ALTER TABLE JGGZ.T_YZ_ZF_SS DROP PRIMARY KEY CASCADE;
3694 DROP TABLE JGGZ.T_YZ_ZF_SS CASCADE CONSTRAINTS;
3695
3696 CREATE TABLE JGGZ.T_YZ_ZF_SS
3697 (
3698 SS_NO VARCHAR2(32 BYTE) NOT NULL,
3699 ZF_ID VARCHAR2(12 BYTE),
3700 SS_DATE DATE,
3701 CHECK_REASON VARCHAR2(2048 BYTE),
3702 CHECK_DETAIL VARCHAR2(2048 BYTE),
3703 CHECK_GJ VARCHAR2(32 BYTE),
3704 CHECK_RESULT VARCHAR2(2048 BYTE),
3705 CLGJ VARCHAR2(32 BYTE),
3706 MEMO VARCHAR2(4000 BYTE),
3707 C_DATE DATE,
3708 U_DATE DATE,
3709 DEL_FLAG CHAR(1 BYTE)
3710 )
3711 NOLOGGING
3712 NOCACHE
3713 NOPARALLEL;
3714
3715
3716 ALTER TABLE JGGZ.T_YZ_ZF_TAF DROP PRIMARY KEY CASCADE;
3717 DROP TABLE JGGZ.T_YZ_ZF_TAF CASCADE CONSTRAINTS;
3718
3719 CREATE TABLE JGGZ.T_YZ_ZF_TAF
3720 (
3721 ZF_ID VARCHAR2(12 BYTE),
3722 TAF_NO VARCHAR2(32 BYTE) NOT NULL,
3723 PJ_NO1 VARCHAR2(8 BYTE),
3724 PJ_NO2 VARCHAR2(16 BYTE),
3725 TAF_NAME VARCHAR2(32 BYTE),
3726 TAF_GENDER VARCHAR2(6 BYTE),
3727 BIRTH DATE,
3728 CAREER VARCHAR2(6 BYTE),
3729 ZM VARCHAR2(64 BYTE),
3730 XZ VARCHAR2(6 BYTE),
3731 XQ VARCHAR2(8 BYTE),
3732 ZF_STATUS VARCHAR2(6 BYTE),
3733 GYDW_ADDR_XZQH VARCHAR2(6 BYTE),
3734 GYDW_ADDR_DETIAL VARCHAR2(32 BYTE),
3735 HJ_ADDR_XZQH VARCHAR2(6 BYTE),
3736 HJ_ADDR_DETAIL VARCHAR2(32 BYTE),
3737 MEMO VARCHAR2(4000 BYTE),
3738 C_DATE DATE,
3739 U_DATE DATE,
3740 DEL_FLAG CHAR(1 BYTE)
3741 )
3742 NOLOGGING
3743 NOCACHE
3744 NOPARALLEL;
3745
3746
3747 ALTER TABLE JGGZ.T_YZ_ZF_TC DROP PRIMARY KEY CASCADE;
3748 DROP TABLE JGGZ.T_YZ_ZF_TC CASCADE CONSTRAINTS;
3749
3750 CREATE TABLE JGGZ.T_YZ_ZF_TC
3751 (
3752 ZF_ID VARCHAR2(12 BYTE),
3753 TC_CODE VARCHAR2(32 BYTE),
3754 TC VARCHAR2(100 BYTE),
3755 C_DATE DATE,
3756 U_DATE DATE,
3757 DEL_FLAG CHAR(1 BYTE)
3758 )
3759 NOLOGGING
3760 NOCACHE
3761 NOPARALLEL;
3762
3763
3764 DROP TABLE JGGZ.T_YZ_ZF_TG CASCADE CONSTRAINTS;
3765
3766 CREATE TABLE JGGZ.T_YZ_ZF_TG
3767 (
3768 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
3769 TGLB VARCHAR2(20 BYTE) NOT NULL,
3770 XH VARCHAR2(5 BYTE)
3771 )
3772 LOGGING
3773 NOCACHE
3774 NOPARALLEL;
3775
3776
3777 ALTER TABLE JGGZ.T_YZ_ZF_TGSK DROP PRIMARY KEY CASCADE;
3778 DROP TABLE JGGZ.T_YZ_ZF_TGSK CASCADE CONSTRAINTS;
3779
3780 CREATE TABLE JGGZ.T_YZ_ZF_TGSK
3781 (
3782 ID VARCHAR2(32 BYTE) NOT NULL,
3783 ZF_ID VARCHAR2(12 BYTE),
3784 TYPE VARCHAR2(1 BYTE),
3785 STARTDATE DATE,
3786 ENDDATE DATE,
3787 LHDATE DATE,
3788 LHJGXZQH VARCHAR2(20 BYTE),
3789 LHJG VARCHAR2(20 BYTE),
3790 MEMO VARCHAR2(1000 BYTE),
3791 C_DATE DATE,
3792 U_DATE DATE,
3793 DEL_FLAG VARCHAR2(1 BYTE),
3794 JWBWID VARCHAR2(32 BYTE)
3795 )
3796 LOGGING
3797 NOCACHE
3798 NOPARALLEL;
3799
3800
3801 ALTER TABLE JGGZ.T_YZ_ZF_TMTZ DROP PRIMARY KEY CASCADE;
3802 DROP TABLE JGGZ.T_YZ_ZF_TMTZ CASCADE CONSTRAINTS;
3803
3804 CREATE TABLE JGGZ.T_YZ_ZF_TMTZ
3805 (
3806 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
3807 HEIGHT VARCHAR2(10 BYTE),
3808 BODY_TYPE VARCHAR2(32 BYTE),
3809 BLOOD_TYPE VARCHAR2(32 BYTE),
3810 FACE_TYPE VARCHAR2(32 BYTE),
3811 ACCENT VARCHAR2(50 BYTE),
3812 FOOT_LEN VARCHAR2(10 BYTE),
3813 SKIN_FEATURE VARCHAR2(1000 BYTE),
3814 CHARACTER VARCHAR2(256 BYTE),
3815 C_DATE DATE,
3816 U_DATE DATE,
3817 DEL_FLAG CHAR(1 BYTE)
3818 )
3819 LOGGING
3820 NOCACHE
3821 NOPARALLEL;
3822
3823
3824 ALTER TABLE JGGZ.T_YZ_ZF_TT DROP PRIMARY KEY CASCADE;
3825 DROP TABLE JGGZ.T_YZ_ZF_TT CASCADE CONSTRAINTS;
3826
3827 CREATE TABLE JGGZ.T_YZ_ZF_TT
3828 (
3829 ID VARCHAR2(32 BYTE) NOT NULL,
3830 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
3831 CASE_NO VARCHAR2(20 BYTE),
3832 RUN_DATE DATE,
3833 RUN_TYPE VARCHAR2(6 BYTE),
3834 RUN_COURSE VARCHAR2(4000 BYTE),
3835 MEASURE VARCHAR2(4000 BYTE),
3836 XWC_YJ VARCHAR2(1000 BYTE),
3837 XWC_QPR VARCHAR2(32 BYTE),
3838 XWC_QP_DATE DATE,
3839 JAIL_YJ VARCHAR2(1000 BYTE),
3840 JAIL_QPR VARCHAR2(32 BYTE),
3841 JAIL_QP_DATE DATE,
3842 NOTICE_NO VARCHAR2(40 BYTE),
3843 WANT_DATE DATE,
3844 WANT_NO VARCHAR2(40 BYTE),
3845 BH_STATUS CHAR(1 BYTE),
3846 C_DATE DATE,
3847 U_DATE DATE,
3848 DEL_FLAG CHAR(1 BYTE),
3849 RUN_ANALYSE VARCHAR2(4000 BYTE),
3850 SZ_DB VARCHAR2(20 BYTE),
3851 RUN_TIME VARCHAR2(8 BYTE)
3852 )
3853 LOGGING
3854 NOCACHE
3855 NOPARALLEL;
3856
3857
3858 ALTER TABLE JGGZ.T_YZ_ZF_UNUSEDZFBH DROP PRIMARY KEY CASCADE;
3859 DROP TABLE JGGZ.T_YZ_ZF_UNUSEDZFBH CASCADE CONSTRAINTS;
3860
3861 CREATE TABLE JGGZ.T_YZ_ZF_UNUSEDZFBH
3862 (
3863 ID VARCHAR2(32 BYTE) NOT NULL,
3864 STARTNO NUMBER(8) NOT NULL,
3865 ENDNO NUMBER(8) NOT NULL
3866 )
3867 LOGGING
3868 NOCACHE
3869 NOPARALLEL;
3870
3871
3872 ALTER TABLE JGGZ.T_YZ_ZF_XQBG DROP PRIMARY KEY CASCADE;
3873 DROP TABLE JGGZ.T_YZ_ZF_XQBG CASCADE CONSTRAINTS;
3874
3875 CREATE TABLE JGGZ.T_YZ_ZF_XQBG
3876 (
3877 XQBG_NO VARCHAR2(32 BYTE) NOT NULL,
3878 ZF_ID VARCHAR2(12 BYTE),
3879 SPB_NO VARCHAR2(32 BYTE),
3880 BD_TYPE VARCHAR2(20 BYTE),
3881 JYJ_PZ_DATE DATE,
3882 PJ_DATE DATE,
3883 PJ_NO1 VARCHAR2(32 BYTE),
3884 PJ_NO2 VARCHAR2(32 BYTE),
3885 PJ_JG VARCHAR2(50 BYTE),
3886 PJ_XZQH VARCHAR2(32 BYTE),
3887 CD_FD VARCHAR2(32 BYTE),
3888 BZ_NX VARCHAR2(8 BYTE),
3889 XZ VARCHAR2(20 BYTE),
3890 SJ_XQ VARCHAR2(32 BYTE),
3891 YXQ VARCHAR2(8 BYTE),
3892 YBZNX VARCHAR2(8 BYTE),
3893 YXZ VARCHAR2(20 BYTE),
3894 YXQ_START_DATE DATE,
3895 YXQ_END_DATE DATE,
3896 START_DATE DATE,
3897 END_DATE DATE,
3898 ZX_DATE DATE,
3899 CD_SJ_QK VARCHAR2(4000 BYTE),
3900 SPB_TYPE CHAR(1 BYTE),
3901 MEMO VARCHAR2(4000 BYTE),
3902 C_DATE DATE,
3903 U_DATE DATE,
3904 DEL_FLAG CHAR(1 BYTE),
3905 YPJ_NO1 VARCHAR2(32 BYTE),
3906 YPJ_NO2 VARCHAR2(32 BYTE),
3907 YPJ_JG VARCHAR2(50 BYTE),
3908 YPJ_XZQH VARCHAR2(32 BYTE),
3909 YPJ_DATE DATE,
3910 C_USER VARCHAR2(32 BYTE),
3911 SZ_DB VARCHAR2(32 BYTE),
3912 CB_DATE DATE
3913 )
3914 LOGGING
3915 NOCACHE
3916 NOPARALLEL;
3917
3918
3919 ALTER TABLE JGGZ.T_YZ_ZF_YJ DROP PRIMARY KEY CASCADE;
3920 DROP TABLE JGGZ.T_YZ_ZF_YJ CASCADE CONSTRAINTS;
3921
3922 CREATE TABLE JGGZ.T_YZ_ZF_YJ
3923 (
3924 ID VARCHAR2(32 BYTE),
3925 ZF_ID VARCHAR2(12 BYTE),
3926 DJ_DATE DATE,
3927 SF_FLAG CHAR(1 BYTE),
3928 MAIL_TYPE VARCHAR2(6 BYTE),
3929 DF_NAME VARCHAR2(64 BYTE),
3930 RELATION VARCHAR2(50 BYTE),
3931 DF_ADDR_XZQH VARCHAR2(32 BYTE),
3932 DF_ADDR_DETAIL VARCHAR2(256 BYTE),
3933 DF_ZIP VARCHAR2(64 BYTE),
3934 CONTENT VARCHAR2(4000 BYTE),
3935 SEND_REASON VARCHAR2(2048 BYTE),
3936 ZRGJ VARCHAR2(32 BYTE),
3937 CLJG VARCHAR2(2048 BYTE),
3938 MEMO VARCHAR2(4000 BYTE),
3939 C_DATE DATE,
3940 U_DATE DATE,
3941 DEL_FLAG CHAR(1 BYTE)
3942 )
3943 NOLOGGING
3944 NOCACHE
3945 NOPARALLEL;
3946
3947
3948 ALTER TABLE JGGZ.T_YZ_ZF_ZDFL DROP PRIMARY KEY CASCADE;
3949 DROP TABLE JGGZ.T_YZ_ZF_ZDFL CASCADE CONSTRAINTS;
3950
3951 CREATE TABLE JGGZ.T_YZ_ZF_ZDFL
3952 (
3953 ID VARCHAR2(32 BYTE),
3954 FA_ID VARCHAR2(32 BYTE),
3955 ZF_ID VARCHAR2(12 BYTE),
3956 DXJY VARCHAR2(100 BYTE),
3957 WTR VARCHAR2(100 BYTE),
3958 WTRZW VARCHAR2(100 BYTE),
3959 STR VARCHAR2(100 BYTE),
3960 PZR VARCHAR2(100 BYTE),
3961 FLDATE DATE,
3962 MEMO VARCHAR2(100 BYTE)
3963 )
3964 LOGGING
3965 NOCACHE
3966 NOPARALLEL;
3967
3968
3969 ALTER TABLE JGGZ.T_YZ_ZF_ZFBHALLOCATED DROP PRIMARY KEY CASCADE;
3970 DROP TABLE JGGZ.T_YZ_ZF_ZFBHALLOCATED CASCADE CONSTRAINTS;
3971
3972 CREATE TABLE JGGZ.T_YZ_ZF_ZFBHALLOCATED
3973 (
3974 ID VARCHAR2(32 BYTE) NOT NULL,
3975 ZFBH NUMBER(8) NOT NULL,
3976 USER_ID VARCHAR2(36 BYTE) NOT NULL,
3977 SESSION_ID VARCHAR2(36 BYTE) NOT NULL,
3978 ALLOCATETIME DATE
3979 )
3980 LOGGING
3981 NOCACHE
3982 NOPARALLEL;
3983
3984
3985 ALTER TABLE JGGZ.T_YZ_ZF_ZK DROP PRIMARY KEY CASCADE;
3986 DROP TABLE JGGZ.T_YZ_ZF_ZK CASCADE CONSTRAINTS;
3987
3988 CREATE TABLE JGGZ.T_YZ_ZF_ZK
3989 (
3990 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
3991 ZF_ADDR_XZQH VARCHAR2(32 BYTE),
3992 ZF_ADDR_DETAIL VARCHAR2(64 BYTE),
3993 FILE_NO VARCHAR2(16 BYTE),
3994 RJ_DATE DATE,
3995 DR_DATE DATE,
3996 BH_NAME VARCHAR2(64 BYTE),
3997 BQWH VARCHAR2(32 BYTE),
3998 XWH VARCHAR2(32 BYTE),
3999 BQZY VARCHAR2(32 BYTE),
4000 BQMM VARCHAR2(32 BYTE),
4001 ZF_NATION VARCHAR2(32 BYTE),
4002 PCS VARCHAR2(32 BYTE),
4003 JD VARCHAR2(32 BYTE),
4004 SY_TYPE VARCHAR2(32 BYTE),
4005 DBJG_XZQH VARCHAR2(32 BYTE),
4006 DBJG_ZXJG VARCHAR2(50 BYTE),
4007 DB_DATE DATE,
4008 PJJG_XZQH VARCHAR2(32 BYTE),
4009 PJJG_ZXJG VARCHAR2(50 BYTE),
4010 PJ_DATE DATE,
4011 YAF_TYPE VARCHAR2(32 BYTE),
4012 XAF_TYPE VARCHAR2(32 BYTE),
4013 YS_DEPT_XZQH VARCHAR2(32 BYTE),
4014 YS_DEPT VARCHAR2(32 BYTE),
4015 YS_NO1 VARCHAR2(32 BYTE),
4016 YS_NO2 VARCHAR2(32 BYTE),
4017 LJ_TIMES VARCHAR2(4 BYTE),
4018 QK_TIMES VARCHAR2(4 BYTE),
4019 LGF VARCHAR2(32 BYTE),
4020 DB VARCHAR2(32 BYTE),
4021 FG_LEVEL VARCHAR2(32 BYTE),
4022 WORKER_LEVEL VARCHAR2(32 BYTE),
4023 GZ VARCHAR2(50 BYTE),
4024 NWFG VARCHAR2(50 BYTE),
4025 ID_CARD VARCHAR2(36 BYTE),
4026 HK_TYPE VARCHAR2(32 BYTE),
4027 LC_TYPE VARCHAR2(32 BYTE),
4028 JX_MEASURE VARCHAR2(32 BYTE),
4029 LBC_FLAG VARCHAR2(32 BYTE),
4030 CUR_START_DATE DATE,
4031 CUR_END_DATE DATE,
4032 CUR_BZNX VARCHAR2(8 BYTE),
4033 CUR_XZ VARCHAR2(32 BYTE),
4034 CURRENT_XQ VARCHAR2(8 BYTE),
4035 LAST_START_DATE DATE,
4036 LAST_END_DATE DATE,
4037 LAST_FX_XZQH VARCHAR2(32 BYTE),
4038 LAST_FX_JY VARCHAR2(64 BYTE),
4039 JXHG_FLAG CHAR(1 BYTE),
4040 SS_FLAG CHAR(1 BYTE),
4041 TC VARCHAR2(1000 BYTE),
4042 FJ VARCHAR2(100 BYTE),
4043 C_DATE DATE,
4044 U_DATE DATE,
4045 DEL_FLAG CHAR(1 BYTE)
4046 )
4047 LOGGING
4048 NOCACHE
4049 NOPARALLEL;
4050
4051
4052 ALTER TABLE JGGZ.T_YZ_ZF_ZM DROP PRIMARY KEY CASCADE;
4053 DROP TABLE JGGZ.T_YZ_ZF_ZM CASCADE CONSTRAINTS;
4054
4055 CREATE TABLE JGGZ.T_YZ_ZF_ZM
4056 (
4057 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
4058 ZM_CODE VARCHAR2(6 BYTE) NOT NULL,
4059 ZM_SEQ NUMBER(2),
4060 C_DATE DATE,
4061 U_DATE DATE,
4062 DEL_FLAG CHAR(1 BYTE)
4063 )
4064 NOLOGGING
4065 NOCACHE
4066 NOPARALLEL;
4067
4068
4069 ALTER TABLE JGGZ.T_YZ_ZF_ZMBK DROP PRIMARY KEY CASCADE;
4070 DROP TABLE JGGZ.T_YZ_ZF_ZMBK CASCADE CONSTRAINTS;
4071
4072 CREATE TABLE JGGZ.T_YZ_ZF_ZMBK
4073 (
4074 XQBGNO VARCHAR2(32 BYTE) NOT NULL,
4075 ZF_ID VARCHAR2(12 BYTE),
4076 XH VARCHAR2(5 BYTE),
4077 ZM VARCHAR2(20 BYTE)
4078 )
4079 LOGGING
4080 NOCACHE
4081 NOPARALLEL;
4082
4083
4084 DROP TABLE JGGZ.T_YZ_ZHTJ_FOR_TYPE CASCADE CONSTRAINTS;
4085
4086 CREATE TABLE JGGZ.T_YZ_ZHTJ_FOR_TYPE
4087 (
4088 COL_1 VARCHAR2(100 BYTE),
4089 COL_2 VARCHAR2(100 BYTE),
4090 COL_3 NUMBER
4091 )
4092 LOGGING
4093 NOCACHE
4094 NOPARALLEL;
4095
4096
4097 ALTER TABLE JGGZ.T_YZ_ZKBXDJ DROP PRIMARY KEY CASCADE;
4098 DROP TABLE JGGZ.T_YZ_ZKBXDJ CASCADE CONSTRAINTS;
4099
4100 CREATE TABLE JGGZ.T_YZ_ZKBXDJ
4101 (
4102 ID VARCHAR2(32 BYTE) NOT NULL,
4103 ZF_ID VARCHAR2(12 BYTE),
4104 RQ DATE,
4105 TH_QK VARCHAR2(500 BYTE),
4106 LS_KZ_FF VARCHAR2(500 BYTE),
4107 BX_QK VARCHAR2(500 BYTE),
4108 MEMO VARCHAR2(500 BYTE),
4109 C_DATE DATE,
4110 U_DATE DATE,
4111 DEL_FLAG CHAR(1 BYTE),
4112 WWZK_ID VARCHAR2(32 BYTE)
4113 )
4114 NOLOGGING
4115 NOCACHE
4116 NOPARALLEL;
4117
4118
4119 ALTER TABLE JGGZ.T_YZ_ZKZFJB DROP PRIMARY KEY CASCADE;
4120 DROP TABLE JGGZ.T_YZ_ZKZFJB CASCADE CONSTRAINTS;
4121
4122 CREATE TABLE JGGZ.T_YZ_ZKZFJB
4123 (
4124 ID VARCHAR2(32 BYTE) NOT NULL,
4125 ZF_ID VARCHAR2(12 BYTE),
4126 SZ_JY VARCHAR2(6 BYTE),
4127 SP_ID VARCHAR2(10 BYTE),
4128 ZK_PZ_RQ DATE,
4129 LK_PZR VARCHAR2(100 BYTE),
4130 ZK_TYPE VARCHAR2(6 BYTE),
4131 JT_SY_1 VARCHAR2(500 BYTE),
4132 JT_SY_2 VARCHAR2(500 BYTE),
4133 JT_SY_3 VARCHAR2(500 BYTE),
4134 JT_SY_4 VARCHAR2(500 BYTE),
4135 ZK_REASON VARCHAR2(6 BYTE),
4136 BJ_R_1 VARCHAR2(100 BYTE),
4137 BJ_R_2 VARCHAR2(100 BYTE),
4138 JG_GJ_1 VARCHAR2(100 BYTE),
4139 JG_GJ_2 VARCHAR2(100 BYTE),
4140 ZK_JB VARCHAR2(6 BYTE),
4141 CK_PZ_RQ DATE,
4142 MEMO VARCHAR2(500 BYTE),
4143 C_DATE DATE,
4144 U_DATE DATE,
4145 DEL_FLAG CHAR(1 BYTE),
4146 CBRQ DATE,
4147 CXCBRQ DATE,
4148 ZKXZ_1 VARCHAR2(6 BYTE),
4149 ZKXZ_2 VARCHAR2(6 BYTE),
4150 CXLY VARCHAR2(500 BYTE),
4151 ZK_REASONSE VARCHAR2(6 BYTE),
4152 CK_CBDATE DATE
4153 )
4154 NOLOGGING
4155 NOCACHE
4156 NOPARALLEL;
4157
4158
4159 DROP TABLE JGGZ.WLJ_ID_TMP CASCADE CONSTRAINTS;
4160
4161 CREATE TABLE JGGZ.WLJ_ID_TMP
4162 (
4163 ID VARCHAR2(32 BYTE) NOT NULL
4164 )
4165 LOGGING
4166 NOCACHE
4167 NOPARALLEL;
4168
4169
4170 DROP TABLE JGGZ.XSF_ZFID_TMP CASCADE CONSTRAINTS;
4171
4172 CREATE TABLE JGGZ.XSF_ZFID_TMP
4173 (
4174 ID VARCHAR2(32 BYTE) NOT NULL,
4175 ZF_ID VARCHAR2(12 BYTE),
4176 RJ_DATE DATE,
4177 LJ_DATE DATE,
4178 DB VARCHAR2(32 BYTE),
4179 LJ_TYPE VARCHAR2(12 BYTE),
4180 RJ_TYPE VARCHAR2(12 BYTE),
4181 C_DATE DATE,
4182 U_DATE DATE,
4183 DEL_FLAG CHAR(1 BYTE),
4184 DDFLAG CHAR(1 BYTE),
4185 LJQX VARCHAR2(20 BYTE),
4186 DRDB VARCHAR2(32 BYTE)
4187 )
4188 LOGGING
4189 NOCACHE
4190 NOPARALLEL;
4191
4192
4193 DROP TABLE JGGZ.ZFID_JYJ_TMP CASCADE CONSTRAINTS;
4194
4195 CREATE TABLE JGGZ.ZFID_JYJ_TMP
4196 (
4197 ZF_ID VARCHAR2(12 BYTE)
4198 )
4199 LOGGING
4200 NOCACHE
4201 NOPARALLEL;
4202
4203
4204 DROP TABLE JGGZ.ZFID_TMP CASCADE CONSTRAINTS;
4205
4206 CREATE TABLE JGGZ.ZFID_TMP
4207 (
4208 ZF_ID VARCHAR2(12 BYTE),
4209 LJ_DATE DATE
4210 )
4211 LOGGING
4212 NOCACHE
4213 NOPARALLEL;
4214
4215
4216 DROP TABLE JGGZ.ZFID_XSF_TMP CASCADE CONSTRAINTS;
4217
4218 CREATE TABLE JGGZ.ZFID_XSF_TMP
4219 (
4220 ZF_ID VARCHAR2(12 BYTE)
4221 )
4222 LOGGING
4223 NOCACHE
4224 NOPARALLEL;
4225
4226
4227 ALTER TABLE JGGZ.ZF_BH DROP PRIMARY KEY CASCADE;
4228 DROP TABLE JGGZ.ZF_BH CASCADE CONSTRAINTS;
4229
4230 CREATE TABLE JGGZ.ZF_BH
4231 (
4232 ID VARCHAR2(32 BYTE) NOT NULL,
4233 ZF_BH VARCHAR2(12 BYTE),
4234 STATUS CHAR(1 BYTE),
4235 C_DATE DATE
4236 )
4237 LOGGING
4238 NOCACHE
4239 NOPARALLEL;
4240
4241
4242 ALTER TABLE JGGZ.ZF_FH DROP PRIMARY KEY CASCADE;
4243 DROP TABLE JGGZ.ZF_FH CASCADE CONSTRAINTS;
4244
4245 CREATE TABLE JGGZ.ZF_FH
4246 (
4247 ID VARCHAR2(32 BYTE) NOT NULL,
4248 ZF_FH VARCHAR2(5 BYTE),
4249 STATUS CHAR(1 BYTE),
4250 C_DATE DATE,
4251 USERID VARCHAR2(32 BYTE)
4252 )
4253 LOGGING
4254 NOCACHE
4255 NOPARALLEL;
4256
4257
4258 DROP TABLE JGGZ.ZF_ID_ID_TMP CASCADE CONSTRAINTS;
4259
4260 CREATE TABLE JGGZ.ZF_ID_ID_TMP
4261 (
4262 ZF_ID VARCHAR2(12 BYTE),
4263 RJ_DATE DATE
4264 )
4265 LOGGING
4266 NOCACHE
4267 NOPARALLEL;
4268
4269
4270 DROP TABLE JGGZ.ZF_ID_TMP CASCADE CONSTRAINTS;
4271
4272 CREATE TABLE JGGZ.ZF_ID_TMP
4273 (
4274 ZF_ID VARCHAR2(12 BYTE)
4275 )
4276 LOGGING
4277 NOCACHE
4278 NOPARALLEL;
4279
4280
4281 DROP TABLE JGGZ.ZHL_T_SYS_USER_LONGINNAME_LIKE CASCADE CONSTRAINTS;
4282
4283 CREATE TABLE JGGZ.ZHL_T_SYS_USER_LONGINNAME_LIKE
4284 (
4285 USER_ID VARCHAR2(10 BYTE) NOT NULL,
4286 USER_NAME VARCHAR2(20 BYTE) NOT NULL,
4287 LOGIN_NAME VARCHAR2(20 BYTE) NOT NULL,
4288 FLAG_EMP VARCHAR2(1 BYTE) NOT NULL,
4289 USER_CRYPTOGRAM VARCHAR2(20 BYTE),
4290 FLAG_LOCK VARCHAR2(1 BYTE) NOT NULL,
4291 FLAG_DEFINE VARCHAR2(1 BYTE) NOT NULL,
4292 IC_NO VARCHAR2(15 BYTE),
4293 CONN_NUM NUMBER(3) NOT NULL,
4294 FLAG_CHECK VARCHAR2(1 BYTE) NOT NULL,
4295 FLAG_ACTIVE VARCHAR2(1 BYTE) NOT NULL,
4296 POSITION_X NUMBER(5) NOT NULL,
4297 POSITION_Y NUMBER(5) NOT NULL
4298 )
4299 LOGGING
4300 NOCACHE
4301 NOPARALLEL;
4302
4303
4304 ALTER TABLE JGGZ.ZHL_T_SYS_USER_TMP DROP PRIMARY KEY CASCADE;
4305 DROP TABLE JGGZ.ZHL_T_SYS_USER_TMP CASCADE CONSTRAINTS;
4306
4307 CREATE TABLE JGGZ.ZHL_T_SYS_USER_TMP
4308 (
4309 USER_ID NUMBER(10) NOT NULL,
4310 USER_NAME VARCHAR2(80 BYTE) NOT NULL,
4311 LOGIN_NAME VARCHAR2(80 BYTE) NOT NULL,
4312 FLAG_EMP VARCHAR2(1 BYTE) DEFAULT '1' NOT NULL,
4313 USER_CRYPTOGRAM VARCHAR2(32 BYTE),
4314 FLAG_LOCK VARCHAR2(1 BYTE) DEFAULT '0' NOT NULL,
4315 FLAG_DEFINE VARCHAR2(1 BYTE) DEFAULT '1' NOT NULL,
4316 IC_NO VARCHAR2(15 BYTE),
4317 CONN_NUM NUMBER(3) DEFAULT 1 NOT NULL,
4318 FLAG_CHECK VARCHAR2(1 BYTE) DEFAULT '0' NOT NULL,
4319 FLAG_ACTIVE VARCHAR2(1 BYTE) DEFAULT '1' NOT NULL,
4320 FLAG_SA VARCHAR2(1 BYTE),
4321 SHOW_ORDER NUMBER(4),
4322 POSITION_X NUMBER(5) DEFAULT 0 NOT NULL,
4323 POSITION_Y NUMBER(5) DEFAULT 0 NOT NULL,
4324 TYPE VARCHAR2(100 BYTE),
4325 USER_ID_YZ NUMBER(10)
4326 )
4327 LOGGING
4328 NOCACHE
4329 NOPARALLEL;
4330
4331
4332 DROP TABLE JGGZ.ZM_TMP CASCADE CONSTRAINTS;
4333
4334 CREATE TABLE JGGZ.ZM_TMP
4335 (
4336 ZF_ID VARCHAR2(12 BYTE) NOT NULL,
4337 ZM_CODE VARCHAR2(6 BYTE) NOT NULL,
4338 ZM_SEQ NUMBER(2),
4339 C_DATE DATE,
4340 U_DATE DATE,
4341 DEL_FLAG CHAR(1 BYTE)
4342 )
4343 LOGGING
4344 NOCACHE
4345 NOPARALLEL;
4346
4347
4348 CREATE INDEX JGGZ.I_DZB_BM ON JGGZ.DZB
4349 (BM)
4350 LOGGING
4351 NOPARALLEL;
4352
4353
4354 CREATE INDEX JGGZ.I_DZB_LB ON JGGZ.DZB
4355 (LB)
4356 LOGGING
4357 NOPARALLEL;
4358
4359
4360 CREATE UNIQUE INDEX JGGZ.PK_KBH_TEMP_TABLE ON JGGZ.KBH_TEMP_TABLE
4361 (KFH, FLAG)
4362 LOGGING
4363 NOPARALLEL;
4364
4365
4366 CREATE UNIQUE INDEX JGGZ.PK_JGGZ_SYNC_SQL ON JGGZ.SYN_SQL
4367 (ID)
4368 LOGGING
4369 NOPARALLEL;
4370
4371
4372 CREATE UNIQUE INDEX JGGZ.T_JXJS_BM_BL_PK ON JGGZ.T_JXJS_BM_BL
4373 (ID)
4374 LOGGING
4375 NOPARALLEL;
4376
4377
4378 CREATE UNIQUE INDEX JGGZ.T_PK_JXJS_FY_CODE ON JGGZ.T_JXJS_FY_BM
4379 (ID)
4380 LOGGING
4381 NOPARALLEL;
4382
4383
4384 CREATE UNIQUE INDEX JGGZ.T_JXJS_JY_PK1_CODE ON JGGZ.T_JXJS_JY_BM
4385 (ID)
4386 LOGGING
4387 NOPARALLEL;
4388
4389
4390 CREATE UNIQUE INDEX JGGZ.T_REPORT_DATA_PRIMARY_KEY ON JGGZ.T_REPORT_DATA
4391 (ID)
4392 LOGGING
4393 NOPARALLEL;
4394
4395
4396 CREATE UNIQUE INDEX JGGZ.PK_REPORT_PROCEDURE_ID ON JGGZ.T_REPORT_PROCEDURE
4397 (ID)
4398 LOGGING
4399 NOPARALLEL;
4400
4401
4402 CREATE UNIQUE INDEX JGGZ.PK_T_SYS_JFKH_AUTOYJ ON JGGZ.T_SYS_JFKH_AUTOYJ
4403 (JYBM)
4404 LOGGING
4405 NOPARALLEL;
4406
4407
4408 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_AUTHORITY_TEST ON JGGZ.T_YZ_AUTHORITY_TEST
4409 (AUTH_ID)
4410 NOLOGGING
4411 NOPARALLEL;
4412
4413
4414 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_DXKTJ ON JGGZ.T_YZ_CXPT_DXKTJ
4415 (MBTJ_ID)
4416 NOLOGGING
4417 NOPARALLEL;
4418
4419
4420 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_FXKTJ ON JGGZ.T_YZ_CXPT_FXKTJ
4421 (MBTJ_ID)
4422 NOLOGGING
4423 NOPARALLEL;
4424
4425
4426 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_MB ON JGGZ.T_YZ_CXPT_MB
4427 (MB_ID)
4428 NOLOGGING
4429 NOPARALLEL;
4430
4431
4432 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_MBGL ON JGGZ.T_YZ_CXPT_MBGL
4433 (ID)
4434 NOLOGGING
4435 NOPARALLEL;
4436
4437
4438 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_MBPX ON JGGZ.T_YZ_CXPT_MBPX
4439 (ID)
4440 NOLOGGING
4441 NOPARALLEL;
4442
4443
4444 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_MBTJ ON JGGZ.T_YZ_CXPT_MBTJ
4445 (MBTJ_ID)
4446 NOLOGGING
4447 NOPARALLEL;
4448
4449
4450 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_MBXGB ON JGGZ.T_YZ_CXPT_MBXGB
4451 (MBXGB_ID)
4452 NOLOGGING
4453 NOPARALLEL;
4454
4455
4456 CREATE UNIQUE INDEX JGGZ.T_YZ_CXPT_MBXSZD_PK ON JGGZ.T_YZ_CXPT_MBXSZD
4457 (ID)
4458 LOGGING
4459 NOPARALLEL;
4460
4461
4462 CREATE UNIQUE INDEX JGGZ.PK_NOOUTLINKTAB_ID ON JGGZ.T_YZ_CXPT_NOOUTLINKTAB
4463 (ID)
4464 LOGGING
4465 NOPARALLEL;
4466
4467
4468 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_SYS_FIELD ON JGGZ.T_YZ_CXPT_SYS_FIELD
4469 (FIELD_ID)
4470 LOGGING
4471 NOPARALLEL;
4472
4473
4474 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_SYS_TABLE ON JGGZ.T_YZ_CXPT_SYS_TABLE
4475 (TABLE_ID)
4476 NOLOGGING
4477 NOPARALLEL;
4478
4479
4480 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CXPT_ZHXTJ ON JGGZ.T_YZ_CXPT_ZHXTJ
4481 (MBTJ_ID)
4482 NOLOGGING
4483 NOPARALLEL;
4484
4485
4486 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_DEPT_TEST ON JGGZ.T_YZ_DEPT_TEST
4487 (DEPT_ID)
4488 NOLOGGING
4489 NOPARALLEL;
4490
4491
4492 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_DJG ON JGGZ.T_YZ_JFKH_DJG
4493 (ID)
4494 LOGGING
4495 NOPARALLEL;
4496
4497
4498 CREATE INDEX JGGZ.IDX_JFKH_JC_ZFID ON JGGZ.T_YZ_JFKH_JC
4499 (ZF_ID)
4500 LOGGING
4501 NOPARALLEL;
4502
4503
4504 CREATE INDEX JGGZ.IDX_JFKH_JC_DATE ON JGGZ.T_YZ_JFKH_JC
4505 (JC_DATE)
4506 LOGGING
4507 NOPARALLEL;
4508
4509
4510 CREATE INDEX JGGZ.IDX_JFKH_JZ ON JGGZ.T_YZ_JFKH_JZ
4511 (ID)
4512 LOGGING
4513 NOPARALLEL;
4514
4515
4516 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_LXFZ ON JGGZ.T_YZ_JFKH_LXFZ
4517 (ID)
4518 LOGGING
4519 NOPARALLEL;
4520
4521
4522 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_REPORT_TEMP ON JGGZ.T_YZ_JFKH_REPORT_TEMP
4523 (SESSIONID, ZFID)
4524 LOGGING
4525 NOPARALLEL;
4526
4527
4528 CREATE INDEX JGGZ.I_T_YZ_JFKH_REPORT_TEMP ON JGGZ.T_YZ_JFKH_REPORT_TEMP
4529 (SESSIONID, DB)
4530 LOGGING
4531 NOPARALLEL;
4532
4533
4534 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKHSCORELOG ON JGGZ.T_YZ_JFKH_SCORE
4535 (ID)
4536 LOGGING
4537 NOPARALLEL;
4538
4539
4540 CREATE INDEX JGGZ.IDX_SCORE_ZFID ON JGGZ.T_YZ_JFKH_SCORE
4541 (ZF_ID)
4542 LOGGING
4543 NOPARALLEL;
4544
4545
4546 CREATE INDEX JGGZ.IDX_SCORE_SCOREDATE ON JGGZ.T_YZ_JFKH_SCORE
4547 (SCOREDATE)
4548 LOGGING
4549 NOPARALLEL;
4550
4551
4552 CREATE INDEX JGGZ.IDX_JFKH_SCORE_DEP ON JGGZ.T_YZ_JFKH_SCORE
4553 (DEPID)
4554 LOGGING
4555 NOPARALLEL;
4556
4557
4558 CREATE INDEX JGGZ.IDX_JFKH_SCORE_JFGJ ON JGGZ.T_YZ_JFKH_SCORE
4559 (JFGJ)
4560 LOGGING
4561 NOPARALLEL;
4562
4563
4564 CREATE INDEX JGGZ.IDX_JFKH_SCORE_DL ON JGGZ.T_YZ_JFKH_SCORE
4565 (DL)
4566 LOGGING
4567 NOPARALLEL;
4568
4569
4570 CREATE INDEX JGGZ.I_JFKH_SCORE_1 ON JGGZ.T_YZ_JFKH_SCORE
4571 (ZF_ID, SCOREDATE, DEL_FLAG, FLAG)
4572 LOGGING
4573 NOPARALLEL;
4574
4575
4576 CREATE INDEX JGGZ.I_JFKH_SCORE_2 ON JGGZ.T_YZ_JFKH_SCORE
4577 (SCOREDATE, DEL_FLAG, FLAG, DEPID)
4578 LOGGING
4579 NOPARALLEL;
4580
4581
4582 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKHCLEARLOG ON JGGZ.T_YZ_JFKH_SCORE_CLEAR
4583 (ID)
4584 LOGGING
4585 NOPARALLEL;
4586
4587
4588 CREATE INDEX JGGZ.IDX_JFKH_SCORE_HISTORY_DEP ON JGGZ.T_YZ_JFKH_SCORE_HISTORY
4589 (DEPID)
4590 LOGGING
4591 NOPARALLEL;
4592
4593
4594 CREATE INDEX JGGZ.IDX_JFKH_SCORE_HISTORY_DL ON JGGZ.T_YZ_JFKH_SCORE_HISTORY
4595 (DL)
4596 LOGGING
4597 NOPARALLEL;
4598
4599
4600 CREATE INDEX JGGZ.IDX_JFKH_SCORE_HISTORY_JFGJ ON JGGZ.T_YZ_JFKH_SCORE_HISTORY
4601 (JFGJ)
4602 LOGGING
4603 NOPARALLEL;
4604
4605
4606 CREATE INDEX JGGZ.IDX_SCORE_SCORE_HISTORYDATE ON JGGZ.T_YZ_JFKH_SCORE_HISTORY
4607 (SCOREDATE)
4608 LOGGING
4609 NOPARALLEL;
4610
4611
4612 CREATE INDEX JGGZ.IDX_SCORE_HISTORY_ZFID ON JGGZ.T_YZ_JFKH_SCORE_HISTORY
4613 (ZF_ID)
4614 LOGGING
4615 NOPARALLEL;
4616
4617
4618 CREATE INDEX JGGZ.I_JFKH_SCORE_HISTORY_1 ON JGGZ.T_YZ_JFKH_SCORE_HISTORY
4619 (ZF_ID, SCOREDATE, DEL_FLAG, FLAG)
4620 LOGGING
4621 NOPARALLEL;
4622
4623
4624 CREATE INDEX JGGZ.I_JFKH_SCORE_HISTORY_2 ON JGGZ.T_YZ_JFKH_SCORE_HISTORY
4625 (SCOREDATE, DEL_FLAG, FLAG, DEPID)
4626 LOGGING
4627 NOPARALLEL;
4628
4629
4630 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_SCORE_HISTORY ON JGGZ.T_YZ_JFKH_SCORE_HISTORY
4631 (ID)
4632 LOGGING
4633 NOPARALLEL;
4634
4635
4636 CREATE INDEX JGGZ.IDX_YEAR ON JGGZ.T_YZ_JFKH_SCORE_MONTH
4637 (YEAR)
4638 LOGGING
4639 NOPARALLEL;
4640
4641
4642 CREATE INDEX JGGZ.IDX_MONTH ON JGGZ.T_YZ_JFKH_SCORE_MONTH
4643 (MONTH)
4644 LOGGING
4645 NOPARALLEL;
4646
4647
4648 CREATE INDEX JGGZ.IDX_ZFID ON JGGZ.T_YZ_JFKH_SCORE_MONTH
4649 (ZF_ID)
4650 LOGGING
4651 NOPARALLEL;
4652
4653
4654 CREATE INDEX JGGZ.I_YZ_JFKH_SCORE_MONTH_3 ON JGGZ.T_YZ_JFKH_SCORE_MONTH
4655 (ZF_ID, YEAR, MONTH)
4656 LOGGING
4657 NOPARALLEL;
4658
4659
4660 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_SCORE_MONTH ON JGGZ.T_YZ_JFKH_SCORE_MONTH
4661 (ID)
4662 LOGGING
4663 NOPARALLEL;
4664
4665
4666 CREATE INDEX JGGZ.I_YZ_JFKH_SCORE_MONTH_2 ON JGGZ.T_YZ_JFKH_SCORE_MONTH
4667 (YEAR, MONTH)
4668 LOGGING
4669 NOPARALLEL;
4670
4671
4672 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKHSPJ ON JGGZ.T_YZ_JFKH_SPJ
4673 (ID)
4674 LOGGING
4675 NOPARALLEL;
4676
4677
4678 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_USER ON JGGZ.T_YZ_JFKH_USER
4679 (ID)
4680 LOGGING
4681 NOPARALLEL;
4682
4683
4684 CREATE INDEX JGGZ.I_T_YZ_JFKH_USER ON JGGZ.T_YZ_JFKH_USER
4685 (USER_ID)
4686 LOGGING
4687 NOPARALLEL;
4688
4689
4690 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_XBF ON JGGZ.T_YZ_JFKH_XBF
4691 (ID)
4692 LOGGING
4693 NOPARALLEL;
4694
4695
4696 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_XBF_DEPT ON JGGZ.T_YZ_JFKH_XBF_DEPT
4697 (ID)
4698 LOGGING
4699 NOPARALLEL;
4700
4701
4702 CREATE INDEX JGGZ.I_T_YZ_JFKH_XBF_DEPT_DF ON JGGZ.T_YZ_JFKH_XBF_DEPT
4703 (DEL_FLAG)
4704 LOGGING
4705 NOPARALLEL;
4706
4707
4708 CREATE INDEX JGGZ.I_T_YZ_JFKH_XBF_DEPT_DT ON JGGZ.T_YZ_JFKH_XBF_DEPT
4709 (DEPTTYPE)
4710 LOGGING
4711 NOPARALLEL;
4712
4713
4714 CREATE INDEX JGGZ.I_T_YZ_JFKH_XBF_DEPT_BM ON JGGZ.T_YZ_JFKH_XBF_DEPT
4715 (BM)
4716 LOGGING
4717 NOPARALLEL;
4718
4719
4720 CREATE INDEX JGGZ.I_T_YZ_JFKH_XBF_DEPT_PI ON JGGZ.T_YZ_JFKH_XBF_DEPT
4721 (PARENTID)
4722 LOGGING
4723 NOPARALLEL;
4724
4725
4726 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_XBF_DETAIL ON JGGZ.T_YZ_JFKH_XBF_DETAIL
4727 (ID)
4728 LOGGING
4729 NOPARALLEL;
4730
4731
4732 CREATE INDEX JGGZ.I_T_YZ_JFKH_XBF_DETAIL_XD ON JGGZ.T_YZ_JFKH_XBF_DETAIL
4733 (XBDATE)
4734 LOGGING
4735 NOPARALLEL;
4736
4737
4738 CREATE INDEX JGGZ.I_T_YZ_JFKH_XBF_DETAIL_XDT ON JGGZ.T_YZ_JFKH_XBF_DETAIL
4739 (XBDEPT)
4740 LOGGING
4741 NOPARALLEL;
4742
4743
4744 CREATE INDEX JGGZ.I_T_YZ_JFKH_XBF_DETAIL_JDT ON JGGZ.T_YZ_JFKH_XBF_DETAIL
4745 (JSDEPT)
4746 LOGGING
4747 NOPARALLEL;
4748
4749
4750 CREATE INDEX JGGZ.I_T_YZ_JFKH_XBF_DETAIL_DF ON JGGZ.T_YZ_JFKH_XBF_DETAIL
4751 (DEL_FLAG)
4752 LOGGING
4753 NOPARALLEL;
4754
4755
4756 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_XBF_USER ON JGGZ.T_YZ_JFKH_XBF_USER
4757 (USERID)
4758 LOGGING
4759 NOPARALLEL;
4760
4761
4762 CREATE UNIQUE INDEX JGGZ.T_YZ_JFKHXZ_PK31079507316854 ON JGGZ.T_YZ_JFKH_XZ
4763 (ID)
4764 LOGGING
4765 NOPARALLEL;
4766
4767
4768 CREATE UNIQUE INDEX JGGZ.PK ON JGGZ.T_YZ_JFKH_YJ_DEPT
4769 (ID)
4770 LOGGING
4771 NOPARALLEL;
4772
4773
4774 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_ZF ON JGGZ.T_YZ_JFKH_ZF
4775 (ID)
4776 LOGGING
4777 NOPARALLEL;
4778
4779
4780 CREATE INDEX JGGZ.IDX_JFKH_ZFID ON JGGZ.T_YZ_JFKH_ZF
4781 (ZF_ID)
4782 LOGGING
4783 NOPARALLEL;
4784
4785
4786 CREATE INDEX JGGZ.IDX_JFKH_ZF_DEPID ON JGGZ.T_YZ_JFKH_ZF
4787 (ZF_DEPID)
4788 LOGGING
4789 NOPARALLEL;
4790
4791
4792 CREATE INDEX JGGZ.I_YZ_JFKH_ZF_1 ON JGGZ.T_YZ_JFKH_ZF
4793 (ZF_ID, ZF_DEPID)
4794 LOGGING
4795 NOPARALLEL;
4796
4797
4798 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_JFKH_ZFLX ON JGGZ.T_YZ_JFKH_ZFLX
4799 (ID)
4800 LOGGING
4801 NOPARALLEL;
4802
4803
4804 CREATE INDEX JGGZ.I_T_YZ_JFKH_ZF_HISTORY ON JGGZ.T_YZ_JFKH_ZF_HISTORY
4805 (ZF_ID, YEAR, MONTH)
4806 LOGGING
4807 NOPARALLEL;
4808
4809
4810 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_LOGS ON JGGZ.T_YZ_LOGS
4811 (ID)
4812 NOLOGGING
4813 NOPARALLEL;
4814
4815
4816 CREATE INDEX JGGZ.I_YZ_LOGS_1 ON JGGZ.T_YZ_LOGS
4817 (USERID, TIME)
4818 LOGGING
4819 NOPARALLEL;
4820
4821
4822 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_MINGCE ON JGGZ.T_YZ_MINGCE
4823 (ID)
4824 LOGGING
4825 NOPARALLEL;
4826
4827
4828 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_PROM_INFO ON JGGZ.T_YZ_PROM_INFO
4829 (ID)
4830 LOGGING
4831 NOPARALLEL;
4832
4833
4834 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_RC_GZJS ON JGGZ.T_YZ_RC_GZJS
4835 (ID)
4836 LOGGING
4837 NOPARALLEL;
4838
4839
4840 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_RC_THDJ ON JGGZ.T_YZ_RC_THDJ
4841 (ID)
4842 LOGGING
4843 NOPARALLEL;
4844
4845
4846 CREATE INDEX JGGZ.I_YZ_RC_THDJ_1 ON JGGZ.T_YZ_RC_THDJ
4847 (ZF_ID, DEL_FLAG)
4848 LOGGING
4849 NOPARALLEL;
4850
4851
4852 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ROLE_AUTHORITY_TEST ON JGGZ.T_YZ_ROLE_AUTHORITY_TEST
4853 (AUTH_ID, ROLE_ID)
4854 NOLOGGING
4855 NOPARALLEL;
4856
4857
4858 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ROLE_TEST ON JGGZ.T_YZ_ROLE_TEST
4859 (ROLE_ID)
4860 NOLOGGING
4861 NOPARALLEL;
4862
4863
4864 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_SFWS ON JGGZ.T_YZ_SFWS
4865 (SFWSID)
4866 LOGGING
4867 NOPARALLEL;
4868
4869
4870 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_SFWSNO ON JGGZ.T_YZ_SFWSNO
4871 (ID)
4872 LOGGING
4873 NOPARALLEL;
4874
4875
4876 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_SFWS_MR ON JGGZ.T_YZ_SFWS_MR
4877 (ID)
4878 LOGGING
4879 NOPARALLEL;
4880
4881
4882 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_SWDJ ON JGGZ.T_YZ_SWDJ
4883 (ZF_ID)
4884 LOGGING
4885 NOPARALLEL;
4886
4887
4888 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_SWJD ON JGGZ.T_YZ_SWJD
4889 (ID)
4890 NOLOGGING
4891 NOPARALLEL;
4892
4893
4894 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_TAB_RELATION ON JGGZ.T_YZ_TAB_RELATION
4895 (TAB_ID)
4896 NOLOGGING
4897 NOPARALLEL;
4898
4899
4900 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_TGZF ON JGGZ.T_YZ_TGZF
4901 (ID)
4902 NOLOGGING
4903 NOPARALLEL;
4904
4905
4906 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_THJH ON JGGZ.T_YZ_THJH
4907 (ID)
4908 NOLOGGING
4909 NOPARALLEL;
4910
4911
4912 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_USER_TEST ON JGGZ.T_YZ_USER_TEST
4913 (USER_ID)
4914 NOLOGGING
4915 NOPARALLEL;
4916
4917
4918 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_WSSP ON JGGZ.T_YZ_WSSP
4919 (ID)
4920 LOGGING
4921 NOPARALLEL;
4922
4923
4924 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_WSSP_MR ON JGGZ.T_YZ_WSSP_MR
4925 (ID)
4926 LOGGING
4927 NOPARALLEL;
4928
4929
4930 CREATE UNIQUE INDEX JGGZ.T_YZ_XT_BM_PK ON JGGZ.T_YZ_XT_BM
4931 (ID)
4932 LOGGING
4933 NOPARALLEL;
4934
4935
4936 CREATE INDEX JGGZ.I_YZ_XT_BM_1 ON JGGZ.T_YZ_XT_BM
4937 (LBID, SM)
4938 LOGGING
4939 NOPARALLEL;
4940
4941
4942 CREATE INDEX JGGZ.I_YZ_XT_BM_2 ON JGGZ.T_YZ_XT_BM
4943 (LBID, REMOVEFLAG)
4944 LOGGING
4945 NOPARALLEL;
4946
4947
4948 CREATE INDEX JGGZ.I_YZ_XT_BM_3 ON JGGZ.T_YZ_XT_BM
4949 (LBID, BM, REMOVEFLAG)
4950 LOGGING
4951 NOPARALLEL;
4952
4953
4954 CREATE INDEX JGGZ.I_YZ_XT_BM_4 ON JGGZ.T_YZ_XT_BM
4955 (LBID, LRM, REMOVEFLAG)
4956 LOGGING
4957 NOPARALLEL;
4958
4959
4960 CREATE INDEX JGGZ.I_YZ_XT_BM_5 ON JGGZ.T_YZ_XT_BM
4961 (LBID, SM, REMOVEFLAG)
4962 LOGGING
4963 NOPARALLEL;
4964
4965
4966 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_CHKITEMS ON JGGZ.T_YZ_XT_CHKITEMS
4967 (ID)
4968 LOGGING
4969 NOPARALLEL;
4970
4971
4972 CREATE INDEX JGGZ.I_T_YZ_XT_CHKITEMS ON JGGZ.T_YZ_XT_CHKITEMS
4973 (PARENTID, DEL_FALG)
4974 LOGGING
4975 NOPARALLEL;
4976
4977
4978 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_CHECKMODUL ON JGGZ.T_YZ_XT_CHKMODUL
4979 (ID)
4980 LOGGING
4981 NOPARALLEL;
4982
4983
4984 CREATE INDEX JGGZ.I_T_YZ_XT_CHECKMODUL ON JGGZ.T_YZ_XT_CHKMODUL
4985 (DEL_FLAG)
4986 LOGGING
4987 NOPARALLEL;
4988
4989
4990 CREATE INDEX JGGZ.I_T_YZ_XT_CHKR_1 ON JGGZ.T_YZ_XT_CHKR
4991 (SESSIONID, DB)
4992 LOGGING
4993 NOPARALLEL;
4994
4995
4996 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_DIMEN ON JGGZ.T_YZ_XT_DIMEN
4997 (ID)
4998 NOLOGGING
4999 NOPARALLEL;
5000
5001
5002 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_DIMENMEMBER ON JGGZ.T_YZ_XT_DIMENMEMBER
5003 (ID)
5004 NOLOGGING
5005 NOPARALLEL;
5006
5007
5008 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_DISDIMENMEMBER ON JGGZ.T_YZ_XT_DISDIMENMEMBER
5009 (ID)
5010 NOLOGGING
5011 NOPARALLEL;
5012
5013
5014 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_DWTJ_CUBEDEFINE ON JGGZ.T_YZ_XT_DWTJ_CUBEDEFINE
5015 (ID)
5016 LOGGING
5017 NOPARALLEL;
5018
5019
5020 CREATE UNIQUE INDEX JGGZ.PK_BM_ID ON JGGZ.T_YZ_XT_EDITBM
5021 (ID)
5022 LOGGING
5023 NOPARALLEL;
5024
5025
5026 CREATE UNIQUE INDEX JGGZ.T_YZ_XT_HOST_PK ON JGGZ.T_YZ_XT_HOST
5027 (ID)
5028 LOGGING
5029 NOPARALLEL;
5030
5031
5032 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_MRZ_USED ON JGGZ.T_YZ_XT_MRZ_USED
5033 (ZF_ID)
5034 LOGGING
5035 NOPARALLEL;
5036
5037
5038 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_PARA ON JGGZ.T_YZ_XT_PARA
5039 (PARAID)
5040 LOGGING
5041 NOPARALLEL;
5042
5043
5044 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_QUERYCONFIG ON JGGZ.T_YZ_XT_QUERYCONFIG
5045 (ID)
5046 LOGGING
5047 NOPARALLEL;
5048
5049
5050 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_SEQDIMENMEMBER ON JGGZ.T_YZ_XT_SEQDIMENMEMBER
5051 (ID)
5052 NOLOGGING
5053 NOPARALLEL;
5054
5055
5056 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_XT_WEB_POPEDOM ON JGGZ.T_YZ_XT_WEB_POPEDOM
5057 (ID)
5058 LOGGING
5059 NOPARALLEL;
5060
5061
5062 CREATE INDEX JGGZ.I_T_YZ_XT_ZH_1 ON JGGZ.T_YZ_XT_ZH
5063 (ZH_CN)
5064 LOGGING
5065 NOPARALLEL;
5066
5067
5068 CREATE INDEX JGGZ.I_T_YZ_XT_ZH_2 ON JGGZ.T_YZ_XT_ZH
5069 (PY)
5070 LOGGING
5071 NOPARALLEL;
5072
5073
5074 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZFKG ON JGGZ.T_YZ_ZFKG
5075 (ID)
5076 NOLOGGING
5077 NOPARALLEL;
5078
5079
5080 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZFKG_MB ON JGGZ.T_YZ_ZFKG_MB
5081 (KG_ID)
5082 NOLOGGING
5083 NOPARALLEL;
5084
5085
5086 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZFLJ ON JGGZ.T_YZ_ZFLJ
5087 (ID)
5088 LOGGING
5089 NOPARALLEL;
5090
5091
5092 CREATE INDEX JGGZ.I_YZ_ZFLJ_1 ON JGGZ.T_YZ_ZFLJ
5093 (ZF_ID, DEL_FLAG)
5094 LOGGING
5095 NOPARALLEL;
5096
5097
5098 CREATE INDEX JGGZ.I_YZ_ZFLJ_2 ON JGGZ.T_YZ_ZFLJ
5099 (ZF_ID, C_DATE, DEL_FLAG)
5100 LOGGING
5101 NOPARALLEL;
5102
5103
5104 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZFSS ON JGGZ.T_YZ_ZFSS
5105 (ID)
5106 LOGGING
5107 NOPARALLEL;
5108
5109
5110 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZFSSXX ON JGGZ.T_YZ_ZFSSXX
5111 (ID)
5112 NOLOGGING
5113 NOPARALLEL;
5114
5115
5116 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_BSJ ON JGGZ.T_YZ_ZF_BSJ
5117 (BSJ_NO)
5118 LOGGING
5119 NOPARALLEL;
5120
5121
5122 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_BWXB ON JGGZ.T_YZ_ZF_BWXB
5123 (ID)
5124 LOGGING
5125 NOPARALLEL;
5126
5127
5128 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_CRJ_INFO ON JGGZ.T_YZ_ZF_CRJ_INFO
5129 (ID)
5130 LOGGING
5131 NOPARALLEL;
5132
5133
5134 CREATE INDEX JGGZ.I_YZ_ZF_CRJ ON JGGZ.T_YZ_ZF_CRJ_INFO
5135 (ZF_ID, RJ_DATE, LJ_DATE, LJ_TYPE)
5136 LOGGING
5137 NOPARALLEL;
5138
5139
5140 CREATE INDEX JGGZ.I_YZ_ZF_CRJ_ZFID ON JGGZ.T_YZ_ZF_CRJ_INFO
5141 (ZF_ID)
5142 LOGGING
5143 NOPARALLEL;
5144
5145
5146 CREATE INDEX JGGZ.I_YZ_ZF_CRJ_INFO_1 ON JGGZ.T_YZ_ZF_CRJ_INFO
5147 (ZF_ID, DEL_FLAG)
5148 LOGGING
5149 NOPARALLEL;
5150
5151
5152 CREATE INDEX JGGZ.I_YZ_ZF_CRJ_INFO_2 ON JGGZ.T_YZ_ZF_CRJ_INFO
5153 (ZF_ID, RJ_DATE, LJ_DATE, DEL_FLAG)
5154 LOGGING
5155 NOPARALLEL;
5156
5157
5158 CREATE INDEX JGGZ.I_YZ_ZF_CRJ_INFO_3 ON JGGZ.T_YZ_ZF_CRJ_INFO
5159 (ZF_ID, RJ_TYPE, RJ_DATE, DEL_FLAG)
5160 LOGGING
5161 NOPARALLEL;
5162
5163
5164 CREATE INDEX JGGZ.I_YZ_ZF_CRJ_INFO_4 ON JGGZ.T_YZ_ZF_CRJ_INFO
5165 (ZF_ID, LJ_TYPE, LJ_DATE, DEL_FLAG)
5166 LOGGING
5167 NOPARALLEL;
5168
5169
5170 CREATE INDEX JGGZ.I_YZ_ZF_CRJ_INFO_5 ON JGGZ.T_YZ_ZF_CRJ_INFO
5171 (RJ_DATE, LJ_DATE)
5172 LOGGING
5173 NOPARALLEL;
5174
5175
5176 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_DBDD ON JGGZ.T_YZ_ZF_DBDD
5177 (ID)
5178 LOGGING
5179 NOPARALLEL;
5180
5181
5182 CREATE INDEX JGGZ.I_YZ_ZF_DBDD ON JGGZ.T_YZ_ZF_DBDD
5183 (ZF_ID, DDQ_DB, DD_DATE, DEL_FLAG)
5184 LOGGING
5185 NOPARALLEL;
5186
5187
5188 CREATE INDEX JGGZ.I_YZ_ZF_DBDD_1 ON JGGZ.T_YZ_ZF_DBDD
5189 (ZF_ID, DEL_FLAG)
5190 LOGGING
5191 NOPARALLEL;
5192
5193
5194 CREATE INDEX JGGZ.I_YZ_ZF_DBDD_2 ON JGGZ.T_YZ_ZF_DBDD
5195 (ZF_ID, DD_DATE, DEL_FLAG)
5196 LOGGING
5197 NOPARALLEL;
5198
5199
5200 CREATE INDEX JGGZ.I_YZ_ZF_DBDD_3 ON JGGZ.T_YZ_ZF_DBDD
5201 (ZF_ID, DD_DATE, DDQ_DB, DEL_FLAG)
5202 LOGGING
5203 NOPARALLEL;
5204
5205
5206 CREATE INDEX JGGZ.I_YZ_ZF_DBDD_4 ON JGGZ.T_YZ_ZF_DBDD
5207 (ZF_ID, DD_DATE, DDH_DB, DEL_FLAG)
5208 LOGGING
5209 NOPARALLEL;
5210
5211
5212 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_DSJ ON JGGZ.T_YZ_ZF_DSJ
5213 (ID)
5214 LOGGING
5215 NOPARALLEL;
5216
5217
5218 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_FGDJ ON JGGZ.T_YZ_ZF_FGDJ
5219 (ID)
5220 LOGGING
5221 NOPARALLEL;
5222
5223
5224 CREATE INDEX JGGZ.I_YZ_ZF_FGDJ_1 ON JGGZ.T_YZ_ZF_FGDJ
5225 (ZF_ID, DEL_FLAG)
5226 LOGGING
5227 NOPARALLEL;
5228
5229
5230 CREATE INDEX JGGZ.I_YZ_ZF_FGDJ_2 ON JGGZ.T_YZ_ZF_FGDJ
5231 (ZF_ID, PZ_DATE, DEL_FLAG)
5232 LOGGING
5233 NOPARALLEL;
5234
5235
5236 CREATE INDEX JGGZ.I_YZ_ZF_FGDJ_3 ON JGGZ.T_YZ_ZF_FGDJ
5237 (ZF_ID, PZ_DATE, BDQ_DJ, DEL_FLAG)
5238 LOGGING
5239 NOPARALLEL;
5240
5241
5242 CREATE INDEX JGGZ.I_YZ_ZF_FGDJ_4 ON JGGZ.T_YZ_ZF_FGDJ
5243 (ZF_ID, PZ_DATE, BDH_DJ, DEL_FLAG)
5244 LOGGING
5245 NOPARALLEL;
5246
5247
5248 CREATE UNIQUE INDEX JGGZ.I_YZ_ZF_FJXX_ZFID ON JGGZ.T_YZ_ZF_FJXX
5249 (ZF_ID)
5250 LOGGING
5251 NOPARALLEL;
5252
5253
5254 CREATE INDEX JGGZ.I_YZ_ZF_FK_ZFID ON JGGZ.T_YZ_ZF_FK
5255 (ZF_ID)
5256 LOGGING
5257 NOPARALLEL;
5258
5259
5260 CREATE INDEX JGGZ.I_YZ_ZF_FK_1 ON JGGZ.T_YZ_ZF_FK
5261 (ZF_ID, DEL_FLAG)
5262 LOGGING
5263 NOPARALLEL;
5264
5265
5266 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_FLFA ON JGGZ.T_YZ_ZF_FLFA
5267 (PLAN_NO)
5268 NOLOGGING
5269 NOPARALLEL;
5270
5271
5272 CREATE INDEX JGGZ.I_T_YZ_ZF_FLFA ON JGGZ.T_YZ_ZF_FLFA
5273 (PLAN_NAME, DEL_FLAG)
5274 LOGGING
5275 NOPARALLEL;
5276
5277
5278 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_FLFAMC ON JGGZ.T_YZ_ZF_FLFAMC
5279 (ZF_ID)
5280 LOGGING
5281 NOPARALLEL;
5282
5283
5284 CREATE INDEX JGGZ.I_T_YZ_ZF_FLFLMC ON JGGZ.T_YZ_ZF_FLFAMC
5285 (PLAN_NO, FLREASON)
5286 LOGGING
5287 NOPARALLEL;
5288
5289
5290 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_FLSZ ON JGGZ.T_YZ_ZF_FLSZ
5291 (ID)
5292 LOGGING
5293 NOPARALLEL;
5294
5295
5296 CREATE INDEX JGGZ.I_T_YZ_ZF_FLSZ ON JGGZ.T_YZ_ZF_FLSZ
5297 (JSDW)
5298 LOGGING
5299 NOPARALLEL;
5300
5301
5302 CREATE INDEX JGGZ.I_T_YZ_ZF_FLTEMP_1 ON JGGZ.T_YZ_ZF_FLTEMP
5303 (SESSIONID, JSDWID)
5304 LOGGING
5305 NOPARALLEL;
5306
5307
5308 CREATE INDEX JGGZ.I_T_YZ_ZF_FLTEMP_2 ON JGGZ.T_YZ_ZF_FLTEMP
5309 (SESSIONID, FLSTATUS)
5310 LOGGING
5311 NOPARALLEL;
5312
5313
5314 CREATE INDEX JGGZ.I_T_YZ_ZF_FLTEMP_3 ON JGGZ.T_YZ_ZF_FLTEMP
5315 (SESSIONID, YX, FLSTATUS, BIRTH)
5316 LOGGING
5317 NOPARALLEL;
5318
5319
5320 CREATE INDEX JGGZ.I_T_YZ_ZF_FLTEMP_4 ON JGGZ.T_YZ_ZF_FLTEMP
5321 (SESSIONID, YX, FLSTATUS, BIRTH, JSDWID,
5322 FYTYPE, LBC)
5323 LOGGING
5324 NOPARALLEL;
5325
5326
5327 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_FLTJ ON JGGZ.T_YZ_ZF_FLTJ
5328 (ID)
5329 LOGGING
5330 NOPARALLEL;
5331
5332
5333 CREATE INDEX JGGZ.I_T_YZ_ZF_FLTJ ON JGGZ.T_YZ_ZF_FLTJ
5334 (JSDWID, TIAOJIANTYPE)
5335 LOGGING
5336 NOPARALLEL;
5337
5338
5339 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_HBKC ON JGGZ.T_YZ_ZF_HBKC
5340 (ID)
5341 LOGGING
5342 NOPARALLEL;
5343
5344
5345 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_JK ON JGGZ.T_YZ_ZF_JK
5346 (ZF_ID)
5347 LOGGING
5348 NOPARALLEL;
5349
5350
5351 CREATE INDEX JGGZ.I_YZ_ZF_JK ON JGGZ.T_YZ_ZF_JK
5352 (ZF_ID, SY_STATUS, NYDW, PJ_NO1, PJ_NO2)
5353 LOGGING
5354 NOPARALLEL;
5355
5356
5357 CREATE INDEX JGGZ.I_YZ_ZF_JK_2 ON JGGZ.T_YZ_ZF_JK
5358 (ZF_FH, SY_STATUS, NYDW, DEL_FLAG)
5359 LOGGING
5360 NOPARALLEL;
5361
5362
5363 CREATE INDEX JGGZ.I_YZ_ZF_JK_3 ON JGGZ.T_YZ_ZF_JK
5364 (ZF_NAME, SY_STATUS, NYDW, DEL_FLAG)
5365 LOGGING
5366 NOPARALLEL;
5367
5368
5369 CREATE INDEX JGGZ.I_YZ_ZF_JK_4 ON JGGZ.T_YZ_ZF_JK
5370 (ZF_ID, SY_STATUS, NYDW, PJ_NO1, PJ_NO2,
5371 DEL_FLAG)
5372 LOGGING
5373 NOPARALLEL;
5374
5375
5376 CREATE INDEX JGGZ.I_YZ_ZF_JK_1 ON JGGZ.T_YZ_ZF_JK
5377 (ZF_ID, NYDW, DEL_FLAG)
5378 LOGGING
5379 NOPARALLEL;
5380
5381
5382 CREATE INDEX JGGZ.I_YZ_ZF_JK_20060526184028 ON JGGZ.T_YZ_ZF_JK_20060526184028
5383 (ZF_ID)
5384 LOGGING
5385 NOPARALLEL;
5386
5387
5388 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_JL ON JGGZ.T_YZ_ZF_JL
5389 (ID)
5390 LOGGING
5391 NOPARALLEL;
5392
5393
5394 CREATE INDEX JGGZ."I_yz_zf_jl_zfid" ON JGGZ.T_YZ_ZF_JL
5395 (ZF_ID)
5396 LOGGING
5397 NOPARALLEL;
5398
5399
5400 CREATE INDEX JGGZ.I_YZ_ZF_JL_1 ON JGGZ.T_YZ_ZF_JL
5401 (ZF_ID, DEL_FLAG)
5402 LOGGING
5403 NOPARALLEL;
5404
5405
5406 CREATE INDEX JGGZ.I_YZ_ZF_JL_2 ON JGGZ.T_YZ_ZF_JL
5407 (ZF_ID, XH, DEL_FLAG)
5408 LOGGING
5409 NOPARALLEL;
5410
5411
5412 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_JLXX ON JGGZ.T_YZ_ZF_JLXX
5413 (JL_NO)
5414 LOGGING
5415 NOPARALLEL;
5416
5417
5418 CREATE INDEX JGGZ.I_YZ_ZF_JLXX_1 ON JGGZ.T_YZ_ZF_JLXX
5419 (ZF_ID, DEL_FLAG)
5420 LOGGING
5421 NOPARALLEL;
5422
5423
5424 CREATE INDEX JGGZ.I_YZ_ZF_JLXX_2 ON JGGZ.T_YZ_ZF_JLXX
5425 (ZF_ID, TYPE, DEL_FLAG)
5426 LOGGING
5427 NOPARALLEL;
5428
5429
5430 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_JWBW ON JGGZ.T_YZ_ZF_JWBW
5431 (ID)
5432 LOGGING
5433 NOPARALLEL;
5434
5435
5436 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_LBC ON JGGZ.T_YZ_ZF_LBC
5437 (LBC_NO)
5438 NOLOGGING
5439 NOPARALLEL;
5440
5441
5442 CREATE INDEX JGGZ.I_YZ_ZF_LBC_1 ON JGGZ.T_YZ_ZF_LBC
5443 (ZF_ID, DEL_FLAG)
5444 LOGGING
5445 NOPARALLEL;
5446
5447
5448 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_LBC_FS ON JGGZ.T_YZ_ZF_LBC_FS
5449 (ID)
5450 LOGGING
5451 NOPARALLEL;
5452
5453
5454 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_MTXX ON JGGZ.T_YZ_ZF_MTXX
5455 (MT_NO)
5456 LOGGING
5457 NOPARALLEL;
5458
5459
5460 CREATE INDEX JGGZ.I_YZ_ZF_MTXX_ZFID ON JGGZ.T_YZ_ZF_MTXX
5461 (ZF_ID)
5462 LOGGING
5463 NOPARALLEL;
5464
5465
5466 CREATE INDEX JGGZ.I_YZ_ZF_MTXX_1 ON JGGZ.T_YZ_ZF_MTXX
5467 (ZF_ID, DEL_FLAG)
5468 LOGGING
5469 NOPARALLEL;
5470
5471
5472 CREATE INDEX JGGZ.I_YZ_ZF_MTXX_2 ON JGGZ.T_YZ_ZF_MTXX
5473 (ZF_ID, MT_TYPE, DEL_FLAG)
5474 LOGGING
5475 NOPARALLEL;
5476
5477
5478 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_MTXX_LOG ON JGGZ.T_YZ_ZF_MTXX_LOG
5479 (ID)
5480 LOGGING
5481 NOPARALLEL;
5482
5483
5484 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_NFL ON JGGZ.T_YZ_ZF_NFL
5485 (PLAN_NO, JSDWID)
5486 LOGGING
5487 NOPARALLEL;
5488
5489
5490 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_NFL_TJ ON JGGZ.T_YZ_ZF_NFL_TJ
5491 (ID)
5492 LOGGING
5493 NOPARALLEL;
5494
5495
5496 CREATE INDEX JGGZ.I_T_YZ_ZF_NFL_TJ_1 ON JGGZ.T_YZ_ZF_NFL_TJ
5497 (TJTYPE)
5498 LOGGING
5499 NOPARALLEL;
5500
5501
5502 CREATE INDEX JGGZ.I_T_YZ_ZF_NFL_TJ_2 ON JGGZ.T_YZ_ZF_NFL_TJ
5503 (JSDW, COLTITLE)
5504 LOGGING
5505 NOPARALLEL;
5506
5507
5508 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_NWFG ON JGGZ.T_YZ_ZF_NWFG
5509 (ID)
5510 LOGGING
5511 NOPARALLEL;
5512
5513
5514 CREATE INDEX JGGZ.I_YZ_ZF_NWFG_1 ON JGGZ.T_YZ_ZF_NWFG
5515 (ZF_ID, DEL_FLAG)
5516 LOGGING
5517 NOPARALLEL;
5518
5519
5520 CREATE INDEX JGGZ.I_YZ_ZF_NWFG_2 ON JGGZ.T_YZ_ZF_NWFG
5521 (ZF_ID, PZ_DATE, DEL_FLAG)
5522 LOGGING
5523 NOPARALLEL;
5524
5525
5526 CREATE INDEX JGGZ.I_YZ_ZF_NWFG_3 ON JGGZ.T_YZ_ZF_NWFG
5527 (ZF_ID, PZ_DATE, FG, DEL_FLAG)
5528 LOGGING
5529 NOPARALLEL;
5530
5531
5532 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_QJFJ ON JGGZ.T_YZ_ZF_QJFJ
5533 (ID)
5534 LOGGING
5535 NOPARALLEL;
5536
5537
5538 CREATE INDEX JGGZ.I_YZ_ZF_QKLJ_ZFID ON JGGZ.T_YZ_ZF_QKLJ
5539 (ZF_ID)
5540 LOGGING
5541 NOPARALLEL;
5542
5543
5544 CREATE INDEX JGGZ.I_YZ_ZF_QKLJ_1 ON JGGZ.T_YZ_ZF_QKLJ
5545 (ZF_ID, QKLJ_LB, LB)
5546 LOGGING
5547 NOPARALLEL;
5548
5549
5550 CREATE INDEX JGGZ.I_YZ_ZF_QKLJ_2 ON JGGZ.T_YZ_ZF_QKLJ
5551 (ZF_ID, LB)
5552 LOGGING
5553 NOPARALLEL;
5554
5555
5556 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_SF ON JGGZ.T_YZ_ZF_SFZF
5557 (ID)
5558 LOGGING
5559 NOPARALLEL;
5560
5561
5562 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_SHGX ON JGGZ.T_YZ_ZF_SHGX
5563 (SHGX_NO)
5564 NOLOGGING
5565 NOPARALLEL;
5566
5567
5568 CREATE INDEX JGGZ.I_YZ_ZF_SHGX_ZFID ON JGGZ.T_YZ_ZF_SHGX
5569 (ZF_ID)
5570 LOGGING
5571 NOPARALLEL;
5572
5573
5574 CREATE INDEX JGGZ.I_YZ_ZF_SHGX_1 ON JGGZ.T_YZ_ZF_SHGX
5575 (ZF_ID, DEL_FLAG)
5576 LOGGING
5577 NOPARALLEL;
5578
5579
5580 CREATE INDEX JGGZ.I_YZ_ZF_SHGX_2 ON JGGZ.T_YZ_ZF_SHGX
5581 (ZF_ID, XH, DEL_FLAG)
5582 LOGGING
5583 NOPARALLEL;
5584
5585
5586 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_SJ ON JGGZ.T_YZ_ZF_SJZF
5587 (ID)
5588 LOGGING
5589 NOPARALLEL;
5590
5591
5592 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_SS ON JGGZ.T_YZ_ZF_SS
5593 (SS_NO)
5594 NOLOGGING
5595 NOPARALLEL;
5596
5597
5598 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_TAF ON JGGZ.T_YZ_ZF_TAF
5599 (TAF_NO)
5600 NOLOGGING
5601 NOPARALLEL;
5602
5603
5604 CREATE INDEX JGGZ.I_YZ_ZF_TC ON JGGZ.T_YZ_ZF_TC
5605 (ZF_ID)
5606 LOGGING
5607 NOPARALLEL;
5608
5609
5610 CREATE INDEX JGGZ.I_YZ_ZF_TC_1 ON JGGZ.T_YZ_ZF_TC
5611 (ZF_ID, C_DATE)
5612 LOGGING
5613 NOPARALLEL;
5614
5615
5616 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_TC ON JGGZ.T_YZ_ZF_TC
5617 (ZF_ID, TC)
5618 LOGGING
5619 NOPARALLEL;
5620
5621
5622 CREATE INDEX JGGZ.I_YZ_ZF_TG_1 ON JGGZ.T_YZ_ZF_TG
5623 (ZF_ID, XH)
5624 LOGGING
5625 NOPARALLEL;
5626
5627
5628 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_TGSK ON JGGZ.T_YZ_ZF_TGSK
5629 (ID)
5630 LOGGING
5631 NOPARALLEL;
5632
5633
5634 CREATE INDEX JGGZ.I_YZ_ZF_TMTZ_1 ON JGGZ.T_YZ_ZF_TMTZ
5635 (ZF_ID, DEL_FLAG)
5636 LOGGING
5637 NOPARALLEL;
5638
5639
5640 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_TMTZ ON JGGZ.T_YZ_ZF_TMTZ
5641 (ZF_ID)
5642 LOGGING
5643 NOPARALLEL;
5644
5645
5646 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_TT ON JGGZ.T_YZ_ZF_TT
5647 (ID)
5648 LOGGING
5649 NOPARALLEL;
5650
5651
5652 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_UNUSEDZFBH ON JGGZ.T_YZ_ZF_UNUSEDZFBH
5653 (ID)
5654 LOGGING
5655 NOPARALLEL;
5656
5657
5658 CREATE UNIQUE INDEX JGGZ.I_UNUSEDZFBH_STARTNO ON JGGZ.T_YZ_ZF_UNUSEDZFBH
5659 (STARTNO)
5660 LOGGING
5661 NOPARALLEL;
5662
5663
5664 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_XQBG ON JGGZ.T_YZ_ZF_XQBG
5665 (XQBG_NO)
5666 LOGGING
5667 NOPARALLEL;
5668
5669
5670 CREATE INDEX JGGZ.I_YZ_ZF_XQBG ON JGGZ.T_YZ_ZF_XQBG
5671 (ZF_ID, PJ_DATE, SJ_XQ, END_DATE, ZX_DATE,
5672 START_DATE)
5673 LOGGING
5674 NOPARALLEL;
5675
5676
5677 CREATE INDEX JGGZ.I_YZ_ZF_XQBG_1 ON JGGZ.T_YZ_ZF_XQBG
5678 (ZF_ID, DEL_FLAG)
5679 LOGGING
5680 NOPARALLEL;
5681
5682
5683 CREATE INDEX JGGZ.I_YZ_ZF_XQBG_2 ON JGGZ.T_YZ_ZF_XQBG
5684 (ZF_ID, BD_TYPE, DEL_FLAG)
5685 LOGGING
5686 NOPARALLEL;
5687
5688
5689 CREATE INDEX JGGZ.I_YZ_ZF_XQBG_3 ON JGGZ.T_YZ_ZF_XQBG
5690 (ZF_ID, ZX_DATE, PJ_DATE, DEL_FLAG)
5691 LOGGING
5692 NOPARALLEL;
5693
5694
5695 CREATE UNIQUE INDEX JGGZ.AK_KEY_1_T_YZ_ZF_ ON JGGZ.T_YZ_ZF_YJ
5696 (ID)
5697 LOGGING
5698 NOPARALLEL;
5699
5700
5701 CREATE INDEX JGGZ.I_T_YZ_ZF_ZDFL ON JGGZ.T_YZ_ZF_ZDFL
5702 (FA_ID, ZF_ID)
5703 LOGGING
5704 NOPARALLEL;
5705
5706
5707 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_ZDFL ON JGGZ.T_YZ_ZF_ZDFL
5708 (ID)
5709 LOGGING
5710 NOPARALLEL;
5711
5712
5713 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_ZFBHALLOCATED ON JGGZ.T_YZ_ZF_ZFBHALLOCATED
5714 (ID)
5715 LOGGING
5716 NOPARALLEL;
5717
5718
5719 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_ZK ON JGGZ.T_YZ_ZF_ZK
5720 (ZF_ID)
5721 LOGGING
5722 NOPARALLEL;
5723
5724
5725 CREATE INDEX JGGZ.I_YZ_ZF_ZK_1 ON JGGZ.T_YZ_ZF_ZK
5726 (ZF_ID, DEL_FLAG)
5727 LOGGING
5728 NOPARALLEL;
5729
5730
5731 CREATE INDEX JGGZ.I_YZ_ZF_ZK_2 ON JGGZ.T_YZ_ZF_ZK
5732 (ZF_ID, FG_LEVEL, DEL_FLAG)
5733 LOGGING
5734 NOPARALLEL;
5735
5736
5737 CREATE INDEX JGGZ.I_YZ_ZF_ZK_3 ON JGGZ.T_YZ_ZF_ZK
5738 (ZF_ID, YS_NO1, YS_NO2, DEL_FLAG)
5739 LOGGING
5740 NOPARALLEL;
5741
5742
5743 CREATE INDEX JGGZ.I_YZ_ZF_ZM ON JGGZ.T_YZ_ZF_ZM
5744 (ZF_ID, ZM_CODE)
5745 LOGGING
5746 NOPARALLEL;
5747
5748
5749 CREATE INDEX JGGZ.I_YZ_ZF_ZM_2 ON JGGZ.T_YZ_ZF_ZM
5750 (ZF_ID, ZM_CODE, DEL_FLAG)
5751 LOGGING
5752 NOPARALLEL;
5753
5754
5755 CREATE INDEX JGGZ.I_YZ_ZF_ZMBK_2 ON JGGZ.T_YZ_ZF_ZMBK
5756 (XQBGNO, XH)
5757 LOGGING
5758 NOPARALLEL;
5759
5760
5761 CREATE INDEX JGGZ.I_YZ_ZF_ZMBK_1 ON JGGZ.T_YZ_ZF_ZMBK
5762 (XQBGNO)
5763 LOGGING
5764 NOPARALLEL;
5765
5766
5767 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZF_ZMBK ON JGGZ.T_YZ_ZF_ZMBK
5768 (XQBGNO, ZF_ID, ZM)
5769 LOGGING
5770 NOPARALLEL;
5771
5772
5773 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZKBXDJ ON JGGZ.T_YZ_ZKBXDJ
5774 (ID)
5775 NOLOGGING
5776 NOPARALLEL;
5777
5778
5779 CREATE UNIQUE INDEX JGGZ.PK_T_YZ_ZKZFJB ON JGGZ.T_YZ_ZKZFJB
5780 (ID)
5781 NOLOGGING
5782 NOPARALLEL;
5783
5784
5785 CREATE INDEX JGGZ.I_YZ_ZKZFJB_1 ON JGGZ.T_YZ_ZKZFJB
5786 (ZF_ID, DEL_FLAG)
5787 LOGGING
5788 NOPARALLEL;
5789
5790
5791 CREATE UNIQUE INDEX JGGZ.PK_ZF_BH ON JGGZ.ZF_BH
5792 (ID)
5793 LOGGING
5794 NOPARALLEL;
5795
5796
5797 CREATE UNIQUE INDEX JGGZ.PK_ZF_FH ON JGGZ.ZF_FH
5798 (ID)
5799 LOGGING
5800 NOPARALLEL;
5801
5802
5803 ALTER TABLE JGGZ.T_JXJS_FY_JY_RELATION DROP PRIMARY KEY CASCADE;
5804 DROP TABLE JGGZ.T_JXJS_FY_JY_RELATION CASCADE CONSTRAINTS;
5805
5806 CREATE TABLE JGGZ.T_JXJS_FY_JY_RELATION
5807 (
5808 ID VARCHAR2(32 BYTE),
5809 FY_ID VARCHAR2(32 BYTE),
5810 JY_ID VARCHAR2(32 BYTE),
5811 CODE_TYPE_TABLE VARCHAR2(50 BYTE),
5812 TABLE_TYPE_TABLE VARCHAR2(50 BYTE),
5813 MEMO VARCHAR2(100 BYTE),
5814 XML_NAME VARCHAR2(32 BYTE)
5815 )
5816 LOGGING
5817 NOCACHE
5818 NOPARALLEL;
5819
5820
5821 DROP TABLE JGGZ.T_JY_FY_TABLE CASCADE CONSTRAINTS;
5822
5823 CREATE TABLE JGGZ.T_JY_FY_TABLE
5824 (
5825 ID VARCHAR2(32 BYTE) NOT NULL,
5826 TABLE_NAME VARCHAR2(500 BYTE),
5827 TABLE_COLUME VARCHAR2(500 BYTE),
5828 TABLE_COLUME_TYPE VARCHAR2(100 BYTE),
5829 IS_DISPLAY VARCHAR2(10 BYTE),
5830 TABLE_TYPE VARCHAR2(10 BYTE),
5831 TABLE_REALATION_TYPE VARCHAR2(10 BYTE),
5832 MEMO VARCHAR2(2000 BYTE),
5833 TABLE_COLUME_LENGTH VARCHAR2(10 BYTE),
5834 TABLE_COLUME_NAME VARCHAR2(100 BYTE)
5835 )
5836 LOGGING
5837 NOCACHE
5838 NOPARALLEL;
5839
5840
5841 DROP TABLE JGGZ.T_ZM_CODE_CHANGE CASCADE CONSTRAINTS;
5842
5843 CREATE TABLE JGGZ.T_ZM_CODE_CHANGE
5844 (
5845 JY_SM VARCHAR2(255 BYTE),
5846 JY_BM VARCHAR2(255 BYTE),
5847 FY_BM VARCHAR2(255 BYTE),
5848 FY_SM VARCHAR2(255 BYTE),
5849 T_FLAG VARCHAR2(10 BYTE),
5850 T_FY_JY_FLAG VARCHAR2(2 BYTE)
5851 )
5852 LOGGING
5853 NOCACHE
5854 NOPARALLEL;
5855
5856
5857 CREATE UNIQUE INDEX JGGZ.T_JXJS_RELATION_ID_PK ON JGGZ.T_JXJS_FY_JY_RELATION
5858 (ID)
5859 LOGGING
5860 NOPARALLEL;
5861
5862
5863 ALTER TABLE JGGZ.KBH_TEMP_TABLE ADD (
5864 CONSTRAINT PK_KBH_TEMP_TABLE PRIMARY KEY (KFH, FLAG));
5865
5866
5867 ALTER TABLE JGGZ.SYN_SQL ADD (
5868 CONSTRAINT PK_JGGZ_SYNC_SQL PRIMARY KEY (ID));
5869
5870
5871 ALTER TABLE JGGZ.T_JXJS_BM_BL ADD (
5872 CONSTRAINT T_JXJS_BM_BL_PK PRIMARY KEY (ID));
5873
5874
5875 ALTER TABLE JGGZ.T_JXJS_FY_BM ADD (
5876 CONSTRAINT T_PK_JXJS_FY_CODE PRIMARY KEY (ID));
5877
5878
5879 ALTER TABLE JGGZ.T_JXJS_JY_BM ADD (
5880 CONSTRAINT T_JXJS_JY_PK1_CODE PRIMARY KEY (ID));
5881
5882
5883 ALTER TABLE JGGZ.T_REPORT_DATA ADD (
5884 CONSTRAINT T_REPORT_DATA_PRIMARY_KEY PRIMARY KEY (ID));
5885
5886
5887 ALTER TABLE JGGZ.T_REPORT_PROCEDURE ADD (
5888 CONSTRAINT PK_REPORT_PROCEDURE_ID PRIMARY KEY (ID));
5889
5890
5891 ALTER TABLE JGGZ.T_SYS_JFKH_AUTOYJ ADD (
5892 CONSTRAINT PK_T_SYS_JFKH_AUTOYJ PRIMARY KEY (JYBM));
5893
5894
5895 ALTER TABLE JGGZ.T_YZ_AUTHORITY_TEST ADD (
5896 CONSTRAINT PK_T_YZ_AUTHORITY_TEST PRIMARY KEY (AUTH_ID));
5897
5898
5899 ALTER TABLE JGGZ.T_YZ_CXPT_DXKTJ ADD (
5900 CONSTRAINT PK_T_YZ_CXPT_DXKTJ PRIMARY KEY (MBTJ_ID));
5901
5902
5903 ALTER TABLE JGGZ.T_YZ_CXPT_FXKTJ ADD (
5904 CONSTRAINT PK_T_YZ_CXPT_FXKTJ PRIMARY KEY (MBTJ_ID));
5905
5906
5907 ALTER TABLE JGGZ.T_YZ_CXPT_MB ADD (
5908 CONSTRAINT PK_T_YZ_CXPT_MB PRIMARY KEY (MB_ID));
5909
5910
5911 ALTER TABLE JGGZ.T_YZ_CXPT_MBGL ADD (
5912 CONSTRAINT PK_T_YZ_CXPT_MBGL PRIMARY KEY (ID));
5913
5914
5915 ALTER TABLE JGGZ.T_YZ_CXPT_MBPX ADD (
5916 CONSTRAINT PK_T_YZ_CXPT_MBPX PRIMARY KEY (ID));
5917
5918
5919 ALTER TABLE JGGZ.T_YZ_CXPT_MBTJ ADD (
5920 CONSTRAINT PK_T_YZ_CXPT_MBTJ PRIMARY KEY (MBTJ_ID));
5921
5922
5923 ALTER TABLE JGGZ.T_YZ_CXPT_MBXGB ADD (
5924 CONSTRAINT PK_T_YZ_CXPT_MBXGB PRIMARY KEY (MBXGB_ID));
5925
5926
5927 ALTER TABLE JGGZ.T_YZ_CXPT_MBXSZD ADD (
5928 CONSTRAINT T_YZ_CXPT_MBXSZD_PK PRIMARY KEY (ID));
5929
5930
5931 ALTER TABLE JGGZ.T_YZ_CXPT_NOOUTLINKTAB ADD (
5932 CONSTRAINT PK_NOOUTLINKTAB_ID PRIMARY KEY (ID));
5933
5934
5935 ALTER TABLE JGGZ.T_YZ_CXPT_SYS_FIELD ADD (
5936 CONSTRAINT PK_T_YZ_CXPT_SYS_FIELD PRIMARY KEY (FIELD_ID));
5937
5938
5939 ALTER TABLE JGGZ.T_YZ_CXPT_SYS_TABLE ADD (
5940 CONSTRAINT PK_T_YZ_CXPT_SYS_TABLE PRIMARY KEY (TABLE_ID));
5941
5942
5943 ALTER TABLE JGGZ.T_YZ_CXPT_ZHXTJ ADD (
5944 CONSTRAINT PK_T_YZ_CXPT_ZHXTJ PRIMARY KEY (MBTJ_ID));
5945
5946
5947 ALTER TABLE JGGZ.T_YZ_DEPT_TEST ADD (
5948 CONSTRAINT PK_T_YZ_DEPT_TEST PRIMARY KEY (DEPT_ID));
5949
5950
5951 ALTER TABLE JGGZ.T_YZ_JFKH_DJG ADD (
5952 CONSTRAINT PK_T_YZ_JFKH_DJG PRIMARY KEY (ID));
5953
5954
5955 ALTER TABLE JGGZ.T_YZ_JFKH_FJCY_CONFIG ADD (
5956 PRIMARY KEY (JB));
5957
5958
5959 ALTER TABLE JGGZ.T_YZ_JFKH_LXFZ ADD (
5960 CONSTRAINT PK_T_YZ_JFKH_LXFZ PRIMARY KEY (ID));
5961
5962
5963 ALTER TABLE JGGZ.T_YZ_JFKH_REPORT_TEMP ADD (
5964 CONSTRAINT PK_T_YZ_JFKH_REPORT_TEMP PRIMARY KEY (SESSIONID, ZFID));
5965
5966
5967 ALTER TABLE JGGZ.T_YZ_JFKH_SCORE ADD (
5968 CONSTRAINT PK_T_YZ_JFKHSCORELOG PRIMARY KEY (ID));
5969
5970
5971 ALTER TABLE JGGZ.T_YZ_JFKH_SCORE_CLEAR ADD (
5972 CONSTRAINT PK_T_YZ_JFKHCLEARLOG PRIMARY KEY (ID));
5973
5974
5975 ALTER TABLE JGGZ.T_YZ_JFKH_SCORE_HISTORY ADD (
5976 CONSTRAINT PK_T_YZ_JFKH_SCORE_HISTORY PRIMARY KEY (ID));
5977
5978
5979 ALTER TABLE JGGZ.T_YZ_JFKH_SCORE_MONTH ADD (
5980 CONSTRAINT PK_T_YZ_JFKH_SCORE_MONTH PRIMARY KEY (ID));
5981
5982
5983 ALTER TABLE JGGZ.T_YZ_JFKH_SPJ ADD (
5984 CONSTRAINT PK_T_YZ_JFKHSPJ PRIMARY KEY (ID));
5985
5986
5987 ALTER TABLE JGGZ.T_YZ_JFKH_USER ADD (
5988 CONSTRAINT PK_T_YZ_JFKH_USER PRIMARY KEY (ID));
5989
5990
5991 ALTER TABLE JGGZ.T_YZ_JFKH_XBF ADD (
5992 CONSTRAINT PK_T_YZ_JFKH_XBF PRIMARY KEY (ID));
5993
5994
5995 ALTER TABLE JGGZ.T_YZ_JFKH_XBF_DEPT ADD (
5996 CONSTRAINT PK_T_YZ_JFKH_XBF_DEPT PRIMARY KEY (ID));
5997
5998
5999 ALTER TABLE JGGZ.T_YZ_JFKH_XBF_DETAIL ADD (
6000 CONSTRAINT PK_T_YZ_JFKH_XBF_DETAIL PRIMARY KEY (ID));
6001
6002
6003 ALTER TABLE JGGZ.T_YZ_JFKH_XBF_USER ADD (
6004 CONSTRAINT PK_T_YZ_JFKH_XBF_USER PRIMARY KEY (USERID));
6005
6006
6007 ALTER TABLE JGGZ.T_YZ_JFKH_XZ ADD (
6008 CONSTRAINT T_YZ_JFKHXZ_PK31079507316854 PRIMARY KEY (ID));
6009
6010
6011 ALTER TABLE JGGZ.T_YZ_JFKH_YJ_DEPT ADD (
6012 CONSTRAINT PK PRIMARY KEY (ID));
6013
6014
6015 ALTER TABLE JGGZ.T_YZ_JFKH_ZF ADD (
6016 CONSTRAINT PK_T_YZ_JFKH_ZF PRIMARY KEY (ID));
6017
6018
6019 ALTER TABLE JGGZ.T_YZ_JFKH_ZFLX ADD (
6020 CONSTRAINT PK_T_YZ_JFKH_ZFLX PRIMARY KEY (ID));
6021
6022
6023 ALTER TABLE JGGZ.T_YZ_JFKH_ZF_HISTORY ADD (
6024 CONSTRAINT PK_T_YZ_JFKH_ZF_HISTORY PRIMARY KEY (ZF_ID, YEAR, MONTH));
6025
6026
6027 ALTER TABLE JGGZ.T_YZ_LOGS ADD (
6028 CONSTRAINT PK_T_YZ_LOGS PRIMARY KEY (ID));
6029
6030
6031 ALTER TABLE JGGZ.T_YZ_MINGCE ADD (
6032 CONSTRAINT PK_T_YZ_MINGCE PRIMARY KEY (ID));
6033
6034
6035 ALTER TABLE JGGZ.T_YZ_PROM_INFO ADD (
6036 CONSTRAINT PK_T_YZ_PROM_INFO PRIMARY KEY (ID));
6037
6038
6039 ALTER TABLE JGGZ.T_YZ_RC_GZJS ADD (
6040 CONSTRAINT PK_T_YZ_RC_GZJS PRIMARY KEY (ID));
6041
6042
6043 ALTER TABLE JGGZ.T_YZ_RC_THDJ ADD (
6044 CONSTRAINT PK_T_YZ_RC_THDJ PRIMARY KEY (ID));
6045
6046
6047 ALTER TABLE JGGZ.T_YZ_ROLE_AUTHORITY_TEST ADD (
6048 CONSTRAINT PK_T_YZ_ROLE_AUTHORITY_TEST PRIMARY KEY (AUTH_ID, ROLE_ID));
6049
6050
6051 ALTER TABLE JGGZ.T_YZ_ROLE_TEST ADD (
6052 CONSTRAINT PK_T_YZ_ROLE_TEST PRIMARY KEY (ROLE_ID));
6053
6054
6055 ALTER TABLE JGGZ.T_YZ_SFWS ADD (
6056 CONSTRAINT PK_T_YZ_SFWS PRIMARY KEY (SFWSID));
6057
6058
6059 ALTER TABLE JGGZ.T_YZ_SFWSNO ADD (
6060 CONSTRAINT PK_T_YZ_SFWSNO PRIMARY KEY (ID));
6061
6062
6063 ALTER TABLE JGGZ.T_YZ_SFWS_MR ADD (
6064 CONSTRAINT PK_T_YZ_SFWS_MR PRIMARY KEY (ID));
6065
6066
6067 ALTER TABLE JGGZ.T_YZ_SWDJ ADD (
6068 CONSTRAINT PK_T_YZ_SWDJ PRIMARY KEY (ZF_ID));
6069
6070
6071 ALTER TABLE JGGZ.T_YZ_SWJD ADD (
6072 CONSTRAINT PK_T_YZ_SWJD PRIMARY KEY (ID));
6073
6074
6075 ALTER TABLE JGGZ.T_YZ_TAB_RELATION ADD (
6076 CONSTRAINT PK_T_YZ_TAB_RELATION PRIMARY KEY (TAB_ID));
6077
6078
6079 ALTER TABLE JGGZ.T_YZ_TGZF ADD (
6080 CONSTRAINT PK_T_YZ_TGZF PRIMARY KEY (ID));
6081
6082
6083 ALTER TABLE JGGZ.T_YZ_THJH ADD (
6084 CONSTRAINT PK_T_YZ_THJH PRIMARY KEY (ID));
6085
6086
6087 ALTER TABLE JGGZ.T_YZ_USER_TEST ADD (
6088 CONSTRAINT PK_T_YZ_USER_TEST PRIMARY KEY (USER_ID));
6089
6090
6091 ALTER TABLE JGGZ.T_YZ_WSSP ADD (
6092 CONSTRAINT PK_T_YZ_WSSP PRIMARY KEY (ID));
6093
6094
6095 ALTER TABLE JGGZ.T_YZ_WSSP_MR ADD (
6096 CONSTRAINT PK_T_YZ_WSSP_MR PRIMARY KEY (ID));
6097
6098
6099 ALTER TABLE JGGZ.T_YZ_XT_BM ADD (
6100 CONSTRAINT T_YZ_XT_BM_PK PRIMARY KEY (ID));
6101
6102
6103 ALTER TABLE JGGZ.T_YZ_XT_CHKITEMS ADD (
6104 CONSTRAINT PK_T_YZ_XT_CHKITEMS PRIMARY KEY (ID));
6105
6106
6107 ALTER TABLE JGGZ.T_YZ_XT_CHKMODUL ADD (
6108 CONSTRAINT PK_T_YZ_XT_CHECKMODUL PRIMARY KEY (ID));
6109
6110
6111 ALTER TABLE JGGZ.T_YZ_XT_DIMEN ADD (
6112 CONSTRAINT PK_T_YZ_XT_DIMEN PRIMARY KEY (ID));
6113
6114
6115 ALTER TABLE JGGZ.T_YZ_XT_DIMENMEMBER ADD (
6116 CONSTRAINT PK_T_YZ_XT_DIMENMEMBER PRIMARY KEY (ID));
6117
6118
6119 ALTER TABLE JGGZ.T_YZ_XT_DISDIMENMEMBER ADD (
6120 CONSTRAINT PK_T_YZ_XT_DISDIMENMEMBER PRIMARY KEY (ID));
6121
6122
6123 ALTER TABLE JGGZ.T_YZ_XT_DWTJ_CUBEDEFINE ADD (
6124 CONSTRAINT PK_T_YZ_XT_DWTJ_CUBEDEFINE PRIMARY KEY (ID));
6125
6126
6127 ALTER TABLE JGGZ.T_YZ_XT_EDITBM ADD (
6128 CONSTRAINT PK_BM_ID PRIMARY KEY (ID));
6129
6130
6131 ALTER TABLE JGGZ.T_YZ_XT_HOST ADD (
6132 CONSTRAINT T_YZ_XT_HOST_PK PRIMARY KEY (ID));
6133
6134
6135 ALTER TABLE JGGZ.T_YZ_XT_MRZ_USED ADD (
6136 CONSTRAINT PK_T_YZ_XT_MRZ_USED PRIMARY KEY (ZF_ID));
6137
6138
6139 ALTER TABLE JGGZ.T_YZ_XT_PARA ADD (
6140 CONSTRAINT PK_T_YZ_XT_PARA PRIMARY KEY (PARAID));
6141
6142
6143 ALTER TABLE JGGZ.T_YZ_XT_QUERYCONFIG ADD (
6144 CONSTRAINT PK_T_YZ_XT_QUERYCONFIG PRIMARY KEY (ID));
6145
6146
6147 ALTER TABLE JGGZ.T_YZ_XT_SEQDIMENMEMBER ADD (
6148 CONSTRAINT PK_T_YZ_XT_SEQDIMENMEMBER PRIMARY KEY (ID));
6149
6150
6151 ALTER TABLE JGGZ.T_YZ_XT_WEB_POPEDOM ADD (
6152 CONSTRAINT PK_T_YZ_XT_WEB_POPEDOM PRIMARY KEY (ID));
6153
6154
6155 ALTER TABLE JGGZ.T_YZ_ZFKG ADD (
6156 CONSTRAINT PK_T_YZ_ZFKG PRIMARY KEY (ID));
6157
6158
6159 ALTER TABLE JGGZ.T_YZ_ZFKG_MB ADD (
6160 CONSTRAINT PK_T_YZ_ZFKG_MB PRIMARY KEY (KG_ID));
6161
6162
6163 ALTER TABLE JGGZ.T_YZ_ZFLJ ADD (
6164 CONSTRAINT PK_T_YZ_ZFLJ PRIMARY KEY (ID));
6165
6166
6167 ALTER TABLE JGGZ.T_YZ_ZFSS ADD (
6168 CONSTRAINT PK_T_YZ_ZFSS PRIMARY KEY (ID));
6169
6170
6171 ALTER TABLE JGGZ.T_YZ_ZFSSXX ADD (
6172 CONSTRAINT PK_T_YZ_ZFSSXX PRIMARY KEY (ID));
6173
6174
6175 ALTER TABLE JGGZ.T_YZ_ZF_BSJ ADD (
6176 CONSTRAINT PK_T_YZ_ZF_BSJ PRIMARY KEY (BSJ_NO));
6177
6178
6179 ALTER TABLE JGGZ.T_YZ_ZF_BWXB ADD (
6180 CONSTRAINT PK_T_YZ_ZF_BWXB PRIMARY KEY (ID));
6181
6182
6183 ALTER TABLE JGGZ.T_YZ_ZF_CRJ_INFO ADD (
6184 CONSTRAINT PK_T_YZ_CRJ_INFO PRIMARY KEY (ID));
6185
6186
6187 ALTER TABLE JGGZ.T_YZ_ZF_DBDD ADD (
6188 CONSTRAINT PK_T_YZ_ZF_DBDD PRIMARY KEY (ID));
6189
6190
6191 ALTER TABLE JGGZ.T_YZ_ZF_DSJ ADD (
6192 CONSTRAINT PK_T_YZ_ZF_DSJ PRIMARY KEY (ID));
6193
6194
6195 ALTER TABLE JGGZ.T_YZ_ZF_FGDJ ADD (
6196 CONSTRAINT PK_T_YZ_ZF_FGDJ PRIMARY KEY (ID));
6197
6198
6199 ALTER TABLE JGGZ.T_YZ_ZF_FK ADD (
6200 CONSTRAINT PK_T_YZ_ZF_FK PRIMARY KEY (ZF_ID));
6201
6202
6203 ALTER TABLE JGGZ.T_YZ_ZF_FLFA ADD (
6204 CONSTRAINT PK_T_YZ_ZF_FLFA PRIMARY KEY (PLAN_NO));
6205
6206
6207 ALTER TABLE JGGZ.T_YZ_ZF_FLFAMC ADD (
6208 CONSTRAINT PK_T_YZ_ZF_FLFAMC PRIMARY KEY (ZF_ID));
6209
6210
6211 ALTER TABLE JGGZ.T_YZ_ZF_FLSZ ADD (
6212 CONSTRAINT PK_T_YZ_ZF_FLSZ PRIMARY KEY (ID));
6213
6214
6215 ALTER TABLE JGGZ.T_YZ_ZF_FLTJ ADD (
6216 CONSTRAINT PK_T_YZ_ZF_FLTJ PRIMARY KEY (ID));
6217
6218
6219 ALTER TABLE JGGZ.T_YZ_ZF_HBKC ADD (
6220 CONSTRAINT PK_T_YZ_ZF_HBKC PRIMARY KEY (ID));
6221
6222
6223 ALTER TABLE JGGZ.T_YZ_ZF_JK ADD (
6224 CONSTRAINT PK_T_YZ_ZF_JK PRIMARY KEY (ZF_ID));
6225
6226
6227 ALTER TABLE JGGZ.T_YZ_ZF_JL ADD (
6228 CONSTRAINT PK_T_YZ_ZF_JL PRIMARY KEY (ID));
6229
6230
6231 ALTER TABLE JGGZ.T_YZ_ZF_JLXX ADD (
6232 CONSTRAINT PK_T_YZ_ZF_JLXX PRIMARY KEY (JL_NO));
6233
6234
6235 ALTER TABLE JGGZ.T_YZ_ZF_JWBW ADD (
6236 CONSTRAINT PK_T_YZ_ZF_JWBW PRIMARY KEY (ID));
6237
6238
6239 ALTER TABLE JGGZ.T_YZ_ZF_LBC ADD (
6240 CONSTRAINT PK_T_YZ_ZF_LBC PRIMARY KEY (LBC_NO));
6241
6242
6243 ALTER TABLE JGGZ.T_YZ_ZF_LBC_FS ADD (
6244 CONSTRAINT PK_T_YZ_ZF_LBC_FS PRIMARY KEY (ID));
6245
6246
6247 ALTER TABLE JGGZ.T_YZ_ZF_MTXX ADD (
6248 CONSTRAINT PK_T_YZ_ZF_MTXX PRIMARY KEY (MT_NO));
6249
6250
6251 ALTER TABLE JGGZ.T_YZ_ZF_MTXX_LOG ADD (
6252 CONSTRAINT PK_T_YZ_ZF_MTXX_LOG PRIMARY KEY (ID));
6253
6254
6255 ALTER TABLE JGGZ.T_YZ_ZF_NFL ADD (
6256 CONSTRAINT PK_T_YZ_ZF_NFL PRIMARY KEY (PLAN_NO, JSDWID));
6257
6258
6259 ALTER TABLE JGGZ.T_YZ_ZF_NFL_TJ ADD (
6260 CONSTRAINT PK_T_YZ_ZF_NFL_TJ PRIMARY KEY (ID));
6261
6262
6263 ALTER TABLE JGGZ.T_YZ_ZF_NWFG ADD (
6264 CONSTRAINT PK_T_YZ_ZF_NWFG PRIMARY KEY (ID));
6265
6266
6267 ALTER TABLE JGGZ.T_YZ_ZF_QJFJ ADD (
6268 CONSTRAINT PK_T_YZ_ZF_QJFJ PRIMARY KEY (ID));
6269
6270
6271 ALTER TABLE JGGZ.T_YZ_ZF_SFZF ADD (
6272 CONSTRAINT PK_T_YZ_ZF_SF PRIMARY KEY (ID));
6273
6274
6275 ALTER TABLE JGGZ.T_YZ_ZF_SHGX ADD (
6276 CONSTRAINT PK_T_YZ_ZF_SHGX PRIMARY KEY (SHGX_NO));
6277
6278
6279 ALTER TABLE JGGZ.T_YZ_ZF_SJZF ADD (
6280 CONSTRAINT PK_T_YZ_ZF_SJ PRIMARY KEY (ID));
6281
6282
6283 ALTER TABLE JGGZ.T_YZ_ZF_SS ADD (
6284 CONSTRAINT PK_T_YZ_ZF_SS PRIMARY KEY (SS_NO));
6285
6286
6287 ALTER TABLE JGGZ.T_YZ_ZF_TAF ADD (
6288 CONSTRAINT PK_T_YZ_ZF_TAF PRIMARY KEY (TAF_NO));
6289
6290
6291 ALTER TABLE JGGZ.T_YZ_ZF_TC ADD (
6292 CONSTRAINT PK_T_YZ_ZF_TC PRIMARY KEY (ZF_ID, TC));
6293
6294
6295 ALTER TABLE JGGZ.T_YZ_ZF_TGSK ADD (
6296 CONSTRAINT PK_T_YZ_ZF_TGSK PRIMARY KEY (ID));
6297
6298
6299 ALTER TABLE JGGZ.T_YZ_ZF_TMTZ ADD (
6300 CONSTRAINT PK_T_YZ_ZF_TMTZ PRIMARY KEY (ZF_ID));
6301
6302
6303 ALTER TABLE JGGZ.T_YZ_ZF_TT ADD (
6304 CONSTRAINT PK_T_YZ_ZF_TT PRIMARY KEY (ID));
6305
6306
6307 ALTER TABLE JGGZ.T_YZ_ZF_UNUSEDZFBH ADD (
6308 CONSTRAINT PK_T_YZ_ZF_UNUSEDZFBH PRIMARY KEY (ID));
6309
6310
6311 ALTER TABLE JGGZ.T_YZ_ZF_XQBG ADD (
6312 CONSTRAINT PK_T_YZ_ZF_XQBG PRIMARY KEY (XQBG_NO));
6313
6314
6315 ALTER TABLE JGGZ.T_YZ_ZF_YJ ADD (
6316 CONSTRAINT AK_KEY_1_T_YZ_ZF_ PRIMARY KEY (ID));
6317
6318
6319 ALTER TABLE JGGZ.T_YZ_ZF_ZDFL ADD (
6320 CONSTRAINT PK_T_YZ_ZF_ZDFL PRIMARY KEY (ID));
6321
6322
6323 ALTER TABLE JGGZ.T_YZ_ZF_ZFBHALLOCATED ADD (
6324 CONSTRAINT PK_T_YZ_ZF_ZFBHALLOCATED PRIMARY KEY (ID));
6325
6326
6327 ALTER TABLE JGGZ.T_YZ_ZF_ZK ADD (
6328 CONSTRAINT PK_T_YZ_ZF_ZK PRIMARY KEY (ZF_ID));
6329
6330
6331 ALTER TABLE JGGZ.T_YZ_ZF_ZM ADD (
6332 CONSTRAINT PK_T_YZ_ZF_ZM PRIMARY KEY (ZF_ID, ZM_CODE));
6333
6334
6335 ALTER TABLE JGGZ.T_YZ_ZF_ZMBK ADD (
6336 CONSTRAINT PK_T_YZ_ZF_ZMBK PRIMARY KEY (XQBGNO, ZF_ID, ZM));
6337
6338
6339 ALTER TABLE JGGZ.T_YZ_ZKBXDJ ADD (
6340 CONSTRAINT PK_T_YZ_ZKBXDJ PRIMARY KEY (ID));
6341
6342
6343 ALTER TABLE JGGZ.T_YZ_ZKZFJB ADD (
6344 CONSTRAINT PK_T_YZ_ZKZFJB PRIMARY KEY (ID));
6345
6346
6347 ALTER TABLE JGGZ.ZF_BH ADD (
6348 CONSTRAINT PK_ZF_BH PRIMARY KEY (ID));
6349
6350
6351 ALTER TABLE JGGZ.ZF_FH ADD (
6352 CONSTRAINT PK_ZF_FH PRIMARY KEY (ID));
6353
6354
6355 ALTER TABLE JGGZ.ZHL_T_SYS_USER_TMP ADD (
6356 CONSTRAINT PK_ZHL_T_SYS_USER_TMP PRIMARY KEY (USER_ID) DISABLE);
6357
6358
6359 ALTER TABLE JGGZ.T_JXJS_FY_JY_RELATION ADD (
6360 CONSTRAINT T_JXJS_RELATION_ID_PK PRIMARY KEY (ID));
6361
6362
6363 ALTER TABLE JGGZ.T_JXJS_JY_BM ADD (
6364 CONSTRAINT T_JXJS_JY_FK FOREIGN KEY (BM_ID)
6365 REFERENCES JGGZ.T_JXJS_BM_BL (ID));
6366
6367
6368 ALTER TABLE JGGZ.T_JXJS_FY_JY_RELATION ADD (
6369 CONSTRAINT T_JXJS_RELAGION_FY_FK FOREIGN KEY (FY_ID)
6370 REFERENCES JGGZ.T_JXJS_FY_BM (ID));
6371
6372 ALTER TABLE JGGZ.T_JXJS_FY_JY_RELATION ADD (
6373 CONSTRAINT T_JXJS_RELAGION_JY_FK FOREIGN KEY (JY_ID)
6374 REFERENCES JGGZ.T_JXJS_JY_BM (ID));
6375
6376
6377 ALTER TABLE JGGZ.T_JY_FY_TABLE ADD (
6378 CONSTRAINT T_JY_FY_FK FOREIGN KEY (TABLE_REALATION_TYPE)
6379 REFERENCES JGGZ.T_JXJS_FY_JY_RELATION (ID));
6380
6381
6382 ALTER TABLE JGGZ.T_ZM_CODE_CHANGE ADD (
6383 CONSTRAINT T_ZM_CODE_CHANGE_FK FOREIGN KEY (T_FY_JY_FLAG)
6384 REFERENCES JGGZ.T_JXJS_FY_JY_RELATION (ID));
Attached Files
To refer to attachments on a page, use attachment:filename, as shown below in the list of files. Do NOT use the URL of the [get] link, since this is subject to change and can break easily.You are not allowed to attach a file to this page.