CREATE TABLE [dbo].[C_B_REF_IND_HIST](
	[HIST_CREATE_DATE] [datetime2](7) NULL,
	[CM_DIRTY_IND] [bigint] NULL,
	[ROWID_OBJECT] [nchar](14) NULL,
	[CREATOR] [nvarchar](50) NULL,
	[CREATE_DATE] [datetime2](7) NULL,
	[UPDATED_BY] [nvarchar](50) NULL,
	[LAST_UPDATE_DATE] [datetime2](7) NULL,
	[CONSOLIDATION_IND] [bigint] NULL,
	[DELETED_IND] [bigint] NULL,
	[DELETED_BY] [nvarchar](50) NULL,
	[DELETED_DATE] [datetime2](7) NULL,
	[LAST_ROWID_SYSTEM] [nchar](14) NULL,
	[DIRTY_IND] [bigint] NULL,
	[INTERACTION_ID] [bigint] NULL,
	[HUB_STATE_IND] [bigint] NULL,
	[QUERY] [nvarchar](256) NULL,
	[FIRST_NM] [nvarchar](50) NULL,
	[MIDDLE_NM] [nvarchar](50) NULL,
	[LAST_NM] [nvarchar](50) NULL,
	[FULL_NM] [nvarchar](200) NULL,
	[YEAR_OF_BIRTH] [nvarchar](5) NULL,
	[AGE_RANGE] [nvarchar](10) NULL,
	[GENDER_CD] [nchar](1) NULL,
	[LOCATION] [nvarchar](200) NULL,
	[CITY] [nvarchar](100) NULL,
	[REGION] [nvarchar](100) NULL,
	[COUNTRY_CD] [nvarchar](250) NULL,
	[ORGANIZATION] [nvarchar](200) NULL,
	[JOB_TITLE] [nvarchar](200) NULL,
	[PRIMARY_PHOTO] [nvarchar](500) NULL,
	[LINKED_IN] [nvarchar](200) NULL,
	[FACEBOOK] [nvarchar](200) NULL,
	[TWITTER] [nvarchar](100) NULL,
	[EMPLMT_DTL] [nvarchar](4000) NULL,
	[EDU_DTL] [nvarchar](4000) NULL,
	[RETURN_CODE] [nvarchar](10) NULL,
	[REFRESH_DATE] [datetime2](0) NULL,
	[REFRESH_FLG] [nvarchar](1) NULL,
	[PRIVATE_PROFILE_IND] [nchar](1) NULL,
	[HAS_CANADIAN_EMAIL] [nchar](1) NULL,
	[PHONE] [nvarchar](250) NULL,
	[DIRECT_PHONE_DO_NOT_CALL] [nchar](1) NULL,
	[METRO_AREA] [nvarchar](100) NULL,
	[ZIP_CODE] [nvarchar](25) NULL,
	[CONTINENT] [nvarchar](75) NULL,
	[PERSON_HAS_MOVED] [nvarchar](50) NULL,
	[WITH_IN_EU] [nchar](1) NULL,
	[WITH_IN_CALIFORNIA] [nchar](1) NULL,
	[WITH_IN_CANADA] [nchar](1) NULL,
	[VALID_DATE] [nvarchar](50) NULL,
	[SRC_LAST_UPDATED_DATE] [nvarchar](50) NULL,
	[NOTICE_PROVIDED_DATE] [nvarchar](50) NULL,
	[SALUTATION] [nvarchar](250) NULL,
	[SUFFIX] [nvarchar](250) NULL,
	[JOB_FUNCTION] [nvarchar](4000) NULL,
	[COMPANY_DIVISION] [nvarchar](250) NULL,
	[HASHED_EMAILS] [nvarchar](4000) NULL,
	[MOBILE_PHONE_DO_NOT_CALL] [nchar](1) NULL,
	[EXTERNAL_URLS] [nvarchar](4000) NULL,
	[COMPANY_ID] [nvarchar](50) NULL,
	[COMPANY_DESCRIPTION] [nvarchar](4000) NULL,
	[COMPANY_PHONE] [nvarchar](25) NULL,
	[COMPANY_FAX] [nvarchar](25) NULL,
	[COMPANY_STREET] [nvarchar](250) NULL,
	[COMPANY_CITY] [nvarchar](100) NULL,
	[COMPANY_STATE] [nvarchar](100) NULL,
	[COMPANY_ZIP_CODE] [nvarchar](25) NULL,
	[COMPANY_COUNTRY] [nvarchar](50) NULL,
	[COMPANY_CONTINENT] [nvarchar](50) NULL,
	[COMPANY_LOGO] [nvarchar](1000) NULL,
	[COMPANY_SIC_CODES] [nvarchar](4000) NULL,
	[COMPANY_NAICS_CODES] [nvarchar](4000) NULL,
	[CONTACT_ACCURACY_SCORE] [nvarchar](10) NULL,
	[COMPANY_WEBSITE] [nvarchar](250) NULL,
	[COMPANY_REVENUE] [nvarchar](50) NULL,
	[COMPANY_REVENUE_NUMERIC] [nvarchar](50) NULL,
	[COMPANY_EMPLOYEE_COUNT] [nvarchar](10) NULL,
	[COMPANY_TYPE] [nvarchar](25) NULL,
	[COMPANY_TICKER] [nvarchar](25) NULL,
	[COMPANY_RANKING] [nvarchar](2000) NULL,
	[IS_DEFUNCT] [nchar](1) NULL,
	[COMPANY_SOCIAL_MEDIA_URLS] [nvarchar](2000) NULL,
	[COMPANY_PRIMARY_INDUSTRY] [nvarchar](1000) NULL,
	[COMPANY_INDUSTRIES] [nvarchar](2500) NULL,
	[COMPANY_REVENUE_RANGE] [nvarchar](250) NULL,
	[COMPANY_EMPLOYEE_RANGE] [nvarchar](250) NULL,
	[MANAGEMENT_LEVEL] [nvarchar](500) NULL,
	[LOCATION_COMPANY_ID] [nvarchar](50) NULL,
	[POSITION_START_DATE] [nvarchar](50) NULL,
	[ZI_EDUCATION] [nvarchar](4000) NULL,
	[ZI_EMPLOYMENT_HISTORY] [nvarchar](4000) NULL
) 
GO

