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