-
Anyone have a simple database schema template available?
I'm trying to create a product catalog for a website and, although I'm getting some things to work, I'm beginning to realize that perhaps I'm going the wrong way with the whole database setup.
Currently I have a vendors table (primary=vend_id), a types table (primary=types_id), and a products table which includes both vend_id and types_id as foreign keys and I have a primary called simply ID.
I also have a column called prodDesc which is a column that will hold a bunch of point-form descriptions of the items.
Firstly, what's the best schema for this thing? Am I on the right track? Secondly, how do I set up the point-form of the prodDesc column so that when I display a product the prodDesc column prints in a point-form list?
I hope I've made it clear...thanks for any help you may have
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|