ALTER TABLE [dbo].[C_B_REF_IND_HIST] ADD  CONSTRAINT [DF_C_B_REF_IND_HIST_CREATOR]  DEFAULT ('CMX') FOR [CREATOR]
GO

ALTER TABLE [dbo].[C_B_REF_IND_HIST] ADD  CONSTRAINT [DF_C_B_REF_IND_HIST_CREATE_DATE]  DEFAULT (getdate()) FOR [CREATE_DATE]
GO

ALTER TABLE [dbo].[C_B_REF_IND_HIST] ADD  CONSTRAINT [DF_C_B_REF_IND_HIST_CONSOLIDATION_IND]  DEFAULT ((4)) FOR [CONSOLIDATION_IND]
GO

ALTER TABLE [dbo].[C_B_REF_IND_HIST] ADD  CONSTRAINT [DF_C_B_REF_IND_HIST_HUB_STATE_IND]  DEFAULT ((1)) FOR [HUB_STATE_IND]
GO

ALTER TABLE [dbo].[C_B_REF_IND_HIST] ADD  CONSTRAINT [DF_C_B_REF_IND_HIST_REFRESH_DATE]  DEFAULT (getdate()) FOR [REFRESH_DATE]
GO

ALTER TABLE [dbo].[C_B_REF_IND_HIST] ADD  CONSTRAINT [DF_C_B_REF_IND_HIST_REFRESH_FLG]  DEFAULT ('N') FOR [REFRESH_FLG]
GO