kko
Tables (4)
disease (확진자)
- disease_id (id) — varchar — Primary key — NOT NULL
- user_id — varchar — Foreign key → user.user_id — NOT NULL
- 질병코드 (code) — int
- 질병명 (disease) — varchar
- 감염날짜 (user_infected) — Date
history (기록)
- history_id (id) — varchar — Primary key — NOT NULL
- disease_id — varchar — Foreign key → disease.disease_id — NOT NULL
- store_id — varchar — Foreign key → store.store_id — NOT NULL
- 확진자 방문날짜 (infect_date) — Date
- 방역날짜 (disinfect_date) — Date
store (업체)
- store_id (id) — varchar — Primary key — NOT NULL
- 주소 (address) — varchar
- 업체명 (name) — varchar
- GPS_X (gps_x) — float
- GPS_Y (gpx_y) — float
- 최근 확진자 방문날짜 (infect_last_date) — Date
- 최근 방역날짜 (disinfect_last_date) — Date
user (유저)
- user_id (id) — varchar — Primary key — NOT NULL
- 이메일 (email) — int
- 이름 (name) — CHAR
- 위치정보수집동의 (agree) — TINYINT(1)