Column Types

Andromeda supports both basic and extended column types.

Basic Types

Column types are specified with the "type_id" keyword, as in this example:

# A decimal number        
column price:             
    type_id:    numb
    colprec: 14
    colscale: 2
    description: Price

# Fixed-width character
column name:
    type_id: char       
    colprec: 8
    description: Name

# Character varying    
column colorcode:
    type_id: vchar      
    colprec: 8
    description: Color Code

The basic types that Andromeda supports are:

Extended Types

Andromeda provides extended types that provide extra validation or user interface features.