schema

type Column struct {
	Name        string
	Previously  string
	Type        string
	Length      int
	IncludeName string
}

type Index struct {
	Columns []string
	Unique  bool
}

type ManyRelationship struct {
	Parent      *Table
	Child       *Table
	ChildColumn *Column
	Alias       string
}

type OneRelationship struct {
	Parent      *Table
	Child       *Table
	ChildColumn *Column
	Alias       string
}

type Schema struct {
	Tables map[string]*Table
	Views  []View
	DBMS   string
}

type Table struct {
	Name    string
	Columns []Column
	Index   []Index

	// One table record has other records in another table relating to it
	HasMany []ManyRelationship
	ChildOf []ManyRelationship

	// One table record may have a single related table record
	HasOne    []OneRelationship
	BelongsTo []OneRelationship
}

type View struct {
	SQL string
}