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


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

[SQL_SCRIPT___DEFAULT]

--------------------------------------------------------
--  DDL for Table SRC_ZOOM_INFO_V7_TB
--------------------------------------------------------

  CREATE TABLE "OTHQ_OWN"."SRC_ZOOM_INFO_V7_TB" 
   (	"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
   )  DEFAULT COLLATION "USING_NLS_COMP" SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255 
 COLUMN STORE COMPRESS FOR QUERY HIGH ROW LEVEL LOCKING LOGGING
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_ZOOM_INFO_V7_TB_INDEX1
--------------------------------------------------------

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

~~~END_VERSION_SECTION~~~