旅行应用数据库设计-优快云博客

本文介绍了一个围绕旅行应用的数据库设计，包含用户信息、旅行详情、聊天记录等关键表结构，旨在提供旅行活动组织与交流的基础数据支持。

DROP TABLE IF EXISTS `T_CHATDETAIL`;
create table T_CHATDETAIL
(
CHATID      int unsigned not null AUTO_INCREMENT,
TRAVELID    int,
FROMUSERID int,
TOUSERID    int,
CHATCONTENT VARCHAR(200),
CHATTIME    DATE,
PRIMARY KEY (`CHATID`)
) AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `T_TRAVELINFO`;
create table T_TRAVELINFO
(
TRAVELID    int unsigned not null AUTO_INCREMENT,
BUILDERID   int not null,
LEADERID    int not null,
TRAVELNAME VARCHAR(20) not null,
STARTPLACE VARCHAR(50) not null,
DESTINATION VARCHAR(50) not null,
STARTTIME   DATE not null,
ENDTIME     DATE not null,
PUBLICFLAG CHAR(1) not null,
DELETEFLAG CHAR(1) not null,
REMARK      VARCHAR(200),
STARTFLG    CHAR(1) default 0 not null,
PRIMARY KEY (`TRAVELID`)
)AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `T_TRAVELLINE`;
create table T_TRAVELLINE
(
TRAVELLINEID int unsigned not null AUTO_INCREMENT,
TRAVELID     int not null,
LEADERID     int,
LONGITUDE    VARCHAR(30),
LATITUDE     VARCHAR(30),
INDEXID      int,
PRIMARY KEY (`TRAVELLINEID`)
)AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `T_TRAVELMEMBERS`;
create table T_TRAVELMEMBERS
(
TRAVELID         int,
USERID           int,
LONGITUDE        VARCHAR(30),
LATITUDE         VARCHAR(30),
STATUSFLAG       CHAR(1),
SHOWLOCATIONFLAG CHAR(1)
) DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `T_USERINFO`;
create table T_USERINFO
(
USERID        int unsigned not null AUTO_INCREMENT,
USERNICKNAME VARCHAR(20),
PHONENO       VARCHAR(20),
LOGINNAME     VARCHAR(20) not null,
LOGINPASSWORD VARCHAR(20) not null,
CARNO         VARCHAR(15),
USERPHOTO     VARCHAR(4000),
PRIMARY KEY (`USERID`)
)AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `T_USERSET`;
create table T_USERSET
(
USERID       int,
AUTOLOGIN    VARCHAR(1) default 0,
SAVEPASSWORD VARCHAR(1) default 0,
BACKUP1      VARCHAR(1) default 0,
BACKUP2      VARCHAR(1) default 0,
BACKUP3      VARCHAR(1) default 0,
BACKUP4      VARCHAR(1) default 0,
BACKUP5      VARCHAR(1) default 0,
BACKUP6      VARCHAR(1) default 0,
BACKUP7      VARCHAR(1) default 0,
BACKUP8      VARCHAR(1) default 0,
BACKUP9      VARCHAR(1) default 0,
BACKUP10     VARCHAR(1) default 0
)