grails - GORM 1-to-many relationship -- 3 tables created rather than 2 -
all my problem i'm creating 1-to-many relationship in gorm , expect 2 database tables created backing objects. 3 created makes sql queries overly complex. i've created close variant on 1-to-many in gorm documentation: class status { list errormessage static hasmany = [errormessage:errormessage] } and error message class: class errormessage { string message static belongsto = status } i expected create 2 database tables: create table status { id number(19,0), version number(19,0), //other fields } create table error_message { id number(19,0), version number(19,0), status_id number(19,0), message varchar(255) //other fields } but wants third table, create table status_text { status_text_id number(19,0), text_idx number(19,0), text_id number(19,0) } adding status errormessage (a hack don't want errormessage have reference status) class removes third table keeps second foreign key resulting in tex
