SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[coordinate]') AND type in (N'U'))
BEGIN
CREATE TABLE [coordinate](
	[DATE] [smalldatetime] NOT NULL CONSTRAINT [DF_coordinate_DATE]  DEFAULT (left(getdate(),(10))),
	[TIME] [varchar](6) NOT NULL,
	[CNO] [varchar](4) NOT NULL,
	[NAME] [varchar](10) NOT NULL,
	[LAT] [decimal](14, 9) NULL,
	[LNG] [decimal](14, 9) NULL,
	[SPD] [varchar](30) NULL,
	[PNT] [varchar](30) NULL,
	[MAJOR] [varchar](4) NULL,
	[MILEAGE] [numeric](18, 4) NULL,
	[CONO] [varchar](5) NULL,
	[JUMPER] [numeric](2, 0) NULL,
	[HCODE] [varchar](4) NULL,
	[code] [numeric](4, 0) 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'[Ÿ¼³ºÎÀ§]') AND type in (N'U'))
BEGIN
CREATE TABLE [Ÿ¼³ºÎÀ§](
	[code] [char](3) NOT NULL CONSTRAINT [DF_Ÿ¼³ºÎÀ§_code]  DEFAULT (''),
	[Ÿ¼³ºÎÀ§] [char](20) NOT NULL CONSTRAINT [DF_Ÿ¼³ºÎÀ§_Ÿ¼³ºÎÀ§]  DEFAULT (''),
	[ºñ°í] [char](20) NOT NULL CONSTRAINT [DF_Ÿ¼³ºÎÀ§_ºñ°í]  DEFAULT (''),
 CONSTRAINT [PK_Ÿ¼³ºÎÀ§] PRIMARY KEY CLUSTERED 
(
	[code] 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'[songjang]') AND type in (N'U'))
