| 221 |
vnguyen |
1 |
CREATE TABLE "RELEASE_MANAGER"."VALIDATION_RULES"
|
|
|
2 |
( "FIELD_NAME" VARCHAR2(1000) NOT NULL ENABLE,
|
|
|
3 |
"IS_REQUIRED" CHAR(1) NOT NULL ENABLE,
|
|
|
4 |
"IS_NUMERIC" CHAR(1),
|
|
|
5 |
"MIN_NUMERIC_VALUE" NUMBER,
|
|
|
6 |
"MAX_NUMERIC_VALUE" NUMBER,
|
|
|
7 |
"IS_DATE" CHAR(1),
|
|
|
8 |
"START_DATE" DATE,
|
|
|
9 |
"END_DATE" DATE,
|
|
|
10 |
"MIN_STRING_LENGTH" NUMBER,
|
|
|
11 |
"MAX_STRING_LENGTH" NUMBER,
|
|
|
12 |
"REGEXP" VARCHAR2(4000),
|
|
|
13 |
"REGEXP_DESCRIPTION" VARCHAR2(50)
|
|
|
14 |
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
|
|
|
15 |
STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
|
|
|
16 |
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
|
|
|
17 |
TABLESPACE "USERS" ;
|