waggle
Tables (20)
ai_blur_jobs
- request_id — UUID — Primary key — NOT NULL
- pin_id — UUID — Foreign key → pins.id — NOT NULL
- original_video_key — VARCHAR(1024) — NOT NULL
- job_type — VARCHAR(50) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- completed_at — TIMESTAMPTZ
ai_chat_jobs
- request_id — UUID — Primary key — NOT NULL
- chat_room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
- start_message_id — BIGINT — Foreign key → chat_messages.id — NOT NULL
- end_message_id — BIGINT — Foreign key → chat_messages.id — NOT NULL
- status — VARCHAR(50) — NOT NULL
- completed_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
categories
- id — BIGSERIAL — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- code — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
category_preferences
- id — BIGSERIAL — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- category_id — BIGINT — Foreign key → categories.id — NOT NULL
chat_messages
- id — BIGSERIAL — Primary key — NOT NULL
- chat_room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
- sender_id — BIGINT — Foreign key → members.id — NOT NULL
- client_message_id — UUID — NOT NULL
- content — TEXT — NOT NULL
- masked_content — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
chat_room_members
- id — BIGSERIAL — Primary key — NOT NULL
- chat_room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- last_read_message_id — BIGINT — Foreign key → chat_messages.id
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
chat_rooms
- id — BIGSERIAL — Primary key — NOT NULL
- pin_id — UUID — Foreign key → pins.id — NOT NULL
- recipient_id — BIGINT — Foreign key → members.id — NOT NULL
- requester_id — BIGINT — Foreign key → members.id — NOT NULL
- status — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
chat_warnings
- id — BIGSERIAL — Primary key — NOT NULL
- chat_room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
- reason_code — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
credit_transactions
- id — BIGSERIAL — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- pin_id — UUID — Foreign key → pins.id
- type — VARCHAR(50) — NOT NULL
- change_amount — INTEGER — NOT NULL
- balance_after — INTEGER — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
members
- id — BIGSERIAL — Primary key — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- age_group — VARCHAR(50)
- gender — VARCHAR(50)
- view_angle — NUMERIC(5,1) — NOT NULL
- credit_balance — INTEGER — NOT NULL
- deleted_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
onboarding_sessions
- jti — UUID — Primary key — NOT NULL
- social_account_id — BIGINT — Foreign key → social_accounts.id — NOT NULL
- expires_at — TIMESTAMPTZ — NOT NULL
- used_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
pin_evaluations
- id — BIGSERIAL — Primary key — NOT NULL
- pin_id — UUID — Foreign key → pins.id — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- evaluation — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
pin_tags
- id — BIGSERIAL — Primary key — NOT NULL
- pin_id — UUID — Foreign key → pins.id — NOT NULL
- tag — VARCHAR(30) — NOT NULL
pin_unlocks
- id — BIGSERIAL — Primary key — NOT NULL
- pin_id — UUID — Foreign key → pins.id — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- idempotency_key — UUID — NOT NULL
pins
- id — UUID — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- place_id — BIGINT — Foreign key → places.id — NOT NULL
- publisher_status — VARCHAR(50) — NOT NULL
- video_status — VARCHAR(50) — NOT NULL
- crowd_level — VARCHAR(50)
- capture_location — GEOGRAPHY(POINT, 4326) — NOT NULL
- detail_location — VARCHAR(200)
- memo — VARCHAR(500)
- original_video_key — VARCHAR(1024) — NOT NULL
- blurred_video_key — VARCHAR(1024)
- thumbnail_key — VARCHAR(1024)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- expires_at — TIMESTAMPTZ
- deleted_at — TIMESTAMPTZ
places
- id — BIGSERIAL — Primary key — NOT NULL
- kakao_place_id — VARCHAR(200)
- name — VARCHAR(100) — NOT NULL
- location — GEOGRAPHY(POINT, 4326) — NOT NULL
- category_group_code — VARCHAR(10)
- category_group_name — VARCHAR(50)
- category_name — VARCHAR(255)
- category — VARCHAR(50) — NOT NULL
- phone — VARCHAR(50)
- address_name — VARCHAR(255)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
refresh_tokens
- id — BIGSERIAL — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- token_hash — VARCHAR(64) — NOT NULL
- expires_at — TIMESTAMPTZ — NOT NULL
- revoked_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
search_histories
- id — BIGSERIAL — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- place_id — BIGINT — Foreign key → places.id
- kakao_place_id — VARCHAR(200)
- search_type — VARCHAR(50) — NOT NULL
- keyword — VARCHAR(200)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
social_accounts
- id — BIGSERIAL — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id
- provider — VARCHAR(50) — NOT NULL
- provider_user_id — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
view_transactions
- id — BIGSERIAL — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.id — NOT NULL
- pin_id — UUID — Foreign key → pins.id
- type — VARCHAR(50) — NOT NULL
- change_amount — NUMERIC(5,1) — NOT NULL
- balance_after — NUMERIC(5,1) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL