USE [swinie]
GO
/****** Object:  Table [dbo].[szczepionka]    Script Date: 01/12/2012 17:53:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[szczepionka](
	[ID_szczepionki] [int] IDENTITY(1,1) NOT NULL,
	[Nazwa] [char](100) NULL,
	[Choroba] [char](100) NULL,
PRIMARY KEY CLUSTERED
(
	[ID_szczepionki] 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
/****** Object:  Table [dbo].[smieci]    Script Date: 01/12/2012 17:53:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[smieci](
	[ID_smieci] [int] IDENTITY(1,1) NOT NULL,
	[Gotowa] [varchar](15) NULL,
	[Zdrowa] [varchar](15) NULL,
	[StanowiskoPomiarowe] [int] NULL,
PRIMARY KEY CLUSTERED
(
	[ID_smieci] 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
/****** Object:  Table [dbo].[sektor]    Script Date: 01/12/2012 17:53:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sektor](
	[ID_sektora] [int] IDENTITY(1,1) NOT NULL,
	[NrSektora] [int] NULL,
	[Gatunek] [varchar](25) NULL,
PRIMARY KEY CLUSTERED
(
	[ID_sektora] 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
/****** Object:  Table [dbo].[kontroler]    Script Date: 01/12/2012 17:53:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[kontroler](
	[ID_kontrolera] [int] IDENTITY(1,1) NOT NULL,
	[PESEL] [varchar](11) NULL,
	[ImieNazwisko] [varchar](30) NULL,
	[ID_kierownika] [int] NULL,
	[PrzedzialWiekowy] [varchar](20) NULL,
	[Wyksztalcenie] [varchar](20) NULL,
	[DataWystawienia] [datetime] NULL,
	[DataWygasniecia] [datetime] NULL,
	[Aktualnosc] [varchar](15) NULL,
PRIMARY KEY CLUSTERED
(
	[ID_kontrolera] 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
/****** Object:  Table [dbo].[data]    Script Date: 01/12/2012 17:53:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[data](
	[ID_daty] [int] IDENTITY(1,1) NOT NULL,
	[Data] [datetime] NULL,
	[Rok] [varchar](4) NULL,
	[Miesiac] [varchar](15) NULL,
	[DzienTygodnia] [varchar](15) NULL,
	[KontrolaPodsumowujaca] [varchar](15) NULL,
PRIMARY KEY CLUSTERED
(
	[ID_daty] 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
/****** Object:  Table [dbo].[czas]    Script Date: 01/12/2012 17:53:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[czas](
	[ID_czasu] [int] IDENTITY(1,1) NOT NULL,
	[Godzina] [int] NULL,
	[PoraDnia] [varchar](15) NULL,
PRIMARY KEY CLUSTERED
(
	[ID_czasu] 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
/****** Object:  Table [dbo].[tucznik]    Script Date: 01/12/2012 17:53:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tucznik](
	[ID_tucznika] [int] IDENTITY(1,1) NOT NULL,
	[NrOsobnika] [int] NULL,
	[Klasa] [varchar](25) NULL,
	[Gatunek] [varchar](25) NULL,
PRIMARY KEY CLUSTERED
(
	[ID_tucznika] 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
/****** Object:  Table [dbo].[szczepionka_tucznik]    Script Date: 01/12/2012 17:53:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[szczepionka_tucznik](
	[ID_szczepionki] [int] NULL,
	[ID_tucznika] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[postep_hodowli]    Script Date: 01/12/2012 17:53:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[postep_hodowli](
	[ID_tucznika] [int] NULL,
	[ID_czasu] [int] NULL,
	[ID_daty] [int] NULL,
	[ID_smieci] [int] NULL,
	[ID_kontrolera] [int] NULL,
	[ID_sektora] [int] NULL,
	[Waga] [real] NULL,
	[PoprzedniaWaga] [real] NULL,
	[Dlugosc] [real] NULL,
	[GruboscTkankiTluszczowej] [real] NULL,
	[WysokoscOkaPoledwicy] [real] NULL,
	[NumerKontroli] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[kontroler_sektor]    Script Date: 01/12/2012 17:53:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[kontroler_sektor](
	[ID_kontrolera] [int] NULL,
	[ID_sektora] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  ForeignKey [FK__kontroler__ID_ki__173876EA]    Script Date: 01/12/2012 17:53:27 ******/
