~~~BEGIN_MAIN_SECTION~~~
[PRODUCT]
table=SRC_ZOOM_INFO_VALUABLE_V7_TB
~~~END_MAIN_SECTION~~~


~~~BEGIN_VERSION_SECTION~~~
[VERSION]
version=2025-11-04

[SQL_SCRIPT___DEFAULT]


CREATE TABLE "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" 
   (
	"O_ZI_C_LOCATION_ID" NUMBER,
	"O_ZI_C_COMPANY_ID" NUMBER,
	"O_ZI_C_IS_HQ" VARCHAR2(1 BYTE),
	"O_ZI_ES_ECID" NUMBER,
	"O_ZI_ES_LOCATION_ID" VARCHAR2(19 BYTE),
	"O_ZI_C_TIER_GRADE" VARCHAR2(1 BYTE),
	"O_ZI_C_NAME" VARCHAR2(100 BYTE),
	"O_ZI_C_NAME_DISPLAY" VARCHAR2(311 BYTE),
	"O_ZI_C_LEGAL_ENTITY_TYPE" VARCHAR2(12 BYTE),
	"O_ZI_C_URL" VARCHAR2(262 BYTE),
	"O_ZI_C_STREET" VARCHAR2(986 BYTE),
	"O_ZI_C_STREET_2" VARCHAR2(139 BYTE),
	"O_ZI_C_CITY" VARCHAR2(214 BYTE),
	"O_ZI_C_STATE" VARCHAR2(108 BYTE),
	"O_ZI_C_ZIP" VARCHAR2(391 BYTE),
	"O_ZI_C_COUNTRY" VARCHAR2(203 BYTE),
	"O_ZI_C_CBSA_NAME" VARCHAR2(45 BYTE),
	"O_ZI_C_COUNTY" VARCHAR2(33 BYTE),
	"O_ZI_C_LATITUDE" NUMBER,
	"O_ZI_C_LONGITUDE" NUMBER,
	"O_ZI_C_VERIFIED_ADDRESS" VARCHAR2(1 BYTE),
	"O_ZI_C_EMPLOYEE_RANGE" VARCHAR2(13 BYTE),
	"O_ZI_C_EMPLOYEES" NUMBER,
	"O_ZI_C_REVENUE_RANGE" VARCHAR2(11 BYTE),
	"O_ZI_C_REVENUE" NUMBER,
	"O_ZI_C_PHONE" VARCHAR2(28 BYTE),
	"O_ZI_C_FAX" VARCHAR2(30 BYTE),
	"O_ZI_C_INDUSTRY_PRIMARY" VARCHAR2(30 BYTE),
	"O_ZI_C_SUB_INDUSTRY_PRIMARY" VARCHAR2(73 BYTE),
	"O_ZI_C_INDUSTRIES" VARCHAR2(173 BYTE),
	"O_ZI_C_SUB_INDUSTRIES" VARCHAR2(420 BYTE),
	"O_ZI_ES_INDUSTRY" VARCHAR2(36 BYTE),
	"O_ZI_ES_INDUSTRIES_TOP3" VARCHAR2(109 BYTE),
	"O_ZI_C_NAICS2" VARCHAR2(2 BYTE),
	"O_ZI_C_NAICS4" VARCHAR2(4 BYTE),
	"O_ZI_C_NAICS6" VARCHAR2(6 BYTE),
	"O_ZI_C_NAICS_TOP3" VARCHAR2(20 BYTE),
	"O_ZI_C_SIC2" VARCHAR2(2 BYTE),
	"O_ZI_C_SIC3" VARCHAR2(3 BYTE),
	"O_ZI_C_SIC4" VARCHAR2(4 BYTE),
	"O_ZI_C_SIC_TOP3" VARCHAR2(14 BYTE),
	"O_ZI_C_ESTIMATED_AGE" NUMBER,
	"O_ZI_C_YEAR_FOUNDED" VARCHAR2(4 BYTE),
	"O_ZI_C_IS_B2B" VARCHAR2(1 BYTE),
	"O_ZI_C_IS_B2C" VARCHAR2(1 BYTE),
	"O_ZI_ES_HQ_ECID" NUMBER,
	"O_ZI_ES_HQ_LOCATION_ID" VARCHAR2(19 BYTE),
	"O_ZI_C_COMPANY_NAME" VARCHAR2(100 BYTE),
	"O_ZI_C_COMPANY_URL" VARCHAR2(446 BYTE),
	"O_ZI_C_COMPANY_STREET" VARCHAR2(736 BYTE),
	"O_ZI_C_COMPANY_STREET_2" VARCHAR2(83 BYTE),
	"O_ZI_C_COMPANY_CITY" VARCHAR2(214 BYTE),
	"O_ZI_C_COMPANY_STATE" VARCHAR2(78 BYTE),
	"O_ZI_C_COMPANY_ZIP" VARCHAR2(228 BYTE),
	"O_ZI_C_COMPANY_COUNTRY" VARCHAR2(196 BYTE),
	"O_ZI_C_COMPANY_CBSA_NAME" VARCHAR2(45 BYTE),
	"O_ZI_C_COMPANY_COUNTY" VARCHAR2(33 BYTE),
	"O_ZI_C_COMPANY_LATITUDE" NUMBER,
	"O_ZI_C_COMPANY_LONGITUDE" NUMBER,
	"O_ZI_C_COMPANY_VERIFIED_ADDRESS" VARCHAR2(1 BYTE),
	"O_ZI_C_COMPANY_EMPLOYEE_RANGE" VARCHAR2(13 BYTE),
	"O_ZI_C_COMPANY_EMPLOYEES" NUMBER,
	"O_ZI_C_COMPANY_REVENUE_RANGE" VARCHAR2(11 BYTE),
	"O_ZI_C_COMPANY_REVENUE" NUMBER,
	"O_ZI_C_COMPANY_PHONE" VARCHAR2(28 BYTE),
	"O_ZI_C_COMPANY_FAX" VARCHAR2(30 BYTE),
	"O_ZI_C_LINKEDIN_URL" VARCHAR2(167 BYTE),
	"O_ZI_C_FACEBOOK_URL" VARCHAR2(189 BYTE),
	"O_ZI_C_TWITTER_URL" VARCHAR2(95 BYTE),
	"O_ZI_C_YELP_URL" VARCHAR2(446 BYTE),
	"O_ZI_C_DOMAIN_RANK" NUMBER,
	"O_ZI_C_KEYWORDS" VARCHAR2(3246 BYTE),
	"O_ZI_C_TOP_KEYWORDS" VARCHAR2(290 BYTE),
	"O_ZI_C_NUM_KEYWORDS" NUMBER,
	"O_ZI_C_EMPLOYEE_GROWTH_1YR" NUMBER,
	"O_ZI_C_EMPLOYEE_GROWTH_2YR" NUMBER,
	"O_ZI_ES_GROWTH" VARCHAR2(1 BYTE),
	"O_ZI_ES_EMPLOYEE_GROWTH" VARCHAR2(1 BYTE),
	"O_ZI_ES_REVENUE_GROWTH" VARCHAR2(1 BYTE),
	"O_ZI_ES_PERCENT_EMPLOYEE_GROWTH" NUMBER,
	"O_ZI_ES_PERCENT_REVENUE_GROWTH" NUMBER,
	"O_ZI_C_NAME_CONFIDENCE_SCORE" NUMBER,
	"O_ZI_C_URL_CONFIDENCE_SCORE" NUMBER,
	"O_ZI_C_ADDRESS_CONFIDENCE_SCORE" NUMBER,
	"O_ZI_C_PHONE_CONFIDENCE_SCORE" NUMBER,
	"O_ZI_C_EMPLOYEES_CONFIDENCE_SCORE" NUMBER,
	"O_ZI_C_REVENUE_CONFIDENCE_SCORE" NUMBER,
	"O_ZI_ES_INDUSTRY_CONFIDENCE_SCORE" NUMBER,
	"O_ZI_C_NAICS_CONFIDENCE_SCORE" NUMBER,
	"O_ZI_C_SIC_CONFIDENCE_SCORE" NUMBER,
	"O_ZI_ES_INDUSTRIES_TOP3_CONFIDENCE_SCORES" VARCHAR2(11 BYTE),
	"O_ZI_C_NAICS_TOP3_CONFIDENCE_SCORES" VARCHAR2(11 BYTE),
	"O_ZI_C_SIC_TOP3_CONFIDENCE_SCORES" VARCHAR2(11 BYTE),
	"O_ZI_C_IDS_MERGED" CLOB,
	"O_ZI_C_NAMES_OTHER" VARCHAR2(5000 BYTE),
	"O_ZI_C_URL_STATUS" VARCHAR2(8 BYTE),
	"O_ZI_C_URLS_ALT" VARCHAR2(499 BYTE),
	"O_ZI_C_URL_LAST_UPDATED" VARCHAR2(10 BYTE),
	"O_ZI_C_INACTIVE_FLAG" VARCHAR2(1 BYTE),
	"O_ZI_C_EIN" VARCHAR2(9 BYTE),
	"O_ZI_C_IS_SMALL_BUSINESS" VARCHAR2(1 BYTE),
	"O_ZI_C_IS_PUBLIC" VARCHAR2(1 BYTE),
	"O_ZI_C_TICKER" VARCHAR2(17 BYTE),
	"O_ZI_C_TICKERS_ALT" VARCHAR2(86 BYTE),
	"O_ZI_C_HAS_MOBILE_APP" VARCHAR2(1 BYTE),
	"O_ZI_C_CURRENCY_CODE" VARCHAR2(3 BYTE),
	"O_ZI_C_NUM_LOCATIONS" NUMBER,
	"O_ZI_C_HR_CONTACTS" NUMBER,
	"O_ZI_C_SALES_CONTACTS" NUMBER,
	"O_ZI_C_MARKETING_CONTACTS" NUMBER,
	"O_ZI_C_FINANCE_CONTACTS" NUMBER,
	"O_ZI_C_C_SUITE_CONTACTS" NUMBER,
	"O_ZI_C_ENGINEERING_CONTACTS" NUMBER,
	"O_ZI_C_IT_CONTACTS" NUMBER,
	"O_ZI_C_OPERATIONS_CONTACTS" NUMBER,
	"O_ZI_C_LEGAL_CONTACTS" NUMBER,
	"O_ZI_C_MEDICAL_CONTACTS" NUMBER,
	"O_ZI_C_TECH_IDS" CLOB,
	"O_ZI_C_LATEST_FUNDING_AGE" NUMBER,
	"O_ZI_C_NUM_OF_INVESTORS" NUMBER,
	"O_ZI_C_INVESTOR_NAMES" VARCHAR2(512 BYTE),
	"O_ZI_C_FUNDING_STRENGTH" VARCHAR2(1 BYTE),
	"O_ZI_C_FUNDING_TYPE" VARCHAR2(166 BYTE),
	"O_ZI_C_TOTAL_FUNDING_AMOUNT" NUMBER,
	"O_ZI_C_LATEST_FUNDING_AMOUNT" NUMBER,
	"O_ZI_C_LATEST_FUNDING_DATE" VARCHAR2(10 BYTE),
	"O_ZI_C_NUM_FUNDING_ROUNDS" NUMBER,
	"O_ZI_C_IS_FORTUNE_100" VARCHAR2(1 BYTE),
	"O_ZI_C_IS_FORTUNE_500" VARCHAR2(1 BYTE),
	"O_ZI_C_IS_S_AND_P_500" VARCHAR2(1 BYTE),
	"O_ZI_C_IS_ULTIMATE_PARENT" VARCHAR2(1 BYTE),
	"O_ZI_C_IS_IMMEDIATE_PARENT" VARCHAR2(1 BYTE),
	"O_ZI_C_IS_DOMESTIC_PARENT" VARCHAR2(1 BYTE),
	"O_ZI_C_IS_DOMESTIC_HQ" VARCHAR2(1 BYTE),
	"O_ZI_C_IS_SUBSIDIARY" VARCHAR2(1 BYTE),
	"O_ZI_C_IS_FRANCHISOR" VARCHAR2(1 BYTE),
	"O_ZI_C_IS_FRANCHISEE" VARCHAR2(1 BYTE),
	"O_ZI_C_HIERARCHY_CODE" VARCHAR2(10 BYTE),
	"O_ZI_C_HIERARCHY_LEVEL" NUMBER,
	"O_ZI_C_PARENT_CHILD_CONFIDENCE_SCORE" NUMBER,
	"O_ZI_C_IMMEDIATE_PARENT_COMPANY_ID" NUMBER,
	"O_ZI_ES_IMMEDIATE_PARENT_ECID" NUMBER,
	"O_ZI_ES_IMMEDIATE_PARENT_LOCATION_ID" VARCHAR2(19 BYTE),
	"O_ZI_C_IMMEDIATE_PARENT_NAME" VARCHAR2(99 BYTE),
	"O_ZI_C_IMMEDIATE_PARENT_URL" VARCHAR2(109 BYTE),
	"O_ZI_C_IMMEDIATE_PARENT_STREET" VARCHAR2(152 BYTE),
	"O_ZI_C_IMMEDIATE_PARENT_STREET_2" VARCHAR2(34 BYTE),
	"O_ZI_C_IMMEDIATE_PARENT_CITY" VARCHAR2(83 BYTE),
	"O_ZI_C_IMMEDIATE_PARENT_ZIP" VARCHAR2(50 BYTE),
	"O_ZI_C_IMMEDIATE_PARENT_STATE" VARCHAR2(40 BYTE),
	"O_ZI_C_IMMEDIATE_PARENT_COUNTRY" VARCHAR2(42 BYTE),
	"O_ZI_C_DOMESTIC_PARENT_COMPANY_ID" NUMBER,
	"O_ZI_C_DOMESTIC_PARENT_LOCATION_ID" NUMBER,
	"O_ZI_ES_DOMESTIC_PARENT_ECID" NUMBER,
	"O_ZI_ES_DOMESTIC_PARENT_LOCATION_ID" VARCHAR2(19 BYTE),
	"O_ZI_C_DOMESTIC_PARENT_NAME" VARCHAR2(100 BYTE),
	"O_ZI_C_DOMESTIC_PARENT_URL" VARCHAR2(300 BYTE),
	"O_ZI_C_DOMESTIC_PARENT_STREET" VARCHAR2(736 BYTE),
	"O_ZI_C_DOMESTIC_PARENT_STREET_2" VARCHAR2(71 BYTE),
	"O_ZI_C_DOMESTIC_PARENT_CITY" VARCHAR2(183 BYTE),
	"O_ZI_C_DOMESTIC_PARENT_ZIP" VARCHAR2(228 BYTE),
	"O_ZI_C_DOMESTIC_PARENT_STATE" VARCHAR2(56 BYTE),
	"O_ZI_C_DOMESTIC_PARENT_COUNTRY" VARCHAR2(82 BYTE),
	"O_ZI_C_ULTIMATE_PARENT_COMPANY_ID" NUMBER,
	"O_ZI_ES_ULTIMATE_PARENT_ECID" NUMBER,
	"O_ZI_ES_ULTIMATE_PARENT_LOCATION_ID" VARCHAR2(19 BYTE),
	"O_ZI_C_ULTIMATE_PARENT_NAME" VARCHAR2(99 BYTE),
	"O_ZI_C_ULTIMATE_PARENT_URL" VARCHAR2(109 BYTE),
	"O_ZI_C_ULTIMATE_PARENT_STREET" VARCHAR2(152 BYTE),
	"O_ZI_C_ULTIMATE_PARENT_STREET_2" VARCHAR2(34 BYTE),
	"O_ZI_C_ULTIMATE_PARENT_CITY" VARCHAR2(83 BYTE),
	"O_ZI_C_ULTIMATE_PARENT_ZIP" VARCHAR2(50 BYTE),
	"O_ZI_C_ULTIMATE_PARENT_STATE" VARCHAR2(40 BYTE),
	"O_ZI_C_ULTIMATE_PARENT_COUNTRY" VARCHAR2(42 BYTE),
	"O_ZI_C_FRANCHISOR_COMPANY_ID" NUMBER,
	"O_ZI_ES_FRANCHISOR_ECID" NUMBER,
	"O_ZI_ES_FRANCHISOR_LOCATION_ID" VARCHAR2(19 BYTE),
	"O_ZI_C_FRANCHISOR_NAME" VARCHAR2(48 BYTE),
	"O_ZI_C_FRANCHISOR_URL" VARCHAR2(31 BYTE),
	"O_ZI_C_FRANCHISOR_STREET" VARCHAR2(45 BYTE),
	"O_ZI_C_FRANCHISOR_STREET_2" VARCHAR2(16 BYTE),
	"O_ZI_C_FRANCHISOR_CITY" VARCHAR2(22 BYTE),
	"O_ZI_C_FRANCHISOR_ZIP" VARCHAR2(9 BYTE),
	"O_ZI_C_FRANCHISOR_STATE" VARCHAR2(25 BYTE),
	"O_ZI_C_FRANCHISOR_COUNTRY" VARCHAR2(18 BYTE),
	"O_ZI_C_TECH_SPEND" VARCHAR2(1 BYTE),
	"O_ZI_C_HR_SPEND" VARCHAR2(1 BYTE),
	"O_ZI_C_SALES_SPEND" VARCHAR2(1 BYTE),
	"O_ZI_C_MARKETING_SPEND" VARCHAR2(1 BYTE),
	"O_ZI_C_FINANCE_SPEND" VARCHAR2(1 BYTE),
	"O_ZI_C_TECH_STRENGTH" VARCHAR2(1 BYTE),
	"O_ZI_C_HR_STRENGTH" VARCHAR2(1 BYTE),
	"O_ZI_C_SALES_STRENGTH" VARCHAR2(1 BYTE),
	"O_ZI_C_MARKETING_STRENGTH" VARCHAR2(1 BYTE),
	"O_ZI_C_FINANCE_STRENGTH" VARCHAR2(1 BYTE),
	"O_ZI_C_TECH_SOPHISTICATION" VARCHAR2(1 BYTE),
	"O_ZI_C_HR_SOPHISTICATION" VARCHAR2(1 BYTE),
	"O_ZI_C_SALES_SOPHISTICATION" VARCHAR2(1 BYTE),
	"O_ZI_C_MARKETING_SOPHISTICATION" VARCHAR2(1 BYTE),
	"O_ZI_C_SOCIAL_SOPHISTICATION" VARCHAR2(1 BYTE),
	"O_ZI_C_FINANCE_SOPHISTICATION" VARCHAR2(1 BYTE),
	"O_ZI_C_LAST_UPDATED_DATE" VARCHAR2(10 BYTE),
	"O_ZI_C_RELEASE_DATE" VARCHAR2(6 BYTE),
	
	"ZI_C_COMPANY_ID" NUMBER, 
	"ZI_C_LOCATION_ID" NUMBER, 
	"COMPANY_NAME" VARCHAR2(200 BYTE) COLLATE "USING_NLS_COMP", 
	"NAICS_CODE" VARCHAR2(200 BYTE) COLLATE "USING_NLS_COMP", 
	"FUNCTIONAL_VERTICAL" VARCHAR2(60 BYTE) COLLATE "USING_NLS_COMP", 
	"REVENUE_CATEGORY" VARCHAR2(20 BYTE) COLLATE "USING_NLS_COMP", 
	"REVENUE_RANGE" VARCHAR2(30 BYTE) COLLATE "USING_NLS_COMP", 
	"EMPLOYEE_RANGE" VARCHAR2(20 BYTE) COLLATE "USING_NLS_COMP", 
	"CURRENCY" VARCHAR2(5 BYTE) COLLATE "USING_NLS_COMP", 
	"COUNTRY" VARCHAR2(220 BYTE) COLLATE "USING_NLS_COMP", 
	"STATE" VARCHAR2(120 BYTE) COLLATE "USING_NLS_COMP", 
	"ZIP_CODE" VARCHAR2(420 BYTE) COLLATE "USING_NLS_COMP", 
	"CITY" VARCHAR2(240 BYTE) COLLATE "USING_NLS_COMP", 
	"B2B_OR_B2C" VARCHAR2(10 BYTE) COLLATE "USING_NLS_COMP", 
	"ZI_C_YEAR_FOUNDED" VARCHAR2(4 BYTE) COLLATE "USING_NLS_COMP", 
	"ZI_C_INDUSTRY_PRIMARY" VARCHAR2(40 BYTE) COLLATE "USING_NLS_COMP", 
	"ZI_C_SUB_INDUSTRY_PRIMARY" VARCHAR2(80 BYTE) COLLATE "USING_NLS_COMP", 
	"ZI_C_IS_B2B" NUMBER, 
	"ZI_C_IS_B2C" NUMBER, 
	"NAICS2_SECTOR" VARCHAR2(200 BYTE) COLLATE "USING_NLS_COMP", 
	"NAICS3_SUB_SECTOR" VARCHAR2(200 BYTE) COLLATE "USING_NLS_COMP", 
	"NAICS4_INDUSTRY_GROUP" VARCHAR2(200 BYTE) COLLATE "USING_NLS_COMP", 
	"NAICS5_INDUSTRY" VARCHAR2(200 BYTE) COLLATE "USING_NLS_COMP", 
	"ZI_C_SIC2" VARCHAR2(2 BYTE) COLLATE "USING_NLS_COMP", 
	"ZI_C_SIC3" VARCHAR2(3 BYTE) COLLATE "USING_NLS_COMP", 
	"ZI_C_SIC4" VARCHAR2(4 BYTE) COLLATE "USING_NLS_COMP", 
	"ZI_C_EMPLOYEE_RANGE" VARCHAR2(15 BYTE) COLLATE "USING_NLS_COMP", 
	"ZI_C_EMPLOYEES" NUMBER, 
	"ZI_C_EMPLOYEE_GROWTH_2YR" NUMBER, 
	"ZI_C_IS_SMALL_BUSINESS" VARCHAR2(1 BYTE) COLLATE "USING_NLS_COMP", 
	"ZI_C_REVENUE_RANGE" VARCHAR2(15 BYTE) COLLATE "USING_NLS_COMP", 
	"ZI_C_REVENUE" NUMBER, 
	"ZI_C_URL" VARCHAR2(400 BYTE) COLLATE "USING_NLS_COMP", 
	"ZI_C_NAICS_CONFIDENCE_SCORE" NUMBER, 
	"ZI_C_SIC_CONFIDENCE_SCORE" NUMBER, 
	"ZI_C_EMPLOYEES_CONFIDENCE_SCORE" NUMBER, 
	"ZI_C_VERIFIED_ADDRESS" VARCHAR2(1 BYTE) COLLATE "USING_NLS_COMP", 
	"ZI_C_REVENUE_CONFIDENCE_SCORE" NUMBER, 
	"ZI_C_INACTIVE_FLAG" VARCHAR2(1 BYTE) COLLATE "USING_NLS_COMP", 
	"ZI_C_NAICS2" NUMBER, 
	"ZI_C_NAICS4" NUMBER, 
	"ZI_C_NAICS6" NUMBER, 
	"ZI_C_LAST_UPDATED_DATE" DATE,
	
	"EXT_SCOMPID" NUMBER,
	"EXT_VALUE_ANNUAL_SUB_CUST_ONLY" NUMBER,
	"EXT_NETSUITE_CUSTOMER" NUMBER,
	"EXT_ZOOMINFO_COMPANY_ID" NUMBER

   )  DEFAULT COLLATION "USING_NLS_COMP" SEGMENT CREATION IMMEDIATE;
   
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_LOCATION_ID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_LOCATION_ID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_ID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_ID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IS_HQ_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IS_HQ");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_ECID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_ECID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_LOCATION_ID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_LOCATION_ID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_TIER_GRADE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_TIER_GRADE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_NAME_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_NAME");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_NAME_DISPLAY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_NAME_DISPLAY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_LEGAL_ENTITY_TYPE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_LEGAL_ENTITY_TYPE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_URL_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_URL");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_STREET_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_STREET");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_STREET_2_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_STREET_2");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_CITY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_CITY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_STATE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_STATE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_ZIP_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_ZIP");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COUNTRY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COUNTRY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_CBSA_NAME_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_CBSA_NAME");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COUNTY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COUNTY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_LATITUDE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_LATITUDE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_LONGITUDE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_LONGITUDE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_VERIFIED_ADDRESS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_VERIFIED_ADDRESS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_EMPLOYEE_RANGE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_EMPLOYEE_RANGE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_EMPLOYEES_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_EMPLOYEES");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_REVENUE_RANGE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_REVENUE_RANGE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_REVENUE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_REVENUE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_PHONE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_PHONE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_FAX_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_FAX");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_INDUSTRY_PRIMARY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_INDUSTRY_PRIMARY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_SUB_INDUSTRY_PRIMARY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_SUB_INDUSTRY_PRIMARY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_INDUSTRIES_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_INDUSTRIES");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_SUB_INDUSTRIES_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_SUB_INDUSTRIES");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_INDUSTRY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_INDUSTRY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_INDUSTRIES_TOP3_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_INDUSTRIES_TOP3");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_NAICS2_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_NAICS2");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_NAICS4_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_NAICS4");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_NAICS6_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_NAICS6");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_NAICS_TOP3_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_NAICS_TOP3");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_SIC2_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_SIC2");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_SIC3_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_SIC3");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_SIC4_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_SIC4");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_SIC_TOP3_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_SIC_TOP3");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_ESTIMATED_AGE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_ESTIMATED_AGE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_YEAR_FOUNDED_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_YEAR_FOUNDED");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IS_B2B_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IS_B2B");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IS_B2C_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IS_B2C");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_HQ_ECID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_HQ_ECID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_HQ_LOCATION_ID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_HQ_LOCATION_ID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_NAME_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_NAME");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_URL_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_URL");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_STREET_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_STREET");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_STREET_2_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_STREET_2");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_CITY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_CITY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_STATE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_STATE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_ZIP_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_ZIP");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_COUNTRY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_COUNTRY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_CBSA_NAME_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_CBSA_NAME");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_COUNTY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_COUNTY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_LATITUDE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_LATITUDE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_LONGITUDE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_LONGITUDE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_VERIFIED_ADDRESS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_VERIFIED_ADDRESS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_EMPLOYEE_RANGE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_EMPLOYEE_RANGE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_EMPLOYEES_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_EMPLOYEES");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_REVENUE_RANGE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_REVENUE_RANGE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_REVENUE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_REVENUE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_PHONE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_PHONE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_COMPANY_FAX_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_COMPANY_FAX");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_LINKEDIN_URL_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_LINKEDIN_URL");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_FACEBOOK_URL_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_FACEBOOK_URL");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_TWITTER_URL_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_TWITTER_URL");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_YELP_URL_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_YELP_URL");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_DOMAIN_RANK_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_DOMAIN_RANK");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_KEYWORDS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_KEYWORDS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_TOP_KEYWORDS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_TOP_KEYWORDS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_NUM_KEYWORDS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_NUM_KEYWORDS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_EMPLOYEE_GROWTH_1YR_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_EMPLOYEE_GROWTH_1YR");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_EMPLOYEE_GROWTH_2YR_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_EMPLOYEE_GROWTH_2YR");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_GROWTH_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_GROWTH");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_EMPLOYEE_GROWTH_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_EMPLOYEE_GROWTH");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_REVENUE_GROWTH_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_REVENUE_GROWTH");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_PERCENT_EMPLOYEE_GROWTH_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_PERCENT_EMPLOYEE_GROWTH");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_PERCENT_REVENUE_GROWTH_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_PERCENT_REVENUE_GROWTH");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_NAME_CONFIDENCE_SCORE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_NAME_CONFIDENCE_SCORE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_URL_CONFIDENCE_SCORE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_URL_CONFIDENCE_SCORE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_ADDRESS_CONFIDENCE_SCORE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_ADDRESS_CONFIDENCE_SCORE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_PHONE_CONFIDENCE_SCORE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_PHONE_CONFIDENCE_SCORE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_EMPLOYEES_CONFIDENCE_SCORE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_EMPLOYEES_CONFIDENCE_SCORE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_REVENUE_CONFIDENCE_SCORE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_REVENUE_CONFIDENCE_SCORE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_INDUSTRY_CONFIDENCE_SCORE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_INDUSTRY_CONFIDENCE_SCORE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_NAICS_CONFIDENCE_SCORE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_NAICS_CONFIDENCE_SCORE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_SIC_CONFIDENCE_SCORE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_SIC_CONFIDENCE_SCORE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_INDUSTRIES_TOP3_CONFIDENCE_SCORES_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_INDUSTRIES_TOP3_CONFIDENCE_SCORES");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_NAICS_TOP3_CONFIDENCE_SCORES_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_NAICS_TOP3_CONFIDENCE_SCORES");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_SIC_TOP3_CONFIDENCE_SCORES_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_SIC_TOP3_CONFIDENCE_SCORES");
--CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IDS_MERGED_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IDS_MERGED");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_NAMES_OTHER_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_NAMES_OTHER");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_URL_STATUS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_URL_STATUS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_URLS_ALT_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_URLS_ALT");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_URL_LAST_UPDATED_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_URL_LAST_UPDATED");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_INACTIVE_FLAG_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_INACTIVE_FLAG");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_EIN_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_EIN");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IS_SMALL_BUSINESS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IS_SMALL_BUSINESS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IS_PUBLIC_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IS_PUBLIC");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_TICKER_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_TICKER");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_TICKERS_ALT_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_TICKERS_ALT");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_HAS_MOBILE_APP_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_HAS_MOBILE_APP");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_CURRENCY_CODE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_CURRENCY_CODE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_NUM_LOCATIONS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_NUM_LOCATIONS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_HR_CONTACTS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_HR_CONTACTS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_SALES_CONTACTS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_SALES_CONTACTS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_MARKETING_CONTACTS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_MARKETING_CONTACTS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_FINANCE_CONTACTS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_FINANCE_CONTACTS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_C_SUITE_CONTACTS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_C_SUITE_CONTACTS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_ENGINEERING_CONTACTS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_ENGINEERING_CONTACTS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IT_CONTACTS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IT_CONTACTS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_OPERATIONS_CONTACTS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_OPERATIONS_CONTACTS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_LEGAL_CONTACTS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_LEGAL_CONTACTS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_MEDICAL_CONTACTS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_MEDICAL_CONTACTS");
--CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_TECH_IDS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_TECH_IDS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_LATEST_FUNDING_AGE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_LATEST_FUNDING_AGE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_NUM_OF_INVESTORS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_NUM_OF_INVESTORS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_INVESTOR_NAMES_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_INVESTOR_NAMES");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_FUNDING_STRENGTH_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_FUNDING_STRENGTH");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_FUNDING_TYPE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_FUNDING_TYPE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_TOTAL_FUNDING_AMOUNT_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_TOTAL_FUNDING_AMOUNT");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_LATEST_FUNDING_AMOUNT_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_LATEST_FUNDING_AMOUNT");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_LATEST_FUNDING_DATE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_LATEST_FUNDING_DATE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_NUM_FUNDING_ROUNDS_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_NUM_FUNDING_ROUNDS");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IS_FORTUNE_100_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IS_FORTUNE_100");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IS_FORTUNE_500_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IS_FORTUNE_500");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IS_S_AND_P_500_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IS_S_AND_P_500");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IS_ULTIMATE_PARENT_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IS_ULTIMATE_PARENT");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IS_IMMEDIATE_PARENT_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IS_IMMEDIATE_PARENT");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IS_DOMESTIC_PARENT_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IS_DOMESTIC_PARENT");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IS_DOMESTIC_HQ_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IS_DOMESTIC_HQ");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IS_SUBSIDIARY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IS_SUBSIDIARY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IS_FRANCHISOR_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IS_FRANCHISOR");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IS_FRANCHISEE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IS_FRANCHISEE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_HIERARCHY_CODE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_HIERARCHY_CODE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_HIERARCHY_LEVEL_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_HIERARCHY_LEVEL");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_PARENT_CHILD_CONFIDENCE_SCORE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_PARENT_CHILD_CONFIDENCE_SCORE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IMMEDIATE_PARENT_COMPANY_ID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IMMEDIATE_PARENT_COMPANY_ID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_IMMEDIATE_PARENT_ECID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_IMMEDIATE_PARENT_ECID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_IMMEDIATE_PARENT_LOCATION_ID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_IMMEDIATE_PARENT_LOCATION_ID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IMMEDIATE_PARENT_NAME_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IMMEDIATE_PARENT_NAME");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IMMEDIATE_PARENT_URL_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IMMEDIATE_PARENT_URL");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IMMEDIATE_PARENT_STREET_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IMMEDIATE_PARENT_STREET");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IMMEDIATE_PARENT_STREET_2_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IMMEDIATE_PARENT_STREET_2");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IMMEDIATE_PARENT_CITY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IMMEDIATE_PARENT_CITY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IMMEDIATE_PARENT_ZIP_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IMMEDIATE_PARENT_ZIP");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IMMEDIATE_PARENT_STATE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IMMEDIATE_PARENT_STATE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_IMMEDIATE_PARENT_COUNTRY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_IMMEDIATE_PARENT_COUNTRY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_DOMESTIC_PARENT_COMPANY_ID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_DOMESTIC_PARENT_COMPANY_ID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_DOMESTIC_PARENT_LOCATION_ID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_DOMESTIC_PARENT_LOCATION_ID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_DOMESTIC_PARENT_ECID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_DOMESTIC_PARENT_ECID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_DOMESTIC_PARENT_LOCATION_ID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_DOMESTIC_PARENT_LOCATION_ID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_DOMESTIC_PARENT_NAME_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_DOMESTIC_PARENT_NAME");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_DOMESTIC_PARENT_URL_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_DOMESTIC_PARENT_URL");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_DOMESTIC_PARENT_STREET_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_DOMESTIC_PARENT_STREET");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_DOMESTIC_PARENT_STREET_2_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_DOMESTIC_PARENT_STREET_2");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_DOMESTIC_PARENT_CITY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_DOMESTIC_PARENT_CITY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_DOMESTIC_PARENT_ZIP_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_DOMESTIC_PARENT_ZIP");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_DOMESTIC_PARENT_STATE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_DOMESTIC_PARENT_STATE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_DOMESTIC_PARENT_COUNTRY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_DOMESTIC_PARENT_COUNTRY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_ULTIMATE_PARENT_COMPANY_ID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_ULTIMATE_PARENT_COMPANY_ID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_ULTIMATE_PARENT_ECID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_ULTIMATE_PARENT_ECID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_ULTIMATE_PARENT_LOCATION_ID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_ULTIMATE_PARENT_LOCATION_ID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_ULTIMATE_PARENT_NAME_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_ULTIMATE_PARENT_NAME");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_ULTIMATE_PARENT_URL_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_ULTIMATE_PARENT_URL");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_ULTIMATE_PARENT_STREET_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_ULTIMATE_PARENT_STREET");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_ULTIMATE_PARENT_STREET_2_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_ULTIMATE_PARENT_STREET_2");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_ULTIMATE_PARENT_CITY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_ULTIMATE_PARENT_CITY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_ULTIMATE_PARENT_ZIP_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_ULTIMATE_PARENT_ZIP");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_ULTIMATE_PARENT_STATE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_ULTIMATE_PARENT_STATE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_ULTIMATE_PARENT_COUNTRY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_ULTIMATE_PARENT_COUNTRY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_FRANCHISOR_COMPANY_ID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_FRANCHISOR_COMPANY_ID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_FRANCHISOR_ECID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_FRANCHISOR_ECID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_ES_FRANCHISOR_LOCATION_ID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_ES_FRANCHISOR_LOCATION_ID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_FRANCHISOR_NAME_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_FRANCHISOR_NAME");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_FRANCHISOR_URL_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_FRANCHISOR_URL");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_FRANCHISOR_STREET_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_FRANCHISOR_STREET");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_FRANCHISOR_STREET_2_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_FRANCHISOR_STREET_2");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_FRANCHISOR_CITY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_FRANCHISOR_CITY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_FRANCHISOR_ZIP_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_FRANCHISOR_ZIP");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_FRANCHISOR_STATE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_FRANCHISOR_STATE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_FRANCHISOR_COUNTRY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_FRANCHISOR_COUNTRY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_TECH_SPEND_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_TECH_SPEND");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_HR_SPEND_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_HR_SPEND");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_SALES_SPEND_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_SALES_SPEND");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_MARKETING_SPEND_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_MARKETING_SPEND");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_FINANCE_SPEND_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_FINANCE_SPEND");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_TECH_STRENGTH_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_TECH_STRENGTH");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_HR_STRENGTH_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_HR_STRENGTH");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_SALES_STRENGTH_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_SALES_STRENGTH");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_MARKETING_STRENGTH_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_MARKETING_STRENGTH");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_FINANCE_STRENGTH_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_FINANCE_STRENGTH");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_TECH_SOPHISTICATION_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_TECH_SOPHISTICATION");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_HR_SOPHISTICATION_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_HR_SOPHISTICATION");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_SALES_SOPHISTICATION_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_SALES_SOPHISTICATION");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_MARKETING_SOPHISTICATION_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_MARKETING_SOPHISTICATION");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_SOCIAL_SOPHISTICATION_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_SOCIAL_SOPHISTICATION");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_FINANCE_SOPHISTICATION_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_FINANCE_SOPHISTICATION");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_LAST_UPDATED_DATE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_LAST_UPDATED_DATE");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_ZI_C_RELEASE_DATE_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("O_ZI_C_RELEASE_DATE");



