CREATE TABLE dbo.Agrees
(
  Agree_ID INT NOT NULL IDENTITY(1,1) NOT NULL PRIMARY KEY,
  AgreeNumber VARCHAR(50)NOT NULL,
  StartAgreeDate DATE NOT NULL,
  StopAgreeDate DATE NOT NULL,
  Contragent_ID INT NOT NULL

)

CREATE TABLE dbo.Agrees
(
  Agree_ID INT NOT NULL IDENTITY(1,1) NOT NULL PRIMARY KEY,
  AgreeNumber VARCHAR(50)NOT NULL,
  StartAgreeDate DATE NOT NULL,
  StopAgreeDate DATE NOT NULL,
  Contragent_ID INT NOT NULL,
  AgreeType_ID TINYINT NOT NULL

)

CREATE TABLE dbo.Agrees
(
  Agree_ID INT NOT NULL IDENTITY(1,1) NOT NULL PRIMARY KEY,
  AgreeNumber VARCHAR(50)NOT NULL,
  StartAgreeDate DATE NOT NULL,
  StopAgreeDate DATE NOT NULL,
  Contragent_ID INT NOT NULL

)

CREATE TABLE dbo.Analytics
(
  Analytic_ID SMALLINT NOT NULL IDENTITY(1,1)PRIMARY KEY,
  AnalyticDescription VARCHAR(100)NOT NULL
)

CREATE TABLE dbo.LinkAgreeAnalytic
(
  Link_ID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
  Agree_ID INT NOT NULL,
  Analytic_ID SMALLINT NOT NULL
)
ALTER TABLE dbo.LinkAgreeAnalytic ADD CONSTRAINT FK_LinkAgrAnalytAgree FOREIGN KEY(Agree_ID )
REFERENCES dbo.Agrees(Agree_ID);
ALTER TABLE dbo.LinkAgreeAnalytic ADD CONSTRAINT FK_LinkAgrAnalytAnalytic FOREIGN KEY(Analytic_ID)
REFERENCES dbo.Analytics(Analytic_ID)