- 论坛徽章:
- 0
|
建表语句如下:
CREATE TABLE SO_FEE
(
DEPENDENCE_ID NUMBER(9) NOT NULL,
MASTER_TASK_TEMPLATE_ID NUMBER(7) NOT NULL,
DEPENDED_TASK_TEMPLATE_ID NUMBER(7) NOT NULL,
RULE_ID NUMBER( NULL,
INURE_TIME DATE NOT NULL,
EXPIRE_TIME DATE NOT NULL,
INSERT_TIME DATE NOT NULL,
"YEAR" VARCHAR2(50 Char) NOT NULL,
"MONTH" VARCHAR2(50 Char) NOT NULL,
DAY_OF_MONTH VARCHAR2(50 Char) NOT NULL,
"HOUR" VARCHAR2(50 Char) NOT NULL,
"MINUTE" VARCHAR2(50 Char) NOT NULL,
WEEK VARCHAR2(50 Char) NOT NULL,
DAY_OF_WEEK VARCHAR2(50 Char) NOT NULL
);
不明白的是:
"YEAR" VARCHAR2(50 Char) NOT NULL,
哪位仁兄知道什么意思,还烦告之! |
|