go-gorm-model

To generate GORM models from SQL migrations, you map database tables into Go structs using specific conventions like the `model` package, `<Entity>Model` struct naming, and `TableName()` implementation to ensure consistent database access.

For nullable fields in GORM models, use pointer types in your Go structs. For PostgreSQL JSONB columns, use the `[]byte` Go type, and for `TIMESTAMPTZ` columns, use `time.Time` to match the SQL definitions exactly.

You only need the necessary GORM tags for primary keys, indexes, unique constraints, defaults, and JSONB implied by your migrations, avoiding unnecessary column or json tags for a cleaner persistence model.

GORM model generation maps join tables and applies database defaults by adding only the specific GORM tags required by your SQL migrations, ensuring your Go structs accurately reflect complex database relationships and constraints.

GORM model files should be placed in `internal/modules/<module>/model/<entity>_model.go`, using the `model` package and following strict `<Entity>Model` struct naming conventions to maintain repository consistency.

The correct primary key type for GORM persistence models is `uint64`, ensuring consistent database access and alignment with your SQL migration table definitions across all generated Go structs.