BEGIN
CREATE TABLE [songjang](
	[date] [datetime] NOT NULL CONSTRAINT [DF_songjang_date]  DEFAULT (getdate()),
	[cono] [numeric](4, 0) NOT NULL CONSTRAINT [DF_songjang_cono]  DEFAULT (0),
	[code] [numeric](2, 0) NOT NULL CONSTRAINT [DF_songjang_code]  DEFAULT (0),
	[¹ýÀÎÄÚµå] [char](3) NOT NULL CONSTRAINT [DF_songjang_¹ýÀÎÄÚµå]  DEFAULT (''),
	[°øÀåÄÚµå] [char](3) NOT NULL CONSTRAINT [DF_songjang_°øÀåÄÚµå]  DEFAULT (''),
	[scode] [char](6) NOT NULL CONSTRAINT [DF_songjang_scode]  DEFAULT (''),
	[saho] [char](60) NOT NULL CONSTRAINT [DF_songjang_saho]  DEFAULT (''),
	[hcode] [char](4) NOT NULL CONSTRAINT [DF_songjang_hcode]  DEFAULT (''),
	[hyun] [char](60) NOT NULL CONSTRAINT [DF_songjang_hyun]  DEFAULT (''),
	[¸ÅÀÔÄÚµå] [char](6) NOT NULL CONSTRAINT [DF_songjang_¸ÅÀÔÄÚµå]  DEFAULT (''),
	[¸ÅÃâÄÚµå] [char](6) NOT NULL CONSTRAINT [DF_songjang_¸ÅÃâÄÚµå]  DEFAULT (''),
	[bcode] [char](5) NOT NULL CONSTRAINT [DF_songjang_bcode]  DEFAULT (''),
	[bhap] [char](12) NOT NULL CONSTRAINT [DF_songjang_bhap]  DEFAULT (''),
	[hon] [numeric](2, 0) NOT NULL CONSTRAINT [DF_songjang_hon]  DEFAULT (0),
	[time] [char](4) NOT NULL CONSTRAINT [DF_songjang_time]  DEFAULT (''),
	[cno] [char](4) NOT NULL CONSTRAINT [DF_songjang_cno]  DEFAULT (''),
	[name] [char](8) NOT NULL CONSTRAINT [DF_songjang_name]  DEFAULT (''),
	[lube] [numeric](5, 2) NOT NULL CONSTRAINT [DF_songjang_lube]  DEFAULT (0),
	[ye] [numeric](6, 2) NOT NULL CONSTRAINT [DF_songjang_ye]  DEFAULT (0),
	[nuge2] [numeric](7, 2) NOT NULL CONSTRAINT [DF_songjang_nuge2]  DEFAULT (0),
	[chek] [numeric](1, 0) NOT NULL CONSTRAINT [DF_songjang_chek]  DEFAULT (0),
	[nuge1] [numeric](4, 0) NOT NULL CONSTRAINT [DF_songjang_nuge1]  DEFAULT (0),
	[danga] [char](1) NOT NULL CONSTRAINT [DF_songjang_danga]  DEFAULT (''),
	[mg] [char](1) NOT NULL CONSTRAINT [DF_songjang_mg]  DEFAULT (''),
	[moltal] [char](1) NOT NULL CONSTRAINT [DF_songjang_moltal]  DEFAULT (''),
	[mollube] [numeric](4, 2) NOT NULL CONSTRAINT [DF_songjang_mollube]  DEFAULT (0),
	[bno] [char](1) NOT NULL CONSTRAINT [DF_songjang_bno]  DEFAULT (''),
	[honhwa] [char](40) NOT NULL CONSTRAINT [DF_songjang_honhwa]  DEFAULT (''),
	[gol] [char](16) NOT NULL CONSTRAINT [DF_songjang_gol]  DEFAULT (''),
	[simen] [char](22) NOT NULL CONSTRAINT [DF_songjang_simen]  DEFAULT (''),
	[prt] [numeric](1, 0) NOT NULL CONSTRAINT [DF_songjang_prt]  DEFAULT (0),
	[m_bcode] [char](5) NOT NULL CONSTRAINT [DF_songjang_m_bcode]  DEFAULT (''),
	[m_bhap] [char](12) NOT NULL CONSTRAINT [DF_songjang_m_bhap]  DEFAULT (''),
	[chek_cont] [char](10) NOT NULL CONSTRAINT [DF_songjang_chek_cont]  DEFAULT (''),
	[f_carnol] [char](4) NOT NULL CONSTRAINT [DF_songjang_f_carnol]  DEFAULT (''),
	[s_ger] [char](30) NOT NULL CONSTRAINT [DF_songjang_s_ger]  DEFAULT (''),
	[s_hyun] [char](30) NOT NULL CONSTRAINT [DF_songjang_s_hyun]  DEFAULT (''),
	[s_tel] [char](20) NOT NULL CONSTRAINT [DF_songjang_s_tel]  DEFAULT (''),
	[h_tel] [char](20) NOT NULL CONSTRAINT [DF_songjang_h_tel]  DEFAULT (''),
	[fly] [char](50) NOT NULL CONSTRAINT [DF_songjang_fly]  DEFAULT (''),
	[slag] [char](3) NOT NULL CONSTRAINT [DF_songjang_slag]  DEFAULT (''),
	[chkman] [char](20) NOT NULL CONSTRAINT [DF_songjang_chkman]  DEFAULT (''),
	[order_no] [char](10) NOT NULL CONSTRAINT [DF_songjang_order_no]  DEFAULT (''),
	[remk] [char](50) NOT NULL CONSTRAINT [DF_songjang_remk]  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'[fly]') AND type in (N'U'))
BEGIN
CREATE TABLE [fly](
	[fno] [char](2) NOT NULL CONSTRAINT [DF_fly_fno]  DEFAULT (''),
	[fly] [char](50) NOT NULL CONSTRAINT [DF_fly_fly]  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'[±â°£¿î¹Ý´Ü°¡]') AND type in (N'U'))
