Skip to content

Instantly share code, notes, and snippets.

@DO162

DO162/Store.Database.sql

Created February 10, 2026 10:39
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save DO162/9b9984e19fd2cd5d5e6ec08eb6df7e0c to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save DO162/9b9984e19fd2cd5d5e6ec08eb6df7e0c to your computer and use it in GitHub Desktop.
Download ZIP
DZ_4_(23.12.25)_SQL
Raw
dbo.Address.Table.sql
USE [Store]
GO
/****** Object: Table [dbo].[Address] Script Date: 1/10/2026 10:07:48 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Address](
[id] [int] IDENTITY(1,1) NOT NULL,
[street] [nvarchar](50) NULL,
[id_city] [int] NULL,
CONSTRAINT [PK_Address] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Address] ON
INSERT [dbo].[Address] ([id], [street], [id_city]) VALUES (1, N'вул. Заводська', 1)
INSERT [dbo].[Address] ([id], [street], [id_city]) VALUES (2, N'вул. Хлібна', 2)
INSERT [dbo].[Address] ([id], [street], [id_city]) VALUES (3, N'вул. Mleczna', 3)
INSERT [dbo].[Address] ([id], [street], [id_city]) VALUES (4, N'вул. Мʼясна', 4)
INSERT [dbo].[Address] ([id], [street], [id_city]) VALUES (5, N'вул. Lactée', 5)
INSERT [dbo].[Address] ([id], [street], [id_city]) VALUES (6, N'вул. Молочна', 6)
INSERT [dbo].[Address] ([id], [street], [id_city]) VALUES (7, N'вул. Фруктова', 7)
INSERT [dbo].[Address] ([id], [street], [id_city]) VALUES (8, N'вул. Pasta', 8)
INSERT [dbo].[Address] ([id], [street], [id_city]) VALUES (9, N'вул. Rice Road', 9)
INSERT [dbo].[Address] ([id], [street], [id_city]) VALUES (10, N'вул. Цукрова', 10)
INSERT [dbo].[Address] ([id], [street], [id_city]) VALUES (11, N'вул. Caffè', 11)
INSERT [dbo].[Address] ([id], [street], [id_city]) VALUES (12, N'вул. Tea Garden', 12)
INSERT [dbo].[Address] ([id], [street], [id_city]) VALUES (13, N'вул. Кондитерська', 13)
INSERT [dbo].[Address] ([id], [street], [id_city]) VALUES (14, N'вул. Пекарська', 14)
INSERT [dbo].[Address] ([id], [street], [id_city]) VALUES (15, N'вул. Олійна', 15)
SET IDENTITY_INSERT [dbo].[Address] OFF
GO
ALTER TABLE [dbo].[Address] WITH CHECK ADD CONSTRAINT [FK_Address_City] FOREIGN KEY([id_city])
REFERENCES [dbo].[City] ([id])
GO
ALTER TABLE [dbo].[Address] CHECK CONSTRAINT [FK_Address_City]
GO
Raw
dbo.Category.Table.sql
USE [Store]
GO
/****** Object: Table [dbo].[Category] Script Date: 1/10/2026 10:07:48 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Category](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](50) NULL,
CONSTRAINT [PK_Category] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Category] ON
INSERT [dbo].[Category] ([id], [name]) VALUES (1, N'Молочні продукти')
INSERT [dbo].[Category] ([id], [name]) VALUES (2, N'Хлібобулочні вироби')
INSERT [dbo].[Category] ([id], [name]) VALUES (3, N'М''ясні продукти')
INSERT [dbo].[Category] ([id], [name]) VALUES (4, N'Рідина')
INSERT [dbo].[Category] ([id], [name]) VALUES (5, N'Бакалія')
INSERT [dbo].[Category] ([id], [name]) VALUES (6, N'Кондитерські вироби')
SET IDENTITY_INSERT [dbo].[Category] OFF
GO
Raw
dbo.City.Table.sql
USE [Store]
GO
/****** Object: Table [dbo].[City] Script Date: 1/10/2026 10:07:48 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[City](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](50) NULL,
[id_region] [int] NULL,
CONSTRAINT [PK_City] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[City] ON
INSERT [dbo].[City] ([id], [name], [id_region]) VALUES (1, N'Вінниця', 1)
INSERT [dbo].[City] ([id], [name], [id_region]) VALUES (2, N'Київ', 2)
INSERT [dbo].[City] ([id], [name], [id_region]) VALUES (3, N'Варшава', 3)
INSERT [dbo].[City] ([id], [name], [id_region]) VALUES (4, N'Львів', 4)
INSERT [dbo].[City] ([id], [name], [id_region]) VALUES (5, N'Париж', 5)
INSERT [dbo].[City] ([id], [name], [id_region]) VALUES (6, N'Тернопіль', 6)
INSERT [dbo].[City] ([id], [name], [id_region]) VALUES (7, N'Миколаїв', 7)
INSERT [dbo].[City] ([id], [name], [id_region]) VALUES (8, N'Мілан', 8)
INSERT [dbo].[City] ([id], [name], [id_region]) VALUES (9, N'Лудхіана', 9)
INSERT [dbo].[City] ([id], [name], [id_region]) VALUES (10, N'Полтава', 10)
INSERT [dbo].[City] ([id], [name], [id_region]) VALUES (11, N'Турин', 11)
INSERT [dbo].[City] ([id], [name], [id_region]) VALUES (12, N'Канді', 12)
INSERT [dbo].[City] ([id], [name], [id_region]) VALUES (13, N'Бориспіль', 13)
INSERT [dbo].[City] ([id], [name], [id_region]) VALUES (14, N'Стрий', 14)
INSERT [dbo].[City] ([id], [name], [id_region]) VALUES (15, N'Дніпро', 15)
SET IDENTITY_INSERT [dbo].[City] OFF
GO
ALTER TABLE [dbo].[City] WITH CHECK ADD CONSTRAINT [FK_City_Region] FOREIGN KEY([id_region])
REFERENCES [dbo].[Region] ([id])
GO
ALTER TABLE [dbo].[City] CHECK CONSTRAINT [FK_City_Region]
GO
Raw
dbo.Country.Table.sql
USE [Store]
GO
/****** Object: Table [dbo].[Country] Script Date: 1/10/2026 10:07:48 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Country](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](50) NULL,
CONSTRAINT [PK_Country] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Country] ON
INSERT [dbo].[Country] ([id], [name]) VALUES (1, N'Україна')
INSERT [dbo].[Country] ([id], [name]) VALUES (2, N'Україна')
INSERT [dbo].[Country] ([id], [name]) VALUES (3, N'Польща')
INSERT [dbo].[Country] ([id], [name]) VALUES (4, N'Україна')
INSERT [dbo].[Country] ([id], [name]) VALUES (5, N'Франція')
INSERT [dbo].[Country] ([id], [name]) VALUES (6, N'Україна')
INSERT [dbo].[Country] ([id], [name]) VALUES (7, N'Україна')
INSERT [dbo].[Country] ([id], [name]) VALUES (8, N'Італія')
INSERT [dbo].[Country] ([id], [name]) VALUES (9, N'Індія')
INSERT [dbo].[Country] ([id], [name]) VALUES (10, N'Україна')
INSERT [dbo].[Country] ([id], [name]) VALUES (11, N'Італія')
INSERT [dbo].[Country] ([id], [name]) VALUES (12, N'Шрі-Ланка')
INSERT [dbo].[Country] ([id], [name]) VALUES (13, N'Україна')
INSERT [dbo].[Country] ([id], [name]) VALUES (14, N'Україна')
INSERT [dbo].[Country] ([id], [name]) VALUES (15, N'Україна')
SET IDENTITY_INSERT [dbo].[Country] OFF
GO
Raw
dbo.Delivery.Table.sql
USE [Store]
GO
/****** Object: Table [dbo].[Delivery] Script Date: 1/10/2026 10:07:48 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Delivery](
[id] [int] IDENTITY(1,1) NOT NULL,
[id_product] [int] NULL,
[id_supplier] [int] NULL,
[price] [nvarchar](50) NULL,
[quantity] [float] NULL,
[date_of_delivery] [date] NULL,
CONSTRAINT [PK_Delivery] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Delivery] ON
INSERT [dbo].[Delivery] ([id], [id_product], [id_supplier], [price], [quantity], [date_of_delivery]) VALUES (1, 1, 1, N'9.00 грн', 120, CAST(N'2026-02-01' AS Date))
INSERT [dbo].[Delivery] ([id], [id_product], [id_supplier], [price], [quantity], [date_of_delivery]) VALUES (2, 2, 2, N'3.50 грн', 200, CAST(N'2025-02-01' AS Date))
INSERT [dbo].[Delivery] ([id], [id_product], [id_supplier], [price], [quantity], [date_of_delivery]) VALUES (3, 3, 3, N'15.00 грн', 60, CAST(N'2025-02-01' AS Date))
INSERT [dbo].[Delivery] ([id], [id_product], [id_supplier], [price], [quantity], [date_of_delivery]) VALUES (4, 4, 4, N'10.00 грн', 80, CAST(N'2025-02-01' AS Date))
INSERT [dbo].[Delivery] ([id], [id_product], [id_supplier], [price], [quantity], [date_of_delivery]) VALUES (5, 5, 5, N'6.00 грн', 150, CAST(N'2025-02-01' AS Date))
INSERT [dbo].[Delivery] ([id], [id_product], [id_supplier], [price], [quantity], [date_of_delivery]) VALUES (6, 6, 6, N'8.00 грн', 90, CAST(N'2025-02-01' AS Date))
INSERT [dbo].[Delivery] ([id], [id_product], [id_supplier], [price], [quantity], [date_of_delivery]) VALUES (7, 7, 7, N'7.00 грн', 110, CAST(N'2025-02-01' AS Date))
INSERT [dbo].[Delivery] ([id], [id_product], [id_supplier], [price], [quantity], [date_of_delivery]) VALUES (8, 8, 8, N'12.00 грн', 70, CAST(N'2025-02-01' AS Date))
INSERT [dbo].[Delivery] ([id], [id_product], [id_supplier], [price], [quantity], [date_of_delivery]) VALUES (9, 9, 9, N'14.00 грн', 130, CAST(N'2025-02-01' AS Date))
INSERT [dbo].[Delivery] ([id], [id_product], [id_supplier], [price], [quantity], [date_of_delivery]) VALUES (10, 10, 10, N'6.00 грн', 300, CAST(N'2025-02-01' AS Date))
INSERT [dbo].[Delivery] ([id], [id_product], [id_supplier], [price], [quantity], [date_of_delivery]) VALUES (11, 11, 11, N'18.00 грн', 50, CAST(N'2025-02-01' AS Date))
INSERT [dbo].[Delivery] ([id], [id_product], [id_supplier], [price], [quantity], [date_of_delivery]) VALUES (12, 12, 12, N'9.00 грн', 140, CAST(N'2025-02-01' AS Date))
INSERT [dbo].[Delivery] ([id], [id_product], [id_supplier], [price], [quantity], [date_of_delivery]) VALUES (13, 13, 13, N'6.50 грн', 160, CAST(N'2025-02-01' AS Date))
INSERT [dbo].[Delivery] ([id], [id_product], [id_supplier], [price], [quantity], [date_of_delivery]) VALUES (14, 14, 14, N'5.00 грн', 180, CAST(N'2025-02-01' AS Date))
INSERT [dbo].[Delivery] ([id], [id_product], [id_supplier], [price], [quantity], [date_of_delivery]) VALUES (15, 15, 15, N'9.00 грн', 95, CAST(N'2025-02-01' AS Date))
SET IDENTITY_INSERT [dbo].[Delivery] OFF
GO
ALTER TABLE [dbo].[Delivery] WITH CHECK ADD CONSTRAINT [FK_Delivery_Product] FOREIGN KEY([id_product])
REFERENCES [dbo].[Product] ([id])
GO
ALTER TABLE [dbo].[Delivery] CHECK CONSTRAINT [FK_Delivery_Product]
GO
ALTER TABLE [dbo].[Delivery] WITH CHECK ADD CONSTRAINT [FK_Delivery_Supplier] FOREIGN KEY([id_supplier])
REFERENCES [dbo].[Supplier] ([id])
GO
ALTER TABLE [dbo].[Delivery] CHECK CONSTRAINT [FK_Delivery_Supplier]
GO
Raw
dbo.Markup.Table.sql
USE [Store]
GO
/****** Object: Table [dbo].[Markup] Script Date: 1/10/2026 10:07:48 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Markup](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](50) NULL,
[percent] [float] NULL,
CONSTRAINT [PK_Markup] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Markup] ON
INSERT [dbo].[Markup] ([id], [name], [percent]) VALUES (1, N'Молоко', 5)
INSERT [dbo].[Markup] ([id], [name], [percent]) VALUES (2, N'Хліб', 0)
INSERT [dbo].[Markup] ([id], [name], [percent]) VALUES (3, N'Сир', 10)
INSERT [dbo].[Markup] ([id], [name], [percent]) VALUES (4, N'Ковбаса', 7)
INSERT [dbo].[Markup] ([id], [name], [percent]) VALUES (5, N'Йогурт', 12)
INSERT [dbo].[Markup] ([id], [name], [percent]) VALUES (6, N'Масло', 8)
INSERT [dbo].[Markup] ([id], [name], [percent]) VALUES (7, N'Сік апельсиновий', 5)
INSERT [dbo].[Markup] ([id], [name], [percent]) VALUES (8, N'Макарони', 15)
INSERT [dbo].[Markup] ([id], [name], [percent]) VALUES (9, N'Рис', 10)
INSERT [dbo].[Markup] ([id], [name], [percent]) VALUES (10, N'Цукор', 0)
INSERT [dbo].[Markup] ([id], [name], [percent]) VALUES (11, N'Кава', 20)
INSERT [dbo].[Markup] ([id], [name], [percent]) VALUES (12, N'Чай', 10)
INSERT [dbo].[Markup] ([id], [name], [percent]) VALUES (13, N'Шоколад', 5)
INSERT [dbo].[Markup] ([id], [name], [percent]) VALUES (14, N'Печиво', 8)
INSERT [dbo].[Markup] ([id], [name], [percent]) VALUES (15, N'Олія', 6)
SET IDENTITY_INSERT [dbo].[Markup] OFF
GO
Raw
dbo.Measurement.Table.sql
USE [Store]
GO
/****** Object: Table [dbo].[Measurement] Script Date: 1/10/2026 10:07:48 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Measurement](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](50) NULL,
[description] [nvarchar](50) NULL,
CONSTRAINT [PK_Measurement] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Measurement] ON
INSERT [dbo].[Measurement] ([id], [name], [description]) VALUES (1, N'Молоко', N'Пастеризоване коровʼяче молоко 2.5')
INSERT [dbo].[Measurement] ([id], [name], [description]) VALUES (2, N'Хліб', N'Свіжий пшеничний хліб')
INSERT [dbo].[Measurement] ([id], [name], [description]) VALUES (3, N'Сир', N'Твердий сир з коровʼячого молока')
INSERT [dbo].[Measurement] ([id], [name], [description]) VALUES (4, N'Ковбаса', N'Варена ковбаса вищого ґатунку')
INSERT [dbo].[Measurement] ([id], [name], [description]) VALUES (5, N'Йогурт', N'Йогурт з полуничним наповнювачем')
INSERT [dbo].[Measurement] ([id], [name], [description]) VALUES (6, N'Масло', N'Вершкове масло 82%')
INSERT [dbo].[Measurement] ([id], [name], [description]) VALUES (7, N'Апельсиновий сік', N'Натуральний апельсиновий сік')
INSERT [dbo].[Measurement] ([id], [name], [description]) VALUES (8, N'Макарони', N'Макаронні вироби з твердих сортів пшениці')
INSERT [dbo].[Measurement] ([id], [name], [description]) VALUES (9, N'Рис', N'Довгозернистий пропарений рис')
INSERT [dbo].[Measurement] ([id], [name], [description]) VALUES (10, N'Цукор', N'Цукор-пісок білий')
INSERT [dbo].[Measurement] ([id], [name], [description]) VALUES (11, N'Мелена кава', N'Мелена кава середнього обсмаження')
INSERT [dbo].[Measurement] ([id], [name], [description]) VALUES (12, N'Чай', N'Чорний байховий чай')
INSERT [dbo].[Measurement] ([id], [name], [description]) VALUES (13, N'Шоколад з какао', N'Молочний шоколад з какао')
INSERT [dbo].[Measurement] ([id], [name], [description]) VALUES (14, N'Печиво', N'Вівсяне печиво з медом')
INSERT [dbo].[Measurement] ([id], [name], [description]) VALUES (15, N'Олія', N'Рафінована соняшникова олія')
SET IDENTITY_INSERT [dbo].[Measurement] OFF
GO
Raw
dbo.Producer.Table.sql
USE [Store]
GO
/****** Object: Table [dbo].[Producer] Script Date: 1/10/2026 10:07:48 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Producer](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](50) NULL,
[id_adress] [int] NULL,
CONSTRAINT [PK_Producer] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Producer] ON
INSERT [dbo].[Producer] ([id], [name], [id_adress]) VALUES (1, N'Lactalis', 1)
INSERT [dbo].[Producer] ([id], [name], [id_adress]) VALUES (2, N'КиївХліб', 2)
INSERT [dbo].[Producer] ([id], [name], [id_adress]) VALUES (3, N'President', 3)
INSERT [dbo].[Producer] ([id], [name], [id_adress]) VALUES (4, N'Мʼясний дім', 4)
INSERT [dbo].[Producer] ([id], [name], [id_adress]) VALUES (5, N'Danone', 5)
INSERT [dbo].[Producer] ([id], [name], [id_adress]) VALUES (6, N'Molokia', 6)
INSERT [dbo].[Producer] ([id], [name], [id_adress]) VALUES (7, N'Sandora', 7)
INSERT [dbo].[Producer] ([id], [name], [id_adress]) VALUES (8, N'Barilla', 8)
INSERT [dbo].[Producer] ([id], [name], [id_adress]) VALUES (9, N'Mistral', 9)
INSERT [dbo].[Producer] ([id], [name], [id_adress]) VALUES (10, N'SweetLand', 10)
INSERT [dbo].[Producer] ([id], [name], [id_adress]) VALUES (11, N'Lavazza', 11)
INSERT [dbo].[Producer] ([id], [name], [id_adress]) VALUES (12, N'Ahmad Tea', 12)
INSERT [dbo].[Producer] ([id], [name], [id_adress]) VALUES (13, N'Roshen', 13)
INSERT [dbo].[Producer] ([id], [name], [id_adress]) VALUES (14, N'Yarych', 14)
INSERT [dbo].[Producer] ([id], [name], [id_adress]) VALUES (15, N'Oleina', 15)
SET IDENTITY_INSERT [dbo].[Producer] OFF
GO
ALTER TABLE [dbo].[Producer] WITH CHECK ADD CONSTRAINT [FK_Producer_Address] FOREIGN KEY([id_adress])
REFERENCES [dbo].[Address] ([id])
GO
ALTER TABLE [dbo].[Producer] CHECK CONSTRAINT [FK_Producer_Address]
GO
Raw
dbo.Product.Table.sql
USE [Store]
GO
/****** Object: Table [dbo].[Product] Script Date: 1/10/2026 10:07:48 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Product](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](50) NULL,
[id_category] [int] NULL,
[price] [nvarchar](50) NULL,
[quantity] [float] NULL,
[id_producer] [int] NULL,
[id_measurement] [int] NULL,
[id_markup] [int] NULL,
CONSTRAINT [PK_Product] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Product] ON
INSERT [dbo].[Product] ([id], [name], [id_category], [price], [quantity], [id_producer], [id_measurement], [id_markup]) VALUES (1, N'Молоко 2.5%', 1, N'32.50 грн', 120, 1, 1, 1)
INSERT [dbo].[Product] ([id], [name], [id_category], [price], [quantity], [id_producer], [id_measurement], [id_markup]) VALUES (2, N'Хліб пшеничний', 2, N'18.00 грн', 200, 2, 2, 2)
INSERT [dbo].[Product] ([id], [name], [id_category], [price], [quantity], [id_producer], [id_measurement], [id_markup]) VALUES (3, N'Сир твердий', 1, N'145.00 грн', 60, 3, 3, 3)
INSERT [dbo].[Product] ([id], [name], [id_category], [price], [quantity], [id_producer], [id_measurement], [id_markup]) VALUES (4, N'Ковбаса варена', 3, N'98.00 грн', 80, 4, 4, 4)
INSERT [dbo].[Product] ([id], [name], [id_category], [price], [quantity], [id_producer], [id_measurement], [id_markup]) VALUES (5, N'Йогурт полуничний', 1, N'27.50 грн', 150, 5, 5, 5)
INSERT [dbo].[Product] ([id], [name], [id_category], [price], [quantity], [id_producer], [id_measurement], [id_markup]) VALUES (6, N'Масло вершкове', 1, N'79.00 грн', 90, 6, 6, 6)
INSERT [dbo].[Product] ([id], [name], [id_category], [price], [quantity], [id_producer], [id_measurement], [id_markup]) VALUES (7, N'Сік апельсиновий', 4, N'45.00 грн', 110, 7, 7, 7)
INSERT [dbo].[Product] ([id], [name], [id_category], [price], [quantity], [id_producer], [id_measurement], [id_markup]) VALUES (8, N'Макарони', 5, N'62.00 грн', 70, 8, 8, 8)
INSERT [dbo].[Product] ([id], [name], [id_category], [price], [quantity], [id_producer], [id_measurement], [id_markup]) VALUES (9, N'Рис довгозернистий', 5, N'54.00 грн', 130, 9, 9, 9)
INSERT [dbo].[Product] ([id], [name], [id_category], [price], [quantity], [id_producer], [id_measurement], [id_markup]) VALUES (10, N'Цукор', 5, N'38.00 грн', 300, 10, 10, 10)
INSERT [dbo].[Product] ([id], [name], [id_category], [price], [quantity], [id_producer], [id_measurement], [id_markup]) VALUES (11, N'Кава мелена', 4, N'210.00 грн', 50, 11, 11, 11)
INSERT [dbo].[Product] ([id], [name], [id_category], [price], [quantity], [id_producer], [id_measurement], [id_markup]) VALUES (12, N'Чай чорний', 4, N'85.00 грн', 140, 12, 12, 12)
INSERT [dbo].[Product] ([id], [name], [id_category], [price], [quantity], [id_producer], [id_measurement], [id_markup]) VALUES (13, N'Шоколад молочний', 6, N'42.00 грн', 160, 13, 13, 13)
INSERT [dbo].[Product] ([id], [name], [id_category], [price], [quantity], [id_producer], [id_measurement], [id_markup]) VALUES (14, N'Печиво вівсяне', 6, N'36.00 грн', 180, 14, 14, 14)
INSERT [dbo].[Product] ([id], [name], [id_category], [price], [quantity], [id_producer], [id_measurement], [id_markup]) VALUES (15, N'Олія соняшникова', 5, N'72.00 грн', 95, 15, 15, 15)
SET IDENTITY_INSERT [dbo].[Product] OFF
GO
ALTER TABLE [dbo].[Product] WITH CHECK ADD CONSTRAINT [FK_Product_Category] FOREIGN KEY([id_category])
REFERENCES [dbo].[Category] ([id])
GO
ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_Category]
GO
ALTER TABLE [dbo].[Product] WITH CHECK ADD CONSTRAINT [FK_Product_Markup] FOREIGN KEY([id_markup])
REFERENCES [dbo].[Markup] ([id])
GO
ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_Markup]
GO
ALTER TABLE [dbo].[Product] WITH CHECK ADD CONSTRAINT [FK_Product_Measurement] FOREIGN KEY([id_measurement])
REFERENCES [dbo].[Measurement] ([id])
GO
ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_Measurement]
GO
ALTER TABLE [dbo].[Product] WITH CHECK ADD CONSTRAINT [FK_Product_Producer] FOREIGN KEY([id_producer])
REFERENCES [dbo].[Producer] ([id])
GO
ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_Producer]
GO
Raw
dbo.Region.Table.sql
USE [Store]
GO
/****** Object: Table [dbo].[Region] Script Date: 1/10/2026 10:07:48 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Region](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](50) NULL,
[id_country] [int] NULL,
CONSTRAINT [PK_Region] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Region] ON
INSERT [dbo].[Region] ([id], [name], [id_country]) VALUES (1, N'Вінницька область', 1)
INSERT [dbo].[Region] ([id], [name], [id_country]) VALUES (2, N'Київська область', 2)
INSERT [dbo].[Region] ([id], [name], [id_country]) VALUES (3, N'Мазовецьке', 3)
INSERT [dbo].[Region] ([id], [name], [id_country]) VALUES (4, N'Львівська область', 4)
INSERT [dbo].[Region] ([id], [name], [id_country]) VALUES (5, N'Іль-де-Франс', 5)
INSERT [dbo].[Region] ([id], [name], [id_country]) VALUES (6, N'Тернопільська область', 6)
INSERT [dbo].[Region] ([id], [name], [id_country]) VALUES (7, N'Миколаївська область', 7)
INSERT [dbo].[Region] ([id], [name], [id_country]) VALUES (8, N'Ломбардія', 8)
INSERT [dbo].[Region] ([id], [name], [id_country]) VALUES (9, N'Пенджаб', 9)
INSERT [dbo].[Region] ([id], [name], [id_country]) VALUES (10, N'Полтавська область', 10)
INSERT [dbo].[Region] ([id], [name], [id_country]) VALUES (11, N'Пʼємонт', 11)
INSERT [dbo].[Region] ([id], [name], [id_country]) VALUES (12, N'Центральна провінція', 12)
INSERT [dbo].[Region] ([id], [name], [id_country]) VALUES (13, N'Київська область', 13)
INSERT [dbo].[Region] ([id], [name], [id_country]) VALUES (14, N'Львівська область', 14)
INSERT [dbo].[Region] ([id], [name], [id_country]) VALUES (15, N'Дніпропетровська область', 15)
SET IDENTITY_INSERT [dbo].[Region] OFF
GO
ALTER TABLE [dbo].[Region] WITH CHECK ADD CONSTRAINT [FK_Region_Country] FOREIGN KEY([id_country])
REFERENCES [dbo].[Country] ([id])
GO
ALTER TABLE [dbo].[Region] CHECK CONSTRAINT [FK_Region_Country]
GO
Raw
dbo.Sale.Table.sql
USE [Store]
GO
/****** Object: Table [dbo].[Sale] Script Date: 1/10/2026 10:07:48 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sale](
[id] [int] IDENTITY(1,1) NOT NULL,
[id_product] [int] NULL,
[price] [float] NULL,
[quantity] [float] NULL,
[date_of_sale] [date] NULL,
CONSTRAINT [PK_Sale] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Sale] ON
INSERT [dbo].[Sale] ([id], [id_product], [price], [quantity], [date_of_sale]) VALUES (1, 1, 1, 100, CAST(N'2026-02-01' AS Date))
INSERT [dbo].[Sale] ([id], [id_product], [price], [quantity], [date_of_sale]) VALUES (2, 2, 2, 164, CAST(N'2026-02-01' AS Date))
INSERT [dbo].[Sale] ([id], [id_product], [price], [quantity], [date_of_sale]) VALUES (3, 3, 3, 30, CAST(N'2026-02-01' AS Date))
INSERT [dbo].[Sale] ([id], [id_product], [price], [quantity], [date_of_sale]) VALUES (4, 4, 4, 40, CAST(N'2026-02-01' AS Date))
INSERT [dbo].[Sale] ([id], [id_product], [price], [quantity], [date_of_sale]) VALUES (5, 5, 5, 108, CAST(N'2026-02-01' AS Date))
INSERT [dbo].[Sale] ([id], [id_product], [price], [quantity], [date_of_sale]) VALUES (6, 6, 6, 56, CAST(N'2026-02-01' AS Date))
INSERT [dbo].[Sale] ([id], [id_product], [price], [quantity], [date_of_sale]) VALUES (7, 7, 7, 36, CAST(N'2026-02-01' AS Date))
INSERT [dbo].[Sale] ([id], [id_product], [price], [quantity], [date_of_sale]) VALUES (8, 8, 8, 56, CAST(N'2026-02-01' AS Date))
INSERT [dbo].[Sale] ([id], [id_product], [price], [quantity], [date_of_sale]) VALUES (9, 9, 9, 29, CAST(N'2026-02-01' AS Date))
INSERT [dbo].[Sale] ([id], [id_product], [price], [quantity], [date_of_sale]) VALUES (10, 10, 10, 249, CAST(N'2026-02-01' AS Date))
INSERT [dbo].[Sale] ([id], [id_product], [price], [quantity], [date_of_sale]) VALUES (11, 11, 11, 34, CAST(N'2026-02-01' AS Date))
INSERT [dbo].[Sale] ([id], [id_product], [price], [quantity], [date_of_sale]) VALUES (12, 12, 12, 109, CAST(N'2026-02-01' AS Date))
INSERT [dbo].[Sale] ([id], [id_product], [price], [quantity], [date_of_sale]) VALUES (13, 13, 13, 107, CAST(N'2026-02-01' AS Date))
INSERT [dbo].[Sale] ([id], [id_product], [price], [quantity], [date_of_sale]) VALUES (14, 14, 14, 178, CAST(N'2026-02-01' AS Date))
INSERT [dbo].[Sale] ([id], [id_product], [price], [quantity], [date_of_sale]) VALUES (15, 15, 15, 95, CAST(N'2026-02-01' AS Date))
SET IDENTITY_INSERT [dbo].[Sale] OFF
GO
ALTER TABLE [dbo].[Sale] WITH CHECK ADD CONSTRAINT [FK_Sale_Product] FOREIGN KEY([id_product])
REFERENCES [dbo].[Product] ([id])
GO
ALTER TABLE [dbo].[Sale] CHECK CONSTRAINT [FK_Sale_Product]
GO
Raw
dbo.Supplier.Table.sql
USE [Store]
GO
/****** Object: Table [dbo].[Supplier] Script Date: 1/10/2026 10:07:48 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Supplier](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](50) NULL,
[id_address] [int] NULL,
CONSTRAINT [PK_Supplier] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Supplier] ON
INSERT [dbo].[Supplier] ([id], [name], [id_address]) VALUES (1, N'FoodTrade UA', 1)
INSERT [dbo].[Supplier] ([id], [name], [id_address]) VALUES (2, N'Bakery Supply', 2)
INSERT [dbo].[Supplier] ([id], [name], [id_address]) VALUES (3, N'EuroFood', 3)
INSERT [dbo].[Supplier] ([id], [name], [id_address]) VALUES (4, N'MeatLine', 4)
INSERT [dbo].[Supplier] ([id], [name], [id_address]) VALUES (5, N'DairyImport', 5)
INSERT [dbo].[Supplier] ([id], [name], [id_address]) VALUES (6, N'MilkGroup', 6)
INSERT [dbo].[Supplier] ([id], [name], [id_address]) VALUES (7, N'JuiceTrade', 7)
INSERT [dbo].[Supplier] ([id], [name], [id_address]) VALUES (8, N'ItalianFoods', 8)
INSERT [dbo].[Supplier] ([id], [name], [id_address]) VALUES (9, N'AsiaFood', 9)
INSERT [dbo].[Supplier] ([id], [name], [id_address]) VALUES (10, N'AgroSupply', 10)
INSERT [dbo].[Supplier] ([id], [name], [id_address]) VALUES (11, N'CoffeeImport', 11)
INSERT [dbo].[Supplier] ([id], [name], [id_address]) VALUES (12, N'TeaWorld', 12)
INSERT [dbo].[Supplier] ([id], [name], [id_address]) VALUES (13, N'SweetTrade', 13)
INSERT [dbo].[Supplier] ([id], [name], [id_address]) VALUES (14, N'CookieLine', 14)
INSERT [dbo].[Supplier] ([id], [name], [id_address]) VALUES (15, N'OilTrade', 15)
SET IDENTITY_INSERT [dbo].[Supplier] OFF
GO
ALTER TABLE [dbo].[Supplier] WITH CHECK ADD CONSTRAINT [FK_Supplier_Address] FOREIGN KEY([id_address])
REFERENCES [dbo].[Address] ([id])
GO
ALTER TABLE [dbo].[Supplier] CHECK CONSTRAINT [FK_Supplier_Address]
GO
Raw
Store.Database.sql
USE [master]
GO
/****** Object: Database [Store] Script Date: 1/10/2026 10:07:48 PM ******/
CREATE DATABASE [Store]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'Store', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSQL\DATA\Store.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
LOG ON
( NAME = N'Store_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSQL\DATA\Store_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF
GO
ALTER DATABASE [Store] SET COMPATIBILITY_LEVEL = 170
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Store].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [Store] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [Store] SET ANSI_NULLS OFF
GO
ALTER DATABASE [Store] SET ANSI_PADDING OFF
GO
ALTER DATABASE [Store] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [Store] SET ARITHABORT OFF
GO
ALTER DATABASE [Store] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [Store] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [Store] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [Store] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [Store] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [Store] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [Store] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [Store] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [Store] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [Store] SET DISABLE_BROKER
GO
ALTER DATABASE [Store] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [Store] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [Store] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [Store] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [Store] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [Store] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [Store] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [Store] SET RECOVERY FULL
GO
ALTER DATABASE [Store] SET MULTI_USER
GO
ALTER DATABASE [Store] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [Store] SET DB_CHAINING OFF
GO
ALTER DATABASE [Store] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
GO
ALTER DATABASE [Store] SET TARGET_RECOVERY_TIME = 60 SECONDS
GO
ALTER DATABASE [Store] SET DELAYED_DURABILITY = DISABLED
GO
ALTER DATABASE [Store] SET ACCELERATED_DATABASE_RECOVERY = OFF
GO
ALTER DATABASE [Store] SET OPTIMIZED_LOCKING = OFF
GO
ALTER DATABASE [Store] SET QUERY_STORE = ON
GO
ALTER DATABASE [Store] SET QUERY_STORE (OPERATION_MODE = READ_WRITE, CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 30), DATA_FLUSH_INTERVAL_SECONDS = 900, INTERVAL_LENGTH_MINUTES = 60, MAX_STORAGE_SIZE_MB = 1000, QUERY_CAPTURE_MODE = AUTO, SIZE_BASED_CLEANUP_MODE = AUTO, MAX_PLANS_PER_QUERY = 200, WAIT_STATS_CAPTURE_MODE = ON)
GO
ALTER DATABASE [Store] SET READ_WRITE
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment