tables.yml

######## IMPORTANT
#
# This file DOES NOT DEFINE A PUBLIC API for Taskcluster
#
# The columns in the Taskcluster database are considered an implementation detail
# and may change without notice even in minor versions.  Do not depend on them.
# Even within the Taskcluster codebase, all access must go though stored functions.
# The information below is only useful to developers implementing or modifying
# stored functions.
clients:
  client_id: text not null
  created: timestamp with time zone not null
  delete_on_expiration: boolean not null
  description: text not null
  disabled: boolean not null
  encrypted_access_token: jsonb not null
  expires: timestamp with time zone not null
  last_date_used: timestamp with time zone not null
  last_modified: timestamp with time zone not null
  last_rotated: timestamp with time zone not null
  scopes: jsonb not null
roles:
  role_id: text not null
  scopes: jsonb not null
  created: timestamp with time zone not null
  description: text not null
  last_modified: timestamp with time zone not null
  etag: uuid not null
github_builds:
  organization: text not null
  repository: text not null
  sha: text not null
  task_group_id: text not null
  state: text not null
  created: timestamp with time zone not null
  updated: timestamp with time zone not null
  installation_id: integer not null
  event_type: text not null
  event_id: text not null
github_integrations:
  installation_id: integer not null
  owner: text not null
github_checks:
  task_group_id: text not null
  task_id: text not null
  check_suite_id: text not null
  check_run_id: text not null
hooks:
  hook_group_id: text not null
  hook_id: text not null
  metadata: jsonb not null
  task: jsonb not null
  bindings: jsonb not null
  schedule: jsonb not null
  encrypted_trigger_token: jsonb not null
  encrypted_next_task_id: jsonb not null
  next_scheduled_date: timestamp with time zone not null
  trigger_schema: jsonb not null
hooks_last_fires:
  hook_group_id: text not null
  hook_id: text not null
  fired_by: text not null
  task_id: text not null
  task_create_time: timestamp with time zone not null
  result: text not null
  error: text not null
hooks_queues:
  hook_group_id: text not null
  hook_id: text not null
  queue_name: text not null
  bindings: jsonb not null
indexed_tasks:
  namespace: text not null
  name: text not null
  rank: integer not null
  task_id: text not null
  data: jsonb not null
  expires: timestamp with time zone not null
index_namespaces:
  parent: text not null
  name: text not null
  expires: timestamp with time zone not null
denylisted_notifications:
  notification_type: text not null
  notification_address: text not null
cache_purges:
  worker_pool_id: text not null
  cache_name: text not null
  before: timestamp with time zone not null
  expires: timestamp with time zone not null
secrets:
  name: text not null
  encrypted_secret: jsonb not null
  expires: timestamp with time zone not null
access_tokens:
  encrypted_access_token: jsonb not null
  hashed_access_token: text not null
  client_id: text not null
  redirect_uri: text not null
  identity: text not null
  identity_provider_id: text not null
  expires: timestamp with time zone not null
  client_details: jsonb not null
authorization_codes:
  code: text not null
  client_id: text not null
  redirect_uri: text not null
  identity: text not null
  identity_provider_id: text not null
  expires: timestamp with time zone not null
  client_details: jsonb not null
github_access_tokens:
  user_id: text not null
  encrypted_access_token: jsonb not null
sessions:
  hashed_session_id: text not null
  encrypted_session_id: jsonb not null
  data: jsonb not null
  expires: timestamp with time zone not null
worker_pool_errors:
  error_id: text not null
  worker_pool_id: text not null
  reported: timestamp with time zone not null
  title: text not null
  kind: text not null
  description: text not null
  extra: jsonb
worker_pools:
  worker_pool_id: text not null
  provider_id: text not null
  created: timestamp with time zone not null
  description: text not null
  email_on_error: boolean not null
  owner: text not null
  last_modified: timestamp with time zone not null
  config: jsonb not null
  provider_data: jsonb not null
  previous_provider_ids: jsonb not null
workers:
  worker_pool_id: text not null
  worker_group: text not null
  worker_id: text not null
  provider_id: text not null
  created: timestamp with time zone not null
  expires: timestamp with time zone not null
  state: text not null
  provider_data: jsonb not null
  capacity: integer not null
  last_modified: timestamp with time zone not null
  last_checked: timestamp with time zone not null
  secret: jsonb
  etag: uuid not null
tasks:
  task_id: text not null
  created: timestamp with time zone not null
  deadline: timestamp with time zone not null
  dependencies: jsonb not null
  expires: timestamp with time zone not null
  extra: jsonb not null
  metadata: jsonb not null
  payload: jsonb not null
  priority: task_priority not null
  requires: task_requires not null
  ever_resolved: boolean not null
  retries: integer not null
  retries_left: integer not null
  routes: jsonb not null
  runs: jsonb not null
  scheduler_id: text not null
  scopes: jsonb not null
  tags: jsonb not null
  taken_until: timestamp with time zone
  task_group_id: text not null
  task_queue_id: text
queue_artifacts:
  task_id: text not null
  run_id: integer not null
  name: text not null
  storage_type: text not null
  content_type: text not null
  details: jsonb not null
  expires: timestamp with time zone not null
  present: boolean not null
task_groups:
  expires: timestamp with time zone not null
  scheduler_id: text not null
  task_group_id: text not null
task_dependencies:
  dependent_task_id: text not null
  required_task_id: text not null
  expires: timestamp with time zone not null
  requires: task_requires not null
  satisfied: boolean not null
queue_workers:
  task_queue_id: text not null
  worker_group: text not null
  worker_id: text not null
  recent_tasks: jsonb not null
  quarantine_until: timestamp with time zone not null
  expires: timestamp with time zone not null
  first_claim: timestamp with time zone not null
task_queues:
  task_queue_id: text not null
  expires: timestamp with time zone not null
  last_date_active: timestamp with time zone not null
  description: text not null
  stability: text not null

# This table is used by tc-lib-azqueue to emulate the Azure Storage API's Queue functionality.
azure_queue_messages:
  message_id: uuid not null
  queue_name: text not null
  message_text: text not null
  inserted: timestamp with time zone not null
  visible: timestamp with time zone not null
  expires: timestamp with time zone not null
  pop_receipt: uuid
objects:
  name: text not null
  project_id: text not null
  backend_id: text not null
  upload_id: text
  upload_expires: timestamp with time zone
  data: jsonb not null
  expires: timestamp with time zone not null