集合属性表：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，为空则代表处于根目录',
  `ZDCCMC` varchar(50) DEFAULT NULL COMMENT,
  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),
  ZDCCMC 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