seoul_meari

Tables (7)

analysis_ticket

  • ticket_id — uuid
  • media_id — uuid — NOT NULL
  • user_id — uuid — NOT NULL
  • location — geography(Point,4326)
  • status — text — NOT NULL
  • severity — text
  • vlm_analysis_text — text
  • idempotency_key — text
  • created_at — timestamptz — NOT NULL

ar_content

  • content_id — uuid
  • place_id — uuid — NOT NULL
  • content_type — text — NOT NULL
  • cdn_url — text — NOT NULL
  • version — text — NOT NULL
  • created_at — timestamptz — NOT NULL

echo_likes

  • like_id — uuid
  • user_id — uuid — NOT NULL
  • echo_id — uuid — NOT NULL
  • created_at — timestamptz — NOT NULL

echoes

  • echo_id — uuid
  • user_id — uuid — NOT NULL
  • content_type — text — NOT NULL
  • content_data — jsonb
  • location — geography(Point,4326) — NOT NULL
  • transform — jsonb
  • place_id — uuid
  • created_at — timestamptz — NOT NULL

media

  • media_id — uuid
  • user_id — uuid — NOT NULL
  • echo_id — uuid
  • s3_key — text — NOT NULL
  • mime_type — text
  • size_bytes — bigint
  • upload_status — text — NOT NULL
  • sha256 — bytea
  • created_at — timestamptz — NOT NULL

places

  • place_id — uuid
  • name — text — NOT NULL
  • description — text
  • geofence — geography(Polygon,4326) — NOT NULL
  • is_active — boolean — NOT NULL

users

  • user_id — uuid
  • nickname — text
  • auth_provider — text — NOT NULL
  • provider_id — text — NOT NULL
  • created_at — timestamptz — NOT NULL