.NET Document and Record Management(repost)

? Inranet WebApp? for managing documents and records? with the following requirements: ·? ? ? ? ? ? ? ? Integrated with a custom built SQL Server database with tables such as companies, projects, tasks, accounts, contracts, meetings etc. ·? ? ? ? ? ? ? ? Store documents as attachments for records(Example employee pictures) and ? Store documents as records (Example Contracts) ·? ? ? ? ? ? ? ? Offline Access? ? ? ? ? ? ? ·? ? ? ? ? ? ? ? Define metadata for different kinds of documents .? Full-Text Indexing, advanced search ·? ? ? ? ? ? ? ? Rich Office Integration ·? ? ? ? ? ? ? ? Document/Row level versioning and security ·? ? ? ? ? ? ? ? Programmatic customization ·? ? ? ? ? ? ? ? built on Microsoft Platform (.NET, SQL Server 2005). ## Deliverables To Whom It May Concern: ? Kindly note that we had a full solution implemented with SharePoint 2007 but the limitations of SharePoint not being relational system brought the project to a bottleneck. We are looking for an alternative solution for managing documents and records for that has the following requirements: ·? ? ? ? ? ? ? ? Integrated with a custom built SQL Server database with tables such as companies, projects, tasks, accounts, contracts, meetings etc. ·? ? ? ? ? ? ? ? Store documents as attachments for records(Example employee pictures) ·? ? ? ? ? ? ? ? Store documents as records (Example Contracts) ·? ? ? ? ? ? ? ? Define metadata for different kinds of documents (such a SharePoint Content Types) including lookups on existing tables. ·? ? ? ? ? ? ? ? Full-Text Indexing, advanced search ·? ? ? ? ? ? ? ? ? Offline Access? ? ? ? ? ? ? .? ? ? ? ? ? ? ? ? Rich Office Integration ·? ? ? ? ? ? ? ? Document/Row level versioning ·? ? ? ? ? ? ? ? Document/Row level security ·? ? ? ? ? ? ? ? Ability for programmatic customization ·? ? ? ? ? ? ? ? The system is supposed to be built on Microsoft Platform (.NET, SQL Server 2005). Please review and above requirements and contact us back if you have a solution. ? Regards, * * *This broadcast message was sent to all bidders on Monday Jul 13, 2009 8:58:42 AM: Hi, Thank you for your Bid, I need to see some sort of a prototype that demonstrates: • Versioning for records (sql database row) • Versioning for documents • Security for Records • Security for Documents • Office Integration • Opening and submitting documents to the system (Office documents) • Linking documents to existing records from various tables from the attached database creation scheme. Please feel free to contact regarding any questions or comments. Regards, --------------------------------- SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[FilingLocations]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[FilingLocations]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](50) NULL, [Comments] [ntext] NULL, CONSTRAINT [PK_FilingLocations] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[Users]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Users]( [ID] [int] IDENTITY(1,1) NOT NULL, [FullName] [nvarchar](100) NULL, [FullNameAr] [nvarchar](100) NULL, [Email] [nchar](20) NULL, [Login] [nchar](20) NULL, CONSTRAINT [PK_Users_1] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[SourceTypes]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[SourceTypes]( [ID] [int] IDENTITY(1,1) NOT NULL, [Title] [nchar](100) NULL, [RelatedTable] [varchar](20) NULL, CONSTRAINT [PK_InfoTypes] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[StorageLocations]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[StorageLocations]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](50) NULL, [Comments] [ntext] NULL, CONSTRAINT [PK_StorageLocations] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[Accounts]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Accounts]( [ID] [int] NOT NULL, [Name] [nvarchar](100) NULL, [NameAr] [nvarchar](100) NULL, [Address] [nvarchar](200) NULL, [BusinessType] [nchar](100) NULL, [BusinessPhone] [nchar](20) NULL, [Fax] [nchar](20) NULL, [Email] [nchar](100) NULL, [MobileNumber] [nchar](20) NULL, [Comments] [text] NULL, CONSTRAINT [PK_Account] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[Categories]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Categories]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [nchar](100) NULL, [Type] [nchar](100) NULL, [Comments] [text] NULL, CONSTRAINT [PK_Categories] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[Locations]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Locations]( [ID] [int] IDENTITY(1,1) NOT NULL, [Location] [nchar](100) NULL, [Comments] [text] NULL, CONSTRAINT [PK_Locations] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[Tasks]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Tasks]( [ID] [int] IDENTITY(1,1) NOT NULL, [Title] [nchar](100) NULL, [Completion] [int] NULL, [Completed] [bit] NULL, [Description] [text] NULL, [DueDate] [datetime] NULL, [EndDate] [datetime] NULL, [InfoBanKID] [nchar](100) NULL, [Priority] [nchar](20) NULL, [StartDate] [datetime] NULL, [Status] [nchar](20) NULL, [WhatToDo] [ntext] NULL, [ProjectID] [int] NULL, [PhaseID] [int] NULL, [AssignedTo] [int] NULL, [AssignedBy] [int] NULL, [RelatedRecordID] [int] NULL, [SourceTypeId] [int] NULL, CONSTRAINT [PK_Tasks] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[Magazines]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Magazines]( [ID] [int] IDENTITY(1,1) NOT NULL, [Language] [nchar](20) NULL, [Type] [int] NULL, [Periodicity] [nchar](20) NULL, [Country] [nchar](20) NULL, [PaymentTerms] [nchar](20) NULL, [Amount] [int] NULL, CONSTRAINT [PK_Magazines] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[Documents]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Documents]( [ID] [int] IDENTITY(1,1) NOT NULL, [FileName] [nvarchar](100) NULL, [Location] [varchar](50) NULL, [Created] [datetime] NULL, [CreatedBy] [int] NULL, [CategoryID] [int] NULL, [SubCategoryID] [int] NULL, [SourceTypeID] [int] NULL, [RelatedRecordID] [int] NULL, [Confidential] [bit] NULL, [ProcessorID] [int] NULL, [ProjectID] [int] NULL, [ProjectPhaseID] [int] NULL, [CompanyID] [int] NULL, CONSTRAINT [PK_Documents] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[BODMeetings]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[BODMeetings]( [ID] [int] IDENTITY(1,1) NOT NULL, [Title] [nchar](100) NULL, [MeetingDate] [datetime] NULL, [MeetingNumber] [int] NULL, [StartTime] [datetime] NULL, [EndTime] [datetime] NULL, [Status] [nchar](100) NULL, [Type] [nchar](20) NULL, [Comments] [text] NULL, [MotherCompany] [int] NULL, [Location] [int] NULL, [CategoryID] [int] NULL, [SubCategoryID] [int] NULL, CONSTRAINT [PK_BODMeeting] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[Files]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Files]( [ID] [int] IDENTITY(1,1) NOT NULL, [SerialNumber] [nvarchar](100) NULL, [ProjectId] [int] NULL, [ActivityId] [int] NULL, [CategoryID] [int] NULL, [SubCategoryID] [int] NULL, [Keywords] [nvarchar](200) NULL, [OpenDate] [datetime] NULL, [CloseDate] [datetime] NULL, [StorageLocationId] [int] NULL, [Comments] [ntext] NULL, [RequestedBy] [int] NULL, [ArchiveDate] [datetime] NULL, [FilingLocationId] [int] NULL, [Status] [varchar](50) NULL, [FilingCoordinatorID] [int] NULL, [FilingSupervisorID] [int] NULL, [CompanyID] [int] NULL, CONSTRAINT [PK_Files] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[IssuesLog]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[IssuesLog]( [ID] [int] IDENTITY(1,1) NOT NULL, [Title] [nchar](20) NULL, [IssueDate] [datetime] NULL, [RequestorID] [int] NULL, [Status] [nchar](100) NULL, [Subject] [text] NULL, [Comments] [text] NULL, [Created] [timestamp] NULL, [CompanyID] [int] NULL, [CategoryID] [int] NULL, [SubCategoryID] [int] NULL, [ProjectID] [int] NULL, [CoordinatorID] [int] NULL, CONSTRAINT [PK_IssuesLog] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[BODMeetingPoints]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[BODMeetingPoints]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [nchar](100) NULL, [BODMeetingID] [int] NULL, [Deadline] [datetime] NULL, [Status] [nchar](20) NULL, [CompletionDate] [datetime] NULL, [Remarks] [text] NULL, [Comments] [text] NULL, CONSTRAINT [PK_BODMeetingPoints] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[RepresentingCompanies]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[RepresentingCompanies]( [ID] [int] IDENTITY(1,1) NOT NULL, [RepresentativeName] [nchar](100) NULL, [BOD] [int] NULL, [CompanyID] [int] NULL, [Comments] [text] NULL, CONSTRAINT [PK_RepresentativeCompanies] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[Attendees]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Attendees]( [ID] [int] IDENTITY(1,1) NOT NULL, [AttendeeID] [int] NULL, [BODMeetingID] [int] NULL, [Attended] [bit] NULL, [RepresentedBy] [int] NULL, [Position] [nchar](100) NULL, [Comments] [text] NULL, CONSTRAINT [PK_Attendees] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[DocumentsArchiving]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[DocumentsArchiving]( [DocumentID] [int] NOT NULL, [FileID] [int] NOT NULL, [SectionID] [int] NOT NULL, CONSTRAINT [PK_DocumentsArchiving] PRIMARY KEY CLUSTERED ( [DocumentID] ASC, [FileID] ASC, [SectionID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[BODResolutionPoints]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[BODResolutionPoints]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [nchar](100) NULL, [MeetingPointId] [int] NULL, [Description] [text] NULL, [Deadline] [datetime] NULL, [Status] [nchar](100) NULL, [Comments] [text] NULL, CONSTRAINT [PK_BODResolutionPoints] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[IssuesDialog]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[IssuesDialog]( [ID] [int] NULL, [IssueID] [int] NULL, [Comments] [ntext] NULL, [Title] [nvarchar](50) NULL, [Created] [timestamp] NULL, [CreatedBy] [int] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[Roles]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Roles]( [ID] [int] NOT NULL, [Title] [nvarchar](50) NULL, [UserID] [int] NULL, CONSTRAINT [PK_Roles] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[TaskDialog]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[TaskDialog]( [ID] [int] IDENTITY(1,1) NOT NULL, [TaskID] [int] NULL, [Created] [timestamp] NULL, [CreatedBy] [int] NULL, [Comment] [ntext] NULL, CONSTRAINT [PK_TaskDialog] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[Sections]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Sections]( [ID] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](50) NULL, [FileId] [int] NULL, [Order] [int] NULL, [Comments] [ntext] NULL, CONSTRAINT [PK_Sections] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[Projects]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Projects]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [nchar](100) NULL, [NameAr] [nchar](200) NULL, [MotherCompany] [int] NULL, [OwningCompanyID] [int] NULL, [Location] [nchar](100) NULL, [Description] [text] NULL, [Status] [nchar](20) NULL, [Type] [nchar](20) NULL, [InitiationDate] [datetime] NULL, [EndDate] [datetime] NULL, [ExpectedEndDate] [datetime] NULL, [MonthlyPRBudget] [int] NULL, [CompanyID] [int] NULL, [FileSequence] [nchar](100) NULL, [Code] [nchar](100) NULL, [LogoPicture] [image] NULL, [Color] [image] NULL, CONSTRAINT [PK_Projects] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[Contacts]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Contacts]( [ID] [int] IDENTITY(1,1) NOT NULL, [FirstName] [nchar](100) NULL, [LastName] [nchar](100) NULL, [FullName] [nchar](100) NULL, [Address] [nvarchar](200) NULL, [City] [nchar](20) NULL, [CountryRegion] [nchar](20) NULL, [JobTitle] [nchar](20) NULL, [BusinessPhone] [nchar](20) NULL, [MobileNumber] [nchar](20) NULL, [FaxNumber] [nchar](20) NULL, [HomeNumber] [nchar](20) NULL, [Email] [nchar](100) NULL, [Grade] [nchar](10) NULL, [Notes] [nchar](100) NULL, [SendGift] [bit] NULL, [SendGreetingFor] [nchar](100) NULL, [StateProvince] [nchar](20) NULL, [WebPage] [nchar](100) NULL, [ZipPostalCode] [nchar](20) NULL, [CompanyId] [int] NULL, [Comments] [text] NULL, [AccountID] [int] NULL, CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[Companies]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Companies]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [nchar](100) NULL, [NameAr] [nchar](200) NULL, [Type] [nchar](100) NULL, [Address] [nchar](200) NULL, [Location] [nchar](100) NULL, [AssignDateREM] [datetime] NULL, [REMJobTitle] [nchar](100) NULL, [CommercialRegistry] [nchar](100) NULL, [Established] [datetime] NULL, [Activity] [nchar](100) NULL, [ActivityAr] [nchar](100) NULL, [Capital] [money] NULL, [CapitalRemarks] [text] NULL, [EndDate] [datetime] NULL, [Remarks] [text] NULL, [Code] [nchar](20) NULL, [Country] [nchar](10) NULL, [ParentCompanyID] [int] NULL, [Manager] [int] NULL, [Bank] [int] NULL, [lawyer] [int] NULL, [AuthorizedSignature] [int] NULL, [BankAuthorizedSignature] [int] NULL, [FinancialManager] [int] NULL, [Auditor] [int] NULL, [TaxConsultant] [int] NULL, [Comments] [text] NULL, CONSTRAINT [PK_Companies] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[ProjectPhases]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[ProjectPhases]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](200) NULL, [ProjectID] [int] NULL, [PhaseOrder] [int] NULL, [Milestone] [bit] NULL, [Description] [ntext] NULL, [Comments] [ntext] NULL, CONSTRAINT [PK_ProjectPhases] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM [login to view URL] WHERE object_id = OBJECT_ID(N'[dbo].[SubCategories]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[SubCategories]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [nchar](100) NULL, [Comments] [text] NULL, [CategoryID] [int] NULL, CONSTRAINT [PK_SubCategories] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] END GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Tasks_ProjectPhases]') AND parent_object_id = OBJECT_ID(N'[dbo].[Tasks]')) ALTER TABLE [dbo].[Tasks] WITH CHECK ADD CONSTRAINT [FK_Tasks_ProjectPhases] FOREIGN KEY([PhaseID]) REFERENCES [dbo].[ProjectPhases] ([ID]) GO ALTER TABLE [dbo].[Tasks] CHECK CONSTRAINT [FK_Tasks_ProjectPhases] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Tasks_Projects]') AND parent_object_id = OBJECT_ID(N'[dbo].[Tasks]')) ALTER TABLE [dbo].[Tasks] WITH CHECK ADD CONSTRAINT [FK_Tasks_Projects] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Projects] ([ID]) GO ALTER TABLE [dbo].[Tasks] CHECK CONSTRAINT [FK_Tasks_Projects] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Tasks_SourceTypes]') AND parent_object_id = OBJECT_ID(N'[dbo].[Tasks]')) ALTER TABLE [dbo].[Tasks] WITH CHECK ADD CONSTRAINT [FK_Tasks_SourceTypes] FOREIGN KEY([SourceTypeId]) REFERENCES [dbo].[SourceTypes] ([ID]) GO ALTER TABLE [dbo].[Tasks] CHECK CONSTRAINT [FK_Tasks_SourceTypes] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Tasks_Users]') AND parent_object_id = OBJECT_ID(N'[dbo].[Tasks]')) ALTER TABLE [dbo].[Tasks] WITH CHECK ADD CONSTRAINT [FK_Tasks_Users] FOREIGN KEY([AssignedTo]) REFERENCES [dbo].[Users] ([ID]) GO ALTER TABLE [dbo].[Tasks] CHECK CONSTRAINT [FK_Tasks_Users] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Tasks_Users1]') AND parent_object_id = OBJECT_ID(N'[dbo].[Tasks]')) ALTER TABLE [dbo].[Tasks] WITH CHECK ADD CONSTRAINT [FK_Tasks_Users1] FOREIGN KEY([AssignedBy]) REFERENCES [dbo].[Users] ([ID]) GO ALTER TABLE [dbo].[Tasks] CHECK CONSTRAINT [FK_Tasks_Users1] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Magazines_InfoTypes]') AND parent_object_id = OBJECT_ID(N'[dbo].[Magazines]')) ALTER TABLE [dbo].[Magazines] WITH CHECK ADD CONSTRAINT [FK_Magazines_InfoTypes] FOREIGN KEY([Type]) REFERENCES [dbo].[SourceTypes] ([ID]) GO ALTER TABLE [dbo].[Magazines] CHECK CONSTRAINT [FK_Magazines_InfoTypes] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Documents_Categories]') AND parent_object_id = OBJECT_ID(N'[dbo].[Documents]')) ALTER TABLE [dbo].[Documents] WITH CHECK ADD CONSTRAINT [FK_Documents_Categories] FOREIGN KEY([CategoryID]) REFERENCES [dbo].[Categories] ([ID]) GO ALTER TABLE [dbo].[Documents] CHECK CONSTRAINT [FK_Documents_Categories] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Documents_Companies]') AND parent_object_id = OBJECT_ID(N'[dbo].[Documents]')) ALTER TABLE [dbo].[Documents] WITH CHECK ADD CONSTRAINT [FK_Documents_Companies] FOREIGN KEY([CompanyID]) REFERENCES [dbo].[Companies] ([ID]) GO ALTER TABLE [dbo].[Documents] CHECK CONSTRAINT [FK_Documents_Companies] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Documents_InfoTypes]') AND parent_object_id = OBJECT_ID(N'[dbo].[Documents]')) ALTER TABLE [dbo].[Documents] WITH CHECK ADD CONSTRAINT [FK_Documents_InfoTypes] FOREIGN KEY([SourceTypeID]) REFERENCES [dbo].[SourceTypes] ([ID]) GO ALTER TABLE [dbo].[Documents] CHECK CONSTRAINT [FK_Documents_InfoTypes] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Documents_ProjectPhases]') AND parent_object_id = OBJECT_ID(N'[dbo].[Documents]')) ALTER TABLE [dbo].[Documents] WITH CHECK ADD CONSTRAINT [FK_Documents_ProjectPhases] FOREIGN KEY([ProjectPhaseID]) REFERENCES [dbo].[ProjectPhases] ([ID]) GO ALTER TABLE [dbo].[Documents] CHECK CONSTRAINT [FK_Documents_ProjectPhases] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Documents_Projects]') AND parent_object_id = OBJECT_ID(N'[dbo].[Documents]')) ALTER TABLE [dbo].[Documents] WITH CHECK ADD CONSTRAINT [FK_Documents_Projects] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Projects] ([ID]) GO ALTER TABLE [dbo].[Documents] CHECK CONSTRAINT [FK_Documents_Projects] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Documents_SubCategories]') AND parent_object_id = OBJECT_ID(N'[dbo].[Documents]')) ALTER TABLE [dbo].[Documents] WITH CHECK ADD CONSTRAINT [FK_Documents_SubCategories] FOREIGN KEY([SubCategoryID]) REFERENCES [dbo].[SubCategories] ([ID]) GO ALTER TABLE [dbo].[Documents] CHECK CONSTRAINT [FK_Documents_SubCategories] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Documents_Users]') AND parent_object_id = OBJECT_ID(N'[dbo].[Documents]')) ALTER TABLE [dbo].[Documents] WITH CHECK ADD CONSTRAINT [FK_Documents_Users] FOREIGN KEY([CreatedBy]) REFERENCES [dbo].[Users] ([ID]) GO ALTER TABLE [dbo].[Documents] CHECK CONSTRAINT [FK_Documents_Users] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_BODMeetings_Categories]') AND parent_object_id = OBJECT_ID(N'[dbo].[BODMeetings]')) ALTER TABLE [dbo].[BODMeetings] WITH CHECK ADD CONSTRAINT [FK_BODMeetings_Categories] FOREIGN KEY([CategoryID]) REFERENCES [dbo].[Categories] ([ID]) GO ALTER TABLE [dbo].[BODMeetings] CHECK CONSTRAINT [FK_BODMeetings_Categories] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_BODMeetings_Companies]') AND parent_object_id = OBJECT_ID(N'[dbo].[BODMeetings]')) ALTER TABLE [dbo].[BODMeetings] WITH CHECK ADD CONSTRAINT [FK_BODMeetings_Companies] FOREIGN KEY([MotherCompany]) REFERENCES [dbo].[Companies] ([ID]) GO ALTER TABLE [dbo].[BODMeetings] CHECK CONSTRAINT [FK_BODMeetings_Companies] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_BODMeetings_Locations]') AND parent_object_id = OBJECT_ID(N'[dbo].[BODMeetings]')) ALTER TABLE [dbo].[BODMeetings] WITH CHECK ADD CONSTRAINT [FK_BODMeetings_Locations] FOREIGN KEY([Location]) REFERENCES [dbo].[Locations] ([ID]) GO ALTER TABLE [dbo].[BODMeetings] CHECK CONSTRAINT [FK_BODMeetings_Locations] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_BODMeetings_SubCategories]') AND parent_object_id = OBJECT_ID(N'[dbo].[BODMeetings]')) ALTER TABLE [dbo].[BODMeetings] WITH CHECK ADD CONSTRAINT [FK_BODMeetings_SubCategories] FOREIGN KEY([SubCategoryID]) REFERENCES [dbo].[SubCategories] ([ID]) GO ALTER TABLE [dbo].[BODMeetings] CHECK CONSTRAINT [FK_BODMeetings_SubCategories] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Files_Categories]') AND parent_object_id = OBJECT_ID(N'[dbo].[Files]')) ALTER TABLE [dbo].[Files] WITH CHECK ADD CONSTRAINT [FK_Files_Categories] FOREIGN KEY([CategoryID]) REFERENCES [dbo].[Categories] ([ID]) GO ALTER TABLE [dbo].[Files] CHECK CONSTRAINT [FK_Files_Categories] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Files_Companies]') AND parent_object_id = OBJECT_ID(N'[dbo].[Files]')) ALTER TABLE [dbo].[Files] WITH CHECK ADD CONSTRAINT [FK_Files_Companies] FOREIGN KEY([CompanyID]) REFERENCES [dbo].[Companies] ([ID]) GO ALTER TABLE [dbo].[Files] CHECK CONSTRAINT [FK_Files_Companies] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Files_FilingLocations]') AND parent_object_id = OBJECT_ID(N'[dbo].[Files]')) ALTER TABLE [dbo].[Files] WITH CHECK ADD CONSTRAINT [FK_Files_FilingLocations] FOREIGN KEY([FilingLocationId]) REFERENCES [dbo].[FilingLocations] ([ID]) GO ALTER TABLE [dbo].[Files] CHECK CONSTRAINT [FK_Files_FilingLocations] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Files_Projects]') AND parent_object_id = OBJECT_ID(N'[dbo].[Files]')) ALTER TABLE [dbo].[Files] WITH CHECK ADD CONSTRAINT [FK_Files_Projects] FOREIGN KEY([ProjectId]) REFERENCES [dbo].[Projects] ([ID]) GO ALTER TABLE [dbo].[Files] CHECK CONSTRAINT [FK_Files_Projects] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Files_StorageLocations]') AND parent_object_id = OBJECT_ID(N'[dbo].[Files]')) ALTER TABLE [dbo].[Files] WITH CHECK ADD CONSTRAINT [FK_Files_StorageLocations] FOREIGN KEY([StorageLocationId]) REFERENCES [dbo].[StorageLocations] ([ID]) GO ALTER TABLE [dbo].[Files] CHECK CONSTRAINT [FK_Files_StorageLocations] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Files_SubCategories]') AND parent_object_id = OBJECT_ID(N'[dbo].[Files]')) ALTER TABLE [dbo].[Files] WITH CHECK ADD CONSTRAINT [FK_Files_SubCategories] FOREIGN KEY([SubCategoryID]) REFERENCES [dbo].[SubCategories] ([ID]) GO ALTER TABLE [dbo].[Files] CHECK CONSTRAINT [FK_Files_SubCategories] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Files_Users]') AND parent_object_id = OBJECT_ID(N'[dbo].[Files]')) ALTER TABLE [dbo].[Files] WITH CHECK ADD CONSTRAINT [FK_Files_Users] FOREIGN KEY([RequestedBy]) REFERENCES [dbo].[Users] ([ID]) GO ALTER TABLE [dbo].[Files] CHECK CONSTRAINT [FK_Files_Users] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Files_Users1]') AND parent_object_id = OBJECT_ID(N'[dbo].[Files]')) ALTER TABLE [dbo].[Files] WITH CHECK ADD CONSTRAINT [FK_Files_Users1] FOREIGN KEY([FilingSupervisorID]) REFERENCES [dbo].[Users] ([ID]) GO ALTER TABLE [dbo].[Files] CHECK CONSTRAINT [FK_Files_Users1] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Files_Users2]') AND parent_object_id = OBJECT_ID(N'[dbo].[Files]')) ALTER TABLE [dbo].[Files] WITH CHECK ADD CONSTRAINT [FK_Files_Users2] FOREIGN KEY([FilingCoordinatorID]) REFERENCES [dbo].[Users] ([ID]) GO ALTER TABLE [dbo].[Files] CHECK CONSTRAINT [FK_Files_Users2] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_IssuesLog_Categories]') AND parent_object_id = OBJECT_ID(N'[dbo].[IssuesLog]')) ALTER TABLE [dbo].[IssuesLog] WITH CHECK ADD CONSTRAINT [FK_IssuesLog_Categories] FOREIGN KEY([CategoryID]) REFERENCES [dbo].[Categories] ([ID]) GO ALTER TABLE [dbo].[IssuesLog] CHECK CONSTRAINT [FK_IssuesLog_Categories] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_IssuesLog_Companies]') AND parent_object_id = OBJECT_ID(N'[dbo].[IssuesLog]')) ALTER TABLE [dbo].[IssuesLog] WITH CHECK ADD CONSTRAINT [FK_IssuesLog_Companies] FOREIGN KEY([CompanyID]) REFERENCES [dbo].[Companies] ([ID]) GO ALTER TABLE [dbo].[IssuesLog] CHECK CONSTRAINT [FK_IssuesLog_Companies] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_IssuesLog_Projects]') AND parent_object_id = OBJECT_ID(N'[dbo].[IssuesLog]')) ALTER TABLE [dbo].[IssuesLog] WITH CHECK ADD CONSTRAINT [FK_IssuesLog_Projects] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Projects] ([ID]) GO ALTER TABLE [dbo].[IssuesLog] CHECK CONSTRAINT [FK_IssuesLog_Projects] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_IssuesLog_SubCategories]') AND parent_object_id = OBJECT_ID(N'[dbo].[IssuesLog]')) ALTER TABLE [dbo].[IssuesLog] WITH CHECK ADD CONSTRAINT [FK_IssuesLog_SubCategories] FOREIGN KEY([SubCategoryID]) REFERENCES [dbo].[SubCategories] ([ID]) GO ALTER TABLE [dbo].[IssuesLog] CHECK CONSTRAINT [FK_IssuesLog_SubCategories] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_IssuesLog_Users]') AND parent_object_id = OBJECT_ID(N'[dbo].[IssuesLog]')) ALTER TABLE [dbo].[IssuesLog] WITH CHECK ADD CONSTRAINT [FK_IssuesLog_Users] FOREIGN KEY([RequestorID]) REFERENCES [dbo].[Users] ([ID]) GO ALTER TABLE [dbo].[IssuesLog] CHECK CONSTRAINT [FK_IssuesLog_Users] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_BODMeetingPoints_BODMeetings]') AND parent_object_id = OBJECT_ID(N'[dbo].[BODMeetingPoints]')) ALTER TABLE [dbo].[BODMeetingPoints] WITH CHECK ADD CONSTRAINT [FK_BODMeetingPoints_BODMeetings] FOREIGN KEY([BODMeetingID]) REFERENCES [dbo].[BODMeetings] ([ID]) GO ALTER TABLE [dbo].[BODMeetingPoints] CHECK CONSTRAINT [FK_BODMeetingPoints_BODMeetings] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RepresentativeCompanies_BODMeetings]') AND parent_object_id = OBJECT_ID(N'[dbo].[RepresentingCompanies]')) ALTER TABLE [dbo].[RepresentingCompanies] WITH CHECK ADD CONSTRAINT [FK_RepresentativeCompanies_BODMeetings] FOREIGN KEY([BOD]) REFERENCES [dbo].[BODMeetings] ([ID]) GO ALTER TABLE [dbo].[RepresentingCompanies] CHECK CONSTRAINT [FK_RepresentativeCompanies_BODMeetings] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RepresentativeCompanies_Companies]') AND parent_object_id = OBJECT_ID(N'[dbo].[RepresentingCompanies]')) ALTER TABLE [dbo].[RepresentingCompanies] WITH CHECK ADD CONSTRAINT [FK_RepresentativeCompanies_Companies] FOREIGN KEY([CompanyID]) REFERENCES [dbo].[Companies] ([ID]) GO ALTER TABLE [dbo].[RepresentingCompanies] CHECK CONSTRAINT [FK_RepresentativeCompanies_Companies] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Attendees_BODMeetings]') AND parent_object_id = OBJECT_ID(N'[dbo].[Attendees]')) ALTER TABLE [dbo].[Attendees] WITH CHECK ADD CONSTRAINT [FK_Attendees_BODMeetings] FOREIGN KEY([BODMeetingID]) REFERENCES [dbo].[BODMeetings] ([ID]) GO ALTER TABLE [dbo].[Attendees] CHECK CONSTRAINT [FK_Attendees_BODMeetings] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Attendees_Contacts]') AND parent_object_id = OBJECT_ID(N'[dbo].[Attendees]')) ALTER TABLE [dbo].[Attendees] WITH CHECK ADD CONSTRAINT [FK_Attendees_Contacts] FOREIGN KEY([AttendeeID]) REFERENCES [dbo].[Contacts] ([ID]) GO ALTER TABLE [dbo].[Attendees] CHECK CONSTRAINT [FK_Attendees_Contacts] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Attendees_Contacts1]') AND parent_object_id = OBJECT_ID(N'[dbo].[Attendees]')) ALTER TABLE [dbo].[Attendees] WITH CHECK ADD CONSTRAINT [FK_Attendees_Contacts1] FOREIGN KEY([RepresentedBy]) REFERENCES [dbo].[Contacts] ([ID]) GO ALTER TABLE [dbo].[Attendees] CHECK CONSTRAINT [FK_Attendees_Contacts1] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_DocumentsArchiving_Documents]') AND parent_object_id = OBJECT_ID(N'[dbo].[DocumentsArchiving]')) ALTER TABLE [dbo].[DocumentsArchiving] WITH CHECK ADD CONSTRAINT [FK_DocumentsArchiving_Documents] FOREIGN KEY([DocumentID]) REFERENCES [dbo].[Documents] ([ID]) GO ALTER TABLE [dbo].[DocumentsArchiving] CHECK CONSTRAINT [FK_DocumentsArchiving_Documents] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_DocumentsArchiving_Files]') AND parent_object_id = OBJECT_ID(N'[dbo].[DocumentsArchiving]')) ALTER TABLE [dbo].[DocumentsArchiving] WITH CHECK ADD CONSTRAINT [FK_DocumentsArchiving_Files] FOREIGN KEY([FileID]) REFERENCES [dbo].[Files] ([ID]) GO ALTER TABLE [dbo].[DocumentsArchiving] CHECK CONSTRAINT [FK_DocumentsArchiving_Files] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_DocumentsArchiving_Sections]') AND parent_object_id = OBJECT_ID(N'[dbo].[DocumentsArchiving]')) ALTER TABLE [dbo].[DocumentsArchiving] WITH CHECK ADD CONSTRAINT [FK_DocumentsArchiving_Sections] FOREIGN KEY([SectionID]) REFERENCES [dbo].[Sections] ([ID]) GO ALTER TABLE [dbo].[DocumentsArchiving] CHECK CONSTRAINT [FK_DocumentsArchiving_Sections] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_BODResolutionPoints_BODMeetingPoints]') AND parent_object_id = OBJECT_ID(N'[dbo].[BODResolutionPoints]')) ALTER TABLE [dbo].[BODResolutionPoints] WITH CHECK ADD CONSTRAINT [FK_BODResolutionPoints_BODMeetingPoints] FOREIGN KEY([MeetingPointId]) REFERENCES [dbo].[BODMeetingPoints] ([ID]) GO ALTER TABLE [dbo].[BODResolutionPoints] CHECK CONSTRAINT [FK_BODResolutionPoints_BODMeetingPoints] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_IssuesDialog_IssuesLog]') AND parent_object_id = OBJECT_ID(N'[dbo].[IssuesDialog]')) ALTER TABLE [dbo].[IssuesDialog] WITH CHECK ADD CONSTRAINT [FK_IssuesDialog_IssuesLog] FOREIGN KEY([IssueID]) REFERENCES [dbo].[IssuesLog] ([ID]) GO ALTER TABLE [dbo].[IssuesDialog] CHECK CONSTRAINT [FK_IssuesDialog_IssuesLog] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_IssuesDialog_Users]') AND parent_object_id = OBJECT_ID(N'[dbo].[IssuesDialog]')) ALTER TABLE [dbo].[IssuesDialog] WITH CHECK ADD CONSTRAINT [FK_IssuesDialog_Users] FOREIGN KEY([CreatedBy]) REFERENCES [dbo].[Users] ([ID]) GO ALTER TABLE [dbo].[IssuesDialog] CHECK CONSTRAINT [FK_IssuesDialog_Users] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Roles_Users]') AND parent_object_id = OBJECT_ID(N'[dbo].[Roles]')) ALTER TABLE [dbo].[Roles] WITH CHECK ADD CONSTRAINT [FK_Roles_Users] FOREIGN KEY([UserID]) REFERENCES [dbo].[Users] ([ID]) GO ALTER TABLE [dbo].[Roles] CHECK CONSTRAINT [FK_Roles_Users] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TaskDialog_Tasks]') AND parent_object_id = OBJECT_ID(N'[dbo].[TaskDialog]')) ALTER TABLE [dbo].[TaskDialog] WITH CHECK ADD CONSTRAINT [FK_TaskDialog_Tasks] FOREIGN KEY([TaskID]) REFERENCES [dbo].[Tasks] ([ID]) GO ALTER TABLE [dbo].[TaskDialog] CHECK CONSTRAINT [FK_TaskDialog_Tasks] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_TaskDialog_Users]') AND parent_object_id = OBJECT_ID(N'[dbo].[TaskDialog]')) ALTER TABLE [dbo].[TaskDialog] WITH CHECK ADD CONSTRAINT [FK_TaskDialog_Users] FOREIGN KEY([CreatedBy]) REFERENCES [dbo].[Users] ([ID]) GO ALTER TABLE [dbo].[TaskDialog] CHECK CONSTRAINT [FK_TaskDialog_Users] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Sections_Files]') AND parent_object_id = OBJECT_ID(N'[dbo].[Sections]')) ALTER TABLE [dbo].[Sections] WITH CHECK ADD CONSTRAINT [FK_Sections_Files] FOREIGN KEY([FileId]) REFERENCES [dbo].[Files] ([ID]) GO ALTER TABLE [dbo].[Sections] CHECK CONSTRAINT [FK_Sections_Files] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Projects_Companies3]') AND parent_object_id = OBJECT_ID(N'[dbo].[Projects]')) ALTER TABLE [dbo].[Projects] WITH CHECK ADD CONSTRAINT [FK_Projects_Companies3] FOREIGN KEY([CompanyID]) REFERENCES [dbo].[Companies] ([ID]) GO ALTER TABLE [dbo].[Projects] CHECK CONSTRAINT [FK_Projects_Companies3] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Contacts_Accounts]') AND parent_object_id = OBJECT_ID(N'[dbo].[Contacts]')) ALTER TABLE [dbo].[Contacts] WITH CHECK ADD CONSTRAINT [FK_Contacts_Accounts] FOREIGN KEY([AccountID]) REFERENCES [dbo].[Accounts] ([ID]) GO ALTER TABLE [dbo].[Contacts] CHECK CONSTRAINT [FK_Contacts_Accounts] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Contacts_Companies]') AND parent_object_id = OBJECT_ID(N'[dbo].[Contacts]')) ALTER TABLE [dbo].[Contacts] WITH CHECK ADD CONSTRAINT [FK_Contacts_Companies] FOREIGN KEY([CompanyId]) REFERENCES [dbo].[Companies] ([ID]) GO ALTER TABLE [dbo].[Contacts] CHECK CONSTRAINT [FK_Contacts_Companies] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Companies_Companies]') AND parent_object_id = OBJECT_ID(N'[dbo].[Companies]')) ALTER TABLE [dbo].[Companies] WITH CHECK ADD CONSTRAINT [FK_Companies_Companies] FOREIGN KEY([ParentCompanyID]) REFERENCES [dbo].[Companies] ([ID]) GO ALTER TABLE [dbo].[Companies] CHECK CONSTRAINT [FK_Companies_Companies] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Companies_Contacts]') AND parent_object_id = OBJECT_ID(N'[dbo].[Companies]')) ALTER TABLE [dbo].[Companies] WITH CHECK ADD CONSTRAINT [FK_Companies_Contacts] FOREIGN KEY([Manager]) REFERENCES [dbo].[Contacts] ([ID]) GO ALTER TABLE [dbo].[Companies] CHECK CONSTRAINT [FK_Companies_Contacts] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Companies_Contacts1]') AND parent_object_id = OBJECT_ID(N'[dbo].[Companies]')) ALTER TABLE [dbo].[Companies] WITH CHECK ADD CONSTRAINT [FK_Companies_Contacts1] FOREIGN KEY([lawyer]) REFERENCES [dbo].[Contacts] ([ID]) GO ALTER TABLE [dbo].[Companies] CHECK CONSTRAINT [FK_Companies_Contacts1] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Companies_Contacts2]') AND parent_object_id = OBJECT_ID(N'[dbo].[Companies]')) ALTER TABLE [dbo].[Companies] WITH CHECK ADD CONSTRAINT [FK_Companies_Contacts2] FOREIGN KEY([AuthorizedSignature]) REFERENCES [dbo].[Contacts] ([ID]) GO ALTER TABLE [dbo].[Companies] CHECK CONSTRAINT [FK_Companies_Contacts2] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Companies_Contacts3]') AND parent_object_id = OBJECT_ID(N'[dbo].[Companies]')) ALTER TABLE [dbo].[Companies] WITH CHECK ADD CONSTRAINT [FK_Companies_Contacts3] FOREIGN KEY([BankAuthorizedSignature]) REFERENCES [dbo].[Contacts] ([ID]) GO ALTER TABLE [dbo].[Companies] CHECK CONSTRAINT [FK_Companies_Contacts3] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Companies_Contacts4]') AND parent_object_id = OBJECT_ID(N'[dbo].[Companies]')) ALTER TABLE [dbo].[Companies] WITH CHECK ADD CONSTRAINT [FK_Companies_Contacts4] FOREIGN KEY([FinancialManager]) REFERENCES [dbo].[Contacts] ([ID]) GO ALTER TABLE [dbo].[Companies] CHECK CONSTRAINT [FK_Companies_Contacts4] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Companies_Contacts5]') AND parent_object_id = OBJECT_ID(N'[dbo].[Companies]')) ALTER TABLE [dbo].[Companies] WITH CHECK ADD CONSTRAINT [FK_Companies_Contacts5] FOREIGN KEY([Auditor]) REFERENCES [dbo].[Contacts] ([ID]) GO ALTER TABLE [dbo].[Companies] CHECK CONSTRAINT [FK_Companies_Contacts5] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_Companies_Contacts6]') AND parent_object_id = OBJECT_ID(N'[dbo].[Companies]')) ALTER TABLE [dbo].[Companies] WITH CHECK ADD CONSTRAINT [FK_Companies_Contacts6] FOREIGN KEY([TaxConsultant]) REFERENCES [dbo].[Contacts] ([ID]) GO ALTER TABLE [dbo].[Companies] CHECK CONSTRAINT [FK_Companies_Contacts6] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ProjectPhases_Projects]') AND parent_object_id = OBJECT_ID(N'[dbo].[ProjectPhases]')) ALTER TABLE [dbo].[ProjectPhases] WITH CHECK ADD CONSTRAINT [FK_ProjectPhases_Projects] FOREIGN KEY([ProjectID]) REFERENCES [dbo].[Projects] ([ID]) GO ALTER TABLE [dbo].[ProjectPhases] CHECK CONSTRAINT [FK_ProjectPhases_Projects] GO IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_SubCategories_Categories]') AND parent_object_id = OBJECT_ID(N'[dbo].[SubCategories]')) ALTER TABLE [dbo].[SubCategories] WITH CHECK ADD CONSTRAINT [FK_SubCategories_Categories] FOREIGN KEY([CategoryID]) REFERENCES [dbo].[Categories] ([ID]) GO ALTER TABLE [dbo].[SubCategories] CHECK CONSTRAINT [FK_SubCategories_Categories] * * *This broadcast message was sent to all bidders on Tuesday Jul 14, 2009 4:19:23 AM: Hi, we had a sharepoint project that got to a bottleneck due to the fact that it's not relational. We are trying to build a custom .NET developed system using ASP.NET, C# and SQL 2005 but we are lacking the rich document management capabilities of SP 2007. The scope of this project is the document management part(office integration, metadata, versioning, security etc) and how it will be integrated with the custom developed dB. Please note that we require some sort of a prototype or features to be able to demo get the management buyyin. thanks Regards * * *This broadcast message was sent to all bidders on Wednesday Jul 15, 2009 5:31:05 AM: The requested demo or prototype should exist of a Ms. SQL database (Customers, Products, Orders, and Order Details, Companies). The system should: 1. The security of the system should be based on Active Directory (Windows Authentication) 2. The order form is a word template that will be submitted to the database as a document, and the relevant metadata should be extracted/linked to it (using a mapped folder using webdav or something similar to what SharePoint does) 3. Ability of store different kind of orders (Customer Order, Business Order) 4. Ability to attach documents to products and customers such as catalogues, pictures etc 5. Row level versioning and security (versions of each product, company) 6. Document level versioning and security (such as versions of each order) 7. Offline Access to the system (should be easy) 8. Support full text indexing and search based on column values 9. Every entity should store the CreatedBy (User), Created(datetime), LastModified (DateTime), LastModifiedBy(User), Version Number Tables: Customers: • ID (PK, identity, int) • FullName (varchar 100) • FullNameAr (nvarchar 100) Arabic Name • Email • Address Companies: • ID (PK, identity, int) • Title (varchar 100) • TitleAr (nvarchar(100)) • Address • Email • Fax Products: • ID (PK, identity, int) • Name (varchar 100) • Description (varchar 200) • AvailableInStock (int) • OrderLevel (int) • UnitPrice (int) Orders: • ID (PK, identity, int) • CustomerID (int) • CompanyID (int) • OrderDate (Datetime) • Amount (money • DeliveryTerms (varchar 100) • PaymentTerms (varchar 100) • Status OrderDetails: • ID (PK, identity, int) • OrderId (int) • ProductID (int) • UnitPrice (money) • Quantity (int) • Total (money) Attachments: • ID (PK, identity, int) • Document (Binary) • RelatedRecordId (int) • RelatedTable (varchar 20) Note: an order can be for a Customer (Person) or a Company. The above schema is not final and it may be modified as per you recommendations.