Search code examples
grailsgrails-ormgrails-domain-class

Foreign Key references primary key in the same table grails domain class


I have a table called person with primary key as id and in the same table I have a foreign key as master_id that references id (primry key) in the same table person. How do I create my domain class in grails for person. ?

Table Person

 Integer person_id PK auto_increment
 String name
 String address
 String city
 Integer  FK master_id references Person(person_id) 

Solution

  • Just create a field of the appropriate type with a name of master:

    class Person {
         Person master
    }