schema

type Builder struct {
	Root string
}

type Column struct {
	Name          string
	GoName        string
	Type          Type
	Nullable      bool
	PrimaryKey    bool
	Unique        bool
	Identity      bool
	AutoIncrement bool
	Default       string
	Generated     string
	SoftDelete    bool
	CreatedAt     bool
	UpdatedAt     bool
	DeletedAt     bool
	CreatedBy     bool
	UpdatedBy     bool
	DeletedBy     bool
	Scope         ScopeKind
	Tags          map[string]string
}

type Constraint struct {
	Name              string
	Kind              ConstraintKind
	Columns           []string
	ReferencedTable   string
	ReferencedColumns []string
	OnDelete          string
	OnUpdate          string
	Expression        string
	Metadata          map[string]string
}

type ConstraintKind string

type Diff struct {
	Operations []Operation
}

type EnumType struct {
	Name     string
	Values   []string
	Metadata map[string]string
}

type Index struct {
	Name       string
	Columns    []string
	Unique     bool
	Expression string
	Where      string
	Method     string
	Metadata   map[string]string
}

type Inspector interface {
	Inspect(ctx context.Context, db *sql.DB, schemaName string) (*Schema, error)
}

type Operation struct {
	Kind       OperationKind
	Table      string
	TableDef   *Table
	Column     *Column
	Previous   *Column
	Index      *Index
	Constraint *Constraint
}

type OperationKind string

type PostgresInspector struct{}

type Schema struct {
	Name    string
	Version int
	Tables  []*Table
	Enums   []*EnumType
	Views   []*View
}

type ScopeKind string

type Snapshot struct {
	GeneratedAt time.Time `json:"generated_at"`
	Schema      *Schema   `json:"schema"`
}

type Table struct {
	Name        string
	GoTypeName  string
	PackageName string
	Columns     []*Column
	Indexes     []*Index
	Constraints []*Constraint
	Comments    []string
	Metadata    map[string]string
}

type Type struct {
	Name       string
	Kind       TypeKind
	Length     int
	Precision  int
	Scale      int
	Nullable   bool
	ArrayOf    *Type
	EnumValues []string
	Metadata   map[string]string
}

type TypeKind string

type View struct {
	Name         string
	SQL          string
	Materialized bool
	Metadata     map[string]string
}