--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX1
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX1" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_LOCATION_ID") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX10
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX10" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("STATE") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX11
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX11" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZIP_CODE") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX12
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX12" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("CITY") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX13
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX13" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("B2B_OR_B2C") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX14
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX14" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_YEAR_FOUNDED") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX15
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX15" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_INDUSTRY_PRIMARY") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX16
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX16" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_SUB_INDUSTRY_PRIMARY") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX17
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX17" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_IS_B2B") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX18
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX18" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_IS_B2C") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX19
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX19" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("NAICS2_SECTOR") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX2
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX2" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("COMPANY_NAME") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX20
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX20" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("NAICS3_SUB_SECTOR") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX21
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX21" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("NAICS4_INDUSTRY_GROUP") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX22
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX22" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("NAICS5_INDUSTRY") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX23
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX23" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_SIC2") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX24
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX24" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_SIC3") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX25
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX25" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_SIC4") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX26
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX26" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_EMPLOYEE_RANGE") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX27
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX27" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_EMPLOYEES") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX28
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX28" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_EMPLOYEE_GROWTH_2YR") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX29
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX29" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_IS_SMALL_BUSINESS") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX3
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX3" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("NAICS_CODE") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX30
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX30" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_REVENUE_RANGE") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX31
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX31" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_REVENUE") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX32
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX32" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_URL") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX33
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX33" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_NAICS_CONFIDENCE_SCORE") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX34
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX34" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_SIC_CONFIDENCE_SCORE") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX35
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX35" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_EMPLOYEES_CONFIDENCE_SCORE") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX36
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX36" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_VERIFIED_ADDRESS") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX37
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX37" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_REVENUE_CONFIDENCE_SCORE") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX38
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX38" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_INACTIVE_FLAG") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX39
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX39" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_NAICS2") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX4
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX4" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("FUNCTIONAL_VERTICAL") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX40
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX40" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_NAICS4") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX41
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX41" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_NAICS6") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX42
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX42" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_LAST_UPDATED_DATE") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX5
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX5" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("REVENUE_CATEGORY") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX6
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX6" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("REVENUE_RANGE") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX7
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("EMPLOYEE_RANGE") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX8
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX8" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("CURRENCY") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX9
--------------------------------------------------------

  CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_INDEX9" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("COUNTRY") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_VALUABLE_V7_TB_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB_PK" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("ZI_C_COMPANY_ID") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  Constraints for Table SRC_ZOOM_INFO_VALUABLE_V7_TB
--------------------------------------------------------

  ALTER TABLE "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" MODIFY ("ZI_C_COMPANY_ID" NOT NULL ENABLE);
  ALTER TABLE "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ADD CONSTRAINT "SRC_ZOOM_INFO_VALUABLE_V7_TB_PK" PRIMARY KEY ("ZI_C_COMPANY_ID")
  USING INDEX PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA"  ENABLE;


CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_EXT_SCOMPID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("EXT_SCOMPID");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_EXT_VALUE_ANNUAL_SUB_CUST_ONLY_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("EXT_VALUE_ANNUAL_SUB_CUST_ONLY");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_EXT_NETSUITE_CUSTOMER_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("EXT_NETSUITE_CUSTOMER");
CREATE INDEX "OTHQ_OWN"."SRC_ZOOM_INFO_TB_INDEX_EXT_ZOOMINFO_COMPANY_ID_VALUABLE_V7" ON "OTHQ_OWN"."SRC_ZOOM_INFO_VALUABLE_V7_TB" ("EXT_ZOOMINFO_COMPANY_ID");

~~~END_VERSION_SECTION~~~