代码如下,仅供参考
-- Create table T_USER
create table T_USER
(
user_id VARCHAR2(20),
user_name VARCHAR2(50),
include_rule VARCHAR2(20)
);
-- Add comments to the table
comment on table T_USER
is '用户表';
-- Add comments to the columns
comment on column T_USER.user_id
is '用户编号';
comment on column T_USER.user_name
is '用户名';
comment on column T_USER.include_rule
is '分配角色';
-- Create table T_ROLE
create table T_ROLE
(
role_id VARCHAR2(20),
extends_id VARCHAR2(20),
include_privilege VARCHAR2(100)
);
-- Add comments to the table
comment on table T_ROLE
is '角色表';
-- Add comments to the columns
comment on column T_ROLE.role_id
is '角色编号';
comment on column T_ROLE.extends_id
is '继承自';
comment on column T_ROLE.include_privilege
is '包含权限';
-- Create table T_PRIVILEGE
create table T_PRIVILEGE
(
privilege_id VARCHAR2(20)
);
-- Add comments to the table
comment on table T_PRIVILEGE
is '权限表';
-- Add comments to the columns
comment on column T_PRIVILEGE.privilege_id
is '权限编号';