SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[kind4]') AND type in (N'U'))
BEGIN
CREATE TABLE [kind4](
	[ÄÚµå4] [char](2) NOT NULL CONSTRAINT [DF_kind4_ÄÚµå4]  DEFAULT (''),
	[°Å·¡Ã³±¸ºÐ] [char](10) NOT NULL CONSTRAINT [DF_kind4_°Å·¡Ã³±¸ºÐ]  DEFAULT (''),
 CONSTRAINT [PK_kind4] PRIMARY KEY CLUSTERED 
(
	[ÄÚµå4] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[oil_cal]') AND type in (N'U'))
BEGIN
CREATE TABLE [oil_cal](
	[tdate] [datetime] NOT NULL CONSTRAINT [DF_oil_cal_tdate]  DEFAULT (getdate()),
	[docuno] [char](10) NOT NULL CONSTRAINT [DF_oil_cal_docuno]  DEFAULT (''),
	[carno] [char](4) NOT NULL CONSTRAINT [DF_oil_cal_carno]  DEFAULT (''),
	[name] [char](15) NOT NULL CONSTRAINT [DF_oil_cal_name]  DEFAULT (''),
	[juniljego1] [numeric](10, 0) NOT NULL CONSTRAINT [DF_oil_cal_juniljego1]  DEFAULT ((0)),
	[juniljego2] [numeric](10, 0) NOT NULL CONSTRAINT [DF_oil_cal_juniljego2]  DEFAULT ((0)),
	[ipgo] [numeric](10, 0) NOT NULL CONSTRAINT [DF_oil_cal_ipgo]  DEFAULT ((0)),
	[chulgo] [numeric](10, 0) NOT NULL CONSTRAINT [DF_oil_cal_chulgo]  DEFAULT ((0)),
	[dangiljego] [numeric](10, 0) NOT NULL CONSTRAINT [DF_oil_cal_dangiljego]  DEFAULT ((0)),
	[kilo] [numeric](10, 0) NOT NULL CONSTRAINT [DF_oil_cal_kilo]  DEFAULT ((0)),
	[mulcha] [numeric](3, 0) NOT NULL CONSTRAINT [DF_oil_cal_mulcha]  DEFAULT ((0)),
	[debul] [numeric](3, 0) NOT NULL CONSTRAINT [DF_oil_cal_debul]  DEFAULT ((0)),
	[gibon] [numeric](3, 0) NOT NULL CONSTRAINT [DF_oil_cal_gibon]  DEFAULT ((0)),
	[abhedo] [numeric](3, 0) NOT NULL CONSTRAINT [DF_oil_cal_abhedo]  DEFAULT ((0)),
	[ilde] [numeric](3, 0) NOT NULL CONSTRAINT [DF_oil_cal_ilde]  DEFAULT ((0)),
	[hoijun] [numeric](3, 0) NOT NULL CONSTRAINT [DF_oil_cal_hoijun]  DEFAULT ((0)),
 CONSTRAINT [PK_oil_cal] PRIMARY KEY CLUSTERED 
(
	[docuno] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[g1_data]') AND type in (N'U'))
BEGIN
CREATE TABLE [g1_data](
	[bp1_code] [char](4) NOT NULL CONSTRAINT [DF_g1_data_bp1_code]  DEFAULT (''),
	[bp1_name] [char](30) NOT NULL CONSTRAINT [DF_g1_data_bp1_name]  DEFAULT (''),
	[g1_code] [char](8) NOT NULL CONSTRAINT [DF_g1_data_g1_code]  DEFAULT (''),
	[g1_name] [char](20) NOT NULL CONSTRAINT [DF_g1_data_g1_name]  DEFAULT (''),
	[g1_unit] [char](10) NOT NULL CONSTRAINT [DF_g1_data_g1_unit]  DEFAULT (''),
	[g1_gunit] [numeric](4, 0) NOT NULL CONSTRAINT [DF_g1_data_g1_gunit]  DEFAULT ((0)),
	[g2_code] [char](8) NOT NULL CONSTRAINT [DF_g1_data_g2_code]  DEFAULT (''),
	[g2_name] [char](20) NOT NULL CONSTRAINT [DF_g1_data_g2_name]  DEFAULT (''),
	[g2_unit] [char](10) NOT NULL CONSTRAINT [DF_g1_data_g2_unit]  DEFAULT (''),
	[g2_gunit] [numeric](4, 0) NOT NULL CONSTRAINT [DF_g1_data_g2_gunit]  DEFAULT ((0)),
	[g3_code] [char](8) NOT NULL CONSTRAINT [DF_g1_data_g3_code]  DEFAULT (''),
	[g3_name] [char](20) NOT NULL CONSTRAINT [DF_g1_data_g3_name]  DEFAULT (''),
	[g3_unit] [char](10) NOT NULL CONSTRAINT [DF_g1_data_g3_unit]  DEFAULT (''),
	[g3_gunit] [numeric](4, 0) NOT NULL CONSTRAINT [DF_g1_data_g3_gunit]  DEFAULT ((0)),
	[g4_code] [char](8) NOT NULL CONSTRAINT [DF_g1_data_g4_code]  DEFAULT (''),
	[g4_name] [char](20) NOT NULL CONSTRAINT [DF_g1_data_g4_name]  DEFAULT (''),
	[g4_unit] [char](10) NOT NULL CONSTRAINT [DF_g1_data_g4_unit]  DEFAULT (''),
	[g4_gunit] [numeric](4, 0) NOT NULL CONSTRAINT [DF_g1_data_g4_gunit]  DEFAULT ((0)),
	[s1_code] [char](8) NOT NULL CONSTRAINT [DF_g1_data_s1_code]  DEFAULT (''),
	[s1_name] [char](20) NOT NULL CONSTRAINT [DF_g1_data_s1_name]  DEFAULT (''),
	[s1_unit] [char](10) NOT NULL CONSTRAINT [DF_g1_data_s1_unit]  DEFAULT (''),
	[s1_gunit] [numeric](4, 0) NOT NULL CONSTRAINT [DF_g1_data_s1_gunit]  DEFAULT ((0)),
	[s2_code] [char](8) NOT NULL CONSTRAINT [DF_g1_data_s2_code]  DEFAULT (''),
	[s2_name] [char](20) NOT NULL CONSTRAINT [DF_g1_data_s2_name]  DEFAULT (''),
	[s2_unit] [char](10) NOT NULL CONSTRAINT [DF_g1_data_s2_unit]  DEFAULT (''),
	[s2_gunit] [numeric](4, 0) NOT NULL CONSTRAINT [DF_g1_data_s2_gunit]  DEFAULT ((0)),
	[s3_code] [char](8) NOT NULL CONSTRAINT [DF_g1_data_s3_code]  DEFAULT (''),
	[s3_name] [char](20) NOT NULL CONSTRAINT [DF_g1_data_s3_name]  DEFAULT (''),
	[s3_unit] [char](10) NOT NULL CONSTRAINT [DF_g1_data_s3_unit]  DEFAULT (''),
	[s3_gunit] [numeric](4, 0) NOT NULL CONSTRAINT [DF_g1_data_s3_gunit]  DEFAULT ((0)),
	[c1_code] [char](8) NOT NULL CONSTRAINT [DF_g1_data_c1_code]  DEFAULT (''),
	[c1_name] [char](20) NOT NULL CONSTRAINT [DF_g1_data_c1_name]  DEFAULT (''),
	[c1_unit] [char](10) NOT NULL CONSTRAINT [DF_g1_data_c1_unit]  DEFAULT (''),
	[c2_code] [char](8) NOT NULL CONSTRAINT [DF_g1_data_c2_code]  DEFAULT (''),
	[c2_name] [char](20) NOT NULL CONSTRAINT [DF_g1_data_c2_name]  DEFAULT (''),
	[c2_unit] [char](10) NOT NULL CONSTRAINT [DF_g1_data_c2_unit]  DEFAULT (''),
	[c3_code] [char](8) NOT NULL CONSTRAINT [DF_g1_data_c3_code]  DEFAULT (''),
	[c3_name] [char](20) NOT NULL CONSTRAINT [DF_g1_data_c3_name]  DEFAULT (''),
	[c3_unit] [char](10) NOT NULL CONSTRAINT [DF_g1_data_c3_unit]  DEFAULT (''),
	[a1_code] [char](8) NOT NULL CONSTRAINT [DF_g1_data_a1_code]  DEFAULT (''),
	[a1_name] [char](20) NOT NULL CONSTRAINT [DF_g1_data_a1_name]  DEFAULT (''),
	[a1_unit] [char](10) NOT NULL CONSTRAINT [DF_g1_data_a1_unit]  DEFAULT (''),
	[a2_code] [char](8) NOT NULL CONSTRAINT [DF_g1_data_a2_code]  DEFAULT (''),
	[a2_name] [char](20) NOT NULL CONSTRAINT [DF_g1_data_a2_name]  DEFAULT (''),
	[a2_unit] [char](10) NOT NULL CONSTRAINT [DF_g1_data_a2_unit]  DEFAULT (''),
	[a3_code] [char](8) NOT NULL CONSTRAINT [DF_g1_data_a3_code]  DEFAULT (''),
	[a3_name] [char](20) NOT NULL CONSTRAINT [DF_g1_data_a3_name]  DEFAULT (''),
	[a3_unit] [char](10) NOT NULL CONSTRAINT [DF_g1_data_a3_unit]  DEFAULT (''),
	[a4_code] [char](8) NOT NULL CONSTRAINT [DF_g1_data_a4_code]  DEFAULT (''),
	[a4_name] [char](20) NOT NULL CONSTRAINT [DF_g1_data_a4_name]  DEFAULT (''),
	[a4_unit] [char](10) NOT NULL CONSTRAINT [DF_g1_data_a4_unit]  DEFAULT ('')
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[mwonga1]') AND type in (N'U'))
BEGIN
CREATE TABLE [mwonga1](
	[docuno] [char](10) NOT NULL CONSTRAINT [DF_mwonga1_docuno]  DEFAULT (''),
	[jdate] [smalldatetime] NOT NULL CONSTRAINT [DF_mwonga1_jdate]  DEFAULT (getdate()),
	[kkgd] [numeric](3, 0) NOT NULL CONSTRAINT [DF_mwonga1_kkgd]  DEFAULT ((0)),
	[kindg] [char](8) NOT NULL CONSTRAINT [DF_mwonga1_kindg]  DEFAULT (''),
	[c1g] [numeric](8, 2) NOT NULL CONSTRAINT [DF_mwonga1_c1g]  DEFAULT ((0)),
	[c2g] [numeric](8, 2) NOT NULL CONSTRAINT [DF_mwonga1_c2g]  DEFAULT ((0)),
	[c3g] [numeric](8, 2) NOT NULL CONSTRAINT [DF_mwonga1_c3g]  DEFAULT ((0)),
	[s1g] [numeric](5, 0) NOT NULL CONSTRAINT [DF_mwonga1_s1g]  DEFAULT ((0)),
	[s2g] [numeric](5, 0) NOT NULL CONSTRAINT [DF_mwonga1_s2g]  DEFAULT ((0)),
	[g1g] [numeric](5, 0) NOT NULL CONSTRAINT [DF_mwonga1_g1g]  DEFAULT ((0)),
	[g2g] [numeric](5, 0) NOT NULL CONSTRAINT [DF_mwonga1_g2g]  DEFAULT ((0)),
	[g3g] [numeric](5, 0) NOT NULL CONSTRAINT [DF_mwonga1_g3g]  DEFAULT ((0)),
	[g4g] [numeric](5, 0) NOT NULL CONSTRAINT [DF_mwonga1_g4g]  DEFAULT ((0)),
	[ag] [numeric](8, 2) NOT NULL CONSTRAINT [DF_mwonga1_ag]  DEFAULT ((0)),
	[us1] [numeric](7, 2) NOT NULL CONSTRAINT [DF_mwonga1_us1]  DEFAULT ((0)),
	[us2] [numeric](7, 2) NOT NULL CONSTRAINT [DF_mwonga1_us2]  DEFAULT ((0)),
	[ug1] [numeric](7, 2) NOT NULL CONSTRAINT [DF_mwonga1_ug1]  DEFAULT ((0)),
	[ug2] [numeric](7, 2) NOT NULL CONSTRAINT [DF_mwonga1_ug2]  DEFAULT ((0)),
	[ug3] [numeric](7, 2) NOT NULL CONSTRAINT [DF_mwonga1_ug3]  DEFAULT ((0)),
	[ug4] [numeric](7, 2) NOT NULL CONSTRAINT [DF_mwonga1_ug4]  DEFAULT ((0)),
	[ag1] [numeric](8, 2) NOT NULL CONSTRAINT [DF_mwonga1_ag1]  DEFAULT ((0)),
	[ag2] [numeric](8, 2) NOT NULL CONSTRAINT [DF_mwonga1_ag2]  DEFAULT ((0)),
	[ag3] [numeric](8, 2) NOT NULL CONSTRAINT [DF_mwonga1_ag3]  DEFAULT ((0)),
	[msx] [char](1) NOT NULL CONSTRAINT [DF_mwonga1_msx]  DEFAULT (''),
	[sno] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mwonga1_sno]  DEFAULT ((0)),
	[type] [char](12) NOT NULL CONSTRAINT [DF_mwonga1_type]  DEFAULT (''),
	[s1] [char](4) NOT NULL CONSTRAINT [DF_mwonga1_s1]  DEFAULT (''),
	[s2] [char](4) NOT NULL CONSTRAINT [DF_mwonga1_s2]  DEFAULT (''),
	[s3] [char](4) NOT NULL CONSTRAINT [DF_mwonga1_s3]  DEFAULT (''),
	[s4] [char](4) NOT NULL CONSTRAINT [DF_mwonga1_s4]  DEFAULT (''),
	[s5] [char](4) NOT NULL CONSTRAINT [DF_mwonga1_s5]  DEFAULT (''),
	[s6] [char](4) NOT NULL CONSTRAINT [DF_mwonga1_s6]  DEFAULT (''),
	[s7] [char](4) NOT NULL CONSTRAINT [DF_mwonga1_s7]  DEFAULT (''),
	[s8] [char](4) NOT NULL CONSTRAINT [DF_mwonga1_s8]  DEFAULT (''),
	[s9] [char](4) NOT NULL CONSTRAINT [DF_mwonga1_s9]  DEFAULT (''),
	[s10] [char](5) NOT NULL CONSTRAINT [DF_mwonga1_s10]  DEFAULT (''),
	[s11] [char](5) NOT NULL CONSTRAINT [DF_mwonga1_s11]  DEFAULT (''),
	[s12] [char](5) NOT NULL CONSTRAINT [DF_mwonga1_s12]  DEFAULT (''),
	[s13] [char](5) NOT NULL CONSTRAINT [DF_mwonga1_s13]  DEFAULT (''),
	[san1] [char](11) NOT NULL CONSTRAINT [DF_mwonga1_san1]  DEFAULT (''),
	[san2] [char](11) NOT NULL CONSTRAINT [DF_mwonga1_san2]  DEFAULT (''),
	[san3] [char](11) NOT NULL CONSTRAINT [DF_mwonga1_san3]  DEFAULT (''),
	[san4] [char](11) NOT NULL CONSTRAINT [DF_mwonga1_san4]  DEFAULT (''),
	[san5] [char](11) NOT NULL CONSTRAINT [DF_mwonga1_san5]  DEFAULT (''),
	[san6] [char](11) NOT NULL CONSTRAINT [DF_mwonga1_san6]  DEFAULT (''),
	[san7] [char](11) NOT NULL CONSTRAINT [DF_mwonga1_san7]  DEFAULT (''),
	[san8] [char](11) NOT NULL CONSTRAINT [DF_mwonga1_san8]  DEFAULT (''),
	[san9] [char](11) NOT NULL CONSTRAINT [DF_mwonga1_san9]  DEFAULT (''),
	[san10] [char](11) NOT NULL CONSTRAINT [DF_mwonga1_san10]  DEFAULT (''),
	[san11] [char](11) NOT NULL CONSTRAINT [DF_mwonga1_san11]  DEFAULT (''),
	[san12] [char](11) NOT NULL CONSTRAINT [DF_mwonga1_san12]  DEFAULT (''),
	[san13] [char](11) NOT NULL CONSTRAINT [DF_mwonga1_san13]  DEFAULT ('')
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[mwonga]') AND type in (N'U'))
BEGIN
CREATE TABLE [mwonga](
	[docuno] [char](10) NOT NULL CONSTRAINT [DF_mwonga_docuno]  DEFAULT (' '),
	[jdate] [smalldatetime] NOT NULL CONSTRAINT [DF_mwonga_jdate]  DEFAULT (getdate()),
	[kkgd] [numeric](3, 0) NOT NULL CONSTRAINT [DF_mwonga_kkgd]  DEFAULT ((0)),
	[kindg] [char](8) NOT NULL CONSTRAINT [DF_mwonga_kindg]  DEFAULT (''),
	[c1g] [numeric](8, 2) NOT NULL CONSTRAINT [DF_mwonga_c1g]  DEFAULT ((0)),
	[c2g] [numeric](8, 2) NOT NULL CONSTRAINT [DF_mwonga_c2g]  DEFAULT ((0)),
	[c3g] [numeric](8, 2) NOT NULL CONSTRAINT [DF_mwonga_c3g]  DEFAULT ((0)),
	[s1g] [numeric](5, 0) NOT NULL CONSTRAINT [DF_mwonga_s1g]  DEFAULT ((0)),
	[s2g] [numeric](5, 0) NOT NULL CONSTRAINT [DF_mwonga_s2g]  DEFAULT ((0)),
	[g1g] [numeric](5, 0) NOT NULL CONSTRAINT [DF_mwonga_g1g]  DEFAULT ((0)),
	[g2g] [numeric](5, 0) NOT NULL CONSTRAINT [DF_mwonga_g2g]  DEFAULT ((0)),
	[g3g] [numeric](5, 0) NOT NULL CONSTRAINT [DF_mwonga_g3g]  DEFAULT ((0)),
	[g4g] [numeric](5, 0) NOT NULL CONSTRAINT [DF_mwonga_g4g]  DEFAULT ((0)),
	[ag] [numeric](8, 2) NOT NULL CONSTRAINT [DF_mwonga_ag]  DEFAULT ((0)),
	[us1] [numeric](7, 2) NOT NULL CONSTRAINT [DF_mwonga_us1]  DEFAULT ((0)),
	[us2] [numeric](7, 2) NOT NULL CONSTRAINT [DF_mwonga_us2]  DEFAULT ((0)),
	[ug1] [numeric](7, 2) NOT NULL CONSTRAINT [DF_mwonga_ug1]  DEFAULT ((0)),
	[ug2] [numeric](7, 2) NOT NULL CONSTRAINT [DF_mwonga_ug2]  DEFAULT ((0)),
	[ug3] [numeric](7, 2) NOT NULL CONSTRAINT [DF_mwonga_ug3]  DEFAULT ((0)),
	[ug4] [numeric](7, 2) NOT NULL CONSTRAINT [DF_mwonga_ug4]  DEFAULT ((0)),
	[ag1] [numeric](8, 2) NOT NULL CONSTRAINT [DF_mwonga_ag1]  DEFAULT ((0)),
	[ag2] [numeric](8, 2) NOT NULL CONSTRAINT [DF_mwonga_ag2]  DEFAULT ((0)),
	[ag3] [numeric](8, 2) NOT NULL CONSTRAINT [DF_mwonga_ag3]  DEFAULT ((0)),
	[msx] [char](1) NOT NULL CONSTRAINT [DF_mwonga_msx]  DEFAULT (''),
	[no] [numeric](3, 0) NOT NULL CONSTRAINT [DF_mwonga_no]  DEFAULT ((0)),
	[sno] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mwonga_sno]  DEFAULT ((0)),
	[type] [char](12) NOT NULL CONSTRAINT [DF_mwonga_type]  DEFAULT (''),
	[s1] [char](4) NOT NULL CONSTRAINT [DF_mwonga_s1]  DEFAULT (''),
	[s2] [char](4) NOT NULL CONSTRAINT [DF_mwonga_s2]  DEFAULT (''),
	[s3] [char](4) NOT NULL CONSTRAINT [DF_mwonga_s3]  DEFAULT (''),
	[s4] [char](4) NOT NULL CONSTRAINT [DF_mwonga_s4]  DEFAULT (''),
	[s5] [char](4) NOT NULL CONSTRAINT [DF_mwonga_s5]  DEFAULT (''),
	[s6] [char](4) NOT NULL CONSTRAINT [DF_mwonga_s6]  DEFAULT (''),
	[s7] [char](4) NOT NULL CONSTRAINT [DF_mwonga_s7]  DEFAULT (''),
	[s8] [char](4) NOT NULL CONSTRAINT [DF_mwonga_s8]  DEFAULT (''),
	[s9] [char](4) NOT NULL CONSTRAINT [DF_mwonga_s9]  DEFAULT (''),
	[s10] [char](5) NOT NULL CONSTRAINT [DF_mwonga_s10]  DEFAULT (''),
	[s11] [char](5) NOT NULL CONSTRAINT [DF_mwonga_s11]  DEFAULT (''),
	[s12] [char](5) NOT NULL CONSTRAINT [DF_mwonga_s12]  DEFAULT (''),
	[s13] [char](5) NOT NULL CONSTRAINT [DF_mwonga_s13]  DEFAULT (''),
	[san1] [char](11) NOT NULL CONSTRAINT [DF_mwonga_san1]  DEFAULT (''),
	[san2] [char](11) NOT NULL CONSTRAINT [DF_mwonga_san2]  DEFAULT (''),
	[san3] [char](11) NOT NULL CONSTRAINT [DF_mwonga_san3]  DEFAULT (''),
	[san4] [char](11) NOT NULL CONSTRAINT [DF_mwonga_san4]  DEFAULT (''),
	[san5] [char](11) NOT NULL CONSTRAINT [DF_mwonga_san5]  DEFAULT (''),
	[san6] [char](11) NOT NULL CONSTRAINT [DF_mwonga_san6]  DEFAULT (''),
	[san7] [char](11) NOT NULL CONSTRAINT [DF_mwonga_san7]  DEFAULT (''),
	[san8] [char](11) NOT NULL CONSTRAINT [DF_mwonga_san8]  DEFAULT (''),
	[san9] [char](11) NOT NULL CONSTRAINT [DF_mwonga_san9]  DEFAULT (''),
	[san10] [char](11) NOT NULL CONSTRAINT [DF_mwonga_san10]  DEFAULT (''),
	[san11] [char](11) NOT NULL CONSTRAINT [DF_mwonga_san11]  DEFAULT (''),
	[san12] [char](11) NOT NULL CONSTRAINT [DF_mwonga_san12]  DEFAULT (''),
	[san13] [char](11) NOT NULL CONSTRAINT [DF_mwonga_san13]  DEFAULT (''),
 CONSTRAINT [PK_mwonga] PRIMARY KEY CLUSTERED 
(
	[docuno] ASC,
	[no] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[jego330]') AND type in (N'U'))
BEGIN
CREATE TABLE [jego330](
	[k33_date] [smalldatetime] NOT NULL CONSTRAINT [DF_jego330_k33_date]  DEFAULT (getdate()),
	[k33_code] [char](11) NOT NULL CONSTRAINT [DF_jego330_k33_code]  DEFAULT (' '),
	[k33_inven] [char](20) NOT NULL CONSTRAINT [DF_jego330_k33_inven]  DEFAULT (' '),
	[k33_i_qty] [numeric](9, 3) NOT NULL CONSTRAINT [DF_jego330_k33_i_qty]  DEFAULT ((0)),
	[k33_o_qty] [numeric](9, 3) NOT NULL CONSTRAINT [DF_jego330_k33_o_qty]  DEFAULT ((0)),
	[k33_pri] [numeric](9, 0) NOT NULL CONSTRAINT [DF_jego330_k33_pri]  DEFAULT ((0)),
	[k33_unit] [char](10) NOT NULL CONSTRAINT [DF_jego330_k33_unit]  DEFAULT (' '),
	[k33_size] [char](10) NOT NULL CONSTRAINT [DF_jego330_k33_size]  DEFAULT (' '),
	[k33_ÀüÀÏÀÔ°í] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego330_k33_ÀüÀÏÀÔ°í]  DEFAULT ((0)),
	[k33_ÀüÀÏÃâ°í] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego330_k33_ÀüÀÏÃâ°í]  DEFAULT ((0)),
 CONSTRAINT [PK_jego330] PRIMARY KEY CLUSTERED 
(
	[k33_date] ASC,
	[k33_code] ASC,
	[k33_pri] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[jego120]') AND type in (N'U'))
BEGIN
CREATE TABLE [jego120](
	[k2_code] [char](4) NOT NULL CONSTRAINT [DF_jego120_k2_code]  DEFAULT (' '),
	[k2_company] [char](30) NOT NULL CONSTRAINT [DF_jego120_k2_company]  DEFAULT (' '),
	[k2_gubun] [char](5) NOT NULL CONSTRAINT [DF_jego120_k2_gubun]  DEFAULT (' '),
	[k2_name] [char](20) NOT NULL CONSTRAINT [DF_jego120_k2_name]  DEFAULT (' '),
	[k2_cno] [char](12) NOT NULL CONSTRAINT [DF_jego120_k2_cno]  DEFAULT (' '),
	[k2_caddr] [char](50) NOT NULL CONSTRAINT [DF_jego120_k2_caddr]  DEFAULT (' '),
	[k2_uptae] [char](20) NOT NULL CONSTRAINT [DF_jego120_k2_uptae]  DEFAULT (' '),
	[k2_jong] [char](20) NOT NULL CONSTRAINT [DF_jego120_k2_jong]  DEFAULT (' '),
	[k2_ctel] [char](19) NOT NULL CONSTRAINT [DF_jego120_k2_ctel]  DEFAULT (' '),
	[k2_cfax] [char](14) NOT NULL CONSTRAINT [DF_jego120_k2_cfax]  DEFAULT (' '),
	[k2_cpost] [char](7) NOT NULL CONSTRAINT [DF_jego120_k2_cpost]  DEFAULT (' '),
	[k2_bb] [char](12) NOT NULL CONSTRAINT [DF_jego120_k2_bb]  DEFAULT (' '),
	[k2_hp] [char](12) NOT NULL CONSTRAINT [DF_jego120_k2_hp]  DEFAULT (' '),
	[k2_remk] [char](30) NOT NULL CONSTRAINT [DF_jego120_k2_remk]  DEFAULT (' '),
	[k2_jumin] [char](14) NOT NULL CONSTRAINT [DF_jego120_k2_jumin]  DEFAULT (' '),
	[k2_i_amt00] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_i_amt00]  DEFAULT ((0)),
	[k2_i_amt01] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_i_amt01]  DEFAULT ((0)),
	[k2_i_amt02] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_i_amt02]  DEFAULT ((0)),
	[k2_i_amt03] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_i_amt03]  DEFAULT ((0)),
	[k2_i_amt04] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_i_amt04]  DEFAULT ((0)),
	[k2_i_amt05] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_i_amt05]  DEFAULT ((0)),
	[k2_i_amt06] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_i_amt06]  DEFAULT ((0)),
	[k2_i_amt07] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_i_amt07]  DEFAULT ((0)),
	[k2_i_amt08] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_i_amt08]  DEFAULT ((0)),
	[k2_i_amt09] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_i_amt09]  DEFAULT ((0)),
	[k2_i_amt10] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_i_amt10]  DEFAULT ((0)),
	[k2_i_amt11] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_i_amt11]  DEFAULT ((0)),
	[k2_i_amt12] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_i_amt12]  DEFAULT ((0)),
	[k2_o_amt00] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_o_amt00]  DEFAULT ((0)),
	[k2_o_amt01] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_o_amt01]  DEFAULT ((0)),
	[k2_o_amt02] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_o_amt02]  DEFAULT ((0)),
	[k2_o_amt03] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_o_amt03]  DEFAULT ((0)),
	[k2_o_amt04] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_o_amt04]  DEFAULT ((0)),
	[k2_o_amt05] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_o_amt05]  DEFAULT ((0)),
	[k2_o_amt06] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_o_amt06]  DEFAULT ((0)),
	[k2_o_amt07] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_o_amt07]  DEFAULT ((0)),
	[k2_o_amt08] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_o_amt08]  DEFAULT ((0)),
	[k2_o_amt09] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_o_amt09]  DEFAULT ((0)),
	[k2_o_amt10] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_o_amt10]  DEFAULT ((0)),
	[k2_o_amt11] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_o_amt11]  DEFAULT ((0)),
	[k2_o_amt12] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego120_k2_o_amt12]  DEFAULT ((0)),
	[k2_o_qty00] [numeric](9, 1) NOT NULL CONSTRAINT [DF_jego120_k2_o_qty00]  DEFAULT ((0)),
	[k2_o_qty01] [numeric](9, 1) NOT NULL CONSTRAINT [DF_jego120_k2_o_qty01]  DEFAULT ((0)),
	[k2_o_qty02] [numeric](9, 1) NOT NULL CONSTRAINT [DF_jego120_k2_o_qty02]  DEFAULT ((0)),
	[k2_o_qty03] [numeric](9, 1) NOT NULL CONSTRAINT [DF_jego120_k2_o_qty03]  DEFAULT ((0)),
	[k2_o_qty04] [numeric](9, 1) NOT NULL CONSTRAINT [DF_jego120_k2_o_qty04]  DEFAULT ((0)),
	[k2_o_qty05] [numeric](9, 1) NOT NULL CONSTRAINT [DF_jego120_k2_o_qty05]  DEFAULT ((0)),
	[k2_o_qty06] [numeric](9, 1) NOT NULL CONSTRAINT [DF_jego120_k2_o_qty06]  DEFAULT ((0)),
	[k2_o_qty07] [numeric](9, 1) NOT NULL CONSTRAINT [DF_jego120_k2_o_qty07]  DEFAULT ((0)),
	[k2_o_qty08] [numeric](9, 1) NOT NULL CONSTRAINT [DF_jego120_k2_o_qty08]  DEFAULT ((0)),
	[k2_o_qty09] [numeric](9, 1) NOT NULL CONSTRAINT [DF_jego120_k2_o_qty09]  DEFAULT ((0)),
	[k2_o_qty10] [numeric](9, 1) NOT NULL CONSTRAINT [DF_jego120_k2_o_qty10]  DEFAULT ((0)),
	[k2_o_qty11] [numeric](9, 1) NOT NULL CONSTRAINT [DF_jego120_k2_o_qty11]  DEFAULT ((0)),
	[k2_o_qty12] [numeric](9, 1) NOT NULL CONSTRAINT [DF_jego120_k2_o_qty12]  DEFAULT ((0)),
	[k2_misu00] [numeric](12, 1) NOT NULL CONSTRAINT [DF_jego120_k2_misu00]  DEFAULT ((0)),
	[k2_gb] [char](2) NOT NULL CONSTRAINT [DF_jego120_k2_gb]  DEFAULT (' ')
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[jego110]') AND type in (N'U'))
BEGIN
CREATE TABLE [jego110](
	[k1_code1] [char](2) NOT NULL CONSTRAINT [DF_jego110_k1_code1]  DEFAULT (' '),
	[k1_code2] [char](2) NOT NULL CONSTRAINT [DF_jego110_k1_code2]  DEFAULT (' '),
	[k1_code3] [char](4) NOT NULL CONSTRAINT [DF_jego110_k1_code3]  DEFAULT (' '),
	[k1_inven] [char](20) NOT NULL CONSTRAINT [DF_jego110_k1_inven]  DEFAULT (' '),
	[k1_size] [char](20) NOT NULL CONSTRAINT [DF_jego110_k1_size]  DEFAULT (' '),
	[k1_unit] [char](10) NOT NULL CONSTRAINT [DF_jego110_k1_unit]  DEFAULT (' '),
	[k1_pri] [numeric](9, 2) NOT NULL CONSTRAINT [DF_jego110_k1_pri]  DEFAULT ((0)),
	[k1_remk] [char](30) NOT NULL CONSTRAINT [DF_jego110_k1_remk]  DEFAULT (' '),
	[k1_qty00] [numeric](11, 3) NOT NULL CONSTRAINT [DF_jego110_k1_qty00]  DEFAULT ((0)),
	[k1_i_qty00] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_i_qty00]  DEFAULT ((0)),
	[k1_i_qty01] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_i_qty01]  DEFAULT ((0)),
	[k1_i_qty02] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_i_qty02]  DEFAULT ((0)),
	[k1_i_qty03] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_i_qty03]  DEFAULT ((0)),
	[k1_i_qty04] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_i_qty04]  DEFAULT ((0)),
	[k1_i_qty05] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_i_qty05]  DEFAULT ((0)),
	[k1_i_qty06] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_i_qty06]  DEFAULT ((0)),
	[k1_i_qty07] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_i_qty07]  DEFAULT ((0)),
	[k1_i_qty08] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_i_qty08]  DEFAULT ((0)),
	[k1_i_qty09] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_i_qty09]  DEFAULT ((0)),
	[k1_i_qty10] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_i_qty10]  DEFAULT ((0)),
	[k1_i_qty11] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_i_qty11]  DEFAULT ((0)),
	[k1_i_qty12] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_i_qty12]  DEFAULT ((0)),
	[k1_o_qty00] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_o_qty00]  DEFAULT ((0)),
	[k1_o_qty01] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_o_qty01]  DEFAULT ((0)),
	[k1_o_qty02] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_o_qty02]  DEFAULT ((0)),
	[k1_o_qty03] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_o_qty03]  DEFAULT ((0)),
	[k1_o_qty04] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_o_qty04]  DEFAULT ((0)),
	[k1_o_qty05] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_o_qty05]  DEFAULT ((0)),
	[k1_o_qty06] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_o_qty06]  DEFAULT ((0)),
	[k1_o_qty07] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_o_qty07]  DEFAULT ((0)),
	[k1_o_qty08] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_o_qty08]  DEFAULT ((0)),
	[k1_o_qty09] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_o_qty09]  DEFAULT ((0)),
	[k1_o_qty10] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_o_qty10]  DEFAULT ((0)),
	[k1_o_qty11] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_o_qty11]  DEFAULT ((0)),
	[k1_o_qty12] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego110_k1_o_qty12]  DEFAULT ((0)),
	[¹ýÀÎÄÚµå] [char](3) NOT NULL CONSTRAINT [DF_jego110_¹ýÀÎÄÚµå]  DEFAULT (''),
	[°øÀåÄÚµå] [char](3) NOT NULL CONSTRAINT [DF_jego110_°øÀåÄÚµå]  DEFAULT ('')
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[staff]') AND type in (N'U'))
BEGIN
CREATE TABLE [staff](
	[»ç¿øÄÚµå] [char](9) NOT NULL CONSTRAINT [DF_staff_»ç¿øÄÚµå]  DEFAULT (''),
	[´ã´çÁ÷¿ø¸í] [char](8) NOT NULL CONSTRAINT [DF_staff_´ã´çÁ÷¿ø¸í]  DEFAULT (''),
	[password] [char](6) NOT NULL CONSTRAINT [DF_staff_password]  DEFAULT (''),
	[level_] [char](1) NOT NULL CONSTRAINT [DF_staff_level_]  DEFAULT (''),
 CONSTRAINT [PK_staff] PRIMARY KEY CLUSTERED 
(
	[»ç¿øÄÚµå] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[fday]') AND type in (N'U'))
BEGIN
CREATE TABLE [fday](
	[sday] [smalldatetime] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[mdesign]') AND type in (N'U'))
BEGIN
CREATE TABLE [mdesign](
	[msx] [char](3) NOT NULL CONSTRAINT [DF_mdesign_msx]  DEFAULT (' '),
	[code] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mdesign_code]  DEFAULT ((0)),
	[gmax] [char](2) NOT NULL CONSTRAINT [DF_mdesign_gmax]  DEFAULT (' '),
	[hcgd] [numeric](3, 0) NOT NULL CONSTRAINT [DF_mdesign_hcgd]  DEFAULT ((0)),
	[slmp] [numeric](3, 0) NOT NULL CONSTRAINT [DF_mdesign_slmp]  DEFAULT ((0)),
	[g40] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mdesign_g40]  DEFAULT ((0)),
	[g25] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mdesign_g25]  DEFAULT ((0)),
	[g19] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mdesign_g19]  DEFAULT ((0)),
	[g13] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mdesign_g13]  DEFAULT ((0)),
	[sand] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mdesign_sand]  DEFAULT ((0)),
	[sand2] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mdesign_sand2]  DEFAULT ((0)),
	[cement] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mdesign_cement]  DEFAULT ((0)),
	[cement2] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mdesign_cement2]  DEFAULT ((0)),
	[water] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mdesign_water]  DEFAULT ((0)),
	[water2] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mdesign_water2]  DEFAULT ((0)),
	[adm] [numeric](5, 2) NOT NULL CONSTRAINT [DF_mdesign_adm]  DEFAULT ((0)),
	[adm1] [numeric](5, 2) NOT NULL CONSTRAINT [DF_mdesign_adm1]  DEFAULT ((0)),
	[adm2] [numeric](5, 2) NOT NULL CONSTRAINT [DF_mdesign_adm2]  DEFAULT ((0)),
	[adm3] [numeric](5, 2) NOT NULL CONSTRAINT [DF_mdesign_adm3]  DEFAULT ((0)),
	[cement3] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mdesign_cement3]  DEFAULT ((0)),
	[g44] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mdesign_g44]  DEFAULT ((0)),
	[sand3] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mdesign_sand3]  DEFAULT ((0)),
	[utw] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mdesign_utw]  DEFAULT ((0)),
	[wc] [numeric](4, 1) NOT NULL CONSTRAINT [DF_mdesign_wc]  DEFAULT ((0)),
	[sa] [numeric](4, 1) NOT NULL CONSTRAINT [DF_mdesign_sa]  DEFAULT ((0)),
	[mname] [char](10) NOT NULL CONSTRAINT [DF_mdesign_mname]  DEFAULT (' '),
	[hhsy] [numeric](4, 1) NOT NULL CONSTRAINT [DF_mdesign_hhsy]  DEFAULT ((0)),
	[bdgs] [numeric](4, 2) NOT NULL CONSTRAINT [DF_mdesign_bdgs]  DEFAULT ((0)),
	[mc1] [numeric](4, 1) NOT NULL CONSTRAINT [DF_mdesign_mc1]  DEFAULT ((0)),
	[mabw] [numeric](4, 1) NOT NULL CONSTRAINT [DF_mdesign_mabw]  DEFAULT ((0)),
	[mbsa] [numeric](4, 1) NOT NULL CONSTRAINT [DF_mdesign_mbsa]  DEFAULT ((0)),
	[psa] [numeric](4, 1) NOT NULL CONSTRAINT [DF_mdesign_psa]  DEFAULT ((0)),
	[mw] [numeric](4, 1) NOT NULL CONSTRAINT [DF_mdesign_mw]  DEFAULT ((0)),
	[mabsa] [numeric](4, 1) NOT NULL CONSTRAINT [DF_mdesign_mabsa]  DEFAULT ((0)),
	[adm4] [numeric](5, 2) NOT NULL CONSTRAINT [DF_mdesign_adm4]  DEFAULT ((0)),
	[adm5] [numeric](5, 2) NOT NULL CONSTRAINT [DF_mdesign_adm5]  DEFAULT ((0)),
	[adm6] [numeric](5, 2) NOT NULL CONSTRAINT [DF_mdesign_adm6]  DEFAULT ((0)),
	[adm7] [numeric](5, 2) NOT NULL CONSTRAINT [DF_mdesign_adm7]  DEFAULT ((0)),
	[adm8] [numeric](5, 2) NOT NULL CONSTRAINT [DF_mdesign_adm8]  DEFAULT ((0)),
	[adm9] [numeric](5, 2) NOT NULL CONSTRAINT [DF_mdesign_adm9]  DEFAULT ((0)),
	[mmult] [numeric](3, 0) NOT NULL CONSTRAINT [DF_mdesign_mmult]  DEFAULT ((0)),
	[mmult1] [numeric](3, 0) NOT NULL CONSTRAINT [DF_mdesign_mmult1]  DEFAULT ((0)),
	[mmult2] [numeric](3, 0) NOT NULL CONSTRAINT [DF_mdesign_mmult2]  DEFAULT ((0)),
	[mmult3] [numeric](3, 0) NOT NULL CONSTRAINT [DF_mdesign_mmult3]  DEFAULT ((0)),
	[mmult4] [numeric](3, 0) NOT NULL CONSTRAINT [DF_mdesign_mmult4]  DEFAULT ((0)),
	[mmult5] [numeric](3, 0) NOT NULL CONSTRAINT [DF_mdesign_mmult5]  DEFAULT ((0)),
	[mmult6] [numeric](3, 0) NOT NULL CONSTRAINT [DF_mdesign_mmult6]  DEFAULT ((0)),
	[mmult7] [numeric](3, 0) NOT NULL CONSTRAINT [DF_mdesign_mmult7]  DEFAULT ((0)),
	[mmult8] [numeric](3, 0) NOT NULL CONSTRAINT [DF_mdesign_mmult8]  DEFAULT ((0)),
	[mmult9] [numeric](3, 0) NOT NULL CONSTRAINT [DF_mdesign_mmult9]  DEFAULT ((0)),
	[type] [char](12) NOT NULL CONSTRAINT [DF_mdesign_type]  DEFAULT (''),
	[gol1] [numeric](5, 0) NOT NULL CONSTRAINT [DF_mdesign_gol1]  DEFAULT ((0)),
	[gol2] [numeric](5, 0) NOT NULL CONSTRAINT [DF_mdesign_gol2]  DEFAULT ((0)),
	[gol3] [numeric](5, 0) NOT NULL CONSTRAINT [DF_mdesign_gol3]  DEFAULT ((0)),
	[gol4] [numeric](5, 0) NOT NULL CONSTRAINT [DF_mdesign_gol4]  DEFAULT ((0)),
	[ks_gu] [char](1) NOT NULL CONSTRAINT [DF_mdesign_ks_gu]  DEFAULT (''),
	[ad_gu] [char](10) NOT NULL CONSTRAINT [DF_mdesign_ad_gu]  DEFAULT (''),
	[ad_sei] [numeric](3, 0) NOT NULL CONSTRAINT [DF_mdesign_ad_sei]  DEFAULT ((0))
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[kind1]') AND type in (N'U'))
BEGIN
CREATE TABLE [kind1](
	[ÄÚµå1] [char](2) NOT NULL CONSTRAINT [DF_kind1_ÄÚµå1]  DEFAULT (''),
	[´ëºÐ·ùÀ̸§] [char](10) NOT NULL CONSTRAINT [DF_kind1_´ëºÐ·ùÀ̸§]  DEFAULT (''),
 CONSTRAINT [PK_kind1] PRIMARY KEY CLUSTERED 
(
	[ÄÚµå1] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[kind3]') AND type in (N'U'))
BEGIN
CREATE TABLE [kind3](
	[ÄÚµå3] [char](2) NOT NULL CONSTRAINT [DF_kind3_ÄÚµå3]  DEFAULT (''),
	[¼ÒºÐ·ùÀ̸§] [char](10) NOT NULL CONSTRAINT [DF_kind3_¼ÒºÐ·ùÀ̸§]  DEFAULT (''),
 CONSTRAINT [PK_kind3] PRIMARY KEY CLUSTERED 
(
	[ÄÚµå3] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[kind2]') AND type in (N'U'))
BEGIN
CREATE TABLE [kind2](
	[ÄÚµå2] [char](2) NOT NULL CONSTRAINT [DF_kind2_ÄÚµå2]  DEFAULT (''),
	[ÁߺзùÀ̸§] [char](10) NOT NULL CONSTRAINT [DF_kind2_ÁߺзùÀ̸§]  DEFAULT (''),
	[ÀÚÀçÀ̸§] [nchar](10) NULL,
 CONSTRAINT [PK_kind2] PRIMARY KEY CLUSTERED 
(
	[ÄÚµå2] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[inwon]') AND type in (N'U'))
BEGIN
CREATE TABLE [inwon](
	[tdate] [datetime] NOT NULL CONSTRAINT [DF_inwon_tdate]  DEFAULT (getdate()),
	[chongwon] [numeric](4, 0) NOT NULL CONSTRAINT [DF_inwon_chongwon]  DEFAULT ((0)),
	[hyunjae] [numeric](4, 0) NOT NULL CONSTRAINT [DF_inwon_hyunjae]  DEFAULT ((0)),
	[chuljang] [numeric](4, 0) NOT NULL CONSTRAINT [DF_inwon_chuljang]  DEFAULT ((0)),
	[byongga] [numeric](4, 0) NOT NULL CONSTRAINT [DF_inwon_byongga]  DEFAULT ((0)),
	[hyuga] [numeric](4, 0) NOT NULL CONSTRAINT [DF_inwon_hyuga]  DEFAULT ((0)),
	[gita] [numeric](4, 0) NOT NULL CONSTRAINT [DF_inwon_gita]  DEFAULT ((0)),
	[ilge1] [numeric](10, 2) NOT NULL CONSTRAINT [DF_inwon_ilge1]  DEFAULT ((0)),
	[ilge2] [numeric](10, 2) NOT NULL CONSTRAINT [DF_inwon_ilge2]  DEFAULT ((0)),
	[wolge1] [numeric](10, 2) NOT NULL CONSTRAINT [DF_inwon_wolge1]  DEFAULT ((0)),
	[wolge2] [numeric](10, 2) NOT NULL CONSTRAINT [DF_inwon_wolge2]  DEFAULT ((0)),
	[nuge1] [numeric](10, 2) NOT NULL CONSTRAINT [DF_inwon_nuge1]  DEFAULT ((0)),
	[nuge2] [numeric](10, 2) NOT NULL CONSTRAINT [DF_inwon_nuge2]  DEFAULT ((0)),
 CONSTRAINT [PK_inwon_1] PRIMARY KEY CLUSTERED 
(
	[tdate] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[agg40]') AND type in (N'U'))
BEGIN
CREATE TABLE [agg40](
	[docuno] [char](10) NOT NULL CONSTRAINT [DF_agg40_docuno]  DEFAULT (''),
	[tno] [char](12) NOT NULL CONSTRAINT [DF_agg40_tno]  DEFAULT (''),
	[cdate] [smalldatetime] NOT NULL CONSTRAINT [DF_agg40_cdate]  DEFAULT (getdate()),
	[tdate] [smalldatetime] NOT NULL CONSTRAINT [DF_agg40_tdate]  DEFAULT (getdate()),
	[m_code] [char](4) NOT NULL CONSTRAINT [DF_agg40_m_code]  DEFAULT (''),
	[man] [char](12) NOT NULL CONSTRAINT [DF_agg40_man]  DEFAULT (''),
	[hman] [char](12) NOT NULL CONSTRAINT [DF_agg40_hman]  DEFAULT (''),
	[h_code] [char](4) NOT NULL CONSTRAINT [DF_agg40_h_code]  DEFAULT (''),
	[cman] [char](12) NOT NULL CONSTRAINT [DF_agg40_cman]  DEFAULT (''),
	[c_code] [char](4) NOT NULL CONSTRAINT [DF_agg40_c_code]  DEFAULT (''),
	[sanji] [char](12) NOT NULL CONSTRAINT [DF_agg40_sanji]  DEFAULT (''),
	[sa_code] [char](4) NOT NULL CONSTRAINT [DF_agg40_sa_code]  DEFAULT (''),
	[chae] [char](15) NOT NULL CONSTRAINT [DF_agg40_chae]  DEFAULT (''),
	[j_code] [char](10) NOT NULL CONSTRAINT [DF_agg40_j_code]  DEFAULT (''),
	[agg] [char](8) NOT NULL CONSTRAINT [DF_agg40_agg]  DEFAULT (''),
	[gswt1] [numeric](6, 1) NOT NULL CONSTRAINT [DF_agg40_gswt1]  DEFAULT ((0)),
	[gcsw1] [numeric](6, 1) NOT NULL CONSTRAINT [DF_agg40_gcsw1]  DEFAULT ((0)),
	[cwt1] [numeric](6, 1) NOT NULL CONSTRAINT [DF_agg40_cwt1]  DEFAULT ((0)),
	[dswt1] [numeric](6, 1) NOT NULL CONSTRAINT [DF_agg40_dswt1]  DEFAULT ((0)),
	[gswt2] [numeric](6, 1) NOT NULL CONSTRAINT [DF_agg40_gswt2]  DEFAULT ((0)),
	[gcsw2] [numeric](6, 1) NOT NULL CONSTRAINT [DF_agg40_gcsw2]  DEFAULT ((0)),
	[cwt2] [numeric](6, 1) NOT NULL CONSTRAINT [DF_agg40_cwt2]  DEFAULT ((0)),
	[dswt2] [numeric](6, 1) NOT NULL CONSTRAINT [DF_agg40_dswt2]  DEFAULT ((0)),
	[gibiju] [numeric](5, 2) NOT NULL CONSTRAINT [DF_agg40_gibiju]  DEFAULT ((0)),
	[gihub] [numeric](5, 2) NOT NULL CONSTRAINT [DF_agg40_gihub]  DEFAULT ((0)),
	[gibi] [numeric](4, 2) NOT NULL CONSTRAINT [DF_agg40_gibi]  DEFAULT ((0)),
	[gih] [numeric](4, 2) NOT NULL CONSTRAINT [DF_agg40_gih]  DEFAULT ((0)),
	[hubiju] [numeric](4, 2) NOT NULL CONSTRAINT [DF_agg40_hubiju]  DEFAULT ((0)),
	[huhub] [numeric](4, 2) NOT NULL CONSTRAINT [DF_agg40_huhub]  DEFAULT ((0)),
	[code] [char](3) NOT NULL CONSTRAINT [DF_agg40_code]  DEFAULT (''),
	[bijung1] [numeric](5, 2) NOT NULL CONSTRAINT [DF_agg40_bijung1]  DEFAULT ((0)),
	[bijung11] [numeric](5, 2) NOT NULL CONSTRAINT [DF_agg40_bijung11]  DEFAULT ((0)),
	[hubsu1] [numeric](5, 2) NOT NULL CONSTRAINT [DF_agg40_hubsu1]  DEFAULT ((0)),
	[bijung2] [numeric](5, 2) NOT NULL CONSTRAINT [DF_agg40_bijung2]  DEFAULT ((0)),
	[bijung12] [numeric](5, 2) NOT NULL CONSTRAINT [DF_agg40_bijung12]  DEFAULT ((0)),
	[bijung21] [numeric](5, 2) NOT NULL CONSTRAINT [DF_agg40_bijung21]  DEFAULT ((0)),
	[bijung22] [numeric](5, 2) NOT NULL CONSTRAINT [DF_agg40_bijung22]  DEFAULT ((0)),
	[hubsu2] [numeric](5, 2) NOT NULL CONSTRAINT [DF_agg40_hubsu2]  DEFAULT ((0)),
	[nap_code] [char](4) NOT NULL CONSTRAINT [DF_agg40_nap_code]  DEFAULT (''),
	[nap] [char](40) NOT NULL CONSTRAINT [DF_agg40_nap]  DEFAULT (''),
	[ndate] [smalldatetime] NOT NULL CONSTRAINT [DF_agg40_ndate]  DEFAULT (getdate()),
	[ndate1] [smalldatetime] NOT NULL CONSTRAINT [DF_agg40_ndate1]  DEFAULT (getdate()),
	[jangso] [char](10) NOT NULL CONSTRAINT [DF_agg40_jangso]  DEFAULT (''),
	[lot] [char](12) NOT NULL CONSTRAINT [DF_agg40_lot]  DEFAULT (''),
	[agg40] [char](18) NOT NULL CONSTRAINT [DF_agg40_agg40]  DEFAULT (''),
	[jong] [char](2) NOT NULL CONSTRAINT [DF_agg40_jong]  DEFAULT (''),
 CONSTRAINT [PK_agg40] PRIMARY KEY CLUSTERED 
(
	[docuno] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[logbook]') AND type in (N'U'))
BEGIN
CREATE TABLE [logbook](
	[lognum] [numeric](10, 0) NOT NULL CONSTRAINT [DF_logbook_lognum]  DEFAULT ((0)),
	[daytime] [smalldatetime] NOT NULL CONSTRAINT [DF_logbook_daytime]  DEFAULT (getdate()),
	[»ç¿øÄÚµå] [char](9) NOT NULL CONSTRAINT [DF_logbook_»ç¿øÄÚµå]  DEFAULT (''),
	[´ã´çÁ÷¿ø¸í] [char](8) NOT NULL CONSTRAINT [DF_logbook_´ã´çÁ÷¿ø¸í]  DEFAULT (''),
	[level_] [char](1) NOT NULL CONSTRAINT [DF_logbook_level_]  DEFAULT ('')
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[sengsan]') AND type in (N'U'))
BEGIN
CREATE TABLE [sengsan](
	[docuno] [char](10) NOT NULL CONSTRAINT [DF_sengsan_docuno]  DEFAULT (' '),
	[tno] [char](12) NOT NULL CONSTRAINT [DF_sengsan_tno]  DEFAULT (' '),
	[tdate] [datetime] NOT NULL CONSTRAINT [DF_sengsan_tdate]  DEFAULT (getdate()),
	[msx] [char](1) NOT NULL CONSTRAINT [DF_sengsan_msx]  DEFAULT (' '),
	[sno] [numeric](5, 0) NOT NULL CONSTRAINT [DF_sengsan_sno]  DEFAULT ((0)),
	[m3] [numeric](7, 2) NOT NULL CONSTRAINT [DF_sengsan_m3]  DEFAULT ((0)),
	[ic2] [numeric](12, 2) NOT NULL CONSTRAINT [DF_sengsan_ic2]  DEFAULT ((0)),
	[ic] [numeric](12, 2) NOT NULL CONSTRAINT [DF_sengsan_ic]  DEFAULT ((0)),
	[ic1] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ic1]  DEFAULT ((0)),
	[ips1] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_is_]  DEFAULT ((0)),
	[is1] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_is1]  DEFAULT ((0)),
	[is2] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_is2]  DEFAULT ((0)),
	[i5] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_i5]  DEFAULT ((0)),
	[i19] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_i19]  DEFAULT ((0)),
	[i4] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_i4]  DEFAULT ((0)),
	[i13] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_i13]  DEFAULT ((0)),
	[ia1] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ia1]  DEFAULT ((0)),
	[ia] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ia]  DEFAULT ((0)),
	[ia2] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ia2]  DEFAULT ((0)),
	[ia3] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ia3]  DEFAULT ((0)),
	[ia4] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ia4]  DEFAULT ((0)),
	[h] [numeric](5, 2) NOT NULL CONSTRAINT [DF_sengsan_h]  DEFAULT ((0)),
	[v] [numeric](7, 2) NOT NULL CONSTRAINT [DF_sengsan_v]  DEFAULT ((0)),
	[nh] [numeric](7, 2) NOT NULL CONSTRAINT [DF_sengsan_nh]  DEFAULT ((0)),
	[np] [numeric](9, 2) NOT NULL CONSTRAINT [DF_sengsan_np]  DEFAULT ((0)),
	[nw] [numeric](9, 2) NOT NULL CONSTRAINT [DF_sengsan_nw]  DEFAULT ((0)),
	[gul41] [numeric](4, 1) NOT NULL CONSTRAINT [DF_sengsan_gul41]  DEFAULT ((0)),
	[jan41] [numeric](4, 1) NOT NULL CONSTRAINT [DF_sengsan_jan41]  DEFAULT ((0)),
	[gul42] [numeric](4, 1) NOT NULL CONSTRAINT [DF_sengsan_gul42]  DEFAULT ((0)),
	[jan42] [numeric](4, 1) NOT NULL CONSTRAINT [DF_sengsan_jan42]  DEFAULT ((0)),
	[ps1] [numeric](4, 1) NOT NULL CONSTRAINT [DF_sengsan_ps1]  DEFAULT ((0)),
	[ps2] [numeric](4, 1) NOT NULL CONSTRAINT [DF_sengsan_ps2]  DEFAULT ((0)),
	[ps3] [numeric](4, 1) NOT NULL CONSTRAINT [DF_sengsan_ps3]  DEFAULT ((0)),
	[pg1] [numeric](4, 1) NOT NULL CONSTRAINT [DF_sengsan_pg1]  DEFAULT ((0)),
	[pg2] [numeric](4, 1) NOT NULL CONSTRAINT [DF_sengsan_pg2]  DEFAULT ((0)),
	[pg3] [numeric](4, 1) NOT NULL CONSTRAINT [DF_sengsan_pg3]  DEFAULT ((0)),
	[pg4] [numeric](4, 1) NOT NULL CONSTRAINT [DF_sengsan_pg4]  DEFAULT ((0)),
	[p] [numeric](5, 2) NOT NULL CONSTRAINT [DF_sengsan_p]  DEFAULT ((0)),
	[u2] [numeric](6, 2) NOT NULL CONSTRAINT [DF_sengsan_u2]  DEFAULT ((0)),
	[u19] [numeric](6, 2) NOT NULL CONSTRAINT [DF_sengsan_u19]  DEFAULT ((0)),
	[u4] [numeric](6, 2) NOT NULL CONSTRAINT [DF_sengsan_u4]  DEFAULT ((0)),
	[u13] [numeric](6, 2) NOT NULL CONSTRAINT [DF_sengsan_u13]  DEFAULT ((0)),
	[us1] [numeric](6, 2) NOT NULL CONSTRAINT [DF_sengsan_us1]  DEFAULT ((0)),
	[us] [numeric](6, 2) NOT NULL CONSTRAINT [DF_sengsan_us]  DEFAULT ((0)),
	[us2] [numeric](6, 2) NOT NULL CONSTRAINT [DF_sengsan_us2]  DEFAULT ((0)),
	[jc] [numeric](12, 2) NOT NULL CONSTRAINT [DF_sengsan_jc]  DEFAULT ((0)),
	[jc2] [numeric](12, 2) NOT NULL CONSTRAINT [DF_sengsan_jc2]  DEFAULT ((0)),
	[jc1] [numeric](12, 2) NOT NULL CONSTRAINT [DF_sengsan_jc1]  DEFAULT ((0)),
	[js2] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_js2]  DEFAULT ((0)),
	[js1] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_js1]  DEFAULT ((0)),
	[js] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_js]  DEFAULT ((0)),
	[j5] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_j5]  DEFAULT ((0)),
	[j4] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_j4]  DEFAULT ((0)),
	[j19] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_j19]  DEFAULT ((0)),
	[j13] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_j13]  DEFAULT ((0)),
	[ja] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ja]  DEFAULT ((0)),
	[ja1] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ja1]  DEFAULT ((0)),
	[ja2] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ja2]  DEFAULT ((0)),
	[ja3] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ja3]  DEFAULT ((0)),
	[ja4] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ja4]  DEFAULT ((0)),
	[ci] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ci]  DEFAULT ((0)),
	[ch] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ch]  DEFAULT ((0)),
	[mi] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_mi]  DEFAULT ((0)),
	[mh] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_mh]  DEFAULT ((0)),
	[oi] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_oi]  DEFAULT ((0)),
	[si] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_si]  DEFAULT ((0)),
	[ai] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ai]  DEFAULT ((0)),
	[cj] [numeric](12, 2) NOT NULL CONSTRAINT [DF_sengsan_cj]  DEFAULT ((0)),
	[cc2] [numeric](12, 2) NOT NULL CONSTRAINT [DF_sengsan_cc2]  DEFAULT ((0)),
	[cs] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_cs]  DEFAULT ((0)),
	[mj] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_mj]  DEFAULT ((0)),
	[ms] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ms]  DEFAULT ((0)),
	[ms1] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ms1]  DEFAULT ((0)),
	[m19] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_m19]  DEFAULT ((0)),
	[m13] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_m13]  DEFAULT ((0)),
	[oj] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_oj]  DEFAULT ((0)),
	[sj] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_sj]  DEFAULT ((0)),
	[aj] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_aj]  DEFAULT ((0)),
	[bj] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_bj]  DEFAULT ((0)),
	[ca3] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ca3]  DEFAULT ((0)),
	[ca4] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ca4]  DEFAULT ((0)),
	[ca5] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ca5]  DEFAULT ((0)),
	[chk] [numeric](1, 0) NOT NULL CONSTRAINT [DF_sengsan_chk]  DEFAULT ((0)),
	[hon] [numeric](1, 0) NOT NULL CONSTRAINT [DF_sengsan_hon]  DEFAULT ((0)),
	[s1g1] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_s1g1]  DEFAULT ((0)),
	[s1g2] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_s1g2]  DEFAULT ((0)),
	[s1g3] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_s1g3]  DEFAULT ((0)),
	[s1g4] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_s1g4]  DEFAULT ((0)),
	[s2g1] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_s2g1]  DEFAULT ((0)),
	[s2g2] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_s2g2]  DEFAULT ((0)),
	[s2g3] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_s2g3]  DEFAULT ((0)),
	[s2g4] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_s2g4]  DEFAULT ((0)),
	[s3g1] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_s3g1]  DEFAULT ((0)),
	[s3g2] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_s3g2]  DEFAULT ((0)),
	[s3g3] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_s3g3]  DEFAULT ((0)),
	[s3g4] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_s3g4]  DEFAULT ((0)),
	[g1s1] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_g1s1]  DEFAULT ((0)),
	[g1s2] [decimal](5, 1) NOT NULL CONSTRAINT [DF_sengsan_g1s2]  DEFAULT ((0)),
	[g1s3] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_g1s3]  DEFAULT ((0)),
	[g2s1] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_g2s1]  DEFAULT ((0)),
	[g2s2] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_g2s2]  DEFAULT ((0)),
	[g2s3] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_g2s3]  DEFAULT ((0)),
	[g3s1] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_g3s1]  DEFAULT ((0)),
	[g3s2] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_g3s2]  DEFAULT ((0)),
	[g3s3] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_g3s3]  DEFAULT ((0)),
	[g4s1] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_g4s1]  DEFAULT ((0)),
	[g4s2] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_g4s2]  DEFAULT ((0)),
	[g4s3] [numeric](5, 1) NOT NULL CONSTRAINT [DF_sengsan_g4s3]  DEFAULT ((0)),
	[bc1] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_bc1]  DEFAULT ((0)),
	[bc2] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_bc2]  DEFAULT ((0)),
	[bc3] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_bc3]  DEFAULT ((0)),
	[bm1] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_bm1]  DEFAULT ((0)),
	[bm2] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_bm2]  DEFAULT ((0)),
	[bm3] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_bm3]  DEFAULT ((0)),
	[b51] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_b51]  DEFAULT ((0)),
	[b41] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_b41]  DEFAULT ((0)),
	[b19] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_b19]  DEFAULT ((0)),
	[b13] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_b13]  DEFAULT ((0)),
	[ba1] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ba1]  DEFAULT ((0)),
	[ba2] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ba2]  DEFAULT ((0)),
	[ba3] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ba3]  DEFAULT ((0)),
	[ba4] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ba4]  DEFAULT ((0)),
	[ba5] [numeric](11, 2) NOT NULL CONSTRAINT [DF_sengsan_ba5]  DEFAULT ((0)),
	[type] [char](15) NOT NULL CONSTRAINT [DF_sengsan_type]  DEFAULT (''),
	[bp] [numeric](1, 0) NOT NULL CONSTRAINT [DF_sengsan_bp]  DEFAULT ((0)),
	[hmult] [numeric](3, 1) NOT NULL CONSTRAINT [DF_sengsan_hmult]  DEFAULT ((0)),
	[hmult1] [numeric](3, 1) NOT NULL CONSTRAINT [DF_sengsan_hmult1]  DEFAULT ((0)),
	[hmult2] [numeric](3, 1) NOT NULL CONSTRAINT [DF_sengsan_hmult2]  DEFAULT ((0)),
	[hmult3] [numeric](3, 1) NOT NULL CONSTRAINT [DF_sengsan_hmult3]  DEFAULT ((0)),
	[wc] [numeric](4, 1) NOT NULL CONSTRAINT [DF_sengsan_wc]  DEFAULT ((0)),
	[sa] [numeric](4, 1) NOT NULL CONSTRAINT [DF_sengsan_sa]  DEFAULT ((0)),
	[utw] [numeric](7, 2) NOT NULL CONSTRAINT [DF_sengsan_utw]  DEFAULT ((0)),
	[mm1] [char](6) NOT NULL CONSTRAINT [DF_sengsan_mm1]  DEFAULT (''),
	[no] [numeric](5, 0) NOT NULL CONSTRAINT [DF_sengsan_no]  DEFAULT ((0)),
	[bi1] [char](50) NOT NULL CONSTRAINT [DF_sengsan_bi1]  DEFAULT (''),
	[bi2] [char](50) NOT NULL CONSTRAINT [DF_sengsan_bi2]  DEFAULT (''),
	[bi3] [char](50) NOT NULL CONSTRAINT [DF_sengsan_bi3]  DEFAULT (''),
	[bi4] [char](50) NOT NULL CONSTRAINT [DF_sengsan_bi4]  DEFAULT (''),
	[bi5] [char](50) NOT NULL CONSTRAINT [DF_sengsan_bi5]  DEFAULT (''),
	[bi6] [char](50) NOT NULL CONSTRAINT [DF_sengsan_bi6]  DEFAULT (''),
	[bi7] [char](50) NOT NULL CONSTRAINT [DF_sengsan_bi7]  DEFAULT (''),
	[bi8] [char](50) NOT NULL CONSTRAINT [DF_sengsan_bi8]  DEFAULT (''),
	[bi9] [char](50) NOT NULL CONSTRAINT [DF_sengsan_bi9]  DEFAULT (''),
	[bi10] [char](50) NOT NULL CONSTRAINT [DF_sengsan_bi10]  DEFAULT (''),
	[bi11] [char](50) NOT NULL CONSTRAINT [DF_sengsan_bi11]  DEFAULT (''),
	[bi12] [char](50) NOT NULL CONSTRAINT [DF_sengsan_bi12]  DEFAULT (''),
	[bi13] [char](50) NOT NULL CONSTRAINT [DF_sengsan_bi13]  DEFAULT (''),
	[bi14] [char](50) NOT NULL CONSTRAINT [DF_sengsan_bi14]  DEFAULT (''),
	[bi15] [char](50) NOT NULL CONSTRAINT [DF_sengsan_bi15]  DEFAULT (''),
	[tongjang] [numeric](12, 0) NOT NULL CONSTRAINT [DF_sengsan_tongjang]  DEFAULT ((0)),
	[tongjang1] [numeric](12, 0) NOT NULL CONSTRAINT [DF_sengsan_tongjang1]  DEFAULT ((0)),
 CONSTRAINT [PK_sengsan] PRIMARY KEY CLUSTERED 
