-- Create table
create table T_TAG
(
F_INTTAGID NUMBER not null,
F_STRCATEGORY NVARCHAR2(100) not null,
F_INTRECORDID NUMBER not null,
F_STRTAGNAME NVARCHAR2(50) not null,
F_STRNOTE NVARCHAR2(500)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table T_TAG
is '标签、关键字表';
-- Add comments to the columns
comment on column T_TAG.F_INTTAGID
is '主键';
comment on column T_TAG.F_STRCATEGORY
is '标签类别';
comment on column T_TAG.F_INTRECORDID
is '记录 ID ,行 ID ,Row Id';
comment on column T_TAG.F_STRTAGNAME
is '标签内容,名称';
comment on column T_TAG.F_STRNOTE
is '记事、备忘';
-- Create/Recreate primary, unique and foreign key constraints
alter table T_TAG
add constraint PK_TAG primary key (F_INTTAGID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
表:t_tag
最新推荐文章于 2023-11-08 15:10:17 发布