schema

type Column struct {
	Name            string         `json:"name"`
	Type            string         `json:"type"`
	Nullable        bool           `json:"nullable"`
	PrimaryKey      bool           `json:"pk"`
	Default         sql.NullString `json:"default"`
	Comment         string         `json:"comment"`
	ParentRelations []*Relation    `json:"-"`
	ChildRelations  []*Relation    `json:"-"`
}

type Constraint struct {
	Name             string   `json:"name"`
	Type             string   `json:"type"`
	Def              string   `json:"def"`
	Check            string   `json:"check"`
	OnDelete         string   `json:"onDelete"`
	Table            *string  `json:"table"`
	ReferenceTable   *string  `json:"reference_table" yaml:"referenceTable"`
	Columns          []string `json:"columns"`
	ReferenceColumns []string `json:"reference_columns" yaml:"referenceColumns"`
	Comment          string   `json:"comment"`
}

type Index struct {
	Name         string `json:"name"`
	IsPrimary    bool
	IsUnique     bool
	IsClustered  bool
	MethodName   string
	Def          string   `json:"def"`
	Table        *string  `json:"table"`
	Columns      []string `json:"columns"`
	Concurrently bool     `json:"concurrently,omitempty"`
	ColDef       string   `json:"coldef,omitempty"`
	With         string   `json:"with,omitempty"`
	Tablespace   string   `json:"tablespace,omitempty"`
	Where        string   `json:"where,omitempty"`
	Comment      string   `json:"comment"`
}

type PatchColumn struct {
	// contains filtered or unexported fields
}

type PatchConstraint struct {
	// contains filtered or unexported fields
}

type PatchIndex struct {
	// contains filtered or unexported fields
}

type PatchRelation struct {
	// contains filtered or unexported fields
}

type PatchSchema struct {
	CurrentSchema string
	// contains filtered or unexported fields
}

type PatchTable struct {
	// contains filtered or unexported fields
}

type PlantUML struct {
	Distance int
}

type Relation struct {
	Name          string    `json:"name"`
	Table         *Table    `json:"table"`
	Columns       []*Column `json:"columns"`
	ParentTable   *Table    `json:"parent_table" yaml:"parentTable"`
	ParentColumns []*Column `json:"parent_columns" yaml:"parentColumns"`
	OnDelete      string    `json:"onDelete"`
	Def           string    `json:"def"`
}

type Schema struct {
	Name          string      `json:"name"`
	Desc          string      `json:"desc"`
	Tables        []*Table    `json:"tables"`
	Relations     []*Relation `json:"relations"`
	CurrentSchema string      `json:"currentSchema"`
	SearchPaths   []string    `json:"searchPaths,omitempty"`
}

type Table struct {
	Name        string        `json:"name"`
	Type        string        `json:"type"`
	Comment     string        `json:"comment"`
	Columns     []*Column     `json:"columns"`
	Indexes     []*Index      `json:"indexes"`
	Constraints []*Constraint `json:"constraints"`
	Def         string        `json:"def"`
}

type YamlColumn struct {
	Type       string  `yaml:"type"`
	Nullable   bool    `yaml:"nullable,omitempty"`
	PrimaryKey bool    `yaml:"pk,omitempty"`
	Default    *string `yaml:"default,omitempty"`
}

type YamlConstraint struct {
	Type             string   `yaml:"type,omitempty"`
	Check            string   `json:"check,omitempty"`
	OnDelete         string   `json:"onDelete,omitempty"`
	ReferenceTable   string   `yaml:"referenceTable,omitempty"`
	Columns          []string `yaml:"columns,flow"`
	ReferenceColumns []string `yaml:"referenceColumns,flow,omitempty"`
}

type YamlIndex struct {
	IsPrimary    bool     `yaml:"isPrimary,omitempty"`
	IsUnique     bool     `yaml:"isUnique,omitempty"`
	IsClustered  bool     `yaml:"isClustered,omitempty"`
	Concurrently bool     `yaml:"concurrently,omitempty"`
	MethodName   string   `yaml:"method,omitempty"`
	Columns      []string `yaml:"columns,flow"`
	ColDef       string   `yaml:"coldef,omitempty"`
	With         string   `yaml:"with,omitempty"`
	Tablespace   string   `yaml:"tablespace,omitempty"`
	Where        string   `yaml:"where,omitempty"`
}

type YamlRelation struct {
	Name          string   `yaml:"name"`
	Columns       []string `yaml:"columns,flow"`
	ParentColumns []string `yaml:"parentColumns,flow"`
	OnDelete      string   `yaml:"onDelete,omitempty"`
}

type YamlSchema struct {
	Name   string                `yaml:"name"`
	Schema string                `yaml:"schema"`
	Tables map[string]*YamlTable `yaml:"tables"`
}

type YamlTable struct {
	Type        string                     `yaml:"type,omitempty"`
	Columns     map[string]*YamlColumn     `yaml:"columns"`
	Indexes     map[string]*YamlIndex      `yaml:"indexes,omitempty"`
	Constraints map[string]*YamlConstraint `yaml:"constraints,omitempty"`
	Relations   map[string]*YamlRelation   `yaml:"relations,omitempty"` // key = parent table
	Def         string                     `yaml:"def,omitempty"`
}