/****** Object:  Table [dbo].[Emitente]    Script Date: 02/27/2014 09:10:53 ******/਀匀䔀吀 䄀一匀䤀开一唀䰀䰀匀 伀一 
GO਀匀䔀吀 儀唀伀吀䔀䐀开䤀䐀䔀一吀䤀䘀䤀䔀刀 伀一 
GO਀䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀䔀洀椀琀攀渀琀攀崀⠀ 
	[IdEmitente] [int] IDENTITY(1,1) NOT NULL,਀ऀ嬀嘀攀爀猀愀漀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰ 
	[RazaoSocial] [nvarchar](100) NOT NULL,਀ऀ嬀䌀一倀䨀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㄀㐀⤀ 一伀吀 一唀䰀䰀Ⰰ 
	[VersaoSchema] [int] NOT NULL,਀ऀ嬀䔀猀琀愀搀漀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㈀㔀㔀⤀ 一伀吀 一唀䰀䰀Ⰰ 
	[TipoSistema] [smallint] NULL,਀ऀ嬀䤀渀猀挀爀椀挀愀漀䴀甀渀椀挀椀瀀愀氀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㈀㔀⤀ 一唀䰀䰀Ⰰ 
PRIMARY KEY CLUSTERED ਀⠀ 
	[IdEmitente] ASC਀⤀圀䤀吀䠀 ⠀倀䄀䐀开䤀一䐀䔀堀  㴀 伀䘀䘀Ⰰ 匀吀䄀吀䤀匀吀䤀䌀匀开一伀刀䔀䌀伀䴀倀唀吀䔀  㴀 伀䘀䘀Ⰰ 䤀䜀一伀刀䔀开䐀唀倀开䬀䔀夀 㴀 伀䘀䘀Ⰰ 䄀䰀䰀伀圀开刀伀圀开䰀伀䌀䬀匀  㴀 伀一Ⰰ 䄀䰀䰀伀圀开倀䄀䜀䔀开䰀伀䌀䬀匀  㴀 伀一⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀 
) ON [PRIMARY]਀䜀伀 
/****** Object:  Table [dbo].[LoteNFSe]    Script Date: 02/27/2014 09:10:53 ******/਀匀䔀吀 䄀一匀䤀开一唀䰀䰀匀 伀一 
GO਀匀䔀吀 儀唀伀吀䔀䐀开䤀䐀䔀一吀䤀䘀䤀䔀刀 伀一 
GO਀䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀䰀漀琀攀一䘀匀攀崀⠀ 
	[IdLote] [int] IDENTITY(1,1) NOT NULL,਀ऀ嬀嘀攀爀猀愀漀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰ 
	[NumeroRecibo] [nvarchar](50) NOT NULL,਀ऀ嬀匀攀焀甀攀渀挀椀愀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰ 
	[StatusLote] [int] NOT NULL,਀ऀ嬀䤀搀䌀攀爀琀椀昀椀挀愀搀漀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰ 
	[IdEmitente] [int] NOT NULL,਀ऀ嬀䤀搀圀攀戀匀攀爀瘀椀挀攀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰ 
	[XmlLoteGerado] [ntext] NULL,਀倀刀䤀䴀䄀刀夀 䬀䔀夀 䌀䰀唀匀吀䔀刀䔀䐀  
