schemalock

type Column struct {
	// DatabaseType is used while parsing SQL but is intentionally omitted from
	// the lock. The lock records the portable type contract, while sqldef owns
	// database-specific details such as varchar lengths and storage aliases.
	DatabaseType string `json:"-"`
	Type         string `json:"type"`
	Nullable     bool   `json:"nullable"`
	PrimaryKey   bool   `json:"primaryKey,omitempty"`
	HasDefault   bool   `json:"hasDefault,omitempty"`
	Generated    bool   `json:"generated,omitempty"`
}

type ForeignKey struct {
	Column           string `json:"column"`
	ReferencedTable  string `json:"referencedTable"`
	ReferencedColumn string `json:"referencedColumn"`
}

type Lock struct {
	FormatVersion int              `json:"formatVersion"`
	Adapter       string           `json:"adapter"`
	Tables        map[string]Table `json:"tables"`
}

type Table struct {
	Columns           map[string]Column           `json:"columns"`
	ForeignKeys       map[string]ForeignKey       `json:"foreignKeys,omitempty"`
	UniqueConstraints map[string]UniqueConstraint `json:"uniqueConstraints,omitempty"`
}

type UniqueConstraint struct {
	Columns []string `json:"columns"`
	Primary bool     `json:"primary,omitempty"`
}