-- Tables

/***** Object:  Table [AKUZ].[T_FPUMP_STC_DEPARTMENT_MOVEMENT_KSG_DATA_ADDITIONAL_CRITERIA_KSLP_LINK] *****/
CREATE TABLE [AKUZ].[T_FPUMP_STC_DEPARTMENT_MOVEMENT_KSG_DATA_ADDITIONAL_CRITERIA_KSLP_LINK]
(
    [FpumpStcDepartmentMovementKsgDataAdditionalCriteriaKslpLinkID] uniqueidentifier NOT NULL,
    [FpumpStcDepartmentMovementKsgData] uniqueidentifier NOT NULL,
    [KslpDict] uniqueidentifier NOT NULL
)
ON [PRIMARY]
GO

-- Alters

ALTER TABLE [AKUZ].[T_FPUMP_STC_DEPARTMENT_MOVEMENT_KSG_DATA_ADDITIONAL_CRITERIA_KSLP_LINK] ADD CONSTRAINT [PK_T_FPUMP_STC_DEPARTMENT_MOVEMENT_KSG_DATA_ADDITIONAL_CRITERIA_KSLP_LINK]
PRIMARY KEY CLUSTERED ([FpumpStcDepartmentMovementKsgDataAdditionalCriteriaKslpLinkID]) ON [PRIMARY]
GO

ALTER TABLE [AKUZ].[T_FPUMP_STC_DEPARTMENT_MOVEMENT_KSG_DATA_ADDITIONAL_CRITERIA_KSLP_LINK] ADD CONSTRAINT [FK_T_FPUMP_STC_DEPARTMENT_MOVEMENT_KSG_DATA_T_FPUMP_ST_745773F5]
FOREIGN KEY([FpumpStcDepartmentMovementKsgData]) REFERENCES [AKUZ].[T_FPUMP_STC_DEPARTMENT_MOVEMENT_KSG_DATA] ([FpumpStcDepartmentMovementKsgDataID])
GO

ALTER TABLE [AKUZ].[T_FPUMP_STC_DEPARTMENT_MOVEMENT_KSG_DATA_ADDITIONAL_CRITERIA_KSLP_LINK] ADD CONSTRAINT [FK_T_KSLP_DICT_T_FPUMP_STC_DEPARTMENT_MOVEMENT_KSG_DATA_ADDITIONAL_CRITERIA_KSLP_LINK_KslpDict]
FOREIGN KEY([KslpDict]) REFERENCES [AKUZ].[T_KSLP_DICT] ([KslpDictID])
GO

