Database tables: zone table system_district

Region table [system_district] data model creation table script-Table structure for system_district-- DROP TABLE IF EXISTS `system_ district` CREATE TABLE `system_ district` (`ID', id` bigint (20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'region ID', `parent_ id` bigint (20) unsigned NOT NULL COMMENT' parent ID', `district_ name` varchar (200) NOT NULL COMMENT 'region name', `short_ name`varchar 'abbreviation', `longitude` decimal 'NOT NULL DEFAULT' 0.0000000' COMMENT 'longitude', `latitude` decimal 'NOT NULL DEFAULT' 0.0000000' COMMENT 'Dimension' `level` int (11) NOT NULL DEFAULT'1' COMMENT 'rating', `sort` int (11) NOT NULL DEFAULT'0' COMMENT 'sort', `is_ deleted` tinyint (1) NOT NULL DEFAULT'0' COMMENT 'deletion flag: 0 not deleted 1 deleted', 'create_ time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT' creation time', `update_ time` timestamp NOT NULL DEFAULT '0000-00-0000: 00update_ COMMENT' modification time', PRIMARY KEY (`timeid`) ENGINE=InnoDB AUTO_INCREMENT=659004503 DEFAULT CHARSET=utf8 COMMENT=' region table' Attachment (tabulation script and data)

System_district.sql