CREATE TABLE [Тип основания] (
	[id] [int] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[Name] [nvarchar] ( 75 ) COLLATE Cyrillic_General_CS_AS NOT NULL ,
	CONSTRAINT [PK_Тип основания] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO
CREATE TABLE [Основание] (
	[id] [bigint] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[osn_type] [int] NOT NULL ,
	[date] [datetime] NOT NULL ,
	[insertdate] [timestamp] NOT NULL ,
	[Manager_id] [bigint] NOT NULL ,
	[Person_id] [bigint] NOT NULL ,
	[Vis_id] [bigint] NOT NULL ,
	CONSTRAINT [PK_Основание] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] ,
	CONSTRAINT [FK_Основание_Тип основания] FOREIGN KEY 
	(
		[osn_type]
	) REFERENCES [Тип основания] (
		[id]
	) ON DELETE CASCADE  ON UPDATE CASCADE 
) ON [PRIMARY]
GO
CREATE TABLE [TechMovies] (
	[id] [bigint] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[Tech_id] [bigint] NOT NULL ,
	[Quatity] [bigint] NOT NULL ,
	[TakerCode] [bigint] NOT NULL ,
	[StationCode] [bigint] NOT NULL ,
	[StatioName] [nvarchar] ( 100 ) COLLATE Cyrillic_General_CS_AS NOT NULL ,
	[TakerName] [nvarchar] ( 100 ) COLLATE Cyrillic_General_CS_AS NOT NULL ,
	[Osn_id] [bigint] NOT NULL ,
	[Date] [datetime] NOT NULL ,
	[Manager_id] [bigint] NOT NULL ,
	CONSTRAINT [PK_TechMovies] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] ,
	CONSTRAINT [FK_TechMovies_Основание] FOREIGN KEY 
	(
		[Osn_id]
	) REFERENCES [Основание] (
		[id]
	) ON DELETE CASCADE  ON UPDATE CASCADE 
) ON [PRIMARY]
GO

INSERT INTO dbo.[Тип основания]([Name])
VALUES(N'Договор поставки')

CREATE TABLE [Договор поставки] (
	[id] [bigint] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[osn_id] [int] NOT NULL ,
	[Sum] money not null ,  -- то что нельзя было сохранить в Основании для примера
 
	CONSTRAINT [PK_Основание] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] ,
	CONSTRAINT [FK_Основание_Тип основания] FOREIGN KEY 
	(
		[osn_id]
	) REFERENCES [Основание] (
		[id]
	) ON DELETE CASCADE  ON UPDATE CASCADE 
) ON [PRIMARY]