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