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