CREATE TABLE [dbo].[keszlet](
	[raktar_kod] [nvarchar](4) NOT NULL,
	[termek_kod] [nvarchar](20) NOT NULL,
	[mennyiseg] [float] NOT NULL,
 CONSTRAINT [PK_keszlet] PRIMARY KEY CLUSTERED
(
	[raktar_kod] ASC,
	[termek_kod] 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
/****** Object:  Table [dbo].[mennyisegi_egysegek]    Script Date: 2017.04.02. 18:56:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mozgasnemek](
	[mozgasnem_kod] [nvarchar](20) NOT NULL,
	[mozgasnem_nev] [nvarchar](60) NOT NULL,
	[mozgasnem_elojel] [smallint] NOT NULL,
	[inaktiv] [bit] NOT NULL,
 CONSTRAINT [PK_mozgasnemek] PRIMARY KEY CLUSTERED
(
	[mozgasnem_kod] 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
/****** Object:  Table [dbo].[partner_kontakt_szemelyek]    Script Date: 2017.04.02. 18:56:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[partner_kontakt_szemelyek](
	[partnerkod] [nvarchar](20) NOT NULL,
	[sorszam] [int] NOT NULL,
	[megszolitas] [nvarchar](50) NOT NULL,
	[titulus] [nvarchar](50) NOT NULL,
	[telefon] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_partner_kontak_szemelyek] PRIMARY KEY CLUSTERED
(
	[partnerkod] ASC,
	[sorszam] 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
/****** Object:  Table [dbo].[partner_megjegyzesek]    Script Date: 2017.04.02. 18:56:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[partner_megjegyzesek](
	[partner_kod] [nvarchar](20) NOT NULL,
	[bejegyzes_kelte] [datetime] NOT NULL,
	[leiras] [nvarchar](500) NOT NULL,
 CONSTRAINT [PK_partner_megjegyzesek] PRIMARY KEY CLUSTERED
(
	[partner_kod] ASC,
	[bejegyzes_kelte] 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
/****** Object:  Table [dbo].[partnerek]    Script Date: 2017.04.02. 18:56:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[partnerek](
	[partner_kod] [nvarchar](20) NOT NULL,
	[partner_nev] [nvarchar](200) NOT NULL,
	[partner_irsz] [nvarchar](10) NOT NULL,
	[partner_varos] [nvarchar](60) NOT NULL,
	[partner_cim] [nvarchar](200) NOT NULL,
	[inaktiv] [bit] NOT NULL,
 CONSTRAINT [PK_partnerek] PRIMARY KEY CLUSTERED
(
	[partner_kod] 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
/****** Object:  Table [dbo].[raktarak]    Script Date: 2017.04.02. 18:56:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[raktarak](
	[raktar_kod] [nvarchar](4) NOT NULL,
	[raktar_megnevezes] [nvarchar](60) NOT NULL,
 CONSTRAINT [PK_raktarak] PRIMARY KEY CLUSTERED
(
	[raktar_kod] 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
/****** Object:  Table [dbo].[rm_fej]    Script Date: 2017.04.02. 18:56:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[rm_fej](
	[iktatoszam] [bigint] IDENTITY(1,1) NOT NULL,
	[partner_kod] [nvarchar](20) NOT NULL,
	[mozgas_datum] [date] NOT NULL,
	[mozgasnem] [nvarchar](20) NOT NULL,
	[raktarkod] [nvarchar](4) NOT NULL,
	[rogziteve] [datetime] NOT NULL,
	[allapot] [nvarchar](2) NOT NULL,
 CONSTRAINT [PK_rm_fej] PRIMARY KEY CLUSTERED
(
	[iktatoszam] 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
/****** Object:  Table [dbo].[rm_tetel]    Script Date: 2017.04.02. 18:56:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[rm_tetel](
	[iktatoszam] [bigint] NOT NULL,
	[sorszam] [int] NOT NULL,
	[termek_kod] [nvarchar](20) NOT NULL,
	[mennyiseg] [float] NOT NULL,
	[ar] [float] NOT NULL DEFAULT ((0)),
	[Ertek]  AS ([ar]*[mennyiseg]),
 CONSTRAINT [PK_rm_tetel] PRIMARY KEY CLUSTERED
(
	[iktatoszam] ASC,
	[sorszam] 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
/****** Object:  Table [dbo].[termekek_arai]    Script Date: 2017.04.02. 18:56:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[termekek_arai](
	[termek_kod] [nvarchar](20) NOT NULL,
	[ervenyes] [date] NOT NULL,
	[ar] [float] NOT NULL,
 CONSTRAINT [PK_termekek_arai] PRIMARY KEY CLUSTERED
(
	[termek_kod] ASC,
	[ervenyes] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]