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)