id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
15471	Associate Attachments with Multiple Parents	filosofo		"There's no logical reason attachments couldn't be associated with multiple posts, and it would make a number of things easier and avoid needless duplication.

I suggest we do this by setting the attachment parent(s) in postmeta, with (possibly) multiple keys named `_parent`, like so:

{{{
+---------+---------+-------------------+------------+
| meta_id | post_id | meta_key          | meta_value |
+---------+---------+-------------------+------------+
|       1 |     123 | _parent           | 456        | 
|       2 |     123 | _parent           | 789        | 
+---------+---------+-------------------+------------+
}}}

Here, 123 is the attachment object's ID, and 456 and 789 are the IDs of its associated post objects.

Thoughts?

"	feature request	closed	normal		Media		normal	duplicate		mikeschinkel@… ciobi deryk@… dartanjan