Сообщение об ошибке (Конфликт инструкции INSERT с ограничением)

CREATE DATABASE insuranceagency
ON
(NAME = 'insuranceagency-data',
FILENAME = 'D:\insuranceagency.mdf',
SIZE = 25,
MAXSIZE = 2000,
FILEGROWTH = 5)
log ON
(NAME = 'insuranceagency-log',
FILENAME = 'D:\insuranceagency.ldf',
SIZE = 25,
MAXSIZE = 2000,
FILEGROWTH = 5)
GO
USE insuranceagency
GO
CREATE TABLE Client 
([Id Client] INT PRIMARY KEY,
FCs VARCHAR(255) NOT NULL,
Passport VARCHAR(20) NOT NULL,
INN VARCHAR(12) NOT NULL, 
Telephone VARCHAR (20) NOT NULL,
Adress VARCHAR(100) NOT NULL)
GO
CREATE TABLE Experience
(Experience INT PRIMARY KEY,
Allowance INT NOT NULL CHECK (Allowance > 0))
GO
CREATE TABLE Agent
([Id Agent] INT PRIMARY KEY,
FCs VARCHAR(255) NOT NULL,
Telephone VARCHAR (20) NOT NULL,
Exerience INT FOREIGN KEY REFERENCES Experience([Experience]))
GO
CREATE TABLE [TYPE OF insurance]
([Id TYPE] INT PRIMARY KEY,
[Name TYPE] VARCHAR (50)NOT NULL)
GO
CREATE TABLE Branch
([Id branch] INT PRIMARY KEY,
[Address] VARCHAR(100) NOT NULL,
Telephone VARCHAR (20) NOT NULL,
Director VARCHAR(100)NOT NULL)
GO
CREATE TABLE Schedule
([Id Agent] INT FOREIGN KEY REFERENCES Agent ([Id agent]) ,
[Id Branch] INT FOREIGN KEY REFERENCES Branch([Id Branch]),
[DAY OF the week] VARCHAR(20) NOT NULL ,
[TIME] TIME NOT NULL,
Cabinet INT NOT NULL,
CONSTRAINT PK_Schedule PRIMARY KEY ([Id Agent],[Id Branch],[DAY OF the week]))
GO
CREATE TABLE [Object OF insurance]
([Id object] INT PRIMARY KEY,
[Name object] VARCHAR(100))
GO
CREATE TABLE [Insuranse CASE]
([Id CASE] INT PRIMARY KEY,
[ID TYPE] INT NOT NULL FOREIGN KEY REFERENCES [TYPE OF insurance]([Id TYPE]) ,
[Name TYPE] VARCHAR(100) NOT NULL,
[Payment(per YEAR)] DECIMAL NOT NULL)
GO
CREATE TABLE [Contract]
([Id Contract] INT PRIMARY KEY,
[ID Client] INT NOT NULL FOREIGN KEY REFERENCES Client([Id Client]),
[Id Agent] INT NOT NULL FOREIGN KEY REFERENCES Agent([Id Agent]),
[Id Insurance CASE] INT NOT NULL FOREIGN KEY REFERENCES [Insuranse CASE]([Id CASE]),
Payment DECIMAL NOT NULL,
[Id Object] INT NOT NULL  FOREIGN KEY REFERENCES [Object OF insurance]([Id Object]),
[DATE OF conclusion] DATE NOT NULL,
[Valid until(years)] INT NOT NULL,
[Contract form] VARCHAR(50) CHECK ([Contract form] IN ('mandatory','voluntary')) NOT NULL)
GO
CREATE TABLE Object_in_contract
([Id Contract] INT NOT NULL FOREIGN KEY REFERENCES [Contract]([Id Contract]),
[Id object] INT NOT NULL FOREIGN KEY REFERENCES [Object OF insurance] ([Id object]),
CONSTRAINT PK_Object_in_contract PRIMARY KEY ([Id Contract],[Id object]))
GO
CREATE TABLE Type_in_contract
([Id contract] INT NOT NULL FOREIGN KEY REFERENCES [Contract]([Id Contract]),
[Id TYPE] INT NOT NULL FOREIGN KEY REFERENCES [TYPE OF insurance]([Id TYPE]),
CONSTRAINT PK_Type_in_contract PRIMARY KEY ([Id Contract],[Id TYPE]))