COGNOS自定人认证表结构

-- Create table
create table COGNOS_GROUP
(
USER_CLASS_ID VARCHAR2(20) not null,
USER_CLASS_NAME VARCHAR2(50),
PARENT_USER_CLASS_ID VARCHAR2(20)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Add comments to the columns
comment on column COGNOS_GROUP.USER_CLASS_ID
is '用户类ID';
comment on column COGNOS_GROUP.USER_CLASS_NAME
is '用户类名称';
comment on column COGNOS_GROUP.PARENT_USER_CLASS_ID
is '父用户类ID';

-- Create table
create table COGNOS_GROUP_MEMBER
(
USER_CLASS_ID VARCHAR2(20) not null,
USER_ID VARCHAR2(20) not null
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Add comments to the columns
comment on column COGNOS_GROUP_MEMBER.USER_CLASS_ID
is '用户类ID';
comment on column COGNOS_GROUP_MEMBER.USER_ID
is '用户ID';

-- Create table
create table COGNOS_USERS
(
USER_ID VARCHAR2(20) not null,
USER_NAME VARCHAR2(50),
USER_PASS VARCHAR2(50),
USER_FOLDER_ID VARCHAR2(20) default 1 not null
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Add comments to the columns
comment on column COGNOS_USERS.USER_ID
is '用户ID';
comment on column COGNOS_USERS.USER_NAME
is '用户名称';
comment on column COGNOS_USERS.USER_PASS
is '用户密码';
comment on column COGNOS_USERS.USER_FOLDER_ID
is '用户文件夹ID';

-- Create table
create table COGNOS_USER_FOLDERS
(
USER_FOLDER_ID VARCHAR2(20) default '1' not null,
USER_FOLDER_NAME VARCHAR2(50) default 'users',
PARENT_USER_FOLDER_ID VARCHAR2(20)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Add comments to the columns
comment on column COGNOS_USER_FOLDERS.USER_FOLDER_ID
is '用户文件夹ID';
comment on column COGNOS_USER_FOLDERS.USER_FOLDER_NAME
is '用户文件夹名称 ';
comment on column COGNOS_USER_FOLDERS.PARENT_USER_FOLDER_ID
is '父用户文件夹ID';