-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathaddr.sql
More file actions
148 lines (128 loc) · 5.32 KB
/
addr.sql
File metadata and controls
148 lines (128 loc) · 5.32 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50553
Source Host : localhost:3306
Source Database : addr
Target Server Type : MYSQL
Target Server Version : 50553
File Encoding : 65001
Date: 2018-06-08 10:16:39
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_area
-- ----------------------------
DROP TABLE IF EXISTS `t_area`;
CREATE TABLE `t_area` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL COMMENT '区域、分类名称标签',
`city_id` int(11) DEFAULT '0' COMMENT '城市ID'
`status` tinyint(1) DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_area
-- ----------------------------
-- ----------------------------
-- Table structure for t_area_classify
-- ----------------------------
DROP TABLE IF EXISTS `t_area_classify`;
CREATE TABLE `t_area_classify` (
`classify_id` int(11) DEFAULT '0' COMMENT '每一个区域的统计分类ID 来源表：classify',
`area_id` int(11) DEFAULT '0' COMMENT '城市区域ID 来源表：area',
`city_id` int(11) DEFAULT '0' COMMENT '城市ID'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_area_classify
-- ----------------------------
-- ----------------------------
-- Table structure for t_city
-- ----------------------------
DROP TABLE IF EXISTS `t_city`;
CREATE TABLE `t_city` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL COMMENT '城市名称',
`prefix` varchar(1) DEFAULT NULL COMMENT '城市首字母 如A、B、C',
`status` tinyint(1) DEFAULT '1' COMMENT '状态',
`href` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_city
-- ----------------------------
-- ----------------------------
-- Table structure for t_classify
-- ----------------------------
DROP TABLE IF EXISTS `t_classify`;
CREATE TABLE `t_classify` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) DEFAULT NULL COMMENT '区域分类名称',
`status` tinyint(1) DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_classify
-- ----------------------------
INSERT INTO `t_classify` VALUES ('1', '热门', '1');
INSERT INTO `t_classify` VALUES ('2', '行政区/商圈', '1');
INSERT INTO `t_classify` VALUES ('3', '地铁站', '1');
INSERT INTO `t_classify` VALUES ('4', '高校', '1');
INSERT INTO `t_classify` VALUES ('5', '车站/机场', '1');
INSERT INTO `t_classify` VALUES ('6', '旅游景点', '1');
INSERT INTO `t_classify` VALUES ('7', '医院', '1');
-- ----------------------------
-- Table structure for t_hotel
-- ----------------------------
DROP TABLE IF EXISTS `t_hotel`;
CREATE TABLE `t_hotel` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) DEFAULT NULL COMMENT '酒店名称（地址采集来源：美团网酒店订购）',
`href` varchar(200) DEFAULT NULL COMMENT '链接',
`remark` varchar(300) DEFAULT NULL COMMENT '一个说明（通常可以辅助用户确定详细地址位置）',
`status` tinyint(1) DEFAULT '1',
`address` varchar(200) DEFAULT NULL COMMENT '详细的地址（该地址可转换为经纬度）',
`l_and_l` varchar(255) DEFAULT NULL COMMENT '经纬度',
`locations_id` int(11) DEFAULT '0' COMMENT '所属地址ID 来源表：locations（通常指该酒店所在更大一些的区域，比如某个广场、某条路）',
`city_id` int(11) DEFAULT '0' COMMENT '所属城市ID 来源表：city',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_hotel
-- ----------------------------
-- ----------------------------
-- Table structure for t_hotel_area
-- ----------------------------
DROP TABLE IF EXISTS `t_hotel_area`;
CREATE TABLE `t_hotel_area` (
`hotel_id` int(11) DEFAULT NULL COMMENT '酒店ID 来源表：hotel',
`area_id` int(11) DEFAULT NULL COMMENT '城市ID 来源表：area'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_hotel_area
-- ----------------------------
-- ----------------------------
-- Table structure for t_locations
-- ----------------------------
DROP TABLE IF EXISTS `t_locations`;
CREATE TABLE `t_locations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL COMMENT '地址（一个较大范围地址 例：某个广场、某条路段）',
`status` tinyint(1) DEFAULT '1',
`href` varchar(200) DEFAULT NULL COMMENT '链接地址',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_locations
-- ----------------------------
-- ----------------------------
-- Table structure for t_locations_area
-- ----------------------------
DROP TABLE IF EXISTS `t_locations_area`;
CREATE TABLE `t_locations_area` (
`locations_id` int(11) DEFAULT '0' COMMENT '地区id 来源表：locations',
`area_id` int(11) DEFAULT '0' COMMENT '城市区域ID 来源表：area'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_locations_area
-- ----------------------------