Class Diagram

News/新闻

`id` INT(5) `title` VARCHAR(30)`content` TEXT `time` DATE `valid` DATE `url` TEXT

Casehandle/案件附表

Admin/管理员

Stage/赛事

id INT(3) PRIMARY KEY name VARCHAR(8) img_1 VARCHAR(64) img_2 VARCHAR(64) deleted BOOLEAN

username VARCHAR(20) password VARCHAR(32) level INT(2)

类

+ attribute1:type = defaultValue+ attribute2:type- attribute3:type

+ operation1(params):returnType- operation2(params)- operation3()

History/搜索历史

`id` INT(5) user BIGINT(11) car_id CHAR(6) time DATETIME

User_Use/用户使用

username VARCHAR(20) type VARCHAR(16) item_id INT(4)

User/驾驶员

Evidence/证据

Menu/菜单

id INT(2) title CHAR(8) fid INT(2) url VARCHAR(128)

Notice/公告

id INT(128) PRIMARY KEY title VARCHAR(32) content VARCHAR(256) publish_time DATETIME active_time DATETIME deleted BOOLEAN

User_Exp/用户游戏

id INT(128) PRIMARY KEY username VARCHAR(32) game_time DATETIME stage INT(4) map INT(4) coins INT(8) exp INT(8) star INT(1)

Criminal/逃犯

`id` INT(5) `name` CHAR(8) `action` TEXT `head` TEXT `state` ENUM('esca...`car_id` VARCHAR(7)`driver_car` BIGINT(12)PRIMARY KEY (`id`)

Map/赛段

stage_id INT(8) map_id INT(8) name VARCHAR(8) img_1 VARCHAR(64) img_2 VARCHAR(64) deleted BOOLEAN exp INT(8) coins INT(8)

Car/车辆信息

Vip

id INT(2) level VARCHAR(16) price INT(8) deleted BOOLEAN

User_Buy/用户购买

username VARCHAR(20) item_id INT(4) type CHAR(8) buy_time DATETIME vip VARCHAR(8)

`id` INT(5) NOT NULL `fid` INT(5) `content` TEXT `power` ENUM('super'... `url` TEXT PRIMARY KEY (`id`)

CASE/案件

Equip/装备

id INT(4) PRIMARY KEY name VARCHAR(8) img_1 VARCHAR(64) img_2 VARCHAR(64) func_value INT(4) type VARCHAR(8) vip VARCHAR(8) deleted BOOLEAN price INT(8)

User_Charge/用户充值

id INT(128) PRIMARY KEY username VARCHAR(32) charge_money INT(8) charge_time DATETIME vip VARCHAR(8)

Law/法律法规

User/用户

username VARCHAR(32) password VARCHAR(32) vip VARCHAR(16) coins INT(8) exp INT(8) sign_time DATETIME last_login_time DATETIME money_charged INT(8) locked BOOLEAN record_stage INT(4) record_map INT(4)

Police/警员