WASSUB

Tables (30)

agent_metrics

  • id — bigint — Primary key — NOT NULL
  • agent_version — character varying(20)
  • collected_at — timestamp(6) with time zone — NOT NULL
  • cpu_percent — double precision
  • disk_used_percent — double precision
  • health_latency_ms — integer
  • health_status_code — integer
  • load1 — double precision
  • load15 — double precision
  • load5 — double precision
  • logical_cpu_count — integer
  • memory_used_percent — double precision
  • network_rx_bytes_total — bigint
  • network_tx_bytes_total — bigint
  • sample_id — character varying(36)
  • uptime_seconds — bigint
  • workspace_id — bigint — NOT NULL

ai_review_jobs

  • id — bigint — Primary key — NOT NULL
  • completed_at — timestamp(6) with time zone
  • created_at — timestamp(6) with time zone — NOT NULL
  • error_code — text
  • gitlab_note_id — bigint
  • job_id — character varying(255) — NOT NULL
  • job_type — character varying(255) — NOT NULL
  • result_received_at — timestamp(6) with time zone
  • review_result — jsonb
  • skip_reason — text
  • status — character varying(255) — NOT NULL
  • submitted_at — timestamp(6) with time zone
  • target — jsonb — NOT NULL
  • updated_at — timestamp(6) with time zone — NOT NULL
  • workspace_id — bigint — NOT NULL

external_oauth_tokens

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • provider_id — VARCHAR(255)
  • encrypted_access_token — TEXT — NOT NULL
  • encrypted_refresh_token — TEXT — NOT NULL
  • token_type — VARCHAR(50)
  • scope — VARCHAR(255)
  • expires_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

jenkins_build_statuses

  • id — BIGSERIAL — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • job_full_name — VARCHAR(255) — NOT NULL
  • build_number — INT
  • build_status — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

jenkins_connections

  • id — BIGSERIAL — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • jenkins_url — VARCHAR(255)
  • jenkins_username — VARCHAR(255)
  • encrypted_api_key — TEXT
  • webhook_secret — TEXT
  • jenkins_credential_id — VARCHAR(255)
  • connection_status — VARCHAR(50)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

jenkins_job_injections

  • id — BIGSERIAL — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • job_full_name — VARCHAR(255)
  • item_type — VARCHAR(50)
  • injected_at — TIMESTAMP

jira_connection_details

  • id — BIGSERIAL — Primary key — NOT NULL
  • owner_id — BIGINT — Foreign key → users.id — NOT NULL
  • cloud_id — VARCHAR(128)
  • site_url — VARCHAR(512)
  • webhook_id — VARCHAR(64)
  • webhook_expires_at — TIMESTAMP
  • webhook_status — VARCHAR(32)
  • webhook_token — VARCHAR(64)

jira_issue_events

  • id — BIGSERIAL — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • project_key — VARCHAR(255)
  • issue_key — VARCHAR(255)
  • issue_summary — VARCHAR(255)
  • event_type — VARCHAR(64) — NOT NULL
  • actor_name — VARCHAR(255)
  • change_field — VARCHAR(255)
  • from_value — VARCHAR(255)
  • to_value — VARCHAR(255)
  • occurred_at — TIMESTAMP — NOT NULL

jira_workspace_connections

  • id — bigint — Primary key — NOT NULL
  • access_token_expires_at — timestamp(6) with time zone
  • cloud_id — character varying(128)
  • created_at — timestamp(6) with time zone — NOT NULL
  • encrypted_access_token — text
  • encrypted_refresh_token — text
  • site_url — character varying(512)
  • webhook_expires_at — timestamp(6) with time zone
  • webhook_id — character varying(64)
  • webhook_status — character varying(32)
  • webhook_token — character varying(64)
  • workspace_id — bigint — NOT NULL

mattermost_pairing_codes

  • id — bigint — Primary key — NOT NULL
  • code_hash — character varying(255) — NOT NULL
  • user_id — bigint — NOT NULL

mattermost_team_channels

  • id — bigint — Primary key — NOT NULL
  • channel_name — character varying(255) — NOT NULL
  • class_number — integer
  • incoming_webhook_id_encrypted — text
  • outgoing_webhook_token_hash — character varying(255) — NOT NULL
  • slash_command_token_hash — character varying(255)
  • team_id — character varying(255) — NOT NULL

notice_analyses

  • id — BIGSERIAL — Primary key — NOT NULL
  • channel_id — VARCHAR(255) — NOT NULL
  • channel_name — VARCHAR(255)
  • raw_text — TEXT
  • status — VARCHAR(50) — NOT NULL
  • summary — TEXT
  • keywords — TEXT
  • action_required — BOOLEAN
  • deadline — DATE
  • created_at — TIMESTAMP — NOT NULL
  • analyzed_at — TIMESTAMP

notion_connection

  • id — BIGSERIAL — Primary key — NOT NULL
  • service_workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • workspace_id — VARCHAR(255) — NOT NULL
  • workspace_name — VARCHAR(255)
  • workspace_icon — VARCHAR(255)
  • bot_id — VARCHAR(255)
  • notion_owner_id — VARCHAR(255)
  • token_type — VARCHAR(50) — NOT NULL
  • access_token_ciphertext — VARCHAR(2048) — NOT NULL
  • refresh_token_ciphertext — VARCHAR(2048)
  • duplicated_template_id — VARCHAR(255)
  • status — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

notion_database_mappings

  • id — BIGSERIAL — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • purpose — VARCHAR(50)
  • status — VARCHAR(50)
  • parent_page_id — VARCHAR(255)
  • title — VARCHAR(255)
  • database_id — VARCHAR(255)
  • data_source_id — VARCHAR(255)
  • url — VARCHAR(255)
  • failure_code — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

notion_document_creations

  • id — BIGSERIAL — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • requested_by_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • purpose — VARCHAR(50)
  • database_mapping_id — BIGINT — Foreign key → notion_database_mappings.id
  • template_setting_id — BIGINT — Foreign key → notion_template_settings.id
  • idempotency_key — VARCHAR(128)
  • title — VARCHAR(255)
  • status — VARCHAR(50)
  • notion_page_id — VARCHAR(255)
  • url — VARCHAR(255)
  • failure_code — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

notion_important_pages

  • id — bigint — Primary key — NOT NULL
  • icon — character varying(2048)
  • last_edited_time — character varying(64) — NOT NULL
  • page_id — character varying(255) — NOT NULL
  • title — character varying(2000) — NOT NULL
  • url — character varying(2048) — NOT NULL
  • workspace_id — bigint — NOT NULL

notion_page_favorites

  • id — bigint — Primary key — NOT NULL
  • icon — character varying(2048)
  • last_edited_time — character varying(64) — NOT NULL
  • page_id — character varying(255) — NOT NULL
  • title — character varying(2000) — NOT NULL
  • url — character varying(2048) — NOT NULL
  • user_id — bigint — NOT NULL
  • workspace_id — bigint — NOT NULL

notion_page_preferences

  • id — BIGSERIAL — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • page_id — VARCHAR(255)
  • title — VARCHAR(255)
  • url — VARCHAR(255)
  • icon — VARCHAR(255)
  • last_edited_time — VARCHAR(255)
  • favorite — BOOLEAN
  • important — BOOLEAN

notion_template_settings

  • id — BIGSERIAL — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • purpose — VARCHAR(50)
  • database_mapping_id — BIGINT
  • title — VARCHAR(255)
  • markdown — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

poll_options

  • id — bigint — Primary key — NOT NULL
  • content — character varying(100) — NOT NULL
  • poll_id — bigint — NOT NULL
  • sort_order — integer — NOT NULL

poll_votes

  • id — bigint — Primary key — NOT NULL
  • option_id — bigint — NOT NULL
  • poll_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL

user_tool_accounts

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • instance_id — VARCHAR(120) — NOT NULL
  • provider_user_id — VARCHAR(100) — NOT NULL
  • username — VARCHAR(255)
  • display_name — VARCHAR(255)
  • email — VARCHAR(255)
  • avatar_url — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

users

  • id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(50)
  • email — VARCHAR(255)
  • role — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

workspace_links

  • id — BIGSERIAL — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • label — VARCHAR(100) — NOT NULL
  • url — VARCHAR(2048) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

workspace_member_candidates

  • id — BIGSERIAL — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • instance_id — VARCHAR(120) — NOT NULL
  • provider_user_id — VARCHAR(100) — NOT NULL
  • username — VARCHAR(255)
  • display_name — VARCHAR(255)
  • avatar_url — TEXT
  • gitlab_access_level — INT — NOT NULL

workspace_members

  • id — BIGSERIAL — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • joined_at — TIMESTAMP — NOT NULL

workspace_polls

  • id — bigint — Primary key — NOT NULL
  • is_anonymous — boolean — NOT NULL
  • closes_at — timestamp(6) with time zone — NOT NULL
  • creator_user_id — bigint — NOT NULL
  • multi_select — boolean — NOT NULL
  • title — character varying(200) — NOT NULL
  • workspace_id — bigint — NOT NULL

workspace_todos

  • id — bigint — Primary key — NOT NULL
  • content — character varying(500) — NOT NULL
  • done — boolean — NOT NULL
  • due_date — date
  • sort_order — integer — NOT NULL
  • workspace_id — bigint — NOT NULL

workspace_tool_connections

  • id — BIGSERIAL — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • instance_id — VARCHAR(120) — NOT NULL
  • resource_type — VARCHAR(20) — NOT NULL
  • external_project_id — VARCHAR(255) — NOT NULL
  • namespace_id — VARCHAR(255)
  • namespace_path — VARCHAR(255)
  • project_name — VARCHAR(255)
  • access_token_id — BIGINT
  • encrypted_access_token — TEXT
  • access_token_expires_at — TIMESTAMP

workspaces

  • id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • ended_at — TIMESTAMP