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