📄 gd.sql
字号:
create table TGD_ASSETSORIGIN
(
CCODE CHAR(20) not null,
VCNAME VARCHAR2(30) not null
)
tablespace CW_TS
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 10K
next 10K
minextents 1
maxextents 121
pctincrease 0
);
create table TGD_BALANCE<<YEAR>>
(
KPBH CHAR(25) not null,
LJJYZ00 NUMBER(15,2) default 0,
LJDYZ00 NUMBER(15,2) default 0,
LJJZJ00 NUMBER(15,2) default 0,
LJDZJ00 NUMBER(15,2) default 0,
LJJJZ00 NUMBER(15,2) default 0,
LJDJZ00 NUMBER(15,2) default 0,
LJJXF00 NUMBER(15,2) default 0,
LJDXF00 NUMBER(15,2) default 0,
LJJYZ01 NUMBER(15,2) default 0,
LJDYZ01 NUMBER(15,2) default 0,
LJJZJ01 NUMBER(15,2) default 0,
LJDZJ01 NUMBER(15,2) default 0,
LJJJZ01 NUMBER(15,2) default 0,
LJDJZ01 NUMBER(15,2) default 0,
LJJXF01 NUMBER(15,2) default 0,
LJDXF01 NUMBER(15,2) default 0,
LJJYZ02 NUMBER(15,2) default 0,
LJDYZ02 NUMBER(15,2) default 0,
LJJZJ02 NUMBER(15,2) default 0,
LJDZJ02 NUMBER(15,2) default 0,
LJJJZ02 NUMBER(15,2) default 0,
LJDJZ02 NUMBER(15,2) default 0,
LJJXF02 NUMBER(15,2) default 0,
LJDXF02 NUMBER(15,2) default 0,
LJJYZ03 NUMBER(15,2) default 0,
LJDYZ03 NUMBER(15,2) default 0,
LJJZJ03 NUMBER(15,2) default 0,
LJDZJ03 NUMBER(15,2) default 0,
LJJJZ03 NUMBER(15,2) default 0,
LJDJZ03 NUMBER(15,2) default 0,
LJJXF03 NUMBER(15,2) default 0,
LJDXF03 NUMBER(15,2) default 0,
LJJYZ04 NUMBER(15,2) default 0,
LJDYZ04 NUMBER(15,2) default 0,
LJJZJ04 NUMBER(15,2) default 0,
LJDZJ04 NUMBER(15,2) default 0,
LJJJZ04 NUMBER(15,2) default 0,
LJDJZ04 NUMBER(15,2) default 0,
LJJXF04 NUMBER(15,2) default 0,
LJDXF04 NUMBER(15,2) default 0,
LJJYZ05 NUMBER(15,2) default 0,
LJDYZ05 NUMBER(15,2) default 0,
LJJZJ05 NUMBER(15,2) default 0,
LJDZJ05 NUMBER(15,2) default 0,
LJJJZ05 NUMBER(15,2) default 0,
LJDJZ05 NUMBER(15,2) default 0,
LJJXF05 NUMBER(15,2) default 0,
LJDXF05 NUMBER(15,2) default 0,
LJJYZ06 NUMBER(15,2) default 0,
LJDYZ06 NUMBER(15,2) default 0,
LJJZJ06 NUMBER(15,2) default 0,
LJDZJ06 NUMBER(15,2) default 0,
LJJJZ06 NUMBER(15,2) default 0,
LJDJZ06 NUMBER(15,2) default 0,
LJJXF06 NUMBER(15,2) default 0,
LJDXF06 NUMBER(15,2) default 0,
LJJYZ07 NUMBER(15,2) default 0,
LJDYZ07 NUMBER(15,2) default 0,
LJJZJ07 NUMBER(15,2) default 0,
LJDZJ07 NUMBER(15,2) default 0,
LJJJZ07 NUMBER(15,2) default 0,
LJDJZ07 NUMBER(15,2) default 0,
LJJXF07 NUMBER(15,2) default 0,
LJDXF07 NUMBER(15,2) default 0,
LJJYZ08 NUMBER(15,2) default 0,
LJDYZ08 NUMBER(15,2) default 0,
LJJZJ08 NUMBER(15,2) default 0,
LJDZJ08 NUMBER(15,2) default 0,
LJJJZ08 NUMBER(15,2) default 0,
LJDJZ08 NUMBER(15,2) default 0,
LJJXF08 NUMBER(15,2) default 0,
LJDXF08 NUMBER(15,2) default 0,
LJJYZ09 NUMBER(15,2) default 0,
LJDYZ09 NUMBER(15,2) default 0,
LJJZJ09 NUMBER(15,2) default 0,
LJDZJ09 NUMBER(15,2) default 0,
LJJJZ09 NUMBER(15,2) default 0,
LJDJZ09 NUMBER(15,2) default 0,
LJJXF09 NUMBER(15,2) default 0,
LJDXF09 NUMBER(15,2) default 0,
LJJYZ10 NUMBER(15,2) default 0,
LJDYZ10 NUMBER(15,2) default 0,
LJJZJ10 NUMBER(15,2) default 0,
LJDZJ10 NUMBER(15,2) default 0,
LJJJZ10 NUMBER(15,2) default 0,
LJDJZ10 NUMBER(15,2) default 0,
LJJXF10 NUMBER(15,2) default 0,
LJDXF10 NUMBER(15,2) default 0,
LJJYZ11 NUMBER(15,2) default 0,
LJDYZ11 NUMBER(15,2) default 0,
LJJZJ11 NUMBER(15,2) default 0,
LJDZJ11 NUMBER(15,2) default 0,
LJJJZ11 NUMBER(15,2) default 0,
LJDJZ11 NUMBER(15,2) default 0,
LJJXF11 NUMBER(15,2) default 0,
LJDXF11 NUMBER(15,2) default 0,
LJJYZ12 NUMBER(15,2) default 0,
LJDYZ12 NUMBER(15,2) default 0,
LJJZJ12 NUMBER(15,2) default 0,
LJDZJ12 NUMBER(15,2) default 0,
LJJJZ12 NUMBER(15,2) default 0,
LJDJZ12 NUMBER(15,2) default 0,
LJJXF12 NUMBER(15,2) default 0,
LJDXF12 NUMBER(15,2) default 0 /*12累计修费*/
)
tablespace CW_TS
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 120K
next 26K
minextents 1
maxextents 121
pctincrease 10
);
alter table TGD_BALANCE<<YEAR>>
add primary key (KPBH)
using index
tablespace CW_TS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 30K
next 10K
minextents 1
maxextents 121
pctincrease 0
);
create table TGD_DEPARTMENT<<YEAR>>
(
CDEPCODE CHAR(12) not null,
CDEPNAME CHAR(20) not null,
IDEPGRADE NUMBER(5),
BDEPEND NUMBER(5),
CDEPPERSON CHAR(20),
CDEPPHONE CHAR(20),
CDEPMEMO CHAR(40),
BOTHERUSE NUMBER(5),
CGDKM CHAR(40),
ISHAVEZD CHAR(2),
XFDFKM CHAR(40)
)
tablespace CW_TS
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 10K
next 10K
minextents 1
maxextents 121
pctincrease 0
);
create table TGD_DEPARTMENTKM
(
CDEPCODE CHAR(12) not null,
CDEPNAME CHAR(20) not null,
CGDKM CHAR(40),
XFDFKM CHAR(40)
)
tablespace CW_TS
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 10K
next 10K
minextents 1
maxextents 121
pctincrease 0
);
create table TGD_DISPLAY
(
VCNAME CHAR(20) not null,
VCCHINAME CHAR(20),
VCENGNAME CHAR(30),
VCDISNAME CHAR(20),
VCUSE CHAR(10),
VCORDER NUMBER(10) not null
)
tablespace CW_TS
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 10K
next 10K
minextents 1
maxextents 121
pctincrease 0
);
create table TGD_GDZCKP
(
KPBH CHAR(25) not null,
GDZCBH CHAR(30),
GDZCMC CHAR(40),
BMBH CHAR(12),
BMMC CHAR(20),
CFDD CHAR(40),
LBBH CHAR(10),
LBMC CHAR(20),
WBYZ NUMBER(15,2),
YZ NUMBER(15,2),
CGZ NUMBER(15,2),
JCZ NUMBER(15,2),
JCZL NUMBER(15,4),
JZ NUMBER(15,2),
KSSYRQ CHAR(10),
YZJE NUMBER(15,2),
YZJL NUMBER(15,6),
ZJFF CHAR(20),
LJZJ NUMBER(15,2),
YJTYF CHAR(10) default 0 not null,
SYNX NUMBER(5),
SYZK CHAR(20),
BIZ CHAR(10),
BZDW CHAR(10),
ZCKM VARCHAR2(40),
DYZJKM VARCHAR2(40),
GZLDW CHAR(10),
GZZL NUMBER(15,4),
LJGZL NUMBER(15,4),
DWZJ NUMBER(15,4),
ZJFS CHAR(20),
JSFS CHAR(20),
ZXR CHAR(10),
ZXRQ CHAR(10),
LRR CHAR(10),
LRRQ CHAR(10),
XMBH CHAR(20),
GGXH CHAR(40),
HL NUMBER(15,4),
JZS NUMBER(5),
DJSL NUMBER(5),
DJGL CHAR(20),
JZMJ NUMBER(15,4),
BJ CHAR(2),
KPYS CHAR(20),
SYZKBH CHAR(4),
ZJKM VARCHAR2(40),
BMFS CHAR(1),
TXQ NUMBER(5),
YTXFL NUMBER(15,4),
YTFY NUMBER(15,4),
ZJLYBM CHAR(20),
ZJLYMC VARCHAR2(30),
ZCFLDM CHAR(10),
ZCFLMC VARCHAR2(30),
LJJZZB NUMBER(15,2),
BQJZZB NUMBER(15,2),
XFKM CHAR(40),
XFDFKM CHAR(40),
GZRQ CHAR(10),
BXDH CHAR(10),
JZCBS CHAR(40),
SCCS CHAR(40),
CCRQ CHAR(10),
CPZH CHAR(20),
JLDW CHAR(10),
BXDBH CHAR(20),
QGDBH CHAR(20),
YSDBH CHAR(20),
ZY CHAR(20),
FPXMMC CHAR(40),
JZZBKM CHAR(40),
QCYZ NUMBER(15,2) default 0,
QCLJZJ NUMBER(15,2) default 0,
QCLJJZZB NUMBER(15,2) default 0
)
tablespace CW_TS
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 330K
next 280K
minextents 1
maxextents unlimited
pctincrease 50
);
create table TGD_GZL
(
KPBH CHAR(25) not null,
SRYF CHAR(7) not null,
GZL NUMBER(15,4),
SQGZL NUMBER(15,4),
LRR CHAR(10),
LRRQ CHAR(10),
BDQYZJE NUMBER(15,2),
BDQYZJL NUMBER(15,4),
BDQLJGZL NUMBER(15,2)
)
tablespace CW_TS
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 10K
next 10K
minextents 1
maxextents 121
pctincrease 0
);
create table TGD_GZSQ
(
QGDBH CHAR(10) not null,
BMBH CHAR(10),
BMMC CHAR(30),
TBR CHAR(10),
SQSJ CHAR(10),
SBMC CHAR(30),
GGXH CHAR(20),
SCCJ CHAR(30),
SGSL NUMBER(10),
SXZJ NUMBER(18),
LYYT CHAR(40),
SBTJ CHAR(30),
RYTJ CHAR(30),
JJXY NUMBER(18,2),
SBSYL NUMBER(18,2),
NHS NUMBER(18,2),
YSBQK CHAR(40),
ZRYJ CHAR(50),
SBKYJ CHAR(50),
LDSP CHAR(50),
PZWH CHAR(20),
BZ CHAR(50),
KPBH CHAR(25)
)
tablespace CW_TS
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 10K
next 10K
minextents 1
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -