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