| 221 |
vnguyen |
1 |
CREATE TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS"
|
|
|
2 |
( "PV_ID" NUMBER NOT NULL ENABLE,
|
|
|
3 |
"PKG_ID" NUMBER NOT NULL ENABLE,
|
|
|
4 |
"PKG_VERSION" VARCHAR2(50) NOT NULL ENABLE,
|
|
|
5 |
"DLOCKED" CHAR(1) NOT NULL ENABLE,
|
|
|
6 |
"RELEASED_AT" NUMBER,
|
|
|
7 |
"MODIFIED_STAMP" DATE,
|
|
|
8 |
"MODIFIER_ID" NUMBER NOT NULL ENABLE,
|
|
|
9 |
"CREATED_STAMP" DATE,
|
|
|
10 |
"CREATOR_ID" NUMBER NOT NULL ENABLE,
|
|
|
11 |
"COMMENTS" VARCHAR2(4000),
|
|
|
12 |
"V_MM" VARCHAR2(50),
|
|
|
13 |
"V_NMM" VARCHAR2(50),
|
|
|
14 |
"V_EXT" VARCHAR2(50),
|
|
|
15 |
"PKG_LABEL" VARCHAR2(60),
|
|
|
16 |
"SRC_PATH" VARCHAR2(2000),
|
|
|
17 |
"PV_DESCRIPTION" VARCHAR2(4000),
|
|
|
18 |
"OWNER_ID" NUMBER NOT NULL ENABLE,
|
|
|
19 |
"PV_OVERVIEW" VARCHAR2(4000),
|
|
|
20 |
"IS_PATCH" CHAR(1),
|
|
|
21 |
"LAST_PV_ID" NUMBER NOT NULL ENABLE,
|
|
|
22 |
"RELEASE_NOTES_INFO" VARCHAR2(1000),
|
|
|
23 |
"IS_DEPLOYABLE" CHAR(1),
|
|
|
24 |
"IS_BUILD_ENV_REQUIRED" CHAR(1),
|
|
|
25 |
"IS_OBSOLETE" CHAR(1),
|
|
|
26 |
"OBSOLETE_COMMENTS" VARCHAR2(4000),
|
|
|
27 |
"BUILD_TYPE" CHAR(1) NOT NULL ENABLE,
|
|
|
28 |
"CHANGE_TYPE" CHAR(1),
|
|
|
29 |
"LINK" VARCHAR2(4000),
|
|
|
30 |
"PATCH_ELECTRONIC_NAME" VARCHAR2(4000),
|
|
|
31 |
"BS_ID" NUMBER,
|
|
|
32 |
"IS_AUTOBUILDABLE" CHAR(1),
|
|
|
33 |
"SBOM_PRIORITY" CHAR(1),
|
|
|
34 |
"RIPPLE_FIELD" CHAR(1 CHAR),
|
|
|
35 |
"MAXIMUM_BUILD_TIME" NUMBER,
|
|
|
36 |
"ESTIMATED_COMPLETION_TIME" DATE
|
|
|
37 |
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
|
|
|
38 |
STORAGE(INITIAL 196608 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645
|
|
|
39 |
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
|
|
|
40 |
TABLESPACE "SYSTEM" ;
|