db

type Column struct {
	Name         string
	OrdinalPos   int
	DataType     string
	IsNullable   bool
	DefaultValue *string
	MaxLength    *int
	Precision    *int
	Scale        *int
	IsPrimary    bool
	IsUnique     bool
}

type DatabaseSchema struct {
	Name   string
	Tables []Table
}

type ForeignKey struct {
	Name       string
	TableName  string
	Columns    []string
	RefTable   string
	RefColumns []string
	OnDelete   string
	OnUpdate   string
}

type Index struct {
	Name      string
	TableName string
	Columns   []string
	IsUnique  bool
	IsPrimary bool
}

type Loader interface {
	// Load returns the full schema for all user tables in the database.
	// schemaName may be empty to use the database default.
	Load(db *sql.DB, schemaName string) (*DatabaseSchema, error)
	// LoadTable returns schema for a single named table.
	LoadTable(db *sql.DB, schemaName, tableName string) (*Table, error)
}

type Table struct {
	Schema      string
	Name        string
	Columns     []Column
	Indexes     []Index
	ForeignKeys []ForeignKey
}