pheeeew

Tables (10)

app_version

  • id — BIGINT — Primary key — NOT NULL
  • platform — VARCHAR(20) — NOT NULL
  • min_supported_version — VARCHAR(32) — NOT NULL
  • latest_version — VARCHAR(32) — NOT NULL
  • store_url — VARCHAR(500) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

device_attestation_budgets

  • id — BIGINT — Primary key — NOT NULL
  • budget_date — DATE — NOT NULL
  • call_count — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

device_blocks

  • id — BIGINT — Primary key — NOT NULL
  • blocker_device_id — BIGINT — Foreign key → devices.id — NOT NULL
  • blocked_device_id — BIGINT — Foreign key → devices.id — NOT NULL
  • origin_sigh_id — BIGINT — Foreign key → sighs.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

device_challenges

  • id — BIGINT — Primary key — NOT NULL
  • challenge — VARCHAR(43) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • consumed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • attempt_count — INT — NOT NULL

device_refresh_tokens

  • id — BIGINT — Primary key — NOT NULL
  • device_id — BIGINT — Foreign key → devices.id — NOT NULL
  • session_id — UUID — NOT NULL
  • token_hash — VARCHAR(64) — NOT NULL
  • expires_at — TIMESTAMP
  • revoked_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

devices

  • id — BIGINT — Primary key — NOT NULL
  • public_id — UUID — NOT NULL
  • request_id — UUID — NOT NULL
  • platform — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

sigh_blocks

  • id — BIGINT — Primary key — NOT NULL
  • blocker_device_id — BIGINT — Foreign key → devices.id — NOT NULL
  • sigh_id — BIGINT — Foreign key → sighs.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

sigh_likes

  • id — BIGINT — Primary key — NOT NULL
  • sigh_id — BIGINT — Foreign key → sighs.id — NOT NULL
  • device_id — BIGINT — Foreign key → devices.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

sigh_reports

  • id — BIGINT — Primary key — NOT NULL
  • sigh_id — BIGINT — Foreign key → sighs.id — NOT NULL
  • reason — VARCHAR(200) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • reporter_device_id — BIGINT — Foreign key → devices.id — NOT NULL

sighs

  • id — BIGINT — Primary key — NOT NULL
  • request_id — UUID — NOT NULL
  • location — GEOMETRY — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • memo — VARCHAR(50)
  • nickname — VARCHAR(50) — NOT NULL
  • deleted_at — TIMESTAMP
  • like_count — BIGINT — NOT NULL
  • version — BIGINT — NOT NULL
  • device_id — BIGINT — Foreign key → devices.id