Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Database tables: zone table system_district

2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 215

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report