Skip to content

Slack channels state

slack_channels_state

  • Schema: public
  • PK: channel_id (varchar)

Columns

Column Type Nullable Default Notes
channel_id varchar NO PK
channel_name varchar NO
workspace varchar YES 'main'
last_read_ts numeric YES 0 Slack message timestamp cursor
is_active bool YES true
created_at timestamp YES now()
updated_at timestamp YES now()

Key indexes

  • slack_channels_state_pkey — primary key on channel_id
  • Index on is_active
  • Index on workspace