schema

Documentation

Index

• type Column
• type Index
• type ManyRelationship
• type OneRelationship
• type Schema
• type Table
  • func (t *Table) AddIndex(i ...Index) *Table
  • func (t *Table) FindColumn(name string) *Column
  • func (t *Table) PrimaryKeyColumn() *Column
• type View

Types

type Column

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

type Index

type Index struct {
	Columns []string
	Unique  bool
}

type ManyRelationship

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

type OneRelationship

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

type Schema

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

type Table

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
}

func (*Table) AddIndex

func (t *Table) AddIndex(i ...Index) *Table

func (*Table) FindColumn

func (t *Table) FindColumn(name string) *Column

func (*Table) PrimaryKeyColumn

func (t *Table) PrimaryKeyColumn() *Column

type View

type View struct {
	SQL string
}