ááááá áá¤á:
"á ááŞá áŠááĽáŁáŠá áŽááá¨á áááĽááĄ, áá ááááá á§ááááá¤áá á ááŁá áĄááááᥠá°ááááĄ."
á áá˘áááŚááŞ, áááá áŽááᥠáŹáá, á áááá ᪠áŠáááĄ, - áááĄáŁá ááá ááĄááááĄ, áá¤ááĄá¨á áĄááá áááááĄááĄ, áááŹá§áááááá áŁá¤á ááĄááá á¨áá¨á¤áááááá, á áá áá áᥠáŁáĄááĽááááá¨á ááá˘áá áááá áá ááá˘áááá áá¤ááĽá áááá.
â áá áŁááá ááááááŹáá á FIAS, áŤááá á¤ááĄá ááááááá á! - áááááŞáŽáááᥠáŽááááĄáŁá¤ááááá. â áááá˘áá, á áá áŠáááᥠáááááᥠáá áááŁáááᥠáá áááĄáŹááá áááĄá áŠáá˘ááá áááᥠáá ááŞááĄá. áááá ááĽááá, áá áááŁáĽá˘áᥠáĄáá ááá áᥠáŠáá˘ááá áááᥠáá áŠáá˘ááá áááᥠáááá áá á áĄááá áááá áá áᥠáááá, ááá᪠áŠáá˘ááá áááᥠáá ááŞááĄá áááŹáá á, áááá á ááŚáᥠááá˘ááá, á áááá ᪠áĄááá áŹááᥠáŹáá.
ááá áá ááááĄá, áἠá§ááááá¤áá á áááá áŽááᥠáŹáá áŁááá ááááááááááĄ, ááĄá á áá, áááááá áŤáá, á¨ááĽááááá áĄáááŁááá á áááá áá ááá áŹááŁáááá, á áá FIASA ááá ááááŁááá áááĄááá. á§ááááá¤áá áĄ, á áááá ᪠ááááááá, áá ááááááááááá!
ááĽáá áŁááá áááĽáá, á áá áá ááá áááá ááááĄááá á¨áá ááŁáá áŁá áááá áááá áááĽááĄ, á ááááá... áá áŁá¤á á DBA ááá . ááŁááŞá, áááá á ááŽá áá, áŹááááĄáŹáá áááááááááŁáá ááá¤áá áááŞááᥠáááá áááĄáááááᥠáŠáá˘ááá ááá áĄáŹáá áá DBA-ᥠááááŞáááá, nest pa?
"áááá... áŠááá áááᥠáááááááááá ááŽáá", - ááŁááŽáá á áá áŁá¤á ááĄááᥠáá áĄááĄáŹá áá¤áá á¨ááááá áá FIASA-ᥠááááĄááá˘áá áá áŽááááá áááŠááŠá.
"á¨ááĄááŽáá! ááááŽ, áá áᥠdbf! - ááááá¤ááĽá á, áĄááŽáá áŁááá áááŽááŽáá áŽáááááĄ, áááááá ááŁááá áááááá ᥠáĄá˘ááááá á˘áŁáá "áá á¤ááĽá˘á" ááá-áá áĽáááᥠáá áá áĄááááá áá, ááá ááĽáá, áááá áŽááᥠááá áááŞááááá áá áŻáᥠáá áĄááááá áá áĄáááŁáá ááááĄ, ááááá¨á, áŚáá, á á ááĽáá áŁááá, 7zip [áááá áá á ááááᥠááááááá ááĄáá áááá᪠á¨ááŁáŤááááááá powershell-áᥠááá¤áá áááááᥠ-áá áĽáááᥠááááá§áááááá]. áááá. ááĽááá áá á¨ááááŤáááá áááĄá áŠáááá˘ááá ááá áá áááŽáĄáá áĄáŁá¤áá Powershell-áá. ááĽááá áááááŹááá áĄáá ááá áá á§áááááááá á áĄááĄáŁáááááááᥠáááá ááááá. á˛ááááŞ.
áá áŁááá á áááááááá áŹáááá ááŹáá áááĄá˘á áŁáááá˘ááᥠdbf á¤ááááááᥠáááĄááŁá áá ááá áááááŁá á áŠáá˘ááá ááááĄááááĄ, áááá˘áá áá ááááá á áá áááááá áá áŁááá áá§ááĄ.
áá ááááŽáĄááá dbfs, ááááŁá¨áá áŠáááá˘ááá áááᥠáá ááá ááá áá áĄáááá áááááŞááááá áá˘ááá áááááá, ááááááŽáá˘á áĄáá ááá˘á, á ááááá᪠áŞáááááŁá âááááĽááᥠááááá˘áŁá â á¤áá á¤áá˘ááᥠáá áá¨á áááááĄáááá, áááá ááŁááááááááᥠáááŽááááá.
áááááááŹáá á áááááŞááááá áá ááááá áááá áááááŻáááá˘áᥠáá¤ááĄá¨á áŹááĄááááĄ, ááᣠááá¤ááᥠáááĄáááááĄ, áááá áá áá¨ááááá áááááááá ááááá á˘áᥠá¨áááááááᥠáááĄáááááááá ááááá!
-ááŁá¤. WTF!!!???
áááá áááááááá áŠáááŁáááá áá ááá˘ááá ááŁáá áá§á, áááá áá ááá˘áá ááá á¨áááŞáááááá á¨ááŞááááááĄ.
áá áá á§ááááá¤áá áá ááĄá ááááááŹáŁáŽá á áá ááááááĽáááá, á áá ááááááŁááá áááááá ááá áááá áá ááááŚá áááááááŁá ááá áá áŠááá áŁá¨áŁááá áááĄáŁáŽááĄáááááááá. ááááááááá áá ááááááá ááá¤áŁááááŁáá ááá¤-áááá áá ááŁáááá.
áá á ááŚá áááááááááŁá á, áĄáááá áááááŞáŽááááá áá áááááŹáŁá á áá áŁá¤á ááĄááá ááĄáá á°áá ááááá˘áá áááááŠááááá, áĄááá áááŁá á ááááŽááá "á áᥠáááááááŽáááá?"
áá, á ááááá áá áá¤áá á áá§á áááĄáŁáŽáᥠáááĄááŞáááá áá áá áááá᪠áá ááááááá dbf-áá áááááááá, ááááááŹá§ááá˘á áááááááŹáá á FIAS xml-ááá, ááá áŁááá˘ááĄ, á áá, á áááá ᪠ááááááá, áᥠáá áᥠááááŁá á, ááááŁá á, ááŽáááááá ááŁáá áá âdbf áá áᥠáááááááááá á¤áá ááá˘á. .â
áááá ááááááááá áá áááááááŁá áááŁá á¨ááĄáááá áááááááᥠáá áĄááĽááᥠá¨áááŁááááá.
ááááá áá¤á 2:
ááááŽ, áᥠááĄááá á¨ááĄááŤááááááá. đ
ááĄá á áá, áááááŹá§áá áŠáá˘ááá ááá ááááá§áááááá
ááááĄáááááĄ, á áá áááááá§áááá ááá, áááá ááááá
ááŁááŞá, FIAS-áᥠá¨ááááŽááááá¨á, âáĄá˘á áŁáĽá˘áŁá áâ ááááĄáááŁáá áááá ááááŽáááááá áá áá ááĄ. áááá˘áá á áá áἠá¤áááááá áá áá áᥠááŁáĄá˘áá xml... ááĄááá, á á ááĽáá áŁááá, xml áá ááá, áááá áá, áá áĄáááááá, áᥠáá áᥠáá á˘á§ááá áŞáŽá ááááá áááááŞáááááá, ááááááŁáá á¤áááá á¨áááŞááᥠáá á áŞáŽá áááĄ.
ááááááá ááá sql.ru á
áἠáá áᥠáááĄá ááááá á¨ááŞááááá ááá áĄáá:
spXMLBulkLoad
USE [FIAS2]
GO
/****** Object: StoredProcedure [dbo].[spXMLBulkLoad] Script Date: 13.05.2019 18:05:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ĐоОйŃ
ОдиПО ŃаСŃĐľŃиŃŃ Ole Automation Procedures:
-- EXEC sp_configure 'Ole Automation Procedures', 1; RECONFIGURE WITH OVERRIDE;
-- ĐŃиПоŃ:
-- EXEC dbo.spXMLBulkLoad 'Z:PathData.xml','Z:PathSchema.xsd', 'FIAS', 'Z:Patherror.xml'
CREATE PROCEDURE [dbo].[spXMLBulkLoad] (
@File SysName
,@Schema SysName
,@DataBase SysName = '<DefaultDataBase>'
,@ErrorLog SysName
) AS
BEGIN
DECLARE @ErrCode Int
,@OLEXMLBulk Int
,@ErrMethod SysName
,@ErrDescript NVarChar(4000)
EXEC @ErrCode = sys.sp_OACreate 'SQLXMLBulkLoad.SQLXMLBulkload', @OLEXMLBulk OUT
IF (@ErrCode = 0)
BEGIN
SET @DataBase = 'Provider=SQLOLEDB;Data Source=.;DataBase=' + @DataBase + ';Integrated Security=SSPI'
EXEC @ErrCode = sys.sp_OASetProperty @OLEXMLBulk ,'ConnectionString', @DataBase
IF (@ErrCode <> 0)
BEGIN SET @ErrMethod = 'ConnectionString'
GOTO Error
END
EXEC @ErrCode = sys.sp_OASetProperty @OLEXMLBulk ,'ErrorLogFile', @ErrorLog
IF (@ErrCode <> 0)
BEGIN SET @ErrMethod = 'ErrorLogFile'
GOTO Error
END
EXEC @ErrCode = sys.sp_OASetProperty @OLEXMLBulk, 'CheckConstraints', 1
IF (@ErrCode <> 0)
BEGIN SET @ErrMethod = 'CheckConstraints'
GOTO Error
END
--EXEC @ErrCode = sys.sp_OASetProperty @OLEXMLBulk, 'ForceTableLock', 1
-- IF (@ErrCode <> 0)
-- BEGIN SET @ErrMethod = 'ForceTableLock'
-- GOTO Error
-- END
EXEC @ErrCode = sys.sp_OAMethod @OLEXMLBulk, 'Execute', NULL, @Schema, @File
IF (@ErrCode <> 0)
BEGIN
SET @ErrMethod = 'Execute'
DECLARE @Exist Int
,@Error XML
,@SQL NvarChar(max)
EXEC master.dbo.xp_FileExist @ErrorLog, @Exist OUT
IF (@Exist = 1)
BEGIN
-- ĐС @ErrorLog ŃаКНа
Set @SQL = N'SELECT @Error = E.Error + CASE WHEN Right(E.Error,1) <> ''>'' THEN ''lt>'' ELSE '''' END '
+ N'FROM OPENROWSET(BULK '''+ @ErrorLog +''', SINGLE_NCLOB) E(Error)'
exec sp_executesql @SQL, N'@Error xml OUTPUT', @Error=@Error OUTPUT
SELECT @ErrDescript = IsNull(@ErrDescript,'') + E.Error.value('Description[1]','SysName') + ' '
FROM @Error.nodes('/Result/Error')E(Error)
SELECT @ErrDescript = IsNull(@ErrDescript,'') + E.Error.value('Description[1]','SysName') + ' '
FROM @Error.nodes('/Error/Record')E(Error)
END
ELSE
GOTO Error
END
GOTO Destroy
Error:
EXEC @ErrCode = sys.sp_OAGetErrorInfo @OLEXMLBulk, @ErrorLog OUT, @ErrDescript OUT
Destroy:
EXEC @ErrCode = sys.sp_OADestroy @OLEXMLBulk
END
ELSE
SELECT
@ErrMethod = 'SQLXMLBulkLoad.SQLXMLBulkload'
,@ErrorLog = 'sp_OACreate'
,@ErrDescript = 'ĐŃийка ŃĐžĐˇĐ´Đ°Đ˝Đ¸Ń OLE ОйŃокŃĐ°'
-- ĐŃвОд ĐžŃийОк
IF (@ErrMethod IS NOT NULL)
BEGIN
RAISERROR('ĐŃийка ĐżŃи вŃпОНнонии ПоŃОда "%s" в "%s": %s',18,1, @ErrMethod, @ErrorLog, @ErrDescript)
RETURN @@Error
END
END
GO
ááááĄááá, áá ááááááááááᥠááááá§áááááá xml-áᥠáááĄááá ááá áŠáá˘ááá áááᥠááááĄááŽáá áŞáááááááá, áĄáááá áá áááá˘áá áááŁáá xsd áĄáĽááááá, á áááááááŞ, á¤ááĽá˘ááá áááá, áááŁáááááᥠááááá, áᣠá áááá áá áĄáá áá áᥠáŠáá˘ááá ááŁáá.
áá ááŚáááááŠááá áŽáĄááááááá, á áá ááĄááá áĄáĽááááá áá áĄáááááĄ, "áááá áá ááŽáááá áŤáááá", ááááŁááááá áĄááá˘áá, áááá áá ááááá áĄáĽááááá áá áĄáá áááááá. áá áááá áááá.
FIAS-áᥠááááĄááá˘áá áá áĄáááŁáá áĄáĽáááᥠá¨ááŞááá á ááŁáá áá áá áᥠáááááŞáááááᥠáŽáááá ááááá á˘ááĄááááĄ.
áááá áá... áĄáŁá 271 ááááá! áᥠáá áᥠáááá á áŻáááá áá áĄááĄáŁáááá!
áááá˘áá ááááááŹá§ááá˘á áá áĄáĽáááááᥠááá˘áááá˘áŁá áá ááááá¤ááŞáá ááá, áááááá ááŁááá áááááŞáááá ááááá¨á áĄáááááá áŞáŽá áááááᥠá¨ááĽááá.
SQLXMLBULKLOAD-ᥠá¨ááŁáŤááá ááá˘áááá˘áŁá áá á¨ááĽáááᥠáŞáŽá ááááá áŠáá˘ááá ááŁáá áááááŞááááááĄáááᥠáááá˘áá áááŁáá áĄáĽáááááá, áááá áá, áááá á ááŽá áá, áᣠáá ááááá áá áá áĄáĽáááᥠá¨ááĽááááĄ, ááá¨áá á áá˘áá áá ááááááááá áá áŞáŽá ááááᥠáá áááááá, ááĄá, á áááá ᪠áá áááá áááá?
áá áááááááŹáá á xsd ááááá ááááá FIAS-áᥠááááĄááá˘áááá áá ááááááááááá ááĄááá áŹááááá ááááŁáááŁá áá.
áĄáááááááá áá, ááĄááá á§áááá áá áá á˘ááááĄáá, ááĄá á áá ááĽááá á¨ááááŤáááá á¨ááĽáááá áĄáááááá áááááŞáááá áááá áá ááááá á¨ááŞááááá áĄáĽááááá áŠáá˘ááá ááááĄááááĄ, ááŽáááá á áááááááá áá ᪠áᣠááĄá á ááŁáá ááááŽááááᥠááááá§áááááá.
1. á¨ááĽááááá áŞáá áááá FIAS2 áááááŞáááá áááá.
á áá˘áá "2"? ááĄá, á ááááá "1" áá§á áááááŞáááá áááá dbf-ok-ááá. ááááá ááááá ááááááááááá áááĄááŁáá áá.
FIAS2 áááááŞáááá ááááᥠá¨ááĽáááᥠáĄáá ááá˘á
CREATE DATABASE [FIAS2]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'FIAS', FILENAME = N'E:DataFIAS1.mdf' , SIZE = 10485760KB , FILEGROWTH = 1048576KB )
LOG ON
( NAME = N'FIAS_log', FILENAME = N'E:DataFIAS1_log.ldf' , SIZE = 1048576KB , FILEGROWTH = 131072KB )
GO
ALTER DATABASE [FIAS2] SET COMPATIBILITY_LEVEL = 120
GO
ALTER DATABASE [FIAS2] SET ANSI_NULL_DEFAULT ON
GO
ALTER DATABASE [FIAS2] SET ANSI_NULLS ON
GO
ALTER DATABASE [FIAS2] SET ANSI_PADDING ON
GO
ALTER DATABASE [FIAS2] SET ANSI_WARNINGS ON
GO
ALTER DATABASE [FIAS2] SET ARITHABORT OFF
GO
ALTER DATABASE [FIAS2] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [FIAS2] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [FIAS2] SET AUTO_CREATE_STATISTICS ON(INCREMENTAL = OFF)
GO
ALTER DATABASE [FIAS2] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [FIAS2] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [FIAS2] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [FIAS2] SET CONCAT_NULL_YIELDS_NULL ON
GO
ALTER DATABASE [FIAS2] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [FIAS2] SET QUOTED_IDENTIFIER ON
GO
ALTER DATABASE [FIAS2] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [FIAS2] SET DISABLE_BROKER
GO
ALTER DATABASE [FIAS2] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [FIAS2] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [FIAS2] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [FIAS2] SET READ_COMMITTED_SNAPSHOT ON
GO
ALTER DATABASE [FIAS2] SET READ_WRITE
GO
ALTER DATABASE [FIAS2] SET RECOVERY SIMPLE
GO
ALTER DATABASE [FIAS2] SET MULTI_USER
GO
ALTER DATABASE [FIAS2] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [FIAS2] SET TARGET_RECOVERY_TIME = 0 SECONDS
GO
ALTER DATABASE [FIAS2] SET DELAYED_DURABILITY = DISABLED
GO
USE [FIAS2]
GO
IF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N'PRIMARY') ALTER DATABASE [FIAS2] MODIFY FILEGROUP [PRIMARY] DEFAULT
GO
2. ááááá á¨áááĽáááá á áááááááá á¤áá á¤áá˘á áá áááááŞáááá ááááá¨á.
ááá áááá á¤áá á¤áá˘á á¨áááŞááᥠxsd áĄáĽáááááĄ, áŽááá áááá á á ááááŁá áá ááĽáááá áá xsd áĄáĽáááááááá áááŚáááŁáá áááááŞáááá áĄáĽááá.
xsd áĄáĽááááá, á¤ááĽá˘ááá áááá, áŠáááŁáááá ááá xml á¤ááááá, ááĄá á áá ááĽááá á¨ááááŤáááá áááŁá¨ááá áááááá, á áááá ᪠áŠáááŁáááá ááá xml á¤ááááááá.
USE [FIAS2]
go
if OBJECT_ID('dbo.[_FIAS]') is not null
drop table dbo.[_FIAS]
go
if OBJECT_ID('dbo._FIAS_SCHEMAS') is not null
drop table dbo.[_FIAS_SCHEMAS]
go
Create table dbo.[_FIAS_SCHEMAS] (x xml, [table ââ not found /]
sysname)
go
-- ĐĐľŃвŃĐš СапŃĐžŃ: ĐĐ°ĐłŃŃСиП ŃŃ
ĐľĐźŃ Đ˛ ŃайНиŃĐşŃ Đ˝Đ° ŃĐľŃвоŃĐľ, Đ´ĐťŃ Đ´Đ°ĐťŃноКŃиŃ
ПанипŃĐťŃŃиК.
insert into dbo.[_FIAS_SCHEMAS] (x, [table ââ not found /]
)
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ACTSTAT' [table ââ not found /]
FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ACTSTAT_2_250_08_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ADDROBJ' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ADDROBJ_2_250_01_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_CENTERST' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_CENTERST_2_250_10_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_CURENTST' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_CURENTST_2_250_07_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_ADDROBJ' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_ADDROBJ_2_250_15_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_HOUSEINT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_HOUSEINT_2_250_17_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_HOUSE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_HOUSE_2_250_16_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_LANDMARK' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_LANDMARK_2_250_18_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_NORMDOC' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_NORMDOC_2_250_19_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ESTSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ESTSTAT_2_250_13_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_FLATTYPE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_FLATTYPE_2_250_23_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_HOUSEINT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_HOUSEINT_2_250_03_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_HOUSE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_HOUSE_2_250_02_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_HSTSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_HSTSTAT_2_250_12_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_INTVSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_INTVSTAT_2_250_11_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_LANDMARK' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_LANDMARK_2_250_04_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_NDOCTYPE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_NDOCTYPE_2_250_20_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_NORMDOC' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_NORMDOC_2_250_05_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_OPERSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_OPERSTAT_2_250_09_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ROOMTYPE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ROOMTYPE_2_250_24_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ROOM' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ROOM_2_250_21_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_SOCRBASE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_SOCRBASE_2_250_06_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_STEAD' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_STEAD_2_250_22_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_STRSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_STRSTAT_2_250_14_04_01_01.xsd', SINGLE_BLOB) x
-- ĐŃĐžŃОК СапŃĐžŃ: Đ Đ°ŃпОŃŃĐžŃиП ŃŃ
оПŃ, и ŃОСдадиП ŃайОŃŃŃ ŃайНиŃŃ Ń ĐźĐľŃаданнŃПи
;WITH XMLNAMESPACES ('http://www.w3.org/2001/XMLSchema' as xs)
Select a.[table ââ not found /]
,tbl.[root_name]
,tbl.[root_description]
,tbl.[name]
,ROW_NUMBER() over (partition by a.[table ââ not found /]
order by 1/0) N
,tbl.[column]
,tbl.[required]
,tbl.[description]
,tbl.[type]
,tbl.[len]
,Case tbl.[type]
when N'byte' then N'tinyint'
when N'date' then N'date'
when N'int' then N'int'
when N'string' then
Case when tbl.[len] = 36 and (tbl.[column] like N'%ID' or tbl.[column] = N'NORMDOC') then N'uniqueidentifier'
when tbl.[len] is Null then N'nvarchar(max)'
Else N'nvarchar(' + cast(tbl.[len] as nvarchar(4000)) + N')' END
when N'integer' then
Case when tbl.[len] > 9 then N'bigint'
when tbl.[len] <= 4 then N'smallint'
Else N'int'
end
else N'nvarchar(max)'
End [sqltype]
,t.n.query('.') [node]
into dbo.[_FIAS]
from dbo.[_FIAS_SCHEMAS] a
Cross apply a.x.nodes('//xs:attribute') t(n)
Cross apply
(values -- нокОŃĐžŃŃĐľ ĐżĐžĐťŃ Đ¸ŃпОНŃСŃŃŃŃŃ Đ˝ĐľŃкОНŃкО ŃаС, пОŃŃĐžĐźŃ ŃдоНаоП ŃĐ°Đş :)
(
x.value('(xs:schema[1]/xs:element[1]/@name)', 'nvarchar(255)')
,x.value('(xs:schema[1]/xs:element[1]/xs:annotation/xs:documentation[1]/text())[1]', 'nvarchar(4000)')
,x.value('(xs:schema[1]/xs:element[1]/xs:complexType[1]/xs:sequence[1]/xs:element[1]/@name)', 'nvarchar(255)')
,t.n.value('(./@name)[1]', 'nvarchar(255)')
,t.n.value('(./@use)[1]', 'nvarchar(255)')
,Stuff(Coalesce(t.n.value('(./xs:simpleType/xs:restriction/@base)[1]', 'nvarchar(255)'), t.n.value('(./@type)[1]', 'nvarchar(255)')), 1, 3, '')
,Coalesce(t.n.value('(./xs:simpleType/xs:restriction/xs:length/@value)[1]', 'int')
,t.n.value('(./xs:simpleType/xs:restriction/xs:maxLength/@value)[1]', 'int')
,t.n.value('(./xs:simpleType/xs:restriction/xs:totalDigits/@value)[1]', 'int'))
,Replace(
Replace(
Replace(
Replace(
Replace(
Replace(
Replace(
Replace(
Replace(t.n.value('(./xs:annotation/xs:documentation)[1]', 'nvarchar(4000)'), ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
)
) tbl([root_name], [root_description], [name], [column], [required], [type], [len], [description])
-- ĐĐžŃПОŃŃиП на ŃоСŃĐťŃŃĐ°Ń
Select * from dbo.[_FIAS]
ááááá˘ááááá ááá˘ááááá ááááŽááááá:
ááá áááá - áá˘ááá áááᥠxsd áĄáĽááááᥠáĄáá ááá áᥠáŞáŽá ááá¨á, áááááá ááŁááá ááŹáááᥠááááááŁá áĄáĽáááᥠáááá˘ááŞááᥠáááá¨á [áŞáŽá ááá "" áá áá áᥠááááááá /].
â áŞáŽá áááᥠáĄááŽááá, á ááááá¨á᪠ááĄáŁá ᥠáááááŞáááááᥠáŠáá˘ááá ááá á¨ááĄááááááĄá áŞáŽá áááááá.
á á ááĽáá áŁááá, á¨ááĄááŤáááááá ááĽáááááá, á áá á§áááá áŻáá áá áĄáĽááááá á¨áááŞáááááĄ, áááá áááááá˘ááá ááá, áĄááĽááŚááááá¨á áŠááĄáá áá áĄáááááá áŞáŽá áááááᥠáĄá˘á áŁáĽá˘áŁá áᥠáŽááááŽáá á¨ááĽááá áááááá áŽááááŽáá áá ááá˘áááá˘áŁá áá, áá áĄáĽáááááᥠáŽááááŽáá á¨ááŞááá. áá ááá˘áááá˘áŁá áá, áááá áá á áá .To. áĄá˘á áŁáĽá˘áŁá á áŤááááá áá¨áááááá ááŞááááá, áááá áá áᥠáᥠá¨áááŞáááá áŁááá 16 áŹááᥠ- ááĄááá ááá˘áááá˘áŁá á áááá áá˘áᥠááááááááá áŁááááŁá ááĄáá ááá áááŞáá. áŻáááá 30 áŹááá áááá˘áá áá CTRL+C - CTRL+V.
áĄáŹáá áá áááá˘áá, ááááá áááááá áŞáŽá ááá¨á áŠáá˘ááá ááá áŤááááá á ááŁááá áá ááááááŹáá ááá á¤ááááááᥠáááááááá, ááĄááá á áááá ᪠áŞáŽá áááááᥠáĄááŽááááá, ááŹáá ááá áŽáááá.
áááá á ááááŽáááá áááááŚááᥠááá¤áá áááŞááᥠáŞáŽá áááᥠáĄá˘á áŁáĽá˘áŁá áᥠá¨ááĄááŽáá áĄáĽáááááááá. 3nf áá á¨ááááŹáŁáŽá, áááá áá ááááá¤áá áááá á áááá ᪠áá áá áááááá.
áĄáŽáááá á¨áá ááĄ, á§áŁá áááŚááá ááááĽáŞááá áá áááŹááᥠ(+)
ááááŹá§áááááááᥠáŽá¨áá áá áĄááááá ááááŽáááĄ: á¨ááĄááŤááááááá áᣠáá á áá ááŽáá áááááááááá á áááá á ááŁáá ááááááááĽáááá á¨áááááŽááá¨á áá á¨ááááá áááááá§áááá ááá ááááááá áááá á áááááááá áááááááĄ. á˛áááŽ, á¨ááááŤááá. ááĄá ááááááááá:
from dbo.[_FIAS_SCHEMAS] a
Cross apply a.x.nodes('//xs:attribute') t(n)
Cross apply
(values -- нокОŃĐžŃŃĐľ ĐżĐžĐťŃ Đ¸ŃпОНŃСŃŃŃŃŃ Đ˝ĐľŃкОНŃкО ŃаС, пОŃŃĐžĐźŃ ŃдоНаоП ŃĐ°Đş :)
(
x.value('(xs:schema[1]/xs:element[1]/@name)', 'nvarchar(255)')
, ... СдоŃŃ ĐźĐžĐśĐ˝Đž поŃĐľŃиŃНиŃŃ Đ˛ŃĐľ ŃНОМнОвŃŃиŃĐťŃоПŃĐľ пОНŃ, ŃŃĐžĐąŃ ĐżĐžŃОП иŃпОНŃСОваŃŃ Đ¸Ń
в ĐťŃйОК ŃĐ°ŃŃи СапŃĐžŃĐ°
)
) tbl([root_name], [root_description], [name], [column], [required], [type], [len], [description])
áᥠááŁá¨áááᥠááá ááááŁáá á¨áááŚáŁáááááá, á á ááĽáá áŁááá. áááá áá á áááá ᪠áá ááááŹá§ááá ááᥠááááá§ááááááĄ, áĄáŹá áá¤áá ááááááá á á áá áᥠááĄááá.
3. ááááá á¨áááĽáááá áĄáá ááá˘ááá, á áááááá᪠áĽááááá FIAS áŞáŽá áááááĄ, á¨ááááá ááááŁá¨ááá ááĄááá áá ááááá á¨áááĽáááá áŞáŽá ááááá:
Declare @schema sysname = N'dbo'
Declare @sql nvarchar(max)
-- ХОСдадиП кОд Đ´ĐťŃ ŃĐžĐˇĐ´Đ°Đ˝Đ¸Ń ŃайНиŃ, и СапŃŃŃиП огО
set @sql = (
Select Distinct
N';Create table '
+ Quotename(@schema)
+ N'.'
+ Quotename([table ââ not found /]
)
+ N'('
+ Stuff((Select
N','
+ QUOTENAME(b.[column])
+ N' '
+ b.[sqltype]
+ Case b.[required] when 'required' then N' NOT NULL'
when 'optional' then N' NULL'
End
From dbo.[_FIAS] b
where b.[table ââ not found /]
= a.[table ââ not found /]
Order by N ASC
For xml path(N''), type
).value(N'.', 'nvarchar(max)'), 1, 1, N'')
+ N')'
from dbo.[_FIAS] a
For xml path(N''), type).value(N'.', N'nvarchar(max)')
exec (@sql)
ááᥠáááá ááá áᥠá§ááááá¤áá á - áĄá˘áá˘ááᥠááááᥠáááá ááááá áŞáŽá áááááᥠá¨ááĽáááᥠáĄáá ááá˘ááá áá áááá˘áá áááŁáá FIAS ááááá ááááá.
á¨áááááŽááᥠá¨áááááá áááŚáááŁáá áŞáŽá áááááᥠá¨ááĽáááᥠááááŽáááá
;
CREATE TABLE [dbo].[_ACTSTAT] (
[NAME] NVARCHAR(100) NOT NULL
,[ACTSTATID] BIGINT NOT NULL
);
CREATE TABLE [dbo].[_ADDROBJ] (
[AOGUID] UNIQUEIDENTIFIER NOT NULL
,[FORMALNAME] NVARCHAR(120) NOT NULL
,[REGIONCODE] NVARCHAR(2) NOT NULL
,[AUTOCODE] NVARCHAR(1) NOT NULL
,[AREACODE] NVARCHAR(3) NOT NULL
,[CITYCODE] NVARCHAR(3) NOT NULL
,[CTARCODE] NVARCHAR(3) NOT NULL
,[PLACECODE] NVARCHAR(3) NOT NULL
,[PLANCODE] NVARCHAR(4) NOT NULL
,[STREETCODE] NVARCHAR(4) NULL
,[EXTRCODE] NVARCHAR(4) NOT NULL
,[SEXTCODE] NVARCHAR(3) NOT NULL
,[OFFNAME] NVARCHAR(120) NULL
,[POSTALCODE] NVARCHAR(6) NULL
,[IFNSFL] NVARCHAR(4) NULL
,[TERRIFNSFL] NVARCHAR(4) NULL
,[IFNSUL] NVARCHAR(4) NULL
,[TERRIFNSUL] NVARCHAR(4) NULL
,[OKATO] NVARCHAR(11) NULL
,[UPDATEDATE] DATE NOT NULL
,[SHORTNAME] NVARCHAR(10) NOT NULL
,[AOLEVEL] BIGINT NOT NULL
,[PARENTGUID] UNIQUEIDENTIFIER NULL
,[AOID] UNIQUEIDENTIFIER NOT NULL
,[PREVID] UNIQUEIDENTIFIER NULL
,[NEXTID] UNIQUEIDENTIFIER NULL
,[CODE] NVARCHAR(17) NULL
,[PLAINCODE] NVARCHAR(15) NULL
,[ACTSTATUS] BIGINT NOT NULL
,[CENTSTATUS] BIGINT NOT NULL
,[OPERSTATUS] BIGINT NOT NULL
,[CURRSTATUS] BIGINT NOT NULL
,[STARTDATE] DATE NOT NULL
,[ENDDATE] DATE NOT NULL
,[NORMDOC] UNIQUEIDENTIFIER NULL
,[LIVESTATUS] TINYINT NOT NULL
,[DIVTYPE] INT NOT NULL
,[OKTMO] NVARCHAR(11) NULL
);
CREATE TABLE [dbo].[_CENTERST] (
[CENTERSTID] BIGINT NOT NULL
,[NAME] NVARCHAR(100) NOT NULL
);
CREATE TABLE [dbo].[_CURENTST] (
[CURENTSTID] BIGINT NOT NULL
,[NAME] NVARCHAR(100) NOT NULL
);
CREATE TABLE [dbo].[_DEL_ADDROBJ] (
[AOGUID] UNIQUEIDENTIFIER NOT NULL
,[FORMALNAME] NVARCHAR(120) NOT NULL
,[REGIONCODE] NVARCHAR(2) NOT NULL
,[AUTOCODE] NVARCHAR(1) NOT NULL
,[AREACODE] NVARCHAR(3) NOT NULL
,[CITYCODE] NVARCHAR(3) NOT NULL
,[CTARCODE] NVARCHAR(3) NOT NULL
,[PLACECODE] NVARCHAR(3) NOT NULL
,[STREETCODE] NVARCHAR(4) NULL
,[EXTRCODE] NVARCHAR(4) NOT NULL
,[PLANCODE] NVARCHAR(4) NOT NULL
,[SEXTCODE] NVARCHAR(3) NOT NULL
,[OFFNAME] NVARCHAR(120) NULL
,[POSTALCODE] NVARCHAR(6) NULL
,[SHORTNAME] NVARCHAR(10) NOT NULL
,[AOLEVEL] BIGINT NOT NULL
,[PARENTGUID] UNIQUEIDENTIFIER NULL
,[AOID] UNIQUEIDENTIFIER NOT NULL
,[PREVID] UNIQUEIDENTIFIER NULL
,[NEXTID] UNIQUEIDENTIFIER NULL
,[CODE] NVARCHAR(17) NULL
,[PLAINCODE] NVARCHAR(15) NULL
,[ACTSTATUS] BIGINT NOT NULL
,[CENTSTATUS] BIGINT NOT NULL
,[OPERSTATUS] BIGINT NOT NULL
,[CURRSTATUS] BIGINT NOT NULL
,[STARTDATE] DATE NOT NULL
,[ENDDATE] DATE NOT NULL
,[NORMDOC] UNIQUEIDENTIFIER NULL
,[LIVESTATUS] TINYINT NOT NULL
,[IFNSFL] NVARCHAR(4) NULL
,[TERRIFNSFL] NVARCHAR(4) NULL
,[IFNSUL] NVARCHAR(4) NULL
,[TERRIFNSUL] NVARCHAR(4) NULL
,[OKATO] NVARCHAR(11) NULL
,[OKTMO] NVARCHAR(11) NULL
,[UPDATEDATE] DATE NOT NULL
);
CREATE TABLE [dbo].[_DEL_HOUSE] (
[POSTALCODE] NVARCHAR(6) NULL
,[IFNSFL] NVARCHAR(4) NULL
,[TERRIFNSFL] NVARCHAR(4) NULL
,[IFNSUL] NVARCHAR(4) NULL
,[TERRIFNSUL] NVARCHAR(4) NULL
,[OKATO] NVARCHAR(11) NULL
,[OKTMO] NVARCHAR(11) NULL
,[UPDATEDATE] DATE NOT NULL
,[HOUSENUM] NVARCHAR(20) NULL
,[ESTSTATUS] SMALLINT NOT NULL
,[BUILDNUM] NVARCHAR(10) NULL
,[STRUCNUM] NVARCHAR(10) NULL
,[STRSTATUS] BIGINT NULL
,[HOUSEID] UNIQUEIDENTIFIER NOT NULL
,[HOUSEGUID] UNIQUEIDENTIFIER NOT NULL
,[AOGUID] UNIQUEIDENTIFIER NOT NULL
,[STARTDATE] DATE NOT NULL
,[ENDDATE] DATE NOT NULL
,[STATSTATUS] BIGINT NOT NULL
,[NORMDOC] UNIQUEIDENTIFIER NULL
,[COUNTER] BIGINT NOT NULL
,[CADNUM] NVARCHAR(100) NULL
,[DIVTYPE] INT NOT NULL
);
CREATE TABLE [dbo].[_DEL_HOUSEINT] (
[IFNSUL] NVARCHAR(4) NULL
,[TERRIFNSUL] NVARCHAR(4) NULL
,[OKATO] NVARCHAR(11) NULL
,[OKTMO] NVARCHAR(11) NULL
,[UPDATEDATE] DATE NOT NULL
,[INTSTART] BIGINT NOT NULL
,[INTEND] BIGINT NOT NULL
,[POSTALCODE] NVARCHAR(6) NULL
,[IFNSFL] NVARCHAR(4) NULL
,[TERRIFNSFL] NVARCHAR(4) NULL
,[HOUSEINTID] UNIQUEIDENTIFIER NOT NULL
,[INTGUID] UNIQUEIDENTIFIER NOT NULL
,[AOGUID] UNIQUEIDENTIFIER NOT NULL
,[STARTDATE] DATE NOT NULL
,[ENDDATE] DATE NOT NULL
,[INTSTATUS] BIGINT NOT NULL
,[NORMDOC] UNIQUEIDENTIFIER NULL
,[COUNTER] BIGINT NOT NULL
);
CREATE TABLE [dbo].[_DEL_LANDMARK] (
[LOCATION] NVARCHAR(500) NOT NULL
,[POSTALCODE] NVARCHAR(6) NULL
,[IFNSFL] NVARCHAR(4) NULL
,[TERRIFNSFL] NVARCHAR(4) NULL
,[IFNSUL] NVARCHAR(4) NULL
,[TERRIFNSUL] NVARCHAR(4) NULL
,[OKATO] NVARCHAR(11) NULL
,[OKTMO] NVARCHAR(11) NULL
,[UPDATEDATE] DATE NOT NULL
,[LANDID] UNIQUEIDENTIFIER NOT NULL
,[LANDGUID] UNIQUEIDENTIFIER NOT NULL
,[AOGUID] UNIQUEIDENTIFIER NOT NULL
,[STARTDATE] DATE NOT NULL
,[ENDDATE] DATE NOT NULL
,[NORMDOC] UNIQUEIDENTIFIER NULL
);
CREATE TABLE [dbo].[_DEL_NORMDOC] (
[NORMDOCID] UNIQUEIDENTIFIER NOT NULL
,[DOCNAME] NVARCHAR(max) NULL
,[DOCDATE] DATE NULL
,[DOCNUM] NVARCHAR(20) NULL
,[DOCTYPE] BIGINT NOT NULL
,[DOCIMGID] UNIQUEIDENTIFIER NULL
);
CREATE TABLE [dbo].[_ESTSTAT] (
[ESTSTATID] BIGINT NOT NULL
,[NAME] NVARCHAR(20) NOT NULL
,[SHORTNAME] NVARCHAR(20) NULL
);
CREATE TABLE [dbo].[_FLATTYPE] (
[SHORTNAME] NVARCHAR(20) NULL
,[FLTYPEID] BIGINT NOT NULL
,[NAME] NVARCHAR(20) NOT NULL
);
CREATE TABLE [dbo].[_HOUSE] (
[POSTALCODE] NVARCHAR(6) NULL
,[REGIONCODE] NVARCHAR(2) NULL
,[IFNSFL] NVARCHAR(4) NULL
,[TERRIFNSFL] NVARCHAR(4) NULL
,[IFNSUL] NVARCHAR(4) NULL
,[TERRIFNSUL] NVARCHAR(4) NULL
,[OKATO] NVARCHAR(11) NULL
,[OKTMO] NVARCHAR(11) NULL
,[UPDATEDATE] DATE NOT NULL
,[HOUSENUM] NVARCHAR(20) NULL
,[ESTSTATUS] SMALLINT NOT NULL
,[BUILDNUM] NVARCHAR(10) NULL
,[STRUCNUM] NVARCHAR(10) NULL
,[STRSTATUS] BIGINT NULL
,[HOUSEID] UNIQUEIDENTIFIER NOT NULL
,[HOUSEGUID] UNIQUEIDENTIFIER NOT NULL
,[AOGUID] UNIQUEIDENTIFIER NOT NULL
,[STARTDATE] DATE NOT NULL
,[ENDDATE] DATE NOT NULL
,[STATSTATUS] BIGINT NOT NULL
,[NORMDOC] UNIQUEIDENTIFIER NULL
,[COUNTER] BIGINT NOT NULL
,[CADNUM] NVARCHAR(100) NULL
,[DIVTYPE] INT NOT NULL
);
CREATE TABLE [dbo].[_HOUSEINT] (
[OKTMO] NVARCHAR(11) NULL
,[OKATO] NVARCHAR(11) NULL
,[IFNSUL] NVARCHAR(4) NULL
,[TERRIFNSUL] NVARCHAR(4) NULL
,[TERRIFNSFL] NVARCHAR(4) NULL
,[POSTALCODE] NVARCHAR(6) NULL
,[IFNSFL] NVARCHAR(4) NULL
,[ENDDATE] DATE NOT NULL
,[INTSTATUS] BIGINT NOT NULL
,[AOGUID] UNIQUEIDENTIFIER NOT NULL
,[STARTDATE] DATE NOT NULL
,[INTGUID] UNIQUEIDENTIFIER NOT NULL
,[HOUSEINTID] UNIQUEIDENTIFIER NOT NULL
,[INTSTART] BIGINT NOT NULL
,[INTEND] BIGINT NOT NULL
,[UPDATEDATE] DATE NOT NULL
,[NORMDOC] UNIQUEIDENTIFIER NULL
,[COUNTER] BIGINT NOT NULL
);
CREATE TABLE [dbo].[_HSTSTAT] (
[HOUSESTID] BIGINT NOT NULL
,[NAME] NVARCHAR(60) NOT NULL
);
CREATE TABLE [dbo].[_INTVSTAT] (
[INTVSTATID] BIGINT NOT NULL
,[NAME] NVARCHAR(60) NOT NULL
);
CREATE TABLE [dbo].[_LANDMARK] (
[NORMDOC] UNIQUEIDENTIFIER NULL
,[STARTDATE] DATE NOT NULL
,[ENDDATE] DATE NOT NULL
,[LANDGUID] UNIQUEIDENTIFIER NOT NULL
,[AOGUID] UNIQUEIDENTIFIER NOT NULL
,[LANDID] UNIQUEIDENTIFIER NOT NULL
,[LOCATION] NVARCHAR(500) NOT NULL
,[POSTALCODE] NVARCHAR(6) NULL
,[TERRIFNSFL] NVARCHAR(4) NULL
,[IFNSFL] NVARCHAR(4) NULL
,[UPDATEDATE] DATE NOT NULL
,[OKTMO] NVARCHAR(11) NULL
,[OKATO] NVARCHAR(11) NULL
,[IFNSUL] NVARCHAR(4) NULL
,[TERRIFNSUL] NVARCHAR(4) NULL
);
CREATE TABLE [dbo].[_NDOCTYPE] (
[NDTYPEID] BIGINT NOT NULL
,[NAME] NVARCHAR(250) NOT NULL
);
CREATE TABLE [dbo].[_NORMDOC] (
[NORMDOCID] UNIQUEIDENTIFIER NOT NULL
,[DOCNAME] NVARCHAR(max) NULL
,[DOCDATE] DATE NULL
,[DOCNUM] NVARCHAR(20) NULL
,[DOCTYPE] BIGINT NOT NULL
,[DOCIMGID] UNIQUEIDENTIFIER NULL
);
CREATE TABLE [dbo].[_OPERSTAT] (
[OPERSTATID] BIGINT NOT NULL
,[NAME] NVARCHAR(100) NOT NULL
);
CREATE TABLE [dbo].[_ROOM] (
[ROOMGUID] UNIQUEIDENTIFIER NOT NULL
,[FLATNUMBER] NVARCHAR(50) NOT NULL
,[FLATTYPE] INT NOT NULL
,[ROOMNUMBER] NVARCHAR(50) NULL
,[ROOMTYPE] INT NULL
,[REGIONCODE] NVARCHAR(2) NOT NULL
,[POSTALCODE] NVARCHAR(6) NULL
,[UPDATEDATE] DATE NOT NULL
,[HOUSEGUID] UNIQUEIDENTIFIER NOT NULL
,[ROOMID] UNIQUEIDENTIFIER NOT NULL
,[PREVID] UNIQUEIDENTIFIER NULL
,[NEXTID] UNIQUEIDENTIFIER NULL
,[STARTDATE] DATE NOT NULL
,[ENDDATE] DATE NOT NULL
,[LIVESTATUS] TINYINT NOT NULL
,[NORMDOC] UNIQUEIDENTIFIER NULL
,[OPERSTATUS] BIGINT NOT NULL
,[CADNUM] NVARCHAR(100) NULL
,[ROOMCADNUM] NVARCHAR(100) NULL
);
CREATE TABLE [dbo].[_ROOMTYPE] (
[SHORTNAME] NVARCHAR(20) NULL
,[NAME] NVARCHAR(20) NOT NULL
,[RMTYPEID] BIGINT NOT NULL
);
CREATE TABLE [dbo].[_SOCRBASE] (
[LEVEL] BIGINT NOT NULL
,[SCNAME] NVARCHAR(10) NULL
,[SOCRNAME] NVARCHAR(50) NOT NULL
,[KOD_T_ST] NVARCHAR(4) NOT NULL
);
CREATE TABLE [dbo].[_STEAD] (
[STEADGUID] UNIQUEIDENTIFIER NOT NULL
,[NUMBER] NVARCHAR(120) NULL
,[REGIONCODE] NVARCHAR(2) NOT NULL
,[POSTALCODE] NVARCHAR(6) NULL
,[IFNSFL] NVARCHAR(4) NULL
,[TERRIFNSFL] NVARCHAR(4) NULL
,[IFNSUL] NVARCHAR(4) NULL
,[TERRIFNSUL] NVARCHAR(4) NULL
,[OKATO] NVARCHAR(11) NULL
,[OKTMO] NVARCHAR(11) NULL
,[UPDATEDATE] DATE NOT NULL
,[PARENTGUID] UNIQUEIDENTIFIER NULL
,[STEADID] UNIQUEIDENTIFIER NOT NULL
,[PREVID] UNIQUEIDENTIFIER NULL
,[NEXTID] UNIQUEIDENTIFIER NULL
,[OPERSTATUS] BIGINT NOT NULL
,[STARTDATE] DATE NOT NULL
,[ENDDATE] DATE NOT NULL
,[NORMDOC] UNIQUEIDENTIFIER NULL
,[LIVESTATUS] TINYINT NOT NULL
,[CADNUM] NVARCHAR(100) NULL
,[DIVTYPE] INT NOT NULL
);
CREATE TABLE [dbo].[_STRSTAT] (
[NAME] NVARCHAR(20) NOT NULL
,[SHORTNAME] NVARCHAR(20) NULL
,[STRSTATID] BIGINT NOT NULL
)
4. áááááááá xsd-ᥠááĽáᥠáŞáŽá áááááᥠáá áááá¨á áá áĄáááŁáá ááááááᥠááá ááááŁá á ááŚáŹáá á, áŠááá ááááááá§ááááá ááᥠáá á¨áááĽáááá áĄá˘á áŁáĽá˘áŁá áᥠááŚáŹáá áᥠáŞáŽá ááááááĄá áá áááá ááááááᥠááá¤áá áááááŁá ááááĄááááá¨á:
-- ХОСдадиП аннОŃĐ°ŃĐ¸Ń Đş ŃайНиŃĐ°Đź и пОНŃĐź
Set @sql = (
Select N'; exec sp_addextendedproperty @name=''description'', @value=N'''
+ a.[root_description]
+ N''', @level0type =N''Schema'', @level0name = N'''
+ @schema
+ N''', @level1type = N''Table'', @level1name = N'''
+ a.[table ââ not found /]
+ N''''
from (Select distinct [table ââ not found /]
, [root_description] from dbo.[_FIAS]) a
for xml path(N''), type
).value(N'.', N'nvarchar(max)')
exec (@sql)
Set @sql = (
Select N'; exec sp_addextendedproperty @name=''description'', @value=N'''
+ a.[description]
+ N''', @level0type =N''Schema'', @level0name = N'''
+ @schema
+ N''', @level1type = N''Table'', @level1name = N'''
+ a.[table ââ not found /]
+ N''', @level2type = N''Column'', @level2name = N'''
+ a.[column]
+ N''''
from dbo.[_FIAS] a
for xml path(N''), type
).value(N'.', N'nvarchar(max)')
exec (@sql)
áἠáá áᥠáááá, á ááááá᪠áááááááá áá á¨ááĄá áŁááá áĄáááŁá¨ááᥠá¨áááááá
;
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО ŃŃĐ°ŃŃŃŃ Đ°ĐşŃŃĐ°ĐťŃнОŃŃи в ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ACTSTAT';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК кНаŃŃиŃикаŃĐžŃĐ° Đ°Đ´ŃĐľŃООйŃаСŃŃŃиŃ
ŃНоПонŃОв ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО ŃŃĐ°ŃŃŃŃ ŃонŃŃĐ° в ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_CENTERST';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО ŃŃĐ°ŃŃŃŃ Đ°ĐşŃŃĐ°ĐťŃнОŃŃи ĐĐĐĐĐ 4.0 в ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_CURENTST';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК кНаŃŃиŃикаŃĐžŃĐ° Đ°Đ´ŃĐľŃООйŃаСŃŃŃиŃ
ŃНоПонŃОв ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО нОПоŃĐ°Đź дОПОв ŃĐťĐ¸Ń ĐłĐžŃОдОв и наŃоНоннŃŃ
ĐżŃнкŃОв, нОПоŃĐ° СоПоНŃĐ˝ŃŃ
ŃŃĐ°ŃŃкОв и Ń.Đż в ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО инŃĐľŃваНаП дОПОв в ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО ОпиŃĐ°Đ˝Đ¸Ń ĐźĐľŃŃ ŃĐ°ŃĐżĐžĐťĐžĐśĐľĐ˝Đ¸Ń Đ¸ĐźŃŃĐľŃŃвоннŃŃ
ОйŃокŃОв в ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО ŃводониŃĐź пО нОŃПаŃивнŃĐź дОкŃПонŃĐ°Đź, ŃвНŃŃŃиПŃŃ ĐžŃнОваниоП ĐżŃиŃĐ˛ĐžĐľĐ˝Đ¸Ń Đ°Đ´ŃĐľŃĐ˝ĐžĐźŃ ŃНоПонŃŃ Đ˝Đ°Đ¸ĐźĐľĐ˝ĐžĐ˛Đ°Đ˝Đ¸Ń Đ˛ ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО ĐżŃиСнакаП Đ˛ĐťĐ°Đ´ĐľĐ˝Đ¸Ń Đ˛ ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ESTSTAT';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО ŃипаП пОПоŃониК в ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_FLATTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО нОПоŃĐ°Đź дОПОв ŃĐťĐ¸Ń ĐłĐžŃОдОв и наŃоНоннŃŃ
ĐżŃнкŃОв в ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО инŃĐľŃваНаП дОПОв в ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО ŃŃĐ°ŃŃŃŃ ŃĐžŃŃĐžŃĐ˝Đ¸Ń Đ´ĐžĐźĐžĐ˛ в ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HSTSTAT';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО ŃŃĐ°ŃŃŃŃ Đ¸Đ˝ŃĐľŃваНОв дОПОв в ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_INTVSTAT';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО ОпиŃĐ°Đ˝Đ¸Ń ĐźĐľŃŃ ŃĐ°ŃĐżĐžĐťĐžĐśĐľĐ˝Đ¸Ń Đ¸ĐźŃŃĐľŃŃвоннŃŃ
ОйŃокŃОв в ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО ŃĐ¸ĐżŃ Đ˝ĐžŃПаŃивнОгО дОкŃПонŃĐ° в ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NDOCTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО ŃводониŃĐź пО нОŃПаŃивнŃĐź дОкŃПонŃĐ°Đź, ŃвНŃŃŃиПŃŃ ĐžŃнОваниоП ĐżŃиŃĐ˛ĐžĐľĐ˝Đ¸Ń Đ°Đ´ŃĐľŃĐ˝ĐžĐźŃ ŃНоПонŃŃ Đ˝Đ°Đ¸ĐźĐľĐ˝ĐžĐ˛Đ°Đ˝Đ¸Ń Đ˛ ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО ŃŃĐ°ŃŃŃŃ Đ´ĐľĐšŃŃĐ˛Đ¸Ń Đ˛ ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_OPERSTAT';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа ŃĐž ŃводониŃПи Đž пОПоŃониŃŃ
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО ŃипаП ĐşĐžĐźĐ˝Đ°Ń Đ˛ ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOMTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО ŃипаП Đ°Đ´ŃĐľŃĐ˝ŃŃ
ОйŃокŃОв в ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_SOCRBASE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа ŃĐž ŃводониŃПи Đž СоПоНŃĐ˝ŃŃ
ŃŃĐ°ŃŃкаŃ
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃав и ŃŃŃŃĐşŃŃŃĐ° ŃаКНа Ń Đ¸Đ˝ŃĐžŃПаŃиоК пО ĐżŃиСнакаП ŃŃŃĐžĐľĐ˝Đ¸Ń Đ˛ ĐРФĐĐĐĄ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STRSTAT'
;
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐНОйаНŃĐ˝ŃĐš ŃникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° '
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AOGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ФОŃПаНиСОваннОо наиПонОванио'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'FORMALNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃогиОна'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'REGIONCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд авŃОнОПии'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AUTOCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃаКОна'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AREACODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд гОŃОда'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CITYCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд внŃŃŃигОŃОдŃкОгО ŃаКОна'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CTARCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд наŃоНоннОгО ĐżŃнкŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PLACECODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃНоПонŃĐ° пНаниŃОвОŃнОК ŃŃŃŃĐşŃŃŃŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PLANCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃНиŃŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'STREETCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд дОпОНниŃоНŃнОгО Đ°Đ´ŃĐľŃООйŃаСŃŃŃогО ŃНоПонŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'EXTRCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд пОдŃиноннОгО дОпОНниŃоНŃнОгО Đ°Đ´ŃĐľŃООйŃаСŃŃŃогО ŃНоПонŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'SEXTCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃиŃиаНŃнОо наиПонОванио'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'OFFNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžŃŃОвŃĐš индокŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ĐФĐĐĄ ФĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'IFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃĐľŃŃиŃĐžŃиаНŃнОгО ŃŃĐ°ŃŃка ĐФĐĐĄ ФĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'TERRIFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ĐФĐĐĄ ĐŽĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'IFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃĐľŃŃиŃĐžŃиаНŃнОгО ŃŃĐ°ŃŃка ĐФĐĐĄ ĐŽĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'TERRIFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKATO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'OKATO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃĐ° вноŃĐľĐ˝Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃĐ°ŃкОо наиПонОванио Ńипа ОйŃокŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'SHORTNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŁŃĐžĐ˛ĐľĐ˝Ń Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° '
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AOLEVEL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ĐžĐąŃокŃĐ° ŃОдиŃоНŃŃкОгО ОйŃокŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PARENTGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'УникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи. ĐĐťŃŃовОо пОНо.'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AOID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи ŃвŃСŃĐ˛Đ°Đ˝Đ¸Ń Ń ĐżŃодŃĐ´ŃŃоК иŃŃĐžŃиŃĐľŃкОК СапиŃŃŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PREVID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи ŃвŃСŃĐ˛Đ°Đ˝Đ¸Ń Ń ĐżĐžŃНодŃŃŃоК иŃŃĐžŃиŃĐľŃкОК СапиŃŃŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'NEXTID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° ОднОК ŃŃŃОкОК Ń ĐżŃиСнакОП Đ°ĐşŃŃĐ°ĐťŃнОŃŃи иС ĐĐĐĐĐ 4.0. '
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° иС ĐĐĐĐĐ 4.0 ОднОК ŃŃŃОкОК йоС ĐżŃиСнака Đ°ĐşŃŃĐ°ĐťŃнОŃŃи (пОŃНодниŃ
двŃŃ
ŃиŃŃ)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PLAINCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄŃĐ°ŃŃŃ Đ°ĐşŃŃĐ°ĐťŃнОŃŃи Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° ФĐĐĐĄ. ĐĐşŃŃĐ°ĐťŃĐ˝ŃĐš Đ°Đ´ŃĐľŃ Đ˝Đ° ŃокŃŃŃŃ Đ´Đ°ŃŃ. ĐĐąŃŃнО пОŃНоднŃŃ ĐˇĐ°ĐżĐ¸ŃŃ ĐžĐą Đ°Đ´ŃĐľŃнОП ОйŃокŃĐľ.
0 â ĐĐľ Đ°ĐşŃŃĐ°ĐťŃĐ˝ŃĐš
1 - ĐĐşŃŃĐ°ĐťŃĐ˝ŃĐš
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'ACTSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄŃĐ°ŃŃŃ ŃонŃŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CENTSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄŃĐ°ŃŃŃ Đ´ĐľĐšŃŃĐ˛Đ¸Ń Đ˝Đ°Đ´ СапиŃŃŃ â ĐżŃиŃина пОŃĐ˛ĐťĐľĐ˝Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи (ŃĐź. ОпиŃанио ŃайНиŃŃ OperationStatus):
01 â ĐниŃиаŃиŃ;
10 â ĐОйавНонио;
20 â ĐСПононио;
21 â ĐŃŃппОвОо иСПононио;
30 â УдаНонио;
31 - УдаНонио вŃНодŃŃвио ŃĐ´Đ°ĐťĐľĐ˝Đ¸Ń Đ˛ŃŃĐľŃŃĐžŃŃогО ОйŃокŃĐ°;
40 â ĐŃиŃОодинонио Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° (ŃНиŃнио);
41 â ĐĐľŃопОдŃинонио вŃНодŃŃвио ŃНиŃĐ˝Đ¸Ń Đ˛ŃŃĐľŃŃĐžŃŃогО ОйŃокŃĐ°;
42 - ĐŃокŃĐ°Ńонио ŃŃŃĐľŃŃĐ˛ĐžĐ˛Đ°Đ˝Đ¸Ń Đ˛ŃНодŃŃвио ĐżŃиŃĐžĐľĐ´Đ¸Đ˝ĐľĐ˝Đ¸Ń Đş Đ´ŃŃĐłĐžĐźŃ Đ°Đ´ŃĐľŃĐ˝ĐžĐźŃ ĐžĐąŃокŃŃ;
43 - ХОСданио нОвОгО Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° в ŃоСŃĐťŃŃĐ°ŃĐľ ŃНиŃĐ˝Đ¸Ń Đ°Đ´ŃĐľŃĐ˝ŃŃ
ОйŃокŃОв;
50 â ĐĐľŃопОдŃинонио;
51 â ĐĐľŃопОдŃинонио вŃНодŃŃвио поŃопОдŃĐ¸Đ˝ĐľĐ˝Đ¸Ń Đ˛ŃŃĐľŃŃĐžŃŃогО ОйŃокŃĐ°;
60 â ĐŃокŃĐ°Ńонио ŃŃŃĐľŃŃĐ˛ĐžĐ˛Đ°Đ˝Đ¸Ń Đ˛ŃНодŃŃвио Đ´ŃОйНониŃ;
61 â ХОСданио нОвОгО Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° в ŃоСŃĐťŃŃĐ°ŃĐľ Đ´ŃОйНониŃ
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'OPERSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄŃĐ°ŃŃŃ Đ°ĐşŃŃĐ°ĐťŃнОŃŃи ĐĐĐĐĐ 4 (пОŃНоднио дво ŃиŃŃŃ Đ˛ кОдо)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CURRSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃаНО доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐкОнŃанио доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐноŃниК кНŃŃ Đ˝Đ° нОŃПаŃивнŃĐš дОкŃПонŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃиСнак доКŃŃвŃŃŃогО Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'LIVESTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'
Тип Đ°Đ´ŃĐľŃĐ°Ńии:
0 - но ОпŃодоНонО
1 - ĐźŃниŃипаНŃĐ˝ŃĐš;
2 - адПиниŃŃŃĐ°ŃивнО-ŃĐľŃŃиŃĐžŃиаНŃĐ˝ŃĐš
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'DIVTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKTMO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'OKTMO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ŃŃĐ°ŃŃŃĐ° (кНŃŃ)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_CURENTST'
,@level2type = N'Column'
,@level2name = N'CURENTSTID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐаиПонОванио (0 - Đ°ĐşŃŃĐ°ĐťŃĐ˝ŃĐš, 1-50, 2-98 â иŃŃĐžŃиŃĐľŃкиК (ĐşŃОПо 51), 51 - поŃопОдŃиноннŃĐš, 99 - ноŃŃŃĐľŃŃвŃŃŃиК)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_CURENTST'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃĐ°ŃкОо наиПонОванио'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_FLATTYPE'
,@level2type = N'Column'
,@level2name = N'SHORTNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'Тип пОПоŃониŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_FLATTYPE'
,@level2type = N'Column'
,@level2name = N'FLTYPEID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐаиПонОванио'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_FLATTYPE'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ŃŃĐ°ŃŃŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HSTSTAT'
,@level2type = N'Column'
,@level2name = N'HOUSESTID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐаиПонОванио'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HSTSTAT'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи (кНŃŃ)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NDOCTYPE'
,@level2type = N'Column'
,@level2name = N'NDTYPEID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐаиПонОванио Ńипа нОŃПаŃивнОгО дОкŃПонŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NDOCTYPE'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ŃŃĐ°ŃŃŃĐ° (кНŃŃ)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_OPERSTAT'
,@level2type = N'Column'
,@level2name = N'OPERSTATID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐаиПонОванио
01 â ĐниŃиаŃиŃ;
10 â ĐОйавНонио;
20 â ĐСПононио;
21 â ĐŃŃппОвОо иСПононио;
30 â УдаНонио;
31 - УдаНонио вŃНодŃŃвио ŃĐ´Đ°ĐťĐľĐ˝Đ¸Ń Đ˛ŃŃĐľŃŃĐžŃŃогО ОйŃокŃĐ°;
40 â ĐŃиŃОодинонио Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° (ŃНиŃнио);
41 â ĐĐľŃопОдŃинонио вŃНодŃŃвио ŃНиŃĐ˝Đ¸Ń Đ˛ŃŃĐľŃŃĐžŃŃогО ОйŃокŃĐ°;
42 - ĐŃокŃĐ°Ńонио ŃŃŃĐľŃŃĐ˛ĐžĐ˛Đ°Đ˝Đ¸Ń Đ˛ŃНодŃŃвио ĐżŃиŃĐžĐľĐ´Đ¸Đ˝ĐľĐ˝Đ¸Ń Đş Đ´ŃŃĐłĐžĐźŃ Đ°Đ´ŃĐľŃĐ˝ĐžĐźŃ ĐžĐąŃокŃŃ;
43 - ХОСданио нОвОгО Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° в ŃоСŃĐťŃŃĐ°ŃĐľ ŃНиŃĐ˝Đ¸Ń Đ°Đ´ŃĐľŃĐ˝ŃŃ
ОйŃокŃОв;
50 â ĐĐľŃопОдŃинонио;
51 â ĐĐľŃопОдŃинонио вŃНодŃŃвио поŃопОдŃĐ¸Đ˝ĐľĐ˝Đ¸Ń Đ˛ŃŃĐľŃŃĐžŃŃогО ОйŃокŃĐ°;
60 â ĐŃокŃĐ°Ńонио ŃŃŃĐľŃŃĐ˛ĐžĐ˛Đ°Đ˝Đ¸Ń Đ˛ŃНодŃŃвио Đ´ŃОйНониŃ;
61 â ХОСданио нОвОгО Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° в ŃоСŃĐťŃŃĐ°ŃĐľ Đ´ŃОйНониŃ;
70 â ĐĐžŃŃŃанОвНонио ОйŃокŃĐ° ĐżŃокŃĐ°ŃивŃогО ŃŃŃĐľŃŃвОванио'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_OPERSTAT'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐНОйаНŃĐ˝ŃĐš ŃникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° '
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AOGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ФОŃПаНиСОваннОо наиПонОванио'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'FORMALNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃогиОна'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'REGIONCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд авŃОнОПии'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AUTOCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃаКОна'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AREACODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд гОŃОда'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CITYCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд внŃŃŃигОŃОдŃкОгО ŃаКОна'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CTARCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд наŃоНоннОгО ĐżŃнкŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PLACECODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃНиŃŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'STREETCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд дОпОНниŃоНŃнОгО Đ°Đ´ŃĐľŃООйŃаСŃŃŃогО ŃНоПонŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'EXTRCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃНоПонŃĐ° пНаниŃОвОŃнОК ŃŃŃŃĐşŃŃŃŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PLANCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд пОдŃиноннОгО дОпОНниŃоНŃнОгО Đ°Đ´ŃĐľŃООйŃаСŃŃŃогО ŃНоПонŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'SEXTCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃиŃиаНŃнОо наиПонОванио'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'OFFNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžŃŃОвŃĐš индокŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃĐ°ŃкОо наиПонОванио Ńипа ОйŃокŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'SHORTNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŁŃĐžĐ˛ĐľĐ˝Ń Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° '
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AOLEVEL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ĐžĐąŃокŃĐ° ŃОдиŃоНŃŃкОгО ОйŃокŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PARENTGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'УникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи. ĐĐťŃŃовОо пОНо.'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AOID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи ŃвŃСŃĐ˛Đ°Đ˝Đ¸Ń Ń ĐżŃодŃĐ´ŃŃоК иŃŃĐžŃиŃĐľŃкОК СапиŃŃŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PREVID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи ŃвŃСŃĐ˛Đ°Đ˝Đ¸Ń Ń ĐżĐžŃНодŃŃŃоК иŃŃĐžŃиŃĐľŃкОК СапиŃŃŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'NEXTID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° ОднОК ŃŃŃОкОК Ń ĐżŃиСнакОП Đ°ĐşŃŃĐ°ĐťŃнОŃŃи иС ĐĐĐĐĐ 4.0. '
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° иС ĐĐĐĐĐ 4.0 ОднОК ŃŃŃОкОК йоС ĐżŃиСнака Đ°ĐşŃŃĐ°ĐťŃнОŃŃи (пОŃНодниŃ
двŃŃ
ŃиŃŃ)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PLAINCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄŃĐ°ŃŃŃ Đ°ĐşŃŃĐ°ĐťŃнОŃŃи Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° ФĐĐĐĄ. ĐĐşŃŃĐ°ĐťŃĐ˝ŃĐš Đ°Đ´ŃĐľŃ Đ˝Đ° ŃокŃŃŃŃ Đ´Đ°ŃŃ. ĐĐąŃŃнО пОŃНоднŃŃ ĐˇĐ°ĐżĐ¸ŃŃ ĐžĐą Đ°Đ´ŃĐľŃнОП ОйŃокŃĐľ.
0 â ĐĐľ Đ°ĐşŃŃĐ°ĐťŃĐ˝ŃĐš
1 - ĐĐşŃŃĐ°ĐťŃĐ˝ŃĐš
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'ACTSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄŃĐ°ŃŃŃ ŃонŃŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CENTSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄŃĐ°ŃŃŃ Đ´ĐľĐšŃŃĐ˛Đ¸Ń Đ˝Đ°Đ´ СапиŃŃŃ â ĐżŃиŃина пОŃĐ˛ĐťĐľĐ˝Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи (ŃĐź. ОпиŃанио ŃайНиŃŃ OperationStatus):
01 â ĐниŃиаŃиŃ;
10 â ĐОйавНонио;
20 â ĐСПононио;
21 â ĐŃŃппОвОо иСПононио;
30 â УдаНонио;
31 - УдаНонио вŃНодŃŃвио ŃĐ´Đ°ĐťĐľĐ˝Đ¸Ń Đ˛ŃŃĐľŃŃĐžŃŃогО ОйŃокŃĐ°;
40 â ĐŃиŃОодинонио Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° (ŃНиŃнио);
41 â ĐĐľŃопОдŃинонио вŃНодŃŃвио ŃНиŃĐ˝Đ¸Ń Đ˛ŃŃĐľŃŃĐžŃŃогО ОйŃокŃĐ°;
42 - ĐŃокŃĐ°Ńонио ŃŃŃĐľŃŃĐ˛ĐžĐ˛Đ°Đ˝Đ¸Ń Đ˛ŃНодŃŃвио ĐżŃиŃĐžĐľĐ´Đ¸Đ˝ĐľĐ˝Đ¸Ń Đş Đ´ŃŃĐłĐžĐźŃ Đ°Đ´ŃĐľŃĐ˝ĐžĐźŃ ĐžĐąŃокŃŃ;
43 - ХОСданио нОвОгО Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° в ŃоСŃĐťŃŃĐ°ŃĐľ ŃНиŃĐ˝Đ¸Ń Đ°Đ´ŃĐľŃĐ˝ŃŃ
ОйŃокŃОв;
50 â ĐĐľŃопОдŃинонио;
51 â ĐĐľŃопОдŃинонио вŃНодŃŃвио поŃопОдŃĐ¸Đ˝ĐľĐ˝Đ¸Ń Đ˛ŃŃĐľŃŃĐžŃŃогО ОйŃокŃĐ°;
60 â ĐŃокŃĐ°Ńонио ŃŃŃĐľŃŃĐ˛ĐžĐ˛Đ°Đ˝Đ¸Ń Đ˛ŃНодŃŃвио Đ´ŃОйНониŃ;
61 â ХОСданио нОвОгО Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° в ŃоСŃĐťŃŃĐ°ŃĐľ Đ´ŃОйНониŃ
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'OPERSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄŃĐ°ŃŃŃ Đ°ĐşŃŃĐ°ĐťŃнОŃŃи ĐĐĐĐĐ 4 (пОŃНоднио дво ŃиŃŃŃ Đ˛ кОдо)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CURRSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃаНО доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐкОнŃанио доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐноŃниК кНŃŃ Đ˝Đ° нОŃПаŃивнŃĐš дОкŃПонŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃиСнак доКŃŃвŃŃŃогО Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'LIVESTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ĐФĐĐĄ ФĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'IFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃĐľŃŃиŃĐžŃиаНŃнОгО ŃŃĐ°ŃŃка ĐФĐĐĄ ФĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'TERRIFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ĐФĐĐĄ ĐŽĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'IFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃĐľŃŃиŃĐžŃиаНŃнОгО ŃŃĐ°ŃŃка ĐФĐĐĄ ĐŽĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'TERRIFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKATO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'OKATO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKTMO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'OKTMO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃĐ° вноŃĐľĐ˝Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ĐФĐĐĄ ĐŽĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'IFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃĐľŃŃиŃĐžŃиаНŃнОгО ŃŃĐ°ŃŃка ĐФĐĐĄ ĐŽĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'TERRIFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKATO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'OKATO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKTMO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'OKTMO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃĐ° вноŃĐľĐ˝Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐнаŃонио наŃаНа инŃĐľŃваНа'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'INTSTART';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐнаŃонио ОкОнŃĐ°Đ˝Đ¸Ń Đ¸Đ˝ŃĐľŃваНа'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'INTEND';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžŃŃОвŃĐš индокŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ĐФĐĐĄ ФĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'IFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃĐľŃŃиŃĐžŃиаНŃнОгО ŃŃĐ°ŃŃка ĐФĐĐĄ ФĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'TERRIFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи инŃĐľŃваНа дОПОв'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'HOUSEINTID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐНОйаНŃĐ˝ŃĐš ŃникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ Đ¸Đ˝ŃĐľŃваНа дОПОв'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'INTGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ĐžĐąŃокŃĐ° ŃОдиŃоНŃŃкОгО ОйŃокŃĐ° (ŃНиŃŃ, гОŃОда, наŃоНоннОгО ĐżŃнкŃĐ° и Ń.Đż.)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'AOGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃаНО доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐкОнŃанио доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄŃĐ°ŃŃŃ Đ¸Đ˝ŃĐľŃваНа (ОйŃŃĐ˝ŃĐš, ŃĐľŃĐ˝ŃĐš, ноŃĐľŃĐ˝ŃĐš)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'INTSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐноŃниК кНŃŃ Đ˝Đ° нОŃПаŃивнŃĐš дОкŃПонŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄŃĐľŃŃик СапиŃоК дОПОв Đ´ĐťŃ ĐĐĐĐĐ 4'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'COUNTER';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ Đ˝ĐžŃПаŃивнОгО дОкŃПонŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_NORMDOC'
,@level2type = N'Column'
,@level2name = N'NORMDOCID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐаиПонОванио дОкŃПонŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃĐ° дОкŃПонŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžĐźĐľŃ Đ´ĐžĐşŃПонŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'Тип дОкŃПонŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ĐžĐąŃаСа (вноŃниК кНŃŃ)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCIMGID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKTMO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'OKTMO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKATO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'OKATO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ĐФĐĐĄ ĐŽĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'IFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃĐľŃŃиŃĐžŃиаНŃнОгО ŃŃĐ°ŃŃка ĐФĐĐĄ ĐŽĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'TERRIFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃĐľŃŃиŃĐžŃиаНŃнОгО ŃŃĐ°ŃŃка ĐФĐĐĄ ФĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'TERRIFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžŃŃОвŃĐš индокŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ĐФĐĐĄ ФĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'IFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐкОнŃанио доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄŃĐ°ŃŃŃ Đ¸Đ˝ŃĐľŃваНа (ОйŃŃĐ˝ŃĐš, ŃĐľŃĐ˝ŃĐš, ноŃĐľŃĐ˝ŃĐš)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'INTSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ĐžĐąŃокŃĐ° ŃОдиŃоНŃŃкОгО ОйŃокŃĐ° (ŃНиŃŃ, гОŃОда, наŃоНоннОгО ĐżŃнкŃĐ° и Ń.Đż.)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'AOGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃаНО доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐНОйаНŃĐ˝ŃĐš ŃникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ Đ¸Đ˝ŃĐľŃваНа дОПОв'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'INTGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи инŃĐľŃваНа дОПОв'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'HOUSEINTID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐнаŃонио наŃаНа инŃĐľŃваНа'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'INTSTART';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐнаŃонио ОкОнŃĐ°Đ˝Đ¸Ń Đ¸Đ˝ŃĐľŃваНа'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'INTEND';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃĐ° вноŃĐľĐ˝Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐноŃниК кНŃŃ Đ˝Đ° нОŃПаŃивнŃĐš дОкŃПонŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄŃĐľŃŃик СапиŃоК дОПОв Đ´ĐťŃ ĐĐĐĐĐ 4'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'COUNTER';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ŃŃĐ°ŃŃŃĐ° (ОйŃŃĐ˝ŃĐš, ŃĐľŃĐ˝ŃĐš, ноŃĐľŃĐ˝ŃĐš)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_INTVSTAT'
,@level2type = N'Column'
,@level2name = N'INTVSTATID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐаиПонОванио'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_INTVSTAT'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐноŃниК кНŃŃ Đ˝Đ° нОŃПаŃивнŃĐš дОкŃПонŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃаНО доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐкОнŃанио доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐНОйаНŃĐ˝ŃĐš ŃникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ ĐžŃионŃиŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'LANDGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'УникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ ŃОдиŃоНŃŃкОгО ОйŃокŃĐ° (ŃНиŃŃ, гОŃОда, наŃоНоннОгО ĐżŃнкŃĐ° и Ń.Đż.)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'AOGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'УникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи ĐžŃионŃиŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'LANDID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐľŃŃĐžŃĐ°ŃпОНОМонио ĐžŃионŃиŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'LOCATION';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžŃŃОвŃĐš индокŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃĐľŃŃиŃĐžŃиаНŃнОгО ŃŃĐ°ŃŃка ĐФĐĐĄ ФĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'TERRIFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ĐФĐĐĄ ФĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'IFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃĐ° вноŃĐľĐ˝Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKTMO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'OKTMO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKATO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'OKATO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ĐФĐĐĄ ĐŽĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'IFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃĐľŃŃиŃĐžŃиаНŃнОгО ŃŃĐ°ŃŃка ĐФĐĐĄ ĐŽĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'TERRIFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ Đ˝ĐžŃПаŃивнОгО дОкŃПонŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NORMDOC'
,@level2type = N'Column'
,@level2name = N'NORMDOCID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐаиПонОванио дОкŃПонŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃĐ° дОкŃПонŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžĐźĐľŃ Đ´ĐžĐşŃПонŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'Тип дОкŃПонŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ĐžĐąŃаСа (вноŃниК кНŃŃ)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCIMGID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃĐ°ŃкОо наиПонОванио'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOMTYPE'
,@level2type = N'Column'
,@level2name = N'SHORTNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐаиПонОванио'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOMTYPE'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'Тип кОПнаŃŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOMTYPE'
,@level2type = N'Column'
,@level2name = N'RMTYPEID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŁŃĐžĐ˛ĐľĐ˝Ń Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_SOCRBASE'
,@level2type = N'Column'
,@level2name = N'LEVEL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃĐ°ŃкОо наиПонОванио Ńипа ОйŃокŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_SOCRBASE'
,@level2type = N'Column'
,@level2name = N'SCNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОНнОо наиПонОванио Ńипа ОйŃокŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_SOCRBASE'
,@level2type = N'Column'
,@level2name = N'SOCRNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐťŃŃовОо пОНо'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_SOCRBASE'
,@level2type = N'Column'
,@level2name = N'KOD_T_ST';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐаиПонОванио
0 â ĐĐľ Đ°ĐşŃŃĐ°ĐťŃĐ˝ŃĐš
1 â ĐĐşŃŃĐ°ĐťŃĐ˝ŃĐš (пОŃНоднŃŃ ĐˇĐ°ĐżĐ¸ŃŃ ĐżĐž Đ°Đ´ŃĐľŃĐ˝ĐžĐźŃ ĐžĐąŃокŃŃ)
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ACTSTAT'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ŃŃĐ°ŃŃŃĐ° (кНŃŃ)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ACTSTAT'
,@level2type = N'Column'
,@level2name = N'ACTSTATID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ŃŃĐ°ŃŃŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_CENTERST'
,@level2type = N'Column'
,@level2name = N'CENTERSTID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐаиПонОванио'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_CENTERST'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžŃŃОвŃĐš индокŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ĐФĐĐĄ ФĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'IFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃĐľŃŃиŃĐžŃиаНŃнОгО ŃŃĐ°ŃŃка ĐФĐĐĄ ФĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'TERRIFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ĐФĐĐĄ ĐŽĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'IFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃĐľŃŃиŃĐžŃиаНŃнОгО ŃŃĐ°ŃŃка ĐФĐĐĄ ĐŽĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'TERRIFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKATO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'OKATO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKTMO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'OKTMO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃĐ° вŃĐľĐźŃ Đ˛Đ˝ĐľŃĐľĐ˝Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžĐźĐľŃ Đ´ĐžĐźĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'HOUSENUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃиСнак вНадониŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'ESTSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžĐźĐľŃ ĐşĐžŃĐżŃŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'BUILDNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžĐźĐľŃ ŃŃŃОониŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'STRUCNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃиСнак ŃŃŃОониŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'STRSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'УникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи дОПа'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'HOUSEID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐНОйаНŃĐ˝ŃĐš ŃникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ Đ´ĐžĐźĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'HOUSEGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'Guid СапиŃи ŃОдиŃоНŃŃкОгО ОйŃокŃĐ° (ŃНиŃŃ, гОŃОда, наŃоНоннОгО ĐżŃнкŃĐ° и Ń.Đż.)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'AOGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃаНО доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐкОнŃанио доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃĐžŃнио дОПа'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'STATSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐноŃниК кНŃŃ Đ˝Đ° нОŃПаŃивнŃĐš дОкŃПонŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄŃĐľŃŃик СапиŃоК дОПОв Đ´ĐťŃ ĐĐĐĐĐ 4'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'COUNTER';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°Đ´Đ°ŃŃŃОвŃĐš нОПоŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'CADNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'Тип Đ°Đ´ŃĐľŃĐ°Ńии:
0 - но ОпŃодоНонО
1 - ĐźŃниŃипаНŃĐ˝ŃĐš;
2 - адПиниŃŃŃĐ°ŃивнО-ŃĐľŃŃиŃĐžŃиаНŃĐ˝ŃĐš'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'DIVTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃиСнак вНадониŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ESTSTAT'
,@level2type = N'Column'
,@level2name = N'ESTSTATID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐаиПонОванио'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ESTSTAT'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃĐ°ŃкОо наиПонОванио'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ESTSTAT'
,@level2type = N'Column'
,@level2name = N'SHORTNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐНОйаНŃĐ˝ŃĐš ŃникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° (СоПоНŃнОгО ŃŃĐ°ŃŃка)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'STEADGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžĐźĐľŃ ĐˇĐľĐźĐľĐťŃнОгО ŃŃĐ°ŃŃка'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'NUMBER';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃогиОна'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'REGIONCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžŃŃОвŃĐš индокŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ĐФĐĐĄ ФĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'IFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃĐľŃŃиŃĐžŃиаНŃнОгО ŃŃĐ°ŃŃка ĐФĐĐĄ ФĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'TERRIFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ĐФĐĐĄ ĐŽĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'IFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃĐľŃŃиŃĐžŃиаНŃнОгО ŃŃĐ°ŃŃка ĐФĐĐĄ ĐŽĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'TERRIFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKATO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'OKATO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKTMO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'OKTMO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃĐ° вноŃĐľĐ˝Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ĐžĐąŃокŃĐ° ŃОдиŃоНŃŃкОгО ОйŃокŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'PARENTGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'УникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи. ĐĐťŃŃовОо пОНо.'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'STEADID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи ŃвŃСŃĐ˛Đ°Đ˝Đ¸Ń Ń ĐżŃодŃĐ´ŃŃоК иŃŃĐžŃиŃĐľŃкОК СапиŃŃŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'PREVID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи ŃвŃСŃĐ˛Đ°Đ˝Đ¸Ń Ń ĐżĐžŃНодŃŃŃоК иŃŃĐžŃиŃĐľŃкОК СапиŃŃŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'NEXTID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄŃĐ°ŃŃŃ Đ´ĐľĐšŃŃĐ˛Đ¸Ń Đ˝Đ°Đ´ СапиŃŃŃ â ĐżŃиŃина пОŃĐ˛ĐťĐľĐ˝Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи (ŃĐź. ОпиŃанио ŃайНиŃŃ OperationStatus):
01 â ĐниŃиаŃиŃ;
10 â ĐОйавНонио;
20 â ĐСПононио;
21 â ĐŃŃппОвОо иСПононио;
30 â УдаНонио;
31 - УдаНонио вŃНодŃŃвио ŃĐ´Đ°ĐťĐľĐ˝Đ¸Ń Đ˛ŃŃĐľŃŃĐžŃŃогО ОйŃокŃĐ°;
40 â ĐŃиŃОодинонио Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° (ŃНиŃнио);
41 â ĐĐľŃопОдŃинонио вŃНодŃŃвио ŃНиŃĐ˝Đ¸Ń Đ˛ŃŃĐľŃŃĐžŃŃогО ОйŃокŃĐ°;
42 - ĐŃокŃĐ°Ńонио ŃŃŃĐľŃŃĐ˛ĐžĐ˛Đ°Đ˝Đ¸Ń Đ˛ŃНодŃŃвио ĐżŃиŃĐžĐľĐ´Đ¸Đ˝ĐľĐ˝Đ¸Ń Đş Đ´ŃŃĐłĐžĐźŃ Đ°Đ´ŃĐľŃĐ˝ĐžĐźŃ ĐžĐąŃокŃŃ;
43 - ХОСданио нОвОгО Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° в ŃоСŃĐťŃŃĐ°ŃĐľ ŃНиŃĐ˝Đ¸Ń Đ°Đ´ŃĐľŃĐ˝ŃŃ
ОйŃокŃОв;
50 â ĐĐľŃопОдŃинонио;
51 â ĐĐľŃопОдŃинонио вŃНодŃŃвио поŃопОдŃĐ¸Đ˝ĐľĐ˝Đ¸Ń Đ˛ŃŃĐľŃŃĐžŃŃогО ОйŃокŃĐ°;
60 â ĐŃокŃĐ°Ńонио ŃŃŃĐľŃŃĐ˛ĐžĐ˛Đ°Đ˝Đ¸Ń Đ˛ŃНодŃŃвио Đ´ŃОйНониŃ;
61 â ХОСданио нОвОгО Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° в ŃоСŃĐťŃŃĐ°ŃĐľ Đ´ŃОйНониŃ
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'OPERSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃаНО доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐкОнŃанио доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐноŃниК кНŃŃ Đ˝Đ° нОŃПаŃивнŃĐš дОкŃПонŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃиСнак доКŃŃвŃŃŃогО Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'LIVESTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°Đ´Đ°ŃŃŃОвŃĐš нОПоŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'CADNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'Тип Đ°Đ´ŃĐľŃĐ°Ńии:
0 - но ОпŃодоНонО
1 - ĐźŃниŃипаНŃĐ˝ŃĐš;
2 - адПиниŃŃŃĐ°ŃивнО-ŃĐľŃŃиŃĐžŃиаНŃĐ˝ŃĐš'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'DIVTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐľŃŃĐžŃĐ°ŃпОНОМонио ĐžŃионŃиŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'LOCATION';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžŃŃОвŃĐš индокŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ĐФĐĐĄ ФĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'IFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃĐľŃŃиŃĐžŃиаНŃнОгО ŃŃĐ°ŃŃка ĐФĐĐĄ ФĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'TERRIFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ĐФĐĐĄ ĐŽĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'IFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃĐľŃŃиŃĐžŃиаНŃнОгО ŃŃĐ°ŃŃка ĐФĐĐĄ ĐŽĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'TERRIFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKATO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'OKATO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKTMO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'OKTMO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃĐ° вноŃĐľĐ˝Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'УникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи ĐžŃионŃиŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'LANDID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐНОйаНŃĐ˝ŃĐš ŃникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ ĐžŃионŃиŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'LANDGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'УникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ ŃОдиŃоНŃŃкОгО ОйŃокŃĐ° (ŃНиŃŃ, гОŃОда, наŃоНоннОгО ĐżŃнкŃĐ° и Ń.Đż.)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'AOGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃаНО доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐкОнŃанио доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐноŃниК кНŃŃ Đ˝Đ° нОŃПаŃивнŃĐš дОкŃПонŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžŃŃОвŃĐš индокŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃогиОна'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'REGIONCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ĐФĐĐĄ ФĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'IFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃĐľŃŃиŃĐžŃиаНŃнОгО ŃŃĐ°ŃŃка ĐФĐĐĄ ФĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'TERRIFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ĐФĐĐĄ ĐŽĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'IFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃĐľŃŃиŃĐžŃиаНŃнОгО ŃŃĐ°ŃŃка ĐФĐĐĄ ĐŽĐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'TERRIFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKATO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'OKATO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKTMO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'OKTMO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃĐ° вŃĐľĐźŃ Đ˛Đ˝ĐľŃĐľĐ˝Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžĐźĐľŃ Đ´ĐžĐźĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'HOUSENUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃиСнак вНадониŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'ESTSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžĐźĐľŃ ĐşĐžŃĐżŃŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'BUILDNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžĐźĐľŃ ŃŃŃОониŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'STRUCNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃиСнак ŃŃŃОониŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'STRSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'УникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи дОПа'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'HOUSEID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐНОйаНŃĐ˝ŃĐš ŃникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ Đ´ĐžĐźĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'HOUSEGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'Guid СапиŃи ŃОдиŃоНŃŃкОгО ОйŃокŃĐ° (ŃНиŃŃ, гОŃОда, наŃоНоннОгО ĐżŃнкŃĐ° и Ń.Đż.)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'AOGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃаНО доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐкОнŃанио доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄĐžŃŃĐžŃнио дОПа'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'STATSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐноŃниК кНŃŃ Đ˝Đ° нОŃПаŃивнŃĐš дОкŃПонŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄŃĐľŃŃик СапиŃоК дОПОв Đ´ĐťŃ ĐĐĐĐĐ 4'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'COUNTER';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°Đ´Đ°ŃŃŃОвŃĐš нОПоŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'CADNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'Тип Đ°Đ´ŃĐľŃĐ°Ńии:
0 - но ОпŃодоНонО
1 - ĐźŃниŃипаНŃĐ˝ŃĐš;
2 - адПиниŃŃŃĐ°ŃивнО-ŃĐľŃŃиŃĐžŃиаНŃĐ˝ŃĐš'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'DIVTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐНОйаНŃĐ˝ŃĐš ŃникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° (пОПоŃониŃ)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'ROOMGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžĐźĐľŃ ĐżĐžĐźĐľŃĐľĐ˝Đ¸Ń Đ¸ĐťĐ¸ ĐžŃиŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'FLATNUMBER';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'Тип пОПоŃониŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'FLATTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžĐźĐľŃ ĐşĐžĐźĐ˝Đ°ŃŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'ROOMNUMBER';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'Тип кОПнаŃŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'ROOMTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐОд ŃогиОна'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'REGIONCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐžŃŃОвŃĐš индокŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃĐ° вноŃĐľĐ˝Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ŃОдиŃоНŃŃкОгО ОйŃокŃĐ° (дОПа)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'HOUSEGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'УникаНŃĐ˝ŃĐš идонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи. ĐĐťŃŃовОо пОНо.'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'ROOMID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи ŃвŃСŃĐ˛Đ°Đ˝Đ¸Ń Ń ĐżŃодŃĐ´ŃŃоК иŃŃĐžŃиŃĐľŃкОК СапиŃŃŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'PREVID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐдонŃиŃикаŃĐžŃ ĐˇĐ°ĐżĐ¸Ńи ŃвŃСŃĐ˛Đ°Đ˝Đ¸Ń Ń ĐżĐžŃНодŃŃŃоК иŃŃĐžŃиŃĐľŃкОК СапиŃŃŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'NEXTID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°ŃаНО доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐкОнŃанио доКŃŃĐ˛Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃиСнак доКŃŃвŃŃŃогО Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ°'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'LIVESTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐноŃниК кНŃŃ Đ˝Đ° нОŃПаŃивнŃĐš дОкŃПонŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĄŃĐ°ŃŃŃ Đ´ĐľĐšŃŃĐ˛Đ¸Ń Đ˝Đ°Đ´ СапиŃŃŃ â ĐżŃиŃина пОŃĐ˛ĐťĐľĐ˝Đ¸Ń ĐˇĐ°ĐżĐ¸Ńи (ŃĐź. ОпиŃанио ŃайНиŃŃ OperationStatus):
01 â ĐниŃиаŃиŃ;
10 â ĐОйавНонио;
20 â ĐСПононио;
21 â ĐŃŃппОвОо иСПононио;
30 â УдаНонио;
31 - УдаНонио вŃНодŃŃвио ŃĐ´Đ°ĐťĐľĐ˝Đ¸Ń Đ˛ŃŃĐľŃŃĐžŃŃогО ОйŃокŃĐ°;
40 â ĐŃиŃОодинонио Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° (ŃНиŃнио);
41 â ĐĐľŃопОдŃинонио вŃНодŃŃвио ŃНиŃĐ˝Đ¸Ń Đ˛ŃŃĐľŃŃĐžŃŃогО ОйŃокŃĐ°;
42 - ĐŃокŃĐ°Ńонио ŃŃŃĐľŃŃĐ˛ĐžĐ˛Đ°Đ˝Đ¸Ń Đ˛ŃНодŃŃвио ĐżŃиŃĐžĐľĐ´Đ¸Đ˝ĐľĐ˝Đ¸Ń Đş Đ´ŃŃĐłĐžĐźŃ Đ°Đ´ŃĐľŃĐ˝ĐžĐźŃ ĐžĐąŃокŃŃ;
43 - ХОСданио нОвОгО Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° в ŃоСŃĐťŃŃĐ°ŃĐľ ŃНиŃĐ˝Đ¸Ń Đ°Đ´ŃĐľŃĐ˝ŃŃ
ОйŃокŃОв;
50 â ĐĐľŃопОдŃинонио;
51 â ĐĐľŃопОдŃинонио вŃНодŃŃвио поŃопОдŃĐ¸Đ˝ĐľĐ˝Đ¸Ń Đ˛ŃŃĐľŃŃĐžŃŃогО ОйŃокŃĐ°;
60 â ĐŃокŃĐ°Ńонио ŃŃŃĐľŃŃĐ˛ĐžĐ˛Đ°Đ˝Đ¸Ń Đ˛ŃНодŃŃвио Đ´ŃОйНониŃ;
61 â ХОСданио нОвОгО Đ°Đ´ŃĐľŃнОгО ОйŃокŃĐ° в ŃоСŃĐťŃŃĐ°ŃĐľ Đ´ŃОйНониŃ
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'OPERSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°Đ´Đ°ŃŃŃОвŃĐš Đ˝ĐžĐźĐľŃ ĐżĐžĐźĐľŃониŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'CADNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐĐ°Đ´Đ°ŃŃŃОвŃĐš Đ˝ĐžĐźĐľŃ ĐşĐžĐźĐ˝Đ°ŃŃ Đ˛ пОПоŃонии'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'ROOMCADNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐаиПонОванио'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STRSTAT'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃĐ°ŃкОо наиПонОванио'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STRSTAT'
,@level2type = N'Column'
,@level2name = N'SHORTNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ĐŃиСнак ŃŃŃОониŃ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STRSTAT'
,@level2type = N'Column'
,@level2name = N'STRSTATID'
5. áŠááá áááááá ááŞáááá áĄáĽáááááĄ:
-- ĐĐżŃодоНонио ŃŃŃНки на иПпОŃŃиŃŃоПŃŃ ŃŃ
оПŃ
update a
Set x.modify ('declare namespace xs="http://www.w3.org/2001/XMLSchema";
insert <xs:import namespace="http://schemas.microsoft.com/sqlserver/2004/sqltypes" schemaLocation="./sqltypes.xsd" /> as first
into (xs:schema)[1]')
from dbo.[_FIAS_SCHEMAS] a
-- ĐĐżŃодоНонио кОŃновОгО Đ°ŃŃŃийŃŃĐ°
update a
Set x.modify('declare namespace ss="urn:schemas-microsoft-com:mapping-schema";
insert (
attribute ss:is-constant {"1"}
)
into (/xs:schema[1]/xs:element[1])')
from dbo.[_FIAS_SCHEMAS] a
-- ĐĐżŃодоНонио нОдŃ, ŃвНŃŃŃоКŃŃ ŃŃŃОкОК ŃайНиŃŃ Đ¸ ŃвŃСаннОК Ń Đ˝ĐľĐš ŃайНиŃŃ
update a
Set x.modify('declare namespace ss="urn:schemas-microsoft-com:mapping-schema";
insert (
attribute ss:relation {sql:column("a.table")}
)
into (xs:schema[1]/xs:element[1]/xs:complexType[1]/xs:sequence[1]/xs:element[1])')
from dbo.[_FIAS_SCHEMAS] a
-- ĐннОŃĐ°ŃĐ¸Ń ĐżĐžĐťĐľĐš в ŃŃ
оПо
-- Т.Đş. Са 1 ŃаС ПОМнО ПОдиŃиŃиŃОваŃŃ ŃОНŃкО ĐžĐ´Đ˝Ń Đ˝ĐžĐ´Ń - ĐżŃидоŃŃŃ Đ¸ŃпОНŃСОваŃŃ ĐşŃŃŃĐžŃ
Declare @table nvarchar(4000)
Declare @column nvarchar(4000)
Declare cur CURSOR LOCAL FORWARD_ONLY
for
Select [table ââ not found /]
, [column]
from dbo.[_FIAS]
Open cur
FETCH NEXT FROM cur into @table, @column
WHILE @@FETCH_STATUS = 0
BEGIN
update a
Set x.modify('declare namespace ss="urn:schemas-microsoft-com:mapping-schema";
insert (
attribute ss:field {sql:column("t.column")}
,attribute ss:datatype {sql:column("b.sqltype")}
)
into (//xs:attribute[@name = sql:column("b.column")])[1]')
from dbo.[_FIAS_SCHEMAS] a
inner join dbo.[_FIAS] b on a.[table ââ not found /]
= b.[table ââ not found /]
cross apply (Values(QUOTENAME(b.[column]))) t([column])
Where b.[table ââ not found /]
= @table and b.[column] = @column
FETCH NEXT FROM cur into @table, @column
END
CLOSE cur;
DEALLOCATE cur;
6. áá áááááĄ, áá˘ááá ááá xsd áĄáĽááááá áááĄááá á¨ááááááá ááááá§ááááááĄááááĄ:
-- ĐŃĐłŃŃСка ŃŃ
оП
-- ĐĐąŃĐ°ŃиŃĐľ вниПанио, ĐżŃŃŃ Đş вŃĐłŃŃМаоПŃĐź ŃŃ
оПаП - СаŃ
Đ°ŃдкОМон!
Set @sql = (
Select N'; exec xp_cmdshell ''bcp "Select [x] from [FIAS2].[dbo].[_FIAS_SCHEMAS] where [table ââ not found /]
= ''''' + a.[table ââ not found /]
+ '''''" queryout "c:filesFIAS' + a.[table ââ not found /]
+ '.xsd" -S . -T -w'''
from dbo.[_FIAS_SCHEMAS] a
for xml path(N''), type
).value(N'.', N'nvarchar(max)')
exec (@sql)
á§áááá! :-)))
áἠáá áᥠááááá ááááŽáááá, á ááááá᪠áĽáááᥠáŞáŽá áááááĄ, ááá ááŚáŹáá áááááááĄ, áŞáááᥠáĄáĽááááᥠáá áááááááááᥠááá áááĄááá:
USE [FIAS2]
go
if OBJECT_ID('dbo.[_FIAS]') is not null
drop table dbo.[_FIAS]
go
if OBJECT_ID('dbo._FIAS_SCHEMAS') is not null
drop table dbo.[_FIAS_SCHEMAS]
go
Declare @schema sysname = N'dbo'
Declare @sql nvarchar(max)
Create table dbo.[_FIAS_SCHEMAS] (x xml, [table ââ not found /]
sysname)
insert into dbo.[_FIAS_SCHEMAS] (x, [table ââ not found /]
)
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ACTSTAT' [table ââ not found /]
FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ACTSTAT_2_250_08_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ADDROBJ' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ADDROBJ_2_250_01_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_CENTERST' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_CENTERST_2_250_10_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_CURENTST' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_CURENTST_2_250_07_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_ADDROBJ' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_ADDROBJ_2_250_15_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_HOUSEINT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_HOUSEINT_2_250_17_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_HOUSE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_HOUSE_2_250_16_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_LANDMARK' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_LANDMARK_2_250_18_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_NORMDOC' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_NORMDOC_2_250_19_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ESTSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ESTSTAT_2_250_13_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_FLATTYPE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_FLATTYPE_2_250_23_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_HOUSEINT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_HOUSEINT_2_250_03_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_HOUSE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_HOUSE_2_250_02_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_HSTSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_HSTSTAT_2_250_12_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_INTVSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_INTVSTAT_2_250_11_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_LANDMARK' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_LANDMARK_2_250_04_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_NDOCTYPE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_NDOCTYPE_2_250_20_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_NORMDOC' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_NORMDOC_2_250_05_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_OPERSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_OPERSTAT_2_250_09_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ROOMTYPE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ROOMTYPE_2_250_24_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ROOM' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ROOM_2_250_21_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_SOCRBASE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_SOCRBASE_2_250_06_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_STEAD' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_STEAD_2_250_22_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_STRSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_STRSTAT_2_250_14_04_01_01.xsd', SINGLE_BLOB) x
;WITH XMLNAMESPACES ('http://www.w3.org/2001/XMLSchema' as xs)
Select a.[table ââ not found /]
,tbl.[root_name]
,tbl.[root_description]
,tbl.[name]
,ROW_NUMBER() over (partition by a.[table ââ not found /]
order by 1/0) N
,tbl.[column]
,tbl.[required]
,tbl.[description]
,tbl.[type]
,tbl.[len]
,Case tbl.[type]
when N'byte' then N'tinyint'
when N'date' then N'date'
when N'int' then N'int'
when N'string' then
Case when tbl.[len] = 36 and (tbl.[column] like N'%ID' or tbl.[column] = N'NORMDOC') then N'uniqueidentifier'
when tbl.[len] is Null then N'nvarchar(max)'
Else N'nvarchar(' + cast(tbl.[len] as nvarchar(4000)) + N')' END
when N'integer' then
Case when tbl.[len] > 9 then N'bigint'
when tbl.[len] <= 4 then N'smallint'
Else N'int'
end
else N'nvarchar(max)'
End [sqltype]
,t.n.query('.') [node]
into dbo.[_FIAS]
from dbo.[_FIAS_SCHEMAS] a
Cross apply a.x.nodes('//xs:attribute') t(n)
Cross apply
(values -- нокОŃĐžŃŃĐľ ĐżĐžĐťŃ Đ¸ŃпОНŃСŃŃŃŃŃ Đ˝ĐľŃкОНŃкО ŃаС, пОŃŃĐžĐźŃ ŃдоНаоП ŃĐ°Đş :)
(
x.value('(xs:schema[1]/xs:element[1]/@name)', 'nvarchar(255)')
,x.value('(xs:schema[1]/xs:element[1]/xs:annotation/xs:documentation[1]/text())[1]', 'nvarchar(4000)')
,x.value('(xs:schema[1]/xs:element[1]/xs:complexType[1]/xs:sequence[1]/xs:element[1]/@name)', 'nvarchar(255)')
,t.n.value('(./@name)[1]', 'nvarchar(255)')
,t.n.value('(./@use)[1]', 'nvarchar(255)')
,Stuff(Coalesce(t.n.value('(./xs:simpleType/xs:restriction/@base)[1]', 'nvarchar(255)'), t.n.value('(./@type)[1]', 'nvarchar(255)')), 1, 3, '')
,Coalesce(t.n.value('(./xs:simpleType/xs:restriction/xs:length/@value)[1]', 'int')
,t.n.value('(./xs:simpleType/xs:restriction/xs:maxLength/@value)[1]', 'int')
,t.n.value('(./xs:simpleType/xs:restriction/xs:totalDigits/@value)[1]', 'int'))
,Replace(
Replace(
Replace(
Replace(
Replace(
Replace(
Replace(
Replace(
Replace(t.n.value('(./xs:annotation/xs:documentation)[1]', 'nvarchar(4000)'), ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
)
) tbl([root_name], [root_description], [name], [column], [required], [type], [len], [description])
-- ĐĐžŃПОŃŃиП на ŃоСŃĐťŃŃĐ°Ń
Select * from dbo.[_FIAS]
-- ХОСдадиП кОд Đ´ĐťŃ ŃĐžĐˇĐ´Đ°Đ˝Đ¸Ń ŃайНиŃ, и СапŃŃŃиП огО
set @sql = (
Select Distinct
N';Create table '
+ Quotename(@schema)
+ N'.'
+ Quotename([table ââ not found /]
)
+ N'('
+ Stuff((Select
N','
+ QUOTENAME(b.[column])
+ N' '
+ b.[sqltype]
+ Case b.[required] when 'required' then N' NOT NULL'
when 'optional' then N' NULL'
End
From dbo.[_FIAS] b
where b.[table ââ not found /]
= a.[table ââ not found /]
Order by N ASC
For xml path(N''), type
).value(N'.', 'nvarchar(max)'), 1, 1, N'')
+ N')'
from dbo.[_FIAS] a
For xml path(N''), type).value(N'.', N'nvarchar(max)')
exec (@sql)
-- ХОСдадиП аннОŃĐ°ŃĐ¸Ń Đş ŃайНиŃĐ°Đź и пОНŃĐź
Set @sql = (
Select N'; exec sp_addextendedproperty @name=''description'', @value=N'''
+ a.[root_description]
+ N''', @level0type =N''Schema'', @level0name = N'''
+ @schema
+ N''', @level1type = N''Table'', @level1name = N'''
+ a.[table ââ not found /]
+ N''''
from (Select distinct [table ââ not found /]
, [root_description] from dbo.[_FIAS]) a
for xml path(N''), type
).value(N'.', N'nvarchar(max)')
exec (@sql)
Set @sql = (
Select N'; exec sp_addextendedproperty @name=''description'', @value=N'''
+ a.[description]
+ N''', @level0type =N''Schema'', @level0name = N'''
+ @schema
+ N''', @level1type = N''Table'', @level1name = N'''
+ a.[table ââ not found /]
+ N''', @level2type = N''Column'', @level2name = N'''
+ a.[column]
+ N''''
from dbo.[_FIAS] a
for xml path(N''), type
).value(N'.', N'nvarchar(max)')
exec (@sql)
-- ĐĐżŃодоНонио ŃŃŃНки на иПпОŃŃиŃŃоПŃŃ ŃŃ
оПŃ
update a
Set x.modify ('declare namespace xs="http://www.w3.org/2001/XMLSchema";
insert <xs:import namespace="http://schemas.microsoft.com/sqlserver/2004/sqltypes" schemaLocation="./sqltypes.xsd" /> as first
into (xs:schema)[1]')
from dbo.[_FIAS_SCHEMAS] a
-- ĐĐżŃодоНонио кОŃновОгО Đ°ŃŃŃийŃŃĐ°
update a
Set x.modify('declare namespace ss="urn:schemas-microsoft-com:mapping-schema";
insert (
attribute ss:is-constant {"1"}
)
into (/xs:schema[1]/xs:element[1])')
from dbo.[_FIAS_SCHEMAS] a
-- ĐĐżŃодоНонио нОдŃ, ŃвНŃŃŃоКŃŃ ŃŃŃОкОК ŃайНиŃŃ Đ¸ ŃвŃСаннОК Ń Đ˝ĐľĐš ŃайНиŃŃ
update a
Set x.modify('declare namespace ss="urn:schemas-microsoft-com:mapping-schema";
insert (
attribute ss:relation {sql:column("a.table")}
)
into (xs:schema[1]/xs:element[1]/xs:complexType[1]/xs:sequence[1]/xs:element[1])')
from dbo.[_FIAS_SCHEMAS] a
-- ĐннОŃĐ°ŃĐ¸Ń ĐżĐžĐťĐľĐš в ŃŃ
оПо
-- Т.Đş. Са 1 ŃаС ПОМнО ПОдиŃиŃиŃОваŃŃ ŃОНŃкО ĐžĐ´Đ˝Ń Đ˝ĐžĐ´Ń - ĐżŃидоŃŃŃ Đ¸ŃпОНŃСОваŃŃ ĐşŃŃŃĐžŃ
Declare @table nvarchar(4000)
Declare @column nvarchar(4000)
Declare cur CURSOR LOCAL FORWARD_ONLY
for
Select [table ââ not found /]
, [column]
from dbo.[_FIAS]
Open cur
FETCH NEXT FROM cur into @table, @column
WHILE @@FETCH_STATUS = 0
BEGIN
update a
Set x.modify('declare namespace ss="urn:schemas-microsoft-com:mapping-schema";
insert (
attribute ss:field {sql:column("t.column")}
,attribute ss:datatype {sql:column("b.sqltype")}
)
into (//xs:attribute[@name = sql:column("b.column")])[1]')
from dbo.[_FIAS_SCHEMAS] a
inner join dbo.[_FIAS] b on a.[table ââ not found /]
= b.[table ââ not found /]
cross apply (Values(QUOTENAME(b.[column]))) t([column])
Where b.[table ââ not found /]
= @table and b.[column] = @column
FETCH NEXT FROM cur into @table, @column
END
CLOSE cur;
DEALLOCATE cur;
-- ĐŃĐłŃŃСка ŃŃ
оП
-- ĐĐąŃĐ°ŃиŃĐľ вниПанио, ĐżŃŃŃ Đş вŃĐłŃŃМаоПŃĐź ŃŃ
оПаП - СаŃ
Đ°ŃдкОМон!
Set @sql = (
Select N'; exec xp_cmdshell ''bcp "Select [x] from [FIAS2].[dbo].[_FIAS_SCHEMAS] where [table ââ not found /]
= ''''' + a.[table ââ not found /]
+ '''''" queryout "c:filesFIAS' + a.[table ââ not found /]
+ '.xsd" -S . -T -w'''
from dbo.[_FIAS_SCHEMAS] a
for xml path(N''), type
).value(N'.', N'nvarchar(max)')
exec (@sql)
ááŽáá á áŠááá ááŽáááá ááááááŁáá xml á¤ááááᥠáŠáá˘ááá áááᥠáá ááŞáááŁá áᥠáááááŤááŽááá á¨ááĄááááááĄá áĄáĽáááá (ááááá á¨ááŁá¤áŁáááá á¤áááááá ááááŽááá e:tmp áĄááĽááŚááááá¨á áá áŠááá ááá˘ááá ááá ááááá ááááá c:filesFIAS-á¨á):
USE FIAS2
GO
Declare @sql nvarchar(max)
if OBJECT_ID('tempdb..#t') is not null
drop table #t
Create table #t ([output] sysname NULL)
insert into #t
exec xp_cmdshell 'dir e:tmp /B'
;With load_data as
(
Select
'_' + t.x.value('(a[2])', 'nvarchar(255)') [table ââ not found /]
,t.x.value('(a[3])', 'date') [fias_date]
,t.x.value('(a[4])', 'uniqueidentifier') [fias_guid]
,a.[output] [file_name]
from #t a
cross apply (VALUES(Cast('<a>' + Replace(Replace(Replace(Replace(a.[output],'DEL_', 'DEL$'), '_', '</a><a>'), '.', '</a><a>'), '$', '_') + '</a>' as xml))) t(x)
Where [output] like 'AS[_]%.xml'
)
Select @sql =
(Select
N';exec [dbo].[spXMLBulkLoad] ''e:tmp' + a.[file_name] + ''', ''c:filesFIAS' + b.[table ââ not found /]
+ '.xsd'', ''FIAS2'', ''e:tmperr.xml'''
from load_data a
inner join [dbo].[_FIAS_SCHEMAS] b on a.[table ââ not found /]
= b.[table ââ not found /]
For xml path(''), type).value(N'.', N'nvarchar(max)')
Exec (@sql)
á¤á¤á¤...
ááĄá, ááŽáá áĄááááááá á§ááááá¤áá á áááĄá áŁááá.
ááŁááŞá, áᥠáá áᥠááĄ, á á᪠ááááá ááááŽá áá, áŤááá á¤ááĄá áááááááá!
áᥠá§ááááá¤áá á áŁáá áááá ááŁá¨áááᥠá§áááááá ááááŁá á áááá!
áŞáŽá ááááááĄá áá ááááá áááááᥠá¨ááĽááááá áá ááĄááŁáá áá, á á ááĽáá áŁááá. áá á á᪠á¨áááŽááá ááá˘ááá ááááĄ.
áĄáá˘ááĄá˘á ááá áááá¨á áŠáááá˘ááá áááá ááááĽááᥠáŹáááá§áááá 5 áĄáááá (ááĄá!!!). áá áᥠáá áᥠáŞáŽá áááᥠáááááĽáĄáá áááᥠááá áá¨á.
áááááá ááŁááá, I/O áĄááĄá˘áááᥠááá˘ááá ááá áá§á 3 áá/áŹá áááááá áá ááááá§áááááŁáá áá§á ááŽáááá á áááááááá ááá ááá.
áááĄáááá ááᥠáááááĽá˘áááᥠáŠáá˘ááá ááá áááŽáá áá ááŁááá˘áᥠ3 ááááĄá áŠááááŹáá áᥠáĄááŠáĽáá áá áŹááá¨á, áĄááŽááááᥠááá˘ááá ááá - áá ááŁááá˘áᥠ8 ááááĄá áŹááá¨á. áá áá áá áŹáŁááá, ááĄááá 60 áááááááá.
ááá ááá˘á§áá, á ááĄááá áá áᥠáááááá¨áá áááŁáá ááĄ; áá áááá᪠áááááŹááᥠááááᥠáá, á áááá ᪠áŠáááĄ, VM ááá áááá˘á áááᥠá¨ááĄáŹáááá.
áááŽááá áááááááááĄáŹáááá, á áá ááá˘ááá ááá áŽáááá áá áááá. áá ááŽáááá áááᥠá¨ááááá áŁááá á¨áááĽáááᥠááááĄá˘áá áŁáá áááááĽáĄááá ááááááŁáá áááá AOID-ááĄááááĄ.
áááá˘áá á áá ááĄááá GUID-ááá áá ááá, áŁááŻááááĄáá ááĄá áááááááá, á ááááá áᣠáŠáá˘ááá áááááá á¨ááĽáááá ááááĄá˘áá áŁá áááááĽáĄáááĄ, áááááááááá ááĽáááá áŞáŽá ááá á¤á áááááá˘áá áááŁáá ááááŽáááááá 50 áá ááŞááá˘áá, áá ááááááá. ááá áá, áááááĽáĄáááᥠá¨ááĽááá áĄáŻááᥠáŠáá˘ááá áááᥠá¨áááááááŞ, á ááááá áááááĽáĄááá¨á áŠááĄáá ááááá áŁá¤á á ááááááᥠááá˘ááá ááááĄ.
áááá˘áá áŠááá áŞáŽá áááᥠáĄááŽááááá ááŹá§ááá áĽáááá áŽáááá (_). ááá ááŁááááááá, á áá áŻáá áŠááá˘ááá ááááá áááááŞááááᥠáááá¨á, á¨ááááá áŽááááŽáá á¨áááĽááááá áĄáááááá áŞáŽá áááááᥠáááááĽáĄááᥠáá á¨ááááá áŠáŁááá ááááááááááá Alter áŞáŽá áááᥠá¨ááŞááááĄ.
ááĄááá á§áŁá áááŚááá ááááĽáŞááá áá á ááááá ááá˘áááááŁá áááááŞáááá á˘ááááᥠFIAS áŞáŽá áááááᥠáááááááĄááááĄ.
ááááááááá, int-áᥠááááá§ááááá, áĄááá᪠tinyint áĄááááá ááĄáá, áá nvarchar áááááá¨á, áĄááá᪠ááŽáááá á ááŞáŽáááá áááá¨ááááááááá áŁááá áá§áᥠá¨ááááŽáŁáá, á áááá ááŞáá á ááááááᥠáááá áá OKATO.
ááĄá á áá, ááááá ááááá¨á:-(.
ááŁááŞá, áá áá¤áá á ááá¨ááá áŽááᥠááá˘ááááááŞáááááᥠáŞáŽá ááááĄ, [dbo].[_FIAS] á¨ááĽáááᥠá¨ááááá, áŽáááá áŠáááŽáá áá áá áááááŽáá áŞááááá á˘ááŁááááá áá ááŽáááá áááᥠá¨ááááá á¨ááĽáááá áŠáá˘ááá áááᥠááŽááá áĄáĽááááá á¨ááĄáŹáá áááŁáá ááá˘ááááááŞáááááᥠáĄáá¤áŁáŤááááá.
ááĄá, áᣠáááá᪠ááá áááááááĄáŁá¤áááááá ááĄááá áááá ááá˘ááá ááááĄááá, ááááá áááááŹááá áááŁáá áŁáááá dbf-ááá áŠáá˘ááá áááᥠááá áááá˘áĄ áá ááááᥠáááááá áŠááá á¨ááŞáááááá ááá˘áá á dbf-ááá¨á. áá áááŹáá á ááááá áá áá áĄá˘áá˘áá.
dbf 8 áŤáá¤á¨á ááá ááááŁá áá áá˘ááá áááá 1 áĄáááá¨á áá áá á ááááá¨á áá ááááŽáááááá áá áá áĄáááá ááááŽáá áŻá áŞáááááŁáá áŞáŽá áááááᥠáĄáááááá áŞáŽá ááááá¨á á¨áá áŹá§áá áá ááááá áááááĽáĄáááᥠá¨ááĽááá.
... ááá áá, áá, áááááĄ, áááááŁá¨ááá áŽááááá LJJ-ááá... áŁá°... áá¤ááá ááá áá ááááᥠáááááááá ááá ááááŁá á áááááŞáááá ááááᥠáááááááŞáá áá áŠáá˘ááá ááá áááááŞááááá, á áááá ᪠á§áááá ááá ááááŁá á áááááááá, SSIS-áᥠáĄáá¨áŁáááááá.
áááá áá áᥠááááá áá áá ááááááá.
â
áááŁáááá:
â
áŤááŚáááá áá ááá áĄáŁá ááá áŠááá áá áá áᥠ:)
áŹá§áá á: www.habr.com