schema.js

module.exports = Schema;

function Schema (options, columns)
{
    this.columns = [];
    this.methods = [];
    this.table = options.table;

    var column;
    if (options.pk !== false) {
        column = new Column("id", "INTEGER PRIMARY KEY");
        this.columns.push(column);
    }

    for (var key in columns) {
        var type = columns[key];
        if (typeof type === "string") {
            column = new Column(key, type.toUpperCase());
            this.columns.push(column);
            continue;
        }
        if (typeof type.type !== "string") {
            throw Error("Cannot Determine Type Of " + key + type);
        }
        if (type.type !== "relationship") {
            column = new Column(key, type.type.toUpperCase());
            continue;
        }
        if (type.manyToOne) {
            column = new Column(type.manyToOne.foreignKey, "INTEGER");
            this.columns.push(column);
            type.manyToOne.type = "manyToOne";
            type.manyToOne.method = key;
            this.methods.push(type.manyToOne);
            continue;
        }
        if (type.oneToMany || type.manyToMany) {
            var m; 
            if (type.oneToMany) {
                m = type.oneToMany;
                m.method = key;
                m.type = "oneToMany";
            } else {
                m = type.manyToMany;
                m.method = key;
                m.type = "manyToMany";
            }
            this.methods.push(m);
            continue;
        }
        throw Error("Error creating Schema");
    }
    if (options.timestamps !== false) {
        this.timestamps = true;
        column = new Column("createdAt", "INTEGER");
        this.columns.push(column);
        column = new Column("updatedAt", "INTEGER");
        this.columns.push(column);
    }
}

function Column (name, type)
{
    this.name = name;
    this.type = type;
}