-- Create table
create table ARTICLE
(
APP_ARTICLE_ID VARCHAR2(16) not null,
ARTICLE_CONTENT VARCHAR2(4000),
ARTICLE_EDITOR VARCHAR2(32),
ARTICLE_PICTURE VARCHAR2(256),
DATE DATE,
ARTICLE_TITLE VARCHAR2(256)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table ARTICLE
is '文章数模';
-- Create/Recreate primary, unique and foreign key constraints
alter table ARTICLE
add constraint PK_ID primary key (APP_ARTICLE_ID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create table
create table EVALUATE
(
APP_EVALUATE_ID VARCHAR2(20) not null,
APP_ARTICLE_ID VARCHAR2(20),
E_MAIL VARCHAR2(30),
CONTENT VARCHAR2(4000),
NAME VARCHAR2(40)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 1
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table EVALUATE
add constraint P_ID primary key (APP_EVALUATE_ID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create sequence
create sequence EVALUATE_SEQ
minvalue 1
maxvalue 9999999999999999999999999999
start with 121
increment by 1
cache 20;
-- Create sequence
create sequence ARTICLE_SEQ
minvalue 1
maxvalue 9999999999999999999999999999
start with 111
increment by 1
nocache;