BEGIN
CREATE TABLE [±â°£¿î¹Ý´Ü°¡](
	[½ÃÀÛÀÏ] [smalldatetime] NOT NULL CONSTRAINT [DF_±â°£¿î¹Ý´Ü°¡_½ÃÀÛÀÏ]  DEFAULT (getdate()),
	[¸¶°¨ÀÏ] [smalldatetime] NOT NULL CONSTRAINT [DF_±â°£¿î¹Ý´Ü°¡_¸¶°¨ÀÏ]  DEFAULT (getdate()),
	[¿îÇ౸ºÐ] [char](10) NOT NULL CONSTRAINT [DF_±â°£¿î¹Ý´Ü°¡_¿îÇ౸ºÐ]  DEFAULT (''),
	[¿î¹Ý´Ü°¡] [numeric](5, 0) NOT NULL CONSTRAINT [DF_±â°£¿î¹Ý´Ü°¡_¿î¹Ý´Ü°¡]  DEFAULT (0),
	[°è»ê±¸ºÐ] [nchar](10) NOT NULL CONSTRAINT [DF_±â°£¿î¹Ý´Ü°¡_°è»ê±¸ºÐ]  DEFAULT (''),
	[±âÃʼö´ç] [numeric](5, 0) NOT NULL CONSTRAINT [DF_±â°£¿î¹Ý´Ü°¡_±âÃʼö´ç]  DEFAULT (0),
	[kmÃß°¡´Ü°¡] [numeric](5, 0) NOT NULL CONSTRAINT [DF_±â°£¿î¹Ý´Ü°¡_kmÃß°¡´Ü°¡]  DEFAULT (0),
	[À¯·ù´Ü°¡] [numeric](5, 0) NOT NULL CONSTRAINT [DF_±â°£¿î¹Ý´Ü°¡_À¯·ù´Ü°¡]  DEFAULT (0),
	[¹Ì¸¸ÃÊ°ú´Ü°¡] [numeric](5, 0) NOT NULL CONSTRAINT [DF_±â°£¿î¹Ý´Ü°¡_¹Ì¸¸ÃÊ°ú´Ü°¡]  DEFAULT (0),
	[m3°è»ê±âÁØ] [numeric](5, 2) NOT NULL CONSTRAINT [DF_±â°£¿î¹Ý´Ü°¡_m3°è»ê±âÁØ]  DEFAULT (0),
	[ȸ¼ö°è»ê±âÁØ] [numeric](5, 2) NOT NULL CONSTRAINT [DF_±â°£¿î¹Ý´Ü°¡_ȸ¼ö°è»ê±âÁØ]  DEFAULT (0),
	[ÃÊ°úm3±âÁØ] [numeric](5, 2) NOT NULL CONSTRAINT [DF_±â°£¿î¹Ý´Ü°¡_ÃÊ°úm3±âÁØ]  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'[carno]') AND type in (N'U'))
BEGIN
CREATE TABLE [carno](
	[cno] [char](4) NOT NULL CONSTRAINT [DF_carno_cno]  DEFAULT (''),
	[name] [char](8) NOT NULL CONSTRAINT [DF_carno_name]  DEFAULT (''),
	[ger] [char](10) NOT NULL CONSTRAINT [DF_carno_ger]  DEFAULT (''),
	[hyun] [char](15) NOT NULL CONSTRAINT [DF_carno_hyun]  DEFAULT (''),
	[type] [char](12) NOT NULL CONSTRAINT [DF_carno_type]  DEFAULT (''),
	[lube] [numeric](5, 2) NOT NULL CONSTRAINT [DF_carno_lube]  DEFAULT (0),
	[time] [char](4) NOT NULL CONSTRAINT [DF_carno_time]  DEFAULT (''),
	[tang] [numeric](2, 0) NOT NULL CONSTRAINT [DF_carno_tang]  DEFAULT (0),
	[rem] [char](10) NOT NULL CONSTRAINT [DF_carno_rem]  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'[carye]') AND type in (N'U'))
BEGIN
CREATE TABLE [carye](
	[cno] [char](4) NOT NULL CONSTRAINT [DF_carye_cno]  DEFAULT (''),
	[name] [char](8) NOT NULL CONSTRAINT [DF_carye_name]  DEFAULT (''),
	[car_name] [char](16) NOT NULL CONSTRAINT [DF_carye_car_name]  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'[ch_ip1]') AND type in (N'U'))
