marcusmoore's avatar

DB schema for marriage?

Hello,

I'm working on a quick(ish) family tree type application and I got a little lost on what the best way to lay out the db tables and their corresponding Eloquent models.

I thought of something similar below that I thought might work but I'm just not sure if that's the direction I should take.

Marriages
___
id
partner_1_id
partner_2_id
start_date
end_date

I wasn't sure how to define the Eloquent relationships in that case...

Any thoughts or input?

Thanks

EDIT:

I also considered making a pivot table but again, I'm not sure of the Eloquent relationships.

Marriages
---
id
start
end
marriage_pivot
---
id
marriage_id
person_id
0 likes
2 replies
jlrdw's avatar

Maybe code it like a pedigree program.

Please or to participate in this conversation.