> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-structure/temporal-tables.md).

# Temporal Tables

{% columns %}
{% column %}
{% content-ref url="/pages/OZKi8x23nM7RJnavj2Sa" %}
[Application-Time Periods](/docs/server/reference/sql-structure/temporal-tables/application-time-periods.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Application-time period tables define a time period between two temporal columns, for application-level data versioning.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/n2uRkUIDIrYKTLWVmomH" %}
[Bitemporal Tables](/docs/server/reference/sql-structure/temporal-tables/bitemporal-tables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Bitemporal tables combine system-versioning and application-time periods, versioning data at both levels.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/P19PakxGq1l0hERecLAG" %}
[System-Versioned Tables](/docs/server/reference/sql-structure/temporal-tables/system-versioned-tables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete system-versioned tables: WITH SYSTEM VERSIONING syntax, FOR SYSTEM\_TIME AS OF/BETWEEN/ALL queries, and ROW\_START/ROW\_END columns.
{% endcolumn %}
{% endcolumns %}