hey there,
i have a table $artists, which i want to self reference through another table $inspirations
$artists has many $inspirations.
but $inspirations are actually just different $artists.
$inspirations would have:
artist_id -> as per a standard has->many relation
but now i want to point it back to itself, eg:
inspiration_artist_id is actually pointing back to the $artists table.
any ideas how i would go about this?
thanks in advance