pgxgen

type Column struct {
	Position int
	Nullable bool
	Name     string
	DataType string
	IsPK     bool
}

type Enum struct {
	Name   string
	Values []*EnumValue
}

type EnumValue struct {
	Value string
}

type Filter struct {
	Column Column
	Op     string
}

type PGData struct {
	Enums  map[string]*Enum
	Tables map[string]*Table
}

type Query struct {
	Name       string
	Table      Table
	Filter     []Filter
	Sort       []Sort
	ReturnOne  bool
	ReturnMany bool
	Paged      bool
}

type QueryDefinition struct {
	Name   string
	Table  string
	Fields []string
	Sort   []string
	Return string
}

type QueryDefinitions struct {
	Query []QueryDefinition
}

type Sort struct {
	Column Column
	Desc   bool
}

type Table struct {
	Catalog     string
	Schema      string
	Name        string
	Columns     []*Column
	PrimaryKeys []*Column
	Indexes     map[string][]*Column
}