The fastest easiest way to get it right.

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
comments powered by Disqus
Home |  Documentation |  Download |  Credits |  Contact |  Login
Andromeda © Copyright 2004-2013, Licensed under the GPL Version 2