Overview
Manages table definitions in your Applad project. Each table lives in its own YAML file undertables/. “tables” is the universal term regardless of whether the underlying adapter is relational (PostgreSQL, MySQL) or document-based (MongoDB). Permission rules live alongside the schema in the same file.
Commands
applad tables list
Lists all tables defined in the active project’stables/ directory, along with their field counts and whether they have permissions defined.
applad tables generate
Generates a new empty table definition file attables/<name>.yaml with placeholder fields, indexes, and permission rules. Edit the generated file to define your actual schema. Running applad db migrate will apply it.
applad tables validate
Validates all table definition files for correctness — checks field types, relation references (does the referenced table exist?), permission rule syntax, and index definitions. Does not touch the database.applad tables show
Shows the full schema and permission rules for a specific table as currently defined in the YAML file.applad tables diff
Shows the difference between a table’s YAML definition and what actually exists in the database. Useful for catching drift — cases where the database schema has diverged from what the config files describe, usually because a migration was applied manually or a file was edited without running migrations.Related Commands
- applad config validate - Validate entire config tree including tables
- Database schema guide - Learn how to define tables in YAML