Microsovft.Framework.Core
1.0.0
See the version list below for details.
dotnet add package Microsovft.Framework.Core --version 1.0.0
NuGet\Install-Package Microsovft.Framework.Core -Version 1.0.0
<PackageReference Include="Microsovft.Framework.Core" Version="1.0.0" />
<PackageVersion Include="Microsovft.Framework.Core" Version="1.0.0" />
<PackageReference Include="Microsovft.Framework.Core" />
paket add Microsovft.Framework.Core --version 1.0.0
#r "nuget: Microsovft.Framework.Core, 1.0.0"
#:package Microsovft.Framework.Core@1.0.0
#addin nuget:?package=Microsovft.Framework.Core&version=1.0.0
#tool nuget:?package=Microsovft.Framework.Core&version=1.0.0
-- 1. Создаем базу данных CREATE DATABASE ИнтернетМагазин; GO
USE ИнтернетМагазин; GO
-- 2. Таблица Клиенты CREATE TABLE Клиенты ( ID_Клиента INT PRIMARY KEY IDENTITY(1,1), Имя_Клиента NVARCHAR(100) NOT NULL, Email_Клиента NVARCHAR(100) UNIQUE NOT NULL, Телефон NVARCHAR(20) ); GO
-- 3. Таблица Адреса_клиентов CREATE TABLE Адреса_клиентов ( ID_Адреса INT PRIMARY KEY IDENTITY(1,1), ID_Клиента INT NOT NULL, Город NVARCHAR(50) NOT NULL, Улица NVARCHAR(100) NOT NULL, Дом NVARCHAR(10) NOT NULL, FOREIGN KEY (ID_Клиента) REFERENCES Клиенты(ID_Клиента) ON DELETE CASCADE ); GO
-- 4. Таблица Категории_товаров CREATE TABLE Категории_товаров ( ID_Категории INT PRIMARY KEY IDENTITY(1,1), Название_категории NVARCHAR(50) NOT NULL UNIQUE ); GO
-- 5. Таблица Товары CREATE TABLE Товары ( ID_Товара INT PRIMARY KEY IDENTITY(1,1), Название_товара NVARCHAR(100) NOT NULL, ID_Категории INT NOT NULL, Текущая_цена DECIMAL(10,2) NOT NULL CHECK (Текущая_цена >= 0), FOREIGN KEY (ID_Категории) REFERENCES Категории_товаров(ID_Категории) ); GO
-- 6. Таблица Статусы_заказов CREATE TABLE Статусы_заказов ( ID_Статуса INT PRIMARY KEY IDENTITY(1,1), Название_статуса NVARCHAR(30) NOT NULL UNIQUE ); GO
-- 7. Таблица Заказы CREATE TABLE Заказы ( ID_Заказа INT PRIMARY KEY IDENTITY(1001,1), Дата_заказа DATE DEFAULT GETDATE(), ID_Статуса INT NOT NULL, ID_Клиента INT NOT NULL, ID_Адреса_доставки INT NOT NULL, FOREIGN KEY (ID_Статуса) REFERENCES Статусы_заказов(ID_Статуса), FOREIGN KEY (ID_Клиента) REFERENCES Клиенты(ID_Клиента), FOREIGN KEY (ID_Адреса_доставки) REFERENCES Адреса_клиентов(ID_Адреса) ); GO
-- 8. Таблица Состав_заказа CREATE TABLE Состав_заказа ( ID_Позиции INT PRIMARY KEY IDENTITY(1,1), ID_Заказа INT NOT NULL, ID_Товара INT NOT NULL, Количество INT NOT NULL CHECK (Количество > 0), Цена_на_момент_заказа DECIMAL(10,2) NOT NULL CHECK (Цена_на_момент_заказа >= 0), FOREIGN KEY (ID_Заказа) REFERENCES Заказы(ID_Заказа), FOREIGN KEY (ID_Товара) REFERENCES Товары(ID_Товара) ); GO
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net9.0 is compatible. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
-
net9.0
- No dependencies.
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.