covid-19
Tables (7)
cases
- id — bigint — Primary key — NOT NULL
- case_name — varchar(150)
- province — varchar(50)
- city — varchar(50)
- is_group_infection — boolean
- confirmed_count — int
patients
- id — bigint — Primary key — NOT NULL
- sex — varchar(6) — NOT NULL
- age — varchar(3) — NOT NULL
- nationality — varchar(20) — NOT NULL
- province — varchar(50) — NOT NULL
- city — varchar(50) — NOT NULL
- infection_type — varchar(150) — NOT NULL
- infected_by — bigint — NOT NULL
- contact_number — int — NOT NULL
- symptom_onset_date — date — NOT NULL
- confirmed_date — date — NOT NULL
- released_date — date — NOT NULL
- deceased_date — date — NOT NULL
- state — varchar(20) — NOT NULL
regions
- id — int — Primary key — NOT NULL
- province — varchar(50)
- city — varchar(50)
- elementary_school_count — int
- kindergarten_count — int
- university_count — int
- elderly_population_ratio — double
- elderly_alone_ratio — double
- nursing_home_count — int
time_age
- id — bigint — Primary key — NOT NULL
- date — date
- time — int
- age — int
- confirmed_count — int
- deceased_count — int
time_province
- id — bigint — Primary key — NOT NULL
- date — date
- time — int
- province — varchar(50)
- confirmed_count — int
- released_count — int
- deceased_count — int
time_sex
- id — bigint — Primary key — NOT NULL
- date — date
- time — int
- sex — varchar(6)
- confirmed_count — int
- deceased_count — int
timeline
- id — bigint — Primary key — NOT NULL
- date — date
- time — int
- tested_count — int
- negative_count — int
- confirmed_count — int
- released_count — int
- deceased_count — int