Web project implemeted by J2EE and based on PostgreSQL database, for tourism tickets booking along with COVID-19 checking.
| No. |
Table |
Description |
| 1 |
register |
用户注册信息表 |
| 2 |
parks |
景区信息表 |
| 3 |
reservations |
订单信息表 |
Sequence of data fields should be consistent with the following lists.
- register
| Data field |
Description |
Data type |
Is primary key |
| user_name |
用户名 |
varchar (50) |
No |
| phone_no |
用户手机号码 |
varchar (20) |
Yes |
| password |
用户登录密码 |
varchar (120) |
No |
| is_official |
用户是否为有关部门管理员 |
boolean |
No |
- parks
| Data field |
Description |
Data type |
Is primary key |
| park_id |
景区ID号 |
int |
Yes |
| open_time |
开园时间（精确到小时） |
int |
No |
| close_time |
闭园时间（精确到小时） |
int |
No |
| park_address |
景区地址 |
varchar (120) |
No |
| contact |
景区联系电话 |
varchar (100) |
No |
| max_num |
游客人次上限 |
int |
No |
| park_name |
景点名称 |
varchar (100) |
No |
| visitor_0 |
当日预订人次 |
int |
No |
| visitor_1 |
次日预订人次 |
int |
No |
| visitor_2 |
后日预订人次 |
int |
No |
| price |
票价 |
float |
No |
| description |
景区简介 |
text |
No |
| covid_risk |
是否有疫情风险 |
boolean |
No |
- reservations
| Data field |
Description |
Data type |
Is primary key |
| reserve_id |
订单号 |
int |
Yes |
| user_phoneno |
提交此订单的用户手机号码 |
varchar (120) |
No |
| schedule |
预订日期时间（精确到小时） |
varchar (50) |
No |
| tourist_phoneno |
游客手机号 |
varchar (120) |
No |
| member_num |
同行人数 |
int |
No |
| tourist_name |
游客姓名 |
varchar (120) |
No |
| tourist_idcard |
游客身份证号 |
varchar (120) |
No |
| where_from |
14天内来源地 |
varchar (100) |
No |
| is_healthy |
“苏康码”是否为绿码 |
boolean |
No |
| is_payed |
是否已完成支付 |
boolean |
No |
| time_stamp |
订单生成时间 |
varchar (50) |
No |
| id_cipher |
订单号加密密文 |
varchar (70) |
No |
| park_selected |
预订的景区名称 |
varchar (80) |
No |
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent