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


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

[SQL_SCRIPT___DEFAULT]


--------------------------------------------------------
--  DDL for Table SRC_PEM_MACS_DEVELOP_CODE_CHURN_APPLICATION_TB
--------------------------------------------------------

  CREATE TABLE "OTHQ_OWN"."SRC_PEM_MACS_DEVELOP_CODE_CHURN_APPLICATION_TB" 
   (	"TIMESTAMP" DATE, 
	"ADDED_LINES" NUMBER, 
	"AUTHOR_EMAIL" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"AUTHOR_TEAM" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"BLANK_LINES" NUMBER, 
	"BRANCH" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"BUGS" NUMBER, 
	"CODE_SMELLS" NUMBER, 
	"COGNITIVE_COMPLEXITY" NUMBER, 
	"COGNITIVE_COMPLEXITY_RATING" NUMBER, 
	"COMMIT_AUTHOR" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"COMMIT_DATE" DATE, 
	"COMMIT_ID" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"COMMIT_MESSAGE" VARCHAR2(1024 BYTE) COLLATE "USING_NLS_COMP", 
	"CONDITIONS_TO_COVER" NUMBER, 
	"COVERAGE_FULLSTACK" NUMBER, 
	"COVERAGE_NONSTACK" NUMBER, 
	"COVERAGE_RATING" NUMBER, 
	"COVERED_CONDITIONS" NUMBER, 
	"COVERED_LINES" NUMBER, 
	"DELETED_LINES" NUMBER, 
	"FILE_HASHCODE" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"FILE_PATH" VARCHAR2(4096 BYTE) COLLATE "USING_NLS_COMP", 
	"FILENAME" VARCHAR2(256 BYTE) COLLATE "USING_NLS_COMP", 
	"INTEGRATION_TIME" NUMBER, 
	"IS_TEST" NUMBER, 
	"IS_TEST_FILE" NUMBER, 
	"ISSUE_CREATION_DATE" DATE, 
	"ISSUE_INTERNAL_ID" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"ISSUE_NUMBER" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"ISSUE_PRODUCT_TEAM" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"ISSUE_TYPE" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"LANGUAGE" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"LINES_OF_CODE" NUMBER, 
	"LINES_OF_COMMENT" NUMBER, 
	"LINES_TO_COVER" NUMBER, 
	"MAINTAINABILITY_RATING" NUMBER, 
	"MAX_INDENTATION" NUMBER, 
	"MEAN_INDENTATION_PER_LINE" NUMBER, 
	"MERGE_COMMIT_ID" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"MODIFIED_LINES" NUMBER, 
	"MODULE_NAME" VARCHAR2(1024 BYTE) COLLATE "USING_NLS_COMP", 
	"MODULE_TYPE" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"OWNERSHIP" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"PRODUCT" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"PRODUCTTEAM" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"RELIABILITY_RATING" NUMBER, 
	"SECURITY_RATING" NUMBER, 
	"SOURCE_TYPE" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"STANDARD_DEVIATION_INDENTATION" NUMBER, 
	"TAGS" VARCHAR2(1024 BYTE) COLLATE "USING_NLS_COMP", 
	"TECHNICAL_DEBT_IN_MINUTES" NUMBER, 
	"TOTAL_CHANGED_FILES" NUMBER, 
	"TOTAL_INDENTATION" NUMBER, 
	"UNCOVERED_CONDITIONS" NUMBER, 
	"UNCOVERED_LINES" NUMBER, 
	"VULNERABILITIES" NUMBER
   )  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_PEM_MACS_DEVELOP_CODE_CHURN_APPLICATION_TB_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "OTHQ_OWN"."SRC_PEM_MACS_DEVELOP_CODE_CHURN_APPLICATION_TB_PK" ON "OTHQ_OWN"."SRC_PEM_MACS_DEVELOP_CODE_CHURN_APPLICATION_TB" ("FILE_PATH", "COMMIT_ID") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  Constraints for Table SRC_PEM_MACS_DEVELOP_CODE_CHURN_APPLICATION_TB
--------------------------------------------------------

  ALTER TABLE "OTHQ_OWN"."SRC_PEM_MACS_DEVELOP_CODE_CHURN_APPLICATION_TB" MODIFY ("COMMIT_ID" NOT NULL ENABLE);
  ALTER TABLE "OTHQ_OWN"."SRC_PEM_MACS_DEVELOP_CODE_CHURN_APPLICATION_TB" MODIFY ("FILE_PATH" NOT NULL ENABLE);
  ALTER TABLE "OTHQ_OWN"."SRC_PEM_MACS_DEVELOP_CODE_CHURN_APPLICATION_TB" ADD CONSTRAINT "SRC_PEM_MACS_DEVELOP_CODE_CHURN_APPLICATION_TB_PK" PRIMARY KEY ("FILE_PATH", "COMMIT_ID")
  USING INDEX PCTFREE 10 INITRANS 20 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "DATA"  ENABLE;

~~~END_VERSION_SECTION~~~

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

[SQL_SCRIPT___DEFAULT]
ALTER TABLE SRC_PEM_MACS_DEVELOP_CODE_CHURN_APPLICATION_TB ADD MERGE_REQUEST_IID NUMBER;
~~~END_VERSION_SECTION~~~