How to model a child table with multiple foreign keys?

worldbank / REaLTabFormer

A suite of auto-regressive and Seq2Seq (sequence-to-sequence) transformer models for tabular and relational synthetic data generation.

https://worldbank.github.io/REaLTabFormer/

MIT License

203 stars 23 forks source link

How to model a child table with multiple foreign keys? #29

Open echatzikyriakidis opened 1 year ago

echatzikyriakidis commented 1 year ago

Hi @avsolatorio !

I have a child table with multiple foreign keys to different parent tables.

Something like Car<-CarStatus, Car<-CarManufacturer relationships.

How can I generate the child table Car? It seems that I have to build many relational models for each relationship but then how should I merge the generated sampled data into one table?

Thanks!