С крипт базы данных информационной системы
USE [is_enterprises]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [id_client] [int] NULL,
[date] [datetime] NULL,
[number] [nchar](10) COLLATE Cyrillic_General_CI_AS NULL,
[comment] [varchar](max) COLLATE Cyrillic_General_CI_AS NULL,
CONSTRAINT [PK_order_client] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
USE [is_enterprises]
GO
ALTER TABLE [dbo].[order_client] WITH CHECK ADD CONSTRAINT [FK_order_client_client] FOREIGN KEY([id_client])
REFERENCES [dbo].[client] ([id])
USE [is_enterprises]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[order_postavshik](
[id] [int] NOT NULL,
[number] [nchar](10) COLLATE Cyrillic_General_CI_AS NULL,
[date] [datetime] NULL,
[id_postavshik] [int] NOT NULL,
[comment] [varchar](max) COLLATE Cyrillic_General_CI_AS NULL,
CONSTRAINT [PK_order_postavshik] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
USE [is_enterprises]
GO
ALTER TABLE [dbo].[order_postavshik] WITH CHECK ADD CONSTRAINT [FK_order_postavshik_postavshik] FOREIGN KEY([id_postavshik])
REFERENCES [dbo].[postavshik] ([id])
USE [is_enterprises]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[postavshik](
[id] [int] NOT NULL,
[organization] [varchar](50) COLLATE Cyrillic_General_CI_AS NULL,
[FIO] [varchar](50) COLLATE Cyrillic_General_CI_AS NULL,
[post] [varchar](20) COLLATE Cyrillic_General_CI_AS NULL,
[rab_telephone] [varchar](15) COLLATE Cyrillic_General_CI_AS NULL,
[mobile] [varchar](11) COLLATE Cyrillic_General_CI_AS NULL,
[faks] [nchar](10) COLLATE Cyrillic_General_CI_AS NULL,
[street] [varchar](20) COLLATE Cyrillic_General_CI_AS NULL,
[town] [varchar](15) COLLATE Cyrillic_General_CI_AS NULL,
[region] [varchar](20) COLLATE Cyrillic_General_CI_AS NULL,
[indeks] [nchar](10) COLLATE Cyrillic_General_CI_AS NULL,
[e_mail] [varchar](20) COLLATE Cyrillic_General_CI_AS NULL,
[comment] [varchar](max) COLLATE Cyrillic_General_CI_AS NULL,
CONSTRAINT [PK_postavshik] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
USE [is_enterprises]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
|
|
GO
CREATE TABLE [dbo].[price](
[id] [int] NOT NULL,
[id_postavshik] [int] NOT NULL,
[id_equipment] [int] NOT NULL,
[price] [money] NULL,
[date_price] [datetime] NULL,
CONSTRAINT [PK_price] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
USE [is_enterprises]
GO
ALTER TABLE [dbo].[price] WITH CHECK ADD CONSTRAINT [FK_price_equipment] FOREIGN KEY([id_equipment])
REFERENCES [dbo].[equipment] ([id])
GO
ALTER TABLE [dbo].[price] WITH CHECK ADD CONSTRAINT [FK_price_postavshik] FOREIGN KEY([id_postavshik])
REFERENCES [dbo].[postavshik] ([id])
USE [is_enterprises]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[uchastnik_act](
[id] [int] NOT NULL,
[id_act] [int] NOT NULL,
[id_employee] [int] NOT NULL,
[factor_uchastia] [float] NULL,
CONSTRAINT [PK_uchastnik_act] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
USE [is_enterprises]
GO
ALTER TABLE [dbo].[uchastnik_act] WITH CHECK ADD CONSTRAINT [FK_uchastnik_act_act] FOREIGN KEY([id_act])
REFERENCES [dbo].[act] ([id])
GO
ALTER TABLE [dbo].[uchastnik_act] WITH CHECK ADD CONSTRAINT [FK_uchastnik_act_employee] FOREIGN KEY([id_employee])
REFERENCES [dbo].[employee] ([id])
USE [is_enterprises]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[line_act](
[id] [int] NOT NULL,
[id_act] [int] NOT NULL,
[id_line_order_client] [int] NOT NULL,
[date_guarantee] [datetime] NULL,
CONSTRAINT [PK_line_act] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
USE [is_enterprises]
GO
ALTER TABLE [dbo].[line_act] WITH CHECK ADD CONSTRAINT [FK_line_act_act] FOREIGN KEY([id_act])
REFERENCES [dbo].[act] ([id])
GO
ALTER TABLE [dbo].[line_act] WITH CHECK ADD CONSTRAINT [FK_line_act_line_order_client] FOREIGN KEY([id_line_order_client])
REFERENCES [dbo].[line_order_client] ([id])
USE [is_enterprises]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[plan_work](
|
|
[id] [int] NOT NULL,
[number] [nchar](10) COLLATE Cyrillic_General_CI_AS NULL,
[date] [datetime] NULL,
[brigad] [nchar](10) COLLATE Cyrillic_General_CI_AS NULL,
[comment] [varchar](max) COLLATE Cyrillic_General_CI_AS NULL,
CONSTRAINT [PK_plan_work] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
USE [is_enterprises]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[line_plan_work](
[id] [int] NOT NULL,
[id_plan_work] [int] NOT NULL,
[id_line_order_client] [int] NOT NULL,
[date_instal] [datetime] NULL,
CONSTRAINT [PK_line_plan_work] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
USE [is_enterprises]
GO
ALTER TABLE [dbo].[line_plan_work] WITH CHECK ADD CONSTRAINT [FK_line_plan_work_line_order_client] FOREIGN KEY([id_line_order_client])
REFERENCES [dbo].[line_order_client] ([id])
GO
ALTER TABLE [dbo].[line_plan_work] WITH CHECK ADD CONSTRAINT [FK_line_plan_work_plan_work] FOREIGN KEY([id_plan_work])
REFERENCES [dbo].[plan_work] ([id])
USE [is_enterprises]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[plan_employee](
[id] [int] NOT NULL,
[id_line_plan_work] [int] NOT NULL,
[id_employee] [int] NOT NULL,
CONSTRAINT [PK_plan_employee] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
USE [is_enterprises]
GO
ALTER TABLE [dbo].[plan_employee] WITH CHECK ADD CONSTRAINT [FK_plan_employee_employee] FOREIGN KEY([id_employee])
REFERENCES [dbo].[employee] ([id])
GO
ALTER TABLE [dbo].[plan_employee] WITH CHECK ADD CONSTRAINT [FK_plan_employee_line_plan_work] FOREIGN KEY([id_line_plan_work])
REFERENCES [dbo].[line_plan_work] ([id])
USE [is_enterprises]
GO
/****** Object: Table [dbo].[employee] Script Date: 05/27/2009 16:33:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[employee](
[id] [int] NOT NULL,
[FIO] [varchar](30) COLLATE Cyrillic_General_CI_AS NULL,
|
|
[address] [varchar](30) COLLATE Cyrillic_General_CI_AS NULL,
[telephone] [varchar](11) COLLATE Cyrillic_General_CI_AS NULL,
CONSTRAINT [PK_employee] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
П риложение Г
Дата добавления: 2020-01-07; просмотров: 447; Мы поможем в написании вашей работы! |
Мы поможем в написании ваших работ!