ALTER TABLE [dbo].[kontroler]  WITH CHECK ADD FOREIGN KEY([ID_kierownika])
REFERENCES [dbo].[kontroler] ([ID_kontrolera])
GO
/****** Object:  ForeignKey [FK__kontroler__ID_ko__1CF15040]    Script Date: 01/12/2012 17:53:27 ******/
ALTER TABLE [dbo].[kontroler_sektor]  WITH CHECK ADD FOREIGN KEY([ID_kontrolera])
REFERENCES [dbo].[kontroler] ([ID_kontrolera])
GO
/****** Object:  ForeignKey [FK__kontroler__ID_se__1DE57479]    Script Date: 01/12/2012 17:53:27 ******/
ALTER TABLE [dbo].[kontroler_sektor]  WITH CHECK ADD FOREIGN KEY([ID_sektora])
REFERENCES [dbo].[sektor] ([ID_sektora])
GO
/****** Object:  ForeignKey [FK__postep_ho__ID_cz__20C1E124]    Script Date: 01/12/2012 17:53:27 ******/
ALTER TABLE [dbo].[postep_hodowli]  WITH CHECK ADD FOREIGN KEY([ID_czasu])
REFERENCES [dbo].[czas] ([ID_czasu])
GO
/****** Object:  ForeignKey [FK__postep_ho__ID_da__21B6055D]    Script Date: 01/12/2012 17:53:27 ******/
ALTER TABLE [dbo].[postep_hodowli]  WITH CHECK ADD FOREIGN KEY([ID_daty])
REFERENCES [dbo].[data] ([ID_daty])
GO
/****** Object:  ForeignKey [FK__postep_ho__ID_ko__239E4DCF]    Script Date: 01/12/2012 17:53:27 ******/
ALTER TABLE [dbo].[postep_hodowli]  WITH CHECK ADD FOREIGN KEY([ID_kontrolera])
REFERENCES [dbo].[kontroler] ([ID_kontrolera])
GO
/****** Object:  ForeignKey [FK__postep_ho__ID_se__24927208]    Script Date: 01/12/2012 17:53:27 ******/
ALTER TABLE [dbo].[postep_hodowli]  WITH CHECK ADD FOREIGN KEY([ID_sektora])
REFERENCES [dbo].[sektor] ([ID_sektora])
GO
/****** Object:  ForeignKey [FK__postep_ho__ID_sm__22AA2996]    Script Date: 01/12/2012 17:53:27 ******/
ALTER TABLE [dbo].[postep_hodowli]  WITH CHECK ADD FOREIGN KEY([ID_smieci])
REFERENCES [dbo].[smieci] ([ID_smieci])
GO
/****** Object:  ForeignKey [FK__postep_ho__ID_tu__1FCDBCEB]    Script Date: 01/12/2012 17:53:27 ******/
ALTER TABLE [dbo].[postep_hodowli]  WITH CHECK ADD FOREIGN KEY([ID_tucznika])
REFERENCES [dbo].[tucznik] ([ID_tucznika])
GO
/****** Object:  ForeignKey [FK__szczepion__ID_sz__117F9D94]    Script Date: 01/12/2012 17:53:27 ******/
ALTER TABLE [dbo].[szczepionka_tucznik]  WITH CHECK ADD FOREIGN KEY([ID_szczepionki])
REFERENCES [dbo].[szczepionka] ([ID_szczepionki])
GO
/****** Object:  ForeignKey [FK__szczepion__ID_tu__1273C1CD]    Script Date: 01/12/2012 17:53:27 ******/
ALTER TABLE [dbo].[szczepionka_tucznik]  WITH CHECK ADD FOREIGN KEY([ID_tucznika])
REFERENCES [dbo].[tucznik] ([ID_tucznika])
GO