--------------------------------------------------------
--  DDL for Table SRC_JIRA_DE_SNAPSHOTS_ORIGINAL_TB
--------------------------------------------------------

  CREATE TABLE "OTHQ_OWN"."SRC_JIRA_DE_SNAPSHOTS_ORIGINAL_TB" 
   (	"BUSINESS_NEED" VARCHAR2(1024 BYTE) COLLATE "USING_NLS_COMP", 
	"BUSINESS_OBJECTIVE" VARCHAR2(256 BYTE) COLLATE "USING_NLS_COMP", 
	"COMMUNICATION" VARCHAR2(1024 BYTE) COLLATE "USING_NLS_COMP", 
	"COMMUNICATION_FOR_INTEGRATIONS" VARCHAR2(256 BYTE) COLLATE "USING_NLS_COMP", 
	"CUSTOMER_NEED" VARCHAR2(256 BYTE) COLLATE "USING_NLS_COMP", 
	"END_DATE" DATE, 
	"EPIC_LINK" VARCHAR2(26 BYTE) COLLATE "USING_NLS_COMP", 
	"EXTERNAL_RELEASE_NOTES" VARCHAR2(4096 BYTE) COLLATE "USING_NLS_COMP", 
	"FEATURE_TYPE" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"INTERNAL_COMMUNICATION" VARCHAR2(4096 BYTE) COLLATE "USING_NLS_COMP", 
	"MOOD_RING" VARCHAR2(26 BYTE) COLLATE "USING_NLS_COMP", 
	"MOOD_RING_COMMENT" VARCHAR2(1024 BYTE) COLLATE "USING_NLS_COMP", 
	"NSCORP_RECORD_ID" NUMBER(26,0), 
	"NSCORP_RELEASE_TARGET" VARCHAR2(26 BYTE) COLLATE "USING_NLS_COMP", 
	"NSX_VERSION" VARCHAR2(26 BYTE) COLLATE "USING_NLS_COMP", 
	"OBJECTIVE" VARCHAR2(1024 BYTE) COLLATE "USING_NLS_COMP", 
	"SOLUTION" VARCHAR2(4096 BYTE) COLLATE "USING_NLS_COMP", 
	"START_DATE" DATE, 
	"TECHNICAL_WRITER_DISPLAYNAME" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"VALUE_STREAM" VARCHAR2(256 BYTE) COLLATE "USING_NLS_COMP", 
	"VALUE_SUB_STREAM" VARCHAR2(256 BYTE) COLLATE "USING_NLS_COMP", 
	"VALUE_SUB_SUB_STREAM" VARCHAR2(256 BYTE) COLLATE "USING_NLS_COMP", 
	"ASSIGNEE_DISPLAYNAME" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"CREATED" DATE, 
	"DESCRIPTION" VARCHAR2(32767 BYTE) COLLATE "USING_NLS_COMP", 
	"DUEDATE" DATE, 
	"ISSUETYPE" VARCHAR2(26 BYTE) COLLATE "USING_NLS_COMP", 
	"LABELS" VARCHAR2(512 BYTE) COLLATE "USING_NLS_COMP", 
	"PROJECT" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"REPORTER_DISPLAYNAME" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"RESOLUTION" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"RESOLUTIONDATE" DATE, 
	"STATUS" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"SUMMARY" VARCHAR2(1024 BYTE) COLLATE "USING_NLS_COMP", 
	"UPDATED" DATE, 
	"KEY" VARCHAR2(26 BYTE) COLLATE "USING_NLS_COMP", 
	"STATUS_CATEGORY" VARCHAR2(26 BYTE) COLLATE "USING_NLS_COMP", 
	"ASSIGNEE_EMAILADDRESS" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"PROJECT_CATEGORY" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"REPORTER_EMAILADDRESS" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"TECHNICAL_WRITER_EMAILADDRESS" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"PARENT" VARCHAR2(26 BYTE) COLLATE "USING_NLS_COMP", 
	"ISSUELINKS_TYPE" VARCHAR2(256 BYTE) COLLATE "USING_NLS_COMP", 
	"ISSUELINKS_OUTWARDISSUE" VARCHAR2(256 BYTE) COLLATE "USING_NLS_COMP", 
	"ISSUELINKS_INWARDISSUE" VARCHAR2(256 BYTE) COLLATE "USING_NLS_COMP", 
	"PROOF_OF_TESTING" VARCHAR2(4096 BYTE) COLLATE "USING_NLS_COMP", 
	"JIRA_DOWNLOADER_METADATA_SCHEDULED_TIME" DATE, 
	"DOMAIN" VARCHAR2(256 BYTE) COLLATE "USING_NLS_COMP", 
	"RESOLVED_BY_DISPLAYNAME" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"RESOLVED_BY_EMAILADDRESS" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"COMPLETION_PERIOD_CHANGE_REASON" VARCHAR2(4096 BYTE) COLLATE "USING_NLS_COMP", 
	"PRODUCT" VARCHAR2(4096 BYTE) COLLATE "USING_NLS_COMP", 
	"FTE_ESTIMATE" NUMBER, 
	"BLOCKERS" VARCHAR2(4096 BYTE) COLLATE "USING_NLS_COMP", 
	"ID" NUMBER, 
	"TARGET_VERSION" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"COMPLETION_PERIOD" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"FIRST_TRANSITION_TO_IN_PROGRESS" DATE,
	"PRIORITY" VARCHAR2(8 BYTE) COLLATE "USING_NLS_COMP", 
	"PORTFOLIO_TEAM_SELECT" VARCHAR2(64 BYTE) COLLATE "USING_NLS_COMP", 
	"URGENCY_LEVEL" VARCHAR2(8 BYTE) COLLATE "USING_NLS_COMP"
   )  DEFAULT COLLATION "USING_NLS_COMP" SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255 
 COLUMN STORE COMPRESS FOR QUERY HIGH ROW LEVEL LOCKING LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SRC_JIRA_DE_SNAPSHOTS_TB_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "OTHQ_OWN"."SRC_JIRA_DE_SNAPSHOTS_TB_PK" ON "OTHQ_OWN"."SRC_JIRA_DE_SNAPSHOTS_ORIGINAL_TB" ("KEY", "JIRA_DOWNLOADER_METADATA_SCHEDULED_TIME") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  Constraints for Table SRC_JIRA_DE_SNAPSHOTS_ORIGINAL_TB
--------------------------------------------------------

  ALTER TABLE "OTHQ_OWN"."SRC_JIRA_DE_SNAPSHOTS_ORIGINAL_TB" ADD CONSTRAINT "SRC_JIRA_DE_SNAPSHOTS_TB_PK" PRIMARY KEY ("KEY", "JIRA_DOWNLOADER_METADATA_SCHEDULED_TIME")
  USING INDEX "OTHQ_OWN"."SRC_JIRA_DE_SNAPSHOTS_TB_PK"  ENABLE;
  ALTER TABLE "OTHQ_OWN"."SRC_JIRA_DE_SNAPSHOTS_ORIGINAL_TB" MODIFY ("KEY" NOT NULL ENABLE);
  ALTER TABLE "OTHQ_OWN"."SRC_JIRA_DE_SNAPSHOTS_ORIGINAL_TB" MODIFY ("JIRA_DOWNLOADER_METADATA_SCHEDULED_TIME" NOT NULL ENABLE);
