INDULGON — DATABASE SCHEMA SUMMARY

Generated: June 8, 2026

Total tables: 450

account_deletion_requests

id uuid, user_id uuid, reason text, export_before_delete boolean, export_id uuid, confirmed boolean, confirmed_at timestamp with time zone, confirmation_code character varying, status character varying, scheduled_deletion_at timestamp with time zone, completed_at timestamp with time zone, records_deleted jsonb, metadata jsonb, created_at timestamp with time zone

account_merge_requests

id uuid, primary_user_id uuid, secondary_user_id uuid, primary_email character varying, secondary_email character varying, primary_verified boolean, secondary_verified boolean, merge_earnings boolean, merge_subscribers boolean, merge_content boolean, merge_bookings boolean, merge_messages boolean, status character varying, completed_at timestamp with time zone, records_merged jsonb, admin_notes text, metadata jsonb, created_at timestamp with time zone

account_recovery_requests

id uuid, email character varying, recovery_type character varying, verification_method character varying, verification_code character varying, verification_expires_at timestamp with time zone, verified boolean, status character varying, notes text, metadata jsonb, created_at timestamp with time zone

account_restore_log

id uuid, snapshot_id uuid, user_id uuid, restored_by uuid, tables_restored jsonb, records_restored integer, mode character varying, created_at timestamp with time zone

account_snapshots

id uuid, user_id uuid, snapshot_type character varying, trigger_reason character varying, snapshot_data jsonb, tables_included jsonb, total_records integer, size_bytes bigint, is_permanent boolean, expires_at timestamp with time zone, created_at timestamp with time zone

achievement_awards

id uuid, name character varying, description text, type character varying, price numeric, image_url text, is_available boolean, created_at timestamp with time zone

achievements

id uuid, name character varying, description text, category character varying, icon character varying, threshold integer, reward_type character varying, reward_value numeric, created_at timestamp with time zone

activity_log

id integer, user_id character varying, action character varying, target_type character varying, target_id character varying, target_name character varying, metadata jsonb, created_at timestamp with time zone, is_public boolean, details jsonb

activity_privacy

user_id uuid, show_online_status boolean, show_time_online boolean, show_activity_details boolean, show_to character varying, show_posts boolean, show_photos_videos boolean, show_likes boolean, show_comments boolean, show_reposts boolean, show_edits boolean, show_profile_updates boolean, show_store_updates boolean, show_bookings boolean, show_following boolean, updated_at timestamp without time zone

addresses

id uuid, user_id uuid, name text, category text, address text, city text, state text, zip text, country text, contact_person text, public_label text, notes text, latitude numeric, longitude numeric, is_deleted boolean, created_at timestamp with time zone, updated_at timestamp with time zone

admin_notification_recipients

id uuid, notification_id uuid, user_id uuid, sent_at timestamp with time zone, read_at timestamp with time zone, dismissed_at timestamp with time zone, action_completed_at timestamp with time zone, action_type character varying

admin_notifications

id uuid, admin_id uuid, title character varying, message text, notification_type character varying, target_user_type ARRAY, target_specific_users ARRAY, priority character varying, created_at timestamp with time zone, expires_at timestamp with time zone, is_active boolean

affiliate_links

id uuid, user_id uuid, program_id uuid, link_code character varying, clicks integer, conversions integer, earnings numeric, created_at timestamp with time zone

affiliate_programs

id uuid, studio_id uuid, program_name character varying, commission_rate numeric, program_type character varying, terms text, is_active boolean, created_at timestamp with time zone

age_verification

id uuid, user_id uuid, date_of_birth date, verification_method character varying, id_document_url text, status character varying, verified_at timestamp with time zone, reviewer_id uuid, created_at timestamp with time zone

age_verifications

id uuid, user_id uuid, verification_method character varying, verified_at timestamp with time zone, verified_by character varying, document_type character varying, document_hash text, expiry_date date, is_valid boolean, notes text, id_expiry_date date, reverify_required boolean, reverify_reason text, reverify_notified_at timestamp with time zone

ai_chat_history

id uuid, user_id uuid, message text, reply text, topic character varying, page_context character varying, created_at timestamp with time zone

ai_context

user_id uuid, location character varying, event_name character varying, booth_number character varying, current_activity character varying, notes text, updated_at timestamp with time zone

ai_conversation_summaries

id uuid, user_id uuid, session_id character varying, summary text, message_count integer, created_at timestamp with time zone

ai_conversations

id uuid, user_id uuid, session_id character varying, role character varying, content text, page_context character varying, tokens_used integer, model character varying, created_at timestamp with time zone

ai_generated_docs

id uuid, user_id uuid, title character varying, type character varying, prompt text, content text, file_url character varying, status character varying, provider character varying, external_task_id character varying, created_at timestamp with time zone, completed_at timestamp with time zone

ai_usage

id uuid, user_id uuid, date date, message_count integer, tokens_in integer, tokens_out integer, estimated_cost numeric

ai_user_memory

id uuid, user_id uuid, key character varying, value text, category character varying, created_at timestamp with time zone, updated_at timestamp with time zone

album_items

id uuid, album_id uuid, post_id uuid, created_at timestamp with time zone

albums

id uuid, user_id uuid, name character varying, description text, cover_image_url text, is_public boolean, price numeric, auto_sort_by character varying, item_count integer, created_at timestamp with time zone

alternative_suggestions

id uuid, performer_id uuid, name character varying, description text, category character varying, price_cents integer, image_url text, is_active boolean, times_suggested integer, last_suggested_at timestamp with time zone, times_accepted integer, metadata jsonb, created_at timestamp with time zone, updated_at timestamp with time zone

amateur_content

id uuid, profile_id uuid, title character varying, price numeric, category character varying, status character varying, uploaded_at timestamp with time zone, approved_at timestamp with time zone

amateur_profiles

id uuid, user_id uuid, display_name character varying, verification_status character varying, age_verified boolean, content_count integer, total_earnings numeric, category character varying, created_at timestamp with time zone

amazon_my_products

id integer, user_id character varying, title character varying, price character varying, image_url text, product_url text, asin character varying, category character varying, description text, is_active boolean, created_at timestamp with time zone

amazon_reviews

id uuid, asin character varying, reviewer_name character varying, rating numeric, title text, body text, review_date date, verified_purchase boolean, helpful_count integer, images jsonb, created_at timestamp with time zone

amazon_wishlist_items

id uuid, wishlist_id uuid, user_id uuid, title character varying, price numeric, image_url text, product_url text, asin character varying, is_purchased boolean, priority character varying, notes text, product_data jsonb, created_at timestamp with time zone, expected_date date, status character varying, full_title text, brand text, category_l1 text, category_l2 text, category_l3 text, breadcrumbs text, all_images jsonb, list_price text, rating text, review_count text, description_bullets jsonb, description text, availability text, enriched_at timestamp without time zone, color character varying, size character varying, variant_group character varying, product_images jsonb, review_images jsonb, location character varying, purchased_at timestamp with time zone, purchased_by character varying, purchase_price numeric, is_favorited boolean, last_moved_at timestamp with time zone, move_count integer, notion_page_id character varying

amazon_wishlists

id uuid, user_id uuid, name character varying, amazon_list_id character varying, item_count integer, last_synced_at timestamp with time zone, created_at timestamp with time zone, folder_id uuid, is_smart boolean, smart_rule jsonb, visibility character varying, description text, cover_image text, updated_at timestamp with time zone, source character varying, notion_database_id character varying

analytics_events

id uuid, user_id uuid, event character varying, properties jsonb, created_at timestamp with time zone

api_errors

id integer, route text, method character varying, status_code integer, error_message text, user_id character varying, occurred_at timestamp with time zone

ar_filters

id integer, creator_id character varying, name character varying, category character varying, filter_data jsonb, preview_url text, description text, tags ARRAY, use_count integer, is_active boolean, created_at timestamp with time zone

archive

id uuid, original_table character varying, original_id uuid, user_id uuid, content_type character varying, title character varying, content text, media_urls jsonb, file_url text, file_name character varying, file_size bigint, file_type character varying, metadata jsonb, deletion_reason character varying, deleted_by uuid, is_recoverable boolean, recovered_at timestamp with time zone, recovered_by uuid, created_at timestamp with time zone, archived_at timestamp with time zone, permanent boolean, expires_at timestamp with time zone

ask_auto_answers

id integer, user_id character varying, question_patterns text, answer text, category character varying, auto_respond boolean, is_active boolean, times_used integer, last_used_at timestamp with time zone, created_at timestamp with time zone, updated_at timestamp with time zone

ask_box

id integer, recipient_id character varying, sender_id character varying, question text, answer text, is_anonymous boolean, status character varying, answered_at timestamp with time zone, created_at timestamp with time zone, is_priority boolean, payment_status character varying, payment_intent_id character varying, amount_paid numeric, platform_fee numeric, performer_earnings numeric, duplicate_of integer, auto_answer_id integer, suggested_answer_id integer, sender_role text, sender_user_type text, is_free_for_role boolean, question_context text

ask_box_settings

id integer, user_id character varying, free_questions integer, price_per_question numeric, priority_price numeric, allow_anonymous boolean, auto_publish boolean, is_enabled boolean, max_question_length integer, updated_at timestamp with time zone, auto_respond_enabled boolean

asmr_bookings

id uuid, session_id uuid, viewer_id uuid, custom_triggers jsonb, status character varying, created_at timestamp with time zone

asmr_sessions

id uuid, performer_id uuid, title character varying, description text, asmr_type character varying, duration_minutes integer, price numeric, scheduled_at timestamp with time zone, triggers jsonb, is_private boolean, status character varying, created_at timestamp with time zone

audio_room_participants

id integer, room_id integer, user_id character varying, role character varying, status character varying, joined_at timestamp with time zone, left_at timestamp with time zone

audio_rooms

id integer, host_id character varying, title character varying, description text, topics jsonb, scheduled_at timestamp with time zone, max_speakers integer, is_recorded boolean, visibility character varying, status character varying, ended_at timestamp with time zone, created_at timestamp with time zone

auto_email_templates

id uuid, trigger_type character varying, subject character varying, body text, is_active boolean, created_at timestamp with time zone

auto_post_albums

id uuid, user_id uuid, album_name character varying, device_id character varying, posting_mode character varying, batch_time time without time zone, schedule_posts_per_day integer, group_by character varying, content_filter character varying, auto_caption boolean, caption_style character varying, hide_location boolean, is_active boolean, created_at timestamp with time zone, timed_slots jsonb, timed_separate_posts boolean, batch_trigger_id uuid

auto_post_groups

id uuid, user_id uuid, event_name character varying, event_day integer, date date, item_count integer, ai_caption text, status character varying, post_id uuid, scheduled_post_at timestamp with time zone, posted_at timestamp with time zone, created_at timestamp with time zone

auto_post_queue

id uuid, user_id uuid, album_id uuid, media_url text, media_type character varying, thumbnail_url text, file_hash character varying, taken_at timestamp with time zone, taken_at_ms bigint, device_location_lat numeric, device_location_lng numeric, location_label character varying, detected_outfit_hash character varying, detected_event character varying, detected_context jsonb, ai_caption text, ai_caption_generated boolean, status character varying, post_id uuid, group_id uuid, scheduled_post_at timestamp with time zone, posted_at timestamp with time zone, error text, created_at timestamp with time zone

auto_post_settings

id uuid, user_id uuid, scene_released boolean, award_nominated boolean, award_won boolean, new_store_listing boolean, strip_club_appearance boolean, booking_confirmed boolean, milestone_reached boolean, going_live boolean, wishlist_gift_received boolean, workout_completed boolean, recipe_shared boolean, music_shared boolean, custom_templates jsonb, created_at timestamp with time zone, updated_at timestamp with time zone

award_orders

id uuid, user_id uuid, award_id uuid, achievement_id uuid, shipping_address jsonb, customization jsonb, status character varying, created_at timestamp with time zone

award_submissions

id uuid, user_id uuid, film_id uuid, award_name character varying, category character varying, year integer, status character varying, submitted_date date, result_date date, scene_transaction_id uuid, closet_item_ids jsonb, notes text, created_at timestamp with time zone, updated_at timestamp with time zone, ceremony_date date, film_title character varying

bank_connections

id uuid, user_id uuid, provider character varying, institution_name character varying, account_type character varying, account_mask character varying, access_token_encrypted text, status character varying, last_synced timestamp with time zone, created_at timestamp with time zone

bank_statements

id uuid, user_id uuid, bank character varying, account_number character varying, account_type character varying, account_label character varying, statement_month character varying, statement_year integer, start_balance numeric, end_balance numeric, total_in numeric, total_out numeric, transaction_count integer, file_path text, file_name character varying, metadata jsonb, created_at timestamp with time zone

bank_transactions

id uuid, user_id uuid, statement_id uuid, bank character varying, account_number character varying, account_label character varying, txn_date date, description text, details text, amount numeric, category character varying, category_label character varying, is_internal boolean, is_categorized boolean, metadata jsonb, created_at timestamp with time zone

birthday_messages

id uuid, fan_id uuid, message text, attachments jsonb, discount_code character varying, is_automated boolean, sent_at timestamp with time zone

blacklist

id uuid, user_id uuid, blocked_name character varying, blocked_identifier character varying, reason text, block_type character varying, notes text, created_at timestamp with time zone

blocked_dates

id uuid, user_id uuid, blocked_date date, reason character varying, created_at timestamp with time zone

body_measurements

id uuid, user_id uuid, date date, weight numeric, body_fat_pct numeric, chest numeric, waist numeric, hips numeric, arms numeric, thighs numeric, notes text, created_at timestamp with time zone

booking_preferences

id uuid, user_id uuid, agent_receives_requests boolean, i_receive_requests boolean, agent_can_accept boolean, i_can_accept_directly boolean, wait_for_agent boolean, wait_for_agent_hours integer, auto_accept_if_open boolean, notify_agent_on_direct_accept boolean, notify_me_on_agent_accept boolean, block_same_day boolean, buffer_minutes integer, availability_start time without time zone, availability_end time without time zone, blocked_days ARRAY, show_on_available_list boolean, show_rates boolean, show_stats_to_studios boolean, allow_direct_studio_contact boolean, allow_direct_fan_booking boolean, require_agent_for_scene_work boolean, require_agent_for_appearances boolean, created_at timestamp with time zone, updated_at timestamp with time zone

booking_requests

id uuid, requester_id uuid, requester_type character varying, recipient_id uuid, recipient_type character varying, agent_id uuid, scene_type character varying, description text, title character varying, requested_date date, requested_time_start time without time zone, requested_time_end time without time zone, duration_hours numeric, is_multi_day boolean, end_date date, offered_rate numeric, rate_notes text, is_first_time_rate boolean, other_performers text, director character varying, location character varying, status character varying, agent_status character varying, performer_status character varying, agent_notified boolean, agent_responded_at timestamp with time zone, agent_unlock_at timestamp with time zone, call_sheet_url text, contract_url text, attachments jsonb, rebook_from_id uuid, rebook_source character varying, is_promotion boolean, promotion_type character varying, promotion_data jsonb, notes text, created_at timestamp with time zone, updated_at timestamp with time zone, read_at timestamp with time zone, priority_fee_cents integer, is_expedited boolean, queue_position integer, expedited_at timestamp with time zone, rebooked_from uuid, rate numeric, duration text, reconsider_requested_at timestamp with time zone, reconsider_message text, production_type text

booking_verifications

id uuid, booking_id uuid, customer_id uuid, performer_id uuid, booking_type character varying, requires_id boolean, requires_payment_hold boolean, requires_deposit boolean, deposit_percent numeric, id_verified boolean, payment_verified boolean, deposit_paid boolean, card_on_file boolean, card_payment_method_id character varying, card_last_four character varying, hold_amount numeric, verified_at timestamp with time zone, created_at timestamp with time zone

bookings

id uuid, performer_id uuid, booker_id uuid, booking_type character varying, status character varying, date date, time_start time without time zone, time_end time without time zone, location character varying, rate numeric, agent_fee numeric, travel_included boolean, flight_info text, hotel_info text, venue_address text, notes text, callsheet jsonb, privacy character varying, created_at timestamp with time zone, updated_at timestamp with time zone, booking_source character varying, mood text, mood_notes text, coworker_user_id uuid, coworker_placeholder_id uuid, production_type text, scene_id uuid, payment_confirmed boolean, payment_confirmed_at timestamp with time zone, agent_id uuid, agent_fee_percentage numeric, agent_fee_paid boolean, agent_fee_paid_at timestamp with time zone

bookmark_collections

id uuid, user_id uuid, name character varying, description text, cover_image text, view_mode character varying, is_default boolean, sort_order integer, created_at timestamp with time zone

bookmarks

id uuid, user_id uuid, post_id uuid, folder character varying, created_at timestamp with time zone, metadata jsonb, content_type character varying, content_id uuid, updated_at timestamp with time zone, url text, title character varying, description character varying, tags ARRAY, bookmark_type character varying, collection_id uuid, thumbnail_url text, source_platform character varying, source_user character varying, product_data jsonb, department character varying, category character varying, subcategory character varying, normalized_url text, source character varying, saved_at timestamp with time zone, is_alive boolean, last_checked timestamp with time zone, http_status integer

bot_event_log

id integer, bot_id integer, user_id character varying, event character varying, data jsonb, status character varying, response jsonb, created_at timestamp with time zone

bot_installs

id integer, user_id character varying, bot_id integer, settings jsonb, is_active boolean, installed_at timestamp with time zone

bots

id integer, creator_id character varying, name character varying, description text, category character varying, avatar_url text, webhook_url text, permissions jsonb, trigger_events jsonb, commands jsonb, settings_schema jsonb, code text, status character varying, published_at timestamp with time zone, created_at timestamp with time zone, updated_at timestamp with time zone

budgets

id uuid, user_id uuid, name character varying, amount numeric, category character varying, period character varying, created_at timestamp with time zone, updated_at timestamp with time zone

calendar_blocks

id uuid, user_id uuid, block_type character varying, block_date date, start_time time without time zone, end_time time without time zone, title character varying, booking_request_id uuid, transaction_id uuid, is_all_day boolean, notes text, created_at timestamp with time zone

calendar_connections

id uuid, user_id uuid, provider character varying, label character varying, ical_url text, oauth_token text, last_sync timestamp with time zone, event_count integer, status character varying, created_at timestamp with time zone

calendar_events

id uuid, user_id uuid, title character varying, event_type character varying, date date, time_start time without time zone, time_end time without time zone, description text, linked_post_id uuid, linked_booking_id uuid, is_public boolean, created_at timestamp with time zone, category character varying, source character varying, external_id character varying, is_visible boolean, reminder_at timestamp with time zone

calendar_sync_config

id uuid, user_id uuid, provider character varying, access_token text, refresh_token text, token_expiry timestamp with time zone, calendar_id character varying, sync_enabled boolean, last_sync timestamp with time zone, created_at timestamp with time zone

call_queue

id integer, caller_id character varying, callee_id character varying, call_type character varying, is_paid boolean, status character varying, answered_at timestamp with time zone, ended_at timestamp with time zone, metadata jsonb, created_at timestamp with time zone

cam_chat_messages

id uuid, room_id uuid, sender_id uuid, message text, message_type character varying, tip_amount numeric, is_visible boolean, created_at timestamp with time zone

cam_private_requests

id uuid, room_id uuid, requester_id uuid, performer_id uuid, status character varying, rate_per_min numeric, duration_requested integer, total_cost numeric, started_at timestamp with time zone, ended_at timestamp with time zone, created_at timestamp with time zone

cam_rooms

id uuid, performer_id uuid, title character varying, description text, status character varying, room_type character varying, credit_rate_per_min numeric, private_rate_per_min numeric, group_rate_per_min numeric, ticket_price numeric, max_viewers integer, current_viewers integer, category character varying, tags jsonb, thumbnail_url text, started_at timestamp with time zone, ended_at timestamp with time zone, total_earned numeric, total_minutes integer, settings jsonb, created_at timestamp with time zone, updated_at timestamp with time zone, recording_url text, replay_enabled boolean, shared_to_feed boolean, share_link character varying, peak_viewers integer, total_tips numeric, highlight_clip_url text, mood text, mood_notes text

cam_schedules

id uuid, performer_id uuid, title character varying, description text, scheduled_at timestamp with time zone, duration_minutes integer, room_type character varying, ticket_price numeric, notify_followers boolean, created_at timestamp with time zone

cam_tips

id uuid, room_id uuid, tipper_id uuid, performer_id uuid, amount numeric, message text, is_anonymous boolean, created_at timestamp with time zone

cam_viewer_sessions

id uuid, room_id uuid, viewer_id uuid, session_type character varying, status character varying, credits_spent numeric, minutes_watched integer, joined_at timestamp with time zone, left_at timestamp with time zone, billing_started_at timestamp with time zone, last_billed_at timestamp with time zone, is_muted boolean, is_banned boolean, created_at timestamp with time zone

campaigns

id uuid, user_id uuid, name character varying, campaign_type character varying, content jsonb, target_platforms jsonb, scheduled_at timestamp with time zone, launched_at timestamp with time zone, budget numeric, description text, status character varying, created_at timestamp with time zone, updated_at timestamp with time zone

caption_jobs

id integer, user_id character varying, video_url text, source_type character varying, source_id integer, language character varying, style jsonb, burn_in boolean, translate_to character varying, captions jsonb, status character varying, completed_at timestamp with time zone, created_at timestamp with time zone

caption_library

id uuid, user_id uuid, caption text, category character varying, tags jsonb, times_used integer, created_at timestamp with time zone

caption_settings

id integer, user_id character varying, auto_caption_posts boolean, auto_caption_stories boolean, auto_caption_reels boolean, default_style jsonb, default_language character varying, burn_in boolean, updated_at timestamp with time zone

captions

id uuid, user_id uuid, caption_text text, folder character varying, tags jsonb, mood character varying, use_count integer, created_at timestamp with time zone, text text, category character varying, platforms jsonb, last_used timestamp with time zone

career_timeline

id uuid, user_id uuid, event_type character varying, event_date timestamp with time zone, title character varying, description text, entity_type character varying, entity_id uuid, metadata jsonb, is_public boolean, created_at timestamp with time zone

cashapp_accounts

id uuid, user_id uuid, cashapp_tag character varying, account_type character varying, label character varying, is_internal_partner boolean, partner_name character varying, created_at timestamp with time zone

change_trail

id integer, content_type character varying, content_id character varying, user_id character varying, field_name character varying, old_value text, new_value text, edit_type character varying, metadata jsonb, created_at timestamp with time zone

channel_points

id integer, user_id character varying, performer_id character varying, points integer, updated_at timestamp with time zone

channel_points_log

id integer, user_id character varying, performer_id character varying, points integer, action character varying, reason text, created_at timestamp with time zone

channel_rewards

id integer, performer_id character varying, title character varying, description text, cost integer, max_redemptions integer, cooldown_seconds integer, is_active boolean, created_at timestamp with time zone

chat_settings

id uuid, user_id uuid, conversation_id uuid, history_enabled boolean, auto_delete_days integer, created_at timestamp with time zone

client_errors

id integer, user_id character varying, error_message text, page_url text, stack_trace text, user_agent text, occurred_at timestamp with time zone, session_id text, error_type text, button_id text, button_text text, screen_size text, auto_fix_attempted boolean, auto_fix_successful boolean, metadata jsonb, created_at timestamp with time zone, resolved_at timestamp with time zone, viewed_at timestamp with time zone, acknowledged_at timestamp with time zone, acknowledged_by text, notion_page_id text, notion_last_synced_at timestamp with time zone

client_interactions

id uuid, client_id uuid, type character varying, note text, created_at timestamp with time zone

client_relationships

id uuid, user_id uuid, name character varying, type character varying, tier character varying, total_spent numeric, booking_count integer, last_seen timestamp with time zone, rating numeric, notes text, tags ARRAY, status character varying, blacklist_reason text, blacklisted_at timestamp with time zone, vetted boolean, vetted_at timestamp with time zone, first_contact timestamp with time zone, created_at timestamp with time zone

closet_items

id uuid, user_id uuid, name character varying, description text, brand character varying, size character varying, color character varying, category character varying, tags jsonb, status character varying, purchase_price numeric, purchase_date date, purchase_source character varying, sale_price numeric, sale_date date, sold_to uuid, photos jsonb, wishlist_item_id uuid, product_id uuid, used_item_id uuid, transaction_id uuid, sale_transaction_id uuid, scene_ids jsonb, feed_post_ids jsonb, fan_requests_enabled boolean, request_count integer, is_deleted boolean, created_at timestamp with time zone, updated_at timestamp with time zone, sold_price numeric, sold_at timestamp with time zone, outfit_category character varying, available_for_requests boolean, request_upcharge numeric

cloud_connections

id uuid, user_id uuid, provider character varying, account_email character varying, access_token text, refresh_token text, root_folder character varying, sync_direction character varying, auto_sync boolean, last_sync timestamp with time zone, status character varying, storage_used bigint, storage_limit bigint, created_at timestamp with time zone

cloud_sync_folders

id uuid, connection_id uuid, user_id uuid, cloud_path character varying, platform_folder character varying, sync_enabled boolean, last_sync timestamp with time zone, files_synced integer, created_at timestamp with time zone

comments

id uuid, post_id uuid, user_id uuid, content text, likes_count integer, created_at timestamp with time zone

companion_bookings

id uuid, client_id uuid, companion_id uuid, booking_date date, booking_time time without time zone, duration_hours numeric, location text, service_type character varying, special_requests text, estimated_rate numeric, counter_rate numeric, counter_message text, is_overnight boolean, is_weekend boolean, status character varying, rating integer, review text, created_at timestamp with time zone, updated_at timestamp with time zone, mood text, mood_notes text

companion_clients

id uuid, user_id uuid, name character varying, phone character varying, email character varying, screening_status character varying, screening_data jsonb, notes text, rating integer, blacklisted boolean, created_at timestamp with time zone

companion_profiles

id uuid, user_id uuid, headline character varying, description text, rate_hourly numeric, rate_overnight numeric, rate_weekend numeric, travel_expenses jsonb, extended_hours_rate numeric, cancellation_policy jsonb, services_offered jsonb, requirements jsonb, availability jsonb, location_city character varying, location_state character varying, willing_to_travel boolean, created_at timestamp with time zone, updated_at timestamp with time zone

companion_rates

id uuid, user_id uuid, duration character varying, rate numeric, incall boolean, outcall boolean, description text, created_at timestamp with time zone

connected_accounts

id integer, user_id uuid, platform character varying, platform_username character varying, platform_user_id character varying, access_token text, refresh_token text, token_expires_at timestamp without time zone, is_active boolean, last_sync_at timestamp without time zone, metadata jsonb, created_at timestamp without time zone, updated_at timestamp without time zone

connected_databases

id uuid, user_id uuid, database_id text, database_name text, category text, subcategory text, page_slug ARRAY, is_financial boolean, sync_direction text, auto_sync boolean, last_synced timestamp with time zone, record_count integer, status text, money_properties ARRAY, all_properties jsonb, created_at timestamp with time zone, updated_at timestamp with time zone

connected_notion_databases

id uuid, user_id uuid, database_id text, database_name text, category text, default_type text, auto_sync boolean, last_synced timestamp with time zone, record_count integer, created_at timestamp with time zone, last_checked timestamp with time zone, total_in_notion integer, new_since_sync integer, modified_since_sync integer, sync_status text

contact_sync_state

id uuid, user_id uuid, contact_id uuid, external_id text, external_source character varying, external_hash text, last_synced timestamp with time zone, created_at timestamp with time zone

content_albums

id uuid, user_id uuid, name text, description text, cover_image text, item_count integer, created_at timestamp with time zone, updated_at timestamp with time zone

content_calendar

id uuid, user_id uuid, title character varying, type character varying, platform character varying, scheduled_date timestamp with time zone, status character varying, caption text, media_url text, created_at timestamp with time zone, linked_event_id uuid, media_count integer, tags jsonb, collaborator_user_id uuid, collaborator_placeholder_id uuid, content text, scheduled_for timestamp with time zone, content_type text, platforms jsonb, media_urls jsonb, notes text, updated_at timestamp with time zone

content_deliveries

id uuid, shoot_id uuid, request_id uuid, performer_id uuid, customer_id uuid, file_ids ARRAY, file_count integer, delivery_url text, delivery_method character varying, message text, delivered_at timestamp with time zone, downloaded_at timestamp with time zone, metadata jsonb

content_reports

id uuid, reporter_id uuid, reported_user_id uuid, reported_content_id uuid, reported_content_type character varying, reason character varying, description text, evidence_urls jsonb, status character varying, action_taken character varying, admin_notes text, resolved_by uuid, resolved_at timestamp with time zone, created_at timestamp with time zone, priority character varying, details text, resolution character varying

content_sensitivity

id integer, content_type character varying, content_id character varying, is_nsfw boolean, is_sensitive boolean, nsfw_level character varying, sensitivity_tags jsonb, verified_by_user boolean, ai_confidence double precision, created_at timestamp without time zone, updated_at timestamp without time zone

content_shoot_files

id uuid, shoot_id uuid, user_id uuid, file_type character varying, file_url text, thumbnail_url text, filename character varying, file_size bigint, width integer, height integer, duration_seconds integer, is_selected boolean, is_sent boolean, is_bonus boolean, sort_order integer, captured_at timestamp with time zone, tags ARRAY, metadata jsonb, created_at timestamp with time zone

content_shoots

id uuid, user_id uuid, shoot_type character varying, title character varying, description text, request_id uuid, customer_id uuid, shot_at timestamp with time zone, location character varying, tags ARRAY, total_files integer, selected_count integer, delivered boolean, delivered_at timestamp with time zone, delivery_method character varying, metadata jsonb, created_at timestamp with time zone

contracts

id uuid, user_id uuid, contract_type character varying, party_name character varying, start_date date, end_date date, rate numeric, commission_pct numeric, terms text, document_url text, status character varying, auto_renew boolean, renewal_date date, notes text, created_at timestamp with time zone, updated_at timestamp with time zone

conversations

id uuid, participant_1 uuid, participant_2 uuid, last_message_at timestamp with time zone, unread_1 integer, unread_2 integer, is_blocked boolean, created_at timestamp with time zone, source_platform character varying, source_conversation_id character varying, imported_at timestamp with time zone, customer_notes text, is_saved boolean, saved_at timestamp with time zone

costar_connections

id integer, user_id_a text, user_id_b text, connection_type text, status text, connected_at timestamp with time zone, created_at timestamp with time zone

counter_offers

id uuid, booking_id uuid, user_id uuid, client_id uuid, mode character varying, original_price numeric, counter_price numeric, status character varying, notes text, created_at timestamp with time zone, from_user_id uuid, to_user_id uuid, proposed_price numeric, proposed_date timestamp with time zone, proposed_duration character varying, message text, response_message text, responded_at timestamp with time zone

credit_packages

id uuid, name character varying, price_cents integer, credits integer, bonus_percent numeric, is_active boolean, sort_order integer, created_at timestamp with time zone

credit_transactions

id uuid, user_id uuid, amount integer, type character varying, description text, reference_id uuid, reference_type character varying, package_id uuid, gifted_to uuid, expires_at timestamp with time zone, source character varying, created_at timestamp with time zone, dollar_value numeric, credit_source character varying, performer_id uuid, performer_payout numeric, platform_fee_amount numeric

cross_post_log

id uuid, user_id uuid, post_id uuid, platform character varying, status character varying, external_post_id character varying, created_at timestamp with time zone

custom_categories

id uuid, user_id uuid, name text, icon text, color text, parent_category text, display_in_nav boolean, nav_section text, created_at timestamp with time zone

custom_forms

id uuid, user_id uuid, title character varying, description text, fields jsonb, is_public boolean, created_at timestamp with time zone

custom_pages

id uuid, user_id uuid, title character varying, slug character varying, description text, is_public boolean, sort_order integer, layout character varying, created_at timestamp with time zone, updated_at timestamp with time zone

custom_phrases

id integer, user_id character varying, target_id character varying, target_nickname character varying, phrase text, context character varying, category character varying, source character varying, is_active boolean, times_used integer, last_used_at timestamp with time zone, created_at timestamp with time zone

custom_requests

id uuid, customer_id uuid, performer_id uuid, formats jsonb, total_price_cents integer, special_instructions text, queue_position integer, status character varying, estimated_delivery timestamp with time zone, delivered_at timestamp with time zone, delivery_url text, payment_status character varying, created_at timestamp with time zone, updated_at timestamp with time zone, request_type character varying, metadata jsonb, quote_id character varying, stripe_payment_link_id character varying, stripe_payment_link_url text, payment_link_status character varying, payment_link_created_at timestamp with time zone, payment_link_expires_at timestamp with time zone, payment_reminder_count integer, last_reminder_sent_at timestamp with time zone, amount_paid_cents integer, customer_email character varying, customer_name character varying, quote_approved_at timestamp with time zone, quote_declined_at timestamp with time zone, decline_reason text, notification_preference character varying, moved_to_queue boolean, stripe_payment_intent_id character varying, read_at timestamp with time zone, priority_fee_cents integer, is_expedited boolean, expedited_at timestamp with time zone, reconsider_requested_at timestamp with time zone, reconsider_message text

custom_transaction_categories

id uuid, user_id uuid, name character varying, label character varying, description text, parent_category character varying, icon character varying, color character varying, created_at timestamp with time zone, updated_at timestamp with time zone

customer_identities

id uuid, customer_id uuid, performer_id uuid, platform character varying, username character varying, display_name character varying, linked_by character varying, linked_at timestamp with time zone, confidence numeric

data_exports

id uuid, user_id uuid, export_type character varying, include_sensara_data boolean, include_imported_data boolean, include_earnings boolean, include_subscribers boolean, include_messages boolean, include_payouts boolean, include_content boolean, include_bookings boolean, include_profile boolean, include_settings boolean, include_analytics boolean, include_financial boolean, include_social boolean, include_safety boolean, format character varying, status character varying, progress integer, file_path text, file_size_bytes bigint, download_count integer, max_downloads integer, started_at timestamp with time zone, completed_at timestamp with time zone, expires_at timestamp with time zone, last_downloaded_at timestamp with time zone, error_message text, metadata jsonb, created_at timestamp with time zone

data_recovery_requests

id uuid, user_id uuid, platform character varying, platform_username character varying, platform_email character varying, account_status character varying, reason_lost_access text, request_earnings boolean, request_subscribers boolean, request_messages boolean, request_payouts boolean, request_content_list boolean, proof_type character varying, proof_details text, proof_files jsonb, acknowledged_terms boolean, acknowledged_at timestamp with time zone, legal_basis character varying, status character varying, sent_at timestamp with time zone, platform_response_at timestamp with time zone, platform_response_notes text, completed_at timestamp with time zone, import_id uuid, records_recovered integer, request_letter text, admin_notes text, follow_up_count integer, last_follow_up_at timestamp with time zone, metadata jsonb, created_at timestamp with time zone, updated_at timestamp with time zone

discovery_preferences

user_id uuid, preferences jsonb, quiz_completed boolean, created_at timestamp with time zone, updated_at timestamp with time zone

dmca_requests

id uuid, user_id uuid, infringing_url text, original_content_url text, platform character varying, status character varying, filed_at timestamp with time zone, resolved_at timestamp with time zone, resolution text, created_at timestamp with time zone, reporter_id uuid, description text, content_type character varying, evidence_urls jsonb, admin_notes text, action_taken text, counter_notice text, counter_evidence jsonb, counter_filed_by uuid, counter_filed_at timestamp with time zone

donations

id uuid, fundraiser_id uuid, donor_id uuid, amount numeric, message text, is_anonymous boolean, created_at timestamp with time zone

draft_campaigns

id uuid, user_id uuid, name character varying, post_ids ARRAY, status character varying, publish_at timestamp with time zone, created_at timestamp with time zone

earning_statements

id uuid, user_id uuid, platform character varying, period character varying, start_date date, end_date date, gross_amount numeric, platform_fee numeric, net_amount numeric, payout_date date, status character varying, raw_data jsonb, source_file character varying, imported_at timestamp with time zone, created_at timestamp with time zone

earnings

id uuid, user_id uuid, source character varying, amount numeric, fee numeric, net_amount numeric, description text, period_start date, period_end date, status character varying, payout_date date, created_at timestamp with time zone, source_platform character varying, original_date timestamp with time zone, imported_at timestamp with time zone, statement_id character varying, statement_period character varying, source_status character varying, is_test_data boolean

earnings_deductions

id uuid, user_id uuid, category character varying, label character varying, percentage numeric, flat_amount numeric, active boolean, created_at timestamp with time zone

email_confirmations

id uuid, user_id uuid, email character varying, token character varying, confirmed boolean, confirmed_at timestamp with time zone, created_at timestamp with time zone, expires_at timestamp with time zone

email_connections

id uuid, user_id uuid, provider character varying, email character varying, oauth_token text, last_sync timestamp with time zone, status character varying, created_at timestamp with time zone

email_integration

id uuid, user_id uuid, provider character varying, email_address character varying, access_token text, refresh_token text, token_expiry timestamp with time zone, sync_enabled boolean, auto_categorize boolean, last_sync timestamp with time zone, created_at timestamp with time zone

email_summaries

id uuid, user_id uuid, email_id character varying, subject character varying, sender character varying, summary text, category character varying, priority character varying, needs_action boolean, suggested_reply text, read boolean, synced_at timestamp with time zone

email_templates

id uuid, user_id uuid, name character varying, category character varying, subject character varying, body text, active boolean, created_at timestamp with time zone, is_system boolean, variables jsonb, updated_at timestamp with time zone

embed_widgets

id uuid, user_id uuid, widget_type character varying, config jsonb, embed_code text, views integer, created_at timestamp with time zone

emergency_contacts

id uuid, user_id uuid, name character varying, phone character varying, relationship character varying, priority integer, created_at timestamp with time zone, is_primary boolean, email character varying

entity_links

id uuid, source_type character varying, source_id uuid, target_type character varying, target_id uuid, link_type character varying, metadata jsonb, created_at timestamp with time zone

event_interests

id uuid, event_id uuid, user_id uuid, created_at timestamp with time zone

expedite_bids

id integer, request_type character varying, request_id character varying, bidder_id character varying, performer_id character varying, bid_amount_cents integer, previous_position integer, new_position integer, outbid_user_id character varying, payment_intent_id character varying, status character varying, created_at timestamp with time zone

expedite_settings

id integer, user_id character varying, enabled boolean, min_fee_cents integer, fee_type character varying, fixed_fee_cents integer, percentage_fee numeric, bidding_enabled boolean, bidding_increment_cents integer, max_expedited_slots integer, show_queue_position boolean, show_expedite_option boolean, created_at timestamp with time zone, updated_at timestamp with time zone

expenses

id uuid, user_id uuid, category character varying, subcategory character varying, amount numeric, description text, vendor character varying, is_tax_deductible boolean, tax_category character varying, receipt_url text, date date, source character varying, bank_transaction_id character varying, created_at timestamp with time zone

external_earnings

id integer, user_id uuid, connected_account_id integer, platform character varying, amount numeric, currency character varying, earned_date date, description text, transaction_id character varying, metadata jsonb, created_at timestamp without time zone

external_payment_logs

id integer, user_id character varying, platform character varying, amount character varying, sender_name character varying, sender_id character varying, description text, direction character varying, platform_fee character varying, created_at timestamp with time zone

external_payment_methods

id integer, user_id character varying, platform character varying, username character varying, display_name character varying, is_active boolean, created_at timestamp with time zone, updated_at timestamp with time zone

fan_consent_log

id uuid, user_id uuid, platform character varying, consent_type character varying, granted boolean, granted_at timestamp with time zone, revoked_at timestamp with time zone, ip_address character varying, user_agent text

fan_event_schedules

id uuid, fan_id uuid, event_name character varying, event_date date, performer_id uuid, performer_name character varying, booth_number character varying, priority integer, time_slot character varying, status character varying, notes text, created_at timestamp with time zone

fan_profiles

id uuid, user_id uuid, fan_id uuid, fan_username character varying, fan_display_name character varying, notes text, tier character varying, total_spent numeric, favorite_content text, communication_style text, boundaries text, last_interaction timestamp with time zone, is_private boolean, created_at timestamp with time zone, updated_at timestamp with time zone

fan_questions

id uuid, performer_id uuid, fan_id uuid, fan_display_name character varying, question text, answer text, is_paid boolean, amount_paid numeric, status character varying, is_public boolean, created_at timestamp with time zone, answered_at timestamp with time zone

fan_requests

id uuid, performer_id uuid, fan_id uuid, fan_name character varying, request_type character varying, description text, amount numeric, status character varying, source_table character varying, source_id uuid, priority character varying, expires_at timestamp with time zone, responded_at timestamp with time zone, created_at timestamp with time zone, updated_at timestamp with time zone

fan_tags

id uuid, user_id uuid, fan_id uuid, fan_username character varying, fan_display_name character varying, tag_type character varying, tag_value character varying, notes text, is_private boolean, created_at timestamp with time zone, updated_at timestamp with time zone

fee_splits

id uuid, booking_id uuid, transaction_id uuid, payer_id uuid, payee_id uuid, payee_type text, amount numeric, percentage numeric, description text, status text, stripe_transfer_id text, paid_at timestamp with time zone, created_at timestamp with time zone

feedback

id uuid, user_id uuid, feedback_type character varying, content text, rating integer, is_public boolean, is_featured boolean, related_content_id uuid, related_content_type character varying, admin_response text, created_at timestamp with time zone

file_duplicates

id uuid, user_id uuid, file_hash character varying, file_count integer, total_size bigint, status character varying, kept_file_id uuid, created_at timestamp with time zone

file_metadata

id uuid, file_id uuid, user_id uuid, date_taken timestamp with time zone, camera_model character varying, gps_lat numeric, gps_lng numeric, orientation integer, width integer, height integer, raw_exif jsonb, show_original_date boolean, created_at timestamp with time zone

file_versions

id uuid, file_id uuid, user_id uuid, version_number integer, file_url text, file_size bigint, file_hash character varying, change_type character varying, change_summary text, changed_by uuid, metadata jsonb, created_at timestamp with time zone

film_performer_earnings

id uuid, film_id uuid, user_id uuid, amount numeric, notes text, created_at timestamp with time zone, updated_at timestamp with time zone

film_performers

id uuid, film_id uuid, user_id uuid, performer_name text, role character varying, is_platform_user boolean, created_at timestamp with time zone, placeholder_id uuid, billing_order integer

film_tag_requests

id uuid, film_id uuid, tagged_user_id uuid, tagged_by_user_id uuid, performer_name text, role character varying, status character varying, created_at timestamp with time zone, responded_at timestamp with time zone

film_transactions

id uuid, film_id uuid, transaction_id uuid, match_confidence real, match_method character varying, created_at timestamp with time zone

films

id uuid, title text, studio text, release_date date, booking_date date, scene_tags text, url text, thumbnail_url text, duration_minutes integer, description text, source character varying, external_id text, metadata jsonb, created_at timestamp with time zone, updated_at timestamp with time zone, is_deleted boolean, completeness_score real, missing_fields ARRAY, needs_review boolean, closet_item_ids jsonb, has_closet_items boolean, is_favorite boolean, is_award_worthy boolean, award_nominations jsonb, awards_won jsonb, status character varying, photos jsonb, amount_earned numeric, affiliate_url text, affiliate_program character varying, buy_url text, cover_photo_url text, bts_photos jsonb, promo_post_ids jsonb, dvd_info jsonb, production_type text

financial_accounts

id uuid, user_id uuid, account_type character varying, account_name text, provider character varying, is_active boolean, metadata jsonb, created_at timestamp with time zone

findom_sessions

id uuid, performer_id uuid, payer_id uuid, session_type character varying, max_amount numeric, total_spent numeric, status character varying, created_at timestamp with time zone

findom_tributes

id uuid, to_user_id uuid, from_user character varying, amount numeric, message text, type character varying, created_at timestamp with time zone, performer_id uuid, payer_id uuid, is_anonymous boolean

fitness_workouts

id uuid, user_id uuid, title character varying, workout_type character varying, duration_minutes integer, calories_burned integer, notes text, exercises jsonb, is_favorite boolean, video_url text, created_at timestamp with time zone, scheduled_date date, status character varying

follows

follower_id uuid, followed_id uuid, created_at timestamp with time zone

form_submissions

id uuid, form_id uuid, responses jsonb, submitter_name character varying, submitter_email character varying, created_at timestamp with time zone

friend_requests

id uuid, from_user uuid, to_user uuid, status character varying, created_at timestamp with time zone

friends

id uuid, requester_id uuid, recipient_id uuid, status character varying, note character varying, created_at timestamp with time zone, accepted_at timestamp with time zone

friendships

id uuid, user_id uuid, friend_id uuid, status character varying, note character varying, created_at timestamp with time zone, updated_at timestamp with time zone

funded_scene_campaigns

id uuid, user_id uuid, title character varying, description text, goal_amount numeric, current_amount numeric, contributors integer, status character varying, days_left integer, created_at timestamp with time zone

funded_scene_requests

id uuid, customer_id uuid, studio_id uuid, title character varying, description text, performers_requested jsonb, supplies_needed jsonb, location_type character varying, location_fee numeric, performer_rates_total numeric, supplies_total numeric, platform_fee numeric, total_cost numeric, payment_method_id character varying, payment_intent_id character varying, deposit_amount numeric, deposit_paid boolean, deposit_paid_at timestamp with time zone, full_payment_status character varying, card_last_four character varying, card_brand character varying, card_authorized boolean, authorization_amount numeric, status character varying, studio_approved boolean, studio_approved_at timestamp with time zone, studio_notes text, performers_confirmed jsonb, customer_approved_quote boolean, customer_approved_at timestamp with time zone, content_delivered boolean, content_delivered_at timestamp with time zone, delivery_url text, customer_satisfied boolean, customer_rating integer, customer_id_verified boolean, customer_verification_id uuid, cancellation_policy text, cancellation_fee_percent numeric, created_at timestamp with time zone, updated_at timestamp with time zone

funded_scenes

id uuid, performer_id uuid, title character varying, description text, funding_goal numeric, current_funding numeric, scene_type character varying, revenue_model character varying, sponsor_revenue_pct numeric, ppv_price numeric, ppv_revenue numeric, ppv_sales_count integer, preview_photos jsonb, backer_count integer, status character varying, created_at timestamp with time zone, mood text, mood_notes text

fundraiser_donations

id uuid, fundraiser_id uuid, donor_id uuid, amount numeric, message text, is_anonymous boolean, created_at timestamp with time zone

fundraisers

id uuid, creator_id uuid, title character varying, description text, goal_amount numeric, raised_amount numeric, status character varying, reward_tiers jsonb, image_url text, created_at timestamp with time zone, ends_at timestamp with time zone, user_id uuid, current_amount numeric, category character varying, end_date timestamp with time zone, cover_image_url text, donor_count integer

game_achievements

id uuid, user_id uuid, achievement_id character varying, achievement_name character varying, achievement_desc text, category character varying, earned_at timestamp with time zone

game_profiles

id uuid, user_id uuid, character_name character varying, character_type character varying, character_look jsonb, level integer, stage character varying, xp integer, coins integer, properties jsonb, wardrobe jsonb, stats jsonb, created_at timestamp with time zone, updated_at timestamp with time zone

game_progress

id uuid, user_id uuid, stage_id character varying, stage_name character varying, completed boolean, score integer, unlocked_at timestamp with time zone, completed_at timestamp with time zone

game_sessions

id uuid, user_id uuid, session_type character varying, scenario jsonb, choices jsonb, outcome jsonb, xp_earned integer, coins_earned integer, started_at timestamp with time zone, ended_at timestamp with time zone

game_wishlist

id uuid, user_id uuid, game_name character varying, platform character varying, price_cents integer, store_url text, priority integer, gifted_by uuid, gifted_at timestamp with time zone, created_at timestamp with time zone

gaming_accounts

id integer, user_id text, platform text, username text, url text, created_at timestamp with time zone

gaming_library

id integer, user_id text, title text, platform text, genre text, hours_played integer, created_at timestamp with time zone

gaming_participants

id uuid, session_id uuid, user_id uuid, gamertag character varying, status character varying, created_at timestamp with time zone

gaming_passes

id integer, user_id text, pass_name text, platform text, expires_at timestamp with time zone, created_at timestamp with time zone

gaming_profiles

id uuid, user_id uuid, xbox_gamertag character varying, psn_id character varying, steam_id character varying, nintendo_friend_code character varying, epic_id character varying, twitch_username character varying, discord_username character varying, game_library jsonb, currently_playing jsonb, wishlist jsonb, session_rates jsonb, video_default character varying, total_sessions integer, total_gaming_earnings numeric, created_at timestamp with time zone, updated_at timestamp with time zone

gaming_sessions

id uuid, performer_id uuid, title character varying, game character varying, platform character varying, scheduled_at timestamp with time zone, duration_minutes integer, price_per_slot numeric, max_players integer, current_players integer, session_type character varying, description text, status character varying, created_at timestamp with time zone

gaming_subscriptions

id uuid, fan_id uuid, performer_id uuid, tier character varying, price_cents integer, hours_included numeric, hours_used numeric, video_preference character varying, status character varying, started_at timestamp with time zone, expires_at timestamp with time zone

gaming_wishlist

id integer, user_id text, title text, platform text, price numeric, url text, added_at timestamp with time zone

geo_blocks

id uuid, user_id uuid, block_type character varying, country character varying, state character varying, reason text, created_at timestamp with time zone

geo_rules

id uuid, user_id uuid, rule_type character varying, value character varying, action character varying, reason text, applies_to character varying, created_at timestamp with time zone

gift_cards

id uuid, user_id uuid, source character varying, amount numeric, remaining numeric, code character varying, from_email text, received_at timestamp with time zone, expires_at timestamp with time zone, is_redeemed boolean, metadata jsonb, created_at timestamp with time zone

health_logs

id uuid, user_id uuid, date date, log_type character varying, title character varying, value numeric, unit character varying, notes text, duration_minutes integer, created_at timestamp with time zone

holiday_discounts

id uuid, holiday_name character varying, discount_percent numeric, priority integer, start_rule jsonb, duration_days integer, days_before integer, display_message text, april_fools_mode boolean, real_discount_percent numeric, stacks_with_promo boolean, is_active boolean, created_at timestamp with time zone

house_content_sales

id uuid, user_id uuid, shift_id uuid, item_type character varying, price numeric, buyer_name character varying, created_at timestamp with time zone

house_costumes

id uuid, user_id uuid, name character varying, type character varying, condition character varying, cost numeric, created_at timestamp with time zone

house_schedule

id integer, user_id text, day_of_week integer, start_time text, end_time text, notes text, created_at timestamp with time zone

house_shifts

id uuid, user_id uuid, venue character varying, date date, start_time character varying, end_time character varying, hours_worked numeric, total_earned numeric, status character varying, created_at timestamp with time zone, club_id uuid, club_name character varying, shift_type character varying, clock_in timestamp with time zone, clock_out timestamp with time zone, total_cash_tips numeric, total_platform_tips numeric, total_content_sales numeric, gross_earnings numeric, house_fee numeric, dj_tipout numeric, bartender_tipout numeric, security_tipout numeric, total_deductions numeric, net_earnings numeric, notes text, mood text, mood_notes text, rate numeric, location character varying, title character varying

house_tip_outs

id uuid, shift_id uuid, user_id uuid, recipient character varying, amount numeric, date date, created_at timestamp with time zone

house_tips

id uuid, user_id uuid, amount numeric, tipper_name character varying, tip_type character varying, shift_id uuid, notes text, created_at timestamp with time zone

identity_verifications

id uuid, user_id uuid, status character varying, method character varying, provider character varying, document_type character varying, document_country character varying, document_hash character varying, legal_name character varying, date_of_birth date, age_at_verification integer, nationality character varying, is_2257_compliant boolean, records_custodian character varying, records_location text, verified_at timestamp with time zone, expires_at timestamp with time zone, external_verification_id character varying, rejection_reason text, metadata jsonb, created_at timestamp with time zone, updated_at timestamp with time zone

import_jobs

id uuid, user_id uuid, platform character varying, source_url text, content_types jsonb, status character varying, progress integer, items_imported integer, metadata jsonb, error text, created_at timestamp with time zone, completed_at timestamp with time zone

imported_earnings

id uuid, user_id uuid, import_id uuid, platform character varying, platform_transaction_id character varying, date timestamp with time zone, gross_amount numeric, net_amount numeric, fee numeric, type character varying, description text, from_user character varying, refunded boolean, raw_data jsonb, created_at timestamp with time zone

imported_fan_profiles

id uuid, user_id uuid, import_id uuid, platform character varying, platform_user_id character varying, platform_username character varying, join_date timestamp with time zone, shared_payment_method boolean, shared_message_history boolean, shared_spending_history boolean, total_spent numeric, subscription_count integer, status character varying, metadata jsonb, created_at timestamp with time zone

imported_messages

id uuid, user_id uuid, import_id uuid, platform character varying, platform_message_id character varying, date timestamp with time zone, has_price boolean, price numeric, tip_amount numeric, is_ppv boolean, message_length integer, raw_data jsonb, created_at timestamp with time zone

imported_payouts

id uuid, user_id uuid, import_id uuid, platform character varying, platform_payout_id character varying, date timestamp with time zone, amount numeric, status character varying, raw_data jsonb, created_at timestamp with time zone

imported_photos

id uuid, user_id uuid, source character varying, source_url text, local_url text, title character varying, description text, tags jsonb, linked_film_id uuid, album_id uuid, photo_type character varying, width integer, height integer, is_hd boolean, imported_at timestamp with time zone

imported_subscribers

id uuid, user_id uuid, import_id uuid, platform character varying, platform_subscriber_id character varying, subscriber_name character varying, subscribe_date timestamp with time zone, last_activity timestamp with time zone, expire_date timestamp with time zone, price numeric, auto_renew boolean, expired boolean, muted boolean, discount_percent integer, status character varying, raw_data jsonb, created_at timestamp with time zone

industry_contacts

id uuid, user_id uuid, name character varying, role character varying, company character varying, email character varying, phone character varying, social_handles jsonb, website character varying, notes text, rating integer, would_work_again boolean, tags ARRAY, first_worked date, last_worked date, times_worked integer, photo_url text, is_favorite boolean, is_deleted boolean, created_at timestamp with time zone, updated_at timestamp with time zone

industry_events

id uuid, name character varying, typical_month integer, typical_city character varying, category character varying, recurring boolean, url text, description text, created_at timestamp with time zone

item_requests

id uuid, item_id uuid, item_type character varying, requester_id uuid, performer_id uuid, message text, offered_price numeric, status character varying, created_at timestamp with time zone, scene_id uuid, scene_title text, item_description text, performer_response text, closet_item_id uuid, listing_url text, updated_at timestamp with time zone, counter_price numeric, final_price numeric, price_history jsonb, fan_response text

kanban_boards

id integer, user_id character varying, name character varying, description text, columns jsonb, sort_order integer, created_at timestamp with time zone

kanban_cards

id integer, board_id integer, user_id character varying, column_name character varying, title character varying, description text, priority character varying, due_date date, tags jsonb, assignee_id character varying, color character varying, sort_order integer, is_archived boolean, created_at timestamp with time zone, updated_at timestamp with time zone

legal_documents

id uuid, user_id uuid, name character varying, type character varying, status character varying, category character varying, expires date, signed boolean, created_at timestamp with time zone

life_bucket_list

id uuid, user_id uuid, title character varying, description text, category character varying, location character varying, estimated_cost numeric, is_completed boolean, completed_at timestamp with time zone, completion_photo_url text, priority character varying, target_year integer, notes text, created_at timestamp with time zone, updated_at timestamp with time zone, deleted_at timestamp with time zone

life_fitness

id uuid, user_id uuid, date date, activity_type character varying, duration_minutes integer, distance_miles numeric, steps integer, calories_burned integer, notes text, created_at timestamp with time zone, updated_at timestamp with time zone, deleted_at timestamp with time zone

life_goals

id uuid, user_id uuid, title character varying, description text, target_date date, category character varying, progress_pct integer, status character varying, created_at timestamp with time zone, updated_at timestamp with time zone, deleted_at timestamp with time zone, goal_type character varying

life_health

id uuid, user_id uuid, date date, weight_lbs numeric, height_inches numeric, notes text, custom_measurements jsonb, created_at timestamp with time zone, updated_at timestamp with time zone, deleted_at timestamp with time zone

life_journal

id uuid, user_id uuid, date date, entry_text text, mood integer, tags ARRAY, created_at timestamp with time zone, updated_at timestamp with time zone, deleted_at timestamp with time zone, journal_type character varying

life_meals

id uuid, user_id uuid, date date, meal_type character varying, description text, calories integer, restaurant_or_homemade character varying, photo_url text, created_at timestamp with time zone, updated_at timestamp with time zone, deleted_at timestamp with time zone

life_media

id uuid, user_id uuid, title character varying, media_type character varying, status character varying, rating numeric, started_at date, finished_at date, platform character varying, notes text, season integer, episode integer, created_at timestamp with time zone, updated_at timestamp with time zone, deleted_at timestamp with time zone, author character varying, pages integer, genre character varying, reading_status character varying, start_date date, finish_date date, isbn character varying

life_outfits

id uuid, user_id uuid, date date, outfit_description text, occasion character varying, weather character varying, temperature_f integer, photos jsonb, items_worn jsonb, rating integer, would_repeat boolean, color_palette ARRAY, style_tags ARRAY, notes text, created_at timestamp with time zone, updated_at timestamp with time zone, deleted_at timestamp with time zone

life_passwords

id uuid, user_id uuid, site_name character varying, url text, username character varying, encrypted_password text, notes text, category character varying, last_changed date, created_at timestamp with time zone, updated_at timestamp with time zone, deleted_at timestamp with time zone

life_period

id uuid, user_id uuid, cycle_start date, cycle_end date, flow_level character varying, symptoms ARRAY, mood character varying, temperature numeric, cervical_mucus character varying, medications ARRAY, notes text, created_at timestamp with time zone, updated_at timestamp with time zone, deleted_at timestamp with time zone

life_places

id uuid, user_id uuid, name character varying, address text, city character varying, state character varying, country character varying, visited_at date, category character varying, rating numeric, notes text, photo_url text, lat numeric, lng numeric, created_at timestamp with time zone, updated_at timestamp with time zone, deleted_at timestamp with time zone

life_receipts

id uuid, user_id uuid, store character varying, amount numeric, date date, category character varying, photo_url text, items jsonb, payment_method character varying, created_at timestamp with time zone, updated_at timestamp with time zone, deleted_at timestamp with time zone

life_skincare

id uuid, user_id uuid, date date, routine_type character varying, products_used jsonb, skin_condition character varying, skin_concerns ARRAY, new_breakouts boolean, selfie_url text, notes text, created_at timestamp with time zone, updated_at timestamp with time zone, deleted_at timestamp with time zone

life_sleep

id uuid, user_id uuid, date date, bedtime time without time zone, wake_time time without time zone, hours numeric, quality_rating integer, deep_sleep_hours numeric, rem_hours numeric, awakenings integer, sleep_aid character varying, dreams text, notes text, created_at timestamp with time zone, updated_at timestamp with time zone, deleted_at timestamp with time zone

life_vision_board

id uuid, user_id uuid, title character varying, description text, category character varying, image_url text, target_date date, is_achieved boolean, achieved_at timestamp with time zone, affirmation text, priority integer, sort_order integer, notes text, created_at timestamp with time zone, updated_at timestamp with time zone, deleted_at timestamp with time zone

life_water

id uuid, user_id uuid, date date, glasses integer, ml_total integer, target_glasses integer, target_ml integer, beverage_type character varying, notes text, created_at timestamp with time zone, updated_at timestamp with time zone, deleted_at timestamp with time zone

life_websites

id uuid, user_id uuid, url text, title character varying, category character varying, tags ARRAY, notes text, added_at timestamp with time zone, created_at timestamp with time zone, updated_at timestamp with time zone, deleted_at timestamp with time zone

linked_emails

id integer, user_id character varying, email character varying, is_primary boolean, created_at timestamp with time zone

location_shares

id uuid, user_id uuid, event_name character varying, event_id uuid, latitude numeric, longitude numeric, floor_level integer, venue_zone character varying, booth_number character varying, is_active boolean, privacy_level character varying, share_until timestamp with time zone, updated_at timestamp with time zone, created_at timestamp with time zone

loyalty_badges

id integer, user_id character varying, badge_type character varying, badge_name character varying, badge_desc text, tier character varying, reason text, awarded_by character varying, awarded_at timestamp with time zone

marketplace_listings

id uuid, seller_id uuid, title character varying, tab character varying, price numeric, category character varying, description text, image_url text, status character varying, views integer, rating numeric, created_at timestamp with time zone

mass_messages

id uuid, sender_id uuid, subject text, body text, media_urls jsonb, ppv_price integer, target_type character varying, target_tier character varying, target_list ARRAY, merge_tags jsonb, scheduled_for timestamp with time zone, sent_at timestamp with time zone, status character varying, recipients_count integer, opened_count integer, created_at timestamp with time zone

match_actions

id integer, user_id character varying, target_id character varying, action character varying, created_at timestamp with time zone

match_profiles

id integer, user_id character varying, bio text, looking_for jsonb, interests jsonb, location character varying, age_range_min integer, age_range_max integer, is_visible boolean, match_type character varying, updated_at timestamp with time zone

matches

id integer, user_id_1 character varying, user_id_2 character varying, matched_at timestamp with time zone

meal_plans

id uuid, user_id uuid, date date, meal_type character varying, recipe_id uuid, notes text, calories integer, created_at timestamp with time zone

media_assignments

id uuid, user_id uuid, media_id uuid, media_url text, assignment_type character varying, target_id uuid, created_at timestamp with time zone

media_downloads

id uuid, user_id uuid, source_url text, source_platform character varying, post_id uuid, local_path text, file_size bigint, mime_type character varying, status character varying, priority character varying, error text, attempts integer, created_at timestamp with time zone, completed_at timestamp with time zone

media_timeline

id uuid, user_id uuid, entry_type character varying, source character varying, file_url text, thumbnail_url text, title character varying, description text, shoot_id uuid, shoot_file_id uuid, request_id uuid, customer_id uuid, captured_at timestamp with time zone, tags ARRAY, album_ids ARRAY, metadata jsonb, created_at timestamp with time zone

media_usage_log

id uuid, user_id uuid, media_url text, context_type character varying, context_id uuid, use_as character varying, used_at timestamp with time zone

message_attachments

id uuid, message_id uuid, file_url text, file_type character varying, filename character varying, file_size bigint, thumbnail_url text, duration_seconds integer, is_downloadable boolean, source_platform character varying, created_at timestamp with time zone

messages

id uuid, conversation_id uuid, sender_id uuid, content text, media_url text, media_type character varying, is_ppv boolean, ppv_price numeric, is_read boolean, is_tip boolean, tip_amount numeric, created_at timestamp with time zone, source_platform character varying, source_id character varying, original_sent_at timestamp with time zone, imported_at timestamp with time zone, source_status character varying

mileage_log

id uuid, user_id uuid, date date, from_location character varying, to_location character varying, miles numeric, purpose character varying, deduction numeric, created_at timestamp with time zone

model_releases

id integer, producer_user_id text, performer_name text, performer_user_id text, performer_email text, date_of_birth date, id_document_path text, id_verified boolean, id_verified_at timestamp with time zone, release_status text, release_signed_at timestamp with time zone, release_document_path text, content_type text, scene_ids ARRAY, legal_name text, aka_names ARRAY, invitation_sent boolean, invitation_sent_at timestamp with time zone, notes text, created_at timestamp with time zone, updated_at timestamp with time zone, is_bilateral boolean, linked_release_id integer, producer_signed boolean, producer_signed_at timestamp with time zone, performer_signed boolean, performer_signed_at timestamp with time zone, fully_signed boolean, fully_signed_at timestamp with time zone

mood_entries

id uuid, user_id uuid, mood text, energy_level integer, notes text, context text, tags ARRAY, linked_booking_id uuid, linked_scene_id uuid, linked_shift_id uuid, location text, weather text, recorded_at timestamp with time zone, created_at timestamp with time zone, is_deleted boolean

moratorium_status

id integer, is_active boolean, message text, declared_date date, cleared_date date, source character varying, updated_by uuid, updated_at timestamp with time zone

music_playlists

id uuid, user_id uuid, name character varying, type character varying, venue character varying, date date, songs jsonb, created_at timestamp with time zone

music_tracks

id uuid, user_id uuid, title character varying, artist character varying, album character varying, category character varying, audio_url text, cover_art_url text, duration_seconds integer, is_explicit boolean, is_original boolean, price numeric, description text, play_count integer, created_at timestamp with time zone, updated_at timestamp with time zone

musicians_playlists

id uuid, user_id uuid, name character varying, description text, cover_art_url text, visibility character varying, track_ids jsonb, is_album boolean, price numeric, created_at timestamp with time zone

musicians_tracks

id uuid, user_id uuid, title character varying, track_type character varying, genre character varying, description text, audio_url text, cover_art_url text, duration_seconds integer, visibility character varying, download_price numeric, play_count integer, download_count integer, collaborators jsonb, tags jsonb, created_at timestamp with time zone, updated_at timestamp with time zone

news_articles

id uuid, title text, body text, excerpt text, category character varying, source_name character varying, source_url text, author_id uuid, is_anonymous boolean, is_published boolean, is_pinned boolean, created_at timestamp with time zone, updated_at timestamp with time zone

note_folders

id integer, user_id character varying, name character varying, parent_folder_id integer, color character varying, sort_order integer, created_at timestamp with time zone, category character varying, icon character varying

notes

id integer, user_id character varying, title character varying, content text, folder_id integer, parent_note_id integer, tags jsonb, contact_id character varying, note_type character varying, attachments jsonb, pinned boolean, is_deleted boolean, deleted_at timestamp with time zone, created_at timestamp with time zone, updated_at timestamp with time zone, category character varying, has_attachments boolean, source_page character varying, source_id character varying, is_sticky boolean

notification_action_log

id uuid, notification_id uuid, user_id uuid, action_type character varying, action_data jsonb, completed_at timestamp with time zone

notification_preferences

id uuid, user_id uuid, event_type character varying, email boolean, push boolean, sms boolean, in_app boolean, created_at timestamp with time zone

notifications

id uuid, user_id uuid, type character varying, title character varying, body text, data jsonb, is_read boolean, created_at timestamp with time zone, source_platform character varying, original_date timestamp with time zone, viewed_at timestamp with time zone, acknowledged_at timestamp with time zone, notion_page_id text, notion_last_synced_at timestamp with time zone

notion_mappings

id uuid, user_id uuid, notion_database_id character varying, notion_database_name character varying, platform_table character varying, sync_direction character varying, last_synced_at timestamp with time zone, record_count integer, status character varying, created_at timestamp with time zone

order_events

id uuid, user_id uuid, wishlist_item_id uuid, order_number character varying, event_type character varying, event_data jsonb, source character varying, email_id character varying, created_at timestamp with time zone

orders

id uuid, buyer_id uuid, seller_id uuid, product_id uuid, quantity integer, total numeric, status character varying, shipping_address jsonb, tracking_number character varying, created_at timestamp with time zone, updated_at timestamp with time zone, items jsonb, total_price numeric, shipping_option character varying, metadata jsonb

page_blocks

id uuid, page_id uuid, user_id uuid, feature character varying, block_title character varying, config jsonb, is_public boolean, sort_order integer, width character varying, created_at timestamp with time zone

partner_api_logs

id uuid, partner_id uuid, endpoint character varying, method character varying, status_code integer, user_id uuid, ip_address character varying, response_ms integer, created_at timestamp with time zone

partner_integrations

id uuid, partner_name character varying, partner_domain character varying, api_key character varying, api_secret_hash character varying, permissions ARRAY, plan character varying, monthly_requests integer, request_limit integer, status character varying, approved_at timestamp with time zone, contact_email character varying, contact_name character varying, webhook_url text, metadata jsonb, created_at timestamp with time zone

password_resets

id uuid, user_id uuid, token character varying, expires_at timestamp with time zone, used boolean, created_at timestamp with time zone

payment_link_events

id uuid, request_id uuid, event_type character varying, stripe_event_id character varying, stripe_payment_intent_id character varying, amount_cents integer, metadata jsonb, created_at timestamp with time zone

payment_methods

id uuid, user_id uuid, type character varying, provider character varying, last_four character varying, is_default boolean, created_at timestamp with time zone

payout_periods

id integer, user_id text, period_start date, period_end date, gross_amount numeric, platform_fee numeric, net_amount numeric, status text, rolled_over_from integer, rolled_over_amount numeric, payout_date date, payout_request_id integer, created_at timestamp with time zone

payout_requests

id uuid, user_id uuid, amount numeric, payout_method character varying, payout_details jsonb, status character varying, processed_at timestamp with time zone, transaction_id character varying, notes text, created_at timestamp with time zone, fee numeric, net_amount numeric, requested_at timestamp with time zone, completed_at timestamp with time zone

payout_settings

id integer, user_id text, schedule text, minimum_payout numeric, payout_method text, payout_details jsonb, created_at timestamp with time zone, updated_at timestamp with time zone

payout_transfers

id uuid, user_id uuid, amount numeric, currency character varying, stripe_transfer_id character varying, stripe_payout_id character varying, status character varying, description text, created_at timestamp with time zone, completed_at timestamp with time zone, failed_at timestamp with time zone, failure_reason text

performance_reviews

id uuid, user_id uuid, period_type character varying, period_start date, period_end date, earnings_total numeric, earnings_change_pct numeric, subscriber_count integer, subscriber_change integer, top_content text, top_source character varying, booking_count integer, message_count integer, highlights text, recommendations text, created_at timestamp with time zone

performer_balances

user_id uuid, available_balance numeric, pending_balance numeric, total_earned numeric, total_fees numeric, total_paid_out numeric, last_payout_at timestamp with time zone, updated_at timestamp with time zone

performer_discovery_attributes

user_id uuid, attributes jsonb, created_at timestamp with time zone, updated_at timestamp with time zone

performer_holiday_settings

id uuid, user_id uuid, holiday_id uuid, enabled boolean, custom_discount numeric, custom_message text, created_at timestamp with time zone

performer_ratings

id uuid, performer_id uuid, reviewer_id uuid, on_time numeric, professional numeric, friendly numeric, performance numeric, communication numeric, overall numeric, review_text text, booking_id uuid, created_at timestamp with time zone

performer_tags

id uuid, tagger_user_id uuid, tagged_user_id uuid, tagged_placeholder_id uuid, context_type character varying, context_id uuid, context_title character varying, role character varying, notes text, status character varying, created_at timestamp with time zone

phone_numbers

id uuid, user_id uuid, phone_number character varying, provider character varying, is_paid boolean, price_per_message numeric, price_per_month numeric, is_active boolean, created_at timestamp with time zone, is_verified boolean, verification_code character varying, verification_expires timestamp with time zone, verification_attempts integer, notify_messages boolean, notify_bookings boolean, notify_safety boolean, notify_earnings boolean, auto_read_on_reply boolean, include_link boolean, quiet_hours_start time without time zone, quiet_hours_end time without time zone, last_sms_sent timestamp with time zone

photo_albums

id uuid, user_id uuid, name character varying, photo_count integer, visibility character varying, category character varying, cover_url text, created_at timestamp with time zone

phrase_settings

id integer, user_id character varying, auto_tip_reply boolean, tip_reply_delay_seconds integer, detection_threshold integer, auto_detect_enabled boolean, updated_at timestamp with time zone, rotation_mode character varying

placeholder_accounts

id uuid, display_name character varying, stage_name character varying, twitter_handle character varying, instagram_handle character varying, known_email character varying, known_platforms jsonb, social_lookup_done boolean, social_lookup_results jsonb, invited_by uuid, invitation_sent boolean, invitation_sent_at timestamp with time zone, invitation_method character varying, invitation_count integer, claimed_by uuid, claimed_at timestamp with time zone, merged boolean, status character varying, metadata jsonb, created_at timestamp with time zone, updated_at timestamp with time zone

platform_connections

id uuid, user_id uuid, platform_name character varying, platform_key character varying, status character varying, access_token text, refresh_token text, token_expires_at timestamp with time zone, external_user_id character varying, external_username character varying, connected_at timestamp with time zone, last_sync_at timestamp with time zone, metadata jsonb, created_at timestamp with time zone, updated_at timestamp with time zone, account_label character varying, account_type character varying, is_default boolean, is_active boolean, profile_image_url text, follower_count integer, capabilities jsonb

platform_earnings

id integer, user_id uuid, earning_type character varying, amount numeric, currency character varying, earned_date date, description text, order_id integer, metadata jsonb, created_at timestamp without time zone

platform_imports

id uuid, user_id uuid, platform character varying, import_type character varying, file_name character varying, file_size_bytes bigint, status character varying, records_total integer, records_imported integer, records_skipped integer, records_failed integer, error_log jsonb, summary jsonb, started_at timestamp with time zone, completed_at timestamp with time zone, created_at timestamp with time zone

platform_relationships

id uuid, model_user_id uuid, fan_user_id uuid, platform character varying, relationship_type character varying, platform_model_id character varying, platform_fan_id character varying, original_subscribe_date timestamp with time zone, original_expire_date timestamp with time zone, original_price numeric, total_spent_on_model numeric, status character varying, reconnected_at timestamp with time zone, model_notified boolean, fan_notified boolean, metadata jsonb, created_at timestamp with time zone

platform_revenue

id uuid, period_start date, period_end date, total_gross numeric, total_platform_fees numeric, total_payouts numeric, transaction_count integer, breakdown jsonb, created_at timestamp with time zone, amount numeric, fee_type character varying, source_transaction_id uuid, performer_id uuid

platform_rules

id uuid, rule_type character varying, name character varying, config jsonb, enabled boolean, created_at timestamp with time zone, updated_at timestamp with time zone

platform_templates

id uuid, slug character varying, name character varying, description text, category character varying, inspired_by character varying, css_file character varying, preview_image character varying, preview_images jsonb, color_palette jsonb, typography jsonb, layout_config jsonb, default_pages jsonb, default_widgets jsonb, is_system boolean, is_dark_mode boolean, price numeric, creator_id uuid, sort_order integer, created_at timestamp with time zone, updated_at timestamp with time zone

platform_transactions

id uuid, seller_id uuid, buyer_id uuid, transaction_type character varying, description text, gross_amount numeric, platform_fee_pct numeric, platform_fee_amount numeric, seller_net numeric, reference_id uuid, reference_type character varying, status character varying, created_at timestamp with time zone, fee_model character varying, stripe_fee numeric, customer_total numeric

playlist_tracks

id uuid, playlist_id uuid, track_id uuid, position integer, created_at timestamp with time zone

playlists

id uuid, user_id uuid, name character varying, description text, is_public boolean, created_at timestamp with time zone

po_box_connections

id uuid, user_id uuid, provider character varying, po_box_address text, tracking_enabled boolean, api_key_encrypted text, created_at timestamp with time zone

political_comments

id uuid, post_id uuid, author_id uuid, body text, is_anonymous boolean, created_at timestamp with time zone

political_posts

id uuid, title text, body text, category character varying, author_id uuid, is_anonymous boolean, show_on_profile boolean, agree_count integer, discuss_count integer, share_count integer, is_removed boolean, removal_reason text, created_at timestamp with time zone, updated_at timestamp with time zone

political_reactions

id uuid, post_id uuid, user_id uuid, reaction character varying, created_at timestamp with time zone

poll_votes

id uuid, poll_id uuid, user_id uuid, option_index integer, created_at timestamp with time zone

polls

id uuid, user_id uuid, question text, options jsonb, post_id uuid, allow_multiple boolean, ends_at timestamp with time zone, total_votes integer, created_at timestamp with time zone

portfolio_items

id uuid, user_id uuid, title character varying, description text, media_url text, media_type character varying, category character varying, tags jsonb, is_featured boolean, sort_order integer, created_at timestamp with time zone, updated_at timestamp with time zone

portfolios

id uuid, user_id uuid, album_name character varying, category character varying, description text, photos jsonb, tags jsonb, photographer_credit character varying, shoot_date date, privacy character varying, view_count integer, created_at timestamp with time zone

post_edits

id uuid, post_id uuid, field_name character varying, old_value text, new_value text, edited_at timestamp with time zone

post_engagements

id uuid, post_id uuid, user_id uuid, type character varying, created_at timestamp with time zone

post_likes

user_id uuid, post_id uuid, created_at timestamp with time zone

post_update_alerts

id uuid, post_id uuid, user_id uuid, edit_id uuid, field_changed character varying, old_value text, new_value text, message text, is_read boolean, created_at timestamp with time zone

posting_triggers

id uuid, user_id uuid, album_id uuid, name character varying, conditions jsonb, logic character varying, action character varying, is_active boolean, last_triggered_at timestamp with time zone, created_at timestamp with time zone

posts

id uuid, user_id uuid, content text, post_type character varying, media_urls jsonb, visibility character varying, is_pinned boolean, is_ppv boolean, ppv_price numeric, likes_count integer, comments_count integer, tips_total numeric, repost_of uuid, created_at timestamp with time zone, updated_at timestamp with time zone, source_platform character varying, source_url text, source_id character varying, original_posted_at timestamp with time zone, imported_at timestamp with time zone, is_hidden boolean, hidden_at timestamp with time zone, media_preserved boolean, local_media_path text, source_status character varying, is_archived boolean, tags jsonb, category character varying, content_type character varying, status character varying, scheduled_at timestamp with time zone, draft_saved_at timestamp with time zone, metadata jsonb, is_deleted boolean, media_layout character varying, album_id uuid, taken_dates jsonb, drip_interval integer, timed_duration integer

ppv_content

id uuid, post_id uuid, user_id uuid, price_credits integer, price_cents integer, free_for_tier character varying, preview_url text, unlock_count integer, revenue_cents integer, created_at timestamp with time zone

ppv_unlocks

id uuid, ppv_id uuid, user_id uuid, method character varying, amount integer, unlocked_at timestamp with time zone

presenters

id uuid, user_id uuid, name character varying, type character varying, specialties ARRAY, rate numeric, rate_unit character varying, bio text, availability character varying, rating numeric, events_hosted integer, languages ARRAY, created_at timestamp with time zone

preservation_jobs

id uuid, user_id uuid, platform character varying, job_type character varying, status character varying, progress integer, content_targets jsonb, priority character varying, items_processed integer, items_total integer, error text, metadata jsonb, created_at timestamp with time zone, completed_at timestamp with time zone

press_releases

id uuid, author_id uuid, performer_id uuid, publicist_id uuid, studio_id uuid, title character varying, content text, status character varying, source_type character varying, source_id uuid, auto_generated boolean, published_at timestamp with time zone, created_at timestamp with time zone, updated_at timestamp with time zone

pricing_bundles

id uuid, user_id uuid, name character varying, price numeric, description text, includes ARRAY, popular boolean, created_at timestamp with time zone

pricing_rates

id uuid, user_id uuid, service character varying, price numeric, duration character varying, description text, created_at timestamp with time zone

products

id uuid, seller_id uuid, name character varying, description text, product_type character varying, price numeric, sale_price numeric, images jsonb, category character varying, tags jsonb, stock_quantity integer, is_active boolean, is_featured boolean, shipping_required boolean, discreet_shipping boolean, created_at timestamp with time zone, updated_at timestamp with time zone, status character varying, digital_file_url text, is_digital boolean, stock_count integer, sold_count integer, closet_item_id uuid, scene_transaction_ids jsonb

profile_articles

id uuid, user_id uuid, category character varying, title character varying, url text, source_name character varying, source_logo_url text, published_date date, excerpt text, image_url text, is_auto_discovered boolean, is_hidden boolean, created_at timestamp with time zone

promo_codes

id uuid, creator_id uuid, code character varying, discount_type character varying, discount_value numeric, max_uses integer, used_count integer, valid_from timestamp with time zone, valid_until timestamp with time zone, is_active boolean, created_at timestamp with time zone, min_order_amount numeric, applicable_services jsonb, stackable boolean, description text, expires_at timestamp with time zone, status character varying

proximity_alerts

id uuid, fan_id uuid, performer_id uuid, alert_radius_meters integer, is_active boolean, last_triggered_at timestamp with time zone, created_at timestamp with time zone

public_profile_data

id uuid, user_id uuid, source character varying, source_url text, bio_text text, birth_date date, birth_place character varying, career_start character varying, awards jsonb, filmography_count integer, images jsonb, raw_data jsonb, last_fetched timestamp with time zone, created_at timestamp with time zone

publicist_engagements

id uuid, publicist_id uuid, user_id uuid, engagement_type character varying, title character varying, description text, date date, outlet character varying, url text, fee numeric, transaction_id uuid, feed_post_ids jsonb, photo_ids jsonb, video_ids jsonb, notes text, created_at timestamp with time zone

publicists

id uuid, user_id uuid, name character varying, company character varying, email character varying, phone character varying, website character varying, social_handles jsonb, services ARRAY, monthly_fee numeric, per_service_fee numeric, contract_url text, notes text, status character varying, is_deleted boolean, created_at timestamp with time zone, updated_at timestamp with time zone

push_notification_config

id uuid, user_id uuid, enabled boolean, morning_push boolean, morning_push_time time without time zone, earnings_alerts boolean, booking_alerts boolean, message_alerts boolean, weekly_recap boolean, weekly_recap_day integer, push_token text, push_provider character varying, timezone character varying, created_at timestamp with time zone

push_queue

id uuid, user_id uuid, title character varying, body text, type character varying, data jsonb, scheduled_for timestamp with time zone, sent_at timestamp with time zone, status character varying, created_at timestamp with time zone

raids

id integer, raider_id character varying, target_id character varying, source_room_id integer, viewer_count integer, message text, status character varying, accepted_at timestamp with time zone, created_at timestamp with time zone

recipes

id uuid, user_id uuid, title character varying, description text, cover_image text, prep_time integer, cook_time integer, servings integer, ingredients jsonb, instructions jsonb, nutrition jsonb, tags ARRAY, source_url text, source_name character varying, is_favorite boolean, collection character varying, created_at timestamp with time zone, photo_url text, nutrition_data jsonb, is_imported boolean

records_2257

id uuid, user_id uuid, performer_name character varying, id_type character varying, upload_date date, status character varying, verified_by character varying, expires date, created_at timestamp with time zone

recurring_transactions

id uuid, user_id uuid, name text, amount numeric, frequency text, category text, merchant text, next_date date, last_date date, account_source text, is_active boolean, notify_before text, notify_hours_before integer, notes text, is_deleted boolean, created_at timestamp with time zone, source character varying

reel_comments

id integer, reel_id integer, user_id character varying, text text, reply_to integer, created_at timestamp with time zone

reel_likes

id integer, reel_id integer, user_id character varying, created_at timestamp with time zone

reels

id integer, user_id character varying, video_url text, thumbnail_url text, caption text, tags jsonb, duration double precision, audio_id integer, visibility character varying, allow_duets boolean, allow_stitches boolean, reel_type character varying, original_reel_id integer, view_count integer, share_count integer, is_deleted boolean, metadata jsonb, created_at timestamp with time zone

referrals

id uuid, referrer_id uuid, referred_id uuid, code character varying, commission_earned numeric, status character varying, created_at timestamp with time zone, tier integer, reward_earned numeric, reward_paid boolean, updated_at timestamp with time zone

reports

id uuid, user_id uuid, report_type character varying, title character varying, description text, severity character varying, status character varying, admin_notes text, screenshot_url text, page_url character varying, browser_info text, assigned_to uuid, resolved_at timestamp with time zone, created_at timestamp with time zone, updated_at timestamp with time zone

resolved_handles

id uuid, name character varying, platform character varying, handle character varying, profile_url text, confidence character varying, source character varying, verified boolean, resolved_at timestamp with time zone, created_at timestamp with time zone

ride_tracking

id uuid, user_id uuid, service character varying, pickup character varying, destination character varying, driver_info text, shared_with text, created_at timestamp with time zone, status character varying

rider_requirements

id uuid, user_id uuid, item character varying, category character varying, priority character varying, met boolean, notes text, created_at timestamp with time zone

riders

id uuid, user_id uuid, travel jsonb, accommodation jsonb, on_set jsonb, rates jsonb, boundaries jsonb, special_requests text, created_at timestamp with time zone, updated_at timestamp with time zone

safety_alerts

id uuid, user_id uuid, alert_type character varying, location_label character varying, notes text, contacts_notified integer, created_at timestamp with time zone, status character varying

safety_check_ins

id uuid, user_id uuid, location character varying, status character varying, notes text, latitude numeric, longitude numeric, created_at timestamp with time zone, checkin_type character varying

safety_checkins

id uuid, user_id uuid, booking_id uuid, check_in_type character varying, expected_duration_minutes integer, location_label character varying, status character varying, check_in_at timestamp with time zone, check_out_at timestamp with time zone, created_at timestamp with time zone

safety_geo_block

user_id text, blocked_states jsonb, blocked_countries jsonb, updated_at timestamp with time zone

safety_incidents

id uuid, user_id uuid, type character varying, description text, severity character varying, location character varying, created_at timestamp with time zone, status character varying, metadata jsonb

safety_reports

id uuid, reporter_id uuid, reported_user_id uuid, report_type character varying, description text, evidence_urls jsonb, severity character varying, status character varying, admin_notes text, action_taken text, counter_notice text, counter_evidence jsonb, counter_filed_by uuid, counter_filed_at timestamp with time zone, resolved_at timestamp with time zone, created_at timestamp with time zone

safety_scores

id uuid, user_id uuid, score integer, components jsonb, incidents integer, check_ins integer, last_updated timestamp with time zone

safety_watermark

user_id text, enabled boolean, watermark_text text, updated_at timestamp with time zone

saved_sounds

id integer, user_id character varying, sound_id integer, created_at timestamp with time zone

scene_contacts

id uuid, contact_id uuid, transaction_id uuid, film_id uuid, role_in_scene character varying, notes text, created_at timestamp with time zone

scene_funding

id uuid, scene_id uuid, funder_id uuid, amount numeric, note text, status character varying, created_at timestamp with time zone

scene_promos

id uuid, user_id uuid, film_id uuid, post_id uuid, platform character varying, promo_type character varying, content text, photos jsonb, affiliate_url text, affiliate_clicks integer, affiliate_earnings numeric, created_at timestamp with time zone

scenes

id uuid, performer_id uuid, title character varying, studio_id uuid, studio_name character varying, director character varying, director_id uuid, producer character varying, scene_type character varying, release_date date, duration_minutes integer, description text, tags jsonb, co_stars jsonb, location character varying, rating numeric, thumbnail_url text, video_url text, rate numeric, agent_fee numeric, travel_cost numeric, net_earning numeric, created_at timestamp with time zone, production_type text, payment_confirmed boolean, payment_confirmed_at timestamp with time zone, payment_amount numeric

scheduled_posts

id uuid, user_id uuid, content text, media_urls ARRAY, platforms ARRAY, scheduled_for timestamp with time zone, status character varying, published_results jsonb, ai_generated boolean, hashtags ARRAY, created_at timestamp with time zone

scraped_events

id uuid, name character varying, category character varying, location character varying, event_date timestamp with time zone, source_url text, description text, organizer character varying, created_at timestamp with time zone

screenshot_imports

id uuid, user_id uuid, image_urls jsonb, platform character varying, extract_type character varying, status character varying, ai_prompt text, extracted_data jsonb, transactions_created integer, error_message text, created_at timestamp with time zone, completed_at timestamp with time zone, is_deleted boolean

server_lifecycle

id integer, event_type text, version text, uptime_seconds integer, route_count integer, memory_mb integer, reason text, metadata jsonb, created_at timestamp with time zone

sessions

id uuid, user_id uuid, token character varying, ip_address character varying, user_agent text, created_at timestamp with time zone, expires_at timestamp with time zone, last_active timestamp with time zone

social_accounts

id uuid, user_id uuid, platform character varying, handle character varying, followers integer, connected boolean, access_token text, refresh_token text, last_sync timestamp with time zone, engagement_rate numeric, created_at timestamp with time zone, account_status character varying, closure_date timestamp with time zone, closure_reason character varying, auto_preserve boolean, settings jsonb, last_health_check timestamp with time zone, status character varying

social_connections

id uuid, user_id uuid, platform character varying, platform_user_id character varying, platform_username character varying, access_token text, refresh_token text, token_expires_at timestamp with time zone, scopes ARRAY, status character varying, last_sync_at timestamp with time zone, sync_config jsonb, metadata jsonb, connected_at timestamp with time zone, created_at timestamp with time zone

social_post_queue

id uuid, user_id uuid, platform character varying, action_type character varying, content text, source_post_url text, source_post_id character varying, media_urls jsonb, tagged_performers jsonb, quote_text text, queue_position integer, status character varying, scheduled_at timestamp with time zone, published_at timestamp with time zone, metadata jsonb, created_at timestamp with time zone

sounds

id integer, creator_id character varying, title character varying, artist character varying, audio_url text, duration double precision, category character varying, clip_start double precision, clip_end double precision, use_count integer, is_active boolean, created_at timestamp with time zone

special_accounts

id uuid, user_id uuid, account_type character varying, name character varying, bio text, specialties ARRAY, rate numeric, rate_unit character varying, platform_fee numeric, metadata jsonb, created_at timestamp with time zone

spending_badges

id uuid, spender_id uuid, performer_id uuid, total_spent_cents integer, tip_count integer, rank_on_profile integer, last_transaction_at timestamp with time zone, updated_at timestamp with time zone

spending_visibility

id uuid, user_id uuid, role character varying, show_on_profiles boolean, show_amounts boolean, show_name boolean, incognito_label character varying, show_rank boolean, min_rank_to_show integer, created_at timestamp with time zone

staging_changes

id uuid, user_id uuid, change_type character varying, file_path character varying, description text, diff_summary text, status character varying, created_at timestamp with time zone, promoted_at timestamp with time zone, rolled_back_at timestamp with time zone

staging_snapshots

id uuid, created_by uuid, label character varying, snapshot_data jsonb, created_at timestamp with time zone

stories

id integer, user_id character varying, media_url text, media_type character varying, caption text, background_color character varying, text_overlay text, font_style character varying, sticker_data jsonb, poll_data jsonb, question_data jsonb, visibility character varying, expires_at timestamp with time zone, is_deleted boolean, created_at timestamp with time zone, reposted_from integer, is_hidden boolean, view_count integer, metadata jsonb

story_highlights

id integer, user_id character varying, story_id integer, highlight_name character varying, created_at timestamp with time zone

story_reactions

id integer, story_id integer, user_id character varying, reaction character varying, message text, created_at timestamp with time zone

story_views

id integer, story_id integer, viewer_id character varying, viewed_at timestamp with time zone

strip_club_appearances

id uuid, user_id uuid, club_id uuid, appearance_date date, appearance_type character varying, guaranteed_amount numeric, actual_earned numeric, house_fee_paid numeric, tips_earned numeric, income_transaction_id uuid, expense_transaction_id uuid, travel_expense_id uuid, contract_url text, contract_id uuid, booking_request_id uuid, feed_post_ids jsonb, photo_ids jsonb, video_ids jsonb, notes text, created_at timestamp with time zone

strip_clubs

id uuid, name character varying, city character varying, state character varying, address text, phone character varying, email character varying, website character varying, contact_person character varying, booking_contact character varying, social_handles jsonb, house_fee numeric, tip_split_pct numeric, notes text, rating integer, is_deleted boolean, created_at timestamp with time zone, updated_at timestamp with time zone

studio_parent_companies

id uuid, studio_name character varying, parent_company character varying, bank_pattern character varying, company_type character varying, studios_owned ARRAY, ein character varying, website character varying, notes text, added_by uuid, verified boolean, created_at timestamp with time zone, updated_at timestamp with time zone

studio_roster

id uuid, studio_user_id uuid, performer_user_id uuid, performer_placeholder_id uuid, performer_name character varying, role character varying, status character varying, contract_start date, contract_end date, commission_rate numeric, notes text, metadata jsonb, created_at timestamp with time zone, updated_at timestamp with time zone

subscription_configs

id uuid, user_id uuid, tiers jsonb, free_messages_per_month jsonb, subscriber_messaging_discount integer, created_at timestamp with time zone, updated_at timestamp with time zone

subscription_tiers

id uuid, performer_id uuid, name character varying, price_cents integer, credits_included integer, free_ppv_per_month integer, custom_request_discount integer, perks jsonb, sort_order integer, is_active boolean, created_at timestamp with time zone

subscriptions

id uuid, subscriber_id uuid, creator_id uuid, tier character varying, price numeric, status character varying, stripe_subscription_id character varying, started_at timestamp with time zone, expires_at timestamp with time zone, cancelled_at timestamp with time zone, auto_renew boolean

support_tickets

id uuid, ticket_number integer, user_id uuid, contact_email character varying, contact_name character varying, category character varying, subject character varying, description text, priority character varying, status character varying, assigned_to character varying, resolution text, resolved_at timestamp with time zone, tags jsonb, attachments jsonb, first_response_at timestamp with time zone, last_activity_at timestamp with time zone, auto_close_at timestamp with time zone, metadata jsonb, created_at timestamp with time zone, updated_at timestamp with time zone

sync_history

id uuid, user_id uuid, sync_type character varying, source character varying, status character varying, stats jsonb, details text, started_at timestamp with time zone, completed_at timestamp with time zone, duration_ms integer

system_events

id uuid, event_type character varying, severity character varying, title character varying, details text, source character varying, related_user_id uuid, related_entity_id character varying, auto_resolved boolean, resolved_at timestamp with time zone, resolved_by character varying, resolution_notes text, notion_synced boolean, created_at timestamp with time zone, notion_page_id text

tax_1099s

id uuid, user_id uuid, payer_name character varying, payer_ein character varying, form_type character varying, tax_year integer, amount numeric, account_type character varying, platform character varying, notes text, created_at timestamp with time zone

tax_reports

id uuid, user_id uuid, year integer, gross_income numeric, total_deductions numeric, taxable_income numeric, estimated_tax numeric, self_employment_tax numeric, quarterly_payment numeric, by_source jsonb, deductions jsonb, forms_1099 jsonb, status character varying, generated_at timestamp with time zone

tax_transactions

id uuid, user_id uuid, transaction_date date, description text, amount numeric, transaction_type character varying, account_name character varying, account_type character varying, category character varying, platform_source character varying, is_income boolean, notes text, created_at timestamp with time zone, from_user character varying

team_members

id uuid, manager_id uuid, member_id uuid, role character varying, commission_pct numeric, status character varying, created_at timestamp with time zone

template_purchases

id uuid, template_id uuid, buyer_id uuid, seller_id uuid, price_cents integer, purchased_at timestamp with time zone

template_ratings

id uuid, template_id uuid, user_id uuid, rating integer, review text, created_at timestamp with time zone

template_widgets

id uuid, widget_type character varying, name character varying, description text, source_page character varying, default_config jsonb, default_size jsonb, min_size jsonb, category character varying, icon character varying, created_at timestamp with time zone

templates

id uuid, creator_id uuid, name character varying, description text, preview_url text, template_data jsonb, price numeric, is_free boolean, downloads integer, category character varying, tags jsonb, created_at timestamp with time zone, slug character varying, inspiration_source character varying, is_inspired boolean, is_admin_template boolean, gallery_style character varying, nav_style character varying, layout_style character varying, is_dark boolean, install_count integer, rating_avg numeric, rating_count integer, is_published boolean, updated_at timestamp with time zone, use_case character varying

test_signup_links

id uuid, token character varying, created_by uuid, label character varying, role_type character varying, tester_group character varying, max_uses integer, used_count integer, expires_at timestamp with time zone, created_at timestamp with time zone

testing_records

id uuid, user_id uuid, provider character varying, test_date date, expires_at date, results character varying, status character varying, verification_code character varying, shared boolean, created_at timestamp with time zone

ticket_messages

id uuid, ticket_id uuid, sender_type character varying, sender_id uuid, sender_name character varying, message text, attachments jsonb, is_internal boolean, created_at timestamp with time zone

tip_menu_items

id uuid, user_id uuid, amount_credits integer, label character varying, description text, emoji character varying, reward_type character varying, reward_content text, sort_order integer, is_active boolean, times_purchased integer, created_at timestamp with time zone

tip_songs

id uuid, user_id uuid, title character varying, artist character varying, min_tip numeric, play_count integer, active boolean, created_at timestamp with time zone

tips

id integer, sender_id character varying, recipient_id character varying, amount numeric, net_amount numeric, message text, acknowledged_at timestamp with time zone, created_at timestamp with time zone

tos_acceptances

id uuid, user_id uuid, tos_version character varying, accepted_at timestamp with time zone, ip_address character varying, user_agent text

transaction_entities

id uuid, owner_id uuid, entity_name character varying, entity_type character varying, relationship character varying, email character varying, phone character varying, linked_user_id uuid, platform_profile_url character varying, wishlist_url character varying, social_urls jsonb, custom_category character varying, notes text, is_invitable boolean, invite_token character varying, invite_sent timestamp with time zone, invite_accepted timestamp with time zone, metadata jsonb, created_at timestamp with time zone, updated_at timestamp with time zone

transaction_links

id uuid, transaction_a uuid, transaction_b uuid, link_type character varying, match_confidence real, match_reason text, created_at timestamp with time zone

transaction_sender_links

id uuid, user_id uuid, sender_name character varying, bank character varying, linked_user_id uuid, linked_customer_id uuid, linked_entity_type character varying, linked_entity_name character varying, confidence character varying, transaction_count integer, total_amount numeric, first_seen date, last_seen date, notes text, created_at timestamp with time zone, updated_at timestamp with time zone

transactions

id uuid, user_id uuid, type character varying, amount numeric, fee numeric, net_amount numeric, status character varying, description text, stripe_payment_id character varying, metadata jsonb, created_at timestamp with time zone, is_deductible boolean, deduction_category character varying, category character varying, date timestamp with time zone, merchant character varying, notes text, source character varying, is_deleted boolean, transaction_date timestamp with time zone, is_tax_deductible boolean, from_user uuid, coworker text, director text, scene_tags text, linked_transaction_id uuid, is_linked boolean, source_account_id uuid, is_transfer boolean, transfer_pair_id uuid, dedup_hash text, completeness_score real, missing_fields ARRAY, needs_review boolean, updated_at timestamp with time zone, studio character varying, agent_name character varying, closet_item_ids jsonb, platform_fee numeric, stripe_fee numeric, stripe_charge_id character varying, from_user_id character varying, customer_total numeric, customer_stripe_fee numeric, data_source character varying, payout_status character varying, is_test_data boolean, production_type text

transcript_settings

id integer, user_id character varying, auto_save_watched boolean, auto_save_bookmarked boolean, auto_save_messages boolean, auto_save_orders boolean, updated_at timestamp with time zone

transcripts

id integer, user_id character varying, video_url text, source_type character varying, source_id integer, title character varying, caption_id integer, transcript_text text, segments jsonb, thumbnail_url text, duration double precision, creator_name character varying, creator_id character varying, folder character varying, tags jsonb, notes text, is_pinned boolean, auto_saved boolean, created_at timestamp with time zone, updated_at timestamp with time zone

trash_bin

id uuid, user_id uuid, original_table character varying, original_id uuid, original_data jsonb, deleted_at timestamp with time zone, deleted_by uuid, restore_until timestamp with time zone, permanently_deleted boolean

travel_checkpoints

id uuid, trip_id uuid, user_id uuid, label character varying, checkpoint_type character varying, expected_time timestamp with time zone, location_trigger text, buffer_minutes integer, sequence_order integer, status character varying, completed_at timestamp with time zone, notes text, latitude numeric, longitude numeric, created_at timestamp with time zone

travel_trips

id uuid, user_id uuid, name character varying, booking_id uuid, departure_time timestamp with time zone, arrival_time timestamp with time zone, flight_number character varying, airline character varying, hotel_name character varying, hotel_address text, event_name character varying, event_venue text, notify_agent boolean, agent_id uuid, notify_contacts boolean, buffer_minutes integer, status character varying, created_at timestamp with time zone, updated_at timestamp with time zone

universal_favorites

id uuid, user_id uuid, content_type character varying, content_id uuid, external_url text, title text, description text, image_url text, price numeric, source_page character varying, metadata jsonb, created_at timestamp with time zone

used_item_orders

id uuid, item_id uuid, buyer_id uuid, seller_id uuid, addons_selected jsonb, subtotal numeric, shipping_cost numeric, platform_fee numeric, total numeric, payment_intent_id character varying, status character varying, tracking_number character varying, shipped_at timestamp with time zone, delivered_at timestamp with time zone, buyer_review text, buyer_rating integer, created_at timestamp with time zone

used_items

id uuid, seller_id uuid, category character varying, title character varying, description text, brand character varying, size character varying, color character varying, condition character varying, wear_duration character varying, wear_activity character varying, base_price numeric, addons jsonb, photos jsonb, shipping_domestic numeric, shipping_international numeric, discreet_packaging boolean, accepts_custom_requests boolean, status character varying, total_sales integer, avg_rating numeric, created_at timestamp with time zone, updated_at timestamp with time zone, closet_item_id uuid, scene_transaction_ids jsonb, feed_post_ids jsonb, original_purchase_price numeric, purchase_date date, sold_price numeric, sold_at timestamp with time zone

user_achievements

id uuid, user_id uuid, achievement_id uuid, progress integer, unlocked_at timestamp with time zone

user_activity

id uuid, user_id uuid, session_start timestamp with time zone, last_heartbeat timestamp with time zone, messages_sent integer, posts_created integer, retweets integer, total_seconds integer, date date

user_activity_log

id uuid, user_id uuid, activity_type text, ip_address text, user_agent text, created_at timestamp with time zone

user_aliases

id uuid, user_id uuid, platform character varying, alias_username character varying, is_verified boolean, added_at timestamp with time zone

user_blocks

id uuid, blocker_id uuid, blocked_id uuid, reason character varying, created_at timestamp with time zone

user_businesses

id uuid, user_id uuid, business_name character varying, business_type character varying, location text, website character varying, phone character varying, description text, services jsonb, photos jsonb, allow_booking boolean, display_on_profile boolean, created_at timestamp with time zone

user_credits

id uuid, user_id uuid, balance integer, lifetime_purchased integer, lifetime_spent integer, last_purchase_at timestamp with time zone, updated_at timestamp with time zone, promotional_balance numeric, purchased_balance numeric

user_domains

id uuid, user_id uuid, domain text, brand_name text, is_verified boolean, ssl_status text, created_at timestamp with time zone

user_gifs

id uuid, user_id uuid, filename character varying, filepath text, duration numeric, width integer, assignment_type character varying, created_at timestamp with time zone

user_layouts

id uuid, user_id uuid, page_name character varying, layout_preset character varying, custom_config jsonb, updated_at timestamp with time zone

user_pages

id uuid, user_id uuid, page_id character varying, display_name character varying, is_visible boolean, parent_id character varying, sort_order integer, created_at timestamp with time zone, updated_at timestamp with time zone

user_photos

id uuid, user_id uuid, url text, caption text, source_name text, source_url text, original_title text, width integer, height integer, tags ARRAY, is_showcase boolean, is_gallery boolean, sort_order integer, discovered_via text, created_at timestamp with time zone

user_profiles

user_id uuid, bio text, tagline character varying, pronouns character varying, website character varying, instagram character varying, twitter character varying, tiktok character varying, onlyfans character varying, fansly character varying, phone character varying, address text, city character varying, state character varying, zip_code character varying, country character varying, profile_views integer, total_earnings numeric, metadata jsonb, updated_at timestamp without time zone

user_services

id uuid, user_id uuid, name character varying, type character varying, duration character varying, price numeric, description text, status character varying, created_at timestamp with time zone, updated_at timestamp with time zone

user_settings

id uuid, user_id uuid, key character varying, value text, created_at timestamp with time zone, watermark_enabled boolean, watermark_text character varying, watermark_position character varying, watermark_opacity numeric

user_template_state

id uuid, user_id uuid, template_id uuid, is_active boolean, custom_pages jsonb, custom_widgets jsonb, custom_css_overrides jsonb, custom_layout jsonb, last_applied_at timestamp with time zone, created_at timestamp with time zone, updated_at timestamp with time zone

user_template_undo

id uuid, user_id uuid, template_id uuid, previous_state jsonb, action character varying, created_at timestamp with time zone

user_url_mappings

id integer, user_id uuid, username character varying, custom_domain character varying, subdomain character varying, created_at timestamp without time zone, updated_at timestamp without time zone, url_type character varying, is_default boolean

user_verifications

id uuid, user_id uuid, role_type character varying, verification_level character varying, id_document_hash text, id_document_type character varying, id_verified_at timestamp with time zone, id_verified_by character varying, email_verified boolean, phone_verified boolean, payment_method_verified boolean, social_accounts jsonb, total_spent numeric, total_tips numeric, completed_purchases integer, cancelled_purchases integer, disputes_filed integer, disputes_lost integer, reports_received integer, reports_upheld integer, is_top_spender boolean, is_trusted_customer boolean, trust_score numeric, badges jsonb, member_since timestamp with time zone, last_active timestamp with time zone, created_at timestamp with time zone, updated_at timestamp with time zone

username_history

id uuid, user_id uuid, old_username character varying, new_username character varying, changed_at timestamp with time zone, platform character varying

users

id uuid, username character varying, email character varying, password_hash text, display_name character varying, avatar_url text, bio text, role character varying, subscription_tier character varying, verified boolean, birthday date, location character varying, website character varying, created_at timestamp with time zone, updated_at timestamp with time zone, last_login timestamp with time zone, is_active boolean, is_banned boolean, two_factor_enabled boolean, privacy_settings jsonb, notification_preferences jsonb, template_id uuid, settings jsonb, profile_nav jsonb, social_links jsonb, hero_image text, tagline character varying, profile_sections jsonb, layout_overrides jsonb, credits_balance numeric, payout_balance numeric, total_earned numeric, total_platform_fees numeric, safety_score integer, showcase_photos jsonb, oauth_provider character varying, oauth_provider_id character varying, oauth_data jsonb, cashapp_handle character varying, venmo_handle character varying, paypal_email character varying, user_type character varying, stripe_connect_id character varying, stripe_connect_type character varying, stripe_onboarding_complete boolean, stripe_payouts_enabled boolean, stripe_charges_enabled boolean, identity_verified boolean, identity_verified_at timestamp with time zone, verification_provider character varying, is_2257_compliant boolean, auth_method character varying, message_rate_text numeric, message_rate_photo numeric, message_rate_video numeric, video_call_rate numeric, roles ARRAY, is_tester boolean, tester_since timestamp with time zone, tester_group character varying, presence_mode character varying, booking_status character varying, vanity_slug character varying, profile_mode character varying, deleted_at timestamp with time zone, id_document_path character varying, id_verified boolean, id_uploaded_at timestamp without time zone, id_verified_at timestamp without time zone, id_verified_by uuid, profile_template character varying, profile_settings jsonb, age_verified boolean, age_verified_at timestamp without time zone, birth_date date, profile_url text, website_url text, url_preference character varying, permanent_profile_url text, id_expiry_date date, age_reverify_required boolean, age_reverify_reason text, age_reverify_notified_at timestamp with time zone, signup_method text, signup_method_detail jsonb, feed_sort_order text, feed_post_date_mode text, feed_visible_sources text, feed_date_filter text, online_mode text, is_online boolean, last_seen timestamp with time zone, online_at timestamp with time zone, industry_status text, status_message text, voice_call_rate numeric, cam_show_rate numeric, cam_show_rate_type text, subscription_price numeric, tip_minimum numeric, custom_video_base numeric, photo_shoot_rate numeric, feature_appearance_rate numeric, rates_updated_at timestamp with time zone, agent_fee_percentage numeric

vault_files

id uuid, user_id uuid, filename character varying, file_url text, file_type character varying, file_size bigint, folder character varying, is_posted boolean, post_id uuid, tags jsonb, created_at timestamp with time zone, file_hash character varying, cloud_source character varying, cloud_path text, original_created_at timestamp with time zone, is_deleted boolean, deleted_at timestamp with time zone, deleted_by uuid, deletion_reason character varying, current_version integer, version_count integer

verification_shares

id uuid, user_id uuid, verification_id uuid, shared_with character varying, share_token character varying, scopes ARRAY, status character varying, used_at timestamp with time zone, expires_at timestamp with time zone, created_at timestamp with time zone

video_call_sessions

id uuid, creator_id uuid, customer_id uuid, platform character varying, duration_minutes integer, price numeric, addons jsonb, content_rules jsonb, scheduled_at timestamp with time zone, started_at timestamp with time zone, ended_at timestamp with time zone, actual_duration integer, extended_minutes integer, extension_cost numeric, status character varying, payment_intent_id character varying, recording_detected boolean, creator_rating integer, customer_rating integer, created_at timestamp with time zone, extensions jsonb, no_show_by character varying, refund_amount numeric, creator_payment numeric, title character varying, daily_room_name text, daily_room_url text, actual_cost numeric, call_type text, notes text, responded_at timestamp with time zone

video_captions

id integer, user_id character varying, source_type character varying, source_id integer, video_url text, language character varying, segments jsonb, style jsonb, is_active boolean, translated_from integer, created_at timestamp with time zone, updated_at timestamp with time zone

video_edit_jobs

id integer, user_id character varying, source_video_url text, source_post_id integer, output_type character varying, mode character varying, target_duration integer, style character varying, music_preference character varying, text_overlay text, aspect_ratio character varying, speed_range jsonb, highlight_tags jsonb, include_intro boolean, include_outro boolean, brand_watermark text, analysis jsonb, adjustments jsonb, output_video_url text, status character varying, completed_at timestamp with time zone, created_at timestamp with time zone

video_edit_projects

id integer, user_id character varying, name character varying, source_videos jsonb, aspect_ratio character varying, timeline jsonb, output_video_url text, status character varying, created_at timestamp with time zone, updated_at timestamp with time zone

view_preferences

id uuid, user_id uuid, page character varying, view_mode character varying, sort_by character varying, sort_order character varying, group_by character varying, filters jsonb, created_at timestamp with time zone, updated_at timestamp with time zone

vip_event_attendees

id uuid, event_id uuid, user_id uuid, status character varying, ticket_price numeric, created_at timestamp with time zone

vip_event_rsvps

id uuid, event_id uuid, user_id uuid, ticket_id character varying, created_at timestamp with time zone

vip_events

id uuid, user_id uuid, type character varying, name character varying, description text, price numeric, max_attendees integer, current_attendees integer, date timestamp with time zone, venue character varying, status character varying, perks ARRAY, created_at timestamp with time zone, performer_id uuid, location character varying, event_date timestamp with time zone, event_type character varying, dress_code character varying, vip_perks jsonb, title character varying

watchlist

id uuid, user_id uuid, title text, media_type text, year integer, rating numeric, genre text, studio text, notes text, status text, release_date date, notify_preference text, poster_url text, is_deleted boolean, created_at timestamp with time zone, updated_at timestamp with time zone

welcome_messages

id uuid, user_id uuid, message_text text, media_urls jsonb, trigger_on jsonb, is_active boolean, auto_post_new_content boolean, auto_post_to_tiers jsonb, send_count integer, created_at timestamp with time zone

wishlist_analytics

id uuid, user_id uuid, period character varying, total_items integer, total_wishlists integer, items_purchased integer, self_purchased_amount numeric, gifted_amount numeric, total_saved numeric, top_category character varying, buy_again_count integer, last_calculated timestamp with time zone

wishlist_archive

id uuid, original_item_id uuid, user_id uuid, asin character varying, title text, full_title text, price numeric, image_url text, product_url text, brand character varying, category_l1 character varying, category_l2 character varying, category_l3 character varying, color character varying, size character varying, product_images jsonb, review_images jsonb, original_location character varying, original_wishlist_id uuid, original_wishlist_name character varying, archived_at timestamp with time zone, archive_reason character varying, metadata jsonb

wishlist_folders

id uuid, user_id uuid, parent_id uuid, name character varying, folder_type character varying, icon character varying, color character varying, sort_order integer, created_at timestamp with time zone, updated_at timestamp with time zone, notion_database_id character varying, notion_parent_page_id character varying

wishlist_goals

id uuid, user_id uuid, name character varying, target numeric, current numeric, deadline date, icon character varying, created_at timestamp with time zone

wishlist_item_links

id uuid, item_id uuid, wishlist_id uuid, user_id uuid, is_favorited boolean, position integer, added_at timestamp with time zone, notes text

wishlist_item_trail

id uuid, item_id uuid, user_id uuid, action character varying, from_location character varying, to_location character varying, from_wishlist_id uuid, to_wishlist_id uuid, metadata jsonb, created_at timestamp with time zone

wishlist_items

id uuid, wishlist_id uuid, name character varying, url text, price numeric, image_url text, notes text, priority character varying, is_purchased boolean, purchased_by uuid, purchased_at timestamp with time zone, purchase_message text, created_at timestamp with time zone, closet_item_id uuid, cart_status character varying, arrival_date date, photos jsonb, order_number character varying, tracking_number character varying, carrier character varying, shipping_status character varying, estimated_delivery date, shipped_at timestamp with time zone, delivered_at timestamp with time zone, source_platform character varying, email_match_id character varying, external_order_url text, notion_page_id text, source character varying, asin character varying, updated_at timestamp with time zone

wishlist_suggestions

id uuid, user_id uuid, item_id uuid, suggestion_type character varying, message text, suggested_wishlist_id uuid, event_name character varying, event_date date, is_dismissed boolean, is_acted boolean, created_at timestamp with time zone

wishlists

id uuid, user_id uuid, name character varying, description text, is_public boolean, category character varying, created_at timestamp with time zone, notion_database_id text, source character varying, updated_at timestamp with time zone