schema

type Column struct {
	Name       string
	Type       string
	NotNull    bool
	Default    *string
	PrimaryKey int // 0 = not PK, 1+ = PK position
	Hidden     int // 0 = normal, 2 = virtual/generated, 3 = stored
}

type Database struct {
	Tables   map[string]*Table
	Indexes  map[string]*Index
	Views    map[string]*View
	Triggers map[string]*Trigger
}

type Index struct {
	Name  string
	Table string
	SQL   string
}

type Table struct {
	Name    string
	Columns []Column
	SQL     string // Original CREATE TABLE statement
	// UniqueColumns lists columns that participate in a UNIQUE table
	// constraint. SQLite does not expose this through PRAGMA table_info.
	UniqueColumns []string
	// ForeignKeyColumns lists columns that are the referencing side of a
	// foreign key (column-level or table-level).
	ForeignKeyColumns []string
}

type Trigger struct {
	Name  string
	Table string
	SQL   string
}

type View struct {
	Name string
	SQL  string
}