# Subscriptions and revisits (OS backing)

<a id="database.osabonnement"></a>

## osabonnement

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Active subscription entries — one row per user/object.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `int` | — |  |
| `object_id` | `int` | — |  |
| `actionflag` | `int` | — |  |
| `produkt` | `nvarchar` | 32 |  |
| `benutzer` | `nvarchar` | 255 |  |
| `station` | `nvarchar` | 32 |  |
| `channel` | `int` | — |  |
| `mail` | `nvarchar` | 255 |  |
| `alias` | `nvarchar` | 255 |  |
| `osobjtype` | `int` | — |  |
| `osgroupid` | `nvarchar` | 32 |  |
| `ostype` | `int` | — |  |
| `osrequest` | `image` | 2147483647 |  |
| `osuserid` | `nvarchar` | 32 |  |
| `osconfirm` | `int` | — |  |
| `osabogrp` | `nvarchar` | 32 |  |

<a id="database.osrevisit"></a>

## osrevisit

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Revisits — one row per user/object revisit entry, see [abn.AddRevisit](../abn.md#abn.AddRevisit).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `int` | — |  |
| `objekttyp` | `int` | — |  |
| `user_id` | `int` | — |  |
| `firstvisit` | `bigint` | — |  |
| `lastvisit` | `bigint` | — |  |
| `infotext` | `nvarchar` | 225 |  |
| `set_user_id` | `int` | — |  |
| `set_time` | `bigint` | — |  |
| `osinformed` | `bigint` | — |  |
| `ostype` | `int` | — |  |
| `osabotype` | `int` | — |  |
| `osuserid` | `nvarchar` | 32 |  |
| `osconfirm` | `int` | — |  |
| `osemail` | `nvarchar` | 255 |  |
| `osguid` | `nvarchar` | 32 |  |
| `oseinformed` | `bigint` | — |  |
| `osread` | `int` | — |  |