| 221 |
vnguyen |
1 |
CREATE TABLE "RELEASE_MANAGER"."UNIT_TESTS"
|
|
|
2 |
( "TEST_ID" NUMBER NOT NULL ENABLE,
|
|
|
3 |
"PV_ID" NUMBER NOT NULL ENABLE,
|
|
|
4 |
"TEST_TYPES_FK" NUMBER NOT NULL ENABLE,
|
|
|
5 |
"TEST_SUMMARY" VARCHAR2(4000),
|
|
|
6 |
"COMPLETION_DATE" DATE,
|
|
|
7 |
"COMPLETED_BY" NUMBER,
|
|
|
8 |
"RESULTS_URL" VARCHAR2(2000),
|
|
|
9 |
"RESULTS_ATTACHMENT_NAME" VARCHAR2(2000),
|
|
|
10 |
"TEST_ACCEPTED" CHAR(1),
|
|
|
11 |
"ACCEPTANCE_DATE" DATE,
|
|
|
12 |
"ACCEPTED_BY" NUMBER,
|
|
|
13 |
"REVIEW_COMMENTS" VARCHAR2(4000),
|
|
|
14 |
"NUMOF_TEST" VARCHAR2(50)
|
|
|
15 |
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
|
|
|
16 |
STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
|
|
|
17 |
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
|
|
|
18 |
TABLESPACE "USERS" ;
|