USE [ABC]
GO
/****** Object:  Table [dbo].[Assets]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Assets](
	[AssetID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](50) NULL,
	[PropertyTypeID] [int] NOT NULL,
	[Address1] [varchar](100) NULL,
	[Address2] [varchar](100) NULL,
	[CityId] [int] NULL,
	[Zip] [varchar](15) NULL,
	[YearBuilt] [int] NULL,
	[PropertySize] [int] NULL,
	[PropertyUnitType] [smallint] NULL,
	[Latitude] [numeric](10, 7) NULL,
	[Longitude] [numeric](10, 7) NULL,
	[IsGeocodeSuccess] [smallint] NOT NULL,
	[Precision] [smallint] NULL,
	[CreatedBy] [int] NULL,
	[DateCreated] [datetime] NOT NULL,
	[ModifiedBy] [int] NULL,
	[DateModified] [datetime] NULL,
	[RemovedBy] [int] NULL,
	[DateRemoved] [datetime] NULL,
	[FromDealPropertyID] [int] NULL,
	[GeoCodeLastAttempt] [datetime] NULL,
	[CreatedByNGJobID] [bigint] NULL,
	[LandAreaInAcres] [decimal](18, 8) NULL,
	[NumberofFloors] [varchar](50) NULL,
	[ModifiedByNGJobID] [bigint] NULL,
	[NumberofBuildings] [int] NULL,
	[RCAPropertyID] [bigint] NULL,
	[OutputCategory] [int] NULL,
	[PropertySubType] [int] NULL,
	[RCAPropertyUpdate] [datetime] NULL,
	[YearRenovated] [int] NULL,
	[Size_Sqft] [decimal](18, 8) NULL,
	[Size_Units] [int] NULL,
	[Size_Acres] [decimal](18, 8) NULL,
	[AlternateAssetID] [int] NULL,
	[TenantIDs] [varchar](300) NULL,
	[TenantNames] [varchar](500) NULL,
	[Size_InLineSqft] [decimal](18, 8) NULL,
	[TenancyID] [int] NULL,
	[IsPortfolio] [bit] NOT NULL,
	[PortfolioCount] [int] NULL,
	[GooglePrecision] [smallint] NULL,
 CONSTRAINT [PK_Properties] PRIMARY KEY CLUSTERED
(
	[AssetID] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[CacheClients]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CacheClients](
	[ClientID] [int] NOT NULL,
	[ClientName] [varchar](255) NOT NULL,
	[OldClientName] [varchar](100) NULL,
	[PreMergerClientID] [int] NULL,
	[PreMergerClientName] [varchar](100) NULL,
	[MappingCode] [smallint] NULL,
	[DateMapped] [datetime] NULL,
	[CurrentClientID] [int] NOT NULL,
	[NewClientID] [int] NULL,
	[InvestorTypeID] [int] NULL,
	[ParentClientID] [int] NULL,
	[ParentClientName] [varchar](100) NULL,
	[Address1] [varchar](255) NULL,
	[Address2] [varchar](100) NULL,
	[Address3] [varchar](100) NULL,
	[Phone] [varchar](40) NULL,
	[Fax] [varchar](40) NULL,
	[Description] [varchar](max) NULL,
	[CityID] [int] NULL,
	[isCMBS] [bit] NOT NULL,
	[isNationalAccount] [bit] NOT NULL,
	[isInvestorCorrespondent] [bit] NOT NULL,
	[isInvestorServicing] [bit] NOT NULL,
	[isUmbrella] [bit] NOT NULL,
	[isForeign] [bit] NOT NULL,
	[isSearchable] [bit] NOT NULL,
	[isDeleted] [bit] NOT NULL,
	[CurrentClientIsDeleted] [bit] NOT NULL,
	[DateRemoved] [datetime] NULL,
	[InvestorServicePortfolio] [money] NULL,
	[URL] [varchar](255) NULL,
	[ModifiedBy] [int] NULL,
	[DateModified] [datetime] NULL,
	[LastBookUpdated] [int] NULL,
	[Zip] [varchar](20) NULL,
	[NAType] [int] NULL,
	[Books] [int] NOT NULL,
	[ThirdPartyCategoryID] [int] NULL,
	[CreatedBy] [int] NULL,
	[DateCreated] [datetime] NULL,
	[ApprovedBy] [int] NULL,
	[DateApproved] [datetime] NULL,
	[CreatedSourceID] [int] NULL,
	[CreatedByNGJobID] [bigint] NULL,
	[ContactCount] [int] NULL,
	[ActivityCount] [int] NULL,
	[OnDealsAsClient] [int] NULL,
	[OnDealsAsInvestor] [int] NULL,
	[Advocates] [varchar](500) NULL,
	[SourcesOfFunds] [varchar](max) NULL,
	[Accounts] [varchar](max) NULL,
	[Advisors] [varchar](max) NULL,
	[QuoteCount] [int] NULL,
	[PackageCount] [int] NULL,
	[BlastCount] [int] NULL,
	[IsFreddieMac] [bit] NOT NULL,
	[HFFWarehouseLOC] [money] NOT NULL,
	[SourceOfFundRegion] [varchar](max) NULL,
	[SalesForceID] [nchar](20) NULL,
	[CACount] [int] NULL,
	[TourCount] [int] NULL,
 CONSTRAINT [PK_CacheClients] PRIMARY KEY CLUSTERED
(
	[ClientID] 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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Cities]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Cities](
	[CityID] [int] IDENTITY(1,1) NOT NULL,
	[City] [nvarchar](200) NULL,
	[State] [nvarchar](200) NOT NULL,
	[Country] [varchar](50) NULL,
	[RegionID] [int] NULL,
	[StateID] [int] NULL,
	[isDeleted] [bit] NOT NULL,
	[isDisplay] [bit] NOT NULL,
	[CountryID] [int] NULL,
	[RegionIDOld] [int] NULL,
	[IsOriginal] [bit] NULL,
	[Latitude] [numeric](10, 7) NULL,
	[Longitude] [numeric](10, 7) NULL,
	[MarketTypeID] [int] NULL,
	[IsGateway] [bit] NOT NULL,
	[RCARegionID] [int] NULL,
	[HasMSAOverride] [bit] NOT NULL,
	[RegionID092013] [int] NULL,
 CONSTRAINT [PK_Cities] PRIMARY KEY CLUSTERED
(
	[CityID] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DealFinancingMethods]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DealFinancingMethods](
	[DealFinancingMethodsID] [int] IDENTITY(1,1) NOT NULL,
	[FinancingMethod] [varchar](255) NOT NULL,
	[DateRemoved] [datetime] NULL,
	[RemovedBy] [int] NULL,
 CONSTRAINT [PK_DealFinancingMethods] PRIMARY KEY CLUSTERED
(
	[DealFinancingMethodsID] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DealPlatforms]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DealPlatforms](
	[PlatformID] [int] NOT NULL,
	[Platform] [varchar](50) NOT NULL,
	[ShortName] [varchar](15) NULL,
	[DisplayOrder] [int] NOT NULL,
	[DepartmentID] [int] NULL,
	[NotesKeyName] [varchar](50) NULL,
	[DisplayWithOffice] [bit] NOT NULL,
	[BookName] [varchar](50) NULL,
	[IsDebt] [bit] NOT NULL,
 CONSTRAINT [PK_Platforms] PRIMARY KEY CLUSTERED
(
	[PlatformID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DealProperties]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DealProperties](
	[PropertyID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](50) NULL,
	[DealID] [int] NULL,
	[PropertyTypeID] [int] NOT NULL,
	[OriginalAddress1] [varchar](100) NULL,
	[OriginalAddress2] [varchar](100) NULL,
	[OriginalCityId] [int] NULL,
	[OriginalZip] [varchar](15) NULL,
	[OriginalYearBuilt] [int] NULL,
	[PropertyProfileID] [int] NULL,
	[HasSingleTenant] [bit] NULL,
	[OriginalPropertySize] [int] NULL,
	[OriginalPropertyUnitType] [smallint] NULL,
	[Occupancy] [decimal](10, 0) NULL,
	[IsPriced] [smallint] NULL,
	[OriginalLatitude] [numeric](10, 7) NULL,
	[OriginalLongitude] [numeric](10, 7) NULL,
	[OriginalIsGeocodeSuccess] [smallint] NOT NULL,
	[IsFinancedByHFF] [bit] NULL,
	[OriginalPrecision] [smallint] NULL,
	[CreatedBy] [int] NULL,
	[DateCreated] [datetime] NOT NULL,
	[ModifiedBy] [int] NULL,
	[DateModified] [datetime] NULL,
	[RemovedBy] [int] NULL,
	[DateRemoved] [datetime] NULL,
	[DisplayInPropertyListing] [bit] NOT NULL,
	[PropertyListingName] [varchar](50) NULL,
	[PropertyListingLocDesc] [varchar](2000) NULL,
	[PropertyListingPropOv] [varchar](4000) NULL,
	[PropertyListingPropDesc] [varchar](2000) NULL,
	[Amount] [money] NULL,
	[IsMainProperty] [bit] NOT NULL,
	[CashOnCash] [decimal](8, 4) NULL,
	[IRR] [decimal](8, 4) NULL,
	[ROC] [decimal](8, 4) NULL,
	[ROI] [decimal](8, 4) NULL,
	[AvgROC] [decimal](8, 4) NULL,
	[AvgROI] [decimal](8, 4) NULL,
	[CalculatedIRR] [money] NULL,
	[BestInitialBid] [money] NULL,
	[Financing] [smallint] NULL,
	[LTV] [decimal](5, 4) NULL,
	[ExcludeISV] [bit] NOT NULL,
	[OriginalGeoCodeLastAttempt] [datetime] NULL,
	[UseGoogleMapSm] [bit] NOT NULL,
	[UseGoogleMapMed] [bit] NOT NULL,
	[GoogleMapSmZoom] [smallint] NULL,
	[GoogleMapMedZoom] [smallint] NULL,
	[AssetID] [int] NULL,
	[RentsInPlaceID] [int] NULL,
	[InPlaceNOI] [decimal](15, 4) NULL,
	[StabilizedNOI] [decimal](15, 4) NULL,
	[GoingInCapRate] [decimal](8, 4) NULL,
	[YearOneCapRate] [decimal](8, 4) NULL,
	[StabCapRate] [decimal](8, 4) NULL,
	[InPlaceCapRateWorksheet] [decimal](8, 4) NULL,
	[YearOneCapRateWorksheet] [decimal](8, 4) NULL,
	[StabilizedCapRateWorksheet] [decimal](8, 4) NULL,
	[FiveYearAvgROI] [decimal](12, 4) NULL,
	[FiveYearAvgROC] [decimal](12, 4) NULL,
	[TenYearAvgROI] [decimal](12, 4) NULL,
	[TenYearAvgROC] [decimal](12, 4) NULL,
	[UseManualFinancials] [bit] NULL,
	[LIRR] [decimal](8, 4) NULL,
	[WALE] [decimal](4, 1) NULL,
 CONSTRAINT [PK_DealProperties] PRIMARY KEY CLUSTERED
(
	[PropertyID] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Deals]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Deals](
	[DealID] [int] IDENTITY(30000,1) NOT NULL,
	[DealName] [varchar](50) NOT NULL,
	[Description] [varchar](2000) NULL,
	[StageID] [int] NOT NULL,
	[Amount] [money] NOT NULL,
	[OfficeID] [int] NULL,
	[DepartmentID] [int] NULL,
	[DealTypeID] [int] NULL,
	[DateFeeExpected] [datetime] NULL,
	[DateClosed] [datetime] NULL,
	[AccountingDate] [datetime] NULL,
	[MaturityDate] [datetime] NULL,
	[isSecuritized] [bit] NULL,
	[isServiced] [bit] NULL,
	[isBoardedByServicing] [bit] NULL,
	[isRollover] [bit] NULL,
	[isExclusive] [bit] NULL,
	[MarketBudget] [money] NULL,
	[HFFTotalFee] [money] NULL,
	[FeeAgreeTypeID] [int] NULL,
	[DateCommitmentExpires] [datetime] NULL,
	[LenderLegalFees] [money] NULL,
	[StartDate] [datetime] NULL,
	[ExitStrategyID] [int] NULL,
	[PublicityID] [int] NULL,
	[DateOpenToPrepay] [datetime] NULL,
	[ClosingRate] [numeric](6, 3) NULL,
	[AccessDealID] [int] NULL,
	[isDeleted] [smallint] NOT NULL,
	[LinkedDealID] [int] NULL,
	[RFPProposalDate] [datetime] NULL,
	[RFPStatus] [smallint] NULL,
	[RFPListPrice] [money] NULL,
	[RFPBOV] [money] NULL,
	[RFPCompetition] [nvarchar](max) NULL,
	[RFPComments] [nvarchar](max) NULL,
	[AcceptanceDate] [datetime] NULL,
	[DateCreated] [datetime] NULL,
	[CreatedBy] [int] NULL,
	[CommitmentAccepted] [varchar](100) NULL,
	[FeesApprovedBy] [int] NULL,
	[DateFeesApproved] [datetime] NULL,
	[FinancialsOld] [varchar](150) NULL,
	[FinancialComments] [varchar](1000) NULL,
	[DateModified] [datetime] NULL,
	[ModifiedBy] [int] NULL,
	[DateRemoved] [datetime] NULL,
	[FeeComments] [varchar](500) NULL,
	[isFeeGrandFathered] [bit] NOT NULL,
	[OrigContractAmt] [money] NULL,
	[MarketingDate] [datetime] NULL,
	[OfferCutoffDate] [datetime] NULL,
	[RFPCompensation] [varchar](255) NULL,
	[IndemnityCap] [money] NULL,
	[PitchDate] [datetime] NULL,
	[WinnerId] [int] NULL,
	[HasRFPPresent] [bit] NULL,
	[HasExecSmry] [bit] NULL,
	[HasPhoto] [bit] NULL,
	[HasFinalMktPkg] [bit] NULL,
	[HasDealHighlight] [bit] NULL,
	[IsPostedOnWebSite] [bit] NULL,
	[RFPDirectAward] [bit] NULL,
	[IsPortfolioDeal] [bit] NOT NULL,
	[TotalCap] [money] NULL,
	[HireDate] [datetime] NULL,
	[DateOMinMarket] [datetime] NULL,
	[InitialBidDueDate] [datetime] NULL,
	[BuyerSelectionDate] [datetime] NULL,
	[CAHFF] [bit] NULL,
	[CAInvestor] [bit] NULL,
	[DealDocs] [int] NULL,
	[ExcludeISV] [bit] NULL,
	[SkipBonusPool] [bit] NULL,
	[HasFeeAgreement] [bit] NOT NULL,
	[HasConsultingAgreement] [bit] NOT NULL,
	[NoPropReq] [bit] NOT NULL,
	[DealStartDate] [datetime] NULL,
	[SalesPrices] [money] NULL,
	[MarketingExpenseBudget] [money] NULL,
	[ThirdPartyReimburseHFF] [money] NULL,
	[ThirdPartyReimburseClient] [money] NULL,
	[RequestedBOV] [bit] NULL,
	[IsNonMarketing] [bit] NULL,
	[PreDealID] [int] NULL,
	[PropertyLocations] [varchar](max) NULL,
	[HFFLoanID] [varchar](50) NULL,
	[ManHours] [int] NULL,
	[RFPPitchTeamID] [int] NULL,
	[DeadDealReasonID] [int] NULL,
	[DeadDealReasonComments] [varchar](500) NULL,
	[HideFromReports] [bit] NOT NULL,
	[HasMixedUseProperty] [bit] NULL,
	[QuoteNotRequired] [bit] NULL,
	[DealPitchReminderSent] [datetime] NULL,
	[IsEstimate] [bit] NULL,
	[JVCategoryID] [int] NULL,
	[HasTermSheet] [bit] NULL,
	[RFPBOVDate] [datetime] NULL,
	[ListPrice] [money] NULL,
	[IsSignificant] [bit] NULL,
	[UnpaidPrincipalBalance] [money] NULL,
	[FeeOriginationPct] [decimal](5, 4) NOT NULL,
	[ETeaserPath] [varchar](255) NULL,
	[IsAgency] [bit] NULL,
	[CoBrokerFee] [money] NULL,
	[DealFinancingMethodID] [int] NULL,
	[PortfolioID] [int] NULL,
	[DateAddedToPortfolio] [datetime] NULL,
	[SkipManagementFeeValidation] [bit] NOT NULL,
	[FannieMaeFee] [money] NULL,
	[IsFannieMae] [bit] NULL,
	[SalesforceID] [nvarchar](20) NULL,
	[SalesforceUpdate] [bit] NOT NULL,
	[SalesForcePush] [bit] NULL,
	[CurrencyID] [int] NULL,
	[RFPDecisionDate] [datetime] NULL,
 CONSTRAINT [PK_Deals] PRIMARY KEY CLUSTERED
(
	[DealID] 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]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DealStages]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DealStages](
	[StageID] [int] IDENTITY(1,1) NOT NULL,
	[Stage] [varchar](50) NOT NULL,
	[DisplayOrder] [int] NOT NULL,
	[NotesKeyName] [varchar](50) NULL,
	[IsPipeline] [bit] NOT NULL,
	[isCompleted] [bit] NOT NULL,
	[isQuote] [bit] NOT NULL,
	[isApplication] [bit] NOT NULL,
	[isCommitment] [bit] NOT NULL,
	[isClosed] [bit] NOT NULL,
	[StageWeb] [varchar](50) NULL,
	[WebClass] [int] NOT NULL,
	[ListOnWeb] [bit] NOT NULL,
	[CanViewISOffers] [bit] NOT NULL,
 CONSTRAINT [PK_DealStages] PRIMARY KEY CLUSTERED
(
	[StageID] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DealsToClients]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DealsToClients](
	[DealID] [int] NOT NULL,
	[ClientID] [int] NOT NULL,
	[MemberType] [int] NOT NULL,
	[isPrimary] [bit] NOT NULL,
	[DisplayOrder] [int] NOT NULL,
	[InvestorTypeID] [int] NULL,
	[DateCreated] [datetime] NOT NULL,
	[Volume] [money] NULL,
	[VolumePct] [decimal](5, 4) NULL,
	[AccountID] [int] NULL,
	[SourceOfFundsID] [int] NULL,
	[DealsToClientsID] [int] IDENTITY(1,1) NOT NULL,
	[SalesForcePush] [bit] NULL,
	[CapstackAmount] [money] NULL,
 CONSTRAINT [PK_DealsToClients] PRIMARY KEY CLUSTERED
(
	[DealID] ASC,
	[ClientID] ASC,
	[MemberType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[DealsToEmployees]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DealsToEmployees](
	[DealID] [int] NOT NULL,
	[EmployeeID] [int] NOT NULL,
	[MemberType] [smallint] NOT NULL,
	[isPrimary] [bit] NOT NULL,
	[DisplayOrder] [int] NOT NULL,
	[isBookProducer] [bit] NOT NULL,
	[DateFeesApproved] [datetime] NULL,
	[InitialLeadCredit] [decimal](5, 4) NULL,
	[ShowOnPropertyListing] [bit] NULL,
	[ReceiveEsigEmails] [bit] NULL,
	[HasDocumentCenterAccess] [bit] NULL,
	[ReceiveDocCenterChangeEmails] [bit] NULL,
	[PropertyListingDisplayOrder] [int] NULL,
	[ReceiveDocCenterFilesUploadedEmail] [bit] NULL,
	[DealsToEmployeesID] [int] IDENTITY(1,1) NOT NULL,
	[SalesForcePush] [bit] NULL,
 CONSTRAINT [PK_DealsToEmployees] PRIMARY KEY CLUSTERED
(
	[DealID] ASC,
	[EmployeeID] ASC,
	[MemberType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[DealTypes]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DealTypes](
	[DealTypeID] [int] IDENTITY(1,1) NOT NULL,
	[DealType] [varchar](50) NOT NULL,
	[PlatformID] [int] NULL,
	[TransactionTypeID] [int] NULL,
	[NotesKeyName] [varchar](50) NULL,
	[isMiscellaneous] [bit] NOT NULL,
	[isFixedAdjLoan] [bit] NOT NULL,
	[DateRemoved] [datetime] NULL,
	[FixedFloating] [smallint] NULL,
	[IsMarketingOther] [bit] NOT NULL,
	[MarketingParentID] [int] NULL,
	[RemovedBy] [int] NULL,
	[CreatedBy] [int] NULL,
	[DateCreated] [datetime] NULL,
	[ModifiedBy] [int] NULL,
	[DateModified] [datetime] NULL,
	[Description] [varchar](1000) NULL,
	[VolumeRuleTypeID] [smallint] NOT NULL,
	[Options] [int] NULL,
	[SortOrder] [int] NULL,
 CONSTRAINT [PK_DealTypes] PRIMARY KEY CLUSTERED
(
	[DealTypeID] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Departments]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Departments](
	[DepartmentID] [int] IDENTITY(1,1) NOT NULL,
	[Department] [varchar](50) NOT NULL,
	[NotesKeyName] [varchar](50) NULL,
	[isPlatform] [bit] NOT NULL,
	[DateRemoved] [datetime] NULL,
 CONSTRAINT [PK_Departments] PRIMARY KEY CLUSTERED
(
	[DepartmentID] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Employees]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Employees](
	[EmployeeID] [int] IDENTITY(1,1) NOT NULL,
	[FirstName] [varchar](50) NOT NULL,
	[LastName] [nvarchar](50) NOT NULL,
	[MiddleName] [nvarchar](50) NULL,
	[NickName] [nvarchar](50) NULL,
	[Phone] [varchar](50) NULL,
	[Fax] [varchar](50) NULL,
	[Cell] [varchar](50) NULL,
	[Pager] [varchar](50) NULL,
	[Email] [varchar](50) NULL,
	[OfficeID] [int] NULL,
	[DepartmentID] [int] NULL,
	[TitleID] [int] NULL,
	[PositionID] [int] NULL,
	[SupervisorID] [int] NULL,
	[AssistantID] [int] NULL,
	[DateLastModified] [datetime] NULL,
	[isOfficeHead] [bit] NOT NULL,
	[isOfficeAssistant] [bit] NOT NULL,
	[isExecCommittee] [bit] NOT NULL,
	[WebBio] [varchar](50) NULL,
	[DateHired] [datetime] NULL,
	[DateTerminated] [datetime] NULL,
	[isActive] [bit] NOT NULL,
	[DrawAmount] [money] NULL,
	[DrawPayback] [numeric](4, 1) NULL,
	[NotesUniqueID] [varchar](40) NULL,
	[NotesKeyName] [varchar](50) NULL,
	[NotesLastModified] [datetime] NULL,
	[SkipImport] [bit] NOT NULL,
	[ContactID] [int] NULL,
	[BudgetFees] [money] NULL,
	[isPortfolioManager] [bit] NOT NULL,
	[ApproveAllDepts] [smallint] NULL,
	[ApproveRequired] [smallint] NULL,
	[ShowInLocationsWeb] [bit] NOT NULL,
	[isDisplayedWeb] [bit] NOT NULL,
	[DateCreated] [datetime] NOT NULL,
	[ModifiedBy] [int] NULL,
	[CreatedBy] [int] NULL,
	[isManager] [bit] NOT NULL,
	[DateDeleted] [datetime] NULL,
	[ProducerCreateDate] [datetime] NULL,
	[Benefit] [money] NULL,
	[HomePhone] [varchar](50) NULL,
	[WebBioNew] [varchar](50) NULL,
	[HRID] [varchar](30) NULL,
	[PayGroupID] [int] NULL,
	[HFFSHRID] [varchar](30) NULL,
	[DateRemoved] [datetime] NULL,
	[RemovedBy] [int] NULL,
	[TermDealsOutstanding] [bit] NOT NULL,
	[PendingHireTerm] [bit] NOT NULL,
	[IsContract] [bit] NOT NULL,
	[SpouseName] [varchar](50) NULL,
	[Address1] [varchar](100) NULL,
	[Address2] [varchar](100) NULL,
	[Address3] [varchar](100) NULL,
	[CityID] [int] NULL,
	[Zip1] [varchar](5) NULL,
	[Zip2] [varchar](4) NULL,
	[Country] [varchar](50) NULL,
	[CanDelete] [bit] NOT NULL,
	[PhysicalOfficeID] [int] NULL,
	[WebAddressMode] [smallint] NOT NULL,
	[ProducerGroupID] [smallint] NULL,
	[TransactionCategories] [int] NULL,
	[ProductSpecialty] [varchar](50) NULL,
	[TransactionCatPrimary] [int] NULL,
	[CompensationComment] [varchar](500) NULL,
	[WebSiteTitle] [varchar](255) NULL,
	[IsMediaContact] [bit] NOT NULL,
	[MediaSortOrder] [int] NULL,
	[LeadershipRoles] [int] NULL,
 CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED
(
	[EmployeeID] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[InvestorTypes]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[InvestorTypes](
	[InvestorTypeID] [int] IDENTITY(1,1) NOT NULL,
	[InvestorType] [varchar](50) NULL,
	[NotesKeyName] [varchar](50) NULL,
	[isNationalAccount] [smallint] NOT NULL,
	[DateRemoved] [datetime] NULL,
	[RemovedBy] [int] NULL,
	[CreatedBy] [int] NULL,
	[DateCreated] [datetime] NULL,
	[ModifiedBy] [int] NULL,
	[DateModified] [datetime] NULL,
	[Description] [varchar](1000) NULL,
	[IsCMBS] [bit] NULL,
	[IsImport] [bit] NOT NULL,
	[AccountAdvisorOption] [int] NULL,
	[InvestorTypeOptions] [int] NULL,
	[SfInvestorType] [varchar](50) NULL,
 CONSTRAINT [PK_InvestorTypes] PRIMARY KEY CLUSTERED
(
	[InvestorTypeID] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Offices]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Offices](
	[OfficeID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](25) NOT NULL,
	[Address1] [varchar](100) NULL,
	[Address2] [varchar](100) NULL,
	[Address3] [varchar](100) NULL,
	[CityID] [int] NULL,
	[Zip1] [varchar](15) NULL,
	[Zip2] [varchar](4) NULL,
	[Country] [varchar](50) NULL,
	[InternalMailCode] [varchar](10) NULL,
	[Phone] [varchar](15) NULL,
	[Fax] [varchar](15) NULL,
	[OfficeAdminID] [int] NULL,
	[DateOpened] [datetime] NULL,
	[DateClosed] [datetime] NULL,
	[isActive] [bit] NOT NULL,
	[NotesUniqueID] [varchar](40) NULL,
	[NotesKeyName] [varchar](25) NULL,
	[NotesLastModified] [datetime] NULL,
	[NotesShadowOffice] [varchar](25) NULL,
	[DateCreated] [datetime] NOT NULL,
	[CreatedBy] [int] NULL,
	[ModifiedBy] [int] NULL,
	[DateModified] [datetime] NULL,
	[OtherPhone] [varchar](15) NULL,
	[DateRemoved] [datetime] NULL,
	[OfficeRegionID] [int] NULL,
	[NameShort] [nchar](10) NULL,
	[Options] [int] NULL,
	[MapAddress1] [varchar](100) NULL,
	[MapAddress2] [varchar](100) NULL,
	[MapAddress3] [varchar](100) NULL,
	[OfficePhoto] [varchar](255) NULL,
	[Latitude] [numeric](10, 7) NULL,
	[Longitude] [numeric](10, 7) NULL,
	[GeoCodeLastAttempt] [datetime] NULL,
	[IsGeocodeSuccess] [smallint] NULL,
	[GooglePrecision] [smallint] NULL,
	[PropertyListingRegionID] [int] NULL,
	[GeocodeAdjustedByUser] [bit] NULL,
	[IPStart] [bigint] NULL,
	[IPEnd] [bigint] NULL,
	[LocalDocsPath] [varchar](500) NULL,
 CONSTRAINT [PK_Offices] PRIMARY KEY CLUSTERED
(
	[OfficeID] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[PropertyTypeGroups]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PropertyTypeGroups](
	[GroupID] [int] IDENTITY(1,1) NOT NULL,
	[GroupName] [varchar](50) NOT NULL,
	[NotesKeyName] [varchar](50) NULL,
	[SortOrder] [int] NULL,
	[Options] [int] NOT NULL,
	[UnitID] [smallint] NULL,
	[IconFilePrefix] [varchar](50) NULL,
 CONSTRAINT [PK_PropertyTypeGroups] PRIMARY KEY CLUSTERED
(
	[GroupID] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[PropertyTypes]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PropertyTypes](
	[PropertyTypeID] [int] IDENTITY(1,1) NOT NULL,
	[PropertyType] [varchar](50) NOT NULL,
	[ParentID] [int] NULL,
	[GroupID] [int] NULL,
	[NotesKeyName] [varchar](50) NULL,
	[DateRemoved] [datetime] NULL,
	[UnitType] [int] NULL,
	[IsOtherMarketing] [bit] NULL,
	[CreatedBy] [varchar](50) NULL,
	[DateCreated] [datetime] NULL,
	[ModifiedBy] [char](50) NULL,
	[DateModified] [datetime] NULL,
	[RemovedBy] [varchar](50) NULL,
	[Description] [varchar](1000) NULL,
	[ValidationGroupID] [int] NULL,
	[ValidationOptions] [int] NULL,
	[RequiresSubType] [bit] NOT NULL,
	[Options] [int] NOT NULL,
	[ShowOnBusCardProfile] [bit] NOT NULL,
	[ShowOnWebSite] [bit] NOT NULL,
	[SortWeb] [int] NOT NULL,
	[IsSearchableOnWebsite] [bit] NULL,
	[PublicPropertyTypeID] [int] NULL,
 CONSTRAINT [PK_PropertyTypes] PRIMARY KEY CLUSTERED
(
	[PropertyTypeID] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Regions]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Regions](
	[RegionID] [int] IDENTITY(1,1) NOT NULL,
	[Region] [varchar](50) NOT NULL,
	[DateRemoved] [datetime] NULL,
	[IsRollupRegion] [bit] NOT NULL,
	[ParentRegionID] [int] NULL,
	[IsForeign] [bit] NOT NULL,
	[RegionCode] [varchar](2) NULL,
	[RegionType] [smallint] NOT NULL,
 CONSTRAINT [PK_Regions] PRIMARY KEY CLUSTERED
(
	[RegionID] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[States]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[States](
	[StateID] [int] IDENTITY(1,1) NOT NULL,
	[State] [varchar](10) NOT NULL,
	[StateLong] [varchar](50) NULL,
	[Country] [varchar](50) NULL,
	[isFixup] [bit] NOT NULL,
	[RegionID] [int] NULL,
	[FIPS] [varchar](10) NULL,
	[ParentRegionID] [int] NULL,
	[zRegionID] [int] NULL,
	[CountryID] [int] NULL,
	[ShowRELicenseText] [bit] NOT NULL,
	[RELicenseText] [varchar](500) NULL,
	[RELicenseHideNonLicTeam] [bit] NOT NULL,
	[ShowRELicenseTextHFFS] [bit] NOT NULL,
	[ShowRELicenseTextInAll] [bit] NOT NULL,
	[FreddieRegionID] [int] NULL,
	[RCARegionID] [int] NULL,
	[RegionID092013] [int] NULL,
	[WebSiteDisplayOptions] [int] NULL,
 CONSTRAINT [PK_States] PRIMARY KEY CLUSTERED
(
	[StateID] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [report].[MonthlyDealAllocations]    Script Date: 11/25/2017 4:54:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [report].[MonthlyDealAllocations](
	[PeriodStartDate] [datetime] NULL,
	[PeriodEndDate] [datetime] NULL,
	[DealID] [int] NULL,
	[AllocatedDepartmentID] [int] NULL,
	[AllocatedOfficeID] [int] NULL,
	[OfficeAllocVolumePipeline] [money] NULL,
	[OfficeAllocVolumeCompleted] [money] NULL,
	[OfficeAllocFeePipeline] [money] NULL,
	[OfficeAllocFeeCompleted] [money] NULL,
	[OfficeAllocVolumePipelineGBP] [money] NULL,
	[OfficeAllocVolumeCompletedGBP] [money] NULL,
	[OfficeAllocFeePipelineGBP] [money] NULL,
	[OfficeAllocFeeCompletedGBP] [money] NULL,
	[CountDealCompleted] [int] NULL,
	[StageID] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_Assets_PropertyAddress]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Assets_PropertyAddress] ON [dbo].[Assets]
(
	[CityId] ASC,
	[Zip] ASC
)
INCLUDE ( 	[Address1],
	[PropertyTypeID],
	[AssetID]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_Assets_PropertyTypeID]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Assets_PropertyTypeID] ON [dbo].[Assets]
(
	[PropertyTypeID] ASC
)
INCLUDE ( 	[PropertyUnitType],
	[DateCreated]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_Assets_RCAPropertyID]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Assets_RCAPropertyID] ON [dbo].[Assets]
(
	[RCAPropertyID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_CacheClients_CityID]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_CacheClients_CityID] ON [dbo].[CacheClients]
(
	[CityID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_CacheClients_CurrentClientID]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_CacheClients_CurrentClientID] ON [dbo].[CacheClients]
(
	[CurrentClientID] ASC,
	[isSearchable] ASC
)
INCLUDE ( 	[ClientID],
	[ClientName],
	[MappingCode],
	[OldClientName]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_CacheClients_InvestorType]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_CacheClients_InvestorType] ON [dbo].[CacheClients]
(
	[InvestorTypeID] ASC,
	[isSearchable] ASC
)
INCLUDE ( 	[ClientID],
	[ThirdPartyCategoryID],
	[OnDealsAsClient],
	[OnDealsAsInvestor],
	[isDeleted],
	[Books]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_CacheClients_Name]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_CacheClients_Name] ON [dbo].[CacheClients]
(
	[ClientName] ASC,
	[isDeleted] ASC
)
INCLUDE ( 	[ClientID],
	[CurrentClientID]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_CacheClients_OldName]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_CacheClients_OldName] ON [dbo].[CacheClients]
(
	[OldClientName] ASC,
	[isDeleted] ASC
)
INCLUDE ( 	[ClientID],
	[CurrentClientID]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_CacheClients_PreMergerName]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_CacheClients_PreMergerName] ON [dbo].[CacheClients]
(
	[PreMergerClientName] ASC,
	[isDeleted] ASC
)
INCLUDE ( 	[ClientID],
	[CurrentClientID]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_CacheClients_SFID]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_CacheClients_SFID] ON [dbo].[CacheClients]
(
	[SalesForceID] ASC
)
INCLUDE ( 	[ClientID]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_CacheClients_Standard]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_CacheClients_Standard] ON [dbo].[CacheClients]
(
	[Books] ASC,
	[isSearchable] ASC,
	[isDeleted] ASC,
	[ThirdPartyCategoryID] ASC,
	[OnDealsAsClient] ASC,
	[OnDealsAsInvestor] ASC
)
INCLUDE ( 	[ClientID]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_Cities]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Cities] ON [dbo].[Cities]
(
	[RegionID] ASC
)
INCLUDE ( 	[isDisplay],
	[isDeleted]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_Cities_1]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Cities_1] ON [dbo].[Cities]
(
	[StateID] ASC
)
INCLUDE ( 	[isDisplay],
	[isDeleted]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_Cities_2]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Cities_2] ON [dbo].[Cities]
(
	[CountryID] ASC
)
INCLUDE ( 	[isDisplay],
	[isDeleted]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_Cities_4]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Cities_4] ON [dbo].[Cities]
(
	[City] ASC
)
INCLUDE ( 	[isDeleted],
	[isDisplay],
	[State]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_DealProperties_AssetID]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_DealProperties_AssetID] ON [dbo].[DealProperties]
(
	[AssetID] ASC
)
INCLUDE ( 	[DateRemoved]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_DealProperties_CityID]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_DealProperties_CityID] ON [dbo].[DealProperties]
(
	[OriginalCityId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_DealProperties_DateRemoved]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_DealProperties_DateRemoved] ON [dbo].[DealProperties]
(
	[DateRemoved] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_DealProperties_DealID]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_DealProperties_DealID] ON [dbo].[DealProperties]
(
	[DealID] ASC
)
INCLUDE ( 	[AssetID],
	[DateRemoved],
	[IsMainProperty],
	[PropertyID],
	[PropertyTypeID]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_DealProperties_LatLon]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_DealProperties_LatLon] ON [dbo].[DealProperties]
(
	[OriginalLatitude] ASC,
	[OriginalLongitude] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_DealProperties_PropTypeID]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_DealProperties_PropTypeID] ON [dbo].[DealProperties]
(
	[PropertyTypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_AccountingDate]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_AccountingDate] ON [dbo].[Deals]
(
	[AccountingDate] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_Deals]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Deals] ON [dbo].[Deals]
(
	[OfficeID] ASC,
	[DepartmentID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_Deals_1]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Deals_1] ON [dbo].[Deals]
(
	[DealTypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_Deals_10]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Deals_10] ON [dbo].[Deals]
(
	[DealID] ASC,
	[DateRemoved] ASC
)
INCLUDE ( 	[DealName],
	[StageID],
	[DealTypeID]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_Deals_3]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Deals_3] ON [dbo].[Deals]
(
	[DealName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_Deals_4]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Deals_4] ON [dbo].[Deals]
(
	[StageID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_Deals_5]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Deals_5] ON [dbo].[Deals]
(
	[Amount] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_Deals_6]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Deals_6] ON [dbo].[Deals]
(
	[HFFTotalFee] ASC,
	[DateFeeExpected] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_Deals_7]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Deals_7] ON [dbo].[Deals]
(
	[isDeleted] ASC,
	[StageID] ASC
)
INCLUDE ( 	[DealID],
	[DealTypeID]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_Deals_SFID]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Deals_SFID] ON [dbo].[Deals]
(
	[SalesforceID] ASC
)
INCLUDE ( 	[DealID]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_PortfolioID]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_PortfolioID] ON [dbo].[Deals]
(
	[PortfolioID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_DealsToClients]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_DealsToClients] ON [dbo].[DealsToClients]
(
	[ClientID] ASC,
	[MemberType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
GO
/****** Object:  Index [IX_DealsToEmployees]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_DealsToEmployees] ON [dbo].[DealsToEmployees]
(
	[EmployeeID] ASC,
	[MemberType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [_dta_index_Employees_10_1835921662__K1_2_3]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [_dta_index_Employees_10_1835921662__K1_2_3] ON [dbo].[Employees]
(
	[EmployeeID] ASC
)
INCLUDE ( 	[LastName],
	[FirstName]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_Employees_1]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Employees_1] ON [dbo].[Employees]
(
	[LastName] ASC,
	[FirstName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_Employees_2]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Employees_2] ON [dbo].[Employees]
(
	[OfficeID] ASC,
	[DepartmentID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_Employees_3]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Employees_3] ON [dbo].[Employees]
(
	[TitleID] ASC,
	[PositionID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_Employees_4]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_Employees_4] ON [dbo].[Employees]
(
	[ContactID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_PropertyTypeGroup]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_PropertyTypeGroup] ON [dbo].[PropertyTypes]
(
	[GroupID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_PropertyTypeParent]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_PropertyTypeParent] ON [dbo].[PropertyTypes]
(
	[ParentID] ASC
)
INCLUDE ( 	[PropertyTypeID],
	[DateRemoved]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_MonthlyDealAllocations_DealID_AllocDeptID_AllocOfficeID]    Script Date: 11/25/2017 4:54:20 PM ******/
