集合分类表：dn_jhfl

1 结构

2 建表语句

mysql建表语句

CREATE TABLE `dn_jhfl` (
  `GUID` varchar(50) NOT NULL COMMENT '集合分类唯一标识',
  `FLMC` varchar(50) DEFAULT NULL COMMENT '分类名称',
  `BZSM` varchar(500) DEFAULT NULL COMMENT '备注说明',
  `CJR` varchar(50) DEFAULT NULL COMMENT '创建人',
  `CJRQ` date DEFAULT NULL COMMENT '创建日期',
  `FLID` varchar(50) DEFAULT NULL COMMENT '上级分类ID',
  `FLSX` int(11) DEFAULT NULL COMMENT '分类顺序',
  PRIMARY KEY (`GUID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='集合分类表'

oracle建表语句

create table DN_JHFL
(
  guid VARCHAR2(50) not null,
  flmc VARCHAR2(50),
  bzsm VARCHAR2(500),
  cjr  VARCHAR2(50),
  cjrq DATE,
  flid VARCHAR2(50),
  flxs NUMBER
);
-- Add comments to the columns 
comment on column DN_JHFL.guid
  is '唯一标识';
comment on column DN_JHFL.jhmc
  is '分类名称';
comment on column DN_JHFL.bzsm
  is '备注说明';
comment on column DN_JHFL.cjr
  is '创建人';
comment on column DN_JHFL.cjrq
  is '创建日期';
comment on column DN_JHFL.flid
  is '所属分类id,为空代表根目录';
comment on column DN_JHFL.flxs
  is '分类顺序';
-- Create/Recreate primary, unique and foreign key constraints 
alter table DN_JHFL
  add constraint DN_JHFL_PK primary key (guid) using index