📄 pc-new.sql
字号:
ALTER TABLE T_FSGH ADD (CONSTRAINT T_FSGH_PK
PRIMARY KEY (FSXH));
CREATE TABLE T_FSPDYSSJ(
ZJFS NUMBER(10) NOT NULL,
LSZJFS NUMBER(10) ,
ZFJBH VARCHAR2(8) NOT NULL,
FSXH NUMBER(10) NOT NULL);
CREATE UNIQUE INDEX T_FSPDYSSJ_PK ON T_FSPDYSSJ(ZFJBH,FSXH);
ALTER TABLE T_FSPDYSSJ ADD (CONSTRAINT T_FSPDYSSJ_PK
PRIMARY KEY (ZFJBH,FSXH));
CREATE TABLE T_FSPDYSSM(
BKDH VARCHAR2(7) NOT NULL,
YSLX CHARACTER(1) NOT NULL,
WJBH VARCHAR2(2) NOT NULL,
QDQA NUMBER(2) NOT NULL,
QDQB NUMBER(2),
ZDQA NUMBER(2) ,
ZDQB NUMBER(2),
KQ VARCHAR2(6) ,
DINGJ NUMBER(6,2) ,
DYZS NUMBER(10) ,
DYK NUMBER(11,2) ,
LSZS NUMBER(10) ,
LSK NUMBER(11,2) ,
NF NUMBER(4) NOT NULL,
FSXH NUMBER(10) NOT NULL);
CREATE UNIQUE INDEX T_FSPDYSSM_PK ON T_FSPDYSSM(FSXH);
ALTER TABLE T_FSPDYSSM ADD (CONSTRAINT T_FSPDYSSM_PK
PRIMARY KEY (FSXH));
CREATE TABLE T_FSRZ(
FSXH NUMBER(10) NOT NULL,
SJFL CHARACTER(1) NOT NULL,
SJZT CHARACTER(1) NOT NULL,
JSSJ DATE NOT NULL);
CREATE UNIQUE INDEX T_FSRZ_PK ON T_FSRZ(FSXH);
ALTER TABLE T_FSRZ ADD (CONSTRAINT T_FSRZ_PK
PRIMARY KEY (FSXH));
CREATE TABLE T_FSTJBB(
BBBH VARCHAR2(2) NOT NULL,
NF NUMBER(4) ,
YF NUMBER(2) ,
BBNR LONG NOT NULL,
FSXH NUMBER(10) NOT NULL);
CREATE UNIQUE INDEX T_FSTJBB_PK ON T_FSTJBB(FSXH);
ALTER TABLE T_FSTJBB ADD (CONSTRAINT T_FSTJBB_PK
PRIMARY KEY (FSXH));
CREATE TABLE T_FSYXSJ(
YXXL VARCHAR2(3) NOT NULL,
WJBH VARCHAR2(2) NOT NULL,
FSXH NUMBER(10) NOT NULL);
CREATE UNIQUE INDEX T_FSYXSJ_PK ON T_FSYXSJ(FSXH);
ALTER TABLE T_FSYXSJ ADD (CONSTRAINT T_FSYXSJ_PK
PRIMARY KEY (FSXH));
CREATE TABLE T_FSZDYSSJ(
YFFS NUMBER(10) NOT NULL,
QZLSS NUMBER(10) ,
ZFJBH VARCHAR2(8) NOT NULL,
FSXH NUMBER(10) NOT NULL);
CREATE UNIQUE INDEX T_FSZDYSSJ_PK ON T_FSZDYSSJ(ZFJBH,FSXH);
ALTER TABLE T_FSZDYSSJ ADD (CONSTRAINT T_FSZDYSSJ_PK
PRIMARY KEY (ZFJBH,FSXH));
CREATE TABLE T_FSZDYSSM(
BKDH VARCHAR2(7) NOT NULL,
YSLX CHARACTER(1) NOT NULL,
WJBH VARCHAR2(2) NOT NULL,
QDQA NUMBER(2) NOT NULL,
KQ VARCHAR2(6) ,
DINGJ NUMBER(6,2) ,
DYZS NUMBER(10) ,
DYK NUMBER(11,2) ,
LSZS NUMBER(10) ,
LSK NUMBER(11,2) ,
NF NUMBER(4) NOT NULL,
FSXH NUMBER(10) NOT NULL);
CREATE UNIQUE INDEX T_FSZDYSSM_PK ON T_FSZDYSSM(FSXH);
ALTER TABLE T_FSZDYSSM ADD (CONSTRAINT T_FSZDYSSM_PK
PRIMARY KEY (FSXH));
CREATE TABLE T_FSZFJB(
NF NUMBER(4) NOT NULL,
FSXH NUMBER(10) NOT NULL);
CREATE UNIQUE INDEX T_FSZFJB_PK ON T_FSZFJB(FSXH);
ALTER TABLE T_FSZFJB ADD (CONSTRAINT T_FSZFJB_PK
PRIMARY KEY (FSXH));
CREATE TABLE T_FSZFJBNR(
SJBH VARCHAR2(2) NOT NULL,
ZFJBH VARCHAR2(8) NOT NULL,
ZFJMC VARCHAR2(16) ,
FSXH NUMBER(10) NOT NULL,
ZFJXH NUMBER(10) NOT NULL);
CREATE UNIQUE INDEX T_FSZFJBNR_PK ON T_FSZFJBNR(SJBH,ZFJBH,FSXH);
ALTER TABLE T_FSZFJBNR ADD (CONSTRAINT T_FSZFJBNR_PK
PRIMARY KEY (SJBH,ZFJBH,FSXH));
CREATE TABLE T_HZ(
HZJSSJ DATE NOT NULL,
SJBH VARCHAR2(2) NOT NULL,
HZZT CHARACTER(1) NOT NULL,
FSXH NUMBER(10) NOT NULL,
BZ VARCHAR2(30),
PC NUMBER(5) NOT NULL);
CREATE UNIQUE INDEX T_HZ_PK ON T_HZ(SJBH,FSXH);
ALTER TABLE T_HZ ADD (CONSTRAINT T_HZ_PK
PRIMARY KEY (SJBH,FSXH));
CREATE TABLE T_JSBKHZML(
NF NUMBER(4) NOT NULL,
SJBH VARCHAR2(2) NOT NULL,
JSXH NUMBER(10) NOT NULL);
CREATE UNIQUE INDEX T_JSBKHZML_PK ON T_JSBKHZML(SJBH,JSXH);
ALTER TABLE T_JSBKHZML ADD (CONSTRAINT T_JSBKHZML_PK
PRIMARY KEY (SJBH,JSXH));
CREATE TABLE T_JSBKHZMLNR(
BKDH VARCHAR2(7) NOT NULL,
BKMC VARCHAR2(40) ,
FBKJMC VARCHAR2(16) ,
CBRQ VARCHAR2(10) ,
DANJ NUMBER(6,2) ,
YJ DECIMAL(6,2) ,
JJ DECIMAL(6,2) ,
BNJ DECIMAL(7,2) ,
NJ DECIMAL(7,2) ,
HZDDJDRQ VARCHAR2(24) ,
FXFW VARCHAR2(4) ,
KQ VARCHAR2(6) ,
TYKH VARCHAR2(12) ,
JB VARCHAR2(6) ,
PC NUMBER(2) ,
KZ NUMBER(2) ,
BYM NUMBER(4) ,
XYF CHARACTER(1) ,
BBDYFL NUMBER(5,2),
WBDYFL NUMBER(5,2),
BBLSFL NUMBER(5,2),
WBLSFL NUMBER(5,2),
BZ VARCHAR2(160),
SJBH VARCHAR2(2) NOT NULL,
JSXH NUMBER(10) NOT NULL);
CREATE UNIQUE INDEX T_JSBKHZMLNR_PK ON T_JSBKHZMLNR(BKDH,SJBH,JSXH);
ALTER TABLE T_JSBKHZMLNR ADD (CONSTRAINT T_JSBKHZMLNR_PK
PRIMARY KEY (BKDH,SJBH,JSXH));
CREATE TABLE T_JSGH(
GHBH VARCHAR2(3) NOT NULL,
GHXL VARCHAR2(2) NOT NULL,
GHNR LONG NOT NULL,
SJBH VARCHAR2(2) NOT NULL,
JSXH NUMBER(10) NOT NULL);
CREATE UNIQUE INDEX T_JSGH_PK ON T_JSGH(SJBH,JSXH);
ALTER TABLE T_JSGH ADD (CONSTRAINT T_JSGH_PK
PRIMARY KEY (SJBH,JSXH));
CREATE TABLE T_JSPDYSSJ(
ZJFS NUMBER(10) NOT NULL,
LSZJFS NUMBER(10) ,
ZFJBH VARCHAR2(8) NOT NULL,
SJBH VARCHAR2(2) NOT NULL,
JSXH NUMBER(10) NOT NULL);
CREATE UNIQUE INDEX T_JSPDYSSJ_PK ON T_JSPDYSSJ(ZFJBH,SJBH,JSXH);
ALTER TABLE T_JSPDYSSJ ADD (CONSTRAINT T_JSPDYSSJ_PK
PRIMARY KEY (ZFJBH,SJBH,JSXH));
CREATE TABLE T_JSPDYSSM(
BKDH VARCHAR2(7) NOT NULL,
YSLX CHARACTER(1) NOT NULL,
WJBH VARCHAR2(2) NOT NULL,
QDQA NUMBER(2) NOT NULL,
QDQB NUMBER(2),
ZDQA NUMBER(2) ,
ZDQB NUMBER(2),
KQ VARCHAR2(6) ,
DINGJ NUMBER(6,2) ,
DYZS NUMBER(10) ,
DYK NUMBER(11,2) ,
LSZS NUMBER(10) ,
LSK NUMBER(11,2) ,
SJBH VARCHAR2(2) NOT NULL,
YXNF NUMBER(4) NOT NULL,
JSXH NUMBER(10) NOT NULL);
CREATE UNIQUE INDEX T_JSPDYSSM_PK ON T_JSPDYSSM(SJBH,JSXH);
ALTER TABLE T_JSPDYSSM ADD (CONSTRAINT T_JSPDYSSM_PK
PRIMARY KEY (SJBH,JSXH));
CREATE TABLE T_JSRZ(
JSXH NUMBER(10) NOT NULL,
SJFL CHARACTER(1) NOT NULL,
SJZT CHARACTER(1) NOT NULL,
SJBH VARCHAR2(2) NOT NULL,
JSSJ DATE NOT NULL);
CREATE UNIQUE INDEX T_JSRZ_PK ON T_JSRZ(JSXH,SJBH);
ALTER TABLE T_JSRZ ADD (CONSTRAINT T_JSRZ_PK
PRIMARY KEY (JSXH,SJBH));
CREATE TABLE T_JSYXSJ(
YXXL VARCHAR2(3) NOT NULL,
WJBH VARCHAR2(2) NOT NULL,
JSXH NUMBER(10) NOT NULL,
SJBH VARCHAR2(2) NOT NULL);
CREATE UNIQUE INDEX T_JSYXSJ_PK ON T_JSYXSJ(JSXH,SJBH);
ALTER TABLE T_JSYXSJ ADD (CONSTRAINT T_JSYXSJ_PK
PRIMARY KEY (JSXH,SJBH));
CREATE TABLE T_JSZDYSSJ(
YFFS NUMBER(10) NOT NULL,
QZLSS NUMBER(10) ,
ZFJBH VARCHAR2(8) NOT NULL,
SJBH VARCHAR2(2) NOT NULL,
JSXH NUMBER(10) NOT NULL);
CREATE UNIQUE INDEX T_JSZDYSSJ_PK ON T_JSZDYSSJ(ZFJBH,SJBH,JSXH);
ALTER TABLE T_JSZDYSSJ ADD (CONSTRAINT T_JSZDYSSJ_PK
PRIMARY KEY (ZFJBH,SJBH,JSXH));
CREATE TABLE T_JSZDYSSM(
YSLX CHARACTER(1) NOT NULL,
WJBH VARCHAR2(2) NOT NULL,
QDQA NUMBER(2) NOT NULL,
KQ VARCHAR2(6) ,
DINGJ NUMBER(6,2) ,
DYZS NUMBER(10) ,
DYK NUMBER(11,2) ,
LSZS NUMBER(10) ,
LSK NUMBER(11,2) ,
SJBH VARCHAR2(2) NOT NULL,
BKDH VARCHAR2(7) NOT NULL,
YXNF NUMBER(4) NOT NULL,
JSXH NUMBER(10) NOT NULL);
CREATE UNIQUE INDEX T_JSZDYSSM_PK ON T_JSZDYSSM(SJBH,JSXH);
ALTER TABLE T_JSZDYSSM ADD (CONSTRAINT T_JSZDYSSM_PK
PRIMARY KEY (SJBH,JSXH));
CREATE TABLE T_JSZFJB(
NF NUMBER(4) NOT NULL,
SJBH VARCHAR2(2) NOT NULL,
JSXH NUMBER(10) NOT NULL);
CREATE UNIQUE INDEX T_JSZFJB_PK ON T_JSZFJB(SJBH,JSXH);
ALTER TABLE T_JSZFJB ADD (CONSTRAINT T_JSZFJB_PK
PRIMARY KEY (SJBH,JSXH));
CREATE TABLE T_JSZFJBNR(
SJBH VARCHAR2(2) NOT NULL,
ZFJBH VARCHAR2(8) NOT NULL,
ZFJMC VARCHAR2(16) ,
JSXH NUMBER(10) NOT NULL,
ZFJXH NUMBER(10) NOT NULL);
CREATE UNIQUE INDEX T_JSZFJBNR_PK ON T_JSZFJBNR(SJBH,ZFJBH,JSXH);
ALTER TABLE T_JSZFJBNR ADD (CONSTRAINT T_JSZFJBNR_PK
PRIMARY KEY (SJBH,ZFJBH,JSXH));
CREATE TABLE T_SJBH(
SJBH VARCHAR2(2) NOT NULL,
SJMC VARCHAR2(8) NOT NULL);
CREATE UNIQUE INDEX T_SJBH_PK ON T_SJBH(SJBH);
ALTER TABLE T_SJBH ADD (CONSTRAINT T_SJBH_PK
PRIMARY KEY (SJBH));
CREATE TABLE T_SNML(
BKDH VARCHAR2(7) NOT NULL,
YXNF NUMBER(4) NOT NULL,
BKMC VARCHAR2(40) NOT NULL);
CREATE UNIQUE INDEX T_SNML_PK ON T_SNML(BKDH,YXNF);
ALTER TABLE T_SNML ADD (CONSTRAINT T_SNML_PK
PRIMARY KEY (BKDH,YXNF));
CREATE TABLE T_SNMLFB(
BKDH VARCHAR2(7) NOT NULL,
SJBH VARCHAR2(2) NOT NULL,
YXNF NUMBER(4) NOT NULL,
FBKJBH VARCHAR2(2) NOT NULL);
CREATE UNIQUE INDEX T_SNMLFB_PK ON T_SNMLFB(BKDH,SJBH,YXNF);
ALTER TABLE T_SNMLFB ADD (CONSTRAINT T_SNMLFB_PK
PRIMARY KEY (BKDH,SJBH,YXNF));
CREATE TABLE T_ZCFSSJ(
ZH NUMBER(4) NOT NULL,
ZZH NUMBER(4) NOT NULL,
FSXH NUMBER(10) NOT NULL,
ZCFSSJ LONG NOT NULL);
CREATE UNIQUE INDEX T_ZCFSSJ_PK ON T_ZCFSSJ(ZH,FSXH);
ALTER TABLE T_ZCFSSJ ADD (CONSTRAINT T_ZCFSSJ_PK
PRIMARY KEY (ZH,FSXH));
CREATE TABLE T_ZCJSSJ(
ZH NUMBER(4) NOT NULL,
ZZH NUMBER(4) NOT NULL,
SJBH VARCHAR2(2) NOT NULL,
JSXH NUMBER(10) NOT NULL,
ZCJSSJ LONG NOT NULL);
CREATE UNIQUE INDEX T_ZCJSSJ_PK ON T_ZCJSSJ(ZH,SJBH,JSXH);
ALTER TABLE T_ZCJSSJ ADD (CONSTRAINT T_ZCJSSJ_PK
PRIMARY KEY (ZH,SJBH,JSXH));
CREATE TABLE T_ZFJ(
ZFJBH VARCHAR2(8) NOT NULL,
YXNF NUMBER(4) NOT NULL,
SJBH VARCHAR2(2) NOT NULL,
ZFJMC VARCHAR2(16),
ZFJXH NUMBER(10) NOT NULL);
create view v_fszdyssm as
select t_fszdyssm.*,t_fsrz.jssj,t_fsrz.sjzt,t_hz.sjbh
from t_fszdyssm,t_fsrz,t_hz
where t_fszdyssm.fsxh=t_fsrz.fsxh and t_fsrz.fsxh=t_hz.fsxh;
create view v_fsbkjhml as
select distinct(t_fsbkjhml.fsxh),t_fsbkjhml.nf,t_fsrz.jssj,t_fsrz.sjzt,t_hz.sjbh
from t_fsbkjhml,t_fsbkjhmlnr,t_fsrz,t_hz
where t_fsbkjhml.fsxh=t_fsbkjhmlnr.fsxh and t_fsbkjhml.fsxh=t_fsrz.fsxh and t_fsrz.fsxh=t_hz.fsxh;
create view v_fsyxsj as
select t_fsyxsj.*,t_fsrz.jssj,t_fsrz.sjzt,t_hz.sjbh
from t_fsyxsj,t_fsrz,t_hz
where t_fsyxsj.fsxh=t_fsrz.fsxh and t_fsrz.fsxh=t_hz.fsxh;
create view v_fsbsfxml as
select distinct(t_fsbsfxml.fsxh),t_fsbsfxml.nf,t_fsrz.jssj,t_fsrz.sjzt,t_hz.sjbh
from t_fsbsfxml,t_fsbsfxmlnr,t_fsrz,t_hz
where t_fsbsfxml.fsxh=t_fsrz.fsxh and t_fsbsfxmlnr.fsxh=t_fsrz.fsxh and t_fsrz.fsxh=t_hz.fsxh;
create view v_fstjbb as
select t_fstjbb.*,t_fsrz.jssj,t_fsrz.sjzt,t_hz.sjbh
from t_fstjbb,t_fsrz,t_hz
where t_fstjbb.fsxh=t_fsrz.fsxh and t_fsrz.fsxh=t_hz.fsxh;
create view v_fsgh as
select t_fsgh.*,t_fsrz.jssj,t_fsrz.sjzt,t_hz.sjbh
from t_fsgh,t_fsrz,t_hz
where t_fsgh.fsxh=t_fsrz.fsxh and t_fsrz.fsxh=t_hz.fsxh;
create view v_fszfjb as
select t_fszfjb.nf,t_fszfjbnr.*,t_fsrz.jssj,t_fsrz.sjzt
from t_fszfjb,t_fszfjbnr,t_fsrz,t_hz
where t_fszfjb.fsxh=t_fszfjbnr.fsxh and t_fszfjb.fsxh=t_fsrz.fsxh and t_fsrz.fsxh=t_hz.fsxh;
create view v_fspdyssm as
select t_fspdyssm.*,t_fsrz.jssj,t_fsrz.sjzt,t_hz.sjbh
from t_fspdyssm,t_fsrz,t_hz
where t_fspdyssm.fsxh=t_fsrz.fsxh and t_fsrz.fsxh=t_hz.fsxh;
create view v_fsghcx as
select t_fsgh.*,t_fsrz.jssj,t_hz.sjbh
from t_fsgh,t_fsrz,t_hz
where t_fsgh.fsxh=t_fsrz.fsxh and t_fsrz.fsxh=t_hz.fsxh;
create view v_jsghcx as
select t_jsgh.*,t_jsrz.jssj
from t_jsgh,t_jsrz
where t_jsgh.jsxh=t_jsrz.jsxh ;
create view v_checkjsfszd as
select t_jsrz.jsxh from t_fbkj,t_snmlfb,t_jszdyssm,t_jsrz
where t_jsrz.sjzt='2' and (t_fbkj.jsfs='2' or t_fbkj.jsfs='3')
and t_jszdyssm.bkdh=t_snmlfb.bkdh and t_jszdyssm.jsxh=t_jsrz.jsxh
and t_snmlfb.fbkjbh=t_fbkj.fbkjbh;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -