CREATE TABLE `AREA` (
`ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`FULLNAME` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '全称',
`GRADE` int(11) NOT NULL COMMENT '层级',
`NAME` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '名称',
`TREEPATH` varchar(255) COLLATE utf8_bin NOT NULL COMMENT '树路径',
`ISDELETE` int(11) DEFAULT NULL COMMENT '是否删除(1是 0否)',
`ORDERS` int(11) DEFAULT NULL COMMENT '行政编码',
`VERSION` float NOT NULL COMMENT '版本',
`CREATEDDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
`LASTMODIFIEDDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新日期',
`PARENT_ID` bigint(20) DEFAULT NULL COMMENT '地区父id',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3510 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1