集合属性表：dn_jhsx

1 结构

2 建表语句

mysql建表语句

CREATE TABLE `dn_jhsx` (
  `GUID` varchar(50) NOT NULL COMMENT '集合唯一标识',
  `JHMC` varchar(50) DEFAULT NULL COMMENT '集合名称',
  `BZSM` varchar(500) DEFAULT NULL COMMENT '备注说明',
  `QSSQL` varchar(500) DEFAULT NULL COMMENT '取数SQL',
  `BMZD` varchar(50) DEFAULT NULL COMMENT '编码字段',
  `MCZD` varchar(50) DEFAULT NULL COMMENT '名称字段',
  `FBMZD` varchar(50) DEFAULT NULL COMMENT '父编码字段',
  `ZDCCJG` varchar(50) DEFAULT NULL COMMENT '字典层次结构',
  `WDZD` varchar(50) DEFAULT NULL COMMENT '维度字段',
  `ZDBM` varchar(50) DEFAULT NULL COMMENT '字典表名',
  `CJR` varchar(50) DEFAULT NULL COMMENT '创建人',
  `CJRQ` date DEFAULT NULL COMMENT '创建日期',
  `QSLY` int(10) DEFAULT '0' COMMENT '取数来源',
  `FLID` varchar(50) DEFAULT NULL COMMENT '所属分类ID，为空则代表处于根目录',
  PRIMARY KEY (`GUID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='集合属性表'

oracle建表语句

create table DN_JHSX
(
  guid   VARCHAR2(50) not null,
  jhmc   VARCHAR2(50),
  bzsm   VARCHAR2(500),
  qssql  VARCHAR2(500),
  bmzd   VARCHAR2(50),
  mczd   VARCHAR2(50),
  fbmzd  VARCHAR2(50),
  zdccjg VARCHAR2(50),
  wdzd   VARCHAR2(50),
  zdbm   VARCHAR2(50),
  cjr    VARCHAR2(50),
  cjrq   DATE,
  qsly   NUMBER(10),
  flid VARCHAR2(50)
);
-- Add comments to the columns 
comment on column DN_JHSX.guid
  is '集合唯一标识';
comment on column DN_JHSX.jhmc
  is '集合名称';
comment on column DN_JHSX.bzsm
  is '备注说明';
comment on column DN_JHSX.qssql
  is '取数SQL';
comment on column DN_JHSX.bmzd
  is '编码字段';
comment on column DN_JHSX.mczd
  is '名称字段';
comment on column DN_JHSX.fbmzd
  is '父编码字段';
comment on column DN_JHSX.zdccjg
  is '字段层级规则';
comment on column DN_JHSX.wdzd
  is '维度字段';
comment on column DN_JHSX.zdbm
  is '字段编码';
comment on column DN_JHSX.cjr
  is '创建人';
comment on column DN_JHSX.cjrq
  is '创建日期';
comment on column DN_JHSX.flid
  is '所属分类id，为空代表属于根目录';
-- Create/Recreate primary, unique and foreign key constraints 
alter table DN_JHSX
  add constraint PK_DN_JHSX primary key (GUID)
  using index