-------------------------------Ali 2020-10-06---------------------

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1228, N'عرض متابعة الارصدة', N'View Balance Check', 3, 2)
Go
 -------------------------------End 2020-10-06---------------------
 -------------------------------Hammad 2020-10-14------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (379, N'Save Store Transaction Signature', N'حفظ إعتماد حركات المخازن', 357, N'/Inventory/StoreTransactionSignature', N'Save', N'fa fa-thumb-tack', N'get', 2, 0, 0)
GO
 -------------------------------End 2020-10-14------------------
 -------------------------------Ali 2020-10-14------------------


 ALTER TABLE dbo.WF_StoreTransactionRequests
	DROP CONSTRAINT FK_WF_StoreTransactionRequests_WF_Vendor
GO
ALTER TABLE dbo.WF_Vendor SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.WF_StoreTransactionRequests
	DROP CONSTRAINT FK_WF_StoreTransactionRequests_INV_Stores
GO
ALTER TABLE dbo.INV_Stores SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.WF_StoreTransactionRequests SET (LOCK_ESCALATION = TABLE)
GO


ALTER TABLE dbo.WF_StoreTransactionRequestsDetails
	DROP CONSTRAINT FK_WF_StoreTransactionRequestsDetails_INV_Items
GO
ALTER TABLE dbo.INV_Items SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.WF_StoreTransactionRequestsDetails SET (LOCK_ESCALATION = TABLE)
GO



ALTER TABLE dbo.WF_StoreTransactionRequestsDetails ADD
	ItemUnitCode int NULL
GO
 -------------------------------End 2020-10-14------------------
 -------------------------------Ali 2020-10-15------------------
CREATE TABLE [dbo].[AC_TransactionRelated](
	[TransactionRelatedID] [int] IDENTITY(1,1) NOT NULL,
	[TransactionCode] [int] NOT NULL,
	[TransactionRelatedCode] [int] NOT NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDateHijri] [nvarchar](10) NOT NULL,
	[CreationDate] [datetime] NOT NULL,
 CONSTRAINT [PK_AC_TransactionRelated] PRIMARY KEY CLUSTERED 
