5조 ERD

테이블 (22)

confirmed

  • date — date — 기본 키 — NOT NULL
  • count — decimal
  • safe — decimal
  • measure — varchar
  • death — decimal
  • sex — decimal
  • age — decimal
  • symtom — varchar
  • region — varchar

confirmed_foreign

  • date — date — 외래 키 → covid.date — NOT NULL
  • total_confirmed — VARCHAR(255)
  • region — VARCHAR(255)
  • sex — VARCHAR(255)
  • age — VARCHAR(255)
  • country — VARCHAR(255)
  • symtom — VARCHAR(255)

confirmed_korea

  • date — date — 외래 키 → covid.date — NOT NULL
  • total_confimed — VARCHAR(255)
  • region — VARCHAR(255)
  • sex — VARCHAR(255)
  • age — VARCHAR(255)
  • symtom — VARCHAR(255)

consum_pattern

  • date — date — 외래 키 → covid.date — NOT NULL
  • applience — decimal
  • book — decimal
  • fashion — decimal
  • food — decimal
  • life — decimal
  • service — decimal
  • ect — decimal

covid

  • date — date — 기본 키 — NOT NULL
  • country — varchar

covid_blue

  • date — date — 외래 키 → covid.date — NOT NULL
  • worry — decimal
  • fear — decimal
  • anger — decimal
  • rage — decimal
  • lethargy — decimal
  • lonely — decimal
  • pride — decimal
  • relief — decimal

covid_vaccine_korea

  • date — date — 외래 키 → covid.date — NOT NULL
  • country — varchar
  • people_vaccinated — decimal
  • people_fully_vaccinated — decimal
  • total_vaccinated_per_hundred — decimal
  • people_vaccinated_per_hundred — decimal
  • people_fully_vaccinated_per_hundred — decimal
  • continent — varchar

covid_vaccine_world

  • date — date — 외래 키 → covid.date — NOT NULL
  • country — varchar
  • people_vaccinated — decimal
  • people_fully_vaccinated — decimal
  • total_vaccinated_per_hundred — decimal
  • people_vaccinated_per_hundred — decimal
  • people_fully_vaccinated_per_hundred — decimal
  • continent — varchar

dailylife

  • dailylife_id — decimal — 기본 키 — NOT NULL
  • date — date — 외래 키 → service.date — NOT NULL
  • dailylife_list — VARCHAR(255)
  • dailylife_count — decimal
  • dailylife_down — decimal
  • dailylife_up — decimal
  • dailylife_no_change — decimal

hobby

  • hobby_id — decimal — 기본 키 — NOT NULL
  • date — date — 외래 키 → service.date — NOT NULL
  • hobby_list — VARCHAR(255)
  • hobby_m — decimal
  • hobby_f — decimal

media_contents

  • m_contents_id — decimal — 기본 키 — NOT NULL
  • date — date — 외래 키 → service.date — NOT NULL
  • m_contents_list — VARCHAR(255)
  • m_contents_count — decimal
  • m_contents_up — decimal
  • m_contents_down — decimal
  • m_contents_nochange — decimal

media_instruments

  • m_instruments_id — decimal — 기본 키 — NOT NULL
  • date — date — 외래 키 → service.date — NOT NULL
  • m_instruments_list — VARCHAR(255)
  • m_instruments_count — decimal
  • m_instruments_up — decimal
  • m_instruments_down — decimal
  • m_instruments_nochange — decimal

media_service

  • m_service_id — decimal — 기본 키 — NOT NULL
  • date — date — 외래 키 → service.date — NOT NULL
  • m_service_list — VARCHAR(255)
  • m_service_count — decimal
  • m_service_up — decimal
  • m_service_down — decimal
  • m_service_nochange — decimal

population

  • date — date — 외래 키 → covid.date — NOT NULL
  • total_population — VARCHAR(255)
  • region_pop — VARCHAR(255)
  • age_pop — VARCHAR(255)

salary

  • salary_id — decimal — 기본 키 — NOT NULL
  • date — date — 외래 키 → service.date — NOT NULL
  • salary_agelist — decimal
  • salary_p — decimal

salary_job

  • salary_id — decimal — 외래 키 → salary.salary_id — NOT NULL
  • date — date — 외래 키 → salary.date — NOT NULL
  • date (date2) — date — 외래 키 → service.date — NOT NULL
  • salary_job — VARCHAR(255)
  • salarydown_p — decimal

service

  • date — date — 외래 키 → covid.date — NOT NULL
  • dailylife — varchar
  • hobby — varchar
  • media_instruments — varchar
  • media_service — varchar
  • media_contents — varchar
  • society — varchar
  • salary — varchar
  • salary_job — varchar

social_distance

  • government_id — decimal — 기본 키 — NOT NULL
  • date (date2) — date — 외래 키 → covid.date — NOT NULL
  • g_city — varchar
  • g_area — varchar
  • g_start_date — date
  • g_end_date — date
  • g_step — decimal

society

  • society_id — decimal — 기본 키 — NOT NULL
  • date — date — 외래 키 → service.date — NOT NULL
  • society_list — VARCHAR(255)
  • society_agree — decimal
  • society_mm — decimal
  • society_don’t — decimal

symptom

  • none — bool
  • symptom — bool

temperature

  • date — date — 기본 키 — NOT NULL — 날짜
  • date (date2) — date — 외래 키 → covid.date — NOT NULL
  • avrg_temp — decimal — 평균기온
  • high_temp — decimal — 최고기온

vaccine_manufacturer

  • country — varchar
  • manufacturer — varchar
  • vaccine_name — varchar