USE [TryNFeOnline]
GO

CREATE TABLE [dbo].[NFExportacao]
(
	[id] [int] IDENTITY (1,1) NOT NULL,
	[idNFProduto] [int] NOT NULL,
	[nDraw] [varchar] (20) COLLATE Latin1_General_CI_AS NULL,
	[numeroRegistroExportacao] [varchar] (20) COLLATE Latin1_General_CI_AS NULL,
	[chNFe] [varchar] (50) COLLATE Latin1_General_CI_AS NULL,
	[qExport] [decimal] (18,4) NULL,
	CONSTRAINT [PK_NFExportacao] PRIMARY KEY CLUSTERED
	(
		[id] ASC
	) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY  = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[NFExportacao] ADD CONSTRAINT [FK_NFExportacao_NFProduto] FOREIGN KEY
	(
		[idNFProduto]
	)
	REFERENCES [dbo].[NFProduto]
	(
		[id]
	)
GO
INSERT INTO VERSAO(VERSAO, VERSAOATUALIZACAO, DATAATUALIZACAO) VALUES(415, 673, GETDATE());