关闭

自定义功能模块设计

标签: java自定义sql设计图
91人阅读 评论(0) 收藏 举报
分类:

项目搭建架构图在线地址点击查看架构图

数据表设计如下:

--自定义数据源表
create table CUSTOM_DATA
(
  id      primary key   VARCHAR(64) not null,
  name         VARCHAR(200),
  sql          CLOB,
  url          varchar(2000),
  method       varchar(10),
  data_source  varchar(30),
  page         char(1);
  control_type char(1);
  source_type  char(1);
  description  varchar(2000),
  status       CHAR(1),
  create_id    varchar(64),
  create_time  timestamp,
  modify_id    varchar(64),
  modify_time   timestamp
)
--表 注释
comment on table CUSTOM_DATA  is '自定义数据源表';
--列 注释
comment on column CUSTOM_DATA.id is 'uuid主键';
comment on column CUSTOM_DATA.name is '名称';
comment on column CUSTOM_DATA.sql is 'SQL语句';
comment on column CUSTOM_DATA.url is '请求地址';
comment on column CUSTOM_DATA.method is '请求方式';
comment on column CUSTOM_DATA.data_source is '数据库连接池';
comment on column CUSTOM_DATA.page is '0不分页,1分页';
comment on column CUSTOM_DATA.control_type is '控件类型:0、table 1、chart';
comment on column CUSTOM_DATA.source_type is '数据源类型:0、sql 1、http请求';
comment on column CUSTOM_DATA.description is '描述';
comment on column CUSTOM_DATA.status is '状态';
comment on column CUSTOM_DATA.create_id is '创建人';
comment on column CUSTOM_DATA.create_time is '创建时间';
comment on column CUSTOM_DATA.modify_id is '修改人';
comment on column CUSTOM_DATA.modify_time is '修改时间';


-- 注释 自定义页面page表或者组件
create table CUSTOM_PAGE
(
  id          primary key   VARCHAR(64) not null,
  name        VARCHAR(100),
  html_code   CLOB,
  rest_id     VARCHAR(32),
  query_ids   VARCHAR(2000),
  type        char(1),
  description VARCHAR(2000),
  create_id    varchar(64),
  create_time  timestamp,
  modify_id    varchar(64),
  modify_time  timestamp
)
-- 表注释 
comment on table CUSTOM_PAGE  is '自定义页面page表';
-- 列注释
comment on column CUSTOM_PAGE.id is 'uuid主键';
comment on column CUSTOM_PAGE.name is '名称';
comment on column CUSTOM_PAGE.html_code is '存储页面所有代码';
comment on column CUSTOM_PAGE.rest_id is '此id为32位数字,开放给其它平台用';
comment on column CUSTOM_PAGE.query_ids is 'query的id集合, 用分号隔开,方便统计用';
comment on column CUSTOM_PAGE.type is '页面类型:0代表页面 主要用于APP中 2代表组件 用于页面局部自定义功能';
comment on column CUSTOM_PAGE.description  is '页面使用说明';
comment on column CUSTOM_PAGE.create_id is '创建人';
comment on column CUSTOM_PAGE.create_time is '创建时间';
comment on column CUSTOM_PAGE.modify_id is '修改人';
comment on column CUSTOM_PAGE.modify_time is '修改时间';


-- 自定义APP
create table CUSTOM_APP
(
  id           primary key    VARCHAR(64) not null,
  name         VARCHAR2(100),
  icon         VARCHAR2(100),
  description  VARCHAR(2000),
  status       char(1),
  create_id    varchar(64),
  create_time  timestamp,
  modify_id    varchar(64),
  modify_time  timestamp
)
-- 表注释
comment on column CUSTOM_APP.category is '应用标签';
-- 字段注释
comment on column CUSTOM_APP.id is 'uuid主键';
comment on column CUSTOM_APP.name is '名称';
comment on column CUSTOM_APP.icon is '图标';
comment on column CUSTOM_APP.description is '描述';
comment on column CUSTOM_APP.status is '状态0启用 1禁用';
comment on column CUSTOM_APP.create_id is '创建人';
comment on column CUSTOM_APP.create_time is '创建时间';
comment on column CUSTOM_APP.modify_id is '修改人';
comment on column CUSTOM_APP.modify_time is '修改时间';


--app和页面建立关联 菜单表
create table CUSTOM_APP_PAGE
(
  id           primary key    VARCHAR(64) not null,
  name         VARCHAR2(100),
  icon         VARCHAR2(100),
  app_id       VARCHAR(64) not null,
  page_id      VARCHAR(64) not null,
  description  VARCHAR(2000),
  status       char(1),
  create_id    varchar(64),
  create_time  timestamp,
  modify_id    varchar(64),
  modify_time  timestamp
)
-- 表注释
comment on column CUSTOM_APP_PAGE.category is 'app菜单表';
-- 字段注释
comment on column CUSTOM_APP_PAGE.id is 'uuid主键';
comment on column CUSTOM_APP_PAGE.name is '名称';
comment on column CUSTOM_APP_PAGE.icon is '图标';
comment on column CUSTOM_APP_PAGE.app_id is 'app_id和APP表建立关联';
comment on column CUSTOM_APP_PAGE.page_id is 'page_id和页面表建立关联';
comment on column CUSTOM_APP_PAGE.description is '描述';
comment on column CUSTOM_APP_PAGE.status is '状态0启用 1禁用';
comment on column CUSTOM_APP_PAGE.create_id is '创建人';
comment on column CUSTOM_APP_PAGE.create_time is '创建时间';
comment on column CUSTOM_APP_PAGE.modify_id is '修改人';
comment on column CUSTOM_APP_PAGE.modify_time is '修改时间';
0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:9450次
    • 积分:202
    • 等级:
    • 排名:千里之外
    • 原创:11篇
    • 转载:0篇
    • 译文:0篇
    • 评论:1条
    文章分类
    最新评论
  • jsch教程

    sinat_16921689: 楼主,如果执行“su - root”这样的操作,需要输入密码怎么处理???