/****** Object:  Table [dbo].[epu_bank_impf]    Script Date: 2020. 07. 29. 14:06:51 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[epu_bank_impf](
	[kulcs] [dbo].[kulcs] IDENTITY(1,1) NOT NULL,
	[kdatum] [dbo].[datum] NOT NULL,
	[vdatum] [dbo].[datum] NOT NULL,
	[rogzitette] [dbo].[kicsoda] NOT NULL,
	[rogzitve] [dbo].[datum_ora] NOT NULL,
 CONSTRAINT [PK_epu_bank_import] PRIMARY KEY CLUSTERED 
(
	[kulcs] 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

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[epu_bank_impf]  WITH CHECK ADD  CONSTRAINT [FK_epu_bank_import_belepes] FOREIGN KEY([rogzitette])
REFERENCES [dbo].[belepes] ([ROVIDNEV])
GO

ALTER TABLE [dbo].[epu_bank_impf] CHECK CONSTRAINT [FK_epu_bank_import_belepes]
GO



CREATE TABLE [dbo].[epu_bank_impt](
	[kulcs] [dbo].[kulcs] NOT NULL,
	[forgalom_tip] [varchar](50) NOT NULL,
	[erteknap] [dbo].[datum] NOT NULL,
	[osszeg] [dbo].[egyseg_ar] NOT NULL,
	[szamlaszam] [varchar](26) NOT NULL,
	[vevo_nev] [varchar](80) NOT NULL,
	[vevo_kod] [dbo].[kulcs] NOT NULL,
	[kozlemeny] [varchar](255) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[epu_bank_impt]  WITH CHECK ADD  CONSTRAINT [FK_epu_bank_impt_epu_bank_impf] FOREIGN KEY([kulcs])
REFERENCES [dbo].[epu_bank_impf] ([kulcs])
GO

ALTER TABLE [dbo].[epu_bank_impt] CHECK CONSTRAINT [FK_epu_bank_impt_epu_bank_impf]
GO

ALTER TABLE [dbo].[epu_bank_impt]  WITH CHECK ADD  CONSTRAINT [FK_epu_bank_impt_vevok] FOREIGN KEY([vevo_kod])
REFERENCES [dbo].[vevok] ([VEVO_KOD])
GO

ALTER TABLE [dbo].[epu_bank_impt] CHECK CONSTRAINT [FK_epu_bank_impt_vevok]
GO



insert into verzio values('upg','Ver. 2.66', dbo.mygetdatetime())
go