asan
Tables (6)
beacon_data
- beacon_data_id — INT — Primary key
- coordinate_id (coordinate_id2) — BIGINT — Foreign key → coordinate.coordinate_id
- image_id (image_id2) — BIGINT — Foreign key → coordinate.image_id
- position — VARCHAR(255)
- beaconData — JSON
coordinate
- coordinate_id — BIGINT — Primary key
- image_id — BIGINT — Foreign key → image.image_id
- position — VARCHAR(255)
- latitude — VARCHAR(255)
- longitude — VARCHAR(255)
- startX — DECIMAL(10, 4)
- startY — DECIMAL(10, 4)
- endX — DECIMAL(10, 4)
- endY — DECIMAL(10, 4)
- setting — VARCHAR(255)
- isWeb — BOOLEAN
image
- image_id — BIGINT — Primary key
- imageName — VARCHAR(255)
- imageUrl — VARCHAR(255)
- isWeb — BOOLEAN
watch
- watch_id — BIGINT — Primary key
- uuid — VARCHAR(255)
- device — VARCHAR(255)
- name — VARCHAR(255)
- host — VARCHAR(255)
- minHR — INT
- maxHR — INT
- gender — VARCHAR(255)
- highRisk — VARCHAR(255)
- currentLocation — VARCHAR(255)
watch_coordinate_prohibition
- id — BIGINT — Primary key
- watch_id — BIGINT — Foreign key → watch.watch_id
- coordinate_id — BIGINT — Foreign key → coordinate.coordinate_id
- image_id — BIGINT — Foreign key → coordinate.image_id
watch_no_contact
- id — BIGINT — Primary key
- watch_id (watch_id2) — BIGINT — Foreign key → watch.watch_id
- no_contact_watch_id — BIGINT — Foreign key → watch_no_contact.id