MariaDB Enterprise Server InnoDB Schema Design

AUTO_INCREMENT Columns

An AUTO_INCREMENT column can function as a primary key.

Create Tables

Use the CREATE TABLE statement to create a table.

Foreign Keys

Define referential constraints between different InnoDB tables.

Indexes

Primary Keys, secondary indexes, unique indexes, full-text indexes, and spatial indexes.

Sequences

Sequences can generate integer values to function as a primary key.