User Profile

Collapse

Profile Sidebar

Collapse
Jackson77
Jackson77
Last Activity: Jul 15 '07, 09:49 AM
Joined: Jul 9 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Jackson77
    replied to Database Design Question.?
    Sorry, It came up with an error when I first posted this, and then I refreshed it.
    ..And now I can't delete this Double post.
    My apologies!
    See more | Go to post

    Leave a comment:


  • Jackson77
    replied to Database Design Question.?
    But, if I were to do this, and store all the Image paths in one table, and by having the ImageID the PK, I wouldn't be able to have two Images with the ImageID of 001, or 002, which I plan to.

    Thank you for your suggestion, but I would prefer if the Images were numbered according to the order they were placed under the order, and not just being counted upwards so that Order 010 has ImagedID of 001, 002,003,, and then Order 011 having...
    See more | Go to post

    Leave a comment:


  • Jackson77
    started a topic Database Design Question.?

    Database Design Question.?

    Hey guys,

    I'm currently in the design stage of a database, and have a question of how the keys should be set up in two of my tables.

    I have an Orders table, which is related to a Customers table, and also to an Images table.
    The orders table has OrderID (PK), CustID (FK), and ImageSetID (PK)

    The ImageSetID field joins to the Images table which contains ImageSetID (FK), ImageID (PK), and ImagePath...
    See more | Go to post
No activity results to display
Show More
Working...