Right way to implement a n-to-m related
- by ThreeFingerMark
Hello,
this is a part from my database structure:
Table: Item
Columns: ItemID, Title, Content, Price
Table: Tag
Columns: TagID, Title
Table: ItemTag
Columns: ItemID, TagID
Table: Image
Columns: ImageID, Path, Size, UploadDate
Table: ItemImage
Columns: ItemID, ImageID
The items can have more than one image so i have a extra table "Image" and map this images to an items. I see now a problem with this structure. Before i can add Images i must enter an item.
My question is now. Is this structure a good way to solve my problem with many images / tags for one item?
Thank you