USE [NSPD_13B_Z7]
GO
/****** Object:  Table [dbo].[KLIENT]    Script Date: 10/18/2018 09:06:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KLIENT](
    [ID_KLIENTA] [NUMERIC](18, 0) NOT NULL,
    [IMIE] [VARCHAR](50) NOT NULL,
    [NAZWISKO] [VARCHAR](50) NOT NULL,
    [ADRES] [VARCHAR](50) NOT NULL,
 CONSTRAINT [PK_KLIENT] PRIMARY KEY CLUSTERED
(
    [ID_KLIENTA] 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].[ROK]    Script Date: 10/18/2018 09:06:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ROK](
    [ID_ROKU] [NUMERIC](18, 0) NOT NULL,
    [ROK] [VARCHAR](50) NOT NULL,
 CONSTRAINT [PK_ROK] PRIMARY KEY CLUSTERED
(
    [ID_ROKU] 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].[POJAZD]    Script Date: 10/18/2018 09:06:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[POJAZD](
    [ID_POJAZDU] [NUMERIC](18, 0) NOT NULL,
    [MARKA] [VARCHAR](50) NOT NULL,
    [MODEL] [VARCHAR](50) NOT NULL,
    [ROCZNIK] [VARCHAR](50) NOT NULL,
    [PRZEBIEG] [VARCHAR](50) NOT NULL,
    [RODZAJ] [VARCHAR](50) NOT NULL,
    [VIN] [VARCHAR](50) NOT NULL,
    [RODZAJ_PALIWA] [VARCHAR](50) NOT NULL,
    [POJEMNOSC_SILNIKA] [VARCHAR](50) NOT NULL,
    [KOLOR] [VARCHAR](50) NOT NULL,
 CONSTRAINT [PK_POJAZD] PRIMARY KEY CLUSTERED
(
    [ID_POJAZDU] 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].[ODDZIAL]    Script Date: 10/18/2018 09:06:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ODDZIAL](
    [ID_ODDZIALU] [NUMERIC](18, 0) NOT NULL,
    [WOJEWODZTWO] [VARCHAR](50) NOT NULL,
    [MIASTO] [VARCHAR](50) NOT NULL,
 CONSTRAINT [PK_ODDZIAL] PRIMARY KEY CLUSTERED
(
    [ID_ODDZIALU] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
 CONSTRAINT [IX_ODDZIAL] UNIQUE NONCLUSTERED
(
    [ID_ODDZIALU] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = ON, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[MIESIAC]    Script Date: 10/18/2018 09:06:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MIESIAC](
    [ID_MIESIACA] [NUMERIC](18, 0) NOT NULL,
    [NAZWA_MIESIACA] [VARCHAR](50) NULL,
    [FK_ID_ROKU] [NUMERIC](18, 0) NOT NULL,
 CONSTRAINT [PK_MIESIAC] PRIMARY KEY CLUSTERED
(
    [ID_MIESIACA] 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].[DZIEN]    Script Date: 10/18/2018 09:06:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DZIEN](
    [ID_DNIA] [NUMERIC](18, 0) NOT NULL,
    [NAZWA_DNIA] [VARCHAR](50) NULL,
    [FK_ID_MIESIACA] [NUMERIC](18, 0) NOT NULL,
 CONSTRAINT [PK_DZIEN] PRIMARY KEY CLUSTERED
(
    [ID_DNIA] 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].[SPRZEDAZ]    Script Date: 10/18/2018 09:06:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SPRZEDAZ](
    [CENA] [VARCHAR](50) NULL,
    [ILOSC] [VARCHAR](50) NULL,
    [FK_ID_POJAZDU] [NUMERIC](18, 0) NOT NULL,
    [FK_ID_ODDZIALU] [NUMERIC](18, 0) NOT NULL,
    [FK_ID_KLIENTA] [NUMERIC](18, 0) NOT NULL,
    [FK_ID_DNIA] [NUMERIC](18, 0) NOT NULL,
    [ID_SPRZEDAZY] [NUMERIC](18, 0) NOT NULL,
 CONSTRAINT [PK_SPRZEDAZ] PRIMARY KEY CLUSTERED
(
    [ID_SPRZEDAZY] 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:  ForeignKey [FK_DZIEN_MIESIAC]    Script Date: 10/18/2018 09:06:26 ******/
ALTER TABLE [dbo].[DZIEN]  WITH CHECK ADD  CONSTRAINT [FK_DZIEN_MIESIAC] FOREIGN KEY([FK_ID_MIESIACA])
REFERENCES [dbo].[MIESIAC] ([ID_MIESIACA])
GO
ALTER TABLE [dbo].[DZIEN] CHECK CONSTRAINT [FK_DZIEN_MIESIAC]
GO
/****** Object:  ForeignKey [FK_MIESIAC_ROK]    Script Date: 10/18/2018 09:06:26 ******/
ALTER TABLE [dbo].[MIESIAC]  WITH CHECK ADD  CONSTRAINT [FK_MIESIAC_ROK] FOREIGN KEY([FK_ID_ROKU])
REFERENCES [dbo].[ROK] ([ID_ROKU])
GO
ALTER TABLE [dbo].[MIESIAC] CHECK CONSTRAINT [FK_MIESIAC_ROK]
GO
/****** Object:  ForeignKey [FK_SPRZEDAZ_DZIEN]    Script Date: 10/18/2018 09:06:26 ******/
ALTER TABLE [dbo].[SPRZEDAZ]  WITH CHECK ADD  CONSTRAINT [FK_SPRZEDAZ_DZIEN] FOREIGN KEY([FK_ID_DNIA])
REFERENCES [dbo].[DZIEN] ([ID_DNIA])
GO
ALTER TABLE [dbo].[SPRZEDAZ] CHECK CONSTRAINT [FK_SPRZEDAZ_DZIEN]
GO
/****** Object:  ForeignKey [FK_SPRZEDAZ_KLIENT]    Script Date: 10/18/2018 09:06:26 ******/
ALTER TABLE [dbo].[SPRZEDAZ]  WITH CHECK ADD  CONSTRAINT [FK_SPRZEDAZ_KLIENT] FOREIGN KEY([FK_ID_KLIENTA])
REFERENCES [dbo].[KLIENT] ([ID_KLIENTA])
GO
ALTER TABLE [dbo].[SPRZEDAZ] CHECK CONSTRAINT [FK_SPRZEDAZ_KLIENT]
GO
/****** Object:  ForeignKey [FK_SPRZEDAZ_ODDZIAL]    Script Date: 10/18/2018 09:06:26 ******/
ALTER TABLE [dbo].[SPRZEDAZ]  WITH CHECK ADD  CONSTRAINT [FK_SPRZEDAZ_ODDZIAL] FOREIGN KEY([FK_ID_ODDZIALU])
REFERENCES [dbo].[ODDZIAL] ([ID_ODDZIALU])
GO
ALTER TABLE [dbo].[SPRZEDAZ] CHECK CONSTRAINT [FK_SPRZEDAZ_ODDZIAL]
GO
/****** Object:  ForeignKey [FK_SPRZEDAZ_POJAZD]    Script Date: 10/18/2018 09:06:26 ******/
ALTER TABLE [dbo].[SPRZEDAZ]  WITH CHECK ADD  CONSTRAINT [FK_SPRZEDAZ_POJAZD] FOREIGN KEY([FK_ID_POJAZDU])
REFERENCES [dbo].[POJAZD] ([ID_POJAZDU])
GO
ALTER TABLE [dbo].[SPRZEDAZ] CHECK CONSTRAINT [FK_SPRZEDAZ_POJAZD]
GO