USE [ebiz품질_nrna1] GO /****** 개체: Table [dbo].[da1000000] 스크립트 날짜: 01/21/2015 15:59:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[da1000000]( [법인코드] [char](3) NOT NULL CONSTRAINT [DF_da1000000_법인코드] DEFAULT (''), [공장코드] [char](3) NOT NULL CONSTRAINT [DF_da1000000_공장코드] DEFAULT (''), [date] [datetime] NOT NULL CONSTRAINT [DF_da1000000_date] DEFAULT (getdate()), [time] [char](10) NOT NULL CONSTRAINT [DF_da1000000_time] DEFAULT (''), [bno] [char](8) NOT NULL CONSTRAINT [DF_da1000000_bno] DEFAULT (''), [sno] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da1000000_sno] DEFAULT ((0)), [cno] [char](8) NOT NULL CONSTRAINT [DF_da1000000_cno] DEFAULT (''), [m3] [numeric](7, 2) NOT NULL CONSTRAINT [DF_da1000000_m3] DEFAULT ((0)), [sms1] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_sms1] DEFAULT ((0)), [sms2] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_sms2] DEFAULT ((0)), [sms3] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_sms3] DEFAULT ((0)), [sms4] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_sms4] DEFAULT ((0)), [sms5] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_sms5] DEFAULT ((0)), [smg1] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_smg1] DEFAULT ((0)), [smg2] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_smg2] DEFAULT ((0)), [smg3] [numeric](8, 1) NOT NULL, [smg4] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_smg4] DEFAULT ((0)), [smg5] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_smg5] DEFAULT ((0)), [s1g1] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_s1g1] DEFAULT ((0)), [s2g2] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_s2g2] DEFAULT ((0)), [s3g3] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_s3g3] DEFAULT ((0)), [s4g4] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_s4g4] DEFAULT ((0)), [s5g5] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_s5g5] DEFAULT ((0)), [g1s1] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_g1s1] DEFAULT ((0)), [g2s2] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_g2s2] DEFAULT ((0)), [g3s3] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_g3s3] DEFAULT ((0)), [g4s4] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_g4s4] DEFAULT ((0)), [g5s5] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_g5s5] DEFAULT ((0)), [type] [char](15) NOT NULL CONSTRAINT [DF_da1000000_type] DEFAULT (''), [g1] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da1000000_g1] DEFAULT ((0)), [g2] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da1000000_g2] DEFAULT ((0)), [g3] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da1000000_g3] DEFAULT ((0)), [g4] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da1000000_g4] DEFAULT ((0)), [g5] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da1000000_g5] DEFAULT ((0)), [s1] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da1000000_s1] DEFAULT ((0)), [s2] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da1000000_s2] DEFAULT ((0)), [s3] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da1000000_s3] DEFAULT ((0)), [s4] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da1000000_s4] DEFAULT ((0)), [s5] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da1000000_s5] DEFAULT ((0)), [c1] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da1000000_c1] DEFAULT ((0)), [c2] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da1000000_c2] DEFAULT ((0)), [c3] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_c3] DEFAULT ((0)), [c4] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_c4] DEFAULT ((0)), [c5] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da1000000_c5] DEFAULT ((0)), [w1] [numeric](7, 1) NOT NULL CONSTRAINT [DF_da1000000_w1] DEFAULT ((0)), [w2] [numeric](7, 1) NOT NULL CONSTRAINT [DF_da1000000_w2] DEFAULT ((0)), [w3] [numeric](7, 1) NOT NULL CONSTRAINT [DF_da1000000_w3] DEFAULT ((0)), [w4] [numeric](7, 1) NOT NULL CONSTRAINT [DF_da1000000_w4] DEFAULT ((0)), [w5] [numeric](7, 1) NOT NULL CONSTRAINT [DF_da1000000_w5] DEFAULT ((0)), [ad1] [numeric](8, 2) NOT NULL CONSTRAINT [DF_da1000000_ad1] DEFAULT ((0)), [ad2] [numeric](7, 2) NOT NULL CONSTRAINT [DF_da1000000_ad2] DEFAULT ((0)), [ad3] [numeric](7, 2) NOT NULL CONSTRAINT [DF_da1000000_ad3] DEFAULT ((0)), [ad4] [numeric](7, 2) NOT NULL CONSTRAINT [DF_da1000000_ad5] DEFAULT ((0)), [ad5] [numeric](7, 2) NOT NULL CONSTRAINT [DF_da1000000_ad4] DEFAULT ((0)), [msx] [char](3) NOT NULL CONSTRAINT [DF_da1000000_msx] DEFAULT (''), [sl] [numeric](7, 1) NOT NULL CONSTRAINT [DF_da1000000_sl] DEFAULT ((0)), [p] [numeric](7, 1) NOT NULL CONSTRAINT [DF_da1000000_p] DEFAULT ((0)), [timestamp_column] [timestamp] NOT NULL, [identity_column] [int] IDENTITY(1,1) NOT NULL, [BCNT] [numeric](4, 0) NOT NULL CONSTRAINT [DF_da1000000_BCNT] DEFAULT ((0)), [BP] [numeric](1, 0) NOT NULL CONSTRAINT [DF_da1000000_BP] DEFAULT ((0)), [GUBUN] [numeric](1, 0) NOT NULL CONSTRAINT [DF_da1000000_GUBUN] DEFAULT ((0)), [hcode] [char](10) NULL CONSTRAINT [DF_da1000000_hcode] DEFAULT (''), [scode] [char](10) NULL CONSTRAINT [DF_da1000000_scode] DEFAULT (''), [saho] [char](60) NULL CONSTRAINT [DF_da1000000_saho] DEFAULT (''), [hyun] [char](60) NULL CONSTRAINT [DF_da1000000_hyun] DEFAULT ('') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ds2000000] 스크립트 날짜: 01/21/2015 16:01:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ds2000000]( [법인코드] [char](3) NOT NULL CONSTRAINT [DF_ds2000000_법인코드] DEFAULT (''), [공장코드] [char](3) NOT NULL CONSTRAINT [DF_ds2000000_공장코드] DEFAULT (''), [date] [datetime] NOT NULL CONSTRAINT [DF_ds2000000_date] DEFAULT (getdate()), [time] [char](10) NOT NULL CONSTRAINT [DF_ds2000000_time] DEFAULT (''), [bno] [char](8) NOT NULL CONSTRAINT [DF_ds2000000_bno] DEFAULT (''), [sno] [numeric](8, 0) NOT NULL CONSTRAINT [DF_ds2000000_sno] DEFAULT ((0)), [cno] [char](8) NOT NULL CONSTRAINT [DF_ds2000000_cno] DEFAULT (''), [m3] [numeric](7, 2) NOT NULL CONSTRAINT [DF_ds2000000_m3] DEFAULT ((0)), [sms1] [numeric](8, 1) NOT NULL CONSTRAINT [DF_ds2000000_sms1] DEFAULT ((0)), [sms2] [numeric](8, 1) NOT NULL CONSTRAINT [DF_ds2000000_sms2] DEFAULT ((0)), [smg1] [numeric](8, 1) NOT NULL CONSTRAINT [DF_ds2000000_smg1] DEFAULT ((0)), [smg2] [numeric](8, 1) NOT NULL CONSTRAINT [DF_ds2000000_smg2] DEFAULT ((0)), [s1g1] [numeric](8, 1) NOT NULL CONSTRAINT [DF_ds2000000_s1g1] DEFAULT ((0)), [s2g2] [numeric](8, 1) NOT NULL CONSTRAINT [DF_ds2000000_s2g2] DEFAULT ((0)), [g1s1] [numeric](8, 1) NOT NULL CONSTRAINT [DF_ds2000000_g1s1] DEFAULT ((0)), [g2s2] [numeric](8, 1) NOT NULL CONSTRAINT [DF_ds2000000_g2s2] DEFAULT ((0)), [type] [char](15) NOT NULL CONSTRAINT [DF_ds2000000_type] DEFAULT (''), [g1] [numeric](8, 0) NOT NULL CONSTRAINT [DF_ds2000000_g1] DEFAULT ((0)), [g2] [numeric](8, 0) NOT NULL CONSTRAINT [DF_ds2000000_g2] DEFAULT ((0)), [g3] [numeric](8, 0) NOT NULL CONSTRAINT [DF_ds2000000_g3] DEFAULT ((0)), [g4] [numeric](8, 0) NOT NULL CONSTRAINT [DF_ds2000000_g4] DEFAULT ((0)), [g5] [numeric](8, 0) NOT NULL CONSTRAINT [DF_ds2000000_g5] DEFAULT ((0)), [s1] [numeric](8, 0) NOT NULL CONSTRAINT [DF_ds2000000_s1] DEFAULT ((0)), [s2] [numeric](8, 0) NOT NULL CONSTRAINT [DF_ds2000000_s2] DEFAULT ((0)), [c1] [numeric](8, 0) NOT NULL CONSTRAINT [DF_ds2000000_c1] DEFAULT ((0)), [c2] [numeric](8, 0) NOT NULL CONSTRAINT [DF_ds2000000_c2] DEFAULT ((0)), [c3] [numeric](8, 1) NOT NULL CONSTRAINT [DF_ds2000000_c3] DEFAULT ((0)), [w1] [numeric](7, 1) NOT NULL CONSTRAINT [DF_ds2000000_w1] DEFAULT ((0)), [w2] [numeric](7, 1) NOT NULL CONSTRAINT [DF_ds2000000_w2] DEFAULT ((0)), [ad1] [numeric](8, 2) NOT NULL CONSTRAINT [DF_ds2000000_ad1] DEFAULT ((0)), [ad2] [numeric](7, 2) NOT NULL CONSTRAINT [DF_ds2000000_ad2] DEFAULT ((0)), [ad3] [numeric](7, 2) NOT NULL CONSTRAINT [DF_ds2000000_ad3] DEFAULT ((0)), [ad4] [numeric](7, 2) NOT NULL CONSTRAINT [DF_ds2000000_ad4] DEFAULT ((0)), [ad5] [numeric](7, 7) NOT NULL CONSTRAINT [DF_ds2000000_ad5] DEFAULT ((0)), [msx] [char](3) NOT NULL CONSTRAINT [DF_ds2000000_msx] DEFAULT (''), [timestamp_column] [timestamp] NOT NULL, [identity_column] [int] IDENTITY(1,1) NOT NULL, [hcode] [char](10) NOT NULL CONSTRAINT [DF_ds2000000_hcode] DEFAULT (''), [scode] [char](10) NOT NULL CONSTRAINT [DF_ds2000000_scode] DEFAULT (''), [saho] [char](10) NOT NULL CONSTRAINT [DF_ds2000000_saho] DEFAULT ('') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[pp1] 스크립트 날짜: 01/21/2015 16:02:26 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[pp1]( [법인코드] [char](3) NOT NULL CONSTRAINT [DF_pp1_법인코드] DEFAULT (''), [공장코드] [char](3) NOT NULL CONSTRAINT [DF_pp1_공장코드] DEFAULT (''), [time] [char](4) NOT NULL CONSTRAINT [DF_pp1_time] DEFAULT (''), [smg1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_smg1] DEFAULT ((0)), [smg2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_smg2] DEFAULT ((0)), [smg3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_smg3] DEFAULT ((0)), [smg4] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_smg4] DEFAULT ((0)), [smg5] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_smg5] DEFAULT ((0)), [sms1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_sms1] DEFAULT ((0)), [sms2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_sms2] DEFAULT ((0)), [sms3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_sms3] DEFAULT ((0)), [ejg1s1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejg1s1] DEFAULT ((0)), [ejg1s2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejg1s2] DEFAULT ((0)), [ejg1s3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejg1s3] DEFAULT ((0)), [ejg2s1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejg2s1] DEFAULT ((0)), [ejg2s2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejg2s2] DEFAULT ((0)), [ejg2s3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejg2s3] DEFAULT ((0)), [ejg3s1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejg3s1] DEFAULT ((0)), [ejg3s2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejg3s2] DEFAULT ((0)), [ejg3s3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejg3s3] DEFAULT ((0)), [ejg4s1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejg4s1] DEFAULT ((0)), [ejg4s2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejg4s2] DEFAULT ((0)), [ejg4s3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejg4s3] DEFAULT ((0)), [ejg5s1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejg5s1] DEFAULT ((0)), [ejg5s2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejg5s2] DEFAULT ((0)), [ejg5s3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejg5s3] DEFAULT ((0)), [ejs1g1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejs1g1] DEFAULT ((0)), [ejs1g2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejs1g2] DEFAULT ((0)), [ejs1g3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejs1g3] DEFAULT ((0)), [ejs1g4] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejs1g4] DEFAULT ((0)), [ejs1g5] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejs1g5] DEFAULT ((0)), [ejs2g1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejs2g1] DEFAULT ((0)), [ejs2g2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejs2g2] DEFAULT ((0)), [ejs2g3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejs2g3] DEFAULT ((0)), [ejs2g4] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejs2g4] DEFAULT ((0)), [ejs2g5] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejs2g5] DEFAULT ((0)), [ejs3g1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejs3g1] DEFAULT ((0)), [ejs3g2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejs3g2] DEFAULT ((0)), [ejs3g3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejs3g3] DEFAULT ((0)), [ejs3g4] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejs3g4] DEFAULT ((0)), [ejs3g5] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_ejs3g5] DEFAULT ((0)), [hoy1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_hoy1] DEFAULT ((0)), [hoy2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp1_hoy2] DEFAULT ((0)), [lq1] [numeric](3, 0) NOT NULL CONSTRAINT [DF_pp1_lq1] DEFAULT ((0)), [lq2] [numeric](3, 0) NOT NULL CONSTRAINT [DF_pp1_lq2] DEFAULT ((0)), [sx] [char](1) NOT NULL CONSTRAINT [DF_pp1_sx] DEFAULT (''), [w1w2] [char](5) NOT NULL CONSTRAINT [DF_pp1_w1w2] DEFAULT (''), [wchk] [char](3) NOT NULL CONSTRAINT [DF_pp1_wchk] DEFAULT (''), [wqc] [char](2) NOT NULL CONSTRAINT [DF_pp1_wqc] DEFAULT (''), [bno] [char](1) NOT NULL CONSTRAINT [DF_pp1_bno] DEFAULT (''), [g1] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_g1] DEFAULT ((0)), [g2] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_g2] DEFAULT ((0)), [g3] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_g3] DEFAULT ((0)), [g4] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_g4] DEFAULT ((0)), [g5] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_g5] DEFAULT ((0)), [sand] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_sand] DEFAULT ((0)), [sand2] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_sand2] DEFAULT ((0)), [sand3] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_sand3] DEFAULT ((0)), [cement] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_cement] DEFAULT ((0)), [cement2] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_cement2] DEFAULT ((0)), [cement3] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_cement3] DEFAULT ((0)), [water] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_water] DEFAULT ((0)), [water2] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_water2] DEFAULT ((0)), [water3] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_water3] DEFAULT ((0)), [adm] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_adm] DEFAULT ((0)), [adm1] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_adm1] DEFAULT ((0)), [adm2] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_adm2] DEFAULT ((0)), [adm3] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_adm3] DEFAULT ((0)), [adm4] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp1_adm4] DEFAULT ((0)), [spc_time] [numeric](3, 0) NOT NULL CONSTRAINT [DF_pp1_spc_time] DEFAULT ((0)), [gg_drv] [char](10) NOT NULL CONSTRAINT [DF_pp1_gg_drv] DEFAULT (''), [hh_drv] [char](10) NOT NULL CONSTRAINT [DF_pp1_hh_drv] DEFAULT (''), [ad1] [numeric](1, 0) NOT NULL CONSTRAINT [DF_pp1_ad1] DEFAULT ((0)), [ad2] [numeric](1, 0) NOT NULL CONSTRAINT [DF_pp1_ad2] DEFAULT ((0)), [timestamp_column] [timestamp] NOT NULL, [identity_column] [int] IDENTITY(1,1) NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[wBatcher] 스크립트 날짜: 01/21/2015 16:06:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[wBatcher]( [docuno] [char](10) NULL CONSTRAINT [DF_wBatcher_docuno] DEFAULT ('(''")'), [법인코드] [char](3) NULL CONSTRAINT [DF_wBatcher_WapCustCode] DEFAULT ('(''")'), [공장코드] [char](3) NULL CONSTRAINT [DF_wBatcher_WapFactCode] DEFAULT ('(''")'), [DateX] [datetime] NULL CONSTRAINT [DF_wBatcher_DateX] DEFAULT (getdate()), [Hogi] [char](1) NULL CONSTRAINT [DF_wBatcher_Hogi] DEFAULT (''), [TimeX] [char](4) NULL CONSTRAINT [DF_wBatcher_TimeX] DEFAULT (''), [gubun] [char](4) NULL CONSTRAINT [DF_wBatcher_gubun] DEFAULT (''), [BNo] [char](10) NULL CONSTRAINT [DF_wBatcher_BNo] DEFAULT (''), [SNo] [char](5) NULL CONSTRAINT [DF_wBatcher_SNo] DEFAULT ('(''")'), [TypeX] [char](15) NULL CONSTRAINT [DF_wBatcher_TypeX] DEFAULT ('(''")'), [CNo] [char](4) NULL CONSTRAINT [DF_wBatcher_CNo] DEFAULT ('(''")'), [M3] [float] NULL, [pG1] [float] NULL, [pG2] [float] NULL, [pS1] [float] NULL, [pS2] [float] NULL, [G1] [int] NULL, [G2] [int] NULL, [G3] [int] NULL, [S1] [int] NULL, [S2] [int] NULL, [S3] [int] NULL, [C1] [float] NULL, [C2] [float] NULL, [C3] [float] NULL, [W1] [float] NULL, [W2] [float] NULL, [W3] [float] NULL, [A1] [float] NULL, [A2] [float] NULL, [A3] [float] NULL, [A4] [float] NULL, [A5] [float] NULL, [A6] [float] NULL, [A7] [float] NULL, [AppendDate] [datetime] NULL, [EditDate] [datetime] NULL, [DelCheck] [char](1) NULL, [현장사진] [image] NULL, [현장녹음] [image] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[rand1] 스크립트 날짜: 01/21/2015 16:03:23 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[rand1]( [법인코드] [char](3) NOT NULL CONSTRAINT [DF_rand1_법인코드] DEFAULT (''), [공장코드] [char](3) NOT NULL CONSTRAINT [DF_rand1_공장코드] DEFAULT (''), [g1] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_g1] DEFAULT ((0)), [g2] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_g2] DEFAULT ((0)), [g3] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_g3] DEFAULT ((0)), [g4] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_g4] DEFAULT ((0)), [g5] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_g5] DEFAULT ((0)), [s1] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_s1] DEFAULT ((0)), [s2] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_s2] DEFAULT ((0)), [s3] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_s3] DEFAULT ((0)), [c1] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_c1] DEFAULT ((0)), [c2] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_c2] DEFAULT ((0)), [c3] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_c3] DEFAULT ((0)), [w1] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_w1] DEFAULT ((0)), [w2] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_w2] DEFAULT ((0)), [w3] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_w3] DEFAULT ((0)), [ad1] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_ad1] DEFAULT ((0)), [ad2] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_ad2] DEFAULT ((0)), [ad3] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_ad3] DEFAULT ((0)), [ad4] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_ad4] DEFAULT ((0)), [ad5] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_ad5] DEFAULT ((0)), [kan] [numeric](4, 0) NOT NULL CONSTRAINT [DF_rand1_kan] DEFAULT ((0)), [eg1] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand1_eg1] DEFAULT ((0)), [eg2] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand1_eg2] DEFAULT ((0)), [eg3] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand1_eg3] DEFAULT ((0)), [eg4] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand1_eg4] DEFAULT ((0)), [eg5] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand1_eg5] DEFAULT ((0)), [es1] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand1_es1] DEFAULT ((0)), [es2] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand1_es2] DEFAULT ((0)), [es3] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand1_es3] DEFAULT ((0)), [ec1] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand1_ec1] DEFAULT ((0)), [ec2] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand1_ec2] DEFAULT ((0)), [ec3] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand1_ec3] DEFAULT ((0)), [ew1] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand1_ew1] DEFAULT ((0)), [ew2] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand1_ew2] DEFAULT ((0)), [ew3] [numeric](3, 1) NOT NULL, [ead1] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_ead1] DEFAULT ((0)), [ead2] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_ead2] DEFAULT ((0)), [ead3] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_ead3] DEFAULT ((0)), [ead4] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_ead4] DEFAULT ((0)), [ead5] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand1_ead5] DEFAULT ((0)), [bno] [numeric](4, 0) NOT NULL CONSTRAINT [DF_rand1_bno] DEFAULT ((0)), [jag1] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand1_jag1] DEFAULT ((0)), [jag2] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand1_jag2] DEFAULT ((0)), [jag3] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand1_jag3] DEFAULT ((0)), [jag4] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand1_jag4] DEFAULT ((0)), [jag5] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand1_jag5] DEFAULT ((0)), [jas1] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand1_jas1] DEFAULT ((0)), [jas2] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand1_jas2] DEFAULT ((0)), [jas3] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand1_jas3] DEFAULT ((0)), [jac1] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand1_jac1] DEFAULT ((0)), [jac2] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand1_jac2] DEFAULT ((0)), [jac3] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand1_jac3] DEFAULT ((0)), [jaw1] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand1_jaw1] DEFAULT ((0)), [jaw2] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand1_jaw2] DEFAULT ((0)), [jaad1] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand1_jaad1] DEFAULT ((0)), [jaad2] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand1_jaad2] DEFAULT ((0)), [jaad3] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand1_jaad3] DEFAULT ((0)), [jaad4] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand1_jaad4] DEFAULT ((0)), [jaad5] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand1_jaad5] DEFAULT ((0)), [w1w2] [char](7) NOT NULL CONSTRAINT [DF_rand1_w1w2] DEFAULT (''), [timestamp_column] [timestamp] NOT NULL, [identity_column] [int] IDENTITY(1,1) NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[etc1] 스크립트 날짜: 01/21/2015 16:01:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[etc1]( [법인코드] [char](3) NOT NULL CONSTRAINT [DF_etc1_법인코드] DEFAULT (''), [공장코드] [char](3) NOT NULL CONSTRAINT [DF_etc1_공장코드] DEFAULT (''), [c_yn] [char](1) NOT NULL CONSTRAINT [DF_etc1_c_yn] DEFAULT (''), [admult] [char](1) NOT NULL CONSTRAINT [DF_etc1_admult] DEFAULT (''), [admult1] [char](1) NOT NULL CONSTRAINT [DF_etc1_admult1] DEFAULT (''), [stime] [char](4) NOT NULL CONSTRAINT [DF_etc1_stime] DEFAULT (''), [etime] [char](4) NOT NULL CONSTRAINT [DF_etc1_etime] DEFAULT (''), [habini] [char](1) NOT NULL CONSTRAINT [DF_etc1_habini] DEFAULT (''), [prt] [numeric](1, 0) NOT NULL CONSTRAINT [DF_etc1_prt] DEFAULT ((0)), [prt_port] [char](3) NOT NULL CONSTRAINT [DF_etc1_prt_port] DEFAULT (''), [timestamp_column] [timestamp] NOT NULL, [identity_column] [int] IDENTITY(1,1) NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[etc2] 스크립트 날짜: 01/21/2015 16:01:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[etc2]( [법인코드] [char](3) NOT NULL CONSTRAINT [DF_etc2_법인코드] DEFAULT (''), [공장코드] [char](3) NOT NULL CONSTRAINT [DF_etc2_공장코드] DEFAULT (''), [c_yn] [char](1) NOT NULL CONSTRAINT [DF_etc2_c_yn] DEFAULT (''), [admult] [char](1) NOT NULL CONSTRAINT [DF_etc2_admult] DEFAULT (''), [admult1] [char](1) NOT NULL CONSTRAINT [DF_etc2_admult1] DEFAULT (''), [stime] [char](4) NOT NULL CONSTRAINT [DF_etc2_stime] DEFAULT (''), [etime] [char](4) NOT NULL CONSTRAINT [DF_etc2_etime] DEFAULT (''), [habini] [char](1) NOT NULL CONSTRAINT [DF_etc2_habini] DEFAULT (''), [prt] [numeric](1, 0) NOT NULL CONSTRAINT [DF_etc2_prt] DEFAULT ((0)), [prt_port] [char](3) NOT NULL CONSTRAINT [DF_etc2_prt_port] DEFAULT (''), [timestamp_column] [timestamp] NOT NULL, [identity_column] [int] IDENTITY(1,1) NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[hjbhap] 스크립트 날짜: 01/21/2015 16:01:23 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[hjbhap]( [docuno] [char](10) NOT NULL CONSTRAINT [DF_hjbhap_docuno] DEFAULT (''), [법인코드] [varchar](3) NULL CONSTRAINT [DF_hjbhap_법인코드] DEFAULT (''), [공장코드] [varchar](3) NULL CONSTRAINT [DF_hjbhap_공장코드] DEFAULT (''), [saho] [varchar](40) NULL CONSTRAINT [DF_hjbhap_saho] DEFAULT (''), [hyun] [varchar](50) NULL CONSTRAINT [DF_hjbhap_hyun] DEFAULT (''), [msx] [varchar](3) NULL CONSTRAINT [DF_hjbhap_msx] DEFAULT (''), [sno] [numeric](4, 0) NULL CONSTRAINT [DF_hjbhap_sno] DEFAULT ((0)), [type] [varchar](12) NULL CONSTRAINT [DF_hjbhap_type] DEFAULT (''), [cdate] [datetime] NULL CONSTRAINT [DF_hjbhap_cdate] DEFAULT (getdate()) ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[mdesign] 스크립트 날짜: 01/21/2015 16:01:52 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[mdesign]( [법인코드] [char](3) NOT NULL CONSTRAINT [DF_mdesign_법인코드] DEFAULT (''), [공장코드] [char](3) NOT NULL CONSTRAINT [DF_mdesign_공장코드] DEFAULT (''), [msx] [numeric](3, 0) NOT NULL CONSTRAINT [DF_mdesign_msx] DEFAULT (''), [code] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mdesign_code] DEFAULT ((0)), [gmax] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mdesign_gmax] DEFAULT (''), [hcgd] [numeric](4, 1) NOT NULL CONSTRAINT [DF_mdesign_hcgd] DEFAULT ((0)), [slmp] [numeric](4, 0) NOT NULL CONSTRAINT [DF_mdesign_slmp] DEFAULT ((0)), [g40] [numeric](4, 0) NULL CONSTRAINT [DF_mdesign_g40] DEFAULT ((0)), [g25] [numeric](4, 0) NULL CONSTRAINT [DF_mdesign_g25] DEFAULT ((0)), [g19] [numeric](4, 0) NULL CONSTRAINT [DF_mdesign_g19] DEFAULT ((0)), [g13] [numeric](4, 0) NULL CONSTRAINT [DF_mdesign_g13] DEFAULT ((0)), [sand] [numeric](4, 0) NULL CONSTRAINT [DF_mdesign_sand] DEFAULT ((0)), [sand2] [numeric](4, 0) NULL CONSTRAINT [DF_mdesign_sand2] DEFAULT ((0)), [sand3] [numeric](4, 0) NULL CONSTRAINT [DF_mdesign_sand3] DEFAULT ((0)), [cement] [numeric](4, 0) NULL CONSTRAINT [DF_mdesign_cement] DEFAULT ((0)), [cement2] [numeric](4, 0) NULL CONSTRAINT [DF_mdesign_cement2] DEFAULT ((0)), [cement3] [numeric](4, 0) NULL CONSTRAINT [DF_mdesign_cement3] DEFAULT ((0)), [cement4] [numeric](4, 0) NULL CONSTRAINT [DF_mdesign_cement4] DEFAULT ((0)), [water] [numeric](4, 0) NULL CONSTRAINT [DF_mdesign_water] DEFAULT ((0)), [water2] [numeric](4, 0) NULL CONSTRAINT [DF_mdesign_water2] DEFAULT ((0)), [adm] [numeric](5, 2) NULL CONSTRAINT [DF_mdesign_adm] DEFAULT ((0)), [adm1] [numeric](5, 2) NULL CONSTRAINT [DF_mdesign_adm1] DEFAULT ((0)), [adm2] [numeric](5, 2) NULL CONSTRAINT [DF_mdesign_adm2] DEFAULT ((0)), [adm3] [numeric](5, 2) NULL CONSTRAINT [DF_mdesign_adm3] DEFAULT ((0)), [g44] [numeric](4, 0) NULL CONSTRAINT [DF_mdesign_g44] DEFAULT ((0)), [utw] [numeric](4, 0) NULL CONSTRAINT [DF_mdesign_utw] DEFAULT ((0)), [wc] [numeric](4, 1) NULL CONSTRAINT [DF_mdesign_wc] DEFAULT ((0)), [wc1] [numeric](4, 1) NULL CONSTRAINT [DF_mdesign_wc1] DEFAULT ((0)), [sa] [numeric](4, 1) NULL CONSTRAINT [DF_mdesign_sa] DEFAULT ((0)), [sa1] [numeric](4, 1) NULL CONSTRAINT [DF_mdesign_sa1] DEFAULT ((0)), [mname] [char](10) NULL CONSTRAINT [DF_mdesign_mname] DEFAULT (''), [hhsy] [numeric](4, 1) NULL CONSTRAINT [DF_mdesign_hhsy] DEFAULT ((0)), [bdgs] [numeric](4, 2) NULL CONSTRAINT [DF_mdesign_bdgs] DEFAULT ((0)), [mc1] [numeric](4, 1) NULL CONSTRAINT [DF_mdesign_mc1] DEFAULT ((0)), [mabw] [numeric](4, 1) NULL CONSTRAINT [DF_mdesign_mabw] DEFAULT ((0)), [mbsa] [numeric](4, 1) NULL CONSTRAINT [DF_mdesign_mbsa] DEFAULT ((0)), [psa] [numeric](4, 1) NULL CONSTRAINT [DF_mdesign_psa] DEFAULT ((0)), [mw] [numeric](4, 1) NULL CONSTRAINT [DF_mdesign_mw] DEFAULT ((0)), [mabsa] [numeric](4, 1) NULL CONSTRAINT [DF_mdesign_mabsa] DEFAULT ((0)), [adm4] [numeric](5, 2) NULL CONSTRAINT [DF_mdesign_adm4] DEFAULT ((0)), [adm5] [numeric](5, 2) NULL CONSTRAINT [DF_mdesign_adm5] DEFAULT ((0)), [adm6] [numeric](5, 2) NULL CONSTRAINT [DF_mdesign_adm6] DEFAULT ((0)), [adm7] [numeric](5, 2) NULL CONSTRAINT [DF_mdesign_adm7] DEFAULT ((0)), [adm8] [numeric](5, 2) NULL CONSTRAINT [DF_mdesign_adm8] DEFAULT ((0)), [adm9] [numeric](5, 2) NULL CONSTRAINT [DF_mdesign_adm9] DEFAULT ((0)), [mmult] [numeric](3, 0) NULL CONSTRAINT [DF_mdesign_mmult] DEFAULT ((0)), [mmult1] [numeric](3, 0) NULL CONSTRAINT [DF_mdesign_mmult1] DEFAULT ((0)), [mmult2] [numeric](3, 0) NULL CONSTRAINT [DF_mdesign_mmult2] DEFAULT ((0)), [mmult3] [numeric](3, 0) NULL CONSTRAINT [DF_mdesign_mmult3] DEFAULT ((0)), [mmult4] [numeric](3, 0) NULL CONSTRAINT [DF_mdesign_mmult4] DEFAULT ((0)), [mmult5] [numeric](3, 0) NULL CONSTRAINT [DF_mdesign_mmult5] DEFAULT ((0)), [mmult6] [numeric](3, 0) NULL CONSTRAINT [DF_mdesign_mmult6] DEFAULT ((0)), [mmult7] [numeric](3, 0) NULL CONSTRAINT [DF_mdesign_mmult7] DEFAULT ((0)), [mmult8] [numeric](3, 0) NULL CONSTRAINT [DF_mdesign_mmult8] DEFAULT ((0)), [mmult9] [numeric](3, 0) NULL CONSTRAINT [DF_mdesign_mmult9] DEFAULT ((0)), [type] [char](13) NOT NULL CONSTRAINT [DF_mdesign_type] DEFAULT (''), [gol1] [numeric](5, 0) NULL CONSTRAINT [DF_mdesign_gol1] DEFAULT ((0)), [gol2] [numeric](5, 0) NULL CONSTRAINT [DF_mdesign_gol2] DEFAULT ((0)), [gol3] [numeric](5, 0) NULL CONSTRAINT [DF_mdesign_gol3] DEFAULT ((0)), [gol4] [numeric](5, 0) NULL CONSTRAINT [DF_mdesign_gol4] DEFAULT ((0)), [ks_gu] [char](1) NULL CONSTRAINT [DF_mdesign_ks_gu] DEFAULT (''), [ad_gu] [char](10) NULL CONSTRAINT [DF_mdesign_ad_gu] DEFAULT (''), [ad_sei] [numeric](3, 0) NULL CONSTRAINT [DF_mdesign_ad_sei] DEFAULT ((0)), [cement5] [numeric](4, 0) NULL CONSTRAINT [DF_mdesign_cement5] DEFAULT ((0)), [adm10] [numeric](5, 2) NULL CONSTRAINT [DF_mdesign_adm10] DEFAULT ((0)), [adm11] [numeric](5, 2) NULL CONSTRAINT [DF_mdesign_adm11] DEFAULT ((0)), [adm12] [numeric](5, 2) NULL CONSTRAINT [DF_mdesign_adm12] DEFAULT ((0)), [adm13] [numeric](5, 2) NULL CONSTRAINT [DF_mdesign_adm13] DEFAULT ((0)), [adm14] [numeric](5, 2) NULL CONSTRAINT [DF_mdesign_adm14] DEFAULT ((0)), [adm15] [numeric](5, 2) NULL CONSTRAINT [DF_mdesign_adm15] DEFAULT ((0)), [mmult10] [numeric](3, 0) NULL CONSTRAINT [DF_mdesign_mmult10] DEFAULT ((0)), [mmult11] [numeric](3, 0) NULL CONSTRAINT [DF_mdesign_mmult11] DEFAULT ((0)), [mmult12] [numeric](3, 0) NULL CONSTRAINT [DF_mdesign_mmult12] DEFAULT ((0)), [mmult13] [numeric](3, 0) NULL CONSTRAINT [DF_mdesign_mmult13] DEFAULT ((0)), [mmult14] [numeric](3, 0) NULL CONSTRAINT [DF_mdesign_mmult14] DEFAULT ((0)), [mmult15] [numeric](3, 0) NULL CONSTRAINT [DF_mdesign_mmult15] DEFAULT ((0)), [water3] [numeric](6, 1) NULL CONSTRAINT [DF_mdesign_water3] DEFAULT ((0)) ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[da2000000] 스크립트 날짜: 01/21/2015 15:59:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[da2000000]( [법인코드] [char](3) NOT NULL CONSTRAINT [DF_da2000000_법인코드] DEFAULT (''), [공장코드] [char](3) NOT NULL CONSTRAINT [DF_da2000000_공장코드] DEFAULT (''), [date] [datetime] NOT NULL CONSTRAINT [DF_da2000000_date] DEFAULT (getdate()), [time] [char](10) NOT NULL CONSTRAINT [DF_da2000000_time] DEFAULT (''), [bno] [char](8) NOT NULL CONSTRAINT [DF_da2000000_bno] DEFAULT (''), [sno] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da2000000_sno] DEFAULT ((0)), [cno] [char](8) NOT NULL CONSTRAINT [DF_da2000000_cno] DEFAULT (''), [m3] [numeric](7, 2) NOT NULL CONSTRAINT [DF_da2000000_m3] DEFAULT ((0)), [sms1] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da2000000_sms1] DEFAULT ((0)), [sms2] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da2000000_sms2] DEFAULT ((0)), [smg1] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da2000000_smg1] DEFAULT ((0)), [smg2] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da2000000_smg2] DEFAULT ((0)), [s1g1] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da2000000_s1g1] DEFAULT ((0)), [s2g2] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da2000000_s2g2] DEFAULT ((0)), [g1s1] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da2000000_g1s1] DEFAULT ((0)), [g2s2] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da2000000_g2s2] DEFAULT ((0)), [type] [char](15) NOT NULL CONSTRAINT [DF_da2000000_type] DEFAULT (''), [g1] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da2000000_g1] DEFAULT ((0)), [g2] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da2000000_g2] DEFAULT ((0)), [g3] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da2000000_g3] DEFAULT ((0)), [g4] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da2000000_g4] DEFAULT ((0)), [g5] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da2000000_g5] DEFAULT ((0)), [s1] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da2000000_s1] DEFAULT ((0)), [s2] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da2000000_s2] DEFAULT ((0)), [c1] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da2000000_c1] DEFAULT ((0)), [c2] [numeric](8, 0) NOT NULL CONSTRAINT [DF_da2000000_c2] DEFAULT ((0)), [c3] [numeric](8, 1) NOT NULL CONSTRAINT [DF_da2000000_c3] DEFAULT ((0)), [w1] [numeric](7, 1) NOT NULL CONSTRAINT [DF_da2000000_w1] DEFAULT ((0)), [w2] [numeric](7, 1) NOT NULL CONSTRAINT [DF_da2000000_w2] DEFAULT ((0)), [ad1] [numeric](8, 2) NOT NULL CONSTRAINT [DF_da2000000_ad1] DEFAULT ((0)), [ad2] [numeric](7, 2) NOT NULL CONSTRAINT [DF_da2000000_ad2] DEFAULT ((0)), [ad3] [numeric](7, 2) NOT NULL CONSTRAINT [DF_da2000000_ad3] DEFAULT ((0)), [ad4] [numeric](7, 2) NOT NULL CONSTRAINT [DF_da2000000_ad4] DEFAULT ((0)), [ad5] [numeric](7, 2) NOT NULL CONSTRAINT [DF_da2000000_ad5] DEFAULT ((0)), [msx] [char](3) NOT NULL CONSTRAINT [DF_da2000000_msx] DEFAULT (''), [timestamp_column] [timestamp] NOT NULL, [identity_column] [int] IDENTITY(1,1) NOT NULL, [hcode] [char](10) NOT NULL CONSTRAINT [DF_da2000000_hcode] DEFAULT (''), [scode] [char](10) NOT NULL CONSTRAINT [DF_da2000000_scode] DEFAULT (''), [saho] [char](60) NOT NULL CONSTRAINT [DF_da2000000_saho] DEFAULT ('') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[ds1000000] 스크립트 날짜: 01/21/2015 16:00:38 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ds1000000]( [법인코드] [char](3) NULL CONSTRAINT [DF_ds1000000_법인코드] DEFAULT (''), [공장코드] [char](3) NULL CONSTRAINT [DF_ds1000000_공장코드] DEFAULT (''), [date] [smalldatetime] NULL CONSTRAINT [DF_ds1000000_date] DEFAULT (getdate()), [time] [char](10) NULL CONSTRAINT [DF_ds1000000_time] DEFAULT (''), [bno] [char](8) NULL CONSTRAINT [DF_ds1000000_bno] DEFAULT (''), [sno] [numeric](8, 0) NULL CONSTRAINT [DF_ds1000000_sno] DEFAULT ((0)), [cno] [char](8) NULL CONSTRAINT [DF_ds1000000_cno] DEFAULT (''), [m3] [numeric](7, 2) NULL CONSTRAINT [DF_ds1000000_m3] DEFAULT ((0)), [sms1] [numeric](8, 1) NULL CONSTRAINT [DF_ds1000000_sms1] DEFAULT ((0)), [sms2] [numeric](8, 1) NULL CONSTRAINT [DF_ds1000000_sms2] DEFAULT ((0)), [sms3] [numeric](8, 1) NULL, [sms4] [numeric](8, 1) NULL, [sms5] [numeric](8, 1) NULL, [smg1] [numeric](8, 1) NULL CONSTRAINT [DF_ds1000000_smg1] DEFAULT ((0)), [smg2] [numeric](8, 1) NULL CONSTRAINT [DF_ds1000000_smg2] DEFAULT ((0)), [smg3] [numeric](8, 1) NULL, [smg4] [numeric](8, 1) NULL, [smg5] [numeric](8, 1) NULL, [s1g1] [numeric](8, 1) NULL CONSTRAINT [DF_ds1000000_s1g1] DEFAULT ((0)), [s2g2] [numeric](8, 1) NULL CONSTRAINT [DF_ds1000000_s2g2] DEFAULT ((0)), [s3g3] [numeric](8, 1) NULL, [s4g4] [numeric](8, 1) NULL, [s5g5] [numeric](8, 1) NULL, [g1s1] [numeric](8, 1) NULL, [g2s2] [numeric](8, 1) NULL CONSTRAINT [DF_ds1000000_g2s2] DEFAULT ((0)), [g3s3] [numeric](8, 1) NULL, [g4s4] [numeric](8, 1) NULL, [g5s5] [numeric](8, 1) NULL, [type] [char](15) NULL CONSTRAINT [DF_ds1000000_type] DEFAULT (''), [g1] [numeric](8, 0) NULL CONSTRAINT [DF_ds1000000_g1] DEFAULT ((0)), [g2] [numeric](8, 0) NULL CONSTRAINT [DF_ds1000000_g2] DEFAULT ((0)), [g3] [numeric](8, 0) NULL CONSTRAINT [DF_ds1000000_g3] DEFAULT ((0)), [g4] [numeric](8, 0) NULL CONSTRAINT [DF_ds1000000_g4] DEFAULT ((0)), [g5] [numeric](8, 0) NULL CONSTRAINT [DF_ds1000000_g5] DEFAULT ((0)), [s1] [numeric](8, 0) NULL CONSTRAINT [DF_ds1000000_s1] DEFAULT ((0)), [s2] [numeric](8, 0) NULL CONSTRAINT [DF_ds1000000_s2] DEFAULT ((0)), [s3] [numeric](8, 0) NULL, [s4] [numeric](8, 0) NULL, [s5] [numeric](8, 0) NULL, [c1] [numeric](8, 0) NULL CONSTRAINT [DF_ds1000000_c1] DEFAULT ((0)), [c2] [numeric](8, 0) NULL CONSTRAINT [DF_ds1000000_c2] DEFAULT ((0)), [c3] [numeric](8, 1) NULL CONSTRAINT [DF_ds1000000_c3] DEFAULT ((0)), [c4] [numeric](8, 1) NULL, [c5] [numeric](8, 1) NULL, [w1] [numeric](7, 1) NULL CONSTRAINT [DF_ds1000000_w1] DEFAULT ((0)), [w2] [numeric](7, 1) NULL CONSTRAINT [DF_ds1000000_w2] DEFAULT ((0)), [w3] [numeric](7, 1) NULL, [w4] [numeric](7, 1) NULL, [w5] [numeric](7, 1) NULL, [ad1] [numeric](8, 2) NULL CONSTRAINT [DF_ds1000000_ad1] DEFAULT ((0)), [ad2] [numeric](7, 2) NULL CONSTRAINT [DF_ds1000000_ad2] DEFAULT ((0)), [ad3] [numeric](7, 2) NULL CONSTRAINT [DF_ds1000000_ad3] DEFAULT ((0)), [ad4] [numeric](7, 2) NULL CONSTRAINT [DF_ds1000000_ad5] DEFAULT ((0)), [ad5] [numeric](7, 2) NULL CONSTRAINT [DF_ds1000000_ad4] DEFAULT ((0)), [msx] [char](3) NULL CONSTRAINT [DF_ds1000000_msx] DEFAULT (''), [sl] [numeric](7, 1) NULL, [p] [numeric](7, 1) NULL, [timestamp_column] [timestamp] NULL, [identity_column] [int] IDENTITY(1,1) NOT NULL, [BCNT] [numeric](4, 0) NULL, [BP] [numeric](1, 0) NULL, [GUBUN] [numeric](1, 0) NULL, [hcode] [char](10) NULL CONSTRAINT [DF_ds1000000_hcode] DEFAULT (''), [scode] [char](10) NULL CONSTRAINT [DF_ds1000000_scode] DEFAULT (''), [saho] [char](60) NULL CONSTRAINT [DF_ds1000000_saho] DEFAULT (''), [hyun] [char](60) NULL CONSTRAINT [DF_ds1000000_hyun] DEFAULT ('') ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[생산WT] 스크립트 날짜: 01/21/2015 15:59:10 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[생산WT]( [일자] [datetime] NULL CONSTRAINT [DF_생산WT_일자] DEFAULT (getdate()), [BNO] [numeric](6, 0) NULL CONSTRAINT [DF_생산WT_BNO] DEFAULT (''), [MSX] [numeric](5, 0) NULL CONSTRAINT [DF_생산WT_MSX] DEFAULT ('001'), [SNO] [numeric](5, 0) NULL CONSTRAINT [DF_생산WT_SNO] DEFAULT ((0)), [TYPE] [nvarchar](20) NULL CONSTRAINT [DF_생산WT_TYPE] DEFAULT (''), [LUBE] [numeric](10, 2) NULL CONSTRAINT [DF_생산WT_LUBE] DEFAULT ((0)), [CNO] [numeric](4, 0) NULL CONSTRAINT [DF_생산WT_CNO] DEFAULT (''), [빈] [nvarchar](10) NULL CONSTRAINT [DF_생산WT_빈] DEFAULT (''), [시작] [nvarchar](15) NULL CONSTRAINT [DF_생산WT_시작] DEFAULT ('00:00:00'), [종료] [nvarchar](8) NULL CONSTRAINT [DF_생산WT_종료] DEFAULT ('00:00'), [S중량] [numeric](10, 2) NULL CONSTRAINT [DF_생산WT_S중량] DEFAULT ((0)), [E중량] [numeric](10, 2) NULL CONSTRAINT [DF_생산WT_E중량] DEFAULT ((0)), [중량] [numeric](10, 2) NULL CONSTRAINT [DF_생산WT_중량] DEFAULT ((0)), [AM] [nvarchar](15) NULL CONSTRAINT [DF_생산WT_AM] DEFAULT ('자동'), [WTDI] [nvarchar](15) NULL CONSTRAINT [DF_생산WT_WTDI] DEFAULT ('계량'), [설정] [numeric](10, 2) NULL CONSTRAINT [DF_생산WT_설정] DEFAULT ((0)) ) ON [PRIMARY] GO /****** 개체: Table [dbo].[pp2] 스크립트 날짜: 01/21/2015 16:02:52 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[pp2]( [법인코드] [char](3) NOT NULL CONSTRAINT [DF_pp2_법인코드] DEFAULT (''), [공장코드] [char](3) NOT NULL CONSTRAINT [DF_pp2_공장코드] DEFAULT (''), [time] [char](4) NOT NULL CONSTRAINT [DF_pp2_time] DEFAULT (''), [smg1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_smg1] DEFAULT ((0)), [smg2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_smg2] DEFAULT ((0)), [smg3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_smg3] DEFAULT ((0)), [smg4] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_smg4] DEFAULT ((0)), [smg5] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_smg5] DEFAULT ((0)), [sms1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_sms1] DEFAULT ((0)), [sms2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_sms2] DEFAULT ((0)), [sms3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_sms3] DEFAULT ((0)), [ejg1s1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejg1s1] DEFAULT ((0)), [ejg1s2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejg1s2] DEFAULT ((0)), [ejg1s3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejg1s3] DEFAULT ((0)), [ejg2s1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejg2s1] DEFAULT ((0)), [ejg2s2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejg2s2] DEFAULT ((0)), [ejg2s3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejg2s3] DEFAULT ((0)), [ejg3s1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejg3s1] DEFAULT ((0)), [ejg3s2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejg3s2] DEFAULT ((0)), [ejg3s3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejg3s3] DEFAULT ((0)), [ejg4s1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejg4s1] DEFAULT ((0)), [ejg4s2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejg4s2] DEFAULT ((0)), [ejg4s3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejg4s3] DEFAULT ((0)), [ejg5s1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejg5s1] DEFAULT ((0)), [ejg5s2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejg5s2] DEFAULT ((0)), [ejg5s3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejg5s3] DEFAULT ((0)), [ejs1g1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejs1g1] DEFAULT ((0)), [ejs1g2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejs1g2] DEFAULT ((0)), [ejs1g3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejs1g3] DEFAULT ((0)), [ejs1g4] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejs1g4] DEFAULT ((0)), [ejs1g5] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejs1g5] DEFAULT ((0)), [ejs2g1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejs2g1] DEFAULT ((0)), [ejs2g2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejs2g2] DEFAULT ((0)), [ejs2g3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejs2g3] DEFAULT ((0)), [ejs2g4] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejs2g4] DEFAULT ((0)), [ejs2g5] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejs2g5] DEFAULT ((0)), [ejs3g1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejs3g1] DEFAULT ((0)), [ejs3g2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejs3g2] DEFAULT ((0)), [ejs3g3] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejs3g3] DEFAULT ((0)), [ejs3g4] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejs3g4] DEFAULT ((0)), [ejs3g5] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_ejs3g5] DEFAULT ((0)), [hoy1] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_hoy1] DEFAULT ((0)), [hoy2] [numeric](4, 2) NOT NULL CONSTRAINT [DF_pp2_hoy2] DEFAULT ((0)), [lq1] [numeric](3, 0) NOT NULL CONSTRAINT [DF_pp2_lq1] DEFAULT ((0)), [lq2] [numeric](3, 0) NOT NULL CONSTRAINT [DF_pp2_lq2] DEFAULT ((0)), [sx] [char](1) NOT NULL CONSTRAINT [DF_pp2_sx] DEFAULT (''), [w1w2] [char](5) NOT NULL CONSTRAINT [DF_pp2_w1w2] DEFAULT (''), [wchk] [char](3) NOT NULL CONSTRAINT [DF_pp2_wchk] DEFAULT (''), [wqc] [char](2) NOT NULL CONSTRAINT [DF_pp2_wqc] DEFAULT (''), [bno] [char](1) NOT NULL CONSTRAINT [DF_pp2_bno] DEFAULT (''), [g1] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_g1] DEFAULT ((0)), [g2] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_g2] DEFAULT ((0)), [g3] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_g3] DEFAULT ((0)), [g4] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_g4] DEFAULT ((0)), [g5] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_g5] DEFAULT ((0)), [sand] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_sand] DEFAULT ((0)), [sand2] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_sand2] DEFAULT ((0)), [sand3] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_sand3] DEFAULT ((0)), [cement] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_cement] DEFAULT ((0)), [cement2] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_cement2] DEFAULT ((0)), [cement3] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_cement3] DEFAULT ((0)), [water] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_water] DEFAULT ((0)), [water2] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_water2] DEFAULT ((0)), [water3] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_water3] DEFAULT ((0)), [adm] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_adm] DEFAULT ((0)), [adm1] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_adm1] DEFAULT ((0)), [adm2] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_adm2] DEFAULT ((0)), [adm3] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_adm3] DEFAULT ((0)), [adm4] [numeric](2, 0) NOT NULL CONSTRAINT [DF_pp2_adm4] DEFAULT ((0)), [spc_time] [numeric](3, 0) NOT NULL CONSTRAINT [DF_pp2_spc_time] DEFAULT ((0)), [gg_drv] [char](10) NOT NULL CONSTRAINT [DF_pp2_gg_drv] DEFAULT (''), [hh_drv] [char](10) NOT NULL CONSTRAINT [DF_pp2_hh_drv] DEFAULT (''), [ad1] [numeric](1, 0) NOT NULL CONSTRAINT [DF_pp2_ad1] DEFAULT ((0)), [ad2] [numeric](1, 0) NOT NULL CONSTRAINT [DF_pp2_ad2] DEFAULT ((0)), [timestamp_column] [timestamp] NOT NULL, [identity_column] [int] IDENTITY(1,1) NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[rand2] 스크립트 날짜: 01/21/2015 16:06:02 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[rand2]( [법인코드] [char](3) NOT NULL CONSTRAINT [DF_rand2_법인코드] DEFAULT (''), [공장코드] [char](3) NOT NULL CONSTRAINT [DF_rand2_공장코드] DEFAULT (''), [g1] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_g1] DEFAULT ((0)), [g2] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_g2] DEFAULT ((0)), [g3] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_g3] DEFAULT ((0)), [g4] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_g4] DEFAULT ((0)), [g5] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_g5] DEFAULT ((0)), [s1] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_s1] DEFAULT ((0)), [s2] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_s2] DEFAULT ((0)), [s3] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_s3] DEFAULT ((0)), [c1] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_c1] DEFAULT ((0)), [c2] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_c2] DEFAULT ((0)), [c3] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_c3] DEFAULT ((0)), [w1] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_w1] DEFAULT ((0)), [w2] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_w2] DEFAULT ((0)), [w3] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_w3] DEFAULT ((0)), [ad1] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_ad1] DEFAULT ((0)), [ad2] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_ad2] DEFAULT ((0)), [ad3] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_ad3] DEFAULT ((0)), [ad4] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_ad4] DEFAULT ((0)), [ad5] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand2_ad5] DEFAULT ((0)), [kan] [numeric](4, 0) NOT NULL CONSTRAINT [DF_rand2_kan] DEFAULT ((0)), [eg1] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand2_eg1] DEFAULT ((0)), [eg2] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand2_eg2] DEFAULT ((0)), [eg3] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand2_eg3] DEFAULT ((0)), [eg4] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand2_eg4] DEFAULT ((0)), [eg5] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand2_eg5] DEFAULT ((0)), [es1] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand2_es1] DEFAULT ((0)), [es2] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand2_es2] DEFAULT ((0)), [es3] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand2_es3] DEFAULT ((0)), [ec1] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand2_ec1] DEFAULT ((0)), [ec2] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand2_ec2] DEFAULT ((0)), [ec3] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand2_ec3] DEFAULT ((0)), [ew1] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand2_ew1] DEFAULT ((0)), [ew2] [numeric](3, 1) NOT NULL CONSTRAINT [DF_rand2_ew2] DEFAULT ((0)), [ew3] [numeric](3, 1) NOT NULL, [ead1] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_ead1] DEFAULT ((0)), [ead2] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_ead2] DEFAULT ((0)), [ead3] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_ead3] DEFAULT ((0)), [ead4] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_ead4] DEFAULT ((0)), [ead5] [numeric](3, 2) NOT NULL CONSTRAINT [DF_rand2_ead5] DEFAULT ((0)), [bno] [numeric](4, 0) NOT NULL CONSTRAINT [DF_rand2_bno] DEFAULT ((0)), [jag1] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand2_jag1] DEFAULT ((0)), [jag2] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand2_jag2] DEFAULT ((0)), [jag3] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand2_jag3] DEFAULT ((0)), [jag4] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand2_jag4] DEFAULT ((0)), [jag5] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand2_jag5] DEFAULT ((0)), [jas1] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand2_jas1] DEFAULT ((0)), [jas2] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand2_jas2] DEFAULT ((0)), [jas3] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand2_jas3] DEFAULT ((0)), [jac1] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand2_jac1] DEFAULT ((0)), [jac2] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand2_jac2] DEFAULT ((0)), [jac3] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand2_jac3] DEFAULT ((0)), [jaw1] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand2_jaw1] DEFAULT ((0)), [jaw2] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand2_jaw2] DEFAULT ((0)), [jaad1] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand2_jaad1] DEFAULT ((0)), [jaad2] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand2_jaad2] DEFAULT ((0)), [jaad3] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand2_jaad3] DEFAULT ((0)), [jaad4] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand2_jaad4] DEFAULT ((0)), [jaad5] [numeric](1, 0) NOT NULL CONSTRAINT [DF_rand2_jaad5] DEFAULT ((0)), [w1w2] [char](7) NOT NULL CONSTRAINT [DF_rand2_w1w2] DEFAULT (''), [timestamp_column] [timestamp] NOT NULL, [identity_column] [int] IDENTITY(1,1) NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** 개체: Table [dbo].[공시체대장] 스크립트 날짜: 01/21/2015 15:59:01 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[공시체대장]( [docuno] [char](10) NOT NULL CONSTRAINT [DF_공시체대장_docuno] DEFAULT (''), [법인코드] [varchar](3) NULL CONSTRAINT [DF_공시체대장_법인코드] DEFAULT (''), [공장코드] [varchar](3) NULL CONSTRAINT [DF_공시체대장_공장코드] DEFAULT (''), [ccode] [varchar](3) NULL CONSTRAINT [DF_공시체대장_ccode] DEFAULT (''), [fcode] [varchar](2) NULL CONSTRAINT [DF_공시체대장_fcode] DEFAULT (''), [saho] [varchar](30) NULL CONSTRAINT [DF_공시체대장_saho] DEFAULT (''), [hyun] [varchar](50) NULL CONSTRAINT [DF_공시체대장_hyun] DEFAULT (''), [msx] [varchar](3) NULL CONSTRAINT [DF_공시체대장_msx] DEFAULT (''), [sno] [numeric](4, 0) NULL CONSTRAINT [DF_공시체대장_sno] DEFAULT ((0)), [type] [varchar](12) NULL CONSTRAINT [DF_공시체대장_type] DEFAULT (''), [cdate] [datetime] NULL CONSTRAINT [DF_공시체대장_cdate] DEFAULT (getdate()), [cno] [varchar](5) NULL CONSTRAINT [DF_공시체대장_cno] DEFAULT (''), [name] [varchar](10) NULL CONSTRAINT [DF_공시체대장_name] DEFAULT (''), [time] [varchar](4) NULL CONSTRAINT [DF_공시체대장_time] DEFAULT (''), [slump] [numeric](3, 0) NULL CONSTRAINT [DF_공시체대장_slump] DEFAULT ((0)), [lube] [numeric](4, 2) NULL CONSTRAINT [DF_공시체대장_lube] DEFAULT ((0)), [condo] [numeric](4, 1) NULL CONSTRAINT [DF_공시체대장_condo] DEFAULT ((0)), [aondo] [numeric](4, 1) NULL CONSTRAINT [DF_공시체대장_aondo] DEFAULT ((0)), [cair] [numeric](4, 1) NULL CONSTRAINT [DF_공시체대장_cair] DEFAULT ((0)), [str7] [numeric](4, 1) NULL CONSTRAINT [DF_공시체대장_str7] DEFAULT ((0)), [str71] [numeric](4, 1) NULL CONSTRAINT [DF_공시체대장_str71] DEFAULT ((0)), [str72] [numeric](4, 1) NULL CONSTRAINT [DF_공시체대장_str72] DEFAULT ((0)), [str73] [numeric](4, 1) NULL CONSTRAINT [DF_공시체대장_str73] DEFAULT ((0)), [str14] [numeric](4, 1) NULL CONSTRAINT [DF_공시체대장_str14] DEFAULT ((0)), [str281] [numeric](4, 1) NULL CONSTRAINT [DF_공시체대장_str281] DEFAULT ((0)), [str282] [numeric](4, 1) NULL CONSTRAINT [DF_공시체대장_str282] DEFAULT ((0)), [str283] [numeric](4, 1) NULL CONSTRAINT [DF_공시체대장_str283] DEFAULT ((0)), [str28] [numeric](4, 1) NULL CONSTRAINT [DF_공시체대장_str28] DEFAULT ((0)), [str45] [numeric](4, 1) NULL CONSTRAINT [DF_공시체대장_str45] DEFAULT ((0)), [sinum] [numeric](2, 0) NULL CONSTRAINT [DF_공시체대장_sinum] DEFAULT ((0)), [cpict] [image] NULL, [posi] [image] NULL, [remk] [char](50) NULL CONSTRAINT [DF_공시체대장_remk] DEFAULT (''), [sremk] [image] NULL, [c_code] [char](5) NULL CONSTRAINT [DF_공시체대장_c_code] DEFAULT (''), [cman] [varchar](15) NULL CONSTRAINT [DF_공시체대장_c_man] DEFAULT (''), [hman] [nchar](15) NULL CONSTRAINT [DF_공시체대장_hman] DEFAULT (''), [clube] [numeric](8, 2) NULL CONSTRAINT [DF_공시체대장_clube] DEFAULT ((0)), [lot] [char](12) NULL CONSTRAINT [DF_공시체대장_lot] DEFAULT (''), [yum] [numeric](7, 5) NULL CONSTRAINT [DF_공시체대장_yum] DEFAULT ((0)), [posi1] [nchar](50) NULL CONSTRAINT [DF_공시체대장_posi1] DEFAULT (N'(" "'')') ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'법인코드' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'공시체대장', @level2type=N'COLUMN',@level2name=N'ccode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'공장코드' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'공시체대장', @level2type=N'COLUMN',@level2name=N'fcode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'거래처명' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'공시체대장', @level2type=N'COLUMN',@level2name=N'saho' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'현장명' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'공시체대장', @level2type=N'COLUMN',@level2name=N'hyun' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'채취일자' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'공시체대장', @level2type=N'COLUMN',@level2name=N'cdate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'슬럼프' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'공시체대장', @level2type=N'COLUMN',@level2name=N'slump' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'콘크리트온도' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'공시체대장', @level2type=N'COLUMN',@level2name=N'condo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'대기온도' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'공시체대장', @level2type=N'COLUMN',@level2name=N'aondo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'콘크리트온도' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'공시체대장', @level2type=N'COLUMN',@level2name=N'cair' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'시료개수' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'공시체대장', @level2type=N'COLUMN',@level2name=N'sinum' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'콘크리트사진' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'공시체대장', @level2type=N'COLUMN',@level2name=N'cpict' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'시료위치사진' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'공시체대장', @level2type=N'COLUMN',@level2name=N'posi' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'비고' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'공시체대장', @level2type=N'COLUMN',@level2name=N'remk' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'음성녹음' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'공시체대장', @level2type=N'COLUMN',@level2name=N'sremk' GO