erd

Tables (7)

GPS (gps)

  • store_id (domain) — varchar — Foreign key → store.store_id — NOT NULL
  • GPS_X (gps_x) — float
  • GPS_Y (gps_y) — float

code (질병코드)

  • code (Key) — varchar — Primary key — NOT NULL
  • name (Field) — varchar

disinfectdate (방역날짜)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → visitdate.Key — NOT NULL
  • store_id (domain) — varchar — Foreign key → visitdate.store_id — NOT NULL

history (기록)

  • Key — Primary key — NOT NULL
  • Key (Key3) — Foreign key → code.code — NOT NULL
  • Field (확진날짜)
  • Key (Key2) — Foreign key → user.Key — NOT NULL
  • store_id (domain) — varchar — Foreign key → store.store_id — NOT NULL

store (업체)

  • store_id (domain) — varchar — Primary key — NOT NULL
  • name (업체명) — varchar
  • address (주소) — varchar
  • disinfectdate (방역날짜) — Date

user (유저)

  • Key — Primary key — NOT NULL

visitdate (방문날짜)

  • Key — Primary key — NOT NULL
  • store_id (domain) — varchar — Foreign key → store.store_id — NOT NULL