create table QUERY_MENU
(
MENU_ID VARCHAR2(24) not null,
PARENT_ID VARCHAR2(24) not null,
IS_LEAF VARCHAR2(1) not null,
MENU_ORDER NUMBER not null,
MENU_NAME VARCHAR2(64) not null,
URL VARCHAR2(128)
);-- Create table
create table QUERY_INFO
(
QUERY_ID VARCHAR2(24) not null,
IF_SINGLE_TABLE VARCHAR2(1) not null,
QUERY_TABLES VARCHAR2(128) not null,
QUERY_NAME VARCHAR2(64) not null
);
-- Add comments to the columns
comment on column QUERY_INFO.QUERY_ID
is '主键,作为此类查询的标识';
comment on column QUERY_INFO.IF_SINGLE_TABLE
is '是否单表查询(0:否,1:是)';
comment on column QUERY_INFO.QUERY_TABLES
is '查询所涉及的表(多个表之间逗号分割)';
comment on column QUERY_INFO.QUERY_NAME
is '查询信息的名称';
-- Create table
create table QUERY_CONDITION_COLS
(
QUERY_ID VARCHAR2(24) not null,
COLUMN_NAME VARCHAR2(64) not null,
CONDTION VARCHAR2(1),
IF_DICT VARCHAR2(1) default 0,
DICT_NAME VARCHAR2(64),
SHOW_NAME VARCHAR2(64) not null
);
-- Add comments to the columns
comment on column QUERY_CONDITION_COLS.QUERY_ID
is '查询实例id';
comment on column QUERY_CONDITION_COLS.COLUMN_NAME
is '列名,对应数据库字段名';
comment on column QUERY_CONDITION_COLS.CONDTION
is '查询条件(=,范围)';
comment on column QUERY_CONDITION_COLS.IF_DICT
is '是否下拉选择,0否 1是';
comment on column QUERY_CONDITION_COLS.DICT_NAME
is '下拉对应的字典名称';
comment on column QUERY_CONDITION_COLS.SHOW_NAME
is '页面显示描述';
-- Create table
create table QUERY_LIST_COLS
(
QUERY_ID VARCHAR2(24),
COLUMN_NAME VARCHAR2(64),
IF_DICT VARCHAR2(1),
DICT_NAME VARCHAR2(64),
COL_ORDER NUMBER,
COL_WIDTH NUMBER,
SHOW_NAME VARCHAR2(64)
);
-- Add comments to the columns
comment on column QUERY_LIST_COLS.COL_ORDER
is '列的显示顺序';
comment on column QUERY_LIST_COLS.COL_WIDTH
is '列的宽度';
comment on column QUERY_LIST_COLS.SHOW_NAME
is '页面显示描述';数据结构
(
MENU_ID VARCHAR2(24) not null,
PARENT_ID VARCHAR2(24) not null,
IS_LEAF VARCHAR2(1) not null,
MENU_ORDER NUMBER not null,
MENU_NAME VARCHAR2(64) not null,
URL VARCHAR2(128)
);-- Create table
create table QUERY_INFO
(
QUERY_ID VARCHAR2(24) not null,
IF_SINGLE_TABLE VARCHAR2(1) not null,
QUERY_TABLES VARCHAR2(128) not null,
QUERY_NAME VARCHAR2(64) not null
);
-- Add comments to the columns
comment on column QUERY_INFO.QUERY_ID
is '主键,作为此类查询的标识';
comment on column QUERY_INFO.IF_SINGLE_TABLE
is '是否单表查询(0:否,1:是)';
comment on column QUERY_INFO.QUERY_TABLES
is '查询所涉及的表(多个表之间逗号分割)';
comment on column QUERY_INFO.QUERY_NAME
is '查询信息的名称';
-- Create table
create table QUERY_CONDITION_COLS
(
QUERY_ID VARCHAR2(24) not null,
COLUMN_NAME VARCHAR2(64) not null,
CONDTION VARCHAR2(1),
IF_DICT VARCHAR2(1) default 0,
DICT_NAME VARCHAR2(64),
SHOW_NAME VARCHAR2(64) not null
);
-- Add comments to the columns
comment on column QUERY_CONDITION_COLS.QUERY_ID
is '查询实例id';
comment on column QUERY_CONDITION_COLS.COLUMN_NAME
is '列名,对应数据库字段名';
comment on column QUERY_CONDITION_COLS.CONDTION
is '查询条件(=,范围)';
comment on column QUERY_CONDITION_COLS.IF_DICT
is '是否下拉选择,0否 1是';
comment on column QUERY_CONDITION_COLS.DICT_NAME
is '下拉对应的字典名称';
comment on column QUERY_CONDITION_COLS.SHOW_NAME
is '页面显示描述';
-- Create table
create table QUERY_LIST_COLS
(
QUERY_ID VARCHAR2(24),
COLUMN_NAME VARCHAR2(64),
IF_DICT VARCHAR2(1),
DICT_NAME VARCHAR2(64),
COL_ORDER NUMBER,
COL_WIDTH NUMBER,
SHOW_NAME VARCHAR2(64)
);
-- Add comments to the columns
comment on column QUERY_LIST_COLS.COL_ORDER
is '列的显示顺序';
comment on column QUERY_LIST_COLS.COL_WIDTH
is '列的宽度';
comment on column QUERY_LIST_COLS.SHOW_NAME
is '页面显示描述';数据结构
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货