> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# sequence table

> next_id to be used for each table

## sequence Table (0)

next\_id to be used for each table

## Fields

| Name        | Description                                                                                                              | Type        | Nullable |
| ----------- | ------------------------------------------------------------------------------------------------------------------------ | ----------- | :------: |
| id          | Sequence-id of host table                                                                                                | PK          |    No    |
| next\_id    | Next id to be used for table                                                                                             | Id          |    Yes   |
| TableName   | The name of the table this row concerns                                                                                  | String(255) |    Yes   |
| TableNumber | The table number for this table, constant over the table's lifetime (but possibly different from one database to another | Int         |    Yes   |

<img src="https://mintcdn.com/superofficeas/8-OIGQQJR0VGDXy_/media/loc/en/database/tables/sequence.png?fit=max&auto=format&n=8-OIGQQJR0VGDXy_&q=85&s=1a44343b91f44746b0c32585d3eb7c12" alt="sequence table relationship diagram" width="101" height="59" data-path="media/loc/en/database/tables/sequence.png" />

## Indexes

| Fields      | Types       | Description |
| ----------- | ----------- | ----------- |
| TableName   | String(255) | Unique      |
| TableNumber | Int         | Unique      |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [Sequence - where do IDs come from](/en/database/getting-started/table-id-sequence.md)
- [DBSetup.exe - Database maintenance](/en/onsite/install/database/dbsetup-exe.md)
- [Working with Insert](/en/api/bulk-operations/mass-operations/insert.md)
- [Upgrade](/en/onsite/automated-tasks/upgrade.md)
- [invitation table](/en/database/tables/invitation.md)
- [Protected tables](/en/api/bulk-operations/mass-operations/protected-tables.md)