📄 gd.sql
字号:
[KPBH],
[DJH]
) ON [PRIMARY];
ALTER TABLE [dbo].[TGD_ZCYZBD] WITH NOCHECK ADD
CONSTRAINT [PK__TGD_ZCYZBD__6166761E] PRIMARY KEY CLUSTERED
(
[KPBH],
[BDLX],
[DJH]
) ON [PRIMARY];
ALTER TABLE [dbo].[TGD_ZCZJFFTZ] WITH NOCHECK ADD
CONSTRAINT [PK_TGD_ZCZJFFTZ] PRIMARY KEY CLUSTERED
(
[KPBH],
[DJH]
) ON [PRIMARY];
ALTER TABLE [dbo].[TGD_ZCZTBD] WITH NOCHECK ADD
CONSTRAINT [PK_TGD_ZCZTBD] PRIMARY KEY CLUSTERED
(
[KPBH],
[DJH]
) ON [PRIMARY];
ALTER TABLE [dbo].[TGD_ZDYBB] WITH NOCHECK ADD
CONSTRAINT [PK__TGD_ZDYBB__625A9A57] PRIMARY KEY CLUSTERED
(
[BBMC],
[ID]
) ON [PRIMARY];
ALTER TABLE [dbo].[TGD_ZJFS] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[DM]
) ON [PRIMARY];
ALTER TABLE [dbo].[TGD_ZJJT] WITH NOCHECK ADD
CONSTRAINT [PK_TGD_ZJJT] PRIMARY KEY CLUSTERED
(
[KPBH],
[TIME]
) ON [PRIMARY];
ALTER TABLE [dbo].[TGD_BALANCE<<YEAR>>] WITH NOCHECK ADD
CONSTRAINT [DF__TGD_BALAN__LJJYZ__0AD36B5C] DEFAULT (0.00) FOR [LJJYZ00],
CONSTRAINT [DF__TGD_BALAN__LJDYZ__0BC78F95] DEFAULT (0.00) FOR [LJDYZ00],
CONSTRAINT [DF__TGD_BALAN__LJJZJ__0CBBB3CE] DEFAULT (0.00) FOR [LJJZJ00],
CONSTRAINT [DF__TGD_BALAN__LJDZJ__0DAFD807] DEFAULT (0.00) FOR [LJDZJ00],
CONSTRAINT [DF__TGD_BALAN__LJJJZ__0EA3FC40] DEFAULT (0.00) FOR [LJJJZ00],
CONSTRAINT [DF__TGD_BALAN__LJDJZ__0F982079] DEFAULT (0.00) FOR [LJDJZ00],
CONSTRAINT [DF__TGD_BALAN__LJJXF__108C44B2] DEFAULT (0.00) FOR [LJJXF00],
CONSTRAINT [DF__TGD_BALAN__LJDXF__118068EB] DEFAULT (0.00) FOR [LJDXF00],
CONSTRAINT [DF__TGD_BALAN__LJJYZ__12748D24] DEFAULT (0) FOR [LJJYZ01],
CONSTRAINT [DF__TGD_BALAN__LJDYZ__1368B15D] DEFAULT (0) FOR [LJDYZ01],
CONSTRAINT [DF__TGD_BALAN__LJJZJ__145CD596] DEFAULT (0) FOR [LJJZJ01],
CONSTRAINT [DF__TGD_BALAN__LJDZJ__1550F9CF] DEFAULT (0) FOR [LJDZJ01],
CONSTRAINT [DF__TGD_BALAN__LJJJZ__16451E08] DEFAULT (0) FOR [LJJJZ01],
CONSTRAINT [DF__TGD_BALAN__LJDJZ__17394241] DEFAULT (0) FOR [LJDJZ01],
CONSTRAINT [DF__TGD_BALAN__LJJXF__182D667A] DEFAULT (0) FOR [LJJXF01],
CONSTRAINT [DF__TGD_BALAN__LJDXF__19218AB3] DEFAULT (0) FOR [LJDXF01],
CONSTRAINT [DF__TGD_BALAN__LJJYZ__1A15AEEC] DEFAULT (0) FOR [LJJYZ02],
CONSTRAINT [DF__TGD_BALAN__LJDYZ__1B09D325] DEFAULT (0) FOR [LJDYZ02],
CONSTRAINT [DF__TGD_BALAN__LJJZJ__1BFDF75E] DEFAULT (0) FOR [LJJZJ02],
CONSTRAINT [DF__TGD_BALAN__LJDZJ__1CF21B97] DEFAULT (0) FOR [LJDZJ02],
CONSTRAINT [DF__TGD_BALAN__LJJJZ__1DE63FD0] DEFAULT (0) FOR [LJJJZ02],
CONSTRAINT [DF__TGD_BALAN__LJDJZ__1EDA6409] DEFAULT (0) FOR [LJDJZ02],
CONSTRAINT [DF__TGD_BALAN__LJJXF__1FCE8842] DEFAULT (0) FOR [LJJXF02],
CONSTRAINT [DF__TGD_BALAN__LJDXF__20C2AC7B] DEFAULT (0) FOR [LJDXF02],
CONSTRAINT [DF__TGD_BALAN__LJJYZ__21B6D0B4] DEFAULT (0) FOR [LJJYZ03],
CONSTRAINT [DF__TGD_BALAN__LJDYZ__22AAF4ED] DEFAULT (0) FOR [LJDYZ03],
CONSTRAINT [DF__TGD_BALAN__LJJZJ__239F1926] DEFAULT (0) FOR [LJJZJ03],
CONSTRAINT [DF__TGD_BALAN__LJDZJ__24933D5F] DEFAULT (0) FOR [LJDZJ03],
CONSTRAINT [DF__TGD_BALAN__LJJJZ__25876198] DEFAULT (0) FOR [LJJJZ03],
CONSTRAINT [DF__TGD_BALAN__LJDJZ__267B85D1] DEFAULT (0) FOR [LJDJZ03],
CONSTRAINT [DF__TGD_BALAN__LJJXF__276FAA0A] DEFAULT (0) FOR [LJJXF03],
CONSTRAINT [DF__TGD_BALAN__LJDXF__2863CE43] DEFAULT (0) FOR [LJDXF03],
CONSTRAINT [DF__TGD_BALAN__LJJYZ__2957F27C] DEFAULT (0) FOR [LJJYZ04],
CONSTRAINT [DF__TGD_BALAN__LJDYZ__2A4C16B5] DEFAULT (0) FOR [LJDYZ04],
CONSTRAINT [DF__TGD_BALAN__LJJZJ__2B403AEE] DEFAULT (0) FOR [LJJZJ04],
CONSTRAINT [DF__TGD_BALAN__LJDZJ__2C345F27] DEFAULT (0) FOR [LJDZJ04],
CONSTRAINT [DF__TGD_BALAN__LJJJZ__2D288360] DEFAULT (0) FOR [LJJJZ04],
CONSTRAINT [DF__TGD_BALAN__LJDJZ__2E1CA799] DEFAULT (0) FOR [LJDJZ04],
CONSTRAINT [DF__TGD_BALAN__LJJXF__2F10CBD2] DEFAULT (0) FOR [LJJXF04],
CONSTRAINT [DF__TGD_BALAN__LJDXF__3004F00B] DEFAULT (0) FOR [LJDXF04],
CONSTRAINT [DF__TGD_BALAN__LJJYZ__30F91444] DEFAULT (0) FOR [LJJYZ05],
CONSTRAINT [DF__TGD_BALAN__LJDYZ__31ED387D] DEFAULT (0) FOR [LJDYZ05],
CONSTRAINT [DF__TGD_BALAN__LJJZJ__32E15CB6] DEFAULT (0) FOR [LJJZJ05],
CONSTRAINT [DF__TGD_BALAN__LJDZJ__33D580EF] DEFAULT (0) FOR [LJDZJ05],
CONSTRAINT [DF__TGD_BALAN__LJJJZ__34C9A528] DEFAULT (0) FOR [LJJJZ05],
CONSTRAINT [DF__TGD_BALAN__LJDJZ__35BDC961] DEFAULT (0) FOR [LJDJZ05],
CONSTRAINT [DF__TGD_BALAN__LJJXF__36B1ED9A] DEFAULT (0) FOR [LJJXF05],
CONSTRAINT [DF__TGD_BALAN__LJDXF__37A611D3] DEFAULT (0) FOR [LJDXF05],
CONSTRAINT [DF__TGD_BALAN__LJJYZ__389A360C] DEFAULT (0) FOR [LJJYZ06],
CONSTRAINT [DF__TGD_BALAN__LJDYZ__398E5A45] DEFAULT (0) FOR [LJDYZ06],
CONSTRAINT [DF__TGD_BALAN__LJJZJ__3A827E7E] DEFAULT (0) FOR [LJJZJ06],
CONSTRAINT [DF__TGD_BALAN__LJDZJ__3B76A2B7] DEFAULT (0) FOR [LJDZJ06],
CONSTRAINT [DF__TGD_BALAN__LJJJZ__3C6AC6F0] DEFAULT (0) FOR [LJJJZ06],
CONSTRAINT [DF__TGD_BALAN__LJDJZ__3D5EEB29] DEFAULT (0) FOR [LJDJZ06],
CONSTRAINT [DF__TGD_BALAN__LJJXF__3E530F62] DEFAULT (0) FOR [LJJXF06],
CONSTRAINT [DF__TGD_BALAN__LJDXF__3F47339B] DEFAULT (0) FOR [LJDXF06],
CONSTRAINT [DF__TGD_BALAN__LJJYZ__403B57D4] DEFAULT (0) FOR [LJJYZ07],
CONSTRAINT [DF__TGD_BALAN__LJDYZ__412F7C0D] DEFAULT (0) FOR [LJDYZ07],
CONSTRAINT [DF__TGD_BALAN__LJJZJ__4223A046] DEFAULT (0) FOR [LJJZJ07],
CONSTRAINT [DF__TGD_BALAN__LJDZJ__4317C47F] DEFAULT (0) FOR [LJDZJ07],
CONSTRAINT [DF__TGD_BALAN__LJJJZ__440BE8B8] DEFAULT (0) FOR [LJJJZ07],
CONSTRAINT [DF__TGD_BALAN__LJDJZ__45000CF1] DEFAULT (0) FOR [LJDJZ07],
CONSTRAINT [DF__TGD_BALAN__LJJXF__45F4312A] DEFAULT (0) FOR [LJJXF07],
CONSTRAINT [DF__TGD_BALAN__LJDXF__46E85563] DEFAULT (0) FOR [LJDXF07],
CONSTRAINT [DF__TGD_BALAN__LJJYZ__47DC799C] DEFAULT (0) FOR [LJJYZ08],
CONSTRAINT [DF__TGD_BALAN__LJDYZ__48D09DD5] DEFAULT (0) FOR [LJDYZ08],
CONSTRAINT [DF__TGD_BALAN__LJJZJ__49C4C20E] DEFAULT (0) FOR [LJJZJ08],
CONSTRAINT [DF__TGD_BALAN__LJDZJ__4AB8E647] DEFAULT (0) FOR [LJDZJ08],
CONSTRAINT [DF__TGD_BALAN__LJJJZ__4BAD0A80] DEFAULT (0) FOR [LJJJZ08],
CONSTRAINT [DF__TGD_BALAN__LJDJZ__4CA12EB9] DEFAULT (0) FOR [LJDJZ08],
CONSTRAINT [DF__TGD_BALAN__LJJXF__4D9552F2] DEFAULT (0) FOR [LJJXF08],
CONSTRAINT [DF__TGD_BALAN__LJDXF__4E89772B] DEFAULT (0) FOR [LJDXF08],
CONSTRAINT [DF__TGD_BALAN__LJJYZ__4F7D9B64] DEFAULT (0) FOR [LJJYZ09],
CONSTRAINT [DF__TGD_BALAN__LJDYZ__5071BF9D] DEFAULT (0) FOR [LJDYZ09],
CONSTRAINT [DF__TGD_BALAN__LJJZJ__5165E3D6] DEFAULT (0) FOR [LJJZJ09],
CONSTRAINT [DF__TGD_BALAN__LJDZJ__525A080F] DEFAULT (0) FOR [LJDZJ09],
CONSTRAINT [DF__TGD_BALAN__LJJJZ__534E2C48] DEFAULT (0) FOR [LJJJZ09],
CONSTRAINT [DF__TGD_BALAN__LJDJZ__54425081] DEFAULT (0) FOR [LJDJZ09],
CONSTRAINT [DF__TGD_BALAN__LJJXF__553674BA] DEFAULT (0) FOR [LJJXF09],
CONSTRAINT [DF__TGD_BALAN__LJDXF__562A98F3] DEFAULT (0) FOR [LJDXF09],
CONSTRAINT [DF__TGD_BALAN__LJJYZ__571EBD2C] DEFAULT (0) FOR [LJJYZ10],
CONSTRAINT [DF__TGD_BALAN__LJDYZ__5812E165] DEFAULT (0) FOR [LJDYZ10],
CONSTRAINT [DF__TGD_BALAN__LJJZJ__5907059E] DEFAULT (0) FOR [LJJZJ10],
CONSTRAINT [DF__TGD_BALAN__LJDZJ__59FB29D7] DEFAULT (0) FOR [LJDZJ10],
CONSTRAINT [DF__TGD_BALAN__LJJJZ__5AEF4E10] DEFAULT (0) FOR [LJJJZ10],
CONSTRAINT [DF__TGD_BALAN__LJDJZ__5BE37249] DEFAULT (0) FOR [LJDJZ10],
CONSTRAINT [DF__TGD_BALAN__LJJXF__5CD79682] DEFAULT (0) FOR [LJJXF10],
CONSTRAINT [DF__TGD_BALAN__LJDXF__5DCBBABB] DEFAULT (0) FOR [LJDXF10],
CONSTRAINT [DF__TGD_BALAN__LJJYZ__5EBFDEF4] DEFAULT (0) FOR [LJJYZ11],
CONSTRAINT [DF__TGD_BALAN__LJDYZ__5FB4032D] DEFAULT (0) FOR [LJDYZ11],
CONSTRAINT [DF__TGD_BALAN__LJJZJ__60A82766] DEFAULT (0) FOR [LJJZJ11],
CONSTRAINT [DF__TGD_BALAN__LJDZJ__619C4B9F] DEFAULT (0) FOR [LJDZJ11],
CONSTRAINT [DF__TGD_BALAN__LJJJZ__62906FD8] DEFAULT (0) FOR [LJJJZ11],
CONSTRAINT [DF__TGD_BALAN__LJDJZ__63849411] DEFAULT (0) FOR [LJDJZ11],
CONSTRAINT [DF__TGD_BALAN__LJJXF__6478B84A] DEFAULT (0) FOR [LJJXF11],
CONSTRAINT [DF__TGD_BALAN__LJDXF__656CDC83] DEFAULT (0) FOR [LJDXF11],
CONSTRAINT [DF__TGD_BALAN__LJJYZ__666100BC] DEFAULT (0) FOR [LJJYZ12],
CONSTRAINT [DF__TGD_BALAN__LJDYZ__675524F5] DEFAULT (0) FOR [LJDYZ12],
CONSTRAINT [DF__TGD_BALAN__LJJZJ__6849492E] DEFAULT (0) FOR [LJJZJ12],
CONSTRAINT [DF__TGD_BALAN__LJDZJ__693D6D67] DEFAULT (0) FOR [LJDZJ12],
CONSTRAINT [DF__TGD_BALAN__LJJJZ__6A3191A0] DEFAULT (0) FOR [LJJJZ12],
CONSTRAINT [DF__TGD_BALAN__LJDJZ__6B25B5D9] DEFAULT (0) FOR [LJDJZ12],
CONSTRAINT [DF__TGD_BALAN__LJJXF__6C19DA12] DEFAULT (0) FOR [LJJXF12],
CONSTRAINT [DF__TGD_BALAN__LJDXF__6D0DFE4B] DEFAULT (0) FOR [LJDXF12]
;
ALTER TABLE [dbo].[TGD_DEPARTMENT<<YEAR>>] WITH NOCHECK ADD
CONSTRAINT [DF_TGD_DEPARTMENT<<YEAR>>_CDEPCODE_1] DEFAULT ('') FOR [CDEPCODE],
CONSTRAINT [DF_TGD_DEPARTMENT<<YEAR>>_CDEPNAME_1] DEFAULT ('') FOR [CDEPNAME],
CONSTRAINT [DF_TGD_DEPARTMENT<<YEAR>>_IDEPGRADE_1] DEFAULT (0) FOR [IDEPGRADE],
CONSTRAINT [DF_TGD_DEPARTMENT<<YEAR>>_BDEPEND_1] DEFAULT (0) FOR [BDEPEND],
CONSTRAINT [DF_TGD_DEPARTMENT<<YEAR>>_CDEPPERSON_1] DEFAULT ('') FOR [CDEPPERSON],
CONSTRAINT [DF_TGD_DEPARTMENT<<YEAR>>_CDEPPHONE_1] DEFAULT ('') FOR [CDEPPHONE],
CONSTRAINT [DF_TGD_DEPARTMENT<<YEAR>>_CDEPMEMO_1] DEFAULT ('') FOR [CDEPMEMO],
CONSTRAINT [DF_TGD_DEPARTMENT<<YEAR>>_BOTHERUSE_1] DEFAULT (0) FOR [BOTHERUSE],
CONSTRAINT [DF_TGD_DEPARTMENT<<YEAR>>_CGDKM_1] DEFAULT ('') FOR [CGDKM],
CONSTRAINT [DF_TGD_DEPARTMENT<<YEAR>>_ISHAVEZD_1] DEFAULT ('0') FOR [ISHAVEZD],
CONSTRAINT [DF_TGD_DEPARTMENT<<YEAR>>_XFDFKM_1] DEFAULT ('') FOR [XFDFKM]
;
ALTER TABLE [dbo].[TGD_DEPARTMENTKM] WITH NOCHECK ADD
CONSTRAINT [DF_TGD_DEPARTMENTKM_CDEPCODE] DEFAULT ('') FOR [CDEPCODE],
CONSTRAINT [DF_TGD_DEPARTMENTKM_CDEPNAME] DEFAULT ('') FOR [CDEPNAME],
CONSTRAINT [DF_TGD_DEPARTMENTKM_CGDKM] DEFAULT ('') FOR [CGDKM],
CONSTRAINT [DF_TGD_DEPARTMENTKM_XFDFKM] DEFAULT ('') FOR [XFDFKM]
;
ALTER TABLE [dbo].[TGD_DISPLAY] WITH NOCHECK ADD
CONSTRAINT [DF_TGD_DISPLAY_VCNAME] DEFAULT ('') FOR [VCNAME],
CONSTRAINT [DF_TGD_DISPLAY_VCCHINAME] DEFAULT ('') FOR [VCCHINAME],
CONSTRAINT [DF_TGD_DISPLAY_VCENGNAME] DEFAULT ('') FOR [VCENGNAME],
CONSTRAINT [DF_TGD_DISPLAY_VCDISNAME] DEFAULT ('') FOR [VCDISNAME],
CONSTRAINT [DF_TGD_DISPLAY_VCUSE] DEFAULT ('') FOR [VCUSE],
CONSTRAINT [DF_TGD_DISPLAY_VCORDER] DEFAULT (0) FOR [VCORDER]
;
ALTER TABLE [dbo].[TGD_GDZCKP] WITH NOCHECK ADD
CONSTRAINT [DF_TGD_GDZCKP_GDZCBH] DEFAULT ('') FOR [GDZCBH],
CONSTRAINT [DF_TGD_GDZCKP_GDZCMC] DEFAULT ('') FOR [GDZCMC],
CONSTRAINT [DF_TGD_GDZCKP_BMBH] DEFAULT ('') FOR [BMBH],
CONSTRAINT [DF_TGD_GDZCKP_BMMC] DEFAULT ('') FOR [BMMC],
CONSTRAINT [DF_TGD_GDZCKP_CFDD] DEFAULT ('') FOR [CFDD],
CONSTRAINT [DF_TGD_GDZCKP_LBBH] DEFAULT ('') FOR [LBBH],
CONSTRAINT [DF_TGD_GDZCKP_LBMC] DEFAULT ('') FOR [LBMC],
CONSTRAINT [DF_TGD_GDZCKP_WBYZ] DEFAULT (0) FOR [WBYZ],
CONSTRAINT [DF_TGD_GDZCKP_YZ] DEFAULT (0) FOR [YZ],
CONSTRAINT [DF_TGD_GDZCKP_CGZ] DEFAULT (0) FOR [CGZ],
CONSTRAINT [DF_TGD_GDZCKP_JCZ] DEFAULT (0) FOR [JCZ],
CONSTRAINT [DF_TGD_GDZCKP_JCZL] DEFAULT (0) FOR [JCZL],
CONSTRAINT [DF_TGD_GDZCKP_JZ] DEFAULT (0) FOR [JZ],
CONSTRAINT [DF_TGD_GDZCKP_KSSYRQ] DEFAULT ('') FOR [KSSYRQ],
CONSTRAINT [DF_TGD_GDZCKP_YZJE] DEFAULT (0) FOR [YZJE],
CONSTRAINT [DF_TGD_GDZCKP_YZJL] DEFAULT (0) FOR [YZJL],
CONSTRAINT [DF_TGD_GDZCKP_ZJFF] DEFAULT ('') FOR [ZJFF],
CONSTRAINT [DF_TGD_GDZCKP_LJZJ] DEFAULT (0) FOR [LJZJ],
CONSTRAINT [DF_TGD_GDZCKP_YJTYF] DEFAULT ('') FOR [YJTYF],
CONSTRAINT [DF_TGD_GDZCKP_SYNX] DEFAULT (0) FOR [SYNX],
CONSTRAINT [DF_TGD_GDZCKP_SYZK] DEFAULT ('') FOR [SYZK],
CONSTRAINT [DF_TGD_GDZCKP_BIZ] DEFAULT ('人民币') FOR [BIZ],
CONSTRAINT [DF_TGD_GDZCKP_BZDW] DEFAULT ('元') FOR [BZDW],
CONSTRAINT [DF_TGD_GDZCKP_ZCKM] DEFAULT ('') FOR [ZCKM],
CONSTRAINT [DF_TGD_GDZCKP_DYZJKM] DEFAULT ('') FOR [DYZJKM],
CONSTRAINT [DF_TGD_GDZCKP_GZLDW] DEFAULT ('') FOR [GZLDW],
CONSTRAINT [DF_TGD_GDZCKP_GZZL] DEFAULT (0) FOR [GZZL],
CONSTRAINT [DF_TGD_GDZCKP_LJGZL] DEFAULT (0) FOR [LJGZL],
CONSTRAINT [DF_TGD_GDZCKP_DWZJ] DEFAULT (0) FOR [DWZJ],
CONSTRAINT [DF_TGD_GDZCKP_ZJFS] DEFAULT ('') FOR [ZJFS],
CONSTRAINT [DF_TGD_GDZCKP_JSFS] DEFAULT ('') FOR [JSFS],
CONSTRAINT [DF_TGD_GDZCKP_ZXR] DEFAULT ('') FOR [ZXR],
CONSTRAINT [DF_TGD_GDZCKP_ZXRQ] DEFAULT ('') FOR [ZXRQ],
CONSTRAINT [DF_TGD_GDZCKP_LRR] DEFAULT ('') FOR [LRR],
CONSTRAINT [DF_TGD_GDZCKP_LRRQ] DEFAULT ('') FOR [LRRQ],
CONSTRAINT [DF_TGD_GDZCKP_XMBH] DEFAULT ('') FOR [XMBH],
CONSTRAINT [DF_TGD_GDZCKP_GGXH] DEFAULT ('') FOR [GGXH],
CONSTRAINT [DF_TGD_GDZCKP_HL] DEFAULT (0) FOR [HL],
CONSTRAINT [DF_TGD_GDZCKP_JZS] DEFAULT (0) FOR [JZS],
CONSTRAINT [DF_TGD_GDZCKP_DJSL] DEFAULT (0) FOR [DJSL],
CONSTRAINT [DF_TGD_GDZCKP_DJGR] DEFAULT ('') FOR [DJGR],
CONSTRAINT [DF_TGD_GDZCKP_JZMJ] DEFAULT (0) FOR [JZMJ],
CONSTRAINT [DF_TGD_GDZCKP_BJ] DEFAULT ('') FOR [BJ],
CONSTRAINT [DF_TGD_GDZCKP_KPYS] DEFAULT ('') FOR [KPYS],
CONSTRAINT [DF_TGD_GDZCKP_SYZKBH] DEFAULT ('') FOR [SYZKBH],
CONSTRAINT [DF_TGD_GDZCKP_ZJKM] DEFAULT ('') FOR [ZJKM],
CONSTRAINT [DF_TGD_GDZCKP_BMFS] DEFAULT ('') FOR [BMFS],
CONSTRAINT [DF_TGD_GDZCKP_TXQ] DEFAULT ('') FOR [TXQ],
CONSTRAINT [DF_TGD_GDZCKP_YTXFL] DEFAULT (0) FOR [YTXFL],
CONSTRAINT [DF_TGD_GDZCKP_YTFY] DEFAULT (0) FOR [YTFY],
CONSTRAINT [DF_TGD_GDZCKP_ZJLYBM] DEFAULT ('') FOR [ZJLYBM],
CONSTRAINT [DF_TGD_GDZCKP_ZJLYMC] DEFAULT ('') FOR [ZJLYMC],
CONSTRAINT [DF_TGD_GDZCKP_ZCFLDM] DEFAULT ('') FOR [ZCFLDM],
CONSTRAINT [DF_TGD_GDZCKP_ZCFLMC] DEFAULT ('') FOR [ZCFLMC],
CONSTRAINT [DF_TGD_GDZCKP_LJJZZB] DEFAULT (0) FOR [LJJZZB],
CONSTRAINT [DF_TGD_GDZCKP_BQJZZB] DEFAULT (0) FOR [BQJZZB],
CONSTRAINT [DF_TGD_GDZCKP_XFKM] DEFAULT ('') FOR [XFKM],
CONSTRAINT [DF_TGD_GDZCKP_XFDFKM] DEFAULT ('') FOR [XFDFKM],
CONSTRAINT [DF_TGD_GDZCKP_GZRQ] DEFAULT ('') FOR [GZRQ],
CONSTRAINT [DF_TGD_GDZCKP_BXDH] DEFAULT ('') FOR [BXDH],
CONSTRAINT [DF_TGD_GDZCKP_JZCBS] DEFAULT ('') FOR [JZCBS],
CONSTRAINT [DF_TGD_GDZCKP_SCCS] DEFAULT ('') FOR [SCCS],
CONSTRAINT [DF_TGD_GDZCKP_CCRQ] DEFAULT ('') FOR [CCRQ],
CONSTRAINT [DF_TGD_GDZCKP_CPZH] DEFAULT ('') FOR [CPZH],
CONSTRAINT [DF_TGD_GDZCKP_JLDW] DEFAULT ('') FOR [JLDW],
CONSTRAINT [DF_TGD_GDZCKP_BXDBH] DEFAULT ('') FOR [BXDBH],
CONSTRAINT [DF_TGD_GDZCKP_QGDBH] DEFAULT ('') FOR [QGDBH],
CONSTRAINT [DF_TGD_GDZCKP_YSDBH] DEFAULT ('') FOR [YSDBH],
CONSTRAINT [DF_TGD_GDZCKP_ZY] DEFAULT ('') FOR [ZY]
;
ALTER TABLE [dbo].[TGD_GZL] WITH NOCHECK ADD
CONSTRAINT [DF_TGD_GZL_KPBH] DEFAULT ('') FOR [KPBH],
CONSTRAINT [DF_TGD_GZL_SRYF] DEFAULT ('') FOR [SRYF],
CONSTRAINT [DF_TGD_GZL_GZL] DEFAULT (0) FOR [GZL],
CONSTRAINT [DF_TGD_GZL_SQGZL] DEFAULT (0) FOR [SQGZL],
CONSTRAINT [DF_TGD_GZL_LRR] DEFAULT ('') FOR [LRR],
CONSTRAINT [DF_TGD_GZL_LRRQ] DEFAULT ('') FOR [LRRQ]
;
ALTER TABLE [dbo].[TGD_GZSQ] WITH NOCHECK ADD
CONSTRAINT [DF_TGD_GZSQ_QGDBH] DEFAULT ('') FOR [QGDBH],
CONSTRAINT [DF_TGD_GZSQ_BMBH] DEFAULT ('') FOR [BMBH],
CONSTRAINT [DF_TGD_GZSQ_BMMC] DEFAULT ('') FOR [BMMC],
CONSTRAINT [DF_TGD_GZSQ_TBR] DEFAULT ('') FOR [TBR],
CONSTRAINT [DF_TGD_GZSQ_SQSJ] DEFAULT ('') FOR [SQSJ],
CONSTRAINT [DF_TGD_GZSQ_SBMC] DEFAULT ('') FOR [SBMC],
CONSTRAINT [DF_TGD_GZSQ_GGXH] DEFAULT ('') FOR [GGXH],
CONSTRAINT [DF_TGD_GZSQ_SCCJ] DEFAULT ('') FOR [SCCJ],
CONSTRAINT [DF_TGD_GZSQ_SGSL] DEFAULT ('') FOR [SGSL],
CONSTRAINT [DF_TGD_GZSQ_SXZJ] DEFAULT (0) FOR [SXZJ],
CONSTRAINT [DF_TGD_GZSQ_LYYT] DEFAULT ('') FOR [LYYT],
CONSTRAINT [DF_TGD_GZSQ_SBTJ] DEFAULT ('') FOR [SBTJ],
CONSTRAINT [DF_TGD_GZSQ_JJXY] DEFAULT (0) FOR [JJXY],
CONSTRAINT [DF_TGD_GZSQ_SBSYL] DEFAULT (0) FOR [SBSYL],
CONSTRAINT [DF_TGD_GZSQ_NHS] DEFAULT (0) FOR [NHS],
CONSTRAINT [DF_TGD_GZSQ_YSBQK] DEFAULT ('') FOR [YSBQK],
CONSTRAINT [DF_TGD_GZSQ_ZRYJ] DEFAULT ('') FOR [ZRYJ],
CONSTRAINT [DF_TGD_GZSQ_SBKYJ] DEFAULT ('') FOR [SBKYJ],
CONSTRAINT [DF_TGD_GZSQ_LDSP] DEFAULT ('') FOR [LDSP],
CONSTRAINT [DF_TGD_GZSQ_PZWH] DEFAULT ('') FOR [PZWH],
CONSTRAINT [DF_TGD_GZSQ_BZ] DEFAULT ('') FOR [BZ]
;
ALTER TABLE [dbo].[TGD_KPMODE] WITH NOCHECK ADD
CONSTRAINT [DF_TGD_KPMODE_LCONTENT] DEFAULT ('') FOR [LCONTENT],
CONSTRAINT [DF__TGD_KPMOD__LENGT__5A4F643B] DEFAULT (0) FOR [LENGTH],
CONSTRAINT [DF_TGD_KPMODE_HGZL] DEFAULT (0) FOR [HGZL],
CONSTRAINT [PK_GD_KPMODE] PRIMARY KEY NONCLUSTERED
(
[VCFILENAME]
) ON [PRIMARY];
;
ALTER TABLE [dbo].[TGD_KPXM] WITH NOCHECK ADD
CONSTRAINT [DF_TGD_KPXM_BIAOM] DEFAULT ('') FOR [CBIAOM],
CONSTRAINT [DF_TGD_KPXM_XMMC] DEFAULT ('') FOR [XMMC],
CONSTRAINT [DF_TGD_KPXM_LX] DEFAULT (1) FOR [LX],
CONSTRAINT [DF_TGD_KPXM_BMMC] DEFAULT ('') FOR [BMMC],
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -