CREATE TABLE tm02_department (
dept_id int(11) NOT NULL AUTO_INCREMENT COMMENT '部门ID' ,
dept_name varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
parent_dept_id int(11) NULL COMMENT '上级部门ID' ,
sort_no int(11) NULL DEFAULT 0 COMMENT '同一父节点下面同级节点排序序号' ,
is_substation tinyint(4) NULL DEFAULT 0 COMMENT '是否是分局' ,
PRIMARY KEY (dept_id),
CONSTRAINT fk_dept FOREIGN KEY (parent_dept_id) REFERENCES tm01_department (dept_id) ON DELETE NO ACTION ON UPDATE NO ACTION
)
ENGINE=ndbcluster
;
dept_id int(11) NOT NULL AUTO_INCREMENT COMMENT '部门ID' ,
dept_name varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
parent_dept_id int(11) NULL COMMENT '上级部门ID' ,
sort_no int(11) NULL DEFAULT 0 COMMENT '同一父节点下面同级节点排序序号' ,
is_substation tinyint(4) NULL DEFAULT 0 COMMENT '是否是分局' ,
PRIMARY KEY (dept_id),
CONSTRAINT fk_dept FOREIGN KEY (parent_dept_id) REFERENCES tm01_department (dept_id) ON DELETE NO ACTION ON UPDATE NO ACTION
)
ENGINE=ndbcluster
;