(਀ऀ嬀䤀搀䰀漀琀攀崀 䄀匀䌀 
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀 吀䔀堀吀䤀䴀䄀䜀䔀开伀一 嬀倀刀䤀䴀䄀刀夀崀 
GO਀⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  吀愀戀氀攀 嬀搀戀漀崀⸀嬀圀攀戀匀攀爀瘀椀挀攀一䘀匀攀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㈀⼀㈀㜀⼀㈀　㄀㐀 　㤀㨀㄀　㨀㔀㌀ ⨀⨀⨀⨀⨀⨀⼀ 
SET ANSI_NULLS ON਀䜀伀 
SET QUOTED_IDENTIFIER ON਀䜀伀 
CREATE TABLE [dbo].[WebServiceNFSe](਀ऀ嬀䤀搀圀攀戀匀攀爀瘀椀挀攀崀 嬀椀渀琀崀 䤀䐀䔀一吀䤀吀夀⠀㄀Ⰰ㄀⤀ 一伀吀 一唀䰀䰀Ⰰ 
	[Versao] [int] NOT NULL,਀ऀ嬀吀椀瀀漀匀椀猀琀攀洀愀崀 嬀猀洀愀氀氀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰ 
	[URL] [nvarchar](200) NOT NULL,਀ऀ嬀吀椀瀀漀䄀洀戀椀攀渀琀攀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰ 
	[TipoWebService] [int] NOT NULL,਀倀刀䤀䴀䄀刀夀 䬀䔀夀 䌀䰀唀匀吀䔀刀䔀䐀  
(਀ऀ嬀䤀搀圀攀戀匀攀爀瘀椀挀攀崀 䄀匀䌀 
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀 
GO਀⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  吀愀戀氀攀 嬀搀戀漀崀⸀嬀圀攀戀匀攀爀瘀椀挀攀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㈀⼀㈀㜀⼀㈀　㄀㐀 　㤀㨀㄀　㨀㔀㌀ ⨀⨀⨀⨀⨀⨀⼀ 
SET ANSI_NULLS ON਀䜀伀 
SET QUOTED_IDENTIFIER ON਀䜀伀 
CREATE TABLE [dbo].[WebService](਀ऀ嬀䤀搀圀攀戀匀攀爀瘀椀挀攀崀 嬀椀渀琀崀 䤀䐀䔀一吀䤀吀夀⠀㄀Ⰰ㄀⤀ 一伀吀 一唀䰀䰀Ⰰ 
	[Versao] [int] NOT NULL,਀ऀ嬀䔀猀琀愀搀漀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㈀⤀ 一伀吀 一唀䰀䰀Ⰰ 
	[URL] [nvarchar](200) NOT NULL,਀ऀ嬀吀椀瀀漀䄀洀戀椀攀渀琀攀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰ 
	[TipoWebService] [int] NOT NULL,਀倀刀䤀䴀䄀刀夀 䬀䔀夀 䌀䰀唀匀吀䔀刀䔀䐀  
(਀ऀ嬀䤀搀圀攀戀匀攀爀瘀椀挀攀崀 䄀匀䌀 
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀 
GO਀⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  吀愀戀氀攀 嬀搀戀漀崀⸀嬀䌀攀爀琀椀昀椀挀愀搀漀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㈀⼀㈀㜀⼀㈀　㄀㐀 　㤀㨀㄀　㨀㔀㌀ ⨀⨀⨀⨀⨀⨀⼀ 
SET ANSI_NULLS ON਀䜀伀 
SET QUOTED_IDENTIFIER ON਀䜀伀 
CREATE TABLE [dbo].[Certificado](਀ऀ嬀䤀搀䌀攀爀琀椀昀椀挀愀搀漀崀 嬀椀渀琀崀 䤀䐀䔀一吀䤀吀夀⠀㄀Ⰰ㄀⤀ 一伀吀 一唀䰀䰀Ⰰ 
	[Versao] [int] NOT NULL,਀ऀ嬀一漀洀攀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㄀　　⤀ 一伀吀 一唀䰀䰀Ⰰ 
	[IdEmitente] [int] NULL,਀ऀ嬀吀椀瀀漀䰀漀挀愀氀崀 嬀猀洀愀氀氀椀渀琀崀 一唀䰀䰀Ⰰ 
PRIMARY KEY CLUSTERED ਀⠀ 
	[IdCertificado] ASC਀⤀圀䤀吀䠀 ⠀倀䄀䐀开䤀一䐀䔀堀  㴀 伀䘀䘀Ⰰ 匀吀䄀吀䤀匀吀䤀䌀匀开一伀刀䔀䌀伀䴀倀唀吀䔀  㴀 伀䘀䘀Ⰰ 䤀䜀一伀刀䔀开䐀唀倀开䬀䔀夀 㴀 伀䘀䘀Ⰰ 䄀䰀䰀伀圀开刀伀圀开䰀伀䌀䬀匀  㴀 伀一Ⰰ 䄀䰀䰀伀圀开倀䄀䜀䔀开䰀伀䌀䬀匀  㴀 伀一⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀 
) ON [PRIMARY]਀䜀伀 
/****** Object:  Table [dbo].[NotaFiscalServico]    Script Date: 02/27/2014 09:10:53 ******/਀匀䔀吀 䄀一匀䤀开一唀䰀䰀匀 伀一 
GO਀匀䔀吀 儀唀伀吀䔀䐀开䤀䐀䔀一吀䤀䘀䤀䔀刀 伀一 
GO਀䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀一漀琀愀䘀椀猀挀愀氀匀攀爀瘀椀挀漀崀⠀ 
	[IdNotaFiscalServico] [int] IDENTITY(1,1) NOT NULL,਀ऀ嬀嘀攀爀猀愀漀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰ 
	[Serie] [nvarchar](3) NOT NULL,਀ऀ嬀匀琀愀琀甀猀一漀琀愀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰ 
	[IdLote] [int] NULL,਀ऀ嬀一漀琀愀堀洀氀䄀甀琀漀爀椀稀愀搀漀崀 嬀渀琀攀砀琀崀 一唀䰀䰀Ⰰ 
	[NotaXml] [ntext] NULL,਀ऀ嬀一甀洀攀爀漀倀爀漀琀漀挀漀氀漀崀 嬀戀椀最椀渀琀崀 一唀䰀䰀Ⰰ 
	[NumeroRps] [int] NULL,਀ऀ嬀一甀洀攀爀漀一漀琀愀崀 嬀椀渀琀崀 一唀䰀䰀Ⰰ 
 CONSTRAINT [PK__NotaFiscalServico] PRIMARY KEY CLUSTERED ਀⠀ 
	[IdNotaFiscalServico] ASC਀⤀圀䤀吀䠀 ⠀倀䄀䐀开䤀一䐀䔀堀  㴀 伀䘀䘀Ⰰ 匀吀䄀吀䤀匀吀䤀䌀匀开一伀刀䔀䌀伀䴀倀唀吀䔀  㴀 伀䘀䘀Ⰰ 䤀䜀一伀刀䔀开䐀唀倀开䬀䔀夀 㴀 伀䘀䘀Ⰰ 䄀䰀䰀伀圀开刀伀圀开䰀伀䌀䬀匀  㴀 伀一Ⰰ 䄀䰀䰀伀圀开倀䄀䜀䔀开䰀伀䌀䬀匀  㴀 伀一⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]਀䜀伀 
/****** Object:  Table [dbo].[Lote]    Script Date: 02/27/2014 09:10:53 ******/਀匀䔀吀 䄀一匀䤀开一唀䰀䰀匀 伀一 
GO਀匀䔀吀 儀唀伀吀䔀䐀开䤀䐀䔀一吀䤀䘀䤀䔀刀 伀一 
GO਀䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀䰀漀琀攀崀⠀ 
	[IdLote] [int] IDENTITY(1,1) NOT NULL,਀ऀ嬀嘀攀爀猀愀漀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰ 
	[NumeroRecebido] [nvarchar](50) NOT NULL,਀ऀ嬀匀攀焀甀攀渀挀椀愀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰ 
	[StatusLote] [int] NOT NULL,਀ऀ嬀䤀搀䌀攀爀琀椀昀椀挀愀搀漀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰ 
	[IdEmitente] [int] NOT NULL,਀ऀ嬀䤀搀圀攀戀匀攀爀瘀椀挀攀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰ 
	[XmlLoteGerado] [ntext] NULL,਀倀刀䤀䴀䄀刀夀 䬀䔀夀 䌀䰀唀匀吀䔀刀䔀䐀  
(਀ऀ嬀䤀搀䰀漀琀攀崀 䄀匀䌀 
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀 吀䔀堀吀䤀䴀䄀䜀䔀开伀一 嬀倀刀䤀䴀䄀刀夀崀 
GO਀⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  吀愀戀氀攀 嬀搀戀漀崀⸀嬀一漀琀愀䘀椀猀挀愀氀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㈀⼀㈀㜀⼀㈀　㄀㐀 　㤀㨀㄀　㨀㔀㌀ ⨀⨀⨀⨀⨀⨀⼀ 
SET ANSI_NULLS ON਀䜀伀 
SET QUOTED_IDENTIFIER ON਀䜀伀 
CREATE TABLE [dbo].[NotaFiscal](਀ऀ嬀䤀搀一漀琀愀䘀椀猀挀愀氀崀 嬀椀渀琀崀 䤀䐀䔀一吀䤀吀夀⠀㄀Ⰰ㄀⤀ 一伀吀 一唀䰀䰀Ⰰ 
	[Versao] [int] NOT NULL,਀ऀ嬀䌀栀愀瘀攀䄀挀攀猀猀漀崀 嬀渀瘀愀爀挀栀愀爀崀⠀㔀　⤀ 一伀吀 一唀䰀䰀Ⰰ 
	[CodigoNumerico] [int] NOT NULL,਀ऀ嬀一甀洀攀爀漀䐀漀挀甀洀攀渀琀漀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰ 
	[Serie] [nvarchar](3) NOT NULL,਀ऀ嬀匀琀愀琀甀猀一漀琀愀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰ 
	[IdLote] [int] NULL,਀ऀ嬀䐀漀挀䐀椀猀琀爀椀戀甀椀挀愀漀一漀琀愀崀 嬀渀琀攀砀琀崀 一唀䰀䰀Ⰰ 
	[NotaXml] [ntext] NULL,਀ऀ嬀一甀洀攀爀漀倀爀漀琀漀挀漀氀漀崀 嬀戀椀最椀渀琀崀 一唀䰀䰀Ⰰ 
	[DocCancelamentoNota] [ntext] NULL,਀ 䌀伀一匀吀刀䄀䤀一吀 嬀倀䬀开开一漀琀愀䘀椀猀挀愀氀开开㄀㌀㠀㜀䔀㄀㤀㜀崀 倀刀䤀䴀䄀刀夀 䬀䔀夀 䌀䰀唀匀吀䔀刀䔀䐀  
(਀ऀ嬀䤀搀一漀琀愀䘀椀猀挀愀氀崀 䄀匀䌀 
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀 吀䔀堀吀䤀䴀䄀䜀䔀开伀一 嬀倀刀䤀䴀䄀刀夀崀 
GO਀⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  吀愀戀氀攀 嬀搀戀漀崀⸀嬀䐀漀眀渀氀漀愀搀一漀琀愀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㈀⼀㈀㜀⼀㈀　㄀㐀 　㤀㨀㄀　㨀㔀㌀ ⨀⨀⨀⨀⨀⨀⼀ 
SET ANSI_NULLS ON਀䜀伀 
SET QUOTED_IDENTIFIER ON਀䜀伀 
SET ANSI_PADDING ON਀䜀伀 
CREATE TABLE [dbo].[DownloadNota](਀ऀ嬀䤀搀䐀漀眀渀氀漀愀搀一漀琀愀崀 嬀椀渀琀崀 䤀䐀䔀一吀䤀吀夀⠀㄀Ⰰ㄀⤀ 一伀吀 一唀䰀䰀Ⰰ 
	[DataHora] [datetime] NOT NULL,਀ऀ嬀䤀瀀崀 嬀瘀愀爀挀栀愀爀崀⠀㔀　⤀ 一伀吀 一唀䰀䰀Ⰰ 
	[EnderecoWeb] [varchar](100) NOT NULL,਀ऀ嬀䤀搀一漀琀愀䘀椀猀挀愀氀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀Ⰰ 
	[Versao] [int] NOT NULL,਀ 䌀伀一匀吀刀䄀䤀一吀 嬀倀䬀开䐀漀眀渀氀漀愀搀一漀琀愀崀 倀刀䤀䴀䄀刀夀 䬀䔀夀 䌀䰀唀匀吀䔀刀䔀䐀  
(਀ऀ嬀䤀搀䐀漀眀渀氀漀愀搀一漀琀愀崀 䄀匀䌀 
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀 
GO਀匀䔀吀 䄀一匀䤀开倀䄀䐀䐀䤀一䜀 伀䘀䘀 
GO਀⼀⨀⨀⨀⨀⨀⨀ 伀戀樀攀挀琀㨀  䐀攀昀愀甀氀琀 嬀䐀䘀开开䌀攀爀琀椀昀椀挀愀开开吀椀瀀漀䰀开开　㔀㄀㤀䌀㘀䄀䘀崀    匀挀爀椀瀀琀 䐀愀琀攀㨀 　㈀⼀㈀㜀⼀㈀　㄀㐀 　㤀㨀㄀　㨀㔀㌀ ⨀⨀⨀⨀⨀⨀⼀ 
ALTER TABLE [dbo].[Certificado] ADD  DEFAULT ((0)) FOR [TipoLocal]਀䜀伀 
/****** Object:  ForeignKey [FK7C23369CFBAB0753]    Script Date: 02/27/2014 09:10:53 ******/਀䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀䌀攀爀琀椀昀椀挀愀搀漀崀  圀䤀吀䠀 䌀䠀䔀䌀䬀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䘀䬀㜀䌀㈀㌀㌀㘀㤀䌀䘀䈀䄀䈀　㜀㔀㌀崀 䘀伀刀䔀䤀䜀一 䬀䔀夀⠀嬀䤀搀䔀洀椀琀攀渀琀攀崀⤀ 
REFERENCES [dbo].[Emitente] ([IdEmitente])਀䜀伀 
ALTER TABLE [dbo].[Certificado] CHECK CONSTRAINT [FK7C23369CFBAB0753]਀䜀伀 
/****** Object:  ForeignKey [FK_LoteNFSe]    Script Date: 02/27/2014 09:10:53 ******/਀䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀一漀琀愀䘀椀猀挀愀氀匀攀爀瘀椀挀漀崀  圀䤀吀䠀 䌀䠀䔀䌀䬀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䘀䬀开䰀漀琀攀一䘀匀攀崀 䘀伀刀䔀䤀䜀一 䬀䔀夀⠀嬀䤀搀䰀漀琀攀崀⤀ 
REFERENCES [dbo].[LoteNFSe] ([IdLote])਀䜀伀 
ALTER TABLE [dbo].[NotaFiscalServico] CHECK CONSTRAINT [FK_LoteNFSe]਀䜀伀 
/****** Object:  ForeignKey [FK4BDC032A1860335]    Script Date: 02/27/2014 09:10:53 ******/਀䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀䰀漀琀攀崀  圀䤀吀䠀 䌀䠀䔀䌀䬀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䘀䬀㐀䈀䐀䌀　㌀㈀䄀㄀㠀㘀　㌀㌀㔀崀 䘀伀刀䔀䤀䜀一 䬀䔀夀⠀嬀䤀搀䌀攀爀琀椀昀椀挀愀搀漀崀⤀ 
REFERENCES [dbo].[Certificado] ([IdCertificado])਀䜀伀 
ALTER TABLE [dbo].[Lote] CHECK CONSTRAINT [FK4BDC032A1860335]਀䜀伀 
/****** Object:  ForeignKey [FK4BDC032A9B27BDFB]    Script Date: 02/27/2014 09:10:53 ******/਀䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀䰀漀琀攀崀  圀䤀吀䠀 䌀䠀䔀䌀䬀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䘀䬀㐀䈀䐀䌀　㌀㈀䄀㤀䈀㈀㜀䈀䐀䘀䈀崀 䘀伀刀䔀䤀䜀一 䬀䔀夀⠀嬀䤀搀圀攀戀匀攀爀瘀椀挀攀崀⤀ 
REFERENCES [dbo].[WebService] ([IdWebService])਀䜀伀 
ALTER TABLE [dbo].[Lote] CHECK CONSTRAINT [FK4BDC032A9B27BDFB]਀䜀伀 
/****** Object:  ForeignKey [FK4BDC032AFBAB0753]    Script Date: 02/27/2014 09:10:53 ******/਀䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀䰀漀琀攀崀  圀䤀吀䠀 䌀䠀䔀䌀䬀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䘀䬀㐀䈀䐀䌀　㌀㈀䄀䘀䈀䄀䈀　㜀㔀㌀崀 䘀伀刀䔀䤀䜀一 䬀䔀夀⠀嬀䤀搀䔀洀椀琀攀渀琀攀崀⤀ 
REFERENCES [dbo].[Emitente] ([IdEmitente])਀䜀伀 
ALTER TABLE [dbo].[Lote] CHECK CONSTRAINT [FK4BDC032AFBAB0753]਀䜀伀 
/****** Object:  ForeignKey [FK883BFB094CAF7531]    Script Date: 02/27/2014 09:10:53 ******/਀䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀一漀琀愀䘀椀猀挀愀氀崀  圀䤀吀䠀 䌀䠀䔀䌀䬀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䘀䬀㠀㠀㌀䈀䘀䈀　㤀㐀䌀䄀䘀㜀㔀㌀㄀崀 䘀伀刀䔀䤀䜀一 䬀䔀夀⠀嬀䤀搀䰀漀琀攀崀⤀ 
REFERENCES [dbo].[Lote] ([IdLote])਀䜀伀 
ALTER TABLE [dbo].[NotaFiscal] CHECK CONSTRAINT [FK883BFB094CAF7531]਀䜀伀 
/****** Object:  ForeignKey [FK_DownloadNota_NotaFiscal]    Script Date: 02/27/2014 09:10:53 ******/਀䄀䰀吀䔀刀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀䐀漀眀渀氀漀愀搀一漀琀愀崀  圀䤀吀䠀 䌀䠀䔀䌀䬀 䄀䐀䐀  䌀伀一匀吀刀䄀䤀一吀 嬀䘀䬀开䐀漀眀渀氀漀愀搀一漀琀愀开一漀琀愀䘀椀猀挀愀氀崀 䘀伀刀䔀䤀䜀一 䬀䔀夀⠀嬀䤀搀一漀琀愀䘀椀猀挀愀氀崀⤀ 
REFERENCES [dbo].[NotaFiscal] ([IdNotaFiscal])਀䜀伀 
ALTER TABLE [dbo].[DownloadNota] CHECK CONSTRAINT [FK_DownloadNota_NotaFiscal]਀䜀伀 
