Maintain consistent naming patterns across all database objects. Ensure that: 1. Related object names are aligned (e.g., indexes should reference their table names)
Maintain consistent naming patterns across all database objects. Ensure that:
Example of good practice:
CREATE TABLE "default_llm_models" (
"id" TEXT NOT NULL,
"project_id" TEXT NOT NULL,
-- other columns...
);
-- Index name matches table name
CREATE INDEX "default_llm_models_project_id_id_key" ON "default_llm_models"("project_id", "id");
Example of consistent column formatting:
CREATE TABLE blob_storage_file_log
(
`id` String,
`project_id` String,
-- All columns use consistent backtick formatting
`event_ts` DateTime64(3),
`is_deleted` UInt8
);
Consistent naming patterns improve readability, reduce errors, and make database schemas more maintainable.
Enter the URL of a public GitHub repository