core

type QueryMacro struct {
	Method string
	Name   string
	Query  string
}

type SQLColumn struct {
	Name       string
	As         string
	Ref        string
	Type       string
	TypeSQL    string
	Nullable   bool
	Table      string
	TableAs    string
	HasDefault bool

	Order int
}

type SQLQuery struct {
	Query  string
	Method string
	Name   string

	Select         string
	SelectOriginal string
	SelectFields   []*SQLColumn

	From    string
	Where   string
	GroupBy []string
	Having  string
}

type SQLSchema struct {
	Tables  map[string]*SQLTable
	Queries []SQLQuery
}

type SQLTable struct {
	Name    string
	Columns map[string]*SQLColumn

	Constraints []*SQLTableConstraint
	Indexes     []*SQLTableIndex
	References  []*SQLTableReference
	Referenced  []*SQLTableReference

	Order int
}

type SQLTableConstraint struct {
	Name    string
	Columns []string
	Type    string
}

type SQLTableIndex struct {
	Name    string
	Columns []string
}

type SQLTableReference struct {
	Name         string
	Columns      []string
	Table        string
	TableColumns []string
}

type TableDeps struct {
	Names []string
	As    string
}