The Smallest Possible Andromeda Specification

The smallest possible Andromeda Specification must contain:

• At least one module

• At least one table with at least one primary key column and one uisearch column

• At least one security assignment to one table (otherwise nobody can do anything!)

There are predefined columns you can use, so that it is possible to have a database that has no unique columns of its own, it uses entirely predefined columns. Predefined columns will be explained in more detail later.

# all tables are placed into modules, so every Andromeda
# database spec must have at least one module
module example:
    description: Examples

# What's a database without a table?
table  contacts:
    module: example
    description: Super Simple Contacts
    
    # a predefined column
    column first_name: 
        primary_key: “Y”    
        uisearch:   “Y” 
                        

    group $LOGIN:       
        permsel: “Y”        
        permins: “Y”         
        permupd: “Y”        
        permdel: “Y”

There is a glitch in the default Andromeda menu system that will go into an infinite loop if you have a table with the same name as a module. Tables and Modules should not have the same name.