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';