SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Worker](
	[WorkerNo] [bigint] NOT NULL,
	[WorkerName] [varchar](50) COLLATE Cyrillic_General_CI_AS NOT NULL,
	[City] [varchar](50) COLLATE Cyrillic_General_CI_AS NOT NULL,
	[Adress] [varchar](50) COLLATE Cyrillic_General_CI_AS NOT NULL,
	[Phone] [char](11) COLLATE Cyrillic_General_CI_AS NOT NULL,
 CONSTRAINT [PK_Worker] PRIMARY KEY CLUSTERED 
(
	[WorkerNo] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Department](
	[DepartmentNo] [bigint] NOT NULL,
	[DepartmentName] [varchar](50) COLLATE Cyrillic_General_CI_AS NOT NULL,
 CONSTRAINT [PK_Department] PRIMARY KEY CLUSTERED 
(
	[DepartmentNo] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Post](
	[PostNo] [bigint] NOT NULL,
	[PostName] [varchar](300) COLLATE Cyrillic_General_CI_AS NOT NULL,
	[Salary] [decimal](20, 6) NOT NULL,
 CONSTRAINT [PK_Post] PRIMARY KEY CLUSTERED 
(
	[PostNo] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ExistWorker](
	[ExistWorkerNo] [bigint] NOT NULL,
	[WorcerNo] [bigint] NOT NULL,
	[DepartmentNo] [bigint] NOT NULL,
	[PostNo] [bigint] NOT NULL,
	[Dates] [datetime] NOT NULL,
 CONSTRAINT [PK_ExistWorker] PRIMARY KEY CLUSTERED 
(
	[ExistWorkerNo] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]