flows

Documentation

Index

• Variables

Variables

var Flow001Properties = mig.Flow{
	{
		ID: mig.MakeID(idPrefix, 1, 1),
		Up: `
			CREATE TABLE IF NOT EXISTS properties (
				id         VARCHAR(36)  PRIMARY KEY,
				street     VARCHAR(255) NOT NULL,
				city       VARCHAR(32)  NOT NULL,
				state      VARCHAR(32)  NOT NULL,
				zip        VARCHAR(10)  NOT NULL,

				created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now()
			)
		`,
	},
}

var Flow002Tenants = mig.Flow{
	{
		ID: mig.MakeID(idPrefix, 2, 1),
		Up: `
			CREATE TABLE IF NOT EXISTS tenants (
				id          VARCHAR(36)  PRIMARY KEY,
				full_name   VARCHAR(128) NOT NULL,
				dl_num      VARCHAR(32)  NOT NULL,
				dl_state    VARCHAR(32)  NOT NULL,
				dob         date,

				created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now(),
				updated_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now()
			);`,
	},
	{
		ID: mig.MakeID(idPrefix, 2, 2),
		Up: `
			CREATE TABLE IF NOT EXISTS tenant_phones (
				row_num     SERIAL       NOT NULL PRIMARY KEY,
				tenant_id   VARCHAR(36)  NOT NULL REFERENCES tenants (id) ON DELETE CASCADE,
				phone_num   VARCHAR(32)  NOT NULL,
				note        VARCHAR(128) NOT NULL default ''
			);
			CREATE UNIQUE INDEX tenant_phone_num ON tenant_phones(tenant_id, phone_num);`,
	},
}