（一） 创建数据库表和关系

DROP TABLE NewsType;

CREATE TABLE NewsType

(

    TypeID NUMBER(10) PRIMARY KEY NOT NULL,

    TypeName VARCHAR2(400) NOT NULL,

    DirName   VARCHAR2(400) NOT NULL,

    TemplateName VARCHAR2(400) NOT NULL

);

DROP SEQUENCE NEWSTYPE_SEQ;

CREATE SEQUENCE NEWSTYPE_SEQ INCREMENT BY 1 START WITH 1;



DROP TABLE News;

CREATE TABLE News

(

    NewsID NUMBER(10) PRIMARY KEY NOT NULL,

    TypeID NUMBER(10) NOT NULL,

    Title VARCHAR2(400) NOT NULL,

    HitCount NUMBER(10) DEFAULT 0 NOT NULL,

    IssuseDate DATE NOT NULL,

    DeployerID NUMBER(10) NOT NULL,

    Origin VARCHAR2(400) NOT NULL,

    URL VARCHAR2(400) NOT NULL,

    KEYWORDS VARCHAR(400) ,

    Priority NUMBER(10) DEFAULT 0 NOT NULL,

    Special VARCHAR2(400) ,

    Description VARCHAR2(400),

    Author VARCHAR2(400),

    Topic   VARCHAR2(400)

);

DROP SEQUENCE NEWS_SEQ;

CREATE SEQUENCE NEWS_SEQ INCREMENT BY 1 START WITH 1;

在 oralce 中，设置数据表的约束关系如下图：

1 2 3 下一页>>