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