| 221 |
vnguyen |
1 |
CREATE TABLE "RELEASE_MANAGER"."CODE_REVIEWS"
|
|
|
2 |
( "PV_ID" NUMBER NOT NULL ENABLE,
|
|
|
3 |
"DATE_OF_REVIEW" DATE,
|
|
|
4 |
"TIME_SPENT" FLOAT(126),
|
|
|
5 |
"REVIEW_REASON" VARCHAR2(4000),
|
|
|
6 |
"RTEAM_DOMAIN_EXPERT" VARCHAR2(4000),
|
|
|
7 |
"RTEAM_LANGUAGE_EXPERT" VARCHAR2(4000),
|
|
|
8 |
"RTEAM_PEER_DEVELOPER" VARCHAR2(4000),
|
|
|
9 |
"RTEAM_AUTHOR" VARCHAR2(4000),
|
|
|
10 |
"FILES_REVIEWED" VARCHAR2(4000),
|
|
|
11 |
"REVIEW_RESULTS" NUMBER,
|
|
|
12 |
"ISSUES_RAISED" VARCHAR2(4000),
|
|
|
13 |
"REVIEW_COMMENTS" VARCHAR2(4000),
|
|
|
14 |
"FNC_S_MEETS_FUNCTIONALITY" CHAR(1),
|
|
|
15 |
"FNC_C_MEETS_FUNCTIONALITY" VARCHAR2(4000),
|
|
|
16 |
"RBS_S_BOUND_COND_HANDLED" CHAR(1),
|
|
|
17 |
"RBS_C_BOUND_COND_HANDLED" VARCHAR2(4000),
|
|
|
18 |
"RBS_S_CLASS_INTERF_PRECOND" CHAR(1),
|
|
|
19 |
"RBS_C_CLASS_INTERF_PRECOND" VARCHAR2(4000),
|
|
|
20 |
"RBS_S_NO_UNITIALISED_DATE" CHAR(1),
|
|
|
21 |
"RBS_C_NO_UNITIALISED_DATE" VARCHAR2(4000),
|
|
|
22 |
"RBS_S_EXCEP_HANDING" CHAR(1),
|
|
|
23 |
"RBS_C_EXCEP_HANDING" VARCHAR2(4000),
|
|
|
24 |
"RBS_S_RESOURCE_MNG" CHAR(1),
|
|
|
25 |
"RBS_C_RESOURCE_MNG" VARCHAR2(4000),
|
|
|
26 |
"RBS_S_TRANS_COMPLET" CHAR(1),
|
|
|
27 |
"RBS_C_TRANS_COMPLET" VARCHAR2(4000),
|
|
|
28 |
"RBS_S_THREADSAFETY" CHAR(1),
|
|
|
29 |
"RBS_C_THREADSAFETY" VARCHAR2(4000),
|
|
|
30 |
"RBS_S_RET_VALS" CHAR(1),
|
|
|
31 |
"RBS_C_RET_VALS" VARCHAR2(4000),
|
|
|
32 |
"RBS_S_CORR_ERR_HANDLING" CHAR(1),
|
|
|
33 |
"RBS_C_CORR_ERR_HANDLING" VARCHAR2(4000),
|
|
|
34 |
"RBS_S_SQL_STD" CHAR(1),
|
|
|
35 |
"RBS_C_SQL_STD" VARCHAR2(4000),
|
|
|
36 |
"MNT_S_EXT_REF" CHAR(1),
|
|
|
37 |
"MNT_C_EXT_REF" VARCHAR2(4000),
|
|
|
38 |
"MNT_S_CLASS_SIZE" CHAR(1),
|
|
|
39 |
"MNT_C_CLASS_SIZE" VARCHAR2(4000),
|
|
|
40 |
"MNT_S_METHOD_SIZE" CHAR(1),
|
|
|
41 |
"MNT_C_METHOD_SIZE" VARCHAR2(4000),
|
|
|
42 |
"MNT_S_APPROP_COMM" CHAR(1),
|
|
|
43 |
"MNT_C_APPROP_COMM" VARCHAR2(4000),
|
|
|
44 |
"MNT_S_IDENT_NAME_STD" CHAR(1),
|
|
|
45 |
"MNT_C_IDENT_NAME_STD" VARCHAR2(4000),
|
|
|
46 |
"MNT_S_SWITCH_HAVE_DEFAULTS" CHAR(1),
|
|
|
47 |
"MNT_C_SWITCH_HAVE_DEFAULTS" VARCHAR2(4000),
|
|
|
48 |
"MNT_S_NO_LIT_NUM" CHAR(1),
|
|
|
49 |
"MNT_C_NO_LIT_NUM" VARCHAR2(4000),
|
|
|
50 |
"MNT_S_NO_DEAD_CODE" CHAR(1),
|
|
|
51 |
"MNT_C_NO_DEAD_CODE" VARCHAR2(4000),
|
|
|
52 |
"DEI_S_STD_DES_PATT" CHAR(1),
|
|
|
53 |
"DEI_C_STD_DES_PATT" VARCHAR2(4000),
|
|
|
54 |
"DEI_S_APPROP_ALGOR" CHAR(1),
|
|
|
55 |
"DEI_C_APPROP_ALGOR" VARCHAR2(4000),
|
|
|
56 |
"DEI_S_APPROP_OBJ" CHAR(1),
|
|
|
57 |
"DEI_C_APPROP_OBJ" VARCHAR2(4000),
|
|
|
58 |
"DEI_S_APPROP_ERR_MSG" CHAR(1),
|
|
|
59 |
"DEI_C_APPROP_ERR_MSG" VARCHAR2(4000),
|
|
|
60 |
"DEI_S_STD_FRAMEW_COMP" CHAR(1),
|
|
|
61 |
"DEI_C_STD_FRAMEW_COMP" VARCHAR2(4000),
|
|
|
62 |
"DEI_S_APPROP_LOGGING" CHAR(1),
|
|
|
63 |
"DEI_C_APPROP_LOGGING" VARCHAR2(4000)
|
|
|
64 |
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
|
|
|
65 |
STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
|
|
|
66 |
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
|
|
|
67 |
TABLESPACE "USERS" ;
|