var sql = require('sql');
module.exports = sql.define({
name: "customersUsers",
columns: [
sql.column("id").serial().primaryKey(true),
sql.column("userId").integer().notNull(true).references("user","id"),
sql.column("customerId").integer().notNull(true).references("customer","id"),
sql.column("createdAt").timestamp().notNull(true).default(sql.func("now")),
sql.column("updatedAt").timestamp().notNull(true).default(sql.func("now"))
]
});
var sql = require('sql');
module.exports = sql.define({
name: "customer",
columns: [
sql.column("id").serial().primaryKey(true),
sql.column("name").varchar(255).notNull(true),
sql.column("createdAt").timestamp().notNull(true).default(sql.func("now")),
sql.column("updatedAt").timestamp().notNull(true).default(sql.func("now"))
]
});
var sql = require('sql');
module.exports = sql.define({
name: "user",
columns: [
sql.column("id").serial().primaryKey(true),
sql.column("email").varchar(255).notNull(true).unique(true),
sql.column("fullName").varchar(255),
sql.column("hash").varchar(96),
sql.column("token").varchar(16),
sql.column("expiresAt").timestamp(),
sql.column("createdAt").timestamp().notNull(true).default(sql.func("now")),
sql.column("updatedAt").timestamp().notNull(true).default(sql.func("now"))
]
});
var sql = require('sql');
module.exports = sql.define({
name: "application",
columns: [
sql.column("id").serial().primaryKey(true),
sql.column("name").varchar(24),
sql.column("slug").varchar(16),
/* production, pre-production, development */
sql.column("environment").varchar(16),
/* php-fpm, tornado, nodejs */
sql.column("platform").varchar(12),
/* Who owns files (default to slug) */
sql.column("owner").varchar(16),
/* Who runs daemon (php-fpm, node, tornado), (default to slug".run") */
sql.column("runner").varchar(20),
sql.column("createdAt").timestamp().default(sql.func("now")),
sql.column("updatedAt").timestamp().default(sql.func("now"))
]
});