1:表字段
2:创建表 脚本
DROP TABLE IF EXISTS `sys_city`;
CREATE TABLE `sys_city` (
`id` int NOT NULL COMMENT '标识 也是行政区编码',
`pid` int NULL DEFAULT NULL COMMENT '父级标识',
`area_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '行政区名称',
`level` int NULL DEFAULT NULL COMMENT '等级 1:省 2:市 3:区',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
3:数据脚本文件
链接: https://pan.baidu.com/s/1zg-AAYYtD7g48ofbdAtMHA
提取码: 23lx
页面更新:2024-03-08
本站资料均由网友自行发布提供,仅用于学习交流。如有版权问题,请与我联系,QQ:4156828
© CopyRight 2008-2024 All Rights Reserved. Powered By bs178.com 闽ICP备11008920号-3
闽公网安备35020302034844号