BEGIN
CREATE TABLE [ch_ip1](
	[code] [numeric](2, 0) NOT NULL CONSTRAINT [DF_ch_ip1_code]  DEFAULT (0),
	[bcode] [char](5) NOT NULL CONSTRAINT [DF_ch_ip1_bcode]  DEFAULT (''),
	[saho] [char](30) NOT NULL CONSTRAINT [DF_ch_ip1_saho]  DEFAULT (''),
	[hyun] [char](30) NOT NULL CONSTRAINT [DF_ch_ip1_hyun]  DEFAULT (''),
	[lube] [numeric](5, 2) NOT NULL CONSTRAINT [DF_ch_ip1_lube]  DEFAULT (0),
	[time] [char](4) NOT NULL CONSTRAINT [DF_ch_ip1_time]  DEFAULT (''),
	[cno] [char](4) NOT NULL CONSTRAINT [DF_ch_ip1_cno]  DEFAULT (''),
	[chk] [float] NOT NULL CONSTRAINT [DF_ch_ip1_chk]  DEFAULT (0),
	[cono] [float] NOT NULL CONSTRAINT [DF_ch_ip1_cono]  DEFAULT (0),
	[moltal] [char](1) NOT NULL CONSTRAINT [DF_ch_ip1_moltal]  DEFAULT (''),
	[name] [char](10) NOT NULL CONSTRAINT [DF_ch_ip1_name]  DEFAULT (''),
	[mollube] [float] NOT NULL CONSTRAINT [DF_ch_ip1_mollube]  DEFAULT (0),
	[bno] [char](1) NOT NULL CONSTRAINT [DF_ch_ip1_bno]  DEFAULT (''),
	[slmp] [float] NOT NULL CONSTRAINT [DF_ch_ip1_slmp]  DEFAULT (0),
	[s_lube] [float] NOT NULL CONSTRAINT [DF_ch_ip1_s_lube]  DEFAULT (0),
	[type] [char](18) NOT NULL CONSTRAINT [DF_ch_ip1_type]  DEFAULT (''),
	[remk] [char](9) NOT NULL CONSTRAINT [DF_ch_ip1_remk]  DEFAULT (''),
	[m_bcode] [char](5) NOT NULL CONSTRAINT [DF_ch_ip1_m_bcode]  DEFAULT (''),
	[m_bhap] [char](9) NOT NULL CONSTRAINT [DF_ch_ip1_m_bhap]  DEFAULT (''),
	[t_bcode] [char](5) NOT NULL CONSTRAINT [DF_ch_ip1_t_bcode]  DEFAULT (''),
	[t_type] [char](18) NOT NULL CONSTRAINT [DF_ch_ip1_t_type]  DEFAULT (''),
	[s_prt] [float] NOT NULL CONSTRAINT [DF_ch_ip1_s_prt]  DEFAULT (0),
	[bp_send] [float] NOT NULL CONSTRAINT [DF_ch_ip1_bp_send]  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'[car]') AND type in (N'U'))
BEGIN
CREATE TABLE [car](
	[cno] [char](4) NOT NULL CONSTRAINT [DF_car_cno]  DEFAULT (''),
	[belong] [char](5) NOT NULL CONSTRAINT [DF_car_belong]  DEFAULT (''),
	[name] [char](10) NOT NULL CONSTRAINT [DF_car_name]  DEFAULT (''),
	[cellphone] [char](16) NOT NULL CONSTRAINT [DF_car_cellphone]  DEFAULT (''),
	[rem] [char](20) NOT NULL CONSTRAINT [DF_car_rem]  DEFAULT (''),
	[gubun] [char](1) NOT NULL CONSTRAINT [DF_car_gu]  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'[honhwa]') AND type in (N'U'))
BEGIN
CREATE TABLE [honhwa](
	[hno] [char](3) NOT NULL CONSTRAINT [DF_honhwa_no]  DEFAULT (''),
	[honhwa] [char](20) NULL CONSTRAINT [DF_honhwa_hon]  DEFAULT (''),
	[gol] [char](20) NULL CONSTRAINT [DF_honhwa_gol]  DEFAULT (''),
	[siment] [char](20) NULL CONSTRAINT [DF_honhwa_siment]  DEFAULT (''),
	[air] [char](20) NULL CONSTRAINT [DF_honhwa_air]  DEFAULT (''),
	[chloride] [char](20) NULL CONSTRAINT [DF_honhwa_chloride]  DEFAULT (''),
	[remk] [char](20) NULL CONSTRAINT [DF_honhwa_remk]  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'[ch_ip2]') AND type in (N'U'))
