model

type Column struct {
	Name string
	// Position is the column's 1-based ordinal in the table's column list, and
	// is CONTIGUOUS on every engine. PostgreSQL's catalog attnum is not: it
	// leaves gaps behind a dropped column, which the structure page rendered
	// raw as 1, 2, 4, 5. The dialect renumbers.
	Position        int
	DataType        string // full engine type, e.g. "varchar(255)", "int unsigned", "numeric(10,2)"
	BaseType        string // bare type name, e.g. "varchar", "int", "numeric" (lower-cased)
	Nullable        bool
	Default         *string // nil = no default; *"" = empty string default
	DefaultIsExpr   bool    // Default is an expression/SQL fragment, not a bare literal value
	DefaultIsNull   bool    // Default is the explicit keyword NULL (DEFAULT NULL), never the literal string 'NULL'
	IsPrimaryKey    bool
	IsAutoIncrement bool
	IsGenerated     bool
	GeneratedKind   string // "stored" or "virtual" for generated columns; "" otherwise
	GeneratedExpr   string // generation expression (no surrounding parens) for a generated column; "" if not generated or unknown
	// Identity is a native identity column's mode: IdentityAlways,
	// IdentityByDefault, or "" for an ordinary column. It is a typed field
	// rather than a magic value inside Extra because ENGINE-NEUTRAL code
	// branches on it: a SQL dump must emit OVERRIDING SYSTEM VALUE for an
	// always-identity column, and the column editor must not emit
	// DROP/SET DEFAULT on any identity column.
	Identity string
	// OnUpdate is the column's automatic-update expression, already normalized
	// by the dialect (MySQL "CURRENT_TIMESTAMP" / "CURRENT_TIMESTAMP(3)"); ""
	// when there is none. Typed for the same reason as Identity: the column
	// editor has to preserve it, and it must not do so by running a
	// MySQL-shaped regex over every engine's Extra.
	OnUpdate string
	// Extra is engine free-text shown verbatim in the structure page's Extra
	// cell ("auto_increment", "on update CURRENT_TIMESTAMP", …). Nothing may
	// branch on its contents — that is what the typed fields above are for.
	Extra     string
	Comment   string
	Collation string
	// CollationSchema is the collation's namespace (PostgreSQL) when Collation is
	// a non-default collation the column DDL must emit as COLLATE; "" otherwise.
	CollationSchema string
	Charset         string
}

type Database struct {
	Name      string
	Collation string
	// TableCount is the number of relations the database structure page lists
	// — tables and views, excluding the kinds that page skips (MariaDB
	// SEQUENCE objects). Defining it as "what you will see when you click
	// through" is what keeps it comparable across engines: MySQL used to count
	// sequences too, and SQLite used to omit views.
	TableCount int   // -1 when unknown / not yet counted
	Size       int64 // total size in bytes; -1 when unknown
	IsSystem   bool  // information_schema, pg_catalog, mysql, etc.
}

type Event struct {
	Name       string
	Type       string // ONE TIME / RECURRING
	Status     string
	ExecuteAt  string
	Interval   string
	Definition string
}

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

	// Synthetic marks a Name the dialect INVENTED because the engine does not
	// name the constraint (SQLite's PRAGMA foreign_key_list has no name column,
	// so the key is identified only by its ordinal). Such a name exists nowhere
	// in the schema: no statement can reference it, and presenting it like a
	// real constraint name misleads. The UI labels it; nothing may emit it into
	// SQL.
	Synthetic bool
}

type Index struct {
	Name      string
	Columns   []IndexColumn
	Unique    bool
	Primary   bool
	Type      string // BTREE, HASH, GIN, … (engine-dependent)
	Predicate string // partial-index WHERE expression; "" for a full index
}

type IndexColumn struct {
	Name       string
	Expr       string // expression index body (when not a plain column)
	Descending bool   // sorted DESC (default is ASC)
	// Prefix is the number of leading characters indexed, for engines with
	// prefix indexes (MySQL's col(10)). Zero means the whole value, which is
	// every key part on every other engine.
	Prefix int
}

type Privilege struct {
	User      string
	Host      string
	Object    string // database/table name when scoped
	Privilege string
	Grantable bool
	// Column names the single column this grant is restricted to, and is empty
	// for an object-wide grant. It is part of the grant's IDENTITY, not a
	// display detail: SELECT on one column and SELECT on the whole table are
	// two different grants that can coexist, and a revoke that dropped the
	// column would remove the wrong one (widening, not narrowing, the account's
	// reach).
	Column string
	// StoredObject is the object pattern exactly as the grant tables store it
	// (MySQL database scope only; empty elsewhere). MySQL matches REVOKE
	// targets by the exact stored pattern string — raw for externally-created
	// grants, LIKE-escaped for TableX's own — so the revoke path must reuse
	// this verbatim instead of re-escaping the database name.
	StoredObject string
}

type RoleMembership struct {
	Role       string
	RoleHost   string
	Member     string
	MemberHost string
	// AdminOption: the member may grant this role onward.
	AdminOption bool
}

type Routine struct {
	Name       string
	Type       string // "PROCEDURE" or "FUNCTION"
	ReturnType string
	Definition string
	Language   string
	Comment    string

	// ArgSignature is the engine's identity argument list ("a integer, b text"),
	// populated only by engines that allow overloading and therefore cannot
	// identify a routine by name alone — PostgreSQL, where DROP FUNCTION f fails
	// with "is not unique" whenever more than one f exists. Empty elsewhere
	// (MySQL routine names are unique within a database), and empty for a
	// zero-argument routine, which is why it renders as an empty pair of
	// parentheses rather than being omitted.
	ArgSignature string
}

type Schema struct {
	Name     string
	Owner    string
	IsSystem bool
}

type Table struct {
	Name      string
	Schema    string
	Type      TableType
	Engine    string // MySQL storage engine (InnoDB, MyISAM, …); empty otherwise
	Rows      int64  // estimated row count; -1 when unknown
	DataSize  int64  // data bytes; -1 when unknown
	IndexSize int64  // index bytes; -1 when unknown
	Size      int64  // total bytes (data+index); -1 when unknown
	Collation string
	Comment   string
	Created   *time.Time
	Updated   *time.Time
}

type TableType string

type Trigger struct {
	Name       string
	Table      string
	Timing     string // BEFORE / AFTER / INSTEAD OF
	Event      string // INSERT / UPDATE / DELETE
	Definition string
}

type User struct {
	Name       string
	Host       string // MySQL user host part; empty for role-based engines
	CanLogin   bool
	IsSuper    bool
	Attributes string // e.g. "Superuser, Create DB" (PostgreSQL); free text
}

type Variable struct {
	Name  string
	Value string
}

type View struct {
	Name       string
	Definition string
}