|
|
|
|
create database covid19;
|
|
|
|
|
use covid19;
|
|
|
|
|
create table province_daily_datas(
|
|
|
|
|
provinceName varchar(30),
|
|
|
|
|
provinceShortName varchar(10),
|
|
|
|
|
currentConfirmedCount int,
|
|
|
|
|
confirmedCount int,
|
|
|
|
|
suspectedCount int,
|
|
|
|
|
curedCount int,
|
|
|
|
|
deadCount int,
|
|
|
|
|
pub_time varchar(30)
|
|
|
|
|
);
|
|
|
|
|
create table city_daily_datas(
|
|
|
|
|
cityName varchar(30),
|
|
|
|
|
currentConfirmedCount int,
|
|
|
|
|
confirmedCount int,
|
|
|
|
|
suspectedCount int,
|
|
|
|
|
curedCount int,
|
|
|
|
|
deadCount int,
|
|
|
|
|
locationId int,
|
|
|
|
|
province varchar(30),
|
|
|
|
|
pub_time varchar(30)
|
|
|
|
|
);
|
|
|
|
|
create table country_daily_datas(
|
|
|
|
|
countryName varchar(30),
|
|
|
|
|
currentConfirmedCount int,
|
|
|
|
|
confirmedCount int,
|
|
|
|
|
confirmedCountRank int,
|
|
|
|
|
curedCount int,
|
|
|
|
|
deadCount int,
|
|
|
|
|
deadCountRank int,
|
|
|
|
|
deadRate float,
|
|
|
|
|
deadRateRank int,
|
|
|
|
|
pub_time varchar(30)
|
|
|
|
|
);
|
|
|
|
|
create table home_realtime_datas
|
|
|
|
|
(
|
|
|
|
|
curConfirm INT comment '现有确诊',
|
|
|
|
|
curConfirmRelative INT comment '较昨日新增确诊',
|
|
|
|
|
asymptomatic INT comment '无症状感染',
|
|
|
|
|
asymptomaticRelative INT comment '较昨日新增无症状感染',
|
|
|
|
|
unconfirmed INT comment '现有疑似',
|
|
|
|
|
unconfirmedRelative INT comment '较昨日疑似新增',
|
|
|
|
|
icu INT comment '现有重症',
|
|
|
|
|
icuRelative INT comment '较昨日重症病例新增',
|
|
|
|
|
confirmed INT comment '累计确诊',
|
|
|
|
|
confirmedRelative INT comment '较昨日累计确诊新增',
|
|
|
|
|
overseasInput INT comment '累计境外输入',
|
|
|
|
|
overseasInputRelative INT comment '较昨日累计境外输入新增',
|
|
|
|
|
cured INT comment '累计治愈',
|
|
|
|
|
curedRelative INT comment '较昨日累计治愈新增',
|
|
|
|
|
died INT comment '累计死亡',
|
|
|
|
|
diedRelative INT comment '较昨日累计死亡新增',
|
|
|
|
|
updatedTime VARCHAR(4000)comment'发布时间'
|
|
|
|
|
) comment'国内实时疫情概况 该表中只保留当前最新的一条数据记录';
|
|
|
|
|
create table home_realtime_datas
|
|
|
|
|
(
|
|
|
|
|
curConfirm INT comment '现有确诊',
|
|
|
|
|
curConfirmRelative INT comment '较昨日新增确诊',
|
|
|
|
|
asymptomatic INT comment '无症状感染',
|
|
|
|
|
asymptomaticRelative INT comment '较昨日新增无症状感染',
|
|
|
|
|
unconfirmed INT comment '现有疑似',
|
|
|
|
|
unconfirmedRelative INT comment '较昨日疑似新增',
|
|
|
|
|
icu INT comment '现有重症',
|
|
|
|
|
icuRelative INT comment '较昨日重症病例新增',
|
|
|
|
|
confirmed INT comment '累计确诊',
|
|
|
|
|
confirmedRelative INT comment '较昨日累计确诊新增',
|
|
|
|
|
overseasInput INT comment '累计境外输入',
|
|
|
|
|
overseasInputRelative INT comment '较昨日累计境外输入新增',
|
|
|
|
|
cured INT comment '累计治愈',
|
|
|
|
|
curedRelative INT comment '较昨日累计治愈新增',
|
|
|
|
|
died INT comment '累计死亡',
|
|
|
|
|
diedRelative INT comment '较昨日累计死亡新增',
|
|
|
|
|
updatedTime VARCHAR(4000)comment'发布时间'
|
|
|
|
|
) comment'国内实时疫情概况 该表中只保留当前最新的一条数据记录';
|
