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