CREATE TABLE `orgno` (
`id`  int NOT NULL AUTO_INCREMENT COMMENT '主键' ,
`areacode`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域编号' ,
`orgnum`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机构编号' ,
`active`  bit(1) NULL COMMENT '是否有效' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
;