# travel-notes-map

**Repository Path**: johnny913/travel-notes-map

## Basic Information

- **Project Name**: travel-notes-map
- **Description**: 个人游记，支持地图展示
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 1
- **Created**: 2017-04-13
- **Last Updated**: 2021-12-21

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#Travel-notes-map

## Create Database
CREATE DATABASE IF NOT EXISTS travel_notes_map DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

## Sql DDL

``` xml
/*==============================================================*/
/* Table: travel_security_user                                     */
/*==============================================================*/
CREATE TABLE travel_security_user
(
   id                   BIGINT NOT NULL,
   username             VARCHAR(255) NOT NULL COMMENT '用户名',
   phone                VARCHAR(255) COMMENT '手机号',
   PASSWORD             VARCHAR(255) NOT NULL COMMENT '密码',
   first_name           VARCHAR(255) COMMENT '名',
   last_name            VARCHAR(255) COMMENT '姓',
   created_at           BIGINT,
   last_modified        BIGINT COMMENT '最近修改时间',
   PRIMARY KEY (id)
);

ALTER TABLE travel_security_user COMMENT '系统-权限-用户';

/*==============================================================*/
/* Table: travel_note                                           */
/*==============================================================*/
CREATE TABLE travel_note
(
   id                   BIGINT NOT NULL,
   author_id            BIGINT,
   author_name          VARCHAR(255),
   title                VARCHAR(255),
   content              VARCHAR(512),
   lng                  VARCHAR(255),
   lat                  VARCHAR(255),
   remark               VARCHAR(255),
   created_at           BIGINT,
   last_modified        BIGINT,
   PRIMARY KEY (id)
);

ALTER TABLE travel_note COMMENT '游记表';

/*==============================================================*/
/* Table: travel_note_image                                     */
/*==============================================================*/
CREATE TABLE travel_note_image
(
   id                   BIGINT NOT NULL,
   travel_note_id       BIGINT,
   author_id            BIGINT,
   author_name          VARCHAR(255),
   NAME                 VARCHAR(255),
   size                 BIGINT,
   suffix               VARCHAR(255),
   uri                  VARCHAR(255),
   created_at           BIGINT,
   PRIMARY KEY (id)
);

ALTER TABLE travel_note_image COMMENT '游记图片';
```

## Run a screenshot
![](http://i.imgur.com/PBz9PwK.png)

注册登录：
![](http://i.imgur.com/ppMPDmj.png)

创建游记：
![](http://i.imgur.com/XrDiLOx.png)

地图上显示游记列表：
![](http://i.imgur.com/q7d4Hux.png)

个性化推荐&游记列表：
![](http://i.imgur.com/Tl3MUJu.png)