(
	[TransactionRelatedID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AC_TransactionRelated]  WITH CHECK ADD  CONSTRAINT [FK_AC_TransactionRelated_AC_Transaction] FOREIGN KEY([TransactionRelatedCode])
REFERENCES [dbo].[AC_Transaction] ([TransactionCode])
GO

ALTER TABLE [dbo].[AC_TransactionRelated] CHECK CONSTRAINT [FK_AC_TransactionRelated_AC_Transaction]
GO

ALTER TABLE [dbo].[AC_TransactionRelated]  WITH CHECK ADD  CONSTRAINT [FK_AC_TransactionRelated_AC_Transaction1] FOREIGN KEY([TransactionCode])
REFERENCES [dbo].[AC_Transaction] ([TransactionCode])
GO

ALTER TABLE [dbo].[AC_TransactionRelated] CHECK CONSTRAINT [FK_AC_TransactionRelated_AC_Transaction1]
GO
 -------------------------------End 2020-10-15------------------
 -------------------------------Ali 2020-10-18------------------

  INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (2133, N'ربط بمعاملات اخرى', N' Related with another Transactions', 16, 2)
  Go
 -------------------------------End 2020-10-18------------------
------------------------------- A.Khaled 2020-10-20 --------------------------    
USE [SST.ERP_Client]
GO

CREATE TABLE [dbo].[TablesRelations](
	[PrimarySchemaName] [varchar](50) NOT NULL,
	[PrimaryTableName] [varchar](150) NOT NULL,
	[PrimaryColumnName] [varchar](150) NOT NULL,
	[ForeignSchemaName] [varchar](50) NOT NULL,
	[ForeignTableName] [varchar](150) NOT NULL,
	[ForeignColumnName] [varchar](150) NOT NULL,
 CONSTRAINT [PK_TablesRelations] PRIMARY KEY CLUSTERED 
(
	[PrimarySchemaName] ASC,
	[PrimaryTableName] ASC,
	[PrimaryColumnName] ASC,
	[ForeignSchemaName] ASC,
	[ForeignTableName] ASC,
	[ForeignColumnName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

USE [SST.ERP_Client]
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AppraisalCategory', N'AppraisalCategoryCode', N'Appraisal', N'AppraisalCategoryDepartment', N'AppraisalCategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AppraisalCategory', N'AppraisalCategoryCode', N'Appraisal', N'AppraisalCategoryType', N'AppraisalCategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AppraisalCategory', N'AppraisalCategoryCode', N'Appraisal', N'AppraisalElementCategory', N'AppraisalCategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AppraisalCategory', N'AppraisalCategoryCode', N'Appraisal', N'DepartmentAppraisalElement', N'AppraisalCategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AppraisalCategory', N'AppraisalCategoryCode', N'Appraisal', N'DepartmentEvaluationCategory', N'AppraisalCategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AppraisalCategory', N'AppraisalCategoryCode', N'Appraisal', N'EmployeeEvaluationCategory', N'AppraisalCategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AppraisalCategory', N'AppraisalCategoryCode', N'Appraisal', N'EvaluationTypeCategory', N'AppraisalCategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AppraisalCategory', N'AppraisalCategoryCode', N'Appraisal', N'EvaluationTypeCategoryElements', N'AppraisalCategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AppraisalElement', N'AppraisalElementCode', N'Appraisal', N'AppraisalElementCategory', N'AppraisalElementCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AppraisalElement', N'AppraisalElementCode', N'Appraisal', N'AppraisalElementPosition', N'AppraisalElementCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AppraisalElement', N'AppraisalElementCode', N'Appraisal', N'AppraisalElementSection', N'AppraisalElementCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AppraisalElement', N'AppraisalElementCode', N'Appraisal', N'DepartmentAppraisalElementDetail', N'AppraisalElementCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AppraisalElement', N'AppraisalElementCode', N'Appraisal', N'EmployeeEvaluationItem', N'AppraisalElementCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AppraisalElement', N'AppraisalElementCode', N'Appraisal', N'EvaluationTypeCategoryElements', N'AppraisalElementCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AppraisalElementGroup', N'AppraisalElementGroupCode', N'Appraisal', N'AppraisalElement', N'AppraisalElementGroupCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AttendancePointSetup', N'AttendancePointSetupCode', N'Appraisal', N'AttendancePointMissingFingerprint', N'AttendancePointSetupCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AttendancePointSetup', N'AttendancePointSetupCode', N'Appraisal', N'AttendancePointPenalty', N'AttendancePointSetupCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AttendancePointSetup', N'AttendancePointSetupCode', N'Appraisal', N'AttendancePointShortAndLate', N'AttendancePointSetupCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AttendancePointSetup', N'AttendancePointSetupCode', N'Appraisal', N'AttendancePointTimePermission', N'AttendancePointSetupCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AttendancePointSetup', N'AttendancePointSetupCode', N'Appraisal', N'AttendancePointVacation', N'AttendancePointSetupCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'AttendancePointSetup', N'AttendancePointSetupCode', N'Appraisal', N'EvaluationTypeCategory', N'AttendancePointSetupCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'CalculationMethod', N'CalculationMethodCode', N'Appraisal', N'AppraisalCategory', N'CalculationMethodCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'CategoryType', N'CategoryTypeCode', N'Appraisal', N'AppraisalCategoryType', N'CategoryTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'DepartmentAppraisalElement', N'DepartmentAppraisalElementCode', N'Appraisal', N'DepartmentAppraisalElementDetail', N'DepartmentAppraisalElementCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'DepartmentEvaluation', N'DepartmentEvaluationCode', N'Appraisal', N'DepartmentEvaluationCategory', N'DepartmentEvaluationCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'DepartmentRelationship', N'DepartmentRelationshipCode', N'Appraisal', N'SectionRelationship', N'DepartmentRelationshipCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'EmployeeEvaluation', N'EmployeeEvaluationCode', N'Appraisal', N'EmployeeEvaluationCategory', N'EmployeeEvaluationCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'EmployeeEvaluationCategory', N'EmployeeEvaluationCategoryCode', N'Appraisal', N'EmployeeEvaluationItem', N'EmployeeEvaluationCategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'EvaluationPeriod', N'EvaluationPeriodCode', N'Appraisal', N'EmployeeEvaluation', N'EvaluationPeriodCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'EvaluationPeriod', N'EvaluationPeriodCode', N'Appraisal', N'EvaluationPeriodMonth', N'EvaluationPeriodCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'EvaluationType', N'EvaluationTypeCode', N'Appraisal', N'DepartmentEvaluation', N'EvaluationTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'EvaluationType', N'EvaluationTypeCode', N'Appraisal', N'EmployeeEvaluation', N'EvaluationTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'EvaluationType', N'EvaluationTypeCode', N'Appraisal', N'EvaluationPeriod', N'EvaluationTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'EvaluationType', N'EvaluationTypeCode', N'Appraisal', N'EvaluationRepeatDates', N'EvaluationTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'EvaluationType', N'EvaluationTypeCode', N'Appraisal', N'EvaluationTypeAllowedEvaluate', N'EvaluationTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'EvaluationType', N'EvaluationTypeCode', N'Appraisal', N'EvaluationTypeCategory', N'EvaluationTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'EvaluationType', N'EvaluationTypeCode', N'Appraisal', N'EvaluationTypeCategoryElements', N'EvaluationTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'EvaluationType', N'EvaluationTypeCode', N'Appraisal', N'EvaluationTypeEmployee', N'EvaluationTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'EvaluationType', N'EvaluationTypeCode', N'Appraisal', N'EvaluationTypeSetup', N'EvaluationTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Appraisal', N'SupervisorPrivilegeSection', N'SupervisorPrivilegeSectionCode', N'Appraisal', N'SupervisorPrivilegeEmployee', N'SupervisorPrivilegeSectionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Attendance', N'GroupPolicy', N'GroupPolicyCode', N'Attendance', N'ShiftType', N'GroupPolicyCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Attendance', N'Policy', N'PolicyCode', N'Attendance', N'PolicyComeEarly', N'PolicyCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Attendance', N'Policy', N'PolicyCode', N'Attendance', N'PolicyComeLate', N'PolicyCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Attendance', N'Policy', N'PolicyCode', N'Attendance', N'PolicyLeaveEarly', N'PolicyCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Attendance', N'Policy', N'PolicyCode', N'Attendance', N'PolicyOverTime', N'PolicyCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Attendance', N'Policy', N'PolicyCode', N'Attendance', N'PolicyWorkingOutWorkTime', N'PolicyCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Attendance', N'PolicyComeEarly', N'PolicyCode', N'Attendance', N'GroupPolicy', N'PolicyComeEarlyCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Attendance', N'PolicyComeLate', N'PolicyCode', N'Attendance', N'GroupPolicy', N'PolicyComeLateCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Attendance', N'PolicyLeaveEarly', N'PolicyCode', N'Attendance', N'GroupPolicy', N'PolicyLeaveEarlyCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Attendance', N'PolicyOverTime', N'PolicyCode', N'Attendance', N'GroupPolicy', N'PolicyOverTimeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Attendance', N'PolicyType', N'PolicyTypeCode', N'Attendance', N'Policy', N'PolicyTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Attendance', N'PolicyWorkingOutWorkTime', N'PolicyCode', N'Attendance', N'GroupPolicy', N'PolicyWorkingOutWorkTimeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Budget', N'BudgetActualCostTypes', N'BudgetActualCostTypeCode', N'Budget', N'BudgetActualCosts', N'BudgetActualCostTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Budget', N'BudgetHeads', N'BudgetHeadCode', N'Budget', N'BudgetItems', N'BudgetHeadCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Budget', N'BudgetHeads', N'BudgetHeadCode', N'Budget', N'BudgetNumericBudgets', N'BudgetHeadCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Budget', N'BudgetHeads', N'BudgetHeadCode', N'Budget', N'BudgetSalaryDetails', N'BudgetHeadCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Budget', N'BudgetItemCategory', N'BudgetItemCategoryCode', N'Budget', N'BudgetItems', N'BudgetItemCategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Budget', N'BudgetItems', N'BudgetItemCode', N'Budget', N'BudgetEmployeeDetails', N'BudgetItemCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Budget', N'BudgetItems', N'BudgetItemCode', N'Budget', N'BudgetExpectedEmployees', N'BudgetItemCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Budget', N'BudgetItems', N'BudgetItemCode', N'Budget', N'DifferentValues', N'BudgetItemCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Budget', N'BudgetNumericBudgets', N'BudgetNumericBudgetCode', N'Budget', N'BudgetExpectedEmployees', N'BudgetNumericBudgetCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Budget', N'DifferentValues', N'DifferentValueCode', N'Budget', N'BudgetEmployeeDetails', N'DifferentValueCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Budget', N'DifferentValues', N'DifferentValueCode', N'Budget', N'DifferentValueConditions', N'DifferentValueCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_ActionType', N'ActionTypeCode', N'dbo', N'AC_TransactionAuthority', N'ActionTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_ActionType', N'ActionTypeCode', N'dbo', N'AC_TransactionAuthorityImage', N'ActionTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_ActionType', N'ActionTypeCode', N'dbo', N'AC_TransactionReply', N'ActionTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Authority', N'AuthorityCode', N'dbo', N'AC_AuthorityDelegation', N'AuthorityCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Authority', N'AuthorityCode', N'dbo', N'AC_AuthorityDelegation', N'DelegatorAuthorityCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Authority', N'AuthorityCode', N'dbo', N'AC_Decision', N'AuthorityCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Authority', N'AuthorityCode', N'dbo', N'AC_DecisionAuthority', N'AuthorityCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Authority', N'AuthorityCode', N'dbo', N'AC_SecurityGroupExportAuthority', N'AuthorityCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Authority', N'AuthorityCode', N'dbo', N'AC_SecurityUserExportAuthority', N'AuthorityCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Authority', N'AuthorityCode', N'dbo', N'AC_Transaction', N'AuthorityCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Authority', N'AuthorityCode', N'dbo', N'AC_TransactionAuthority', N'AuthorityCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Authority', N'AuthorityCode', N'dbo', N'AC_TransactionAuthorityImage', N'AuthorityCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Authority', N'AuthorityCode', N'dbo', N'AC_TransactionHistory', N'AuthorityExportCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Authority', N'AuthorityCode', N'dbo', N'AC_TransactionHistory', N'AuthorityReleaseCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Authority', N'AuthorityCode', N'dbo', N'AC_TransactionReply', N'AuthorityCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Authority', N'AuthorityCode', N'dbo', N'AC_TransactionReply', N'ExportAuthorityCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Authority', N'AuthorityCode', N'dbo', N'AC_TransactionReply', N'RecommendedAuthorityCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Authority', N'AuthorityCode', N'dbo', N'SecurityUserAuthority', N'AuthorityCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Decision', N'DecisionCode', N'dbo', N'AC_DecisionAuthority', N'DecisionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Decision', N'DecisionCode', N'dbo', N'AC_DecisionFile', N'DecisionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Decision', N'DecisionCode', N'dbo', N'AC_DecisionLocation', N'DecisionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_DecisionType', N'DecisionTypeCode', N'dbo', N'AC_Decision', N'DecisionTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_EmpTransaction', N'EmpTransactionCode', N'dbo', N'AC_EmpTransactionFile', N'EmpTransactionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_EmpTransaction', N'EmpTransactionCode', N'dbo', N'AC_EmpTransactionHistory', N'EmpTransactionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_EmpTransaction', N'EmpTransactionCode', N'dbo', N'AC_Transaction', N'EmpTransactionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_EmpTransactionStatus', N'EmpTransactionStatusCode', N'dbo', N'AC_EmpTransaction', N'EmpTransactionStatusCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_EmpTransactionStatus', N'EmpTransactionStatusCode', N'dbo', N'AC_EmpTransactionHistory', N'EmpTransactionStatusCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_PriorityDegree', N'PriorityDegreeCode', N'dbo', N'AC_EmpTransaction', N'PriorityDegreeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_PriorityDegree', N'PriorityDegreeCode', N'dbo', N'AC_Transaction', N'PriorityDegreeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Track', N'TrackCode', N'dbo', N'AC_EmployeeTrack', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Track', N'TrackCode', N'dbo', N'AC_EmpTransaction', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Track', N'TrackCode', N'dbo', N'AC_TrackDetail', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Transaction', N'TransactionCode', N'dbo', N'AC_TransactionAuthority', N'TransactionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Transaction', N'TransactionCode', N'dbo', N'AC_TransactionAuthorityImage', N'TransactionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Transaction', N'TransactionCode', N'dbo', N'AC_TransactionFile', N'TransactionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Transaction', N'TransactionCode', N'dbo', N'AC_TransactionHistory', N'TransactionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Transaction', N'TransactionCode', N'dbo', N'AC_TransactionLocation', N'TransactionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Transaction', N'TransactionCode', N'dbo', N'AC_TransactionNotes', N'TransactionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Transaction', N'TransactionCode', N'dbo', N'AC_TransactionRelated', N'TransactionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Transaction', N'TransactionCode', N'dbo', N'AC_TransactionRelated', N'TransactionRelatedCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_Transaction', N'TransactionCode', N'dbo', N'AC_TransactionReply', N'TransactionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_TransactionReply', N'TransactionReplyCode', N'dbo', N'AC_TransactionHistory', N'TransactionReplyCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_TransactionReply', N'TransactionReplyCode', N'dbo', N'AC_TransactionReplyFile', N'TransactionReplyCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_TransactionStatus', N'TransactionStatusCode', N'dbo', N'AC_Transaction', N'TransactionStatusCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_TransactionStatus', N'TransactionStatusCode', N'dbo', N'AC_TransactionHistory', N'TransactionStatusCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_TransactionStatus', N'TransactionStatusCode', N'dbo', N'AC_TransactionReply', N'ReplyStatusCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_TransactionTemplate', N'TransactionTemplateCode', N'dbo', N'AC_SecurityUserTemplate', N'TransactionTemplateCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_TransactionType', N'TransactionTypeCode', N'dbo', N'AC_EmployeeTrack', N'TransactionTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_TransactionType', N'TransactionTypeCode', N'dbo', N'AC_EmpTransaction', N'TransactionTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_TransactionType', N'TransactionTypeCode', N'dbo', N'AC_SecurityGroupTransType', N'TransactionTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_TransactionType', N'TransactionTypeCode', N'dbo', N'AC_SecurityUserTransType', N'TransactionTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AC_TransactionType', N'TransactionTypeCode', N'dbo', N'AC_Track', N'TransactionTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Airlines', N'AirlineCode', N'dbo', N'WF_AirTicketRequest', N'BackAirlineCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Airlines', N'AirlineCode', N'dbo', N'WF_AirTicketRequest', N'GoingAirlineCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AirlinesCompany', N'AirlinesCompanyCode', N'dbo', N'WF_AirTicketOffer', N'AirlinesCompanyCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AirTicketCondition', N'AirTicketConditionCode', N'dbo', N'WF_AirTicketRequest', N'AirTicketConditionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AppModule', N'AppModuleCode', N'dbo', N'ConfigCategoryModule', N'AppModuleCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AppModule', N'AppModuleCode', N'dbo', N'EmailTemplateType', N'AppModuleCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'AppModule', N'AppModuleCode', N'dbo', N'SystemMenuModule', N'AppModuleCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Arc_Folder', N'FolderCode', N'dbo', N'Arc_File', N'FolderCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Arc_Folder', N'FolderCode', N'dbo', N'Arc_Folder', N'ParentID')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Basis', N'BandCode', N'dbo', N'WF_BonusType', N'BandCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Basis', N'BandCode', N'dbo', N'WF_MonthlyEffectsRequest', N'BandCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Basis', N'BandCode', N'dbo', N'WF_PromotionRequestDetail', N'BandCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Basis', N'BandCode', N'dbo', N'WF_SalaryDetail', N'BandCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Branch', N'BranchCode', N'dbo', N'SecurityUserBranch', N'BranchCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'CandidacySetup', N'CandidacySetupCode', N'dbo', N'CandidacySetupMonth', N'CandidacySetupCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'CandidacySetup', N'CandidacySetupCode', N'dbo', N'EmployeeCandidacy', N'CandidacySetupCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'CandidacySetup', N'CandidacySetupCode', N'dbo', N'VoteSettings', N'CandidacySetupCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'CandidacyTypes', N'CandidacyTypeCode', N'dbo', N'CandidacySetup', N'CandidacyTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'CandidacyTypes', N'CandidacyTypeCode', N'dbo', N'CandidacyTypeDetails', N'CandidacyTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'CandidacyTypes', N'CandidacyTypeCode', N'dbo', N'CandidacyTypePenalty', N'CandidacyTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'CandidatesTypes', N'CandidatesTypeCode', N'dbo', N'CandidacyTypeDetails', N'CandidatesTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'City', N'CityCode', N'dbo', N'Rec_RecruitEmployee', N'CityCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'City', N'CityCode', N'dbo', N'Rec_WorkSite', N'CityCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Condition', N'ConditionCode', N'dbo', N'PositionCondition', N'ConditionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'ConditionCategory', N'ConditioncategoryCode', N'dbo', N'Condition', N'ConditioncategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'ConfigCategory', N'ConfigCategoryCode', N'dbo', N'ConfigCategoryModule', N'ConfigCategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'ConfigCategory', N'ConfigCategoryCode', N'dbo', N'ConfigParameter', N'ConfigCategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'ConfigParameter', N'ConfigKey', N'dbo', N'ConfigLookup', N'ConfigKey')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'CostCenter', N'CostCenter', N'dbo', N'WF_MonthlyEffectsRequest', N'CostCenter')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Country', N'CountryCode', N'dbo', N'City', N'CountryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Country', N'CountryCode', N'dbo', N'Rec_RecruitEmployee', N'CountryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Country', N'CountryCode', N'dbo', N'Rec_RecruitEmployeeEducation', N'CountryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Country', N'CountryCode', N'dbo', N'Rec_WorkSite', N'CountryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Currencies', N'CurrencyCode', N'dbo', N'WF_CasualRequest', N'CurrencyCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Currencies', N'CurrencyCode', N'dbo', N'WF_SalaryDetail', N'CurrencyCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Departments', N'DepartmentCode', N'dbo', N'EmployeeCandidacy', N'DepartmentCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Departments', N'DepartmentCode', N'dbo', N'Sections', N'DepartmentCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Departments', N'DepartmentCode', N'dbo', N'WF_PromotionRequest', N'DepartmentCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Departments', N'DepartmentCode', N'dbo', N'WF_TransferRequest', N'NewDepartmentCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Departments', N'DepartmentCode', N'dbo', N'WF_TransferRequest', N'OldDepartmentCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Divisions', N'DivisionCode', N'dbo', N'Departments', N'DivisionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Divisions', N'DivisionCode', N'dbo', N'WF_PromotionRequest', N'DivisionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Divisions', N'DivisionCode', N'dbo', N'WF_TransferRequest', N'NewDivisionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Divisions', N'DivisionCode', N'dbo', N'WF_TransferRequest', N'OldDivisionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'EducationStatus', N'EducationStatusCode', N'dbo', N'Rec_RecruitEmployeeEducation', N'EducationStatusCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'EmailTemplate', N'EmailTemplateCode', N'dbo', N'EmailTemplateLevel', N'EmailTemplateCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'EmailTemplateType', N'EmailTemplateTypeCode', N'dbo', N'AC_SecurityUserTemplate', N'EmailTemplateTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'EmailTemplateType', N'EmailTemplateTypeCode', N'dbo', N'AC_TransactionTemplate', N'EmailTemplateTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'EmailTemplateType', N'EmailTemplateTypeCode', N'dbo', N'EmailTemplate', N'EmailTemplateTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'EmailTemplateType', N'EmailTemplateTypeCode', N'dbo', N'EmailTemplateLevel', N'EmailTemplateTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'EmailTemplateType', N'EmailTemplateTypeCode', N'dbo', N'Notification', N'NotificationTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'EmailTemplateType', N'EmailTemplateTypeCode', N'dbo', N'SecurityUserEmailNotification', N'EmailTemplateTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Emp_Delegation', N'DelegationId', N'dbo', N'Emp_DelegationDetail', N'DelegationId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'EmployeeCandidacy', N'EmployeeCandidacyID', N'dbo', N'EmployeeCandidacyQuality', N'EmployeeCandidacyID')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'EmployeeCandidacy', N'EmployeeCandidacyID', N'dbo', N'VotingCandidate', N'EmployeeCandidacyID')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'AC_EmployeeTrack', N'EmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'AC_EmpTransaction', N'EmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'Emp_Delegation', N'DelegatorId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'Emp_Delegation', N'EmployeeId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'EmployeeCandidacy', N'EmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'EmployeesExtend', N'EmployeeExtendCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'SecurityUser', N'EmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'SecurityUserEmployee', N'EmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'WF_AirTicketRequest', N'EmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'WF_BonusRequest', N'EmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'WF_ChangeDayoffRequest', N'EmployeeId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'WF_CompensationRequestForADayOfRest', N'EmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'WF_EmployeeTrack', N'EmployeeId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'WF_FingerPrintRequest', N'EmployeeId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'WF_GeneralRequest', N'EmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'WF_LoanRequest', N'EmployeeId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'WF_MasterRequests', N'EmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'WF_OtherEmployeeTrack', N'EmployeeId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'WF_OverTimeSymphonyRequest', N'EmployeeId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'WF_PenaltyRequest', N'EmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'WF_PermissionRequest', N'EmployeeId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'WF_PromotionRequest', N'EmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'WF_ResignationRequest', N'EmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'WF_StaffReplacement', N'EmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'WF_VacationRequest', N'EmployeeId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Employees', N'EmployeeCode', N'dbo', N'WF_VehicleRequest', N'EmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Event', N'EventCode', N'dbo', N'EventEmployee', N'EventCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Event', N'EventCode', N'dbo', N'EventSection', N'EventCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'ForeignerUser', N'ForeignerUserCode', N'dbo', N'ForeignerAuditAction', N'ForeignerUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'ForeignerUser', N'ForeignerUserCode', N'dbo', N'Rec_ApplyForJob', N'ForeignerUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'ForeignerUser', N'ForeignerUserCode', N'dbo', N'Rec_JobApplyingStages', N'ForeignerUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'ForeignerUser', N'ForeignerUserCode', N'dbo', N'Rec_JobOffer', N'ForeignerUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'ForeignerUser', N'ForeignerUserCode', N'dbo', N'Rec_RecruitEmployee', N'ForeignerUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'ForeignerUser', N'ForeignerUserCode', N'dbo', N'Rec_RecruitJobAnswer', N'ForeignerUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Grade', N'GradeCode', N'dbo', N'Rec_RecruitEmployeeEducation', N'GradeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'INV_ItemCategories', N'CategoryCode', N'dbo', N'INV_Items', N'CategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'INV_Items', N'ItemCode', N'dbo', N'INV_StoreItemsData', N'ItemCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'INV_ItemTypes', N'ItemTypeCode', N'dbo', N'INV_Items', N'ItemTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'INV_ItemUnits', N'UnitCode', N'dbo', N'INV_Items', N'UnitCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'INV_Stores', N'StoreCode', N'dbo', N'INV_StoreItemsData', N'StoreCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Levels', N'LevelCode', N'dbo', N'EmailTemplateLevel', N'LevelCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Levels', N'LevelCode', N'dbo', N'WF_MissionPlaceLevel', N'LevelCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Levels', N'LevelCode', N'dbo', N'WF_PromotionRequest', N'LevelCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Location', N'LocationCode', N'dbo', N'AC_Authority', N'LocationCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Location', N'LocationCode', N'dbo', N'AC_Decision', N'LocationCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Location', N'LocationCode', N'dbo', N'AC_DecisionLocation', N'LocationCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Location', N'LocationCode', N'dbo', N'AC_EmpTransaction', N'LocationCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Location', N'LocationCode', N'dbo', N'AC_Transaction', N'LocationCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Location', N'LocationCode', N'dbo', N'AC_TransactionLocation', N'LocationCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Location', N'LocationCode', N'dbo', N'Employees', N'LocationCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Location', N'LocationCode', N'dbo', N'Location', N'LocationCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Location', N'LocationCode', N'dbo', N'Rec_WorkSite', N'LocationCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Location', N'LocationCode', N'dbo', N'SecurityUserEmployee', N'LocationCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Location', N'LocationCode', N'dbo', N'SecurityUserLocation', N'LocationCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Location', N'LocationCode', N'dbo', N'SecurityUserSection', N'LocationCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Location', N'LocationCode', N'dbo', N'WF_PromotionRequest', N'LocationCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'MaritalStatus', N'MaritalCode', N'dbo', N'Rec_RecruitEmployee', N'MaritalCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Military', N'MilitaryCode', N'dbo', N'Rec_RecruitEmployee', N'MilitaryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Nationality', N'NationalityCode', N'dbo', N'Rec_RecruitEmployee', N'NationalityCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Notification', N'NotificationCode', N'dbo', N'NotificationUser', N'NotificationCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'OrganizationCategory', N'OrganizationCategoryCode', N'dbo', N'OrganizationStructure', N'OrganizationCategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'OrganizationGroup', N'OrganizationGroupCode', N'dbo', N'OrganizationStructureAndGroups', N'OrganizationGroupCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'OrganizationStructure', N'OrganizationStructureId', N'dbo', N'OrganizationStructureAndGroups', N'OrganizationStructureId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'PenaltiesList', N'PenaltyCode', N'dbo', N'WF_PenaltyRequest', N'PenaltyCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'PenaltyCategories', N'PenaltyCategoryCode', N'dbo', N'CandidacyTypePenalty', N'PenaltyCategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'PenaltyCategories', N'PenaltyCategoryCode', N'dbo', N'WF_BonusTypePenalty', N'PenaltyCategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'PositionCondition', N'PositionConditionCode', N'dbo', N'WF_MasterRequestsCondition', N'PositionConditionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'PositionCondition', N'PositionConditionCode', N'dbo', N'WF_NewHireRequestCondition', N'PositionConditionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'PositionCondition', N'PositionConditionCode', N'dbo', N'WF_PromotionRequestCondition', N'PositionConditionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Positions', N'PositionCode', N'dbo', N'PositionCondition', N'PositionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Positions', N'PositionCode', N'dbo', N'Rec_RecruitEmployeeExperiance', N'PositionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Positions', N'PositionCode', N'dbo', N'WF_CasualRequestSection', N'PositionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Positions', N'PositionCode', N'dbo', N'WF_NewEmployeesRequest', N'PositionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Positions', N'PositionCode', N'dbo', N'WF_OverTimeSymphonyRequest', N'PositionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Positions', N'PositionCode', N'dbo', N'WF_PromotionRequest', N'PositionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Positions', N'PositionCode', N'dbo', N'WF_TransferRequest', N'NewPositionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Positions', N'PositionCode', N'dbo', N'WF_TransferRequest', N'OldPositionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'PromotionReasons', N'PromotionReasonCode', N'dbo', N'WF_PromotionRequest', N'PromotionReasonCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'QualityStandard', N'QualityStandardCode', N'dbo', N'EmployeeCandidacyQuality', N'QualityStandardCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_ApplyForJob', N'ApplyForJobCode', N'dbo', N'Rec_HirinigDetails', N'ApplyForJobCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_CompanyDomain', N'CompanyDomainCode', N'dbo', N'Rec_RecruitEmployeeExperiance', N'CompanyDomainCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_CompanySize', N'CompanySizeCode', N'dbo', N'Rec_RecruitEmployeeExperiance', N'CompanySizeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_ContactType', N'ContactTypeCode', N'dbo', N'Rec_RecruitEmployeeContact', N'ContactTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_EvaluationInterviewStage', N'EvaluationInterviewStageCode', N'dbo', N'Rec_JobApplyingStageEvaluation', N'EvaluationInterviewStageCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_EvaluationParameter', N'EvaluationParameterCode', N'dbo', N'Rec_EvaluationInterviewStage', N'EvaluationParameterCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_JobApplyingStageDetail', N'JobApplyingStageDetailCode', N'dbo', N'Rec_JobApplyingStageEvaluation', N'JobApplyingStageDetailCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_JobApplyingStages', N'JobApplyingStageCode', N'dbo', N'Rec_JobApplyingStageDetail', N'JobApplyingStageCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_JobCategory', N'JobCategoryCode', N'dbo', N'Positions', N'JobCategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_JobOffer', N'JobOfferCode', N'dbo', N'Rec_JobOfferDetail', N'JobOfferCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_JobOfferParameter', N'JobOfferParameterCode', N'dbo', N'Rec_JobOfferDetail', N'JobOfferParameterCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_JobOfferParameter', N'JobOfferParameterCode', N'dbo', N'Rec_RecruitJobOfferParameter', N'JobOfferParameterCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_JobRole', N'JobRoleCode', N'dbo', N'Rec_RecruitJob', N'JobRoleCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_JobType', N'JobTypeCode', N'dbo', N'Rec_RecruitJob', N'JobTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_PersonalInterviewStages', N'PersonalInterviewStageCode', N'dbo', N'Rec_ApplyForJob', N'PersonalInterviewStageCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_PersonalInterviewStages', N'PersonalInterviewStageCode', N'dbo', N'Rec_EvaluationInterviewStage', N'PersonalInterviewStageCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_PersonalInterviewStages', N'PersonalInterviewStageCode', N'dbo', N'Rec_JobApplyingStages', N'PersonalInterviewStageCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_PersonalInterviewStages', N'PersonalInterviewStageCode', N'dbo', N'Rec_RecruitJobStages', N'PersonalInterviewStageCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_QuestionTemplate', N'QuestionTemplateCode', N'dbo', N'Rec_ClosedAnswer', N'QuestionTemplateCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_QuestionTemplate', N'QuestionTemplateCode', N'dbo', N'Rec_DateRangeAnswer', N'QuestionTemplateCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_QuestionTemplate', N'QuestionTemplateCode', N'dbo', N'Rec_MultiChoiceAnswer', N'QuestionTemplateCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_QuestionTemplate', N'QuestionTemplateCode', N'dbo', N'Rec_NumRangeAnswer', N'QuestionTemplateCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_QuestionTemplate', N'QuestionTemplateCode', N'dbo', N'Rec_RecruitJobAnswer', N'QuestionTemplateCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_QuestionTemplate', N'QuestionTemplateCode', N'dbo', N'Rec_RecruitJobQuestion', N'QuestionTemplateCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_QuestionType', N'QuestionTypeCode', N'dbo', N'Rec_QuestionTemplate', N'QuestionTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_ReasonsRejectHiring', N'RejectHiringCode', N'dbo', N'Rec_HirinigDetails', N'RejectHiringCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_RecruitEmployee', N'RecruitEmployeeCode', N'dbo', N'Rec_RecruitEmployeeCertificate', N'RecruitEmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_RecruitEmployee', N'RecruitEmployeeCode', N'dbo', N'Rec_RecruitEmployeeContact', N'RecruitEmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_RecruitEmployee', N'RecruitEmployeeCode', N'dbo', N'Rec_RecruitEmployeeEducation', N'RecruitEmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_RecruitEmployee', N'RecruitEmployeeCode', N'dbo', N'Rec_RecruitEmployeeExperiance', N'RecruitEmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_RecruitEmployee', N'RecruitEmployeeCode', N'dbo', N'Rec_RecruitEmployeeReference', N'RecruitEmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_RecruitEmployee', N'RecruitEmployeeCode', N'dbo', N'Rec_RecruitEmployeeSkill', N'RecruitEmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_RecruitEmployee', N'RecruitEmployeeCode', N'dbo', N'Rec_RecruitEmployeeTraining', N'RecruitEmployeeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_RecruitJob', N'RecruitJobCode', N'dbo', N'Rec_ApplyForJob', N'RecruitJobCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_RecruitJob', N'RecruitJobCode', N'dbo', N'Rec_JobApplyingStages', N'RecruitJobCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_RecruitJob', N'RecruitJobCode', N'dbo', N'Rec_JobOffer', N'RecruitJobCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_RecruitJob', N'RecruitJobCode', N'dbo', N'Rec_RecruitJobAnswer', N'RecruitJobCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_RecruitJob', N'RecruitJobCode', N'dbo', N'Rec_RecruitJobOfferParameter', N'RecruitJobCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_RecruitJob', N'RecruitJobCode', N'dbo', N'Rec_RecruitJobQuestion', N'RecruitJobCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_RecruitJob', N'RecruitJobCode', N'dbo', N'Rec_RecruitJobStages', N'RecruitJobCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_SkillLevel', N'SkillLevelCode', N'dbo', N'Rec_RecruitEmployeeSkill', N'SkillLevelCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Rec_VisaStatus', N'VisaStatusCode', N'dbo', N'Rec_RecruitEmployee', N'VisaStatusCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'ResignationReasons', N'ResignationCode', N'dbo', N'WF_ResignationRequest', N'ResignationCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Sections', N'SectionCode', N'dbo', N'EmployeeCandidacy', N'SectionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Sections', N'SectionCode', N'dbo', N'Employees', N'SectionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Sections', N'SectionCode', N'dbo', N'SecurityUserSection', N'SectionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Sections', N'SectionCode', N'dbo', N'WF_CasualRequestSection', N'SectionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Sections', N'SectionCode', N'dbo', N'WF_OverTimeSymphonyRequest', N'SectionCodeRequest')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Sections', N'SectionCode', N'dbo', N'WF_PromotionRequest', N'SectionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Sections', N'SectionCode', N'dbo', N'WF_TransferRequest', N'NewSectionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'Sections', N'SectionCode', N'dbo', N'WF_TransferRequest', N'OldSectionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityGroup', N'SecurityGroupCode', N'dbo', N'AC_SecurityGroupExportAuthority', N'SecurityGroupCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityGroup', N'SecurityGroupCode', N'dbo', N'AC_SecurityGroupLevel', N'SecurityGroupCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityGroup', N'SecurityGroupCode', N'dbo', N'AC_SecurityGroupTransType', N'SecurityGroupCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityGroup', N'SecurityGroupCode', N'dbo', N'SecurityGroupDetail', N'SecurityGroupID')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityGroup', N'SecurityGroupCode', N'dbo', N'SecurityUser', N'SecurityGroupCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityPrivilege', N'ID', N'dbo', N'SecurityPrivilegeActions', N'SecurityPrivilegeID')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_AuthorityDelegation', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_AuthorityDelegation', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_Decision', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_Decision', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_DecisionAuthority', N'RecievedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_EmpTransaction', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_EmpTransaction', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_EmpTransactionHistory', N'FromUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_EmpTransactionHistory', N'ToUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_SecurityUserExportAuthority', N'SecurityUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_SecurityUserLevel', N'SecurityUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_SecurityUserTemplate', N'SecurityUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_SecurityUserTransType', N'SecurityUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_Transaction', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_Transaction', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_TransactionAuthority', N'RecievedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_TransactionHistory', N'ChangedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_TransactionHistory', N'RecievedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_TransactionNotes', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_TransactionReply', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AC_TransactionReply', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'Arc_Folder', N'UserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AuditAction', N'UserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'AuditData', N'UserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'CompanyRegulation', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'ConfigParameter', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'Notification', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'NotificationUser', N'UserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'OrgStructureUserEmployee', N'SecurityUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'OrgStructureUserPrivilege', N'SecurityUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'Rec_EvaluationParameter', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'Rec_EvaluationParameter', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'Rec_JobApplyingStageDetail', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'Rec_JobApplyingStageDetail', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'Rec_JobOfferParameter', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'Rec_JobOfferParameter', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'SecurityLoginLog', N'SecurityUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'SecurityUserAuthority', N'SecurityUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'SecurityUserBranch', N'SecurityUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'SecurityUserDetail', N'SecurityUserID')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'SecurityUserEmailNotification', N'SecurityUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'SecurityUserEmployee', N'SecurityUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'SecurityUserFavoriteMenu', N'SecurityUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'SecurityUserLocation', N'SecurityUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'SecurityUserSection', N'SecurityUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'VotingCandidate', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_AirTicketRequest', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_AirTicketRequest', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_AirTicketRequestSignature', N'UserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_BonusRequest', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_BonusRequest', N'HRApprovalUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_BonusRequest', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_BonusRequestSignature', N'UserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_CasualRequest', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_CasualRequest', N'HRApprovalUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_CasualRequest', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_CasualRequestSignature', N'UserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_ChangeDayoffRequest', N'RecordAddBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_ChangeDayoffRequest', N'RecordLastChangeBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_ChangeDayoffRequestSignature', N'UserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_CompensationRequestFinalDayRestSignature', N'UserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_CompensationRequestForADayOfRest', N'HRApprovalUserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_CompensationRequestForADayOfRest', N'RecordAddBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_CompensationRequestForADayOfRest', N'RecordLastChangeBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_CompensationRequestForADayOfRestSignature', N'UserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_DisclaimerRequestSignature', N'UserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_FingerPrintRequest', N'RecordAddBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_FingerPrintRequest', N'RecordLastChangeBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_FingerPrintRequestSignature', N'UserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_GeneralRequest', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_GeneralRequest', N'HRApprovalUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_GeneralRequest', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_GeneralRequestSignature', N'UserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_LoanRequest', N'HRApprovalUserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_LoanRequest', N'RecordAddBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_LoanRequest', N'RecordLastChangeBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_LoanRequestSignature', N'UserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_MaintenanceRequest', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_MaintenanceRequest', N'HRApprovalUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_MaintenanceRequest', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_MaintenanceRequestSignature', N'UserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_MasterRequests', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_MasterRequests', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_MasterRequestsSignature', N'UserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_NewEmployeesRequest', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_NewEmployeesRequest', N'HRApprovalUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_NewEmployeesRequest', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_NewEmployeesRequestSignature', N'UserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_NewHireRequest', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_NewHireRequest', N'HRApprovalUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_NewHireRequest', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_NewHireRequestSignature', N'UserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_OverTimeRequestFinalSignature', N'UserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_OverTimeRequestSignature', N'UserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_OverTimeSymphonyRequest', N'HRApprovalUserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_OverTimeSymphonyRequest', N'RecordAddBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_OverTimeSymphonyRequest', N'RecordLastChangeBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_OverTimeSymphonyRequestSignature', N'UserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_PenaltyRequest', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_PenaltyRequest', N'HRApprovalUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_PenaltyRequest', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_PenaltyRequestSignature', N'UserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_PermissionRequest', N'AddBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_PermissionRequest', N'HRApprovalUserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_PermissionRequest', N'LastChangeBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_PermissionRequestSignature', N'UserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_PromotionRequest', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_PromotionRequest', N'HRApprovalUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_PromotionRequest', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_PromotionRequestSignature', N'UserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_PurchasesRequest', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_PurchasesRequest', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_PurchasesRequestSignature', N'UserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_RequisitionFormRequest', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_RequisitionFormRequest', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_RequisitionFormRequestSignature', N'UserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_ResignationRequest', N'CreatedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_ResignationRequest', N'HRApprovalUserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_ResignationRequest', N'ModifiedBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_ResignationRequestSignature', N'UserCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_TrackDetail', N'UserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_UserTrackNotification', N'UserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_VacationRequest', N'AddBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_VacationRequest', N'HRApprovalUserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_VacationRequestSignature', N'UserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_VehicleRequest', N'RecordAddBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_VehicleRequest', N'RecordLastChangeBy')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SecurityUser', N'SecurityUserCode', N'dbo', N'WF_VehicleRequestSignature', N'UserId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SystemMenu', N'SystemMenuCode', N'dbo', N'AuditAction', N'MenuCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SystemMenu', N'SystemMenuCode', N'dbo', N'SecurityPrivilege', N'SystemMenuCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SystemMenu', N'SystemMenuCode', N'dbo', N'SecurityUser', N'DefaultMenuCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SystemMenu', N'SystemMenuCode', N'dbo', N'SecurityUserFavoriteMenu', N'SystemMenuCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SystemMenu', N'SystemMenuCode', N'dbo', N'SystemMenu', N'ParentID')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'SystemMenu', N'SystemMenuCode', N'dbo', N'SystemMenuModule', N'SystemMenuCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'TimePermissionsKinds', N'ComeLateOrOutEarly', N'dbo', N'WF_PermissionRequest', N'ComeLateOrOutEarly')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'TimePermissionsTypes', N'TimePermissionCode', N'dbo', N'WF_PermissionRequest', N'TimePermissionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'UserType', N'UserTypeCode', N'dbo', N'AC_EmpTransaction', N'UserTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'UserType', N'UserTypeCode', N'dbo', N'AC_SecurityGroupLevel', N'UserTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'UserType', N'UserTypeCode', N'dbo', N'AC_SecurityUserLevel', N'UserTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'UserType', N'UserTypeCode', N'dbo', N'AC_TrackDetail', N'UserTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'UserType', N'UserTypeCode', N'dbo', N'SecurityUser', N'UserTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'UserType', N'UserTypeCode', N'dbo', N'WF_TrackDetail', N'UserTypeId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'VacationType', N'VacationCode', N'dbo', N'WF_VacationRequest', N'VacationTypeId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'VacationType', N'VacationCode', N'dbo', N'WF_VacationRequestDetail', N'VacationCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'VoteSettings', N'VoteSettingID', N'dbo', N'VotingCandidate', N'VoteSettingID')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_AirTicketOffer', N'AirTicketOfferCode', N'dbo', N'WF_AirTicketOfferFile', N'AirTicketOfferCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_AirTicketRequest', N'AirTicketRequestCode', N'dbo', N'WF_AirTicketOffer', N'AirTicketRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_AirTicketRequest', N'AirTicketRequestCode', N'dbo', N'WF_AirTicketRequest', N'CancelRequestNumber')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_AirTicketRequest', N'AirTicketRequestCode', N'dbo', N'WF_AirTicketRequestSignature', N'AirTicketRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_BonusRequest', N'BonusRequestCode', N'dbo', N'WF_BonusRequestSignature', N'BonusRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_BonusType', N'BonusTypeCode', N'dbo', N'WF_BonusesRequest', N'BonusTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_BonusType', N'BonusTypeCode', N'dbo', N'WF_BonusTypePenalty', N'BonusTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_CasualRequest', N'CasualRequestCode', N'dbo', N'WF_CasualRequest', N'CancelRequestNumber')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_CasualRequest', N'CasualRequestCode', N'dbo', N'WF_CasualRequestSection', N'CasualRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_CasualRequest', N'CasualRequestCode', N'dbo', N'WF_CasualRequestSignature', N'CasualRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_ChangeDayoffRequest', N'ChangeDayoffRequestId', N'dbo', N'WF_ChangeDayoffRequestSignature', N'ChangeDayoffRequestId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_CompensationAllowanceTypes', N'CompensationAllowanceTypeCode', N'dbo', N'WF_CompensationRequestForADayOfRest', N'CompensationAllowanceTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_CompensationRequestForADayOfRest', N'CompensationRequestForADayOfRestId', N'dbo', N'WF_CompensationRequestFinalDayRestSignature', N'CompensationRequestForADayOfRestId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_CompensationRequestForADayOfRest', N'CompensationRequestForADayOfRestId', N'dbo', N'WF_CompensationRequestForADayOfRestSignature', N'CompensationRequestForADayOfRestId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Customer', N'CustomerCode', N'dbo', N'WF_RequisitionFormRequest', N'CustomerCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Customer', N'CustomerCode', N'dbo', N'WF_StoreTransactionRequests', N'CustomerCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Direction', N'DirectionCode', N'dbo', N'WF_VehicleRequest', N'DirectionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Direction', N'DirectionCode', N'dbo', N'WF_VehiclesRequest', N'DirectionCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_FactorType', N'FactorTypeCode', N'dbo', N'WF_CompensationAllowanceTypes', N'FactorTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_FactorType', N'FactorTypeCode', N'dbo', N'WF_MonthlyEffectsRequest', N'CalculatedByCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_FingerPrintRequest', N'FingerPrintRequestId', N'dbo', N'WF_FingerPrintRequestSignature', N'FingerPrintRequestId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_GeneralRequest', N'GeneralRequestId', N'dbo', N'WF_GeneralRequestSignature', N'GeneralRequestId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_GeneralRequestType', N'GeneralRequestTypeCode', N'dbo', N'WF_GeneralRequest', N'GeneralRequestTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_GeneralRequestType', N'GeneralRequestTypeCode', N'dbo', N'WF_GeneralsRequest', N'GeneralRequestTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_KeepingTypes', N'KeepingTypeCode', N'dbo', N'WF_Keeping', N'KeepingTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_LoanRequest', N'LoanRequestId', N'dbo', N'WF_LoanRequestSignature', N'LoanRequestId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_LoanType', N'LoanTypeCode', N'dbo', N'WF_LoanRequest', N'LoanTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_LoanType', N'LoanTypeCode', N'dbo', N'WF_LoanTypeDetials', N'LoanTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_MaintenanceRequest', N'MaintenanceRequestCode', N'dbo', N'WF_MaintenanceRequestSignature', N'MaintenanceRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_MaintenanceType', N'MaintenanceTypeCode', N'dbo', N'WF_MaintenanceRequest', N'MaintenanceTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_MaintenanceType', N'MaintenanceTypeCode', N'dbo', N'WF_MaintenancesRequest', N'MaintenanceTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_MasterRequests', N'MasterRequestCode', N'dbo', N'WF_BonusesRequest', N'MasterRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_MasterRequests', N'MasterRequestCode', N'dbo', N'WF_GeneralsRequest', N'MasterRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_MasterRequests', N'MasterRequestCode', N'dbo', N'WF_MaintenancesRequest', N'MasterRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_MasterRequests', N'MasterRequestCode', N'dbo', N'WF_MasterRequestsCondition', N'MasterRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_MasterRequests', N'MasterRequestCode', N'dbo', N'WF_MasterRequestsSignature', N'MasterRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_MasterRequests', N'MasterRequestCode', N'dbo', N'WF_MonthlyEffectsRequest', N'MasterRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_MasterRequests', N'MasterRequestCode', N'dbo', N'WF_NewJobRequest', N'MasterRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_MasterRequests', N'MasterRequestCode', N'dbo', N'WF_StoreTransactionRequests', N'MasterRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_MasterRequests', N'MasterRequestCode', N'dbo', N'WF_TransferRequest', N'MasterRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_MasterRequests', N'MasterRequestCode', N'dbo', N'WF_VehiclesRequest', N'MasterRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_MissionPlace', N'MissionPlaceCode', N'dbo', N'WF_MissionPlaceLevel', N'MissionPlaceCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_MissionPlace', N'MissionPlaceCode', N'dbo', N'WF_PermissionRequest', N'MissionPlaceCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_MissionPlace', N'MissionPlaceCode', N'dbo', N'WF_VacationRequest', N'MissionPlaceCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_NewEmployeesRequest', N'NewEmployeesRequestCode', N'dbo', N'WF_NewEmployeesRequest', N'CancelRequestNumber')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_NewEmployeesRequest', N'NewEmployeesRequestCode', N'dbo', N'WF_NewEmployeesRequestSignature', N'NewEmployeesRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_NewEmployeesRequest', N'NewEmployeesRequestCode', N'dbo', N'WF_StaffReplacement', N'NewEmployeesRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_NewHireRequest', N'NewHireRequestCode', N'dbo', N'WF_Keeping', N'NewHireRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_NewHireRequest', N'NewHireRequestCode', N'dbo', N'WF_NewHireRequest', N'CancelRequestNumber')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_NewHireRequest', N'NewHireRequestCode', N'dbo', N'WF_NewHireRequestCondition', N'NewHireRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_NewHireRequest', N'NewHireRequestCode', N'dbo', N'WF_NewHireRequestSignature', N'NewHireRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_NewHireRequest', N'NewHireRequestCode', N'dbo', N'WF_SalaryDetail', N'NewHireRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_OvertimeEventType', N'EventTypeCode', N'dbo', N'WF_OverTimeRequest', N'EventTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_OvertimeEventType', N'EventTypeCode', N'dbo', N'WF_OverTimeSymphonyRequest', N'EventTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_OverTimeRequest', N'OverTimeRequestId', N'dbo', N'WF_OverTimeRequestDetails', N'OverTimeRequestId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_OverTimeRequest', N'OverTimeRequestId', N'dbo', N'WF_OverTimeRequestFinalSignature', N'OverTimeRequestId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_OverTimeRequest', N'OverTimeRequestId', N'dbo', N'WF_OverTimeRequestSignature', N'OverTimeRequestId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_OverTimeSymphonyRequest', N'OverTimeRequestId', N'dbo', N'WF_OverTimeSymphonyRequestSignature', N'OverTimeRequestId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_OvertimeType', N'OvertimeTypeCode', N'dbo', N'WF_OverTimeRequest', N'OvertimeTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_OvertimeType', N'OvertimeTypeCode', N'dbo', N'WF_OverTimeSymphonyRequest', N'OvertimeTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_PenaltyRequest', N'PenaltyRequestCode', N'dbo', N'WF_PenaltyRequest', N'CancelRequestNumber')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_PenaltyRequest', N'PenaltyRequestCode', N'dbo', N'WF_PenaltyRequestSignature', N'PenaltyRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_PermissionRequest', N'PermissionRequestId', N'dbo', N'WF_PermissionRequestSignature', N'PermissionRequestId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_PromotionRequest', N'PromotionRequestCode', N'dbo', N'WF_PromotionRequest', N'CancelRequestNumber')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_PromotionRequest', N'PromotionRequestCode', N'dbo', N'WF_PromotionRequestCondition', N'PromotionRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_PromotionRequest', N'PromotionRequestCode', N'dbo', N'WF_PromotionRequestDetail', N'PromotionRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_PromotionRequest', N'PromotionRequestCode', N'dbo', N'WF_PromotionRequestSignature', N'PromotionRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_PurchasesRequest', N'PurchasesRequestCode', N'dbo', N'WF_PurchasesRequestDetails', N'PurchasesRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_PurchasesRequest', N'PurchasesRequestCode', N'dbo', N'WF_PurchasesRequestSignature', N'PurchasesRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_AirTicketRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_AirTicketRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_BonusRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_BonusRequest', N'HRApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_BonusRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_CasualRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_CasualRequest', N'HRApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_CasualRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_ChangeDayoffRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_ChangeDayoffRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_CompensationRequestFinalDayRestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_CompensationRequestForADayOfRest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_CompensationRequestForADayOfRest', N'HRApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_CompensationRequestForADayOfRestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_DisclaimerRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_FingerPrintRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_FingerPrintRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_GeneralRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_GeneralRequest', N'HRApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_GeneralRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_LoanRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_LoanRequest', N'HRApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_LoanRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_MaintenanceRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_MaintenanceRequest', N'HRApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_MaintenanceRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_MasterRequests', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_MasterRequestsSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_NewEmployeesRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_NewEmployeesRequest', N'HRApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_NewEmployeesRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_NewHireRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_NewHireRequest', N'HRApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_NewHireRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_OverTimeRequestFinalSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_OverTimeRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_OverTimeSymphonyRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_OverTimeSymphonyRequest', N'HRApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_OverTimeSymphonyRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_PenaltyRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_PenaltyRequest', N'HRApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_PenaltyRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_PermissionRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_PermissionRequest', N'HRApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_PermissionRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_PromotionRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_PromotionRequest', N'HRApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_PromotionRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_PurchasesRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_PurchasesRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_RequisitionFormRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_RequisitionFormRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_ResignationRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_ResignationRequest', N'DisclaimerDepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_ResignationRequest', N'HRApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_ResignationRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_VacationRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_VacationRequest', N'DisclaimerDepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_VacationRequest', N'HRApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_VacationRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_VehicleRequest', N'DepartmentApproval')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestStatus', N'RequestStatusId', N'dbo', N'WF_VehicleRequestSignature', N'Approved')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestType', N'RequestTypeId', N'dbo', N'WF_DisclaimerRequestSignature', N'RequestTypeId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestType', N'RequestTypeId', N'dbo', N'WF_EmployeeTrack', N'RequestTypeId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestType', N'RequestTypeId', N'dbo', N'WF_MasterRequests', N'RequestTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestType', N'RequestTypeId', N'dbo', N'WF_OtherEmployeeTrack', N'RequestTypeId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestType', N'RequestTypeId', N'dbo', N'WF_Track', N'RequestTypeId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequestType', N'RequestTypeId', N'dbo', N'WF_UserTrackNotification', N'RequestTypeId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequisitionFormRequest', N'RequisitionFormRequestCode', N'dbo', N'WF_RequisitionFormRequestDetails', N'RequisitionFormRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_RequisitionFormRequest', N'RequisitionFormRequestCode', N'dbo', N'WF_RequisitionFormRequestSignature', N'RequisitionFormRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_ResignationRequest', N'ResignationRequestCode', N'dbo', N'WF_ResignationRequest', N'CancelRequestNumber')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_ResignationRequest', N'ResignationRequestCode', N'dbo', N'WF_ResignationRequestSignature', N'ResignationRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_SetUpType', N'SetUpTypeID', N'dbo', N'WF_CasualRequest', N'SetUpTypeID')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_StoreTransactionRequests', N'MasterRequestCode', N'dbo', N'WF_StoreTransactionRequestsDetails', N'MasterRequestCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_AirTicketRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_BonusRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_CasualRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_ChangeDayoffRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_CompensationRequestForADayOfRest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_EmployeeTrack', N'TrackId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_FingerPrintRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_GeneralRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_LoanRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_MaintenanceRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_MasterRequests', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_NewEmployeesRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_NewHireRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_OtherEmployeeTrack', N'TrackId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_OverTimeSymphonyRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_PenaltyRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_PermissionRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_PromotionRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_PurchasesRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_RequisitionFormRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_ResignationRequest', N'DisclaimerTrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_ResignationRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_TrackDetail', N'TrackId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_UserTrackNotification', N'TrackId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_VacationRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_Track', N'TrackId', N'dbo', N'WF_VehicleRequest', N'TrackCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_VacationRequest', N'VacationRequestId', N'dbo', N'WF_VacationRequestDetail', N'VacationRequestId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_VacationRequest', N'VacationRequestId', N'dbo', N'WF_VacationRequestSignature', N'VacationRequestId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_VehicleRequest', N'VehicleRequestId', N'dbo', N'WF_VehicleRequestSignature', N'VehicleRequestId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_VehicleType', N'VehicleTypeCode', N'dbo', N'WF_VehicleRequest', N'VehicleTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'dbo', N'WF_VehicleType', N'VehicleTypeCode', N'dbo', N'WF_VehiclesRequest', N'VehicleTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'HangFire', N'Job', N'Id', N'HangFire', N'JobParameter', N'JobId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'HangFire', N'Job', N'Id', N'HangFire', N'State', N'JobId')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'BillMaterial', N'BillMaterialCode', N'Inv', N'BillMaterialItemContent', N'BillMaterialCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'ItemCard', N'ItemCardCode', N'Inv', N'BillMaterial', N'ItemCardCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'ItemCard', N'ItemCardCode', N'Inv', N'BillMaterialItemContent', N'ItemCardCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'ItemCard', N'ItemCardCode', N'Inv', N'ItemCardAlternative', N'ItemCardCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'ItemCard', N'ItemCardCode', N'Inv', N'ItemCardUnit', N'ItemCardCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'ItemCard', N'ItemCardCode', N'Inv', N'ItemCardUnitBarCode', N'ItemCardCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'ItemCard', N'ItemCardCode', N'Inv', N'StoreItemWeightedAverageCost', N'ItemCardCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'ItemCard', N'ItemCardCode', N'Inv', N'StoreTransactionDetail', N'ItemCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'ItemCategory', N'ItemCategoryCode', N'Inv', N'ItemCard', N'ItemCategoryCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'ItemGroup', N'ItemGroupCode', N'Inv', N'ItemCard', N'ItemGroupCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'ItemType', N'ItemTypeCode', N'Inv', N'ItemCard', N'ItemTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'ItemUnit', N'ItemUnitCode', N'Inv', N'BillMaterial', N'ItemUnitCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'ItemUnit', N'ItemUnitCode', N'Inv', N'BillMaterialItemContent', N'ItemUnitCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'ItemUnit', N'ItemUnitCode', N'Inv', N'ItemCardUnit', N'ItemUnitCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'ItemUnit', N'ItemUnitCode', N'Inv', N'ItemCardUnitBarCode', N'ItemUnitCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'ItemUnit', N'ItemUnitCode', N'Inv', N'StoreTransactionDetail', N'UnitCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'NatureItem', N'NatureItemCode', N'Inv', N'ItemCard', N'NatureItemCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'Recipe', N'RecipeCode', N'Inv', N'BillMaterial', N'RecipeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'Store', N'StoreCode', N'Inv', N'StoreItemWeightedAverageCost', N'StoreCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'Store', N'StoreCode', N'Inv', N'StoreTransactionDetail', N'StoreCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'Store', N'StoreCode', N'Inv', N'StoreTransactionMaster', N'TransactionStoreCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'Store', N'StoreCode', N'Inv', N'StoreUserPrivilege', N'StoreCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'StoreTransactionMaster', N'StoreTransactionMasterCode', N'Inv', N'StoreTransactionDetail', N'StoreTransactionMasterCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'Supplier', N'SupplierCode', N'Inv', N'StoreTransactionMaster', N'SupplierCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'Supplier', N'SupplierCode', N'Inv', N'SupplierContactData', N'SupplierCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'SupplierGroup', N'SupplierGroupCode', N'Inv', N'Supplier', N'SupplierGroupCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'TransactionType', N'TransactionTypeCode', N'Inv', N'StoreTransactionMaster', N'TransactionTypeCode')
GO
INSERT [dbo].[TablesRelations] ([PrimarySchemaName], [PrimaryTableName], [PrimaryColumnName], [ForeignSchemaName], [ForeignTableName], [ForeignColumnName]) VALUES (N'Inv', N'TransactionType', N'TransactionTypeCode', N'Inv', N'TransactionTypeUserPrivilege', N'TransactionTypeCode')
GO
------------------------------- End 2020-10-20 --------------------------

------------------------------- Ali 2020-10-22 --------------------------

  INSERT [dbo].[OrganizationStructure] ( [OrganizationStructureCode], 
  [Name], [Arabic_Name], [ParentId], [Audit_CreatedBy], [Audit_CreationDate], [Audit_ModifiedBy],
   [Audit_ModificationDate], [OrganizationCategoryCode], [Nickname], [Arabic_Nickname])  VALUES ( 1, N'sst', N'حلول لللبرمجيات', 0, 1044, CAST(N'2020-05-11T02:53:23.000' AS DateTime),  1, CAST(N'2020-06-04T04:54:19.000' AS DateTime),NULL, N'sst', N'حلول لللبرمجيات') 
------------------------------- End 2020-10-22 --------------------------
