/****** Object:  Table [dbo].[foglalasok]    Script Date: 03/03/2010 17:11:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[foglalasok](
	[kulcs] [dbo].[kulcs] IDENTITY(1,1) NOT NULL,
	[prioritas] [bigint] NOT NULL,
	[cikk_szam] [dbo].[cikk_szam] NOT NULL,
	[edarab] [dbo].[mennyiseg] NOT NULL,
	[darab] [dbo].[mennyiseg] NOT NULL,
	[vevo] [dbo].[kulcs] NOT NULL,
	[raktar_kod] [dbo].[kulcs] NOT NULL,
	[foglalva] [dbo].[datum_ora] NOT NULL,
	[foglalta] [dbo].[kicsoda] NOT NULL,
	[meddig] [dbo].[datum] NOT NULL,
	[prior_modositotta] [dbo].[kicsoda] NOT NULL,
	[prior_modositva] [dbo].[datum_ora] NOT NULL,
 CONSTRAINT [PK_foglalasok] 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].[foglalasok]  WITH CHECK ADD  CONSTRAINT [FK_foglalasok_belepes] FOREIGN KEY([foglalta])
REFERENCES [dbo].[belepes] ([ROVIDNEV])
GO
ALTER TABLE [dbo].[foglalasok] CHECK CONSTRAINT [FK_foglalasok_belepes]
GO
ALTER TABLE [dbo].[foglalasok]  WITH CHECK ADD  CONSTRAINT [FK_foglalasok_cikkek] FOREIGN KEY([cikk_szam])
REFERENCES [dbo].[cikkek] ([CIKK_SZAM])
GO
ALTER TABLE [dbo].[foglalasok] CHECK CONSTRAINT [FK_foglalasok_cikkek]
GO
ALTER TABLE [dbo].[foglalasok]  WITH CHECK ADD  CONSTRAINT [FK_foglalasok_vevok] FOREIGN KEY([vevo])
REFERENCES [dbo].[vevok] ([VEVO_KOD])
GO
ALTER TABLE [dbo].[foglalasok] CHECK CONSTRAINT [FK_foglalasok_vevok]
go