catalog

type Catalog struct {
	DefaultSchema string
	Schemas       []*Schema
}

type CheckConstraint struct {
	Name       string
	Expression string
}

type Column struct {
	Name       string
	Type       string // raw SQL type name, e.g. "UUID", "VARCHAR(255)", "TIMESTAMP"
	FullType   string // full SQL type with modifiers, e.g. "character varying(255)", "uuid"
	NotNull    bool
	IsArray    bool
	ArrayDims  int
	Comment    string
	Length     *int
	IsUnsigned bool
	Default    string // raw SQL expression, e.g. "uuid_generate_v4()", "CURRENT_TIMESTAMP"
	IsPrimary  bool
}

type Enum struct {
	Name   string
	Values []string
}

type ForeignKey struct {
	Name       string
	Columns    []string
	RefTable   string
	RefSchema  string
	RefColumns []string
	OnDelete   string
	OnUpdate   string
}

type Index struct {
	Name        string
	Columns     []string
	IsUnique    bool
	Where       string // partial index predicate, raw SQL
	IfNotExists bool
}

type PrimaryKey struct {
	Name    string
	Columns []string
}

type Schema struct {
	Name       string
	Tables     []*Table
	Enums      []*Enum
	Extensions []string
}

type Table struct {
	Name        string
	Schema      string
	Columns     []*Column
	Comment     string
	PrimaryKey  *PrimaryKey
	Indexes     []*Index
	ForeignKeys []*ForeignKey
	Uniques     []*UniqueConstraint
	Checks      []*CheckConstraint
}

type UniqueConstraint struct {
	Name    string
	Columns []string
}