CREATE NONCLUSTERED INDEX [IX_MonthlyDealAllocations_DealID_AllocDeptID_AllocOfficeID] ON [report].[MonthlyDealAllocations]
(
	[DealID] ASC,
	[AllocatedDepartmentID] ASC,
	[AllocatedOfficeID] ASC
)
INCLUDE ( 	[PeriodStartDate],
	[PeriodEndDate],
	[CountDealCompleted],
	[StageID]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Assets] ADD  CONSTRAINT [DF_Properties_IsGeocodeSuccess]  DEFAULT ((0)) FOR [IsGeocodeSuccess]
GO
ALTER TABLE [dbo].[Assets] ADD  CONSTRAINT [DF_Properties_DateCreated]  DEFAULT (getdate()) FOR [DateCreated]
GO
ALTER TABLE [dbo].[Assets] ADD  CONSTRAINT [DF_Assets_IsProtfolio]  DEFAULT ((0)) FOR [IsPortfolio]
GO
ALTER TABLE [dbo].[CacheClients] ADD  CONSTRAINT [DF_CacheClients_isCMBS]  DEFAULT ((0)) FOR [isCMBS]
GO
ALTER TABLE [dbo].[CacheClients] ADD  CONSTRAINT [DF_CacheClients_isNationalAccount]  DEFAULT ((0)) FOR [isNationalAccount]
GO
ALTER TABLE [dbo].[CacheClients] ADD  CONSTRAINT [DF_CacheClients_isCorrespondent]  DEFAULT ((0)) FOR [isInvestorCorrespondent]
GO
ALTER TABLE [dbo].[CacheClients] ADD  CONSTRAINT [DF_CacheClients_isInvestorServicing]  DEFAULT ((0)) FOR [isInvestorServicing]
GO
ALTER TABLE [dbo].[CacheClients] ADD  CONSTRAINT [DF_CacheClients_isUmbrella]  DEFAULT ((0)) FOR [isUmbrella]
GO
ALTER TABLE [dbo].[CacheClients] ADD  CONSTRAINT [DF_CacheClients_isForeign]  DEFAULT ((0)) FOR [isForeign]
GO
ALTER TABLE [dbo].[CacheClients] ADD  CONSTRAINT [DF_CacheClients_isSearchable]  DEFAULT ((0)) FOR [isSearchable]
GO
ALTER TABLE [dbo].[CacheClients] ADD  CONSTRAINT [DF_CacheClients_isDeleted]  DEFAULT ((0)) FOR [isDeleted]
GO
ALTER TABLE [dbo].[CacheClients] ADD  CONSTRAINT [DF_CacheClients_CurrentClientIsDeleted]  DEFAULT ((0)) FOR [CurrentClientIsDeleted]
GO
ALTER TABLE [dbo].[CacheClients] ADD  CONSTRAINT [DF_CacheClients_Books]  DEFAULT ((0)) FOR [Books]
GO
ALTER TABLE [dbo].[CacheClients] ADD  CONSTRAINT [DF_CacheClients_IsFreddieMac]  DEFAULT ((0)) FOR [IsFreddieMac]
GO
ALTER TABLE [dbo].[CacheClients] ADD  CONSTRAINT [DF_CacheClients_HFFWarehouseLOC]  DEFAULT ((0)) FOR [HFFWarehouseLOC]
GO
ALTER TABLE [dbo].[Cities] ADD  CONSTRAINT [DF_Cities_isDeleted]  DEFAULT ((0)) FOR [isDeleted]
GO
ALTER TABLE [dbo].[Cities] ADD  CONSTRAINT [DF_Cities_isDisplay]  DEFAULT ((1)) FOR [isDisplay]
GO
ALTER TABLE [dbo].[Cities] ADD  CONSTRAINT [DF_Cities_IsGateway]  DEFAULT ((0)) FOR [IsGateway]
GO
ALTER TABLE [dbo].[Cities] ADD  CONSTRAINT [DF_Cities_HasMSAOverride]  DEFAULT ((0)) FOR [HasMSAOverride]
GO
ALTER TABLE [dbo].[DealPlatforms] ADD  CONSTRAINT [DF_DealPlatforms_DisplayOrder]  DEFAULT (0) FOR [DisplayOrder]
GO
ALTER TABLE [dbo].[DealPlatforms] ADD  CONSTRAINT [DF_DealPlatforms_DispShortNameOffice]  DEFAULT (0) FOR [DisplayWithOffice]
GO
ALTER TABLE [dbo].[DealPlatforms] ADD  CONSTRAINT [DF_DealPlatforms_IsDebt]  DEFAULT (0) FOR [IsDebt]
GO
ALTER TABLE [dbo].[DealProperties] ADD  CONSTRAINT [DF_DealProperties_IsGeocodeSuccess]  DEFAULT ((0)) FOR [OriginalIsGeocodeSuccess]
GO
ALTER TABLE [dbo].[DealProperties] ADD  CONSTRAINT [DF_DealProperties_IsFinancedByHFF]  DEFAULT ((0)) FOR [IsFinancedByHFF]
GO
ALTER TABLE [dbo].[DealProperties] ADD  CONSTRAINT [DF_DealProperties_DateCreated]  DEFAULT (getdate()) FOR [DateCreated]
GO
ALTER TABLE [dbo].[DealProperties] ADD  CONSTRAINT [DF_DealProperties_DisplayInPropertyListing]  DEFAULT ((1)) FOR [DisplayInPropertyListing]
GO
ALTER TABLE [dbo].[DealProperties] ADD  CONSTRAINT [DF_DealProperties_IsMainProperty]  DEFAULT ((0)) FOR [IsMainProperty]
GO
ALTER TABLE [dbo].[DealProperties] ADD  CONSTRAINT [DF_DealProperties_ExcludeISV]  DEFAULT ((0)) FOR [ExcludeISV]
GO
ALTER TABLE [dbo].[DealProperties] ADD  CONSTRAINT [DF_DealProperties_UseGoogleMapSm]  DEFAULT ((1)) FOR [UseGoogleMapSm]
GO
ALTER TABLE [dbo].[DealProperties] ADD  CONSTRAINT [DF_DealProperties_UseGoogleMapMed]  DEFAULT ((1)) FOR [UseGoogleMapMed]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_StageID]  DEFAULT ((0)) FOR [StageID]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_Amount]  DEFAULT ((0)) FOR [Amount]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_isDeleted]  DEFAULT ((0)) FOR [isDeleted]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_DateCreated]  DEFAULT (getdate()) FOR [DateCreated]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_isFeeGrandFathered]  DEFAULT ((0)) FOR [isFeeGrandFathered]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_WinnerId]  DEFAULT ((0)) FOR [WinnerId]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_HasRFPPresent]  DEFAULT ((0)) FOR [HasRFPPresent]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_HasExecSmry]  DEFAULT ((0)) FOR [HasExecSmry]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_HasPhoto]  DEFAULT ((0)) FOR [HasPhoto]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_HasFinalMktPkg]  DEFAULT ((0)) FOR [HasFinalMktPkg]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_HasDealHighlight]  DEFAULT ((0)) FOR [HasDealHighlight]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_RFPDirectAward]  DEFAULT ((0)) FOR [RFPDirectAward]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_IsPortfolioDeal]  DEFAULT ((0)) FOR [IsPortfolioDeal]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_DealDocs]  DEFAULT ((0)) FOR [DealDocs]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_ExcludeISV]  DEFAULT ((0)) FOR [ExcludeISV]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_SkipBonusPool]  DEFAULT ((0)) FOR [SkipBonusPool]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_HasFeeAgreement]  DEFAULT ((0)) FOR [HasFeeAgreement]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_HasConsultingAgreement]  DEFAULT ((0)) FOR [HasConsultingAgreement]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_NoPropReq]  DEFAULT ((0)) FOR [NoPropReq]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_DealStart]  DEFAULT (getdate()) FOR [DealStartDate]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_RequestedBOV]  DEFAULT ((0)) FOR [RequestedBOV]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_HideFromReports]  DEFAULT ((0)) FOR [HideFromReports]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_HasMixedUseProperty]  DEFAULT ((0)) FOR [HasMixedUseProperty]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_HasRFPPresent1]  DEFAULT ((0)) FOR [HasTermSheet]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_Amount1]  DEFAULT ((0)) FOR [UnpaidPrincipalBalance]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_FeeOriginationPct]  DEFAULT ((0)) FOR [FeeOriginationPct]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_SkipManagementFeeValidation]  DEFAULT ((0)) FOR [SkipManagementFeeValidation]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF__Deals__Salesforc__76E317F6]  DEFAULT ((0)) FOR [SalesforceUpdate]
GO
ALTER TABLE [dbo].[Deals] ADD  CONSTRAINT [DF_Deals_CurrencyID]  DEFAULT ((1)) FOR [CurrencyID]
GO
ALTER TABLE [dbo].[DealStages] ADD  CONSTRAINT [DF_DealStages_DisplayOrder]  DEFAULT ((0)) FOR [DisplayOrder]
GO
ALTER TABLE [dbo].[DealStages] ADD  CONSTRAINT [DF_DealStages_IsPipeline]  DEFAULT ((0)) FOR [IsPipeline]
GO
ALTER TABLE [dbo].[DealStages] ADD  CONSTRAINT [DF_DealStages_isCompleted]  DEFAULT ((0)) FOR [isCompleted]
GO
ALTER TABLE [dbo].[DealStages] ADD  CONSTRAINT [DF_DealStages_isQuote]  DEFAULT ((0)) FOR [isQuote]
GO
ALTER TABLE [dbo].[DealStages] ADD  CONSTRAINT [DF_DealStages_isApplication]  DEFAULT ((0)) FOR [isApplication]
GO
ALTER TABLE [dbo].[DealStages] ADD  CONSTRAINT [DF_DealStages_isCommitment]  DEFAULT ((0)) FOR [isCommitment]
GO
ALTER TABLE [dbo].[DealStages] ADD  CONSTRAINT [DF_DealStages_isClosed]  DEFAULT ((0)) FOR [isClosed]
GO
ALTER TABLE [dbo].[DealStages] ADD  CONSTRAINT [DF_DealStages_WebClass]  DEFAULT ((0)) FOR [WebClass]
GO
ALTER TABLE [dbo].[DealStages] ADD  CONSTRAINT [DF_DealStages_ListOnWeb]  DEFAULT ((0)) FOR [ListOnWeb]
GO
ALTER TABLE [dbo].[DealStages] ADD  CONSTRAINT [DF_DealStages_CanViewISOffers]  DEFAULT ((1)) FOR [CanViewISOffers]
GO
ALTER TABLE [dbo].[DealsToClients] ADD  CONSTRAINT [DF_DealsToClients_isPrimary]  DEFAULT (0) FOR [isPrimary]
GO
ALTER TABLE [dbo].[DealsToClients] ADD  CONSTRAINT [DF_DealsToClients_DisplayOrder]  DEFAULT (0) FOR [DisplayOrder]
GO
ALTER TABLE [dbo].[DealsToClients] ADD  CONSTRAINT [DF_DealsToClients_DateCreated]  DEFAULT (getdate()) FOR [DateCreated]
GO
ALTER TABLE [dbo].[DealsToEmployees] ADD  CONSTRAINT [DF_DealsToEmployees_isPrimary]  DEFAULT (0) FOR [isPrimary]
GO
ALTER TABLE [dbo].[DealsToEmployees] ADD  CONSTRAINT [DF_DealsToEmployees_DisplayOrder]  DEFAULT (0) FOR [DisplayOrder]
GO
ALTER TABLE [dbo].[DealsToEmployees] ADD  CONSTRAINT [DF_DealsToEmployees_isBookProducer]  DEFAULT (0) FOR [isBookProducer]
GO
ALTER TABLE [dbo].[DealsToEmployees] ADD  CONSTRAINT [DF_DealsToEmployees_ShowOnPropertyListing]  DEFAULT ((0)) FOR [ShowOnPropertyListing]
GO
ALTER TABLE [dbo].[DealsToEmployees] ADD  CONSTRAINT [DF_DealsToEmployees_ReceiveEsigEmail]  DEFAULT ((0)) FOR [ReceiveEsigEmails]
GO
ALTER TABLE [dbo].[DealsToEmployees] ADD  CONSTRAINT [DF_DealsToEmployees_HasDocumentCenterAccess]  DEFAULT ((0)) FOR [HasDocumentCenterAccess]
GO
ALTER TABLE [dbo].[DealsToEmployees] ADD  CONSTRAINT [DF_DealsToEmployees_ReceiveDocCenterChangeEmails]  DEFAULT ((0)) FOR [ReceiveDocCenterChangeEmails]
GO
ALTER TABLE [dbo].[DealTypes] ADD  CONSTRAINT [DF_DealTypes_isMiscellaneous]  DEFAULT ((0)) FOR [isMiscellaneous]
GO
ALTER TABLE [dbo].[DealTypes] ADD  CONSTRAINT [DF_DealTypes_isFixedAdjLoan]  DEFAULT ((0)) FOR [isFixedAdjLoan]
GO
ALTER TABLE [dbo].[DealTypes] ADD  CONSTRAINT [DF_DealTypes_IsMarketingOther]  DEFAULT ((0)) FOR [IsMarketingOther]
GO
ALTER TABLE [dbo].[DealTypes] ADD  CONSTRAINT [DF_DealTypes_VolumeRuleTypeID]  DEFAULT ((0)) FOR [VolumeRuleTypeID]
GO
ALTER TABLE [dbo].[DealTypes] ADD  CONSTRAINT [DF_DealTypes_SortOrder]  DEFAULT ((2)) FOR [SortOrder]
GO
ALTER TABLE [dbo].[Departments] ADD  CONSTRAINT [DF_Departments_isPlatform]  DEFAULT ((0)) FOR [isPlatform]
GO
ALTER TABLE [dbo].[Employees] ADD  CONSTRAINT [DF_Employees_isOfficeHead]  DEFAULT ((0)) FOR [isOfficeHead]
GO
ALTER TABLE [dbo].[Employees] ADD  CONSTRAINT [DF_Employees_isOfficeAssistant]  DEFAULT ((0)) FOR [isOfficeAssistant]
GO
ALTER TABLE [dbo].[Employees] ADD  CONSTRAINT [DF_Employees_isExecCommitte]  DEFAULT ((0)) FOR [isExecCommittee]
GO
ALTER TABLE [dbo].[Employees] ADD  CONSTRAINT [DF_Employees_isActive]  DEFAULT ((1)) FOR [isActive]
GO
ALTER TABLE [dbo].[Employees] ADD  CONSTRAINT [DF_Employees_SkipImport]  DEFAULT ((0)) FOR [SkipImport]
GO
ALTER TABLE [dbo].[Employees] ADD  CONSTRAINT [DF_Employees_isServicePortfolioManager]  DEFAULT ((0)) FOR [isPortfolioManager]
GO
ALTER TABLE [dbo].[Employees] ADD  CONSTRAINT [DF_Employees_CanApprove]  DEFAULT ((0)) FOR [ApproveAllDepts]
GO
ALTER TABLE [dbo].[Employees] ADD  CONSTRAINT [DF_Employees_ApproveRequired]  DEFAULT ((0)) FOR [ApproveRequired]
GO
ALTER TABLE [dbo].[Employees] ADD  CONSTRAINT [DF_Employees_ShowInLocationsWeb]  DEFAULT ((0)) FOR [ShowInLocationsWeb]
GO
ALTER TABLE [dbo].[Employees] ADD  CONSTRAINT [DF_Employees_isDisplayedWeb]  DEFAULT ((1)) FOR [isDisplayedWeb]
GO
ALTER TABLE [dbo].[Employees] ADD  CONSTRAINT [DF_Employees_DateCreated]  DEFAULT (getdate()) FOR [DateCreated]
GO
ALTER TABLE [dbo].[Employees] ADD  CONSTRAINT [DF_Employees_isManager]  DEFAULT ((0)) FOR [isManager]
GO
ALTER TABLE [dbo].[Employees] ADD  CONSTRAINT [DF_Employees_TermDealsOutstanding]  DEFAULT ((0)) FOR [TermDealsOutstanding]
GO
ALTER TABLE [dbo].[Employees] ADD  CONSTRAINT [DF_Employees_PendingHireTerm]  DEFAULT ((0)) FOR [PendingHireTerm]
GO
ALTER TABLE [dbo].[Employees] ADD  CONSTRAINT [DF_Employees_IsContract]  DEFAULT ((0)) FOR [IsContract]
GO
ALTER TABLE [dbo].[Employees] ADD  CONSTRAINT [DF_Employees_CanDelete]  DEFAULT ((0)) FOR [CanDelete]
GO
ALTER TABLE [dbo].[Employees] ADD  CONSTRAINT [DF_Employees_WebAddressMode]  DEFAULT ((0)) FOR [WebAddressMode]
GO
ALTER TABLE [dbo].[Employees] ADD  DEFAULT ((0)) FOR [IsMediaContact]
GO
ALTER TABLE [dbo].[InvestorTypes] ADD  CONSTRAINT [DF_InvestorTypes_isNationalAccount]  DEFAULT ((0)) FOR [isNationalAccount]
GO
ALTER TABLE [dbo].[InvestorTypes] ADD  CONSTRAINT [DF_InvestorTypes_IsCMBS]  DEFAULT ((0)) FOR [IsCMBS]
GO
ALTER TABLE [dbo].[InvestorTypes] ADD  CONSTRAINT [DF_InvestorTypes_IsImport]  DEFAULT ((0)) FOR [IsImport]
GO
ALTER TABLE [dbo].[Offices] ADD  CONSTRAINT [DF_Offices_isActive]  DEFAULT ((0)) FOR [isActive]
GO
ALTER TABLE [dbo].[Offices] ADD  CONSTRAINT [DF_Offices_DateCreated]  DEFAULT (getdate()) FOR [DateCreated]
GO
ALTER TABLE [dbo].[Offices] ADD  CONSTRAINT [DF_Offices_WebOptions]  DEFAULT ((3)) FOR [Options]
GO
ALTER TABLE [dbo].[PropertyTypeGroups] ADD  CONSTRAINT [DF_PropertyTypeGroups_Options]  DEFAULT ((0)) FOR [Options]
GO
ALTER TABLE [dbo].[PropertyTypes] ADD  CONSTRAINT [DF_PropertyTypes_IsOtherMarketing]  DEFAULT ((0)) FOR [IsOtherMarketing]
GO
ALTER TABLE [dbo].[PropertyTypes] ADD  CONSTRAINT [DF_PropertyTypes_DateCreated]  DEFAULT (getdate()) FOR [DateCreated]
GO
ALTER TABLE [dbo].[PropertyTypes] ADD  CONSTRAINT [DF_PropertyTypes_ValidationGroupID]  DEFAULT ((0)) FOR [ValidationGroupID]
GO
ALTER TABLE [dbo].[PropertyTypes] ADD  CONSTRAINT [DF_PropertyTypes_RequiresSubType]  DEFAULT ((0)) FOR [RequiresSubType]
GO
ALTER TABLE [dbo].[PropertyTypes] ADD  CONSTRAINT [DF_PropertyTypes_Options]  DEFAULT ((0)) FOR [Options]
GO
ALTER TABLE [dbo].[PropertyTypes] ADD  CONSTRAINT [DF_PropertyTypes_ShowOnBusCardProfile]  DEFAULT ((1)) FOR [ShowOnBusCardProfile]
GO
ALTER TABLE [dbo].[PropertyTypes] ADD  CONSTRAINT [DF_PropertyTypes_ShowOnWebSite]  DEFAULT ((1)) FOR [ShowOnWebSite]
GO
ALTER TABLE [dbo].[PropertyTypes] ADD  CONSTRAINT [DF_PropertyTypes_SortWeb]  DEFAULT ((0)) FOR [SortWeb]
GO
ALTER TABLE [dbo].[PropertyTypes] ADD  CONSTRAINT [DF_PropertyTypes_SearchableOnWebsite]  DEFAULT ((0)) FOR [IsSearchableOnWebsite]
GO
ALTER TABLE [dbo].[Regions] ADD  CONSTRAINT [DF_Regions_IsRollupRegion]  DEFAULT ((0)) FOR [IsRollupRegion]
GO
ALTER TABLE [dbo].[Regions] ADD  CONSTRAINT [DF_Regions_IsForeign]  DEFAULT ((0)) FOR [IsForeign]
GO
ALTER TABLE [dbo].[Regions] ADD  CONSTRAINT [DF_Regions_RegionType]  DEFAULT ((0)) FOR [RegionType]
GO
ALTER TABLE [dbo].[States] ADD  CONSTRAINT [DF_States_isFixup]  DEFAULT ((0)) FOR [isFixup]
GO
ALTER TABLE [dbo].[States] ADD  CONSTRAINT [DF_States_ShowRELicenseText]  DEFAULT ((0)) FOR [ShowRELicenseText]
GO
ALTER TABLE [dbo].[States] ADD  CONSTRAINT [DF_States_RELicenseShowNonLicTeam]  DEFAULT ((0)) FOR [RELicenseHideNonLicTeam]
GO
ALTER TABLE [dbo].[States] ADD  CONSTRAINT [DF_States_ShowRELicenseTextHFFS]  DEFAULT ((0)) FOR [ShowRELicenseTextHFFS]
GO
ALTER TABLE [dbo].[States] ADD  CONSTRAINT [DF_States_ShowLicenseTextInAll]  DEFAULT ((0)) FOR [ShowRELicenseTextInAll]
GO
ALTER TABLE [dbo].[Assets]  WITH CHECK ADD  CONSTRAINT [FK_Assets_PropertyTypes] FOREIGN KEY([PropertyTypeID])
REFERENCES [dbo].[PropertyTypes] ([PropertyTypeID])
GO
ALTER TABLE [dbo].[Assets] CHECK CONSTRAINT [FK_Assets_PropertyTypes]
GO
ALTER TABLE [dbo].[Assets]  WITH CHECK ADD  CONSTRAINT [FK_Assets_PropertyTypeUnits] FOREIGN KEY([PropertyUnitType])
REFERENCES [dbo].[PropertyTypeUnits] ([UnitID])
GO
ALTER TABLE [dbo].[Assets] CHECK CONSTRAINT [FK_Assets_PropertyTypeUnits]
GO
ALTER TABLE [dbo].[Cities]  WITH CHECK ADD  CONSTRAINT [FK_Cities_Countries] FOREIGN KEY([CountryID])
REFERENCES [dbo].[Countries] ([CountryID])
GO
ALTER TABLE [dbo].[Cities] CHECK CONSTRAINT [FK_Cities_Countries]
GO
ALTER TABLE [dbo].[DealPlatforms]  WITH CHECK ADD  CONSTRAINT [FK_DealPlatforms_Departments] FOREIGN KEY([DepartmentID])
REFERENCES [dbo].[Departments] ([DepartmentID])
GO
ALTER TABLE [dbo].[DealPlatforms] CHECK CONSTRAINT [FK_DealPlatforms_Departments]
GO
ALTER TABLE [dbo].[Deals]  WITH CHECK ADD  CONSTRAINT [FK_Deals_DealStages] FOREIGN KEY([StageID])
REFERENCES [dbo].[DealStages] ([StageID])
GO
ALTER TABLE [dbo].[Deals] CHECK CONSTRAINT [FK_Deals_DealStages]
GO
ALTER TABLE [dbo].[Deals]  WITH CHECK ADD  CONSTRAINT [FK_Deals_DealTypes] FOREIGN KEY([DealTypeID])
REFERENCES [dbo].[DealTypes] ([DealTypeID])
GO
ALTER TABLE [dbo].[Deals] CHECK CONSTRAINT [FK_Deals_DealTypes]
GO
ALTER TABLE [dbo].[Deals]  WITH CHECK ADD  CONSTRAINT [FK_Deals_Offices] FOREIGN KEY([OfficeID])
REFERENCES [dbo].[Offices] ([OfficeID])
GO
ALTER TABLE [dbo].[Deals] CHECK CONSTRAINT [FK_Deals_Offices]
GO
ALTER TABLE [dbo].[DealsToClients]  WITH CHECK ADD  CONSTRAINT [FK_DealsToClients_Clients] FOREIGN KEY([ClientID])
REFERENCES [dbo].[Clients] ([ClientID])
GO
ALTER TABLE [dbo].[DealsToClients] CHECK CONSTRAINT [FK_DealsToClients_Clients]
GO
ALTER TABLE [dbo].[DealsToClients]  WITH CHECK ADD  CONSTRAINT [FK_DealsToClients_Deals] FOREIGN KEY([DealID])
REFERENCES [dbo].[Deals] ([DealID])
GO
ALTER TABLE [dbo].[DealsToClients] CHECK CONSTRAINT [FK_DealsToClients_Deals]
GO
ALTER TABLE [dbo].[DealsToClients]  WITH CHECK ADD  CONSTRAINT [FK_DealsToClients_InvestorTypes] FOREIGN KEY([InvestorTypeID])
REFERENCES [dbo].[InvestorTypes] ([InvestorTypeID])
GO
ALTER TABLE [dbo].[DealsToClients] CHECK CONSTRAINT [FK_DealsToClients_InvestorTypes]
GO
ALTER TABLE [dbo].[DealTypes]  WITH NOCHECK ADD  CONSTRAINT [FK_DealTypes_DealPlatforms] FOREIGN KEY([PlatformID])
REFERENCES [dbo].[DealPlatforms] ([PlatformID])
GO
ALTER TABLE [dbo].[DealTypes] CHECK CONSTRAINT [FK_DealTypes_DealPlatforms]
GO
ALTER TABLE [dbo].[DealTypes]  WITH CHECK ADD  CONSTRAINT [FK_DealTypes_DealTypeGroups] FOREIGN KEY([TransactionTypeID])
REFERENCES [dbo].[DealTransactionTypes] ([TransactionTypeID])
GO
ALTER TABLE [dbo].[DealTypes] CHECK CONSTRAINT [FK_DealTypes_DealTypeGroups]
GO
ALTER TABLE [dbo].[DealTypes]  WITH CHECK ADD  CONSTRAINT [FK_DealVolumeRuleTypes_DealTypes] FOREIGN KEY([VolumeRuleTypeID])
REFERENCES [dbo].[DealVolumeRuleTypes] ([VolumeRuleTypeID])
GO
ALTER TABLE [dbo].[DealTypes] CHECK CONSTRAINT [FK_DealVolumeRuleTypes_DealTypes]
GO
ALTER TABLE [dbo].[Employees]  WITH CHECK ADD  CONSTRAINT [FK_Employees_Employees] FOREIGN KEY([SupervisorID])
REFERENCES [dbo].[Employees] ([EmployeeID])
GO
ALTER TABLE [dbo].[Employees] CHECK CONSTRAINT [FK_Employees_Employees]
GO
ALTER TABLE [dbo].[Employees]  WITH CHECK ADD  CONSTRAINT [FK_Employees_Employees1] FOREIGN KEY([AssistantID])
REFERENCES [dbo].[Employees] ([EmployeeID])
GO
ALTER TABLE [dbo].[Employees] CHECK CONSTRAINT [FK_Employees_Employees1]
GO
ALTER TABLE [dbo].[Offices]  WITH CHECK ADD  CONSTRAINT [FK_Offices_Employees] FOREIGN KEY([OfficeAdminID])
REFERENCES [dbo].[Employees] ([EmployeeID])
GO
ALTER TABLE [dbo].[Offices] CHECK CONSTRAINT [FK_Offices_Employees]
GO
ALTER TABLE [dbo].[PropertyTypes]  WITH NOCHECK ADD  CONSTRAINT [FK_PropertyTypes_PropertyTypeGroups] FOREIGN KEY([GroupID])
REFERENCES [dbo].[PropertyTypeGroups] ([GroupID])
GO
ALTER TABLE [dbo].[PropertyTypes] CHECK CONSTRAINT [FK_PropertyTypes_PropertyTypeGroups]
GO
ALTER TABLE [dbo].[PropertyTypes]  WITH CHECK ADD  CONSTRAINT [FK_PropertyTypes_PropertyTypes] FOREIGN KEY([ParentID])
REFERENCES [dbo].[PropertyTypes] ([PropertyTypeID])
GO
ALTER TABLE [dbo].[PropertyTypes] CHECK CONSTRAINT [FK_PropertyTypes_PropertyTypes]
GO
ALTER TABLE [dbo].[PropertyTypes]  WITH CHECK ADD  CONSTRAINT [FK_PropertyTypes_PublicPropertyTypes] FOREIGN KEY([PublicPropertyTypeID])
REFERENCES [dbo].[PublicPropertyTypes] ([PublicPropertyTypeID])
GO
ALTER TABLE [dbo].[PropertyTypes] CHECK CONSTRAINT [FK_PropertyTypes_PublicPropertyTypes]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'New Financing = 0, Cash = 1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DealProperties', @level2type=N'COLUMN',@level2name=N'Financing'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Debt - Percentage' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Deals', @level2type=N'COLUMN',@level2name=N'ClosingRate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Oroginal Contract amount (IS Only)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Deals', @level2type=N'COLUMN',@level2name=N'OrigContractAmt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Marketing Date (IS Only)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Deals', @level2type=N'COLUMN',@level2name=N'MarketingDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date Cuttoff For All Offers (IS Only)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Deals', @level2type=N'COLUMN',@level2name=N'OfferCutoffDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Compensation (IS Only for RFP - free-form entry)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Deals', @level2type=N'COLUMN',@level2name=N'RFPCompensation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Indemnity Cap (IS Only - Used on RFP)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Deals', @level2type=N'COLUMN',@level2name=N'IndemnityCap'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Pitch Date (IS Only)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Deals', @level2type=N'COLUMN',@level2name=N'PitchDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Total Capitalization' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Deals', @level2type=N'COLUMN',@level2name=N'TotalCap'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Bitwise Summary of Deal docs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Deals', @level2type=N'COLUMN',@level2name=N'DealDocs'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rolled up property addresses - populated by triggers.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Deals', @level2type=N'COLUMN',@level2name=N'PropertyLocations'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Override for Client Investor Type' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DealsToClients', @level2type=N'COLUMN',@level2name=N'InvestorTypeID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0 = Fixed, 1 = Floating' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'DealTypes', @level2type=N'COLUMN',@level2name=N'FixedFloating'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0 = PhysicalThenLogicalOffice, 1 = LogicalOnly, 2 = Both' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Employees', @level2type=N'COLUMN',@level2name=N'WebAddressMode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Type of unit (e.g. SQ FT, ACRE, UNIT)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PropertyTypes', @level2type=N'COLUMN',@level2name=N'UnitType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1 = Normal, 2 = RCA' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Regions', @level2type=N'COLUMN',@level2name=N'RegionType'
GO