up/Учебная практика 37 гр. 1 сем. - 2/СУБД Яхтенная верфь/Ресурсы 1/ms.sql

/****** Object:  Table [dbo].[Client]    Script Date: 30.05.2021 12:28:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Client](
	[IdClient] [int] IDENTITY(1,1) NOT NULL,
	[Fam] [nvarchar](50) NULL,
	[Name] [nvarchar](50) NULL,
	[Otch] [nvarchar](50) NULL,
	[Login] [nvarchar](50) NULL,
	[Passw] [nvarchar](50) NULL,
	[BDay] [date] NULL,
	[Phone] [nvarchar](50) NULL,
	[Email] [nvarchar](50) NULL,
	[PhotoClient] [nvarchar](100) NULL,
 CONSTRAINT [PK_Client] PRIMARY KEY CLUSTERED 
(
	[IdClient] 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].[SalesYaht]    Script Date: 30.05.2021 12:28:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SalesYaht](
	[IdSales] [int] IDENTITY(1,1) NOT NULL,
	[IdClient] [int] NULL,
	[Date] [date] NULL,
	[IdYaht] [int] NULL,
	[IdColor] [int] NULL,
 CONSTRAINT [PK_SalesYaht] PRIMARY KEY CLUSTERED 
(
	[IdSales] 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].[Yahta]    Script Date: 30.05.2021 12:28:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Yahta](
	[IdYahta] [int] IDENTITY(1,1) NOT NULL,
	[NameModel] [nvarchar](50) NULL,
	[IdType] [int] NULL,
	[Cost] [money] NULL,
	[Count] [int] NULL,
	[PhotoYaht] [nvarchar](100) NULL,
 CONSTRAINT [PK_Yahta] PRIMARY KEY CLUSTERED 
(
	[IdYahta] 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].[YahtColor]    Script Date: 30.05.2021 12:28:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[YahtColor](
	[IdColor] [int] IDENTITY(1,1) NOT NULL,
	[NameColor] [nvarchar](50) NULL,
 CONSTRAINT [PK_YahtColor] PRIMARY KEY CLUSTERED 
(
	[IdColor] 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].[YahtType]    Script Date: 30.05.2021 12:28:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[YahtType](
	[IdType] [int] IDENTITY(1,1) NOT NULL,
	[NameType] [nvarchar](50) NULL,
 CONSTRAINT [PK_YahtType] PRIMARY KEY CLUSTERED 
(
	[IdType] 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
ALTER TABLE [dbo].[SalesYaht]  WITH CHECK ADD  CONSTRAINT [FK_SalesYaht_Client] FOREIGN KEY([IdClient])
REFERENCES [dbo].[Client] ([IdClient])
GO
ALTER TABLE [dbo].[SalesYaht] CHECK CONSTRAINT [FK_SalesYaht_Client]
GO
ALTER TABLE [dbo].[SalesYaht]  WITH CHECK ADD  CONSTRAINT [FK_SalesYaht_Yahta] FOREIGN KEY([IdYaht])
REFERENCES [dbo].[Yahta] ([IdYahta])
GO
ALTER TABLE [dbo].[SalesYaht] CHECK CONSTRAINT [FK_SalesYaht_Yahta]
GO
ALTER TABLE [dbo].[SalesYaht]  WITH CHECK ADD  CONSTRAINT [FK_SalesYaht_YahtColor] FOREIGN KEY([IdColor])
REFERENCES [dbo].[YahtColor] ([IdColor])
GO
ALTER TABLE [dbo].[SalesYaht] CHECK CONSTRAINT [FK_SalesYaht_YahtColor]
GO
ALTER TABLE [dbo].[Yahta]  WITH CHECK ADD  CONSTRAINT [FK_Yahta_YahtType] FOREIGN KEY([IdType])
REFERENCES [dbo].[YahtType] ([IdType])
GO
ALTER TABLE [dbo].[Yahta] CHECK CONSTRAINT [FK_Yahta_YahtType]
GO