Represents a complete database table with all its metadata.

This struct stores comprehensive information about a database table including its name, columns, primary key, foreign keys, and indices extracted from database introspection.

Access Behaviour

The Table struct implements the Access behaviour, allowing you to access columns by name using bracket notation:

table[:column_name]  # Returns the Column struct or nil
table["column_name"] # Also works with string keys

Examples

# Simple table
%Drops.SQL.Database.Table{
  name: "users",
  columns: [
    %Drops.SQL.Database.Column{name: "id", type: :integer, primary_key: true, ...},
    %Drops.SQL.Database.Column{name: "email", type: "varchar(255)", primary_key: false, ...}
  ],
  primary_key: %Drops.SQL.Database.PrimaryKey{columns: ["id"]},
  foreign_keys: [],
  indices: [
    %Drops.SQL.Database.Index{name: "idx_users_email", columns: ["email"], unique: true, ...}
  ]
}

# Accessing columns
id_column = table[:id]
email_column = table["email"]

# Table with foreign keys
%Drops.SQL.Database.Table{
  name: "posts",
  columns: [...],
  primary_key: %Drops.SQL.Database.PrimaryKey{columns: ["id"]},
  foreign_keys: [
    %Drops.SQL.Database.ForeignKey{
      columns: ["user_id"],
      referenced_table: "users",
      referenced_columns: ["id"]
    }
  ],
  indices: [...]
}