Data Model with GORM and PostgreSQL

Domain Classes

class Department {
  String name
}
class Student {
  String rollNo; String name; String email
  Department department
  static belongsTo = [department: Department]
}

Constraints

rollNo unique and required; email unique with email format; department required.

Indexes

Index name and email for the search queries; foreign key on department.

Key Points

• Unique rollNo at DB plus domain level.
• belongsTo gives cascading behavior.
• Seed departments before students.