(
	[docuno] ASC,
	[no] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[g2_data]') AND type in (N'U'))
BEGIN
CREATE TABLE [g2_data](
	[bp1_code] [char](4) NOT NULL CONSTRAINT [DF_g2_data_bp1_code]  DEFAULT (''),
	[bp1_name] [char](30) NOT NULL CONSTRAINT [DF_g2_data_bp1_name]  DEFAULT (''),
	[g1_code] [char](8) NOT NULL CONSTRAINT [DF_g2_data_g1_code]  DEFAULT (''),
	[g1_name] [char](20) NOT NULL CONSTRAINT [DF_g2_data_g1_name]  DEFAULT (''),
	[g1_unit] [char](10) NOT NULL CONSTRAINT [DF_g2_data_g1_unit]  DEFAULT (''),
	[g1_gunit] [numeric](4, 0) NOT NULL CONSTRAINT [DF_g2_data_g1_gunit]  DEFAULT ((0)),
	[g2_code] [char](8) NOT NULL CONSTRAINT [DF_g2_data_g2_code]  DEFAULT (''),
	[g2_name] [char](20) NOT NULL CONSTRAINT [DF_g2_data_g2_name]  DEFAULT (''),
	[g2_unit] [char](10) NOT NULL CONSTRAINT [DF_g2_data_g2_unit]  DEFAULT (''),
	[g2_gunit] [numeric](4, 0) NOT NULL CONSTRAINT [DF_g2_data_g2_gunit]  DEFAULT ((0)),
	[g3_code] [char](8) NOT NULL CONSTRAINT [DF_g2_data_g3_code]  DEFAULT (''),
	[g3_name] [char](20) NOT NULL CONSTRAINT [DF_g2_data_g3_name]  DEFAULT (''),
	[g3_unit] [char](10) NOT NULL CONSTRAINT [DF_g2_data_g3_unit]  DEFAULT (''),
	[g3_gunit] [numeric](4, 0) NOT NULL CONSTRAINT [DF_g2_data_g3_gunit]  DEFAULT ((0)),
	[g4_code] [char](8) NOT NULL CONSTRAINT [DF_g2_data_g4_code]  DEFAULT (''),
	[g4_name] [char](20) NOT NULL CONSTRAINT [DF_g2_data_g4_name]  DEFAULT (''),
	[g4_unit] [char](10) NOT NULL CONSTRAINT [DF_g2_data_g4_unit]  DEFAULT (''),
	[g4_gunit] [numeric](4, 0) NOT NULL CONSTRAINT [DF_g2_data_g4_gunit]  DEFAULT ((0)),
	[s1_code] [char](8) NOT NULL CONSTRAINT [DF_g2_data_s1_code]  DEFAULT (''),
	[s1_name] [char](20) NOT NULL CONSTRAINT [DF_g2_data_s1_name]  DEFAULT (''),
	[s1_unit] [char](10) NOT NULL CONSTRAINT [DF_g2_data_s1_unit]  DEFAULT (''),
	[s1_gunit] [numeric](4, 0) NOT NULL CONSTRAINT [DF_g2_data_s1_gunit]  DEFAULT ((0)),
	[s2_code] [char](8) NOT NULL CONSTRAINT [DF_g2_data_s2_code]  DEFAULT (''),
	[s2_name] [char](20) NOT NULL CONSTRAINT [DF_g2_data_s2_name]  DEFAULT (''),
	[s2_unit] [char](10) NOT NULL CONSTRAINT [DF_g2_data_s2_unit]  DEFAULT (''),
	[s2_gunit] [numeric](4, 0) NOT NULL CONSTRAINT [DF_g2_data_s2_gunit]  DEFAULT ((0)),
	[s3_code] [char](8) NOT NULL CONSTRAINT [DF_g2_data_s3_code]  DEFAULT (''),
	[s3_name] [char](20) NOT NULL CONSTRAINT [DF_g2_data_s3_name]  DEFAULT (''),
	[s3_unit] [char](10) NOT NULL CONSTRAINT [DF_g2_data_s3_unit]  DEFAULT (''),
	[s3_gunit] [numeric](4, 0) NOT NULL CONSTRAINT [DF_g2_data_s3_gunit]  DEFAULT ((0)),
	[c1_code] [char](8) NOT NULL CONSTRAINT [DF_g2_data_c1_code]  DEFAULT (''),
	[c1_name] [char](20) NOT NULL CONSTRAINT [DF_g2_data_c1_name]  DEFAULT (''),
	[c1_unit] [char](10) NOT NULL CONSTRAINT [DF_g2_data_c1_unit]  DEFAULT (''),
	[c2_code] [char](8) NOT NULL CONSTRAINT [DF_g2_data_c2_code]  DEFAULT (''),
	[c2_name] [char](20) NOT NULL CONSTRAINT [DF_g2_data_c2_name]  DEFAULT (''),
	[c2_unit] [char](10) NOT NULL CONSTRAINT [DF_g2_data_c2_unit]  DEFAULT (''),
	[c3_code] [char](8) NOT NULL CONSTRAINT [DF_g2_data_c3_code]  DEFAULT (''),
	[c3_name] [char](20) NOT NULL CONSTRAINT [DF_g2_data_c3_name]  DEFAULT (''),
	[c3_unit] [char](10) NOT NULL CONSTRAINT [DF_g2_data_c3_unit]  DEFAULT (''),
	[a1_code] [char](8) NOT NULL CONSTRAINT [DF_g2_data_a1_code]  DEFAULT (''),
	[a1_name] [char](20) NOT NULL CONSTRAINT [DF_g2_data_a1_name]  DEFAULT (''),
	[a1_unit] [char](10) NOT NULL CONSTRAINT [DF_g2_data_a1_unit]  DEFAULT (''),
	[a2_code] [char](8) NOT NULL CONSTRAINT [DF_g2_data_a2_code]  DEFAULT (''),
	[a2_name] [char](20) NOT NULL CONSTRAINT [DF_g2_data_a2_name]  DEFAULT (''),
	[a2_unit] [char](10) NOT NULL CONSTRAINT [DF_g2_data_a2_unit]  DEFAULT (''),
	[a3_code] [char](8) NOT NULL CONSTRAINT [DF_g2_data_a3_code]  DEFAULT (''),
	[a3_name] [char](20) NOT NULL CONSTRAINT [DF_g2_data_a3_name]  DEFAULT (''),
	[a3_unit] [char](10) NOT NULL CONSTRAINT [DF_g2_data_a3_unit]  DEFAULT (''),
	[a4_code] [char](8) NOT NULL CONSTRAINT [DF_g2_data_a4_code]  DEFAULT (''),
	[a4_name] [char](20) NOT NULL CONSTRAINT [DF_g2_data_a4_name]  DEFAULT (''),
	[a4_unit] [char](10) NOT NULL CONSTRAINT [DF_g2_data_a4_unit]  DEFAULT ('')
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[jego210]') AND type in (N'U'))
BEGIN
CREATE TABLE [jego210](
	[k21_date] [smalldatetime] NOT NULL CONSTRAINT [DF_jego210_k21_date]  DEFAULT (getdate()),
	[k21_io_tag] [char](2) NOT NULL CONSTRAINT [DF_jego210_k21_io_tag]  DEFAULT (' '),
	[k21_gubun] [char](6) NOT NULL CONSTRAINT [DF_jego210_k21_gubun]  DEFAULT (' '),
	[k21_slipno] [numeric](5, 0) NOT NULL CONSTRAINT [DF_jego210_k21_slipno]  DEFAULT ((0)),
	[k21_12code] [char](4) NOT NULL CONSTRAINT [DF_jego210_k21_12code]  DEFAULT (' '),
	[k21_12comp] [char](30) NOT NULL CONSTRAINT [DF_jego210_k21_12comp]  DEFAULT (' '),
	[k21_serial] [numeric](2, 0) NOT NULL CONSTRAINT [DF_jego210_k21_serial]  DEFAULT ((0)),
	[k21_11code] [char](8) NOT NULL CONSTRAINT [DF_jego210_k21_11code]  DEFAULT (' '),
	[k21_11inve] [char](20) NOT NULL CONSTRAINT [DF_jego210_k21_11inve]  DEFAULT (' '),
	[k21_11size] [char](10) NOT NULL CONSTRAINT [DF_jego210_k21_11size]  DEFAULT (' '),
	[k21_qty] [numeric](10, 3) NOT NULL CONSTRAINT [DF_jego210_k21_qty]  DEFAULT ((0)),
	[k21_pri] [numeric](9, 2) NOT NULL CONSTRAINT [DF_jego210_k21_pri]  DEFAULT ((0)),
	[k21_amt] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego210_k21_amt]  DEFAULT ((0)),
	[k21_vat] [numeric](11, 0) NOT NULL CONSTRAINT [DF_jego210_k21_vat]  DEFAULT ((0)),
	[k21_remk] [char](30) NOT NULL CONSTRAINT [DF_jego210_k21_remk]  DEFAULT (' '),
	[k21_gb] [char](1) NOT NULL CONSTRAINT [DF_jego210_k21_gb]  DEFAULT (' '),
	[k21_time] [char](4) NOT NULL CONSTRAINT [DF_jego210_k21_time]  DEFAULT (' '),
	[k21_cno] [char](4) NOT NULL CONSTRAINT [DF_jego210_k21_cno]  DEFAULT (' '),
	[k21_name] [char](7) NOT NULL CONSTRAINT [DF_jego210_k21_name]  DEFAULT (' '),
	[k21_unit] [char](10) NOT NULL CONSTRAINT [DF_jego210_k21_unit]  DEFAULT (' '),
	[k21_j_amt] [numeric](12, 0) NOT NULL CONSTRAINT [DF_jego210_k21_j_amt]  DEFAULT ((0)),
	[k21_j_date] [smalldatetime] NOT NULL CONSTRAINT [DF_jego210_k21_j_date]  DEFAULT (getdate()),
	[k21_rota] [numeric](2, 0) NOT NULL CONSTRAINT [DF_jego210_k21_rota]  DEFAULT ((0)),
	[k21_upri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_jego210_k21_upri]  DEFAULT ((0)),
	[¹ýÀÎÄÚµå] [char](3) NOT NULL CONSTRAINT [DF_jego210_¹ýÀÎÄÚµå]  DEFAULT (''),
	[°øÀåÄÚµå] [char](3) NOT NULL CONSTRAINT [DF_jego210_°øÀåÄÚµå]  DEFAULT (''),
	[u_code] [char](6) NOT NULL CONSTRAINT [DF_jego210_u_code]  DEFAULT (''),
	[u_comp] [char](30) NOT NULL CONSTRAINT [DF_jego210_u_comp]  DEFAULT ('')
) ON [PRIMARY]
END