261 lines
13 KiB
Transact-SQL
261 lines
13 KiB
Transact-SQL
|
||
CREATE TABLE [dbo].[DriverPrepare_DriverDataType](
|
||
[DriverDataTypeId] [nvarchar](50) NOT NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[DriverDataTypeCode] [nvarchar](50) NULL,
|
||
[DriverDataTypeName] [nvarchar](50) NULL,
|
||
[ParentId] [nvarchar](50) NULL,
|
||
CONSTRAINT [PK_DriverPrepare_DriverDataType] PRIMARY KEY CLUSTERED
|
||
(
|
||
[DriverDataTypeId] 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].[DriverPrepare_DriverDataType] WITH CHECK ADD CONSTRAINT [FK_DriverPrepare_DriverDataType_Base_Project] FOREIGN KEY([ProjectId])
|
||
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[DriverPrepare_DriverDataType] CHECK CONSTRAINT [FK_DriverPrepare_DriverDataType_Base_Project]
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'寮숩' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DriverDataType', @level2type=N'COLUMN',@level2name=N'DriverDataTypeId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'淃커Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DriverDataType', @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'DriverPrepare_DriverDataType', @level2type=N'COLUMN',@level2name=N'DriverDataTypeCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'잚깎츰냔' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DriverDataType', @level2type=N'COLUMN',@level2name=N'DriverDataTypeName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'만섬Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DriverDataType', @level2type=N'COLUMN',@level2name=N'ParentId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'역났栗죕澗섞잚깎깊' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DriverDataType'
|
||
GO
|
||
|
||
|
||
alter table [dbo].[DriverPrepare_DriverData] add DriverDataTypeId nvarchar(50) null
|
||
GO
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[DriverPrepare_DutyItem](
|
||
[DutyItemId] [nvarchar](50) NOT NULL,
|
||
[DutyId] [nvarchar](50) NULL,
|
||
[Stage] [nvarchar](50) NULL,
|
||
[Code] [int] NULL,
|
||
[ActivityContent] [nvarchar](50) NULL,
|
||
[Item1] [bit] NULL,
|
||
[Item2] [bit] NULL,
|
||
[Item3] [bit] NULL,
|
||
[Item4] [bit] NULL,
|
||
[Item5] [bit] NULL,
|
||
[Item6] [bit] NULL,
|
||
[Item7] [bit] NULL,
|
||
[Item8] [bit] NULL,
|
||
[Item9] [bit] NULL,
|
||
[Item10] [bit] NULL,
|
||
[Item11] [bit] NULL,
|
||
[Item12] [bit] NULL,
|
||
[Item13] [bit] NULL,
|
||
[Item14] [bit] NULL,
|
||
[Remark] [nvarchar](200) NULL,
|
||
CONSTRAINT [PK_DriverPrepare_DutyItem] PRIMARY KEY CLUSTERED
|
||
(
|
||
[DutyItemId] 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
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'寮숩' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'DutyItemId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'棍숩' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'DutyId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'쌓뙈' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'Stage'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'埼뵀' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'Code'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'삶땡코휭' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'ActivityContent'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'세減匡숭긍齡' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'Item1'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'꾸鱗방넋긍齡' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'Item2'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'茄嘉렘갭긍齡' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'Item3'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'세減 寧돔' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'Item4'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'줄珂 대嘉' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'Item5'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'莉廉 寧뿐' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'Item6'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'꾸鱗 獵契' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'Item7'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'션쩌 괩멩' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'Item8'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'무痰묏넋괏崍' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'Item9'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'覩죕 묩壇' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'Item10'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'롸驕 뺏駱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'Item11'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'괏頓' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'Item12'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'구틔구숭묩壇' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'Item13'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'끓놔膠죕뇹零' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'Item14'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'구鬧' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem', @level2type=N'COLUMN',@level2name=N'Remark'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'역났삶땡得훨롸묏츠玖깊' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_DutyItem'
|
||
GO
|
||
|
||
|
||
alter table [dbo].[DriverPrepare_Duty] alter column [DutyName] nvarchar(50) null
|
||
alter table [dbo].[DriverPrepare_Duty] alter column [DutyCode] nvarchar(50) null
|
||
GO
|
||
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[DriverPrepare_SchemePlanItem](
|
||
[SchemePlanItemId] [nvarchar](50) NOT NULL,
|
||
[SchemePlanId] [nvarchar](50) NULL,
|
||
[SolutionName] [nvarchar](100) NULL,
|
||
[SortIndex] [int] NULL,
|
||
CONSTRAINT [PK_DriverPrepare_SchemePlanItem] PRIMARY KEY CLUSTERED
|
||
(
|
||
[SchemePlanItemId] 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
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'寮숩' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_SchemePlanItem', @level2type=N'COLUMN',@level2name=N'SchemePlanItemId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'棍숩' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_SchemePlanItem', @level2type=N'COLUMN',@level2name=N'SchemePlanId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'렘갭츰냔' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_SchemePlanItem', @level2type=N'COLUMN',@level2name=N'SolutionName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'탤埼' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_SchemePlanItem', @level2type=N'COLUMN',@level2name=N'SortIndex'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'역났렘갭긍齡셕뺍츠玖깊' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DriverPrepare_SchemePlanItem'
|
||
GO
|
||
|
||
|
||
|
||
|
||
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'북냥갚쿱羹淃커','<EFBFBD>구섟밗돛溝固녑求、뉘<EFBFBD>렘갭',1)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'북냥갚쿱羹淃커','궁뵨루샙桿났렘갭',2)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'북냥갚쿱羹淃커','랗南뺏抉箕鍵샙拷틱桿났렘갭',3)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'북냥갚쿱羹淃커','랗南뺏抉箕鍵샙桿났렘갭',4)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'북냥갚쿱羹淃커','쿱羹묏論溝固폭쵱렘갭',5)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'북냥갚쿱羹淃커','溝固零뻣렘갭',6)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'북냥갚쿱羹淃커','錮향닭뺏셉陋輕렘갭',7)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'북냥갚쿱羹淃커','櫓箕溝固갚輕념렘갭',8)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'북냥갚쿱羹淃커','멕箕溝固<EFBFBD>侊、<EFBFBD>箕렘갭',9)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'북냥갚쿱羹淃커','溝固廬왕桿駱렘갭',10)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'북냥갚쿱羹淃커','쿱羹젬땡桿났렘갭',11)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'북냥갚쿱羹淃커','芚젓샙桿났렘갭',12)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'북냥갚쿱羹淃커','쿱羹陋零尻죕桿났렘갭',13)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'북냥갚쿱羹淃커','댕옮젓陋零尻죕桿났렘갭',14)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'죽擧淃커','땡<EFBFBD>구데샙桿났렘갭',1)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'죽擧淃커','밗돛녑求뉘<EFBFBD>렘갭',2)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'죽擧淃커','무痰묏넋뵨즘擧밗돛녑求뉘<EFBFBD>렘갭',3)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'죽擧淃커','力폼밗돛뉘<EFBFBD>렘갭',4)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'죽擧淃커','젬땡桿났렘갭',5)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'죽擧淃커','尻죕桿났렘갭',6)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'죽擧淃커','昑콘옘뵙렘갭',7)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','110KV긴든杰갛陋섟肝든렘갭',1)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','든샙데桿렘갭',2)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','베彊긴든杰，쯤庫토든杆갛陋、딧桿뵨肝든렘갭',3)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','老깊딧桿嘉묏렘갭',4)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','DCS溝固딧桿렘갭',5)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','SIS溝固딧桿렘갭',6)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','GDS溝固딧桿렘갭',7)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','윈稜뚤쉿溝固딧桿렘갭',8)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','든柬솰왠섟鷺썹괩쒸溝固딧桿렘갭',9)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','轟窟繫斤溝固딧桿렘갭',10)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','寧겹샙궁데샙桿났렘갭',11)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','BOG箕鍵샙答琦뻔렘갭',12)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','BOG箕鍵샙왕潼桿났렘갭',13)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','무痰묏넋溝固녑求뉘<EFBFBD>렘갭',14)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','묏論溝固뉘<EFBFBD>렘갭',15)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','무痰묏넋溝固폭쵱렘갭',16)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','묏論溝固폭쵱렘갭',17)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','溝固뎁폭맴鈍零뻣렘갭',18)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','뇨받뎁폭맴鈍零뻣렘갭',19)
|
||
insert into DriverPrepare_SchemePlanItem values
|
||
(NEWID(),'LNG淃커','昑콘옘뵙넋埼',20)
|
||
GO |