集合表：dn_jh

1 结构

2 建表语句

mysql建表语句

CREATE TABLE `dn_jh` (
  `ZDBM` varchar(50) NOT NULL COMMENT '字典编码',
  `GUID` varchar(50) NOT NULL COMMENT '集合唯一标识',
  `CYBM` varchar(100) DEFAULT NULL COMMENT '成员别名',
  `ZDFBM` varchar(50) DEFAULT NULL COMMENT '字典父编码',
  `CM` varchar(50) DEFAULT NULL COMMENT '层码',
  `CJ` float(4,2) DEFAULT NULL COMMENT '层级',
  `SX` int(10) DEFAULT NULL COMMENT '顺序',
  `ZDYCYBJ` smallint(1) DEFAULT NULL COMMENT '自定义成员标记',
  `ZDYCYGS` varchar(500) DEFAULT NULL COMMENT '自定义成员公式',
  `JSBJ` smallint(1) DEFAULT NULL COMMENT '假删标记',
  `BZXX` varchar(500) DEFAULT NULL COMMENT '备注信息',
  PRIMARY KEY (`ZDBM`,`GUID`),
  KEY `SYS_C0018978` (`CM`),
  KEY `SYS_C0018979` (`JSBJ`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='集合数据表'

oracle建表语句

create table DN_JH
(
  zdbm    VARCHAR2(50) not null,
  guid    VARCHAR2(50) not null,
  cybm    VARCHAR2(100),
  zdfbm   VARCHAR2(50),
  cm      VARCHAR2(50),
  cj      NUMBER(4,2),
  sx      NUMBER(10),
  zdycybj NUMBER(1),
  zdycygs VARCHAR2(500),
  jsbj    NUMBER(1),
  bzxx    VARCHAR2(500)
)
;
-- Add comments to the columns 
comment on column DN_JH.zdbm
  is '字段编码';
comment on column DN_JH.guid
  is '集合唯一标识';
comment on column DN_JH.cybm
  is '成员别名';
comment on column DN_JH.zdfbm
  is '字段父编码';
comment on column DN_JH.cm
  is '层码';
comment on column DN_JH.sx
  is '顺序';
comment on column DN_JH.zdycybj
  is '自定义成员标记 其中：1-自定义成员';
comment on column DN_JH.zdycygs
  is '自定义成员公式';
comment on column DN_JH.jsbj
  is '假删标记 其中：1-假删';
comment on column DN_JH.bzxx
  is '备注信息';
comment on column DN_JH.cj
  is '层级';
-- Create/Recreate indexes 
create index IDX_DN_JH_CM on DN_JH (CM);
create index IDX_DN_JH_JSBJ on DN_JH (JSBJ);
-- Create/Recreate primary, unique and foreign key constraints 
alter table DN_JH
  add constraint PK_DN_JH primary key (ZDBM, GUID) using index