305 lines
16 KiB
Transact-SQL
305 lines
16 KiB
Transact-SQL
delete from Sys_ButtonToMenu where MenuId='EBF89AED-12B1-438A-8477-007720C1A74E'
|
||
delete from Sys_Menu where MenuId='EBF89AED-12B1-438A-8477-007720C1A74E'
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES ('C6CF24D7-DCC4-4278-9B28-1B45FBA1A99B','보꼼흙욋쩌흙','HJGL/MaterialManage/StockIn.aspx',11,'0A4F9FAA-3FA1-4CCC-A084-3A26E4B9344D','Menu_HJGL',0,1,1)
|
||
GO
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('7D929636-EFCE-4095-BF64-73F8F61907FD','C6CF24D7-DCC4-4278-9B28-1B45FBA1A99B','藤속',1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('C7F15F87-CB76-40C2-86EA-B1A744483D6E','C6CF24D7-DCC4-4278-9B28-1B45FBA1A99B','錦맣',2)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('E0481593-4A4B-48C9-A9D6-AD7190AAC646','C6CF24D7-DCC4-4278-9B28-1B45FBA1A99B','<EFBFBD>뇜',3)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('EC4B3E7C-AF64-4EAA-AEC6-DCEBECDC8F53','C6CF24D7-DCC4-4278-9B28-1B45FBA1A99B','괏닸',4)
|
||
GO
|
||
|
||
|
||
CREATE TABLE [dbo].[Weld_UsingMat](
|
||
[UsingMatId] [nvarchar](50) NOT NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[Jot_ID] [nvarchar](50) NULL,
|
||
[WeldId] [nvarchar](50) NULL,
|
||
[UsingPlanId] [nvarchar](50) NULL,
|
||
[Amount] [decimal](9, 3) NULL,
|
||
[UsingMan] [nvarchar](50) NULL,
|
||
[UsingDate] [datetime] NULL,
|
||
[StoreMan] [nvarchar](50) NULL,
|
||
[Warrantybook] [nvarchar](50) NULL,
|
||
[Number] [nvarchar](50) NULL,
|
||
[IsWelderConfirm] [bit] NULL,
|
||
[IsStoreManConfirm] [bit] NULL,
|
||
[ReturnMat] [decimal](9, 3) NULL,
|
||
[ReturnMatTop] [int] NULL,
|
||
[StockInId] [nvarchar](50) NULL,
|
||
[IsClose] [bit] NULL,
|
||
[IsOnTime] [bit] NULL,
|
||
[UsePosition] [nvarchar](50) NULL,
|
||
[TwoAmount] [decimal](9, 3) NULL,
|
||
CONSTRAINT [PK_Weld_UsingMat] PRIMARY KEY CLUSTERED
|
||
(
|
||
[UsingMatId] ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[Weld_UsingMat] WITH CHECK ADD CONSTRAINT [FK_Weld_UsingMat_Base_Project] FOREIGN KEY([ProjectId])
|
||
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[Weld_UsingMat] CHECK CONSTRAINT [FK_Weld_UsingMat_Base_Project]
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'寮숩' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingMat', @level2type=N'COLUMN',@level2name=N'UsingMatId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'淃커ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingMat', @level2type=N'COLUMN',@level2name=N'ProjectId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'보룹' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingMat', @level2type=N'COLUMN',@level2name=N'Jot_ID'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'보꼼' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingMat', @level2type=N'COLUMN',@level2name=N'WeldId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'쥴痰셕뺍ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingMat', @level2type=N'COLUMN',@level2name=N'UsingPlanId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'쥴痰鑒좆' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingMat', @level2type=N'COLUMN',@level2name=N'Amount'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'쥴痰훙' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingMat', @level2type=N'COLUMN',@level2name=N'UsingMan'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'쥴痰珂쇌' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingMat', @level2type=N'COLUMN',@level2name=N'UsingDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'괏밗逃' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingMat', @level2type=N'COLUMN',@level2name=N'StoreMan'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'醴괏蝎뵀' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingMat', @level2type=N'COLUMN',@level2name=N'Warrantybook'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'직彊뵀' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingMat', @level2type=N'COLUMN',@level2name=N'Number'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'보묏角뤠횅훰' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingMat', @level2type=N'COLUMN',@level2name=N'IsWelderConfirm'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'괏밗逃角뤠횅훰' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingMat', @level2type=N'COLUMN',@level2name=N'IsStoreManConfirm'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'욋닸ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingMat', @level2type=N'COLUMN',@level2name=N'StockInId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角뤠균뻔' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingMat', @level2type=N'COLUMN',@level2name=N'IsClose'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角뤠객珂藁죕（true-객珂，false-灌객珂）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingMat', @level2type=N'COLUMN',@level2name=N'IsOnTime'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'보꼼쥴痰깊' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingMat'
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES ('E7D2D4F1-99D7-4920-8D16-C802F37E2D17','쥴죕셕뺍쩌흙','HJGL/MaterialManage/UsingPlan.aspx',12,'0A4F9FAA-3FA1-4CCC-A084-3A26E4B9344D','Menu_HJGL',0,1,1)
|
||
GO
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('ECBDDF08-EDB2-4ABE-8C3D-EA5A63889C18','E7D2D4F1-99D7-4920-8D16-C802F37E2D17','藤속',1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('34C7226E-3041-470E-987E-D5F1B1DC6427','E7D2D4F1-99D7-4920-8D16-C802F37E2D17','錦맣',2)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('2000E471-6CC4-4758-82F6-86BA3888DEBF','E7D2D4F1-99D7-4920-8D16-C802F37E2D17','<EFBFBD>뇜',3)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('0BF36BAE-EF6F-47B7-B94C-044EF483E3D6','E7D2D4F1-99D7-4920-8D16-C802F37E2D17','괏닸',4)
|
||
GO
|
||
|
||
|
||
CREATE TABLE [dbo].[Weld_UsingPlan](
|
||
[UsingPlanId] [nvarchar](50) NOT NULL,
|
||
[WeldId] [nvarchar](50) NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[Jot_ID] [nvarchar](50) NULL,
|
||
[Amount] [decimal](9, 3) NULL,
|
||
[UsingManOne] [nvarchar](50) NULL,
|
||
[UsingManTwo] [nvarchar](50) NULL,
|
||
[InPutDate] [datetime] NULL,
|
||
[CancelDate] [datetime] NULL,
|
||
[IsCancel] [bit] NULL,
|
||
[IsFinish] [bit] NULL,
|
||
[FinishMan] [nvarchar](50) NULL,
|
||
[OrderTime] [nvarchar](50) NULL,
|
||
[OrderDate] [datetime] NULL,
|
||
[CancelResult] [nvarchar](100) NULL,
|
||
[IsSubmit] [bit] NULL,
|
||
[UsePosition] [nvarchar](50) NULL,
|
||
[UsingUnit] [nvarchar](50) NULL,
|
||
[TeamGroupId] [nvarchar](50) NULL,
|
||
[STE_ID] [nvarchar](500) NULL,
|
||
[STE_Name] [nvarchar](500) NULL,
|
||
[IsNeedConfirm] [bit] NULL,
|
||
[InPutMan] [nvarchar](50) NULL,
|
||
[IsSteelStru] [bit] NULL,
|
||
[Type] [char](1) NULL,
|
||
CONSTRAINT [PK_Weld_UsingPlan] PRIMARY KEY CLUSTERED
|
||
(
|
||
[UsingPlanId] ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
) 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'Weld_UsingPlan', @level2type=N'COLUMN',@level2name=N'UsingPlanId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'보꼼ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingPlan', @level2type=N'COLUMN',@level2name=N'WeldId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'淃커ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingPlan', @level2type=N'COLUMN',@level2name=N'ProjectId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'보룹' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingPlan', @level2type=N'COLUMN',@level2name=N'Jot_ID'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鑒좆' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingPlan', @level2type=N'COLUMN',@level2name=N'Amount'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'뒤寧쥴죕훙' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingPlan', @level2type=N'COLUMN',@level2name=N'UsingManOne'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'뒤랗쥴죕훙' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingPlan', @level2type=N'COLUMN',@level2name=N'UsingManTwo'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'쩌흙珂쇌' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingPlan', @level2type=N'COLUMN',@level2name=N'InPutDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鱗록珂쇌' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingPlan', @level2type=N'COLUMN',@level2name=N'CancelDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角뤠鱗록' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingPlan', @level2type=N'COLUMN',@level2name=N'IsCancel'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'써監훙寧괏밗逃' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingPlan', @level2type=N'COLUMN',@level2name=N'FinishMan'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'渡獨쥴죕珂쇌' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingPlan', @level2type=N'COLUMN',@level2name=N'OrderTime'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'渡獨휑퍅' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingPlan', @level2type=N'COLUMN',@level2name=N'OrderDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'鱗록覩凜' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingPlan', @level2type=N'COLUMN',@level2name=N'CancelResult'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角뤠瓊슥' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingPlan', @level2type=N'COLUMN',@level2name=N'IsSubmit'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'쥴죕셕뺍쩌흙깊' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_UsingPlan'
|
||
GO
|
||
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[Weld_RecycleMat](
|
||
[RecycleMatId] [nvarchar](50) NOT NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[Jot_ID] [nvarchar](50) NULL,
|
||
[WeldId] [nvarchar](50) NULL,
|
||
[UsingMatId] [nvarchar](50) NULL,
|
||
[UsingPlanId] [nvarchar](50) NULL,
|
||
[RecycleAmount] [numeric](9, 3) NULL,
|
||
[UsingAmount] [numeric](9, 3) NULL,
|
||
[RecycleMan] [nvarchar](50) NULL,
|
||
[RecycleDate] [datetime] NULL,
|
||
[StockMan] [nvarchar](50) NULL,
|
||
[Warrantybook] [nvarchar](50) NULL,
|
||
[Number] [nvarchar](50) NULL,
|
||
[IsWelderConfirm] [bit] NULL,
|
||
[IsStoreManConfirm] [bit] NULL,
|
||
[ReturnMat] [numeric](9, 3) NULL,
|
||
[ReturnMatTop] [int] NULL,
|
||
[UsePosition] [nvarchar](50) NULL,
|
||
CONSTRAINT [PK_Weld_RecycleMat] PRIMARY KEY CLUSTERED
|
||
(
|
||
[RecycleMatId] ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[Weld_RecycleMat] WITH CHECK ADD CONSTRAINT [FK_Weld_RecycleMat_Weld_RecycleMat] FOREIGN KEY([ProjectId])
|
||
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[Weld_RecycleMat] CHECK CONSTRAINT [FK_Weld_RecycleMat_Weld_RecycleMat]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[Weld_RecycleMat] WITH CHECK ADD CONSTRAINT [FK_Weld_RecycleMat_Weld_UsingMat] FOREIGN KEY([UsingMatId])
|
||
REFERENCES [dbo].[Weld_UsingMat] ([UsingMatId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[Weld_RecycleMat] CHECK CONSTRAINT [FK_Weld_RecycleMat_Weld_UsingMat]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[Weld_RecycleMat] WITH CHECK ADD CONSTRAINT [FK_Weld_RecycleMat_Weld_UsingPlan] FOREIGN KEY([UsingPlanId])
|
||
REFERENCES [dbo].[Weld_UsingPlan] ([UsingPlanId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[Weld_RecycleMat] CHECK CONSTRAINT [FK_Weld_RecycleMat_Weld_UsingPlan]
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'寮숩' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_RecycleMat', @level2type=N'COLUMN',@level2name=N'RecycleMatId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'淃커ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_RecycleMat', @level2type=N'COLUMN',@level2name=N'ProjectId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'보룹' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_RecycleMat', @level2type=N'COLUMN',@level2name=N'Jot_ID'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'보꼼ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_RecycleMat', @level2type=N'COLUMN',@level2name=N'WeldId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'쥴죕ID（깃션닒硅데藁쀼）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_RecycleMat', @level2type=N'COLUMN',@level2name=N'UsingMatId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'쥴痰셕뺍ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_RecycleMat', @level2type=N'COLUMN',@level2name=N'UsingPlanId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'쀼澗鑒좆' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_RecycleMat', @level2type=N'COLUMN',@level2name=N'RecycleAmount'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'쥴痰鑒좆' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_RecycleMat', @level2type=N'COLUMN',@level2name=N'UsingAmount'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'藁쀼훙' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_RecycleMat', @level2type=N'COLUMN',@level2name=N'RecycleMan'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'藁쀼휑퍅' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_RecycleMat', @level2type=N'COLUMN',@level2name=N'RecycleDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'괏밗逃횅훰' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_RecycleMat', @level2type=N'COLUMN',@level2name=N'StockMan'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'醴괏蝎뵀' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_RecycleMat', @level2type=N'COLUMN',@level2name=N'Warrantybook'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'직彊뵀' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_RecycleMat', @level2type=N'COLUMN',@level2name=N'Number'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'藁죕훙횅훰' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_RecycleMat', @level2type=N'COLUMN',@level2name=N'IsWelderConfirm'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'괏밗逃횅훰' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_RecycleMat', @level2type=N'COLUMN',@level2name=N'IsStoreManConfirm'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'보꼼쀼澗깊' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Weld_RecycleMat'
|
||
GO
|
||
|
||
|