public.abuse_activity_signals | Security | api_key_id, confidence_delta, created_at, id, ip_address, metadata, method, reason_code, risk_tier, route, score_delta, signal_type, subject_key, subject_type, user_id, workspace_id | RLS public: enable; public: service_role ALL; public: authenticated SELECT |
public.abuse_events | Security | created_at, email, email_hash, endpoint, event_type, id, ip_address, metadata, success, user_agent | RLS public: enable; public: service_role INSERT; public: authenticated SELECT |
public.abuse_reputation_subjects | Security | api_key_id, cidr, confidence_score, created_at, id, ip_address, last_negative_signal_at, last_positive_signal_at, last_seen_at, metadata, negative_signal_count, positive_signal_count, reputation_score, subject_key, subject_type, tier, trust_multiplier, updated_at, user_id, workspace_id | RLS public: enable; public: service_role ALL; public: authenticated SELECT |
public.abuse_step_up_challenges | Security | challenge_type, completed_at, created_at, expires_at, id, ip_address, metadata, risk_tier, route, status, subject_key, updated_at, user_id | RLS public: enable; public: service_role ALL; public: authenticated SELECT |
public.abuse_trust_overrides | Security | absolute_limits, created_at, created_by, expires_at, id, limit_mode, metadata, reason, revoke_reason, revoked_at, revoked_by, subject_key, subject_type, tier, trust_multiplier, updated_at | RLS public: enable; public: service_role ALL; public: authenticated ALL; public: GRANT SELECT, INSERT, UPDATE, DELETE service_role; public: REVOKE ALL anon, authenticated |
public.ai_chat_messages | AI and memory | chat_id, completion_tokens, content, created_at, creator_id, finish_reason, id, metadata, model, prompt_tokens, role, type | RLS public: enable; public: authenticated SELECT |
public.ai_chats | AI and memory | archived_at, created_at, creator_id, id, is_public, latest_summarized_message_id, model, pinned, summary, title | RLS public: enable; public: authenticated SELECT; public: authenticated UPDATE; public: authenticated INSERT |
public.ai_credit_feature_access | AI and memory | enabled, feature, id, max_requests_per_day, tier | RLS public: enable; public: authenticated SELECT |
public.ai_credit_plan_allocations | AI and memory | allowed_features, allowed_models, created_at, credits_per_seat, daily_limit, default_image_model, default_language_model, id, is_active, markup_multiplier, max_credits_per_request, max_output_tokens_per_request, max_requests_per_day, monthly_credits, tier, updated_at, weekly_limit | RLS public: enable; public: authenticated SELECT |
public.ai_credit_transactions | AI and memory | amount, balance_id, chat_message_id, cost_usd, created_at, execution_id, feature, id, image_count, input_tokens, metadata, model_id, output_tokens, reasoning_tokens, search_count, transaction_type, user_id, ws_id | RLS public: enable; public: authenticated SELECT |
public.ai_model_favorites | AI and memory | created_at, id, model_id, user_id, ws_id | RLS public: enable; public: authenticated DELETE; public: authenticated INSERT; public: authenticated SELECT |
public.audio_chunks | Meetings | chunk_order, created_at, id, session_id, storage_path | RLS public: enable; public: public ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.aurora_ml_forecast | System and configuration | catboost, created_at, date, elasticnet, id, lightgbm, ws_id, xgboost | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.aurora_ml_metrics | System and configuration | created_at, directional_accuracy, id, model, rmse, turning_point_accuracy, weighted_score, ws_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.aurora_statistical_forecast | System and configuration | auto_arima, auto_arima_hi_90, auto_arima_lo_90, auto_ets, auto_ets_hi_90, auto_ets_lo_90, auto_theta, auto_theta_hi_90, auto_theta_lo_90, ces, ces_hi_90, ces_lo_90, created_at, date, id, ws_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.aurora_statistical_metrics | System and configuration | created_at, directional_accuracy, id, model, no_scaling, rmse, turning_point_accuracy, weighted_score, ws_id | RLS public: enable; public: public ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.blocked_ips | Security | block_level, blocked_at, created_at, expires_at, id, ip_address, metadata, reason, status, unblock_reason, unblocked_at, unblocked_by, updated_at | RLS public: enable; public: service_role ALL; public: authenticated ALL |
public.board_template_shares | Tasks | created_at, created_by, email, id, permission, template_id, user_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT ALL service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.board_templates | Tasks | background_path, content, created_at, created_by, description, id, name, source_board_id, updated_at, visibility, ws_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT; public: GRANT ALL service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.calendar_auth_tokens | Calendar and time | access_token, account_email, account_name, created_at, expires_at, id, is_active, provider, refresh_token, user_id, ws_id | RLS public: enable; public: public UPDATE; public: authenticated SELECT; public: authenticated INSERT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.calendar_connections | Calendar and time | access_role, auth_token_id, calendar_id, calendar_name, color, created_at, id, is_enabled, provider, sync_delete_enabled, sync_inbound_enabled, sync_outbound_enabled, updated_at, workspace_calendar_id, ws_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.calendar_event_colors | Calendar and time | value | RLS public: enable; public: authenticated SELECT |
public.calendar_sync_dashboard | Calendar and time | batch_count, calendar_connection_count, calendar_ids_synced, cooldown_remaining_seconds, date_range_end, date_range_start, deleted_events, end_time, error_message, error_stack_trace, error_type, events_fetched_total, events_filtered_out, failed_event_ids, google_api_calls_count, google_api_error_code, google_api_pages_fetched, google_api_retry_count, id, inserted_events, payload_size_bytes, source, start_time, status, sync_token_used, timing_database_writes_ms, timing_event_processing_ms, timing_google_api_fetch_ms, timing_token_operations_ms, timing_total_ms, triggered_by, triggered_from, type, updated_at, updated_events, was_blocked_by_cooldown, ws_id | RLS public: enable; public: authenticated SELECT; public: GRANT UPDATE service_role; public: GRANT TRIGGER service_role |
public.calendar_sync_states | Calendar and time | calendar_id, last_synced_at, sync_token, ws_id | RLS public: enable; public: public ALL |
public.canonical_external_projects | System and configuration | adapter, allowed_collections, allowed_features, created_at, created_by, delivery_profile, display_name, id, is_active, metadata, updated_at, updated_by | RLS public: enable; public: authenticated ALL; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.changelog_entries | System and configuration | category, content, cover_image_url, created_at, creator_id, id, is_published, published_at, slug, summary, title, updated_at, version | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT; public: GRANT ALL authenticated; public: GRANT SELECT anon |
public.course_certificates | Education | completed_date, created_at, group_id, id, user_id | RLS public: enable; public: authenticated SELECT; public: authenticated UPDATE; public: authenticated INSERT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.course_module_completion_status | Education | completed_at, completion_id, completion_status, created_at, module_id, user_id | RLS public: enable; public: authenticated UPDATE; public: authenticated INSERT; public: authenticated SELECT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.course_module_flashcards | Education | created_at, flashcard_id, module_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.course_module_quiz_sets | Education | created_at, module_id, set_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.course_module_quiz_submissions | Education | ai_feedback, answer, created_at, feedback, id, is_correct, module_id, quiz_id, selected_option_id, user_id | RLS public: enable; public: authenticated INSERT; public: authenticated SELECT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.course_module_quizzes | Education | created_at, module_id, quiz_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.course_test_attempt_answers | Education | answer, attempt_id, created_at, feedback, id, is_correct, quiz_id, score_awarded, selected_option_id | RLS public: enable; public: authenticated SELECT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.course_test_attempts | Education | created_at, id, score, started_at, submitted_at, test_id, user_id | RLS public: enable; public: authenticated SELECT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.course_test_modules | Education | created_at, module_id, test_id | RLS public: enable; public: authenticated SELECT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.course_test_quizzes | Education | created_at, module_id, quiz_id, test_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.course_tests | Education | course_id, created_at, description, duration_in_minutes, id, is_published, is_score_published, name, start_at | RLS public: enable; public: authenticated SELECT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.crawled_url_next_urls | Content and CMS | created_at, origin_id, skipped, url | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.crawled_urls | Content and CMS | created_at, creator_id, html, id, markdown, url | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.credit_wallets | AI and memory | limit, payment_date, statement_date, wallet_id | RLS public: enable; public: authenticated ALL |
public.currency_exchange_rates | System and configuration | base_currency, created_at, date, fetched_at, id, rate, target_currency | RLS public: enable; public: service_role ALL; public: authenticated SELECT |
public.discord_guild_members | Chat | created_at, discord_guild_id, discord_user_id, id, platform_user_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.discord_integrations | Chat | created_at, creator_id, discord_guild_id, id, ws_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.email_audit | Mail and delivery | bcc_addresses, cc_addresses, content_hash, created_at, entity_id, entity_type, error_message, html_content, id, ip_address, message_id, metadata, provider, reply_to_addresses, sent_at, source_email, source_name, status, subject, template_type, text_content, to_addresses, updated_at, user_agent, user_id, ws_id | RLS public: enable; public: service_role ALL; public: authenticated SELECT |
public.email_blacklist | Mail and delivery | added_by_user_id, created_at, entry_type, id, reason, updated_at, value | RLS public: enable; public: authenticated ALL |
public.finance_budgets | Finance and commerce | alert_threshold, amount, category_id, created_at, description, end_date, id, is_active, name, period, spent, start_date, updated_at, wallet_id, ws_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.finance_invoice_products | Finance and commerce | amount, created_at, invoice_id, owner_id, owner_name, price, product_id, product_name, product_unit, total_diff, unit_id, warehouse, warehouse_id | public: authenticated ALL |
public.finance_invoice_promotions | Finance and commerce | code, created_at, description, invoice_id, name, promo_id, use_ratio, value | RLS public: enable; public: authenticated ALL |
public.finance_invoice_user_groups | Finance and commerce | created_at, invoice_id, user_group_id | RLS public: enable; public: authenticated ALL |
public.finance_invoices | Finance and commerce | category_id, completed_at, created_at, creator_id, customer_id, id, note, notice, paid_amount, platform_creator_id, price, subscription_months, total_diff, transaction_id, valid_until, wallet_id, ws_id | Policy not indexed; first mention; last mention |
public.guest_users_lead_generation | Identity | created_at, id, mail_id, user_id, ws_id | RLS public: enable; public: public ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.habit_calendar_events | Calendar and time | completed, created_at, event_id, habit_id, id, occurrence_date, scheduling_reason, updated_at | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.habit_completions | System and configuration | completed_at, created_at, event_id, habit_id, id, occurrence_date | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.habit_skipped_occurrences | System and configuration | created_at, created_by, habit_id, id, occurrence_date, revoked_at, source_event_id, updated_at, ws_id | RLS public: enable; public: PUBLIC ALL; public: PUBLIC SELECT |
public.handles | Identity | created_at, creator_id, value | RLS public: enable; public: anon, authenticated INSERT; public: authenticated INSERT; public: authenticated DELETE |
public.hive_members | Content and CMS | created_at, enabled, id, notes, updated_at, user_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT |
public.hive_npc_memories | Content and CMS | content, created_at, created_by, enabled, id, importance, npc_id, server_id, source_run_id | RLS public: enable; public: authenticated SELECT |
public.hive_npc_runs | Content and CMS | actor_user_id, applied_event_id, autonomous, created_at, credit_source, credit_ws_id, credits_deducted, error, id, input_context, input_tokens, interaction_id, llm_cost, llm_model, llm_provider, npc_id, output_decision, output_tokens, prompt_mode, reasoning_tokens, research_session_id, server_id, status, target_npc_id, trigger | RLS public: enable; public: authenticated SELECT |
public.hive_npcs | Content and CMS | backstory, backstory_enabled, created_at, created_by, custom_prompt_enabled, id, memory_enabled, model, name, position, role, server_id, settings, system_prompt, updated_at | RLS public: enable; public: authenticated SELECT |
public.hive_research_session_events | Content and CMS | actor_user_id, created_at, event_kind, id, payload, server_id, session_id, source_id, source_type | RLS public: enable; public: authenticated ALL; public: authenticated SELECT |
public.hive_research_sessions | Content and CMS | created_at, created_by, description, ended_at, id, metadata, name, server_id, started_at, status, updated_at | RLS public: enable; public: authenticated ALL; public: authenticated SELECT |
public.hive_servers | Content and CMS | created_at, created_by, description, enabled, id, max_players, name, slug, updated_at | RLS public: enable; public: authenticated ALL; public: authenticated SELECT |
public.hive_workflow_runs | Content and CMS | actor_user_id, created_at, error, finished_at, id, input, output, research_session_id, server_id, started_at, status, step_trace, workflow_id | RLS public: enable; public: authenticated ALL; public: authenticated INSERT; public: authenticated SELECT |
public.hive_workflows | Content and CMS | archived_at, created_at, created_by, definition, description, enabled, id, name, server_id, updated_at, updated_by, version | RLS public: enable; public: authenticated ALL; public: authenticated SELECT |
public.hive_world_events | Content and CMS | actor_user_id, created_at, event_type, id, payload, research_session_id, revision, server_id | RLS public: enable; public: authenticated SELECT |
public.hive_world_states | Content and CMS | revision, server_id, updated_at, updated_by, world_data | RLS public: enable; public: authenticated SELECT |
public.internal_emails | Mail and delivery | bcc_addresses, cc_addresses, created_at, html_payload, id, payload, reply_to_addresses, source_email, subject, to_addresses, user_id, ws_id | RLS public: enable; public: authenticated SELECT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.link_analytics | Analytics | browser, city, clicked_at, country, country_region, created_at, device_type, id, ip_address, latitude, link_id, longitude, os, postal_code, referrer, referrer_domain, timezone, user_agent, vercel_id, vercel_region | RLS public: enable; public: PUBLIC INSERT; public: authenticated SELECT; public: GRANT ALL service_role; public: GRANT INSERT anon |
public.live_api_sessions | Meetings | created_at, expires_at, id, scope_key, session_handle, updated_at, user_id, ws_id | RLS public: enable; public: PUBLIC ALL |
public.meet_ai_chunks | Meetings | attempt_id, attempt_started_at, attempts, cost_usd, created_at, duration_seconds, id, prior_cost_usd, sequence, session_id, start_seconds, status, transcript, unpriced_attempts, usage | RLS public: enable; public: authenticated SELECT; public: GRANT ALL service_role; public: GRANT SELECT authenticated |
public.meet_ai_memories | Meetings | category, content, created_at, id, user_id | RLS public: enable; public: authenticated SELECT; public: GRANT ALL service_role; public: GRANT SELECT authenticated |
public.meet_ai_sessions | Meetings | created_at, ended_at, id, meeting_id, notes, notes_cost_usd, notes_started_at, notes_status, notes_unpriced_attempts, notes_usage, user_id | RLS public: enable; public: authenticated SELECT; public: GRANT ALL service_role; public: GRANT SELECT authenticated |
public.meet_ai_user_preferences | Meetings | memory_enabled, updated_at, user_id | RLS public: enable; public: authenticated SELECT; public: GRANT ALL service_role; public: GRANT SELECT authenticated |
public.meet_together_finalized_timeframes | Meetings | created_at, created_by, end_at, id, plan_id, position, start_at, updated_at | RLS public: enable; public: GRANT SELECT, INSERT, UPDATE, DELETE service_role; public: REVOKE ALL anon, authenticated; Policy not indexed; first mention |
public.meet_together_guest_timeblocks | Meetings | created_at, date, end_time, id, plan_id, start_time, tentative, user_id | RLS public: enable; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role; Policy not indexed; first mention; last mention |
public.meet_together_guests | Meetings | created_at, id, name, password_hash, password_salt, plan_id | RLS public: enable; public: REVOKE ALL anon, authenticated; public: GRANT UPDATE service_role; Policy not indexed; first mention; last mention |
public.meet_together_plans | Meetings | agenda_content, created_at, creator_id, dates, description, duration_minutes, end_time, finalized_at, finalized_by, id, is_confirmed, is_public, name, start_time, timezone, where_to_meet, ws_id | RLS public: enable; public: public SELECT; public: authenticated SELECT; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.meet_together_user_timeblocks | Meetings | created_at, date, end_time, id, plan_id, start_time, tentative, user_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.mira_daily_stats | AI and memory | created_at, date, focus_minutes, focus_sessions_completed, id, interactions, streak_day, tasks_completed, updated_at, user_id, xp_earned | public: PUBLIC UPDATE; public: PUBLIC INSERT; public: PUBLIC SELECT |
public.mira_focus_sessions | AI and memory | actual_duration, completed, created_at, ended_at, goal, id, notes, planned_duration, started_at, user_id, xp_earned | public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.mira_memories | AI and memory | category, confidence, created_at, embedding, id, key, last_referenced_at, source, updated_at, user_id, value | public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.mira_pets | AI and memory | created_at, health, hunger, id, last_fed_at, last_interaction_at, level, mood, name, streak_days, total_conversations, total_focus_minutes, updated_at, user_id, xp, xp_to_next_level | public: PUBLIC UPDATE; public: PUBLIC INSERT; public: PUBLIC SELECT |
public.mira_soul | AI and memory | boundaries, chat_tone, created_at, id, name, personality, push_tone, tone, updated_at, user_id, vibe | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.mira_user_accessories | AI and memory | accessory_id, id, is_equipped, unlocked_at, user_id | public: PUBLIC UPDATE; public: PUBLIC INSERT; public: PUBLIC SELECT |
public.mira_user_achievements | AI and memory | achievement_id, id, unlocked_at, user_id | public: PUBLIC INSERT; public: PUBLIC SELECT |
public.notes | Content and CMS | archived, content, created_at, creator_id, deleted, id, title, updated_at, ws_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT; public: GRANT ALL authenticated |
public.notification_preferences | Notifications | channel, created_at, enabled, event_type, id, scope, updated_at, user_id, ws_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.notification_push_devices | Notifications | app_flavor, created_at, device_id, id, last_seen_at, platform, token, updated_at, user_id | RLS public: enable; public: PUBLIC ALL; public: PUBLIC DELETE; public: PUBLIC UPDATE |
public.notifications | Notifications | action_url, archived_at, code, created_at, created_by, data, description, email, entity_id, entity_type, expires_at, id, metadata, parent_id, priority, read_at, scope, title, type, user_id, ws_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated SELECT; public: GRANT ALL service_role; public: REVOKE ALL public, anon, authenticated |
public.onboarding_progress | Identity | completed_at, completed_missions, completed_steps, created_at, current_step, dismissed_at, flow_type, goals, guidance_mode, invited_emails, journey_revision, language_preference, notifications_enabled, persona, profile_completed, replay_app, team_workspace_id, theme_preference, tour_completed, updated_at, use_case, user_id, workspace_avatar_url, workspace_description, workspace_name | RLS public: enable; public: authenticated INSERT; public: authenticated UPDATE; public: authenticated SELECT |
public.platform_email_roles | Identity | allow_challenge_management, allow_manage_all_challenges, allow_role_management, created_at, email, enabled | RLS public: enable; public: authenticated ALL |
public.platform_entity_creation_limits | System and configuration | created_at, enabled, notes, per_day, per_hour, per_month, per_week, table_name, tier, total_limit, updated_at, updated_by | RLS public: enable; public: GRANT SELECT, INSERT, UPDATE, DELETE service_role; public: REVOKE ALL anon, authenticated; Policy not indexed; first mention |
public.platform_user_roles | Identity | allow_challenge_management, allow_discord_integrations, allow_manage_all_challenges, allow_role_management, allow_workspace_creation, created_at, enabled, user_id | RLS public: enable; public: authenticated SELECT; public: authenticated ALL |
public.poll_guest_votes | System and configuration | created_at, guest_id, id, option_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.poll_options | System and configuration | created_at, id, poll_id, value | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.poll_user_votes | System and configuration | created_at, id, option_id, user_id | RLS public: enable; public: authenticated INSERT; public: authenticated DELETE; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.polls | System and configuration | allow_anonymous_updates, created_at, creator_id, id, name, plan_id, ws_id | RLS public: enable; public: authenticated ALL; public: public SELECT; public: authenticated INSERT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.post_email_queue | Notifications | attempt_count, batch_id, blocked_reason, cancelled_at, claimed_at, created_at, group_id, id, last_attempt_at, last_error, post_id, sender_platform_user_id, sent_at, sent_email_id, status, updated_at, user_id, ws_id | RLS public: enable; Policy not indexed; first mention; last mention |
public.product_categories | Finance and commerce | created_at, id, name, ws_id | RLS public: enable; public: authenticated ALL |
public.product_stock_changes | Finance and commerce | amount, beneficiary_id, created_at, creator_id, id, note, product_id, unit_id, warehouse_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.qr_login_challenges | Identity | approval_metadata, approved_at, approver_device_id, approver_email, approver_platform, approver_user_id, consumed_at, created_at, expires_at, id, request_metadata, secret_hash, status, updated_at | RLS public: enable; public: GRANT ALL service_role; public: REVOKE ALL authenticated; Policy not indexed; first mention; last mention |
public.quiz_options | Education | created_at, explanation, id, is_correct, points, quiz_id, value | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.quiz_set_quizzes | Education | created_at, quiz_id, set_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.rate_limit_appeals | Security | cleared_blocked_ip_id, client_ip, created_at, created_rate_limit_rule_id, creator_id, diagnostics, id, message, page_path, proxy_block_reason, rate_limit_policy, rate_limit_window, request_method, request_path, response_status, retry_after_seconds, review_note, reviewed_at, reviewed_by, status, temporary_relief_expires_at, temporary_relief_granted_at, timezone, turnstile_verified_at, updated_at, user_agent, user_email, workspace_id | RLS public: enable; public: authenticated INSERT; public: authenticated SELECT; public: GRANT DELETE, INSERT, REFERENCES, SELECT, TRIGGER, TRUNCATE, UPDATE service_role; public: GRANT SELECT, INSERT authenticated |
public.realtime_log_aggregations | Analytics | channel_id, created_at, error_count, id, kind, sample_messages, time_bucket, total_count, user_id, ws_id | RLS public: enable; public: authenticated SELECT |
public.recording_sessions | Meetings | created_at, id, meeting_id, status, updated_at, user_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.recurring_transactions | Finance and commerce | amount, category_id, created_at, description, end_date, frequency, id, is_active, last_occurrence, name, next_occurrence, start_date, updated_at, wallet_id, ws_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.sent_emails | Mail and delivery | content, created_at, email, id, post_id, receiver_id, sender_id, source_email, source_name, subject, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.sepay_connections | Finance and commerce | access_token_encrypted, access_token_expires_at, created_at, id, refresh_token_encrypted, scopes, sepay_company_id, status, updated_at, ws_id | RLS public: enable; Policy not indexed; first mention; last mention |
public.sepay_wallet_links | Finance and commerce | active, created_at, id, metadata, sepay_account_number, sepay_bank_account_id, sepay_gateway, sepay_sub_account_id, updated_at, wallet_id, ws_id | RLS public: enable; Policy not indexed; first mention; last mention |
public.sepay_webhook_endpoints | Finance and commerce | active, created_at, deleted_at, id, last_used_at, rotated_at, sepay_webhook_id, token_hash, token_prefix, wallet_id, ws_id | RLS public: enable; Policy not indexed; first mention; last mention |
public.sepay_webhook_events | Finance and commerce | created_transaction_id, endpoint_id, failure_reason, id, payload, processed_at, received_at, reference_code, sepay_event_id, status, transaction_date, transfer_amount, transfer_type, wallet_id, ws_id | RLS public: enable; Policy not indexed; first mention; last mention |
public.shortened_links | System and configuration | created_at, creator_id, domain, id, link, password_hash, password_hint, slug, ws_id | RLS public: enable; public: authenticated SELECT; public: public INSERT; public: authenticated INSERT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.support_inquiries | System and configuration | created_at, creator_id, email, id, images, is_read, is_resolved, message, name, product, subject, type | RLS public: enable; public: authenticated SELECT; public: public INSERT; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.task_assignees | Tasks | created_at, task_id, user_id | RLS public: enable; public: authenticated INSERT; public: authenticated DELETE; public: authenticated SELECT; public: GRANT ALL service_role; public: GRANT ALL authenticated |
public.task_board_public_links | Tasks | board_id, code, created_at, created_by_user_id, disabled_at, disabled_by_user_id, enabled, id, updated_at | RLS public: enable; public: GRANT ALL PRIVILEGES service_role; public: REVOKE ALL PRIVILEGES authenticated; Policy not indexed; first mention |
public.task_board_shares | Tasks | board_id, created_at, id, permission, shared_by_user_id, shared_with_email, shared_with_user_id, updated_at | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT; public: GRANT ALL PRIVILEGES service_role; public: REVOKE ALL PRIVILEGES authenticated |
public.task_board_status_templates | Tasks | created_at, description, id, is_default, name, statuses, updated_at | RLS public: enable; public: authenticated ALL; public: authenticated SELECT |
public.task_calendar_events | Calendar and time | completed, created_at, event_id, id, scheduled_minutes, scheduling_reason, task_id, updated_at | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.task_capacity_rule_labels | Tasks | label_id, rule_id | RLS public: enable; public: GRANT SELECT, INSERT, UPDATE, DELETE service_role; Policy not indexed; first mention |
public.task_capacity_rule_lists | Tasks | list_id, rule_id | RLS public: enable; public: GRANT SELECT, INSERT, UPDATE, DELETE service_role; Policy not indexed; first mention |
public.task_capacity_rule_projects | Tasks | project_id, rule_id | RLS public: enable; public: GRANT SELECT, INSERT, UPDATE, DELETE service_role; Policy not indexed; first mention |
public.task_capacity_rules | Tasks | board_id, counting_mode, created_at, created_by, disabled_reason, enabled, enforcement, id, label_match_mode, limit_value, metric, name, project_match_mode, updated_at, updated_by | RLS public: enable; public: GRANT SELECT, INSERT, UPDATE, DELETE service_role; Policy not indexed; first mention |
public.task_cycle_tasks | Tasks | created_at, cycle_id, task_id | RLS public: enable; public: PUBLIC ALL; public: PUBLIC SELECT; public: GRANT ALL authenticated |
public.task_cycles | Tasks | archived, created_at, creator_id, deleted, description, end_date, id, name, start_date, status, updated_at, ws_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT; public: GRANT ALL authenticated |
public.task_drafts | Tasks | assignee_ids, board_id, created_at, creator_id, description, end_date, estimation_points, id, label_ids, list_id, name, priority, project_ids, start_date, updated_at, ws_id | RLS public: enable; public: authenticated ALL |
public.task_history | Tasks | change_type, changed_at, changed_by, deleted_at, field_name, id, metadata, new_value, old_value, task_id | RLS public: enable; public: PUBLIC SELECT; public: PUBLIC DELETE; public: PUBLIC UPDATE |
public.task_initiatives | Tasks | archived, created_at, creator_id, deleted, description, id, name, status, updated_at, ws_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT; public: GRANT ALL authenticated |
public.task_labels | Tasks | label_id, task_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC INSERT; public: PUBLIC SELECT; public: GRANT SELECT, INSERT, DELETE service_role; public: GRANT SELECT, INSERT, DELETE authenticated |
public.task_leaderboard_members | Tasks | created_at, display_name, id, joined_by, leaderboard_id, status, team_id, updated_at, user_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT ALL PRIVILEGES service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.task_leaderboard_teams | Tasks | color, created_at, created_by, id, leaderboard_id, name, updated_at | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT ALL PRIVILEGES service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.task_leaderboards | Tasks | archived_at, created_at, created_by, description, id, join_code, metric_id, name, period_end, period_start, starred, status, updated_at, visibility, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT ALL PRIVILEGES service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.task_lists | Tasks | archived, board_id, color, created_at, creator_id, deleted, id, name, position, status | RLS public: enable; public: authenticated ALL; public: GRANT ALL service_role; public: GRANT ALL authenticated |
public.task_plan_items | Tasks | created_at, created_by_user_id, id, notes, plan_id, planned_end, planned_start, snapshot_title, sort_key, status, target_board_id, target_list_id, target_ws_id, task_id, updated_at | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT; public: GRANT ALL PRIVILEGES service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.task_plan_shares | Tasks | created_at, id, permission, plan_id, shared_by_user_id, shared_with_email, shared_with_user_id, shared_with_ws_id, updated_at | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT; public: GRANT ALL PRIVILEGES service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.task_plan_workspaces | Tasks | added_by_user_id, created_at, plan_id, ws_id | RLS public: enable; public: authenticated DELETE; public: authenticated INSERT; public: authenticated SELECT; public: GRANT ALL PRIVILEGES service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.task_plans | Tasks | archived_at, created_at, default_target_board_id, default_target_list_id, default_target_ws_id, id, owner_id, period_end, period_start, period_type, personal_ws_id, status, timezone, title, updated_at | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT; public: GRANT ALL PRIVILEGES service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.task_profile_progress_settings | Tasks | created_at, display_name, show_goals, show_leaderboards, show_progress, updated_at, user_id, visibility, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT ALL PRIVILEGES service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.task_progress_achievements | Tasks | category, code, created_at, criteria, description, icon, id, name, sort_order, tier, updated_at, ws_id | RLS public: enable; public: authenticated SELECT; public: GRANT ALL PRIVILEGES service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.task_progress_entries | Tasks | board_id, created_at, created_by, deleted_at, entry_date, id, list_id, metric_id, mode, note, project_id, source_id, source_type, tags, task_id, updated_at, value, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT ALL PRIVILEGES service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.task_progress_goals | Tasks | archived_at, board_id, created_at, description, goal_type, habit_frequency, habit_target_count, habit_threshold, id, metric_id, name, owner_id, period_end, period_start, project_id, recurrence, starred, status, tags, target_value, task_id, updated_at, visibility, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT ALL PRIVILEGES service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.task_progress_metrics | Tasks | aggregation, archived_at, created_at, created_by, description, id, is_default, name, unit_kind, unit_label, updated_at, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT ALL PRIVILEGES service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.task_progress_user_achievements | Tasks | achievement_code, created_at, id, progress, unlocked_at, updated_at, user_id, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT ALL PRIVILEGES service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.task_progress_user_stats | Tasks | created_at, last_milestone_at, level, streak_freezes, updated_at, user_id, ws_id, xp | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT ALL PRIVILEGES service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.task_project_initiatives | Tasks | created_at, initiative_id, project_id | RLS public: enable; public: PUBLIC ALL; public: PUBLIC SELECT; public: GRANT ALL authenticated |
public.task_project_tasks | Tasks | created_at, project_id, task_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT; public: GRANT ALL authenticated |
public.task_project_update_attachments | Tasks | created_at, deleted_at, file_name, file_path, file_size, id, mime_type, update_id, uploaded_by | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC INSERT; public: PUBLIC SELECT |
public.task_project_update_comments | Tasks | content, created_at, deleted_at, id, parent_id, update_id, updated_at, user_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.task_project_update_reactions | Tasks | created_at, emoji, id, update_id, user_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC INSERT; public: PUBLIC SELECT |
public.task_project_updates | Tasks | content, created_at, creator_id, deleted_at, id, project_id, updated_at | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.task_projects | Tasks | archived, created_at, creator_id, deleted, description, description_yjs_state, end_date, health_status, id, lead_id, name, priority, start_date, status, updated_at, ws_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT; public: GRANT ALL authenticated |
public.task_relationships | Tasks | created_at, created_by, id, source_task_id, target_task_id, type | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT |
public.task_share_link_uses | Tasks | accessed_at, id, share_link_id, user_id | RLS public: enable; public: authenticated INSERT; public: authenticated SELECT; public: GRANT ALL service_role; public: GRANT SELECT, INSERT authenticated |
public.task_share_links | Tasks | code, created_at, created_by_user_id, id, permission, public_access, requires_invite, task_id | RLS public: enable; public: authenticated SELECT; public: authenticated DELETE; public: authenticated UPDATE; public: GRANT ALL service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.task_shares | Tasks | created_at, id, permission, shared_by_user_id, shared_with_email, shared_with_user_id, task_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT; public: GRANT ALL service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.task_templates | Tasks | archived_at, assignee_ids, created_at, created_by, default_board_id, default_list_id, description, description_yjs_state, end_date, estimation_points, id, label_ids, name, priority, project_ids, slug, source_task_id, start_date, task_name, updated_at, visibility, ws_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT; public: GRANT ALL service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.task_user_override_labels | Tasks | created_at, label_id, task_id, user_id | RLS public: enable; public: authenticated DELETE; public: authenticated INSERT; public: authenticated SELECT; public: GRANT DELETE, INSERT, REFERENCES, SELECT, TRIGGER, TRUNCATE, UPDATE anon, authenticated, service_role |
public.task_user_override_projects | Tasks | created_at, project_id, task_id, user_id | RLS public: enable; public: authenticated DELETE; public: authenticated INSERT; public: authenticated SELECT; public: GRANT DELETE, INSERT, REFERENCES, SELECT, TRIGGER, TRUNCATE, UPDATE anon, authenticated, service_role |
public.task_user_overrides | Tasks | completed_at, created_at, due_date_override, estimation_override, notes, personal_added_at, personal_board_id, personal_list_id, personal_placed_at, personal_sort_key, personally_unassigned, priority_override, self_managed, task_id, updated_at, user_id | RLS public: enable; public: authenticated UPDATE; public: authenticated INSERT; public: authenticated DELETE |
public.task_user_scheduling_settings | Tasks | auto_schedule, calendar_hours, created_at, is_splittable, max_split_duration_minutes, min_split_duration_minutes, task_id, total_duration, updated_at, user_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT |
public.task_watchers | Tasks | created_at, id, task_id, user_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC INSERT; public: PUBLIC SELECT |
public.tasks | Tasks | board_id, closed_at, completed, completed_at, created_at, creator_id, deleted_at, description, description_yjs_state, display_number, embedding, end_date, estimation_points, fts, id, list_id, name, priority, sort_key, start_date | RLS public: enable; public: authenticated ALL; public: GRANT ALL service_role; public: GRANT ALL authenticated |
public.time_tracking_breaks | Calendar and time | break_duration_seconds, break_end, break_start, break_type_id, break_type_name, created_at, created_by, id, notes, session_id, updated_at | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.time_tracking_categories | Calendar and time | color, created_at, description, id, name, updated_at, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT |
public.time_tracking_goals | Calendar and time | category_id, created_at, daily_goal_minutes, id, is_active, updated_at, user_id, weekly_goal_minutes, ws_id | RLS public: enable; public: authenticated SELECT; public: authenticated ALL |
public.time_tracking_sessions | Calendar and time | category_id, created_at, date, description, duration_seconds, end_time, id, is_running, parent_session_id, pending_approval, productivity_score, start_time, tags, task_id, title, updated_at, user_id, was_resumed, ws_id | RLS public: enable; public: authenticated INSERT; public: authenticated UPDATE; public: PUBLIC ALL |
public.transaction_categories | Finance and commerce | color, created_at, description, icon, id, is_expense, name, ws_id | RLS public: enable; public: authenticated ALL |
public.transaction_tags | Finance and commerce | color, created_at, description, id, name, updated_at, ws_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.tulearn_gamification_events | Education | created_at, id, idempotency_key, metadata, source_id, source_type, user_id, ws_id, xp | RLS public: enable; public: authenticated SELECT; public: GRANT ALL service_role; public: GRANT SELECT authenticated |
public.tulearn_learner_state | Education | created_at, current_streak, hearts, last_activity_date, last_heart_refill_at, longest_streak, max_hearts, preferences, selected_workspace_id, streak_freezes, updated_at, user_id, ws_id, xp_total | RLS public: enable; public: authenticated UPDATE; public: authenticated INSERT; public: authenticated SELECT; public: GRANT ALL service_role; public: GRANT SELECT, INSERT, UPDATE authenticated |
public.tulearn_parent_invites | Education | accepted_at, created_at, expires_at, id, invited_by, parent_email, parent_user_id, revoked_at, status, student_workspace_user_id, token_hash, updated_at, ws_id | RLS public: enable; public: authenticated SELECT; public: GRANT ALL service_role; public: GRANT SELECT authenticated |
public.tulearn_parent_student_links | Education | accepted_at, created_at, created_by, id, parent_user_id, revoked_at, status, student_platform_user_id, student_workspace_user_id, updated_at, ws_id | RLS public: enable; public: authenticated SELECT; public: GRANT ALL service_role; public: GRANT SELECT authenticated |
public.user_board_list_overrides | Tasks | board_id, created_at, id, list_id, notes, personal_status, scope_type, updated_at, user_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT |
public.user_configs | Identity | created_at, id, updated_at, user_id, value | RLS public: enable; public: PUBLIC ALL |
public.user_feedbacks | Identity | content, created_at, creator_id, group_id, id, require_attention, user_id | RLS public: enable; public: authenticated ALL |
public.user_group_attendance | Contacts and workforce | created_at, date, group_id, id, notes, session_id, status, user_id | RLS public: enable; public: authenticated ALL |
public.user_group_linked_products | Contacts and workforce | created_at, group_id, product_id, unit_id, warehouse_id | RLS public: enable; public: authenticated ALL |
public.user_group_metrics | Contacts and workforce | created_at, factor, group_id, id, is_weighted, name, unit, ws_id | public: REVOKE INSERT, UPDATE, DELETE authenticated; public: GRANT ALL PRIVILEGES service_role; Policy not indexed; first mention; last mention |
public.user_indicators | Contacts and workforce | created_at, creator_id, indicator_id, user_id, value | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.user_private_details | Identity | birthday, default_workspace_id, deleted, email, fade_completed_tasks, first_day_of_week, full_name, new_email, services, task_auto_assign_to_self, time_format, timezone, user_id | RLS public: enable; public: authenticated SELECT; public: authenticated UPDATE |
public.user_suspensions | Security | created_at, expires_at, id, lifted_at, lifted_by, metadata, reason, suspended_at, suspended_by, user_id | RLS public: enable; public: service_role ALL; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.user_workspace_configs | Identity | created_at, id, updated_at, user_id, value, ws_id | RLS public: enable; public: PUBLIC ALL |
public.users | Identity | avatar_url, banner_url, bio, created_at, display_name, handle, id | RLS public: enable; public: authenticated SELECT; public: authenticated UPDATE; public: PUBLIC UPDATE; public: GRANT ALL service_role; public: GRANT ALL authenticated |
public.vietnamese_holidays | System and configuration | created_at, date, id, name, year | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.wallet_interest_configs | Finance and commerce | created_at, enabled, id, last_calculated_at, last_interest_amount, provider, total_interest_earned, tracking_end_date, tracking_start_date, updated_at, wallet_id, zalopay_tier | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.wallet_interest_rates | Finance and commerce | annual_rate, config_id, created_at, effective_from, effective_to, id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.wallet_transaction_tags | Finance and commerce | created_at, tag_id, transaction_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC INSERT; public: PUBLIC SELECT |
public.wallet_transactions | Finance and commerce | amount, category_id, created_at, creator_id, description, id, invoice_id, is_amount_confidential, is_category_confidential, is_description_confidential, platform_creator_id, report_opt_in, taken_at, wallet_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT |
public.wallet_types | Finance and commerce | id | RLS public: enable; Policy not indexed; first mention; last mention |
public.workforce_benefits | Finance and commerce | amount, benefit_type, contract_id, created_at, currency, effective_from, effective_until, id, is_recurring, name, notes, recurrence_period, updated_at, ws_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT |
public.workforce_compensation | Finance and commerce | base_hourly_rate, base_salary_annual, base_salary_monthly, contract_id, created_at, currency, effective_from, effective_until, id, insurance_salary, overtime_multiplier_daily, overtime_multiplier_holiday, overtime_multiplier_weekend, overtime_threshold_daily_hours, payment_frequency, updated_at, ws_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT |
public.workforce_contracts | Finance and commerce | contract_type, created_at, created_by, department, employment_status, end_date, file_url, id, job_title, notes, start_date, updated_at, user_id, working_location, ws_id | RLS public: enable; public: authenticated SELECT; public: authenticated DELETE; public: authenticated UPDATE |
public.workspace_ai_credit_balances | AI and memory | bonus_credits, created_at, id, period_end, period_start, total_allocated, total_used, updated_at, user_id, ws_id | RLS public: enable; public: authenticated SELECT |
public.workspace_ai_executions | AI and memory | api_key_id, created_at, finish_reason, id, input, input_tokens, model_id, output, output_tokens, reasoning_tokens, system_prompt, total_tokens, ws_id | RLS public: enable; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role; Policy not indexed; first mention; last mention |
public.workspace_ai_models | AI and memory | created_at, description, id, name, updated_at, url, ws_id | RLS public: enable; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role; Policy not indexed; first mention |
public.workspace_ai_prompts | AI and memory | created_at, creator_id, id, input, model, name, output, ws_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_api_key_usage_logs | Analytics | api_key_id, created_at, endpoint, error_message, id, ip_address, method, request_params, response_time_ms, status_code, user_agent, ws_id | RLS public: enable; public: authenticated INSERT; public: authenticated SELECT |
public.workspace_api_keys | System and configuration | created_at, created_by, description, expires_at, id, key_hash, key_prefix, last_used_at, name, role_id, scopes, updated_at, ws_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_boards | Tasks | allow_zero_estimates, archived_at, count_unestimated_issues, created_at, creator_id, default_closed_list_id, default_done_list_id, default_list_id, deleted_at, estimation_type, extended_estimation, icon, id, name, next_task_number, template_id, ticket_prefix, ws_id | public: authenticated ALL; public: public ALL |
public.workspace_break_types | System and configuration | color, created_at, description, icon, id, is_default, name, updated_at, ws_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.workspace_calendar_categories | Calendar and time | color, created_at, id, name, position, updated_at, ws_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT |
public.workspace_calendar_events | Calendar and time | color, created_at, description, end_at, external_calendar_id, external_event_id, external_updated_at, google_calendar_id, google_event_id, id, is_encrypted, last_synced_at, location, locked, provider, scheduling_metadata, scheduling_source, source_calendar_id, start_at, sync_error, sync_status, task_id, title, ws_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT |
public.workspace_calendar_hour_settings | Calendar and time | created_at, data, type, ws_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_calendar_sync_coordination | Calendar and time | created_at, last_upsert, updated_at, ws_id | RLS public: enable; public: authenticated ALL |
public.workspace_chat_channels | Chat | created_at, created_by, description, id, is_private, name, updated_at, ws_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.workspace_chat_messages | Chat | channel_id, content, created_at, deleted_at, id, updated_at, user_id | RLS public: enable; public: PUBLIC INSERT; public: PUBLIC SELECT; public: PUBLIC DELETE |
public.workspace_chat_participants | Chat | channel_id, id, joined_at, last_read_at, user_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.workspace_chat_typing_indicators | Chat | channel_id, id, updated_at, user_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.workspace_configs | System and configuration | created_at, id, updated_at, value, ws_id | RLS public: enable; public: PUBLIC ALL; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_course_module_groups | Education | color, created_at, group_id, icon, id, sort_key, title | RLS public: enable; Policy not indexed; first mention; last mention |
public.workspace_course_modules | Education | content, created_at, extra_content, group_id, id, is_public, is_published, is_quiz_score_published, module_group_id, name, quiz_deadline, sort_key, vocabulary, youtube_links | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_credit_pack_purchases | AI and memory | created_at, credit_pack_id, expires_at, granted_at, id, polar_subscription_id, status, tokens_granted, tokens_remaining, updated_at, ws_id | RLS public: enable; public: authenticated SELECT; public: GRANT ALL service_role; public: GRANT SELECT service_role |
public.workspace_cron_executions | Operations | created_at, cron_run_id, duration_ms, end_time, endpoint_url, error, http_status, id, job_id, response, source, start_time, status | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_cron_jobs | Operations | active, created_at, cron_job_id, dataset_id, endpoint_url, external_app_id, external_job_key, failure_count, headers_config, http_method, id, last_run_at, last_status, locked_at, locked_by, name, next_run_at, retry_count, schedule, schedule_timezone, timeout_ms, ws_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_dataset_cells | Content and CMS | column_id, created_at, data, dataset_id, id, row_id | Policy not indexed; first mention; last mention |
public.workspace_dataset_columns | Content and CMS | alias, created_at, dataset_id, description, id, name | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_dataset_rows | Content and CMS | created_at, dataset_id, id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_datasets | Content and CMS | created_at, description, id, name, url, ws_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_default_included_user_groups | System and configuration | created_at, group_id, ws_id | RLS public: enable; public: GRANT DELETE service_role; public: GRANT UPDATE service_role; Policy not indexed; first mention; last mention |
public.workspace_default_permissions | System and configuration | created_at, enabled, member_type, permission, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_documents | Content and CMS | content, created_at, id, is_public, legacy_content, name, ws_id | RLS public: enable; public: authenticated ALL |
public.workspace_email_credentials | Mail and delivery | access_id, access_key, created_at, id, region, source_email, source_name, ws_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_email_invite_roles | Identity | created_at, email, role_id, ws_id | RLS public: enable; public: GRANT ALL service_role; public: REVOKE ALL PUBLIC, anon, authenticated; Policy not indexed; first mention |
public.workspace_email_invites | Identity | created_at, email, invited_by, role_id, type, ws_id | RLS public: enable; public: authenticated INSERT; public: authenticated UPDATE; public: authenticated SELECT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_encryption_keys | System and configuration | created_at, encrypted_key, id, key_version, updated_at, ws_id | RLS public: enable; public: service_role ALL |
public.workspace_external_project_assets | Content and CMS | alt_text, asset_type, block_id, created_at, created_by, entry_id, id, metadata, sort_order, source_url, stable_source_id, storage_path, updated_at, updated_by, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.workspace_external_project_binding_audits | Content and CMS | actor_user_id, changed_at, destination_ws_id, id, next_canonical_id, previous_canonical_id, source_ws_id | RLS public: enable; public: authenticated SELECT; public: GRANT SELECT authenticated |
public.workspace_external_project_bindings | Content and CMS | canonical_project_id, created_at, created_by, is_enabled, settings, updated_at, updated_by, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT SELECT, INSERT, UPDATE, DELETE service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.workspace_external_project_blocks | Content and CMS | block_type, content, created_at, created_by, entry_id, id, sort_order, stable_source_id, title, updated_at, updated_by, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.workspace_external_project_collections | Content and CMS | collection_type, config, created_at, created_by, description, id, is_enabled, slug, title, updated_at, updated_by, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.workspace_external_project_entries | Content and CMS | collection_id, created_at, created_by, id, metadata, profile_data, published_at, scheduled_for, slug, sort_order, source_adapter, stable_source_id, status, subtitle, summary, title, updated_at, updated_by, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.workspace_external_project_entry_placements | Content and CMS | created_at, created_by, entry_id, id, metadata, placement_key, sort_order, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.workspace_external_project_entry_relations | Content and CMS | created_at, from_entry_id, id, metadata, relation_definition_id, relation_type, sort_order, to_entry_id, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT SELECT, INSERT, UPDATE, DELETE service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.workspace_external_project_entry_taxonomy_assignments | Content and CMS | assignment_type, created_at, created_by, entry_id, id, sort_order, taxonomy_id, value, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.workspace_external_project_field_definitions | Content and CMS | collection_id, created_at, created_by, default_value, description, field_scope, field_type, id, is_enabled, is_required, key, label, options, sort_order, source, updated_at, updated_by, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.workspace_external_project_import_jobs | Content and CMS | adapter, canonical_external_project_id, completed_at, created_at, id, report, requested_by, source_reference, started_at, status, updated_at, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.workspace_external_project_publish_events | Content and CMS | canonical_external_project_id, created_at, entry_id, event_kind, id, payload, profile_data, triggered_by, visibility_scope, ws_id | RLS public: enable; public: authenticated INSERT; public: authenticated SELECT; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.workspace_external_project_relation_definition_targets | Content and CMS | created_at, id, relation_definition_id, target_collection_id, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT SELECT, INSERT, UPDATE, DELETE service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.workspace_external_project_relation_definitions | Content and CMS | cardinality, created_at, created_by, id, inverse_label, is_required, key, label, sort_order, source_collection_id, updated_at, updated_by, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT SELECT, INSERT, UPDATE, DELETE service_role; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.workspace_external_project_taxonomies | Content and CMS | created_at, created_by, id, label, metadata, slug, taxonomy_type, updated_at, updated_by, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT SELECT, INSERT, UPDATE, DELETE authenticated |
public.workspace_flashcards | Education | back, created_at, front, id, ws_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_guest_permissions | Identity | created_at, enable, guest_id, id, permission, resource_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT; public: GRANT UPDATE service_role; public: GRANT SELECT service_role |
public.workspace_guests | Identity | created_at, id, user_id, ws_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT; public: GRANT UPDATE service_role; public: GRANT SELECT service_role |
public.workspace_habit_tracker_entries | System and configuration | created_at, created_by, entry_date, entry_kind, id, note, occurred_at, primary_value, tags, tracker_id, updated_at, user_id, values, ws_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT; public: REVOKE INSERT, UPDATE, DELETE public, anon, authenticated |
public.workspace_habit_tracker_streak_actions | System and configuration | action_type, created_at, created_by, id, note, period_end, period_start, tracker_id, updated_at, user_id, ws_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT; public: REVOKE INSERT, UPDATE, DELETE public, anon, authenticated |
public.workspace_habit_tracker_entry_receipts | System and configuration | created_at, entry_id, idempotency_key, request_hash, tracker_id, user_id, ws_id | RLS public: enable; public: GRANT SELECT, INSERT, UPDATE service_role; public: REVOKE ALL public, anon, authenticated; Policy not indexed; first mention |
public.workspace_habit_trackers | System and configuration | aggregation_strategy, archived_at, color, composer_config, composer_mode, created_at, created_by, creation_key, description, freeze_allowance, icon, id, input_schema, is_active, name, primary_metric_key, quick_add_values, recovery_window_periods, start_date, target_operator, target_period, target_value, template_category, tracking_mode, updated_at, use_case, ws_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT; public: REVOKE INSERT, UPDATE, DELETE public, anon, authenticated |
public.workspace_habits | System and configuration | auto_schedule, calendar_hours, color, created_at, creator_id, day_of_month, day_of_week_monthly, days_of_week, deleted_at, dependency_habit_id, dependency_type, description, duration_minutes, end_date, frequency, id, ideal_instances_per_day, ideal_time, is_active, is_splittable, is_visible_in_calendar, max_duration_minutes, max_instances_per_day, min_duration_minutes, min_instances_per_day, monthly_type, name, priority, recurrence_interval, start_date, time_preference, updated_at, week_of_month, ws_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT |
public.workspace_invite_link_uses | Identity | id, invite_link_id, joined_at, user_id, ws_id | RLS public: enable; public: authenticated INSERT; public: authenticated SELECT; public: GRANT ALL service_role; public: GRANT INSERT authenticated |
public.workspace_invite_links | Identity | code, created_at, creator_id, expires_at, id, max_uses, type, updated_at, ws_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT; public: GRANT ALL service_role; public: GRANT DELETE authenticated |
public.workspace_invite_roles | Identity | created_at, role_id, user_id, ws_id | RLS public: enable; public: GRANT ALL service_role; public: REVOKE ALL PUBLIC, anon, authenticated; Policy not indexed; first mention |
public.workspace_invites | Identity | created_at, role_id, type, user_id, ws_id | RLS public: enable; public: authenticated INSERT; public: authenticated DELETE; public: authenticated UPDATE |
public.workspace_meetings | Meetings | created_at, creator_id, id, name, time, ws_id | RLS public: enable; public: authenticated INSERT; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_members | Identity | created_at, sort_key, type, user_id, ws_id | RLS public: enable; public: authenticated UPDATE; public: authenticated INSERT; public: authenticated DELETE |
public.workspace_orders | Finance and commerce | billing_reason, created_at, credit_pack_id, currency, id, polar_order_id, polar_subscription_id, product_id, product_kind, status, total_amount, updated_at, ws_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_products | Finance and commerce | archived, avatar_url, category_id, created_at, creator_id, description, finance_category_id, id, manufacturer_id, name, owner_id, usage, ws_id | RLS public: enable; public: authenticated ALL |
public.workspace_quiz_attempt_answers | Education | attempt_id, id, is_correct, quiz_id, score_awarded, selected_option_id | RLS public: enable; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role; Policy not indexed; first mention; last mention |
public.workspace_quiz_attempts | Education | attempt_number, completed_at, duration_seconds, id, set_id, started_at, submitted_at, total_score, user_id | RLS public: enable; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role; Policy not indexed; first mention; last mention |
public.workspace_quiz_sets | Education | allow_view_old_attempts, allow_view_results, attempt_limit, available_date, created_at, due_date, explanation_mode, id, instruction, name, results_released, time_limit_minutes, ws_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_quizzes | Education | answer, content, created_at, id, instruction, question, score, type, ws_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_role_members | Identity | created_at, role_id, user_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_role_permissions | Identity | created_at, enabled, permission, role_id, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_role_wallet_whitelist | Identity | created_at, custom_days, id, role_id, viewing_window, wallet_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT |
public.workspace_roles | Identity | created_at, id, name, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_secrets | System and configuration | created_at, id, name, value, ws_id | RLS public: enable; public: authenticated ALL |
public.workspace_settings | System and configuration | break_duration_minutes, break_enabled, break_interval_minutes, created_at, guest_user_checkup_threshold, missed_entry_date_threshold, referral_count_cap, referral_increment_percent, referral_promotion_id, referral_reward_type, updated_at, ws_id | RLS public: enable; public: PUBLIC ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_subscriptions | Finance and commerce | cancel_at_period_end, created_at, current_period_end, current_period_start, id, polar_subscription_id, product_id, seat_count, status, updated_at, ws_id | Policy not indexed; first mention; last mention |
public.workspace_task_labels | Tasks | color, created_at, creator_id, id, name, ws_id | RLS public: enable; public: PUBLIC DELETE; public: PUBLIC UPDATE; public: PUBLIC INSERT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_task_reminder_settings | Tasks | created_at, enabled, id, reminder_intervals, updated_at, ws_id | RLS public: enable; public: PUBLIC ALL; public: PUBLIC SELECT |
public.workspace_teams | Identity | created_at, deleted, id, name, ws_id | Policy not indexed; first mention; last mention |
public.workspace_user_fields | Contacts and workforce | created_at, default_value, description, id, name, notes, possible_values, type, ws_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_user_group_tag_groups | Contacts and workforce | created_at, group_id, tag_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_user_group_tags | Contacts and workforce | color, created_at, id, name, ws_id | RLS public: enable; public: authenticated ALL; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_user_groups | Contacts and workforce | archived, cert_template, created_at, creator_id, description, ending_date, id, is_course_published, is_guest, name, notes, starting_date, ws_id | public: authenticated SELECT |
public.workspace_user_groups_users | Contacts and workforce | created_at, group_id, role, user_id | Policy not indexed; first mention; last mention |
public.workspace_user_linked_users | Contacts and workforce | created_at, platform_user_id, virtual_user_id, ws_id | RLS public: enable; public: authenticated SELECT; public: authenticated INSERT |
public.workspace_user_profile_link_submissions | Contacts and workforce | actor_auth_uid, created_at, id, profile_link_id, submitted_fields, workspace_user_id, ws_id | RLS public: enable; public: authenticated SELECT; public: GRANT ALL service_role; public: GRANT INSERT authenticated |
public.workspace_user_profile_links | Contacts and workforce | allowed_fields, code, created_at, creator_id, expires_at, id, max_uses, mode, prefill_existing_values, requires_auth, revoked_at, target_user_id, updated_at, ws_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT; public: GRANT ALL service_role; public: GRANT DELETE authenticated |
public.workspace_user_status_changes | Contacts and workforce | actor_auth_uid, archived, archived_until, audit_record_version_id, created_at, creator_id, id, source, user_id, ws_id | RLS public: enable; public: authenticated ALL; public: authenticated SELECT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspace_users | Contacts and workforce | address, archived, archived_until, avatar_url, balance, birthday, created_at, created_by, display_name, email, ethnicity, full_name, gender, guardian, id, national_id, note, phone, referred_by, updated_at, updated_by, ws_id | RLS public: enable; public: authenticated ALL |
public.workspace_wallet_transfers | Finance and commerce | created_at, from_transaction_id, to_transaction_id | RLS public: enable; public: authenticated SELECT; public: authenticated INSERT; public: authenticated DELETE |
public.workspace_whiteboards | Content and CMS | archived_at, created_at, creator_id, description, id, snapshot, thumbnail_url, title, updated_at, ws_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT; public: GRANT UPDATE service_role; public: GRANT TRUNCATE service_role |
public.workspaces | Identity | avatar_url, created_at, creator_id, deleted, energy_profile, first_day_of_week, handle, id, logo_url, name, personal, scheduling_settings, timezone, auth_role, auth_uid, id, old_record, old_record_id, op, record, record_id, table_name, ts, ws_id, avatar_url, display_name, email, full_name, id, ws_id, avatar_url, display_name, email, full_name, id, ws_id, created_at, id, user_id, ws_id, created_at, id, user_id, ws_id, created_at, id, personal_ws_id, user_id, attendance_count, full_name, group_id, is_completed, post_id, user_id, attendance_count, email, full_name, gender, group_id, is_completed, phone, post_id, user_id, ws_id, attendance_count, email, full_name, gender, group_id, phone, user_id, ws_id, browser, click_count, device_type, domain, first_click_at, last_click_at, link_id, os, slug, unique_visitors, city, click_count, country, country_region, domain, first_click_at, last_click_at, latitude, link_id, longitude, postal_code, slug, timezone, unique_visitors, vercel_region, creator_id, domain, first_click_at, last_click_at, link_created_at, link_id, original_url, slug, top_browser, top_city, top_country, top_device_type, top_os, top_referrer_domain, top_vercel_region, total_clicks, unique_browsers, unique_cities, unique_countries, unique_device_types, unique_operating_systems, unique_referrers, unique_visitors, ws_id, display_name, is_guest, plan_id, timeblock_count, user_id, avatar_url, display_name, domain_count, email, first_link_created, id, last_link_created, link_count, creator_count, domain, first_created, last_created, link_count, activity_date, session_count, total_duration, user_id, ws_id, category_color, category_id, category_name, created_at, day_of_week, description, duration_seconds, end_time, id, is_running, productivity_score, session_date, session_length_category, session_month, session_week, start_hour, start_time, tags, task_id, task_name, title, updated_at, user_id, was_resumed, ws_id, archived, created_at, ending_date, id, name, notes, sessions, starting_date, tag_count, tags, ws_id, amount, category_id, created_at, creator_id, description, id, invoice_id, is_amount_confidential, is_category_confidential, is_description_confidential, report_opt_in, taken_at, wallet_id, cells, created_at, dataset_id, row_id, code, created_at, creator_id, current_uses, expires_at, id, is_expired, is_full, max_uses, member_type, updated_at, ws_id, id, link_count, logo_url, name, avatar_url, created_at, display_name, email, handle, id, pending, type, ws_id, amount, archived, created_at, ending_date, id, name, notes, sessions, starting_date, ws_id, amount, archived, created_at, ending_date, id, is_guest, name, notes, sessions, starting_date, ws_id, allowed_fields, code, created_at, creator_id, current_uses, expires_at, id, is_expired, is_full, is_revoked, max_uses, mode, prefill_existing_values, requires_auth, revoked_at, target_user_id, updated_at, ws_id, address, archived, archived_until, avatar_url, balance, birthday, created_at, created_by, display_name, email, ethnicity, full_name, gender, group_count, groups, guardian, id, linked_users, national_id, note, phone, updated_at, updated_by, ws_id | RLS public: enable; public: authenticated DELETE; public: authenticated UPDATE; public: authenticated INSERT |
