package schema

// AlertSchema represents the SQL schema of the Alerts table.
type AlertSchema struct {
	ID int `sql:"id INT PRIMARY KEY DEFAULT unique_rowid()"`

	// An alerts.Alert serialized as JSON.
	// TODO(jcgregorio) Update this to JSONB.
	Alert string `sql:"alert TEXT"`

	// The Alert.State which is an alerts.ConfigState value, which is converted
	// into an int.
	//
	// TODO(jcgregorio) Rationalize to either be an int or a string in both SQL
	// and in the code.
	ConfigState int `sql:"config_state INT DEFAULT 0"`

	// Stored as a Unit timestamp.
	LastModified int `sql:"last_modified INT"`

	// Name of the subscription this alert responds to.
	SubscriptionName string `sql:"sub_name STRING"`

	// Revision of the associated subscription. Used to query the Subscriptions table.
	SubscriptionRevision string `sql:"sub_revision STRING"`
}