hytos / ID2.Manager / DataBaseCreate / ViewMarkupData.sql @ d8bd4799
이력 | 보기 | 이력해설 | 다운로드 (6.15 KB)
| 1 | e890d999 | taeseongkim | USE [ID2Manager] |
|---|---|---|---|
| 2 | GO |
||
| 3 | |||
| 4 | EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ViewMarkupData' |
||
| 5 | GO |
||
| 6 | |||
| 7 | EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ViewMarkupData' |
||
| 8 | GO |
||
| 9 | |||
| 10 | /****** Object: View [dbo].[ViewMarkupData] Script Date: 2023-08-16 ???? 1:11:44 ******/
|
||
| 11 | DROP VIEW [dbo].[ViewMarkupData] |
||
| 12 | GO |
||
| 13 | |||
| 14 | /****** Object: View [dbo].[ViewMarkupData] Script Date: 2023-08-16 ???? 1:11:44 ******/
|
||
| 15 | SET ANSI_NULLS ON |
||
| 16 | GO |
||
| 17 | |||
| 18 | SET QUOTED_IDENTIFIER ON |
||
| 19 | GO |
||
| 20 | |||
| 21 | CREATE VIEW [dbo].[ViewMarkupData] |
||
| 22 | AS
|
||
| 23 | SELECT CONVERTER.PROJECT_NO, CONVERTER.DOCUMENT_ID, CONVERTER.STATUS, MarkupData.PAGENUMBER, MarkupData.Text, MarkupData.CREATE_DATE, MarkupData.NAME
|
||
| 24 | FROM (SELECT PROJECT_NO, DOCUMENT_ID, MAX(STATUS) AS STATUS |
||
| 25 | FROM markus_SEC.dbo.CONVERTER_DOC
|
||
| 26 | WHERE (STATUS >= 0) AND (STATUS <= 4) |
||
| 27 | GROUP BY PROJECT_NO, DOCUMENT_ID |
||
| 28 | HAVING (COUNT(*) > 1)) AS CONVERTER LEFT OUTER JOIN |
||
| 29 | (SELECT markus_SEC.dbo.DOCINFO.PROJECT_NO, markus_SEC.dbo.DOCINFO.DOCUMENT_ID, markus_SEC.dbo.MARKUP_DATA.PAGENUMBER,
|
||
| 30 | CASE WHEN MAX(dbo.MarkupDataParse(markus_SEC.dbo.MARKUP_DATA.DATA)) IS NOT NULL THEN MAX(dbo.MarkupDataParse(markus_SEC.dbo.MARKUP_DATA.DATA)) |
||
| 31 | ELSE MAX('Markup') END AS Text, MAX(markus_SEC.dbo.MARKUP_INFO_VERSION.CREATE_DATE) AS CREATE_DATE, MAX(markus_SEC.dbo.MEMBER.NAME) AS NAME |
||
| 32 | FROM markus_SEC.dbo.MARKUP_DATA INNER JOIN |
||
| 33 | markus_SEC.dbo.ControlType ON markus_SEC.dbo.MARKUP_DATA.DATA_TYPE = markus_SEC.dbo.ControlType.TypeValue INNER JOIN |
||
| 34 | markus_SEC.dbo.DOCINFO INNER JOIN |
||
| 35 | markus_SEC.dbo.MARKUP_INFO ON markus_SEC.dbo.DOCINFO.ID = markus_SEC.dbo.MARKUP_INFO.DOCINFO_ID INNER JOIN |
||
| 36 | markus_SEC.dbo.MARKUP_INFO_VERSION ON markus_SEC.dbo.MARKUP_INFO.ID = markus_SEC.dbo.MARKUP_INFO_VERSION.MARKUPINFO_ID ON |
||
| 37 | markus_SEC.dbo.MARKUP_DATA.MARKUPINFO_VERSION_ID = markus_SEC.dbo.MARKUP_INFO_VERSION.ID INNER JOIN |
||
| 38 | markus_SEC.dbo.MEMBER ON markus_SEC.dbo.MARKUP_INFO.USER_ID = markus_SEC.dbo.MEMBER.ID
|
||
| 39 | GROUP BY markus_SEC.dbo.DOCINFO.PROJECT_NO, markus_SEC.dbo.DOCINFO.DOCUMENT_ID, markus_SEC.dbo.MARKUP_DATA.PAGENUMBER, |
||
| 40 | dbo.MarkupDataParse(markus_SEC.dbo.MARKUP_DATA.DATA), markus_SEC.dbo.MEMBER.NAME) AS MarkupData ON |
||
| 41 | CONVERTER.PROJECT_NO = MarkupData.PROJECT_NO AND CONVERTER.DOCUMENT_ID = MarkupData.DOCUMENT_ID
|
||
| 42 | GO |
||
| 43 | |||
| 44 | EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00] |
||
| 45 | Begin DesignProperties =
|
||
| 46 | Begin PaneConfigurations =
|
||
| 47 | Begin PaneConfiguration = 0
|
||
| 48 | NumPanes = 4
|
||
| 49 | Configuration = "(H (1[21] 4[16] 2[31] 3) )"
|
||
| 50 | End
|
||
| 51 | Begin PaneConfiguration = 1
|
||
| 52 | NumPanes = 3
|
||
| 53 | Configuration = "(H (1 [50] 4 [25] 3))"
|
||
| 54 | End
|
||
| 55 | Begin PaneConfiguration = 2
|
||
| 56 | NumPanes = 3
|
||
| 57 | Configuration = "(H (1 [50] 2 [25] 3))"
|
||
| 58 | End
|
||
| 59 | Begin PaneConfiguration = 3
|
||
| 60 | NumPanes = 3
|
||
| 61 | Configuration = "(H (4 [30] 2 [40] 3))"
|
||
| 62 | End
|
||
| 63 | Begin PaneConfiguration = 4
|
||
| 64 | NumPanes = 2
|
||
| 65 | Configuration = "(H (1 [56] 3))"
|
||
| 66 | End
|
||
| 67 | Begin PaneConfiguration = 5
|
||
| 68 | NumPanes = 2
|
||
| 69 | Configuration = "(H (2 [66] 3))"
|
||
| 70 | End
|
||
| 71 | Begin PaneConfiguration = 6
|
||
| 72 | NumPanes = 2
|
||
| 73 | Configuration = "(H (4 [50] 3))"
|
||
| 74 | End
|
||
| 75 | Begin PaneConfiguration = 7
|
||
| 76 | NumPanes = 1
|
||
| 77 | Configuration = "(V (3))"
|
||
| 78 | End
|
||
| 79 | Begin PaneConfiguration = 8
|
||
| 80 | NumPanes = 3
|
||
| 81 | Configuration = "(H (1[56] 4[18] 2) )"
|
||
| 82 | End
|
||
| 83 | Begin PaneConfiguration = 9
|
||
| 84 | NumPanes = 2
|
||
| 85 | Configuration = "(H (1 [75] 4))"
|
||
| 86 | End
|
||
| 87 | Begin PaneConfiguration = 10
|
||
| 88 | NumPanes = 2
|
||
| 89 | Configuration = "(H (1[66] 2) )"
|
||
| 90 | End
|
||
| 91 | Begin PaneConfiguration = 11
|
||
| 92 | NumPanes = 2
|
||
| 93 | Configuration = "(H (4 [60] 2))"
|
||
| 94 | End
|
||
| 95 | Begin PaneConfiguration = 12
|
||
| 96 | NumPanes = 1
|
||
| 97 | Configuration = "(H (1) )"
|
||
| 98 | End
|
||
| 99 | Begin PaneConfiguration = 13
|
||
| 100 | NumPanes = 1
|
||
| 101 | Configuration = "(V (4))"
|
||
| 102 | End
|
||
| 103 | Begin PaneConfiguration = 14
|
||
| 104 | NumPanes = 1
|
||
| 105 | Configuration = "(V (2))"
|
||
| 106 | End
|
||
| 107 | ActivePaneConfig = 0
|
||
| 108 | End
|
||
| 109 | Begin DiagramPane =
|
||
| 110 | Begin Origin =
|
||
| 111 | Top = 0
|
||
| 112 | Left = 0
|
||
| 113 | End
|
||
| 114 | Begin Tables =
|
||
| 115 | Begin Table = "CONVERTER"
|
||
| 116 | Begin Extent =
|
||
| 117 | Top = 6
|
||
| 118 | Left = 311
|
||
| 119 | Bottom = 119
|
||
| 120 | Right = 483
|
||
| 121 | End
|
||
| 122 | DisplayFlags = 280
|
||
| 123 | TopColumn = 0
|
||
| 124 | End
|
||
| 125 | Begin Table = "MarkupData"
|
||
| 126 | Begin Extent =
|
||
| 127 | Top = 6
|
||
| 128 | Left = 38
|
||
| 129 | Bottom = 136
|
||
| 130 | Right = 210
|
||
| 131 | End
|
||
| 132 | DisplayFlags = 280
|
||
| 133 | TopColumn = 0
|
||
| 134 | End
|
||
| 135 | End
|
||
| 136 | End
|
||
| 137 | Begin SQLPane =
|
||
| 138 | End
|
||
| 139 | Begin DataPane =
|
||
| 140 | Begin ParameterDefaults = ""
|
||
| 141 | End
|
||
| 142 | Begin ColumnWidths = 10
|
||
| 143 | Width = 284
|
||
| 144 | Width = 1500
|
||
| 145 | Width = 1500
|
||
| 146 | Width = 3690
|
||
| 147 | Width = 1500
|
||
| 148 | Width = 2490
|
||
| 149 | Width = 2250
|
||
| 150 | Width = 1500
|
||
| 151 | Width = 1500
|
||
| 152 | Width = 1500
|
||
| 153 | End
|
||
| 154 | End
|
||
| 155 | Begin CriteriaPane =
|
||
| 156 | Begin ColumnWidths = 11
|
||
| 157 | Column = 18090
|
||
| 158 | Alias = 900
|
||
| 159 | Table = 1170
|
||
| 160 | Output = 720
|
||
| 161 | Append = 1400
|
||
| 162 | NewValue = 1170
|
||
| 163 | SortType = 1350
|
||
| 164 | SortOrder = 1410
|
||
| 165 | GroupBy = 1350
|
||
| 166 | Filter = 1350
|
||
| 167 | Or = 1350
|
||
| 168 | Or = 1350
|
||
| 169 | Or = 1350
|
||
| 170 | End
|
||
| 171 | End
|
||
| 172 | End
|
||
| 173 | ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ViewMarkupData' |
||
| 174 | GO |
||
| 175 | |||
| 176 | EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ViewMarkupData' |
||
| 177 | GO |
||
| 178 |