BEGIN
CREATE TABLE [ch_ip2](
	[code] [numeric](2, 0) NOT NULL CONSTRAINT [DF_ch_ip2_code]  DEFAULT (0),
	[bcode] [char](5) NOT NULL CONSTRAINT [DF_ch_ip2_bcode]  DEFAULT (''),
	[saho] [char](30) NOT NULL CONSTRAINT [DF_ch_ip2_saho]  DEFAULT (''),
	[hyun] [char](30) NOT NULL CONSTRAINT [DF_ch_ip2_hyun]  DEFAULT (''),
	[lube] [numeric](5, 2) NOT NULL CONSTRAINT [DF_ch_ip2_lube]  DEFAULT (0),
	[time] [char](4) NOT NULL CONSTRAINT [DF_ch_ip2_time]  DEFAULT (''),
	[cno] [char](4) NOT NULL CONSTRAINT [DF_ch_ip2_cno]  DEFAULT (''),
	[chk] [float] NOT NULL CONSTRAINT [DF_ch_ip2_chk]  DEFAULT (0),
	[cono] [float] NOT NULL CONSTRAINT [DF_ch_ip2_cono]  DEFAULT (0),
	[moltal] [char](1) NOT NULL CONSTRAINT [DF_ch_ip2_moltal]  DEFAULT (''),
	[name] [char](10) NOT NULL CONSTRAINT [DF_ch_ip2_name]  DEFAULT (''),
	[mollube] [float] NOT NULL CONSTRAINT [DF_ch_ip2_mollube]  DEFAULT (0),
	[bno] [char](1) NOT NULL CONSTRAINT [DF_ch_ip2_bno]  DEFAULT (''),
	[slmp] [float] NOT NULL CONSTRAINT [DF_ch_ip2_slmp]  DEFAULT (0),
	[s_lube] [float] NOT NULL CONSTRAINT [DF_ch_ip2_s_lube]  DEFAULT (0),
	[type] [char](18) NOT NULL CONSTRAINT [DF_ch_ip2_type]  DEFAULT (''),
	[remk] [char](9) NOT NULL CONSTRAINT [DF_ch_ip2_remk]  DEFAULT (''),
	[m_bcode] [char](5) NOT NULL CONSTRAINT [DF_ch_ip2_m_bcode]  DEFAULT (''),
	[m_bhap] [char](9) NOT NULL CONSTRAINT [DF_ch_ip2_m_bhap]  DEFAULT (''),
	[t_bcode] [char](5) NOT NULL CONSTRAINT [DF_ch_ip2_t_bcode]  DEFAULT (''),
	[t_type] [char](18) NOT NULL CONSTRAINT [DF_ch_ip2_t_type]  DEFAULT (''),
	[s_prt] [float] NOT NULL CONSTRAINT [DF_ch_ip2_s_prt]  DEFAULT (0),
	[bp_send] [float] NOT NULL CONSTRAINT [DF_ch_ip2_bp_send]  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'[wator]') AND type in (N'U'))
BEGIN
CREATE TABLE [wator](
	[wDate] [datetime] NOT NULL,
	[cono] [numeric](4, 0) NOT NULL CONSTRAINT [DF_wator_cono]  DEFAULT (0),
	[wTime] [char](4) NOT NULL CONSTRAINT [DF_wator_wTime]  DEFAULT (''),
	[cno] [char](4) NOT NULL CONSTRAINT [DF_wator_cno]  DEFAULT (''),
	[name] [char](8) NOT NULL CONSTRAINT [DF_wator_name]  DEFAULT (''),
	[code] [numeric](2, 0) NOT NULL CONSTRAINT [DF_wator_code]  DEFAULT (0),
	[scode] [char](6) NOT NULL CONSTRAINT [DF_wator_scode]  DEFAULT (''),
	[saho] [char](30) NOT NULL CONSTRAINT [DF_wator_saho]  DEFAULT (''),
	[hcode] [char](4) NOT NULL CONSTRAINT [DF_wator_hcode]  DEFAULT (''),
	[hyun] [char](30) NOT NULL CONSTRAINT [DF_wator_hyun]  DEFAULT (''),
	[bcode] [char](5) NOT NULL CONSTRAINT [DF_wator_bcode]  DEFAULT (''),
	[bhap] [char](12) NOT NULL CONSTRAINT [DF_wator_bhap]  DEFAULT (''),
	[bno] [char](1) NOT NULL CONSTRAINT [DF_wator_bno]  DEFAULT (''),
	[wa_nuge1] [numeric](4, 0) NOT NULL CONSTRAINT [DF_wator_wa_nuge1]  DEFAULT (0),
	[chek] [numeric](1, 0) NOT NULL CONSTRAINT [DF_wator_chek]  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'[yejung]') AND type in (N'U'))
