Documentation

The SEQUENCE Automation

The SEQUENCE automation is used to produce auto-incrementing values in a column. This is most often used for things like an order_num and others.

By convention columns that use SEQUENCE are always int. The results of using other types are not defined.

column order_id:
    type_id: int
    description: Order ID
    
table orders:
    module: ordering
    description: Orders
    
    column order_id:
        auto: sequence