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