BEGIN
CREATE TABLE [yejung](
	[date] [datetime] NOT NULL CONSTRAINT [DF_yejung_date]  DEFAULT (getdate()),
	[code] [numeric](2, 0) NOT NULL CONSTRAINT [DF_yejung_code]  DEFAULT (0),
	[¹ýÀÎÄÚµå] [char](3) NOT NULL CONSTRAINT [DF_yejung_¹ýÀÎÄÚµå]  DEFAULT (''),
	[°øÀåÄÚµå] [char](3) NOT NULL CONSTRAINT [DF_yejung_°øÀåÄÚµå]  DEFAULT (''),
	[scode] [char](6) NOT NULL CONSTRAINT [DF_yejung_scode]  DEFAULT (''),
	[saho] [char](60) NOT NULL CONSTRAINT [DF_yejung_saho]  DEFAULT (''),
	[hcode] [char](4) NOT NULL CONSTRAINT [DF_yejung_hcode]  DEFAULT (''),
	[hyun] [char](60) NOT NULL CONSTRAINT [DF_yejung_hyun]  DEFAULT (''),
	[¸ÅÃâÄÚµå] [char](6) NOT NULL CONSTRAINT [DF_yejung_¸ÅÃâÄÚµå]  DEFAULT (''),
	[¸ÅÀÔÄÚµå] [char](6) NOT NULL CONSTRAINT [DF_yejung_¸ÅÀÔÄÚµå]  DEFAULT (''),
	[¿©½Å±Ý¾×] [numeric](10, 0) NOT NULL CONSTRAINT [DF_yejung_¿©½Å±Ý¾×]  DEFAULT (0),
	[¿©½ÅÀܾ×] [numeric](10, 0) NOT NULL CONSTRAINT [DF_yejung_¿©½ÅÀܾ×]  DEFAULT (0),
	[bcode] [char](5) NOT NULL CONSTRAINT [DF_yejung_bcode]  DEFAULT (''),
	[bhap] [char](12) NOT NULL CONSTRAINT [DF_yejung_bhap]  DEFAULT (''),
	[hon] [numeric](2, 0) NOT NULL CONSTRAINT [DF_yejung_hon]  DEFAULT (0),
	[ye] [numeric](7, 2) NOT NULL CONSTRAINT [DF_yejung_ye]  DEFAULT (0),
	[ch] [numeric](7, 2) NOT NULL CONSTRAINT [DF_yejung_ch]  DEFAULT (0),
	[jan] [numeric](7, 2) NOT NULL CONSTRAINT [DF_yejung_jan]  DEFAULT (0),
	[nuge] [numeric](3, 0) NOT NULL CONSTRAINT [DF_yejung_nuge]  DEFAULT (0),
	[danga] [char](1) NOT NULL CONSTRAINT [DF_yejung_danga]  DEFAULT (''),
	[mg] [char](1) NOT NULL CONSTRAINT [DF_yejung_mg]  DEFAULT (''),
	[honhwa] [char](40) NOT NULL CONSTRAINT [DF_yejung_honhwa]  DEFAULT (''),
	[slmp] [numeric](2, 0) NOT NULL CONSTRAINT [DF_yejung_slmp]  DEFAULT (0),
	[gno] [char](1) NOT NULL CONSTRAINT [DF_yejung_gno]  DEFAULT (''),
	[gol] [char](16) NOT NULL CONSTRAINT [DF_yejung_gol]  DEFAULT (''),
	[sno] [char](1) NOT NULL CONSTRAINT [DF_yejung_sno]  DEFAULT (''),
	[simen] [char](22) NOT NULL CONSTRAINT [DF_yejung_simen]  DEFAULT (''),
	[sc] [numeric](3, 0) NOT NULL CONSTRAINT [DF_yejung_sc]  DEFAULT (0),
	[silc] [numeric](3, 0) NOT NULL CONSTRAINT [DF_yejung_silc]  DEFAULT (0),
	[b_ch] [numeric](8, 2) NOT NULL CONSTRAINT [DF_yejung_b_ch]  DEFAULT (0),
	[b_nuge] [numeric](3, 0) NOT NULL CONSTRAINT [DF_yejung_b_nuge]  DEFAULT (0),
	[f_time] [char](4) NOT NULL CONSTRAINT [DF_yejung_f_time]  DEFAULT (''),
	[f_ch] [numeric](7, 2) NOT NULL CONSTRAINT [DF_yejung_f_ch]  DEFAULT (0),
	[f_nuge] [numeric](3, 0) NOT NULL CONSTRAINT [DF_yejung_f_nuge]  DEFAULT (0),
	[prt] [numeric](1, 0) NOT NULL CONSTRAINT [DF_yejung_prt]  DEFAULT (0),
	[sta_time] [char](4) NOT NULL CONSTRAINT [DF_yejung_sta_time]  DEFAULT (''),
	[spc_time] [char](4) NOT NULL CONSTRAINT [DF_yejung_spc_time]  DEFAULT (''),
	[jagup] [char](50) NOT NULL CONSTRAINT [DF_yejung_jagup]  DEFAULT (''),
	[remk] [char](50) NOT NULL CONSTRAINT [DF_yejung_remk]  DEFAULT (''),
	[f_carno] [char](4) NOT NULL CONSTRAINT [DF_yejung_f_carno]  DEFAULT (''),
	[s_ger] [char](30) NOT NULL CONSTRAINT [DF_yejung_s_ger]  DEFAULT (''),
	[s_hyun] [char](30) NOT NULL CONSTRAINT [DF_yejung_s_hyun]  DEFAULT (''),
	[s_tel] [char](20) NOT NULL CONSTRAINT [DF_yejung_s_tel]  DEFAULT (''),
	[h_tel] [char](20) NOT NULL CONSTRAINT [DF_yejung_h_tel]  DEFAULT (''),
	[fly] [char](3) NOT NULL CONSTRAINT [DF_yejung_fly]  DEFAULT (''),
	[slag] [char](3) NOT NULL CONSTRAINT [DF_yejung_slag]  DEFAULT (''),
	[chk] [numeric](1, 0) NOT NULL CONSTRAINT [DF_yejung_chk]  DEFAULT (0),
	[chkman] [char](20) NOT NULL CONSTRAINT [DF_yejung_chkman]  DEFAULT (''),
	[order_no] [char](10) NOT NULL CONSTRAINT [DF_yejung_order_no]  DEFAULT (''),
	[d31_pri] [numeric](6, 0) NOT NULL CONSTRAINT [DF_yejung_d31_pri]  DEFAULT (0),
	[dc_pri] [numeric](3, 0) NOT NULL CONSTRAINT [DF_yejung_dc_pri]  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'[siment]') AND type in (N'U'))
BEGIN
CREATE TABLE [siment](
	[sno] [char](2) NOT NULL CONSTRAINT [DF_siment_sno]  DEFAULT (''),
	[siment] [char](50) NOT NULL CONSTRAINT [DF_siment_siment]  DEFAULT (''),
	[fly] [char](3) NOT NULL CONSTRAINT [DF_siment_fly]  DEFAULT (''),
	[slag] [char](3) NOT NULL CONSTRAINT [DF_siment_slag]  DEFAULT (''),
	[sc] [numeric](3, 0) NOT NULL CONSTRAINT [DF_siment_sc]  DEFAULT (0),
	[silc] [numeric](3, 0) NOT NULL CONSTRAINT [DF_siment_silc]  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'[goljae]') AND type in (N'U'))
BEGIN
CREATE TABLE [goljae](
	[gno] [char](2) NOT NULL CONSTRAINT [DF_goljae_gno]  DEFAULT (''),
	[gol] [char](16) NOT NULL CONSTRAINT [DF_goljae_gol]  DEFAULT ('')
) ON